| OLD | NEW |
| 1 # 2007 May 10 | 1 # 2007 May 10 |
| 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 267 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 278 OFFSET EXISTS ( | 278 OFFSET EXISTS ( |
| 279 SELECT ALL | 279 SELECT ALL |
| 280 (SELECT ALL -2147483648) NOT IN ( | 280 (SELECT ALL -2147483648) NOT IN ( |
| 281 SELECT ALL 123456789.1234567899 | 281 SELECT ALL 123456789.1234567899 |
| 282 ) IN (SELECT 2147483649) | 282 ) IN (SELECT 2147483649) |
| 283 FROM sqlite_master | 283 FROM sqlite_master |
| 284 ) NOT IN (SELECT ALL 'The') | 284 ) NOT IN (SELECT ALL 'The') |
| 285 ) | 285 ) |
| 286 )) | 286 )) |
| 287 } | 287 } |
| 288 } {0 -4294967298} | 288 } {0 {{}}} |
| 289 | 289 |
| 290 # At one point the following INSERT statement caused an assert() to fail. | 290 # At one point the following INSERT statement caused an assert() to fail. |
| 291 # | 291 # |
| 292 do_test fuzz-1.19 { | 292 do_test fuzz-1.19 { |
| 293 execsql { CREATE TABLE t1(a) } | 293 execsql { CREATE TABLE t1(a) } |
| 294 catchsql { | 294 catchsql { |
| 295 INSERT INTO t1 VALUES( | 295 INSERT INTO t1 VALUES( |
| 296 CASE WHEN NULL THEN NULL ELSE ( SELECT 0 ORDER BY 456 ) END | 296 CASE WHEN NULL THEN NULL ELSE ( SELECT 0 ORDER BY 456 ) END |
| 297 ) | 297 ) |
| 298 } | 298 } |
| (...skipping 71 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 370 integrity_check fuzz-7.5.integrity | 370 integrity_check fuzz-7.5.integrity |
| 371 | 371 |
| 372 #---------------------------------------------------------------- | 372 #---------------------------------------------------------------- |
| 373 # Many CREATE and DROP TABLE statements: | 373 # Many CREATE and DROP TABLE statements: |
| 374 # | 374 # |
| 375 set E [list table duplicate {no such col} {ambiguous column name} {use DROP}] | 375 set E [list table duplicate {no such col} {ambiguous column name} {use DROP}] |
| 376 do_fuzzy_test fuzz-8.1 -template {[CreateOrDropTableOrView]} -errorlist $E | 376 do_fuzzy_test fuzz-8.1 -template {[CreateOrDropTableOrView]} -errorlist $E |
| 377 | 377 |
| 378 close $::log | 378 close $::log |
| 379 finish_test | 379 finish_test |
| OLD | NEW |