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 |