database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
17,644 Commits 1,786 Branches 392 Tags
or-optimization
Commit Graph

611 Commits

Author SHA1 Message Date
drh
0942559a14 Move the "shell_add_schema()" SQL function used by the ".schema" command 
of the command-line shell to a different spot in the shell.c source file
so that it is not in the middle of an unrelated module.

FossilOrigin-Name: 254617a1ccfa1736d4e53d670d80319c79c4d93ebf1de69d89ebdba3949bc270
 2017-06-15 16:56:05 +00:00
drh
90cdec0672 Fix harmless compiler warnings in the shell.c file 
FossilOrigin-Name: 9afd7a2ffd3a39456190ad05e85ff6485298aae262d9e0698a58c1d73507a36f
 2017-06-15 13:07:56 +00:00
drh
594ccd09b1 Improvements to the ".tables" command in the command-line shell so that 
it shows the name of all schemas if the name is anything other than "main".

FossilOrigin-Name: c7f778b7cee16a1dcebccd256408ee1d08ef2b62e388a9ebba5738a0a89bf3a0
 2017-06-15 12:50:47 +00:00
drh
20c9c3f4eb In the command-line shell, enhance the ".schema" command show that it 
shows the schema for ATTACH-ed databases in addition to "main".

FossilOrigin-Name: 48e086284a76da10a85315bc992e2294bd4711e35ec5a5abaa16e39a6a69d206
 2017-06-15 12:21:09 +00:00
drh
c5d353fb33 Adjust the implementation of the ".selftest" feature of the shell to avoid 
using the deprecated sqlite3_get_table() interface.

FossilOrigin-Name: 3168e2c92ad0a0dafc78a27ee1d87ac89f426585f506f418a0182141335dc68b
 2017-06-09 02:27:49 +00:00
drh
64bf76d2b2 Fix the column width deduction logic in the command-line shell to account 
for multi-byte utf8 characters.

FossilOrigin-Name: ed0842c156ab1a78d5d00d3a55dab5e3f08cd349328d606724688f1528df3f6b
 2017-06-05 12:29:26 +00:00
mistachkin
e16a350f17 Improve shell help text for the '.open' command. 
FossilOrigin-Name: 7cc940a97efc096ff3725710f526c06f52453bd923fb9e825ce6990275df747a
 2017-05-29 03:48:13 +00:00
drh
ce13b99f99 Remove the msvc.h header file from the autoconf tarball. 
FossilOrigin-Name: 84996aef68adeabc8bd97cad269188c67de628f776337a25ec2d63bc956cee78
 2017-05-23 20:00:00 +00:00
drh
453ca043a2 Add the ".cd" command to the command-line shell. 
FossilOrigin-Name: 5fe28e15b1d6d8a588fcaf93c6035c0e0ab7bcad1067c7933cd430d2e04bbbd8
 2017-05-22 18:00:34 +00:00
drh
f8a2e8c2d2 Fix requirements marks and harmless compiler warnings. 
FossilOrigin-Name: 198ff4c01d86d193a54745764d69376cab8e94747a4daa444690f7e1ec87800b
 2017-05-06 17:12:52 +00:00
drh
050b124ce2 Fix a collision of the "B0" identifier name between the termios.h header 
file and the SHA3 implementation in the shell.

FossilOrigin-Name: b9a58daca80a815e87e541cb5fff9bc8b93f131d223f322c5b83dd5a5f0c0312
 2017-05-04 11:13:50 +00:00
drh
6887e8facd Fix the ".column" output mode in the command-line shell so that it correctly 
counts and formats multi-byte UTF characters.

FossilOrigin-Name: f508aff8d1782abdff4d03726ae098607a0ee6cfd2e35b130097ee5043e98960
 2017-04-17 13:18:42 +00:00
drh
13fe138b0a Fix the quoting mechanism for ".dump" so that it is not applied for the 
".mode quote" output.

FossilOrigin-Name: 78c1e90305d48917d9423d8e50a7dfd15ec27aa93cb421610062229c7ede13a6
 2017-04-08 13:42:55 +00:00
drh
72507d431b Fix the ".dump" command so that it works with ".headers on". Also fix the 
display of ".mode insert" with ".headers on".

FossilOrigin-Name: a6ce57ee3c7f3527554a75cc1dd5ebcd33c944d4dca07b134d103596a2ae5b32
 2017-04-08 00:55:13 +00:00
drh
6193d49cdf Use replace() instead of char() to quote newline and return characters in 
strings in the output of .dump, to avoid excess expression complexity.

FossilOrigin-Name: 4c2b572969ea2ed2a925444ecfa356aa877018cbb9c4f57d081ab4b535cd1dd0
 2017-04-07 11:45:58 +00:00
dan
54e2efcd2f Fix the ".lint fkey" shell command for cases where the child key is also an 
INTEGER PRIMARY KEY.

FossilOrigin-Name: 48826b222c110a90996a84605318ea6b1e502b8c5129f4d561f8350dbdbcd264
 2017-04-06 14:56:26 +00:00
dan
50da9382f9 Fix the ".lint fkey" shell tool command so that it works for foreign keys that 
refer implicitly to primary key columns with non-BINARY default collation
sequences.

FossilOrigin-Name: 327eff25ba2420267cc8dc49dd3c3aab45f4bf9e060d1ad480e25d016d21f3ba
 2017-04-06 12:06:56 +00:00
drh
34ad36bf81 Disable the new --preserve-rowids option on the CLI ".dump" command if 
compiled with SQLITE_OMIT_VIRTUALTABLE.

FossilOrigin-Name: bd5bbe4eece9051cc8c27d834d22fb243d34f261641984555d02a27b7038d4f6
 2017-03-25 18:15:05 +00:00
drh
2fb79e9b04 Fix two harmless compiler warnings. 
FossilOrigin-Name: 32be9c3faaafd736da3f49d475dc9279af4e4ba38070b60033d898345080acf0
 2017-03-25 12:08:11 +00:00
drh
701ff6ad2d Fix harmless compiler warnings in the shell. 
FossilOrigin-Name: a786829783ef65ef270ca360712364cbd47a540d31ed1547d50808aad698bea7
 2017-03-22 12:51:34 +00:00
drh
a5d75ba9ea Mention the ".selftest" command in the ".help" output of the CLI. 
FossilOrigin-Name: 37f766dbad1f99ff86dd1b771bf443036e928e5b4d8abe55bbe4acf3362c7be2
 2017-03-15 14:20:34 +00:00
drh
708b22b1e3 The output of the ".dump" command in the CLI quotes newline and carriage-return 
characters using "char(10)" and "char(13)".

FossilOrigin-Name: 8b2954dd8376e2de985cf5dedeb6eec32c430505
 2017-03-11 01:56:41 +00:00
drh
891d6b4e9e Increase the number of significant digits in floating point literals on 
".dump" output from the shell.

FossilOrigin-Name: 7359fcacaadc349f520536311dcd1d0b5cea7673
 2017-03-11 00:46:57 +00:00
drh
a2df53bd61 Enhance the ".stats" dot-command in the CLI to use sqlite3_status64() instead 
of sqlite3_status().

FossilOrigin-Name: 118f5c0564fef70cbd06fc0d9dbb2baec162cc39
 2017-03-10 14:36:10 +00:00
drh
f157d10f9f Improvements to ".selftest --init". Tests are number in increments of 10 
starting with 100.  The tests are generated inside a SAVEPOINT.  Errors are
reported during test generation.  Tests can be appended to existing tests.
Add a test case to verify the schema.

FossilOrigin-Name: b044b152aac2ec606750940ea816ad4a4aef8eb6
 2017-03-10 01:05:38 +00:00
drh
fb546afb4d Remove the test/dbselftest.c program. In its place, add the ".selftest" 
command to the CLI.  The new CLI version is .selftest is slightly different
in that it uses SHA3 hashing instead of SHA1, so the new is subtly 
incompatible with the old.

FossilOrigin-Name: f4fcd46f08ba59d2a3e772cad98383129f648386
 2017-03-09 22:00:33 +00:00
drh
f8563c00b2 Fix the ".dump" command to correctly extract tail data from corrupt 
WITHOUT ROWID tables.

FossilOrigin-Name: 6c627e50622d8bcd25ec7d5503f3fafd725673a8
 2017-03-09 18:13:52 +00:00
drh
e6e1d124db Begin moving separate boolean variables in the ShellState object of the CLI 
into the shellFlgs bitmask.

FossilOrigin-Name: 50eec5d9aa38fab1a85d788356ffdaf6c35d9ece
 2017-03-09 13:50:49 +00:00
drh
f80d4ff59f Make sure the database connection is open prior to running the ".sha3sum" 
command.

FossilOrigin-Name: 2ea300fb8f7c497f3f092dc91f4305d8431c27d9
 2017-03-08 18:06:20 +00:00
drh
3ee83efec1 In the ".sha3sum" command, if there is a LIKE pattern, show the hashes for 
each table separately.  Without a LIKE pattern, show a single hash over the
entire database.

FossilOrigin-Name: 30f878832820ce7ccc4627c4f0f98fbe82f8b0f6
 2017-03-08 17:56:54 +00:00
drh
1554bc8a2e Add the ".sha3sum" command to the CLI - used to compute a cryptographic hash 
of the <em>content</em> of a database file or of individual tables with in
that file.

FossilOrigin-Name: fc663799075a22b0a61a6a114116bb2d1b96d4ab
 2017-03-08 16:10:34 +00:00
drh
f42d318002 In the CLI, avoid unnecessary identifier quoting in the ".dump" output. 
Also add new ".dump" test cases.

FossilOrigin-Name: de65f907610a59e64cbf2214789c11f7117a86a6
 2017-03-08 12:25:18 +00:00
drh
e611f14471 Add the --preserve-rowids option to the ".dump" command in the CLI. 
FossilOrigin-Name: c60aee24714a47ce12ee2a4dcefb9f55211d3761
 2017-03-08 11:44:00 +00:00
dan
2147221c36 Fix a use-after-free problem in the shell tool code that could occur if an SQL 
statement were executed after an ".open" command with invalid options.

FossilOrigin-Name: ac760db0727209db0a816e112ea5f47e54d54dac
 2017-03-01 11:30:27 +00:00
drh
f196972c73 Fix the #endif location for an #ifndef SQLITE_UNTESTABLE macro in the 
command-line shell.

FossilOrigin-Name: 8cc9d74c176a78aeebfbb39198c21b5dd547ff52
 2017-02-17 23:52:00 +00:00
drh
2b44fd94ba Enable the ".wheretrace" and ".selecttrace" extensions in the command-line 
shell when compiled on Windows using DEBUG=3 or higher.  Fix a harmless
warning in the shell that comes up when compiled this way.

FossilOrigin-Name: 8a03be1dc42737ba0712d33f639ea26dc243b20e
 2017-02-17 01:43:51 +00:00
drh
0c5cd969b8 Clarification of the help text for the command-line shell. 
FossilOrigin-Name: ca4f1e4962df64ae756c286f3795af7d6f692cdd
 2017-02-14 21:47:46 +00:00
drh
7aee83b935 In the command-line shell, enhance the ".mode" command so that it restores the 
default column and row separators for modes "line", "list", "column", and
"tcl".

FossilOrigin-Name: 58f02e6eae8fc9e2577fe435b0282fb46af3960d
 2017-01-27 01:52:42 +00:00
drh
38305ab55f Fix an uninitialized variable in the command-line shell. 
FossilOrigin-Name: 06b8001ade62bc59e6ae20f761167a81d85a4272
 2017-01-22 16:34:35 +00:00
drh
96ada59cbb Fix harmless compiler warnings in the command-line shell and in Lemon. 
FossilOrigin-Name: afcdc4a60e357d171156e0de705bf7ad1b37daab
 2016-12-29 19:48:46 +00:00
drh
6a5a4208fc Combine the implementations of the ".tables" and ".indexes" commands in the 
command-line shell.  The ".indexes" command now puts the indexes in multiple
columns, just like ".tables" and shows all indexes in all attached databases.

FossilOrigin-Name: def29333655691c7d54451193be13445a2857d29
 2016-12-24 21:32:40 +00:00
drh
b20a61b704 Change the output format of the ".databases" command in the command-line shell 
so that it shows the schema name, a colon, and the corresponding filename.

FossilOrigin-Name: 8558512e9ca343300a767ef23810f2d7b50fd925
 2016-12-24 18:18:58 +00:00
drh
a4b81d2a44 In the command-line shell, improve the formatting to the ".databases" 
command and on the ".tables" command, only show the schema prefix for
databases past the first ("main") database.

FossilOrigin-Name: c0d5626e274cbf8c2d2167183c4d6835d72dae57
 2016-12-24 18:04:28 +00:00
drh
344a1bf133 Fix harmless compiler warnings. 
FossilOrigin-Name: fa86db2f915c0a189c3be02b1aaa7f24d339d7d6
 2016-12-22 14:53:25 +00:00
dan
11da002c02 Fix a problem in the shell tools readfile() command causing blobs to be 
truncated at the first embedded 0x00 byte in release builds, or an assert() to
fail in a debug build.

FossilOrigin-Name: 8dedd6ad44bd1d103dced9d1350188cb2327128d
 2016-12-17 08:18:05 +00:00
drh
3fd9f33bd1 Fix minor issues with the ".lint" command implemention in the shell and 
the shell help text related to ".lint".

FossilOrigin-Name: 1268dc77712d85de0b62332c88b22f7489f4e87f
 2016-12-16 18:41:11 +00:00
dan
3c7ebeb548 Change ".fkey_missing_indexes" to ".lint fkey-indexes". 
FossilOrigin-Name: ee621ade38c11806e1df57c459da5f018a6d0670
 2016-12-16 17:28:56 +00:00
dan
dd9e0be46a Update .fkey_missing_indexes to use the built-in pragma vtabs. 
FossilOrigin-Name: 3ab05987b0cc12af64bf32d885d04aff45d7a77c
 2016-12-16 16:44:27 +00:00
dan
f9647b6625 Add the -groupbyparent option to the ".fkey_missing_indexes" command. 
FossilOrigin-Name: 976c51b4836dfba2ce9b246334a85bda08ac526f
 2016-12-15 06:01:40 +00:00
dan
35ac58eabc Add the experimental ".fkey_missing_indexes" command to the shell tool. To 
identify indexes that should be created on child keys if FK processing is to
be enabled.

FossilOrigin-Name: 7df23aca1f7c7b769d614d740b3fda3073f46ba9
 2016-12-14 19:28:27 +00:00