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

Changes to test/pragma.test.

  1855   1855   sqlite3 db2 test.db
  1856   1856   do_test 23.1 {
  1857   1857     db eval {
  1858   1858       CREATE TABLE t1(a INTEGER PRIMARY KEY,b,c,d);
  1859   1859       CREATE INDEX i1 ON t1(b,c);
  1860   1860       CREATE INDEX i2 ON t1(c,d);
  1861   1861       CREATE INDEX i2x ON t1(d COLLATE nocase, c DESC);
         1862  +    CREATE INDEX i3 ON t1(d,b+c,c);
  1862   1863       CREATE TABLE t2(x INTEGER REFERENCES t1);
  1863   1864     }
  1864   1865     db2 eval {SELECT name FROM sqlite_master}
  1865         -} {t1 i1 i2 i2x t2}
         1866  +} {t1 i1 i2 i2x i3 t2}
  1866   1867   do_test 23.2a {
  1867   1868     db eval {
  1868   1869       DROP INDEX i2;
  1869   1870       CREATE INDEX i2 ON t1(c,d,b);
  1870   1871     }
  1871   1872     capture_pragma db2 out {PRAGMA index_info(i2)}
  1872   1873     db2 eval {SELECT cid, name, '|' FROM out ORDER BY seqno}
................................................................................
  1885   1886   } {2 c 0 BINARY 1 | 3 d 0 BINARY 1 | 1 b 0 BINARY 1 | -1 {} 0 BINARY 0 |}
  1886   1887   
  1887   1888   # (The first column of output from PRAGMA index_xinfo is...)
  1888   1889   # EVIDENCE-OF: R-00197-14279 The rank of the column within the index. (0
  1889   1890   # means left-most. Key columns come before auxiliary columns.)
  1890   1891   #
  1891   1892   # (The second column of output from PRAGMA index_xinfo is...)
  1892         -# EVIDENCE-OF: R-40889-06838 The rank of the column within the table
         1893  +# EVIDENCE-OF: R-06603-49335 The rank of the column within the table
  1893   1894   # being indexed, or -1 if the index-column is the rowid of the table
  1894         -# being indexed.
         1895  +# being indexed and -2 if the index is on an expression.
  1895   1896   #
  1896   1897   # (The third column of output from PRAGMA index_xinfo is...)
  1897         -# EVIDENCE-OF: R-22751-28901 The name of the column being indexed, or
  1898         -# NULL if the index-column is the rowid of the table being indexed.
         1898  +# EVIDENCE-OF: R-40641-22898 The name of the column being indexed, or
         1899  +# NULL if the index-column is the rowid of the table being indexed or an
         1900  +# expression.
  1899   1901   #
  1900   1902   # (The fourth column of output from PRAGMA index_xinfo is...)
  1901   1903   # EVIDENCE-OF: R-11847-09179 1 if the index-column is sorted in reverse
  1902   1904   # (DESC) order by the index and 0 otherwise.
  1903   1905   #
  1904   1906   # (The fifth column of output from PRAGMA index_xinfo is...)
  1905   1907   # EVIDENCE-OF: R-15313-19540 The name for the collating sequence used to
................................................................................
  1911   1913   #
  1912   1914   do_test 23.2c {
  1913   1915     db2 eval {PRAGMA index_xinfo(i2)}
  1914   1916   } {0 2 c 0 BINARY 1 1 3 d 0 BINARY 1 2 1 b 0 BINARY 1 3 -1 {} 0 BINARY 0}
  1915   1917   do_test 23.2d {
  1916   1918     db2 eval {PRAGMA index_xinfo(i2x)}
  1917   1919   } {0 3 d 0 nocase 1 1 2 c 1 BINARY 1 2 -1 {} 0 BINARY 0}
         1920  +do_test 23.2e {
         1921  +  db2 eval {PRAGMA index_xinfo(i3)}
         1922  +} {0 3 d 0 BINARY 1 1 -2 {} 0 BINARY 1 2 2 c 0 BINARY 1 3 -1 {} 0 BINARY 0}
  1918   1923   
  1919   1924   # EVIDENCE-OF: R-64103-17776 PRAGMA schema.index_list(table-name); This
  1920   1925   # pragma returns one row for each index associated with the given table.
  1921   1926   #
  1922   1927   # (The first column of output from PRAGMA index_list is...)
  1923   1928   # EVIDENCE-OF: R-02753-24748 A sequence number assigned to each index
  1924   1929   # for internal tracking purposes.
................................................................................
  1932   1937   # (The fourth column of output from PRAGMA index_list is...)
  1933   1938   # EVIDENCE-OF: R-36609-39554 "c" if the index was created by a CREATE
  1934   1939   # INDEX statement, "u" if the index was created by a UNIQUE constraint,
  1935   1940   # or "pk" if the index was created by a PRIMARY KEY constraint.
  1936   1941   #
  1937   1942   do_test 23.3 {
  1938   1943     db eval {
         1944  +    DROP INDEX IF EXISTS i3;
  1939   1945       CREATE INDEX i3 ON t1(d,b,c);
  1940   1946     }
  1941   1947     capture_pragma db2 out {PRAGMA index_list(t1)}
  1942   1948     db2 eval {SELECT seq, name, "unique", origin, '|' FROM out ORDER BY seq}
  1943   1949   } {0 i3 0 c | 1 i2 0 c | 2 i2x 0 c | 3 i1 0 c |}
  1944   1950   do_test 23.4 {
  1945   1951     db eval {