database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
17,617 Commits 1,785 Branches 392 Tags
analyze-empty-tables
Commit Graph

17617 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
dd032a7380 Cause the ANALYZE command to build sqlite_stat1 table entries for empty tables 
with the assumption that such tables really contain 10 elements.  This gives
better query plans for tables that are truely empty, but is likely to cause
problems in legacy systems, so the change is kept off trunk.  Some TCL tests
fail on this check-in due to the new stat1 entries.

FossilOrigin-Name: c81f260c2d4791e40f74c86927a4e9efb79a9d241a66476e4af35c7bbe37a49c
 2017-06-07 10:55:02 +00:00
drh
d1417ee1cb Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated 
number of rows in tables that lack sqlite_stat1 entries.

FossilOrigin-Name: 234ede26e30f20e6c33002739ed8be35dbfb5c77700bd857ff31072b9b7df347
 2017-06-06 18:20:43 +00:00
drh
cf1393df94 Fix a subtle bug in the remember UDF of the kvtest.exe utility program. 
FossilOrigin-Name: 9eea3670e77e2f831b7c00ae2d65a5583f9cad626d9ab286f92582ef29ecd4e3
 2017-06-05 19:20:35 +00:00
dan
b1d66c5986 Fix a bug in test_fs.c that occurs when the first component of a path contains 
a GLOB or LIKE escape character.

FossilOrigin-Name: 73c70590d7689806901378cd2a7e167ec4339f886031369266e07868acd23b93
 2017-06-05 16:33:53 +00:00
drh
a4327e65bb For the kvtest utility, add the --vacuum option to "kvtest stat" and also 
run PRAGMA integrity_check with "kvtest stat".

FossilOrigin-Name: f3c25df4562efda2adeb211a4cc893246354917849a0fa4d95da3d7970e9588e
 2017-06-05 13:28:17 +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
drh
3b77506ba5 Omit some of the fstree tests in vtabH if the PWD contains LIKE wildcards. 
FossilOrigin-Name: ead29f9cb757a5f9921086e3bb4998f60e0d6cfcf41ef0f9a230b365b6226947
 2017-06-05 10:31:03 +00:00
drh
4c88348729 Initialize a variable to zero to prevent an (incorrect) compiler warning of 
it potentially being uninitialized.

FossilOrigin-Name: 65182ce041b30cd0193b958eca975b720fe5200a868baba1e633e49433d86813
 2017-06-03 20:09:37 +00:00
drh
5930f663a1 Fix the SQLITE_PTR_TO_INT macro so that works on recent versions of LLVM on 
Macs.

FossilOrigin-Name: c4089ffbdb4b3467648c97044b0d3085da7128103079b686f608efde83c7df30
 2017-06-03 19:16:29 +00:00
drh
629a75f69a Remove unused header file from kvtest. 
FossilOrigin-Name: dd7e043f7c9e16cd98a273b7105fa74bdd14a93db8cd5bde064cc1c40591155c
 2017-06-03 18:27:49 +00:00
drh
1346fdad65 In kvtest, add the ability to work with a hierarchy of files on disk, 
in addition to having all files in the same directory.

FossilOrigin-Name: f568f666c85ab9b80592927dc033cfd65bd4415576cf5b3beaf300d68a8e074e
 2017-06-03 17:24:04 +00:00
drh
16d62901a3 Add the --nocheckpoint and --multitrans options to kvtest. 
FossilOrigin-Name: 5828633c2392274b6863b50eaffbb2a176a4d892e83542824a9a3f0d1b62c967
 2017-06-03 15:17:21 +00:00
drh
f151890791 Add the --fsync flag to kvtest, and document the --nosync flag. 
FossilOrigin-Name: 7fdc78a672b2ea6187dcb5fdf32f809bb8e4d501e2434f2233edc3bc2e3acc7c
 2017-06-02 23:32:17 +00:00
drh
a2e71ced79 Work toward enhancing kvtest to measure write performance. 
FossilOrigin-Name: fc73e7d2f16386f96c55c42f9830193f7c178521a7ad90c3117b85ef629b5ce4
 2017-06-02 19:31:46 +00:00
drh
170ad68a40 Change the name of the OP_Seek opcode into OP_DeferredSeek for better 
clarity of function.  No functional code changes.

FossilOrigin-Name: ab33d299c7dab52703d06f3441c8a98c6c809b2612ec65d71aab2919bd2b1540
 2017-06-02 15:44:22 +00:00
drh
6c2d94f928 Fix a typo in the header comment of the "series.c" virtual table extension. 
FossilOrigin-Name: d637feb4e3032ee0067c204b56d2af5f7eab228e645f2e77b0b043c2b299724d
 2017-06-02 13:16:54 +00:00
drh
c5e56b3473 Add a comment to the Lemon documentation regarding the security of the 
lemon.exe command-line tool.

FossilOrigin-Name: 4c2458c1908181dc2f6bc594395c06d015fcbd78f5d3472f07a6a3909be9673c
 2017-06-01 01:53:19 +00:00
drh
cdbb126be7 Add the SQLITE_STMTSTATUS_MEMUSED opcode to sqlite3_stmt_status() 
for finding the heap memory usage by a single prepared statement.

FossilOrigin-Name: c26cf978eead1c9d265eddabaa421e7735b472fcf2792cd2bdeb0901bcf3fb44
 2017-05-31 17:30:08 +00:00
drh
3528f6b62b Add the SQLITE_STMTSTATUS_MEMUSED option for sqlite3_stmt_status() that reports 
the amount of heap memory used for a single prepared statement.

FossilOrigin-Name: b57d510465458dec5b5fc778fd6e8833392964201f9febebf526e60a543da0c2
 2017-05-31 16:21:54 +00:00
drh
6b37e0adc9 Add the experimental "stmts" virtual table for introspection of prepared 
statements.

FossilOrigin-Name: cb4c5c66aba757356da3b8ec3c66a5c8c40e180b3360638ac634f7787404a5b1
 2017-05-31 16:09:04 +00:00
drh
d4ab003d4e Avoid allocating excess memory to the KeyInfo objects. 
FossilOrigin-Name: df7859435161f3ecf36635ce574bf73573516a1f2c6e75be320619364e7067d1
 2017-05-31 13:45:59 +00:00
drh
d5bdd5effb Remove a completely unnecessary memset() from the INSERT code generator. 
FossilOrigin-Name: 7d58836b9db1293a3a6581af4358b7c91a588efd5c9b2df384803f3855ff87a8
 2017-05-31 13:27:15 +00:00
drh
b8a1290a28 Very small performance increase in sqlite3VdbeSetNumCols(). 
FossilOrigin-Name: 8885b4461044ae8ecdfe1b9aa47f4aad65efabc98e3fcd9e307a06504fab34c6
 2017-05-31 11:24:13 +00:00
drh
02f18cc5ac Reorder fields in the PgHdr object for a performance increase. 
FossilOrigin-Name: 326e63d71e0e164c5bcd1f74772cb4071b82daf6f04a5d440b985bace5a4c941
 2017-05-31 03:20:39 +00:00
drh
a8b9793c86 Avoid unnecessary memory zeroing during expression list allocation. 
FossilOrigin-Name: de28e6514a42438411e2c9d833ba660108128ca86d0b90f32925fb73195f4862
 2017-05-31 02:58:30 +00:00
drh
d03257c141 Size and performance optimizations to sqlite3ResolveExprNames(). 
FossilOrigin-Name: af8c0fed93c830c50641d95691bb507c31947a15529aba2a88bfaa66b3a3287a
 2017-05-31 00:49:40 +00:00
drh
2ab792e4c0 Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return 
SQLITE_DONE if they have already reached the end (or beginning) of the table.
This gives a performance increase and size reduction.

FossilOrigin-Name: e972a3860892022d57b26ec44ce0fbadc61c1ff54b7a10b7e82390db88d323a7
 2017-05-30 18:34:07 +00:00
dan
d26d2c7de2 Omit a test of codepoint 0x202F (non-break narrow space) from the fts3 ICU 
tests. Different versions of ICU apparently handle this obscure codepoint
slightly differently.

FossilOrigin-Name: 69ae688982d6cb9f859f5643c315a1dc5ba76ad35553ecea8329a75ee70a87b1
 2017-05-30 18:14:47 +00:00
drh
e70d01f143 More efficient error handling and reset in the binding mechanism. 
FossilOrigin-Name: 9a3e3b34ba6eafce2f560c13225a3673e18d696b29295b59d958e938fa593baf
 2017-05-29 22:44:18 +00:00
drh
1e669f02bc Omit unnecessary fstat() calls for determining the database file size, 
resulting in smaller and faster code.

FossilOrigin-Name: dd61c736775c53450821327495276485dced7935d0b4b5ebd17662731afc8adb
 2017-05-29 17:59:29 +00:00
drh
8c9ed054b3 Fix an issue with OPT_FEATURE_FLAGS in configure.ac. 
FossilOrigin-Name: 43ce3bd3a4b41ea757e308e563d6c1bf7f9c09f10e4766c536d0bf1042c45613
 2017-05-29 17:43:06 +00:00
drh
77f6af2b96 Avoid unnecessary fstat() calls to determine the database size when 
transitioning into a read transaction on a rollback-mode database.

FossilOrigin-Name: 6c3476b513965df22d648f9a1b99733af753b44d51163cc7d42a69bf562300e1
 2017-05-29 16:45:45 +00:00
drh
5f5a2d1c3c Avoid unnecessary calls to fstat() to determine the database file size. 
FossilOrigin-Name: c733a1dea37e4678e7bd0d3d0ca9b8eae1fbdc28615f75d8f1e5141aa53567d9
 2017-05-29 14:57:23 +00:00
drh
8abc54e2e8 Fix a typo in a comment. No code changes. 
FossilOrigin-Name: cb29b838886769afe866b1172e3d5d7e36387149b79c51f91cf59da3f4a5f25b
 2017-05-29 14:30:46 +00:00
drh
979dd1be57 Optimizations to the Walker object and its methods to make the code a little 
smaller and to help it run a little faster.

FossilOrigin-Name: 6854a34ed708259f2280f7ee56cec09f7fc99810dc739dc2814ddeae286aa2c4
 2017-05-29 14:26:07 +00:00
drh
d8a295669c Correctly initialize the iSelectId of FROM clause terms that are a self 
join of a reused materialized subquery.  Without this, the EXPLAIN QUERY PLAN
output for the query will identify the subquery using the uninitialized
(and arbitrary) iSelectId.

FossilOrigin-Name: 43c9ae371f6250fee98a7c4011726eff8ad37f5a97add4f490ac3a2dd501a0d2
 2017-05-29 13:09:24 +00:00
mistachkin
e16a350f17 Improve shell help text for the '.open' command. 
FossilOrigin-Name: 7cc940a97efc096ff3725710f526c06f52453bd923fb9e825ce6990275df747a
 2017-05-29 03:48:13 +00:00
drh
ae2ac854b3 Smaller and faster vdbeSorterCompareText(). 
FossilOrigin-Name: 542dc4c5eb87017fe03b6c181e779993aa84564785e1177ccf937d52f985593b
 2017-05-27 22:42:36 +00:00
drh
14e845a9d4 Small performance increase and size decrease in the btreeInitPage() routine. 
FossilOrigin-Name: 6f415833e0554706dcf04f68ecba4ca2e54c08f3bbf6a1dba182bb132c912a2e
 2017-05-25 21:35:56 +00:00
drh
137c46f8b6 Merge the LEFT JOIN query flattener fixes from 3.19.2. 
FossilOrigin-Name: 6513e4a121e32df7e5cd95f47cdf8049b85bdbcb378cf23db29838fb1143d3ce
 2017-05-25 17:27:52 +00:00
drh
65ff63ea62 Version 3.19.2 
FossilOrigin-Name: edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9
version-3.19.2 		2017-05-25 16:50:27 +00:00
drh
dc6de47925 The SQLITE_EXTRA_IFNULLROW compile-time option causes OP_IfNullRow opcodes 
to be issued for references to the right-hand side table of *any* flattened
join, not just LEFT JOINs.  This puts extra stress on the OP_IfNUllRow opcodes
for testing purposes.

FossilOrigin-Name: 1a074c8a2bc0b28918ef905339d11a21d30101b4ea8c06c8b3faca7d17237538
 2017-05-25 11:39:50 +00:00
drh
074ce1e7fd The TK_IF_NULL_ROW expression node must be treated as a variable that 
references the table Expr.iTable.
Proposed fix for ticket [7fde638e94287d2c].

FossilOrigin-Name: b30a364a12d9865242b1444984cd25ee126dc69108d5c6a2d4b35df184437fe9
 2017-05-25 00:28:36 +00:00
drh
8389bff0a8 Increase the version number to 3.19.2 since ticket [7fde638e94287d2] is 
going to necessitate another patch release.

FossilOrigin-Name: c315727acd5fffe6e83ad9a5e84360d5cfa9aa8faa10d4970ea9823c7e8126ee
 2017-05-25 00:12:04 +00:00
drh
f43ce0b445 The TK_IF_NULL_ROW expression node must be treated as a variable that 
references the table Expr.iTable.
Proposed fix for ticket [7fde638e94287d2c].

FossilOrigin-Name: 77fc23013cebc7797985864b91d78db5d0e2469511732044ebfaf02b891c979a
 2017-05-25 00:08:48 +00:00
mistachkin
831265f962 Fix harmless compiler warnings in FTS5. 
FossilOrigin-Name: 57a60e959c198b87ed29fab14356f89e0ea7cdb1dd99adbea45b40e8d0cb310a
 2017-05-24 15:32:44 +00:00
drh
6fb139e087 Version 3.19.1 
FossilOrigin-Name: f6d7b988f40217821a382bc298180e9e6794f3ed79a83c6ef5cae048989b3f86
version-3.19.1 		2017-05-24 13:08:33 +00:00
drh
63ad86e70e Fix a problem in STAT4 equality estimation for multi-column indexes 
introduced by check-in [3e0590dee0e68cc1599].

FossilOrigin-Name: cfb0d9e0207128b1c2b48689288a849b19dbc00a22cfaca26eec4bfc773629f8
 2017-05-24 04:18:00 +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
92b71757f7 Do not use strcpy() in the (obsolete) amatch extension. 
In releasetest.tcl, run Apple tests using -Os instead of -O1

FossilOrigin-Name: 4440e42031b9cb0edf9a8621cd4f46f209392940ec5b9eefcf8c1e3fef5f7b76
 2017-05-23 19:35:20 +00:00