|
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0, version-3.38.5, version-3.38.4, relese, version-3.38.3, version-3.38.2, version-3.38.1 |
|
| #
f2a777fa |
| 22-Feb-2022 |
drh <> |
For the "PRAGMA database_list" statement, do not check to see if the schema
is up-to-date and do not try to reload the schema.
FossilOrigin-Name: 710de6a2137c872812effa43ea888aa77d339362ca0b6c8990d4
For the "PRAGMA database_list" statement, do not check to see if the schema
is up-to-date and do not try to reload the schema.
FossilOrigin-Name: 710de6a2137c872812effa43ea888aa77d339362ca0b6c8990d4426c8fb20689
show more ...
|
|
Revision tags: version-3.38.0, version-3.37.2, version-3.37.1, version-3.37.0 |
|
| #
253888c1 |
| 04-Oct-2021 |
drh <> |
The pragma_table_list virtual table should have only one "schema" column.
FossilOrigin-Name: 886feffaad6baac37dfaab489c2aecc4abf51a3a5bce1e8a94be7cc1d2a3c30c
|
| #
2e50f670 |
| 21-Sep-2021 |
drh <> |
Add the "PRAGMA table_list" command with its corresponding eponymous
table-valued function: "pragma_table_list".
FossilOrigin-Name: 2c0e7ae541e9ecb86aa58fa7e7057def8aac1b1af1af1aa80b8bf2d260f9a2f9
|
| #
b4d9b2b5 |
| 20-Jul-2021 |
drh <> |
Demonstration code to show how NOT NULL and CHECK constraints can be
verified after an ALTER TABLE ADD COLUMN.
FossilOrigin-Name: 039f540373b03af9e0c87499e5e0423eb093d1d343829282a5ac1de2d600b881
|
|
Revision tags: version-3.36.0, version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3, version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0, version-3.33.0 |
|
| #
4b849b0b |
| 03-Jul-2020 |
drh <[email protected]> |
Fix the pragma_foreign_key_check virtual table so that it accepts arguments.
FossilOrigin-Name: 07f849dee3d245ecf80ba3c3ce8dfc630e71ddb1e9c0bcc1f08cee22001fcb07
|
|
Revision tags: version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0 |
|
| #
49a76a8f |
| 31-Mar-2020 |
drh <[email protected]> |
Add "PRAGMA analysis_limit=N;" to limit the number of rows visited by
ANALYZE when N is positive. Positive N also disables collecting stat4.
FossilOrigin-Name: a279b151c1623807774daf4975175c62ea252
Add "PRAGMA analysis_limit=N;" to limit the number of rows visited by
ANALYZE when N is positive. Positive N also disables collecting stat4.
FossilOrigin-Name: a279b151c1623807774daf4975175c62ea252eefb71f9820ced6773769b392c5
show more ...
|
| #
b48c0d59 |
| 07-Feb-2020 |
drh <[email protected]> |
Simplify the code by removing the unsupported and undocumented
SQLITE_HAS_CODEC compile-time option
FossilOrigin-Name: 5a877221ce90e7523059353a68650c5fdd28ed032807afc2f10afbfbf864bdfe
|
|
Revision tags: version-3.31.1, version-3.31.0 |
|
| #
2b1c2aad |
| 07-Jan-2020 |
drh <[email protected]> |
Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set
the risk rank for many virtual tables.
FossilOrigin-Name: 4c21373c21c9b17b222ae65297a039a035e6ec6b505c00c33704e3c03f94f834
|
| #
79d5bc80 |
| 04-Jan-2020 |
drh <[email protected]> |
Enhance PRAGMA function_list so that it shows all instances of each FuncDef,
the number of arguments, the encoding, the type, and the flags. Use this
capability to locate and fix incorrect function
Enhance PRAGMA function_list so that it shows all instances of each FuncDef,
the number of arguments, the encoding, the type, and the flags. Use this
capability to locate and fix incorrect function flags in the standard build.
FossilOrigin-Name: 9ca906d24a2e88eddb2fd067783512b66cfc49dce1596d816a1c38a09d128218
show more ...
|
| #
66c48907 |
| 29-Oct-2019 |
drh <[email protected]> |
Remove the legacy_file_format PRAGMA. In its place, provide the
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config().
Fix for ticket [6484e6ce678fffab]
FossilOrigin-Name: 4d424f3047b48f
Remove the legacy_file_format PRAGMA. In its place, provide the
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config().
Fix for ticket [6484e6ce678fffab]
FossilOrigin-Name: 4d424f3047b48fc441475137f30a719d2f079390c86fe2617710ddfb05c5e240
show more ...
|
|
Revision tags: version-3.30.1, version-3.30.0 |
|
| #
cc3f3d1f |
| 17-Aug-2019 |
drh <[email protected]> |
Activate introspection pragmas by default. The new option
SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out.
FossilOrigin-Name: 9c4bca64fb5f635296a8d7d7c1bf2808e02ca734a9983e5cee9
Activate introspection pragmas by default. The new option
SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out.
FossilOrigin-Name: 9c4bca64fb5f635296a8d7d7c1bf2808e02ca734a9983e5cee9132f5352a9a6d
show more ...
|
|
Revision tags: version-3.29.0 |
|
| #
51e441da |
| 21-May-2019 |
drh <[email protected]> |
Combine the implementations of the key and hexkey pragmas into a single
case. Have both pragmas return "ok" if they are implemented.
FossilOrigin-Name: b3692c406f7ba62587c9d3256f888748393519680e9e2
Combine the implementations of the key and hexkey pragmas into a single
case. Have both pragmas return "ok" if they are implemented.
FossilOrigin-Name: b3692c406f7ba62587c9d3256f888748393519680e9e2db53f59557f1a300e05
show more ...
|
| #
08652b5e |
| 08-May-2019 |
drh <[email protected]> |
Provide the SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA compile-time option to
omit the case_sensitive_like pragma. This change, in combination with
documentation changes, is the current solution to tick
Provide the SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA compile-time option to
omit the case_sensitive_like pragma. This change, in combination with
documentation changes, is the current solution to ticket
[a340eef47b0cad5].
FossilOrigin-Name: eabe7f2d4ff0e0dd868dcab7ec1d4a9168a25f80d3a52f0eeea2f90bd33782f2
show more ...
|
| #
10c0e711 |
| 25-Apr-2019 |
drh <[email protected]> |
Add the sqlite3_hard_heap_limit64() interface and the corresponding
"PRAGMA hard_heap_limit=N" command.
FossilOrigin-Name: b0ccef61a7f92d20228becbf4f997bf0f4e46dad2deaf0896dc63b976ad1dd11
|
|
Revision tags: version-3.28.0, version-3.27.2, version-3.27.1, version-3.27.0 |
|
| #
01996dae |
| 06-Feb-2019 |
drh <[email protected]> |
Back out check-in [008112bcef561a8], reenabling deprecated PRAGMAs when the
SQLITE_OMIT_DEPRECATED compile-time option is used, because way too many
TH3 tests depend on those deprecated PRAGMAs.
Fos
Back out check-in [008112bcef561a8], reenabling deprecated PRAGMAs when the
SQLITE_OMIT_DEPRECATED compile-time option is used, because way too many
TH3 tests depend on those deprecated PRAGMAs.
FossilOrigin-Name: 9dbf512d1c4627a28d60f4e7238cb100d7a4e11f976139b07ad1c59e9b584c7d
show more ...
|
| #
24545d23 |
| 05-Feb-2019 |
drh <[email protected]> |
Keep the temp_store_directory and data_store_directory pragmas even when
compiling with SQLITE_OMIT_DEPRECATED.
FossilOrigin-Name: 93386a7c97f27df69f79052ef4d80143bb6832a806885249c315d226b2a256b2
|
| #
9b747068 |
| 31-Jan-2019 |
drh <[email protected]> |
Improvements to "PRAGMA parser_trace=ON": Make it a flag pragma, and then
use the flag to show the complete SQL text at the beginning of the parse.
FossilOrigin-Name: 507c43537f00d089efb3c3020fb6e82
Improvements to "PRAGMA parser_trace=ON": Make it a flag pragma, and then
use the flag to show the complete SQL text at the beginning of the parse.
FossilOrigin-Name: 507c43537f00d089efb3c3020fb6e826e8f89f3efa2caaa12c5309d35dd0c22e
show more ...
|
| #
3cc9af21 |
| 24-Jan-2019 |
drh <[email protected]> |
Omit deprecated PRAGMAs when compiling with the -DSQLITE_OMIT_DEPRECATED option.
FossilOrigin-Name: 008112bcef561a8a3ebfb007cbef36cbc0071f547e6ebdba3d3bbb39e2c48c7a
|
|
Revision tags: version-3.26.0, version-3.25.3 |
|
| #
fd748c64 |
| 30-Oct-2018 |
drh <[email protected]> |
Split the SQLITE_WriteSchema flag in two flags, WriteSchema and
SQLITE_NoSchemaError. Set only WriteSchema on a VACUUM to avoid problems
when trying to vacuum a corrupt database. With this change,
Split the SQLITE_WriteSchema flag in two flags, WriteSchema and
SQLITE_NoSchemaError. Set only WriteSchema on a VACUUM to avoid problems
when trying to vacuum a corrupt database. With this change, the size
of the flags field on sqlite3 must grow from 32 to 64 bytes.
FossilOrigin-Name: 4f9878107a54356b7105fa1db7655ee239685d570436f6ad4d4221c9bd829b3d
show more ...
|
| #
fa5c62ef |
| 11-Oct-2018 |
drh <[email protected]> |
Add the textkey and textrekey pragmas.
FossilOrigin-Name: f03164d45450cd7ff2162999aa9e51eec7fb5e7cab1fa83d876b544f8f841097
|
| #
bdc9744f |
| 01-Oct-2018 |
drh <[email protected]> |
Change the name of the pragma to PRAGMA table_xinfo. Improve the
mkpragmatab.tcl script to reuse column names where appropriate.
FossilOrigin-Name: 2fdd068987e59b979045d71ae64e700600ef07e54ae340f30
Change the name of the pragma to PRAGMA table_xinfo. Improve the
mkpragmatab.tcl script to reuse column names where appropriate.
FossilOrigin-Name: 2fdd068987e59b979045d71ae64e700600ef07e54ae340f30c2064e5dcccb8ea
show more ...
|
| #
d7dc0a36 |
| 01-Oct-2018 |
drh <[email protected]> |
Add the extra "hidden" column to the end of the PRAGMA table_vinfo output.
FossilOrigin-Name: cf1b76135f511530dcc7b82f78c952bf97ebcddb40be06f713f9f2326915fabe
|
| #
15fc988c |
| 29-Sep-2018 |
drh <[email protected]> |
Add the PRAGMA table_vinfo command (with an extra "v" before "info") that
works like PRAGMA table_info (without the "v") except that it also shows
hidden columns on virtual tables.
FossilOrigin-Name
Add the PRAGMA table_vinfo command (with an extra "v" before "info") that
works like PRAGMA table_info (without the "v") except that it also shows
hidden columns on virtual tables.
FossilOrigin-Name: 8bcd1a59560aa7ea73e6529e5c14ece8ac09bf7e99efdcfd388fead39846b6bf
show more ...
|
|
Revision tags: version-3.25.2 |
|
| #
674b8942 |
| 20-Sep-2018 |
dan <[email protected]> |
Add a PRAGMA that restores the legacy ALTER TABLE RENAME TO behaviour.
FossilOrigin-Name: 5acad2e92c11c209bedc6ac8a709595e8070eed028ffc82af61499e5ceaa5e2b
|
|
Revision tags: version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2 |
|
| #
7df01196 |
| 28-Apr-2018 |
drh <[email protected]> |
Add the SQLITE_DBCONFIG_RESET_DATABASE control as a replacement for
the reset_database pragma. Resetting the database should be hard enough
to do that it cannot be done by accident.
FossilOrigin-Na
Add the SQLITE_DBCONFIG_RESET_DATABASE control as a replacement for
the reset_database pragma. Resetting the database should be hard enough
to do that it cannot be done by accident.
FossilOrigin-Name: ff836cb8b0377c5970ecb2b797702e2b5d208eda443ecbd55f4c238a3094b28a
show more ...
|