OLD | NEW |
1 # 2006 November 08 | 1 # 2006 November 08 |
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 847 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
858 catchsql { | 858 catchsql { |
859 ROLLBACK; | 859 ROLLBACK; |
860 } | 860 } |
861 } {0 {}} | 861 } {0 {}} |
862 do_test capi3c-11.9.3 { | 862 do_test capi3c-11.9.3 { |
863 sqlite3_get_autocommit $DB | 863 sqlite3_get_autocommit $DB |
864 } 1 | 864 } 1 |
865 do_test capi3c-11.10 { | 865 do_test capi3c-11.10 { |
866 sqlite3_step $STMT | 866 sqlite3_step $STMT |
867 } {SQLITE_ROW} | 867 } {SQLITE_ROW} |
868 ifcapable !autoreset { | |
869 # If SQLITE_OMIT_AUTORESET is defined, then the statement must be | |
870 # reset() before it can be passed to step() again. | |
871 do_test capi3-11.11a { sqlite3_step $STMT } {SQLITE_MISUSE} | |
872 do_test capi3-11.11b { sqlite3_reset $STMT } {SQLITE_ABORT} | |
873 } | |
874 do_test capi3c-11.11 { | 868 do_test capi3c-11.11 { |
875 sqlite3_step $STMT | 869 sqlite3_step $STMT |
876 } {SQLITE_DONE} | 870 } {SQLITE_DONE} |
877 do_test capi3c-11.12 { | 871 ifcapable !autoreset { |
878 sqlite3_step $STMT | 872 do_test capi3c-11.12armor { |
879 sqlite3_step $STMT | 873 sqlite3_step $STMT |
880 } {SQLITE_ROW} | 874 sqlite3_step $STMT |
| 875 } {SQLITE_MISUSE} |
| 876 } else { |
| 877 do_test capi3c-11.12 { |
| 878 sqlite3_step $STMT |
| 879 sqlite3_step $STMT |
| 880 } {SQLITE_ROW} |
| 881 } |
881 do_test capi3c-11.13 { | 882 do_test capi3c-11.13 { |
882 sqlite3_finalize $STMT | 883 sqlite3_finalize $STMT |
883 } {SQLITE_OK} | 884 } {SQLITE_OK} |
884 do_test capi3c-11.14 { | 885 do_test capi3c-11.14 { |
885 execsql { | 886 execsql { |
886 SELECT a FROM t2; | 887 SELECT a FROM t2; |
887 } | 888 } |
888 } {1 2} | 889 } {1 2} |
889 do_test capi3c-11.14.1 { | 890 do_test capi3c-11.14.1 { |
890 sqlite3_get_autocommit $DB | 891 sqlite3_get_autocommit $DB |
(...skipping 501 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
1392 | 1393 |
1393 5 "SELECT * FROM t11 UNION ALL SELECT * FROM t12 ORDER BY 1" | 1394 5 "SELECT * FROM t11 UNION ALL SELECT * FROM t12 ORDER BY 1" |
1394 6 "SELECT * FROM t11 UNION SELECT * FROM t12 ORDER BY 1" | 1395 6 "SELECT * FROM t11 UNION SELECT * FROM t12 ORDER BY 1" |
1395 7 "SELECT * FROM t11 EXCEPT SELECT * FROM t12 ORDER BY 1" | 1396 7 "SELECT * FROM t11 EXCEPT SELECT * FROM t12 ORDER BY 1" |
1396 8 "SELECT * FROM t11 INTERSECT SELECT * FROM t12 ORDER BY 1" | 1397 8 "SELECT * FROM t11 INTERSECT SELECT * FROM t12 ORDER BY 1" |
1397 } { | 1398 } { |
1398 do_test 25.$tn { decltype $sql } {VARCHAR(10) INTEGER} | 1399 do_test 25.$tn { decltype $sql } {VARCHAR(10) INTEGER} |
1399 } | 1400 } |
1400 | 1401 |
1401 finish_test | 1402 finish_test |
OLD | NEW |