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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 824dde7fc48dbca6d6c956c4eb79bbfa |
| User & Date: | drh 2014-07-18 17:39:48 |
Context
|
2014-07-18
| ||
| 19:06 | Improved documentation for checkpoints and the busy handler. No changes to code. check-in: ca92c024 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: 824dde7f user: drh tags: trunk | |
| 14:43 | Improvements to the ".fullschema" command in the command-line shell. check-in: fa80c64c 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 {
|