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

Side by Side Diff: third_party/sqlite/src/test/exists.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 # 2011 April 9 1 # 2011 April 9
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 141 matching lines...) Expand 10 before | Expand all | Expand 10 after
152 sql1 { CREATE TABLE aux.t2(x) } 152 sql1 { CREATE TABLE aux.t2(x) }
153 sql1 { DROP INDEX IF EXISTS aux.i2 } 153 sql1 { DROP INDEX IF EXISTS aux.i2 }
154 sql2 { CREATE INDEX aux.i2 ON t2(x) } 154 sql2 { CREATE INDEX aux.i2 ON t2(x) }
155 sql1 { DROP INDEX IF EXISTS aux.i2 } 155 sql1 { DROP INDEX IF EXISTS aux.i2 }
156 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'index' } 156 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'index' }
157 } {} 157 } {}
158 do_test 3.$tn.2.2 { 158 do_test 3.$tn.2.2 {
159 sql1 { DROP INDEX IF EXISTS i2 } 159 sql1 { DROP INDEX IF EXISTS i2 }
160 sql2 { CREATE INDEX aux.i2 ON t2(x) } 160 sql2 { CREATE INDEX aux.i2 ON t2(x) }
161 sql1 { DROP INDEX IF EXISTS i2 } 161 sql1 { DROP INDEX IF EXISTS i2 }
162 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'index' } 162 sql2 { SELECT * FROM aux.sqlite_master WHERE type = 'index' }
163 } {} 163 } {}
164 164
165 # VIEW objects. 165 # VIEW objects.
166 # 166 #
167 do_test 3.$tn.3.1 { 167 do_test 3.$tn.3.1 {
168 sql1 { DROP VIEW IF EXISTS aux.v1 } 168 sql1 { DROP VIEW IF EXISTS aux.v1 }
169 sql2 { CREATE VIEW aux.v1 AS SELECT * FROM t2 } 169 sql2 { CREATE VIEW aux.v1 AS SELECT * FROM t2 }
170 sql1 { DROP VIEW IF EXISTS aux.v1 } 170 sql1 { DROP VIEW IF EXISTS aux.v1 }
171 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'view' } 171 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'view' }
172 } {} 172 } {}
(...skipping 16 matching lines...) Expand all
189 sql1 { DROP TRIGGER IF EXISTS tr1 } 189 sql1 { DROP TRIGGER IF EXISTS tr1 }
190 sql2 { CREATE TRIGGER aux.tr1 AFTER INSERT ON t2 BEGIN SELECT 1; END } 190 sql2 { CREATE TRIGGER aux.tr1 AFTER INSERT ON t2 BEGIN SELECT 1; END }
191 sql1 { DROP TRIGGER IF EXISTS tr1 } 191 sql1 { DROP TRIGGER IF EXISTS tr1 }
192 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'trigger' } 192 sql2 { SELECT name FROM aux.sqlite_master WHERE type = 'trigger' }
193 } {} 193 } {}
194 } 194 }
195 } 195 }
196 196
197 197
198 finish_test 198 finish_test
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698