| 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 |