OLD | NEW |
1 # 2001 September 15 | 1 # 2001 September 15 |
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 524 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
535 } {123.45 123.45} | 535 } {123.45 123.45} |
536 do_test select1-6.9.6 { | 536 do_test select1-6.9.6 { |
537 execsql2 { | 537 execsql2 { |
538 SELECT * FROM test1 a, test1 b LIMIT 1 | 538 SELECT * FROM test1 a, test1 b LIMIT 1 |
539 } | 539 } |
540 } {a.f1 11 a.f2 22 b.f1 11 b.f2 22} | 540 } {a.f1 11 a.f2 22 b.f1 11 b.f2 22} |
541 do_test select1-6.9.7 { | 541 do_test select1-6.9.7 { |
542 set x [execsql2 { | 542 set x [execsql2 { |
543 SELECT * FROM test1 a, (select 5, 6) LIMIT 1 | 543 SELECT * FROM test1 a, (select 5, 6) LIMIT 1 |
544 }] | 544 }] |
545 regsub -all {subquery_[0-9a-fA-F]+_} $x {subquery} x | 545 regsub -all {sq_[0-9a-fA-F_]+} $x {subquery} x |
546 set x | 546 set x |
547 } {a.f1 11 a.f2 22 sqlite_subquery.5 5 sqlite_subquery.6 6} | 547 } {a.f1 11 a.f2 22 sqlite_subquery.5 5 sqlite_subquery.6 6} |
548 do_test select1-6.9.8 { | 548 do_test select1-6.9.8 { |
549 set x [execsql2 { | 549 set x [execsql2 { |
550 SELECT * FROM test1 a, (select 5 AS x, 6 AS y) AS b LIMIT 1 | 550 SELECT * FROM test1 a, (select 5 AS x, 6 AS y) AS b LIMIT 1 |
551 }] | 551 }] |
552 regsub -all {subquery_[0-9a-fA-F]+_} $x {subquery} x | 552 regsub -all {subquery_[0-9a-fA-F]+_} $x {subquery} x |
553 set x | 553 set x |
554 } {a.f1 11 a.f2 22 b.x 5 b.y 6} | 554 } {a.f1 11 a.f2 22 b.x 5 b.y 6} |
555 do_test select1-6.9.9 { | 555 do_test select1-6.9.9 { |
(...skipping 503 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
1059 } {} | 1059 } {} |
1060 do_test select1-15.2 { | 1060 do_test select1-15.2 { |
1061 sqlite3 db2 test.db | 1061 sqlite3 db2 test.db |
1062 execsql { DROP INDEX i1 } db2 | 1062 execsql { DROP INDEX i1 } db2 |
1063 db2 close | 1063 db2 close |
1064 } {} | 1064 } {} |
1065 do_test select1-15.3 { | 1065 do_test select1-15.3 { |
1066 execsql { SELECT 2 IN (SELECT a FROM t1) } | 1066 execsql { SELECT 2 IN (SELECT a FROM t1) } |
1067 } {1} | 1067 } {1} |
1068 } | 1068 } |
| 1069 |
| 1070 # Crash bug reported on the mailing list on 2012-02-23 |
| 1071 # |
| 1072 do_test select1-16.1 { |
| 1073 catchsql {SELECT 1 FROM (SELECT *)} |
| 1074 } {1 {no tables specified}} |
1069 | 1075 |
1070 finish_test | 1076 finish_test |
OLD | NEW |