Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | SQLite has long accepted some unadvertised and non-standard join syntax. Add a test to ensure that future versions continue to accept this non-standard syntax, to avoid breaking legacy applications that use the undefined syntax. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
824dde7fc48dbca6d6c956c4eb79bbfa |
User & Date: | drh 2014-07-18 17:39:48.053 |
Context
2014-07-18
| ||
19:06 | Improved documentation for checkpoints and the busy handler. No changes to code. (check-in: ca92c02406 user: drh tags: trunk) | |
17:39 | SQLite has long accepted some unadvertised and non-standard join syntax. Add a test to ensure that future versions continue to accept this non-standard syntax, to avoid breaking legacy applications that use the undefined syntax. (check-in: 824dde7fc4 user: drh tags: trunk) | |
14:43 | Improvements to the ".fullschema" command in the command-line shell. (check-in: fa80c64caa user: drh tags: trunk) | |
Changes
Changes to test/join.test.
︙ | ︙ | |||
31 32 33 34 35 36 37 38 39 40 41 42 43 44 | CREATE TABLE t2(b,c,d); INSERT INTO t2 VALUES(1,2,3); INSERT INTO t2 VALUES(2,3,4); INSERT INTO t2 VALUES(3,4,5); SELECT * FROM t2; } } {1 2 3 2 3 4 3 4 5} do_test join-1.3 { execsql2 { SELECT * FROM t1 NATURAL JOIN t2; } } {a 1 b 2 c 3 d 4 a 2 b 3 c 4 d 5} do_test join-1.3.1 { | > > > > > > > > > > > | 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | CREATE TABLE t2(b,c,d); INSERT INTO t2 VALUES(1,2,3); INSERT INTO t2 VALUES(2,3,4); INSERT INTO t2 VALUES(3,4,5); SELECT * FROM t2; } } {1 2 3 2 3 4 3 4 5} # A FROM clause of the form: "<table>, <table> ON <expr>" is not # allowed by the SQLite syntax diagram, nor by any other SQL database # engine that we are aware of. Nevertheless, historic versions of # SQLite have allowed it. We need to continue to support it moving # forward to prevent breakage of legacy applications. Though, we will # not advertise it as being supported. # do_execsql_test join-1.2.1 { SELECT t1.rowid, t2.rowid, '|' FROM t1, t2 ON t1.a=t2.b; } {1 1 | 2 2 | 3 3 |} do_test join-1.3 { execsql2 { SELECT * FROM t1 NATURAL JOIN t2; } } {a 1 b 2 c 3 d 4 a 2 b 3 c 4 d 5} do_test join-1.3.1 { |
︙ | ︙ |