| OLD | NEW |
| 1 # 2014 January 11 | 1 # 2014 January 11 |
| 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 232 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 243 SELECT (c$n == $n) FROM x | 243 SELECT (c$n == $n) FROM x |
| 244 " | 244 " |
| 245 } | 245 } |
| 246 | 246 |
| 247 do_execsql_test 4.2 [genstmt 10] 1 | 247 do_execsql_test 4.2 [genstmt 10] 1 |
| 248 do_execsql_test 4.3 [genstmt 100] 1 | 248 do_execsql_test 4.3 [genstmt 100] 1 |
| 249 do_execsql_test 4.4 [genstmt 255] 1 | 249 do_execsql_test 4.4 [genstmt 255] 1 |
| 250 set nLimit [sqlite3_limit db SQLITE_LIMIT_COLUMN -1] | 250 set nLimit [sqlite3_limit db SQLITE_LIMIT_COLUMN -1] |
| 251 do_execsql_test 4.5 [genstmt [expr $nLimit-1]] 1 | 251 do_execsql_test 4.5 [genstmt [expr $nLimit-1]] 1 |
| 252 do_execsql_test 4.6 [genstmt $nLimit] 1 | 252 do_execsql_test 4.6 [genstmt $nLimit] 1 |
| 253 do_catchsql_test 4.7 [genstmt [expr $nLimit+1]] {1 {too many columns in index}} | 253 do_catchsql_test 4.7 [genstmt [expr $nLimit+1]] \ |
| 254 {1 {too many columns in result set}} |
| 254 | 255 |
| 255 #--------------------------------------------------------------------------- | 256 #--------------------------------------------------------------------------- |
| 256 # Check that adding a WITH clause to an INSERT disables the xfer | 257 # Check that adding a WITH clause to an INSERT disables the xfer |
| 257 # optimization. | 258 # optimization. |
| 258 # | 259 # |
| 259 proc do_xfer_test {tn bXfer sql {res {}}} { | 260 proc do_xfer_test {tn bXfer sql {res {}}} { |
| 260 set ::sqlite3_xferopt_count 0 | 261 set ::sqlite3_xferopt_count 0 |
| 261 uplevel [list do_test $tn [subst -nocommands { | 262 uplevel [list do_test $tn [subst -nocommands { |
| 262 set dres [db eval {$sql}] | 263 set dres [db eval {$sql}] |
| 263 list [set ::sqlite3_xferopt_count] [set dres] | 264 list [set ::sqlite3_xferopt_count] [set dres] |
| (...skipping 144 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 408 WITH q(a) AS ( | 409 WITH q(a) AS ( |
| 409 SELECT 1 | 410 SELECT 1 |
| 410 UNION ALL | 411 UNION ALL |
| 411 SELECT a+1 FROM q, v WHERE a<5 | 412 SELECT a+1 FROM q, v WHERE a<5 |
| 412 ) | 413 ) |
| 413 SELECT * FROM q; | 414 SELECT * FROM q; |
| 414 } {1 2 3 4 5} | 415 } {1 2 3 4 5} |
| 415 | 416 |
| 416 | 417 |
| 417 finish_test | 418 finish_test |
| 418 | |
| OLD | NEW |