(text/x-fossil-wiki)
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.
|