OLD | NEW |
1 # 2013 February 26 | 1 # 2013 February 26 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
11 # | 11 # |
12 # This file implements regression tests for SQLite library. Specifically, | 12 # This file implements regression tests for SQLite library. Specifically, |
13 # it tests that ticket [7a31705a7e6c95d514e6f20a6900f436bbc9fed8] in the | 13 # it tests that ticket [7a31705a7e6c95d514e6f20a6900f436bbc9fed8] in the |
14 # name resolver has been fixed. | 14 # name resolver has been fixed. |
15 # | 15 # |
16 | 16 |
17 set testdir [file dirname $argv0] | 17 set testdir [file dirname $argv0] |
18 source $testdir/tester.tcl | 18 source $testdir/tester.tcl |
19 | 19 |
20 do_execsql_test tkt-7a31705a7e6-1.1 { | 20 do_execsql_test tkt-7a31705a7e6-1.1 { |
21 CREATE TABLE t1 (a INTEGER PRIMARY KEY); | 21 CREATE TABLE t1 (a INTEGER PRIMARY KEY); |
22 CREATE TABLE t2 (a INTEGER PRIMARY KEY, b INTEGER); | 22 CREATE TABLE t2 (a INTEGER PRIMARY KEY, b INTEGER); |
23 CREATE TABLE t2x (b INTEGER PRIMARY KEY); | 23 CREATE TABLE t2x (b INTEGER PRIMARY KEY); |
24 SELECT t1.a FROM ((t1 JOIN t2 ON t1.a=t2.a) AS x JOIN t2x ON x.b=t2x.b) as y; | 24 SELECT t1.a FROM ((t1 JOIN t2 ON t1.a=t2.a) AS x JOIN t2x ON x.b=t2x.b) as y; |
25 } {} | 25 } {} |
OLD | NEW |