Historically, the following four table have been interpreted the same was, as
a two column table with an INTEGER PRIMARY KEY in the first column:
<blockquote><verbatim>
CREATE TABLE t1(x integer NOT NULL, y test, PRIMARY KEY(x));
CREATE TABLE t2("x" integer NOT NULL, "y" test, PRIMARY KEY("x"));
CREATE TABLE t3([x] integer NOT NULL, [y] test, PRIMARY KEY([x]));
CREATE TABLE t4('x' integer NOT NULL, 'y' test, PRIMARY KEY('x'));
</verbatim></blockquote>
However, in 3.9.0 and 3.9.1, the t4 table above is interpreted as a two column
table with a separate PRIMARY KEY index on the first column. Hence, if the
database schema above is created with version 3.8.11.1 or earlier, then
PRAGMA integrity_check will show an error with version 3.9.0 and later.
Version 3.9.0 and later should interpret all four tables above the same way.

This page was generated in about
0.017s by
Fossil 2.5 [1481ae1f9e] 2017-12-14 00:25:40