@@ -614,7 +614,7 @@ do_test non-standard-kdf-and-ciphers {
614
614
SELECT count(*) FROM t1;
615
615
}
616
616
617
- } {2}
617
+ } {{PRAGMA cipher command is deprecated, please remove from usage.} 2}
618
618
db close
619
619
file delete -force test.db
620
620
@@ -649,7 +649,7 @@ do_test rekey-from-cbc-to-ecb-no-iv {
649
649
SELECT count(*) FROM t1;
650
650
}
651
651
652
- } {1001}
652
+ } {{PRAGMA cipher command is deprecated, please remove from usage.} 1001}
653
653
db close
654
654
file delete -force test.db
655
655
@@ -1069,7 +1069,7 @@ do_test attached-database-pragmas {
1069
1069
PRAGMA cipher_use_hmac = OFF;
1070
1070
SELECT count(*) FROM t1;
1071
1071
}
1072
- } {1000}
1072
+ } {{PRAGMA cipher command is deprecated, please remove from usage.} 1000}
1073
1073
db close
1074
1074
file delete -force test.db
1075
1075
file delete -force test2.db
@@ -1541,7 +1541,7 @@ do_test verify-pragma-cipher-version {
1541
1541
execsql {
1542
1542
PRAGMA cipher_version;
1543
1543
}
1544
- } {3.3.1 }
1544
+ } {3.4.0 }
1545
1545
db close
1546
1546
file delete -force test.db
1547
1547
@@ -1922,18 +1922,6 @@ do_test verify-pragma-cipher-page-size-changed {
1922
1922
db close
1923
1923
file delete -force test.db
1924
1924
1925
- # verify invalid cipher does not cause segfault
1926
- if_built_with_openssl verify-invalid-cipher-does-not-segfault {
1927
- sqlite_orig db test.db
1928
- execsql {
1929
- PRAGMA key = 'test';
1930
- PRAGMA cipher = 'junk';
1931
- PRAGMA cipher;
1932
- }
1933
- } {AES-256-CBC}
1934
- db close
1935
- file delete -force test.db
1936
-
1937
1925
# verify setting cipher_store_pass before key
1938
1926
# does not cause segfault
1939
1927
do_test verify-cipher-store-pass-before-key-does-not-segfault {
@@ -1967,7 +1955,7 @@ if_built_with_openssl verify-pragma-cipher-changed {
1967
1955
PRAGMA cipher = 'AES-256-ECB';
1968
1956
PRAGMA cipher;
1969
1957
}
1970
- } {AES-256-ECB}
1958
+ } {{PRAGMA cipher command is deprecated, please remove from usage.} AES-256-ECB}
1971
1959
db close
1972
1960
file delete -force test.db
1973
1961
@@ -2302,5 +2290,26 @@ do_test attach_database_with_non_default_page_size {
2302
2290
db close
2303
2291
file delete -force test.db test2.db
2304
2292
2293
+ if_built_with_openssl wont-write-database-with-invalid-cipher {
2294
+ sqlite_orig db test.db
2295
+ catchsql {
2296
+ PRAGMA key = 'test';
2297
+ PRAGMA cipher = 'foobar';
2298
+ CREATE TABLE t1(a,b);
2299
+ }
2300
+ } {1 {SQL logic error or missing database}}
2301
+ db close
2302
+ file delete -force test.db
2303
+
2304
+ if_built_with_openssl wont-write-database-with-invalid-cipher-2 {
2305
+ sqlite_orig db test.db
2306
+ execsql {
2307
+ PRAGMA key = 'test';
2308
+ PRAGMA cipher = 'foobar';
2309
+ }
2310
+ } {{PRAGMA cipher command is deprecated, please remove from usage.}}
2311
+ db close
2312
+ file delete -force test.db
2313
+
2305
2314
sqlite3_test_control_pending_byte $old_pending_byte
2306
2315
finish_test
0 commit comments