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

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

Issue 901033002: Import SQLite 3.8.7.4. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Chromium changes to support SQLite 3.8.7.4. 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
OLDNEW
1 # 2009 April 14 1 # 2009 April 14
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 31 matching lines...) Expand 10 before | Expand all | Expand 10 after
42 do_test vtabD-1.4 { 42 do_test vtabD-1.4 {
43 execsql { SELECT * FROM tv1 WHERE a = 1 OR b = 1 } 43 execsql { SELECT * FROM tv1 WHERE a = 1 OR b = 1 }
44 } {1 1} 44 } {1 1}
45 do_test vtabD-1.5 { 45 do_test vtabD-1.5 {
46 execsql { SELECT * FROM tv1 WHERE (a > 0 AND a < 5) OR (b > 15 AND b < 65) } 46 execsql { SELECT * FROM tv1 WHERE (a > 0 AND a < 5) OR (b > 15 AND b < 65) }
47 } {1 1 2 4 3 9 4 16 5 25 6 36 7 49 8 64} 47 } {1 1 2 4 3 9 4 16 5 25 6 36 7 49 8 64}
48 48
49 do_test vtabD-1.6 { 49 do_test vtabD-1.6 {
50 execsql { SELECT * FROM tv1 WHERE a < 500 OR b = 810000 } 50 execsql { SELECT * FROM tv1 WHERE a < 500 OR b = 810000 }
51 } [execsql { 51 } [execsql {
52 SELECT * FROM t1 WHERE a < 500 52 SELECT * FROM t1 WHERE a < 500;
53 UNION ALL 53 SELECT * FROM t1 WHERE b = 810000 AND NOT (a < 500);
54 SELECT * FROM t1 WHERE b = 810000 AND NOT (a < 500)
55 }] 54 }]
56 55
57 do_test vtabD-1.7 { 56 do_test vtabD-1.7 {
58 execsql { SELECT * FROM tv1 WHERE a < 90000 OR b = 8100000000 } 57 execsql { SELECT * FROM tv1 WHERE a < 90000 OR b = 8100000000 }
59 } [execsql { 58 } [execsql {
60 SELECT * FROM t1 WHERE a < 90000 59 SELECT * FROM t1 WHERE a < 90000;
61 UNION ALL 60 SELECT * FROM t1 WHERE b = 8100000000 AND NOT (a < 90000);
62 SELECT * FROM t1 WHERE b = 8100000000 AND NOT (a < 90000)
63 }] 61 }]
64 62
65 if {[working_64bit_int]} { 63 if {[working_64bit_int]} {
66 do_test vtabD-1.8 { 64 do_test vtabD-1.8 {
67 execsql { SELECT * FROM tv1 WHERE a = 90001 OR b = 810000 } 65 execsql { SELECT * FROM tv1 WHERE a = 90001 OR b = 810000 }
68 } {90001 8100180001 900 810000} 66 } {90001 8100180001 900 810000}
69 } 67 }
70 68
71 finish_test 69 finish_test
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698