Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Silently ignore requests to change the PRAGMA synchronous setting to an illegal integer value, rather than raising an assertion. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
e0a88176fcfbed7b554a036948261a33 |
User & Date: | drh 2015-04-16 16:04:39.846 |
Context
2015-04-16
| ||
16:22 | Fix a faulty assert() in the compound-SELECT code generator. (check-in: 10715b05f2 user: drh tags: trunk) | |
16:04 | Silently ignore requests to change the PRAGMA synchronous setting to an illegal integer value, rather than raising an assertion. (check-in: e0a88176fc user: drh tags: trunk) | |
15:47 | Make sure errors in coding triggers are propagated back up to the parser. (check-in: 928f973ca9 user: drh tags: trunk) | |
Changes
Changes to src/pragma.c.
︙ | ︙ | |||
942 943 944 945 946 947 948 | if( !zRight ){ returnSingleInt(pParse, "synchronous", pDb->safety_level-1); }else{ if( !db->autoCommit ){ sqlite3ErrorMsg(pParse, "Safety level may not be changed inside a transaction"); }else{ | > | > | 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 | if( !zRight ){ returnSingleInt(pParse, "synchronous", pDb->safety_level-1); }else{ if( !db->autoCommit ){ sqlite3ErrorMsg(pParse, "Safety level may not be changed inside a transaction"); }else{ testcase( (getSafetyLevel(zRight,0,1)+1) & ~PAGER_SYNCHRONOUS_MASK ); pDb->safety_level = (getSafetyLevel(zRight,0,1)+1) & PAGER_SYNCHRONOUS_MASK; setAllPagerFlags(db); } } break; } #endif /* SQLITE_OMIT_PAGER_PRAGMAS */ |
︙ | ︙ |
Changes to test/pragma.test.
︙ | ︙ | |||
214 215 216 217 218 219 220 221 222 223 224 225 226 227 | } } {0} do_test pragma-1.14 { execsql { PRAGMA synchronous=2; PRAGMA synchronous; } } {2} } ;# ifcapable pager_pragmas # Test turning "flag" pragmas on and off. # ifcapable debug { # Pragma "vdbe_listing" is only available if compiled with SQLITE_DEBUG | > > > > > > > > > > > > | 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 | } } {0} do_test pragma-1.14 { execsql { PRAGMA synchronous=2; PRAGMA synchronous; } } {2} do_test pragma-1.14.1 { execsql { PRAGMA synchronous=4; PRAGMA synchronous; } } {0} do_test pragma-1.14.2 { execsql { PRAGMA synchronous=10; PRAGMA synchronous; } } {2} } ;# ifcapable pager_pragmas # Test turning "flag" pragmas on and off. # ifcapable debug { # Pragma "vdbe_listing" is only available if compiled with SQLITE_DEBUG |
︙ | ︙ |