SQLite

All files named ”test/quote.test”
Login

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

History for test/quote.test

2024-01-22
15:26
[7b01b2a261] part of check-in [0a834bd811] Improved error message when a double-quoted string is used and it seems likely that the user wanted a single-quoted string literal. (check-in: [0a834bd811] user: drh branch: improved-dqs-error-msg, size: 5365)
2022-01-16
19:11
[ffb40f0eb7] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 5093)
2021-10-01
20:39
[f33f95990e] part of check-in [2f7c946c5f] Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: [2f7c946c5f] user: dan branch: trunk, size: 5044)
2021-03-14
20:17
[b8ddaba6b8] part of check-in [7e2d7ca15a] An additional test case (check-in: [7e2d7ca15a] user: drh branch: tkt-1c24a659-b, size: 4933)
19:55
[a626b6ada9] part of check-in [a2adae907a] An alternative approach for fixing ticket [1c24a659e6d7f3a1]. (check-in: [a2adae907a] user: drh branch: tkt-1c24a659-b, size: 4749)
01:40
[38b4e3da5d] part of check-in [7c8aa38125] Never allow a double-quoted identifier that appears by itself in the argument list of an index to be interpreted as a string literal. Proposed fix for ticket [1c24a659e6d7f3a1]. (check-in: [7c8aa38125] user: drh branch: tkt-1c24a659, size: 3939)
2020-08-27
18:36
[3f9238ab0e] part of check-in [5ce34a955b] Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints. (check-in: [5ce34a955b] user: drh branch: trunk, size: 3711)
2019-07-02
12:23
[626149eda8] part of check-in [97a94446f3] Restore the legacy behavior of enabling double-quoted string literals in all contexts. But also provide a new compile-time option (SQLITE_DQS) to change the default to something more restrictive. (check-in: [97a94446f3] user: drh branch: trunk, size: 3705)
2019-05-20
17:14
[8258838e51] part of check-in [1685610ef8] Disallow string constants enclosed in double-quotes within new CREATE TABLE and CREATE INDEX statements. It is still possible to enclose column names in double-quotes, and existing database schemas that use double-quotes for strings can still be loaded. This addresses ticket [9b78184b]. (check-in: [1685610ef8] user: dan branch: trunk, size: 3611)
2007-04-25
11:32
[215897dbe8] part of check-in [0935cdf82a] Fix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS 3869) (check-in: [0935cdf82a] user: drh branch: trunk, size: 2150)
2005-11-01
15:48
[5891f23389] part of check-in [e0d6f61c7d] Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) (check-in: [e0d6f61c7d] user: drh branch: trunk, size: 2148)
2005-08-13
18:15
[c1ca5e1880] part of check-in [6b7a4e9752] Provide grave accent quoting of identifiers for MySQL compatibility. Ticket #1337. (CVS 2591) (check-in: [6b7a4e9752] user: drh branch: trunk, size: 2150)
2004-08-20
18:34
[6d75cf635d] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 2026)
2002-05-21
13:43
[08f23385c6] part of check-in [55e7d65496] Double-quoted strings resolve to column names if possible. Single-quoted strings continue to be interpreted as string literals. (CVS 576) (check-in: [55e7d65496] user: drh branch: trunk, size: 2024)
2001-09-16
00:13
[286db94471] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 1689)
2001-07-23
14:33
Added: [40a3164af8] part of check-in [029e3a3a5d] Add ability to quote table and column names in expression. (CVS 235) (check-in: [029e3a3a5d] user: drh branch: trunk, size: 2226)