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

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

Issue 5626002: Update sqlite to 3.7.3. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src/third_party/sqlite/src
Patch Set: Remove misc change. Created 10 years 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 | Annotate | Revision Log
« no previous file with comments | « third_party/sqlite/src/test/attachmalloc.test ('k') | third_party/sqlite/src/test/auth2.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 # 2003 April 4 1 # 2003 April 4
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 1958 matching lines...) Expand 10 before | Expand all | Expand 10 after
1969 do_test auth-1.294 { 1969 do_test auth-1.294 {
1970 set ::authargs {} 1970 set ::authargs {}
1971 execsql { 1971 execsql {
1972 CREATE TABLE t4(a,b,c); 1972 CREATE TABLE t4(a,b,c);
1973 CREATE INDEX t4i1 ON t4(a); 1973 CREATE INDEX t4i1 ON t4(a);
1974 CREATE INDEX t4i2 ON t4(b,a,c); 1974 CREATE INDEX t4i2 ON t4(b,a,c);
1975 INSERT INTO t4 VALUES(1,2,3); 1975 INSERT INTO t4 VALUES(1,2,3);
1976 ANALYZE; 1976 ANALYZE;
1977 } 1977 }
1978 set ::authargs 1978 set ::authargs
1979 } {t4 {} main {}} 1979 } {t4 {} main {} t2 {} main {}}
1980 do_test auth-1.295 { 1980 do_test auth-1.295 {
1981 execsql { 1981 execsql {
1982 SELECT count(*) FROM sqlite_stat1; 1982 SELECT count(*) FROM sqlite_stat1;
1983 } 1983 }
1984 } 2 1984 } 3
1985 proc auth {code args} { 1985 proc auth {code args} {
1986 if {$code=="SQLITE_ANALYZE"} { 1986 if {$code=="SQLITE_ANALYZE"} {
1987 set ::authargs [concat $::authargs $args] 1987 set ::authargs [concat $::authargs $args]
1988 return SQLITE_DENY 1988 return SQLITE_DENY
1989 } 1989 }
1990 return SQLITE_OK 1990 return SQLITE_OK
1991 } 1991 }
1992 do_test auth-1.296 { 1992 do_test auth-1.296 {
1993 set ::authargs {} 1993 set ::authargs {}
1994 catchsql { 1994 catchsql {
1995 ANALYZE; 1995 ANALYZE;
1996 } 1996 }
1997 } {1 {not authorized}} 1997 } {1 {not authorized}}
1998 do_test auth-1.297 { 1998 do_test auth-1.297 {
1999 execsql { 1999 execsql {
2000 SELECT count(*) FROM sqlite_stat1; 2000 SELECT count(*) FROM sqlite_stat1;
2001 } 2001 }
2002 } 2 2002 } 3
2003 } ;# ifcapable analyze 2003 } ;# ifcapable analyze
2004 2004
2005 2005
2006 # Authorization for ALTER TABLE ADD COLUMN. 2006 # Authorization for ALTER TABLE ADD COLUMN.
2007 # These tests are omitted if the library 2007 # These tests are omitted if the library
2008 # was built without ALTER TABLE support. 2008 # was built without ALTER TABLE support.
2009 ifcapable {altertable} { 2009 ifcapable {altertable} {
2010 do_test auth-1.300 { 2010 do_test auth-1.300 {
2011 execsql {CREATE TABLE t5(x)} 2011 execsql {CREATE TABLE t5(x)}
2012 proc auth {code arg1 arg2 arg3 arg4} { 2012 proc auth {code arg1 arg2 arg3 arg4} {
(...skipping 228 matching lines...) Expand 10 before | Expand all | Expand 10 after
2241 } 2241 }
2242 } {115 117} 2242 } {115 117}
2243 do_test auth-4.3 { 2243 do_test auth-4.3 {
2244 set authargs {} 2244 set authargs {}
2245 execsql { 2245 execsql {
2246 UPDATE v1 SET x=1 WHERE x=117 2246 UPDATE v1 SET x=1 WHERE x=117
2247 } 2247 }
2248 set authargs 2248 set authargs
2249 } [list \ 2249 } [list \
2250 SQLITE_UPDATE v1 x main {} \ 2250 SQLITE_UPDATE v1 x main {} \
2251 SQLITE_INSERT v1chng {} main r2 \
2252 SQLITE_READ v1 x main r2 \
2253 SQLITE_READ v1 x main r2 \
2254 SQLITE_SELECT {} {} {} v1 \ 2251 SQLITE_SELECT {} {} {} v1 \
2255 SQLITE_READ t2 a main v1 \ 2252 SQLITE_READ t2 a main v1 \
2256 SQLITE_READ t2 b main v1 \ 2253 SQLITE_READ t2 b main v1 \
2257 SQLITE_SELECT {} {} {} {} \ 2254 SQLITE_SELECT {} {} {} {} \
2258 SQLITE_READ v1 x main v1 \ 2255 SQLITE_READ v1 x main v1 \
2256 SQLITE_INSERT v1chng {} main r2 \
2257 SQLITE_READ v1 x main r2 \
2258 SQLITE_READ v1 x main r2 \
2259 ] 2259 ]
2260
2260 do_test auth-4.4 { 2261 do_test auth-4.4 {
2261 execsql { 2262 execsql {
2262 CREATE TRIGGER r3 INSTEAD OF DELETE ON v1 BEGIN 2263 CREATE TRIGGER r3 INSTEAD OF DELETE ON v1 BEGIN
2263 INSERT INTO v1chng VALUES(OLD.x,NULL); 2264 INSERT INTO v1chng VALUES(OLD.x,NULL);
2264 END; 2265 END;
2265 SELECT * FROM v1; 2266 SELECT * FROM v1;
2266 } 2267 }
2267 } {115 117} 2268 } {115 117}
2268 do_test auth-4.5 { 2269 do_test auth-4.5 {
2269 set authargs {} 2270 set authargs {}
(...skipping 81 matching lines...) Expand 10 before | Expand all | Expand 10 after
2351 execsql { SELECT * FROM t5 } 2352 execsql { SELECT * FROM t5 }
2352 } {1} 2353 } {1}
2353 } 2354 }
2354 2355
2355 2356
2356 rename proc {} 2357 rename proc {}
2357 rename proc_real proc 2358 rename proc_real proc
2358 2359
2359 2360
2360 finish_test 2361 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/src/test/attachmalloc.test ('k') | third_party/sqlite/src/test/auth2.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698