SQLite

Check-in [8de20fc72a]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Remove stray (and incomplete) comment from a test file. No changes to code.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 8de20fc72a9b55fabd2444b2d73c88c65658430d6d182da9f0e2f3432373ab51
User & Date: mistachkin 2017-07-21 20:31:31.789
Context
2017-07-24
14:44
Compiler warning fix associated with date/time functions. (check-in: a98f07d942 user: drh tags: trunk)
2017-07-21
20:31
Remove stray (and incomplete) comment from a test file. No changes to code. (check-in: 8de20fc72a user: mistachkin tags: trunk)
2017-07-20
20:49
Fix a harmless typo, but one that would show up in the documentation if not fixed. (check-in: e4b1dd3683 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/indexexpr1.test.
376
377
378
379
380
381
382
383
384
385
386
do_execsql_test indexexpr1-1300.1 {
  CREATE TABLE t1300(a INTEGER PRIMARY KEY, b);
  INSERT INTO t1300 VALUES(1,'coffee'),(2,'COFFEE'),(3,'stress'),(4,'STRESS');
  CREATE INDEX t1300bexpr ON t1300( substr(b,4) );
  SELECT a FROM t1300 WHERE substr(b,4)='ess' COLLATE nocase ORDER BY +a;
} {3 4}

# Date and time functions can participate in an index as long as they
# do not contain

finish_test







<
<
<

376
377
378
379
380
381
382



383
do_execsql_test indexexpr1-1300.1 {
  CREATE TABLE t1300(a INTEGER PRIMARY KEY, b);
  INSERT INTO t1300 VALUES(1,'coffee'),(2,'COFFEE'),(3,'stress'),(4,'STRESS');
  CREATE INDEX t1300bexpr ON t1300( substr(b,4) );
  SELECT a FROM t1300 WHERE substr(b,4)='ess' COLLATE nocase ORDER BY +a;
} {3 4}




finish_test