OLD | NEW |
1 # 2008 August 12 | 1 # 2008 August 12 |
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 #*********************************************************************** |
(...skipping 60 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
71 INSERT INTO t2 VALUES(2,22); | 71 INSERT INTO t2 VALUES(2,22); |
72 CREATE TABLE t3(x,y); | 72 CREATE TABLE t3(x,y); |
73 INSERT INTO t3 VALUES(1,'one'); | 73 INSERT INTO t3 VALUES(1,'one'); |
74 | 74 |
75 SELECT *, (SELECT z FROM (SELECT y AS z FROM t3 WHERE x=t1.a+1) ) FROM t1; | 75 SELECT *, (SELECT z FROM (SELECT y AS z FROM t3 WHERE x=t1.a+1) ) FROM t1; |
76 } | 76 } |
77 } {0 2 one} | 77 } {0 2 one} |
78 | 78 |
79 | 79 |
80 finish_test | 80 finish_test |
OLD | NEW |