Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add test case for the fix in the previous commit. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
39434262d5cf1af197ce0abb1f1ee84e |
| User & Date: | dan 2018-06-18 20:08:08 |
Context
|
2018-06-19
| ||
| 11:15 | Minor change to the input grammar to make the parser tables slightly smaller. (check-in: 320fa69e user: drh tags: trunk) | |
|
2018-06-18
| ||
| 20:08 | Add test case for the fix in the previous commit. (check-in: 39434262 user: dan tags: trunk) | |
| 19:09 | Fix typo in the 'normalize' extension. (check-in: 0c9163ea user: mistachkin tags: trunk) | |
Changes
Changes to test/normalize.test.
61 62 63 64 65 66 67 68 69 70 71 72 |
{SELECT a,NULL,b FROM t1 WHERE c IS NOT NULL or D is null or e=5}
{select a,?,b from t1 where c is not null or d is null or e=?;}
170
{/* IN list exactly 5 bytes long */
SELECT * FROM t1 WHERE x IN (1,2,3);}
{select*from t1 where x in(?,?,?);}
} {
do_test $tnum [list sqlite3_normalize $sql] $norm
}
finish_test
|
> > > |
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 |
{SELECT a,NULL,b FROM t1 WHERE c IS NOT NULL or D is null or e=5}
{select a,?,b from t1 where c is not null or d is null or e=?;}
170
{/* IN list exactly 5 bytes long */
SELECT * FROM t1 WHERE x IN (1,2,3);}
{select*from t1 where x in(?,?,?);}
180
{ }
{}
} {
do_test $tnum [list sqlite3_normalize $sql] $norm
}
finish_test
|