Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(209)

Side by Side Diff: third_party/sqlite/src/test/select1.test

Issue 949043002: Add //third_party/sqlite to dirs_to_snapshot, remove net_sql.patch (Closed) Base URL: git@github.com:domokit/mojo.git@master
Patch Set: Created 5 years, 10 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
« no previous file with comments | « third_party/sqlite/src/test/securedel2.test ('k') | third_party/sqlite/src/test/select4.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
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
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
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
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/securedel2.test ('k') | third_party/sqlite/src/test/select4.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698