Differences From Artifact [6912c4280d]:
- File test/gencol1.test — part of check-in [d2da62a9df] at 2021-07-30 23:30:30 on branch trunk — Recognize certain standard datatypes ("INT", "INTEGER", "REAL", "TEXT", and "BLOB") and if a column has one of those datatypes, store the type part of the bit-field information in the Column structure to save space. (user: drh size: 17291) [more...]
To Artifact [1b63f8c001]:
- File test/gencol1.test — part of check-in [b9417d400f] at 2021-09-07 15:41:25 on branch trunk — Fix a potential NULL pointer deference in the LIKE optimization. The problem was introduced by the addition of generated columns in check-in [b855acf1831943b3] (SQLite version 3.31.0, 2020-01-22). Reported by Wang Ke in [forum/forumpost/699b44b3ee|forum post 699b44b3ee]. (user: drh size: 17602)
| ︙ | ︙ | |||
597 598 599 600 601 602 603 604 605 |
Always
AS ('xyzzy'),
e int Always default(5)
);
INSERT INTO t1(a) VALUES(5);
SELECT name, type FROM pragma_table_xinfo('t1');
} {a INTEGER b INT c TEXT d {} e INT}
finish_test
| > > > > > > > > > > > | 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 |
Always
AS ('xyzzy'),
e int Always default(5)
);
INSERT INTO t1(a) VALUES(5);
SELECT name, type FROM pragma_table_xinfo('t1');
} {a INTEGER b INT c TEXT d {} e INT}
# 2021-09-07 forum https://sqlite.org/forum/forumpost/699b44b3ee
#
reset_db
do_execsql_test gencol1-22.1 {
CREATE TABLE t0(a PRIMARY KEY,b TEXT AS ('2') UNIQUE);
INSERT INTO t0(a) VALUES(2);
SELECT * FROM t0 AS x JOIN t0 AS y
WHERE x.b='2'
AND (y.a=2 OR (x.b LIKE '2*' AND y.a=x.b));
} {2 2 2 2}
finish_test
|