database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-07-29 08:01:23 +03:00
Code Activity
30,255 Commits 1,567 Branches 182 Tags
reuse-schema-3.50
Commit Graph

80 Commits

Author SHA1 Message Date
drh
707b713adc Merge the latest trunk enhancements into the reuse-schema branch. 
FossilOrigin-Name: b51690e180cfb6034c772899f068453da8484a830283f7c152cfb6fa4330c31e
 2025-03-03 16:53:48 +00:00
drh
1d54203394 Strive to make sorts stable in the mkpragmatab.tcl build script, so that 
we get consistent amalgamations regardless of platform.
[forum:/forumpost/c9914addebf3da51|Forum thread c9914addebf3da51].

FossilOrigin-Name: 3f57584710d611748eb0af797c58c72e4ac099db09f5286cafdbd9a8ce354c90
 2025-02-27 16:07:49 +00:00
drh
50bd28f6b3 Merge the latest trunk enhancements into the reuse-schema branch. 
FossilOrigin-Name: b2bf063011df07a4ee8031461dee9ee9b6e4de46f24e492d95104707332b26dc
 2025-02-18 14:56:13 +00:00
drh
cd56ad4ccb Omit the src/pragma.h file. It is generated by the tool/mkpragmatab.tcl script. 
The makefiles now know how to build this file for themselves.

FossilOrigin-Name: 9709ed1cdfa17f690ffd4ec8cfc54efefec8352143c1d8b701f09299bd7eef6e
 2025-02-11 19:54:13 +00:00
drh
f234d50e0e Merge the latest trunk enhancements into the reuse-schema branch. 
FossilOrigin-Name: 5c36819c42e7163e517e44e2196c739c45558d2d190139fc78d45f9bba30252c
 2023-12-06 22:22:02 +00:00
drh
8a93ce7458 Update the srctree-check.tcl script and child script so that they can be run 
on a read-only source tree and so that if any inconsistencies are found, the
script returns a non-zero exit code and thus halts the build.

FossilOrigin-Name: 58eb5440d75fb13c1a089cb935de6fb94b4322e10e349db8f11f37b9a2fda2fc
 2023-11-02 12:05:55 +00:00
drh
fa98d0ea0d Don't reload the schema on PRAGMA database_list. 
FossilOrigin-Name: 630fe446da880b5320ff014a9f7dde683664eb5cb9fd47be5b9b32ed3c590f71
 2022-02-22 20:38:45 +00:00
drh
f2a777fa5d 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
 2022-02-22 20:29:31 +00:00
drh
b963701038 Merge recent trunk enhancements into the reuse-schema branch 
FossilOrigin-Name: cd15fc3c08373dad63ba7eafb117d0d09913b8fc339882fd909da5ec485a7138
 2021-10-21 14:10:04 +00:00
drh
253888c13b The pragma_table_list virtual table should have only one "schema" column. 
FossilOrigin-Name: 886feffaad6baac37dfaab489c2aecc4abf51a3a5bce1e8a94be7cc1d2a3c30c
 2021-10-04 13:30:22 +00:00
drh
63f94dfe9f Merge recent trunk enhancements into the reuse-schema branch. 
FossilOrigin-Name: 64234c5c9a5709e7c7c1b18bf32f4374692129b353c4698010abfc98bd00bcc4
 2021-10-04 11:49:35 +00:00
drh
2e50f67073 Add the "PRAGMA table_list" command with its corresponding eponymous 
table-valued function: "pragma_table_list".

FossilOrigin-Name: 2c0e7ae541e9ecb86aa58fa7e7057def8aac1b1af1af1aa80b8bf2d260f9a2f9
 2021-09-21 17:26:23 +00:00
drh
339fbb64be Merge recent trunk enhancements into the reuse-schema branch. 
FossilOrigin-Name: d71adc3fd85cfc5902b7146101d030ab2fbe932ed05848a407a7422ddeeb4c43
 2021-08-03 16:11:59 +00:00
drh
b4d9b2b537 Demonstration code to show how NOT NULL and CHECK constraints can be 
verified after an ALTER TABLE ADD COLUMN.

FossilOrigin-Name: 039f540373b03af9e0c87499e5e0423eb093d1d343829282a5ac1de2d600b881
 2021-07-20 07:35:07 +00:00
drh
e805679133 Merge all changes since the 3.32.0 release into the reuse-schema branch. 
FossilOrigin-Name: b1a77b7eade14d58b3ccd50b98c2ffb6362d093f2cde2bd178ea62cef2cb8d9f
 2020-08-11 14:55:17 +00:00
drh
4b849b0b09 Fix the pragma_foreign_key_check virtual table so that it accepts arguments. 
FossilOrigin-Name: 07f849dee3d245ecf80ba3c3ce8dfc630e71ddb1e9c0bcc1f08cee22001fcb07
 2020-07-03 12:32:04 +00:00
drh
6d78967393 Merge trunk enhancements in the reuse-schema branch. 
(Actual date of this check-in is 2020-05-18.)

FossilOrigin-Name: 5af4abe98c747ff5c6a84b6cc1f7b69d9b492a807a8fd5234163f3bd9c96c574
 2020-05-16 18:59:59 +00:00
drh
49a76a8fe5 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
 2020-03-31 20:57:06 +00:00
dan
8e8c7ccc9b Merge latest trunk changes into this branch. 
FossilOrigin-Name: 3f5650aae69498fce8c3f2b9c9e67e52f676776ea6d8a2f0f153fdeb8857231c
 2020-02-27 15:20:37 +00:00
drh
b48c0d59fa Simplify the code by removing the unsupported and undocumented 
SQLITE_HAS_CODEC compile-time option

FossilOrigin-Name: 5a877221ce90e7523059353a68650c5fdd28ed032807afc2f10afbfbf864bdfe
 2020-02-07 01:12:53 +00:00
drh
106ab91fc8 Merge all recent enhancements and fixes from trunk. 
FossilOrigin-Name: f783917800a5ce7c4bb31725b26d266cd4f133a0cc8414c6bf4789a8cd1e45c8
 2020-01-15 14:26:58 +00:00
drh
2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 
the risk rank for many virtual tables.

FossilOrigin-Name: 4c21373c21c9b17b222ae65297a039a035e6ec6b505c00c33704e3c03f94f834
 2020-01-07 19:45:40 +00:00
drh
79d5bc80c7 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
 2020-01-04 01:43:02 +00:00
drh
803f06bf62 Merge recent enhancements from trunk. 
FossilOrigin-Name: b8a631fd30d0732505679230684b3362c965438197a2b11518f01a77599c9202
 2019-11-14 15:21:15 +00:00
drh
66c48907a2 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
 2019-10-29 16:18:45 +00:00
drh
d973196e30 Merge all recent trunk enhancements into the reuse-schema branch. 
FossilOrigin-Name: 27eb223690989a294c5aad7a8ab1927904b1041e36ce7a0c04800bce49ec9142
 2019-09-16 12:35:48 +00:00
drh
007ba6457e Bring the hard-heap-limit branch up-to-date with trunk. 
FossilOrigin-Name: 9b14eb77548d3f65f5a4c9b16cecdbce8a3fb663692aa8315fbd21aab3e89f0d
 2019-08-20 17:14:21 +00:00
drh
cc3f3d1f05 Activate introspection pragmas by default. The new option 
SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out.

FossilOrigin-Name: 9c4bca64fb5f635296a8d7d7c1bf2808e02ca734a9983e5cee9132f5352a9a6d
 2019-08-17 15:27:58 +00:00
drh
88e7099875 Merge recent enhancements from trunk. 
FossilOrigin-Name: ff9f3e09510b4418cb166fa2557598a279e7baedc315a5d1c3ae63beb92c238d
 2019-05-24 13:04:55 +00:00
drh
51e441da2b 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
 2019-05-21 17:04:27 +00:00
drh
28c156d6d6 Merge all the latest trunk enhancements into the reuse-schema branch. 
FossilOrigin-Name: 018f3199b9ba043fbbf88ec46b4fa16728f6507e000f4813ed346aaf6665add6
 2019-05-14 22:25:26 +00:00
drh
08652b5ea0 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
 2019-05-08 17:27:18 +00:00
drh
10c0e7115b Add the sqlite3_hard_heap_limit64() interface and the corresponding 
"PRAGMA hard_heap_limit=N" command.

FossilOrigin-Name: b0ccef61a7f92d20228becbf4f997bf0f4e46dad2deaf0896dc63b976ad1dd11
 2019-04-25 18:15:38 +00:00
dan
74e020a164 Where possible, avoid loading all schemas into memory for PRAGMA statements. 
FossilOrigin-Name: 64f97530ad387655767b5205fb9a9c723210cd4975176ab6fb71bca0cb585a74
 2019-02-25 17:54:23 +00:00
drh
01996dae49 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
 2019-02-06 00:11:13 +00:00
drh
24545d2300 Keep the temp_store_directory and data_store_directory pragmas even when 
compiling with SQLITE_OMIT_DEPRECATED.

FossilOrigin-Name: 93386a7c97f27df69f79052ef4d80143bb6832a806885249c315d226b2a256b2
 2019-02-05 12:16:53 +00:00
drh
9b747068ba 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
 2019-01-31 01:39:01 +00:00
drh
3cc9af2140 Omit deprecated PRAGMAs when compiling with the -DSQLITE_OMIT_DEPRECATED option. 
FossilOrigin-Name: 008112bcef561a8a3ebfb007cbef36cbc0071f547e6ebdba3d3bbb39e2c48c7a
 2019-01-24 16:07:18 +00:00
drh
fd748c6460 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
 2018-10-30 16:25:35 +00:00
drh
fa5c62ef2e Add the textkey and textrekey pragmas. 
FossilOrigin-Name: f03164d45450cd7ff2162999aa9e51eec7fb5e7cab1fa83d876b544f8f841097
 2018-10-11 18:41:50 +00:00
drh
bdc9744f60 Change the name of the pragma to PRAGMA table_xinfo. Improve the 
mkpragmatab.tcl script to reuse column names where appropriate.

FossilOrigin-Name: 2fdd068987e59b979045d71ae64e700600ef07e54ae340f30c2064e5dcccb8ea
 2018-10-01 21:26:30 +00:00
drh
d7dc0a36cc Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. 
FossilOrigin-Name: cf1b76135f511530dcc7b82f78c952bf97ebcddb40be06f713f9f2326915fabe
 2018-10-01 18:28:42 +00:00
drh
5612ef1057 Bring the PRAGMA table_vinfo statement up to date with trunk. 
FossilOrigin-Name: 6f606f99231f88ae5ff719d0ce21afc4b844490102c27ac20aa606baaf78d8d6
 2018-10-01 17:15:17 +00:00
drh
15fc988ce0 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
 2018-09-29 19:38:42 +00:00
dan
674b894269 Add a PRAGMA that restores the legacy ALTER TABLE RENAME TO behaviour. 
FossilOrigin-Name: 5acad2e92c11c209bedc6ac8a709595e8070eed028ffc82af61499e5ceaa5e2b
 2018-09-20 08:28:01 +00:00
drh
8ae11aac93 Add the "Pragma_list" pragma. Put all three pragmas created on this branch 
inside of #ifdef SQLITE_INTROSPECTION_PRAGMAS.

FossilOrigin-Name: 2f3c3781ef3d66ecafef083d7144287ff23eea5a6d93b014dfeb2a8ac71f757e
 2017-07-07 17:33:07 +00:00
drh
ab53bb635c Add new pragmas: "function_list" and "module_list" 
FossilOrigin-Name: e5f01d7fde05fdb547f35816ff15c31a92c170b31877f4c640b7bc2be3f580b3
 2017-07-07 15:43:22 +00:00
drh
169dd928c5 Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner 
stability guarantee.  This involves refactoring the sqlite3.flags bitvector
to carve out a free bit to use.

FossilOrigin-Name: 7076e8283ebae1b45a5d85d9538b49b6da399d38c3c6935de100f948f814f6a9
 2017-06-26 13:57:49 +00:00
drh
c45fdb2a7f Enable pragma virtual tables for the integrity_check, quick_check, and 
foreign_key_check pragmas.

FossilOrigin-Name: 118f7bb33a6f78951bbffa957f48015d1bce5aaf9246a99262a90bc8ad52e5a3
 2017-06-21 01:36:30 +00:00
drh
761f691d0e Force a schema load prior to "PRAGMA optimize". 
FossilOrigin-Name: 86897c24c0b35ffea8df72d86a099addf67de210c6568aaba22ef92f1a60c3cf
 2017-04-03 13:33:51 +00:00