1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Commit Graph

9695 Commits

Author SHA1 Message Date
shess
8a7de08a8b Fix overzealous fts2 assertions WRT rowid 0 or lower. Only check that
docids are ascending if there was a prior docid set for the doclist,
ignore the initial docid of 0. (CVS 4026)

FossilOrigin-Name: ed3a131f1d3fe51d1e79bdfe1bfafa55f825afa9
2007-05-21 21:59:18 +00:00
danielk1977
b39f70b04a Change the way overflow pages are allocated from the free-list to increase the chance that they are a contiguous block. Much more can still be done. (CVS 4023)
FossilOrigin-Name: b7391892041eb72b0ebcbb7a9a6721ae3482dd80
2007-05-17 18:28:11 +00:00
danielk1977
6338c762a5 Bring the autoconf based build system up to date with the recent changes. #2366, #2367 and #2368. (CVS 4022)
FossilOrigin-Name: ae644bc7aad229f2d219ea20eb4774318feb3051
2007-05-17 16:38:30 +00:00
danielk1977
5b159dc312 Fix a problem with casting blobs to numeric types. (CVS 4021)
FossilOrigin-Name: f2ce727c4d798c666e95876a2b67e8a305d82e3a
2007-05-17 16:34:43 +00:00
danielk1977
63c64f3b8c Add speed3.test file. For testing performance issues related to overflow pages. (CVS 4020)
FossilOrigin-Name: 684f765df3e8a4836f254717d175a4a7b5e7d15f
2007-05-17 14:45:12 +00:00
danielk1977
f12737da7e Modify test scripts to allow for the fact that zeroblob() is not available when compiled with OMIT_INCRBLOB. Ticket #2365. (CVS 4019)
FossilOrigin-Name: 2ee959be4afa2cf05d183ff92a31dd1b5a84becf
2007-05-17 06:44:28 +00:00
danielk1977
a9c16b0a38 Fix handling of utf-16 encoding of code point 0xE000. (CVS 4017)
FossilOrigin-Name: bfc35ce8673ce51f726535b90c1d86be272848bb
2007-05-16 18:11:41 +00:00
drh
cd7b46db84 Keep the full precision of integers if possible when casting to "numeric".
Ticket #2364. (CVS 4012)

FossilOrigin-Name: 2ac985a38034da87b0fa3837976e1f2164b22672
2007-05-16 11:55:56 +00:00
drh
056c8f782e Additional tests for malformed UTF-8. (CVS 4011)
FossilOrigin-Name: 448d3ef670dce6d27c7d7b1be58088d45f8b6274
2007-05-15 18:35:21 +00:00
drh
7e326c09c2 Make sure pParse->rc gets set whenever sqlite3ErrorMsg() is called. This is
added insurance that parsing will stop quickly after an error.  This change
did make the parser stop faster in some cases, which required some revisions
to tests. (CVS 4010)

FossilOrigin-Name: f84d9dab110c4415d9b772f8043397640162b6b2
2007-05-15 16:51:37 +00:00
drh
9a087a99e5 Relax the restriction on using bytes 0x80 through 0xbf as the first
character of an identifier.  Enhancements to ALTER TABLE tests for
tables with strange names or stange column names. (CVS 4008)

FossilOrigin-Name: 262a3e6339b31f269f8f07e43d295b90827e2779
2007-05-15 14:34:32 +00:00
drh
eab7f3fe8d Do not allow bytes 0x80 through 0xBF to be the first character of an
identifer because no valid UTF-8 character can begin with those bytes.
If we allowed an identifier to begin with one of those bytes, then the
substr() function in ALTER TABLE will not work correctly. (CVS 4003)

FossilOrigin-Name: 252810424d8c4dcd19b369d62027094df7cf0bcc
2007-05-15 09:00:14 +00:00
danielk1977
1ee506d792 Fix some test script errors in fuzz.test. (CVS 4002)
FossilOrigin-Name: 51eeae7b7ad5a0fbdd9d4418120dbdb6cd577cd5
2007-05-15 07:14:32 +00:00
danielk1977
15d7982ad8 A fix for queries that used correlated, compound sub-queries in the HAVING clause. Also update fuzz.test some more. (CVS 4001)
FossilOrigin-Name: da0c1ab4deedd2b952a43b3af6962a9403f8c9ee
2007-05-15 07:00:34 +00:00
drh
4e5dd85135 Fix problems in ALTER TABLE that occur when column or table names are
invalid UTF encodings. (CVS 4000)

FossilOrigin-Name: 9ff382f4584ff685a78b39f24424319709efb382
2007-05-15 03:56:49 +00:00
drh
f764e6fc3d The built-in substr() function applied to a BLOB counts bytes, not characters. (CVS 3997)
FossilOrigin-Name: 75d573080d03ee48fe88710f70c6875ff9cae19c
2007-05-15 01:13:47 +00:00
drh
2a9abf61c7 Make sure the parser aborts quickly following a syntax error. (CVS 3996)
FossilOrigin-Name: d07cdd3c096c120d104ae13f7932c0a955324517
2007-05-15 00:09:13 +00:00
danielk1977
a670b22641 Fix a problem with ORDER BY and compound SELECT queries. (CVS 3995)
FossilOrigin-Name: af76928fc5891f9a222ac0c39f8b443a9707b9e3
2007-05-14 16:50:48 +00:00
danielk1977
fa2bb6da24 Fix a bug in "flattening" optimization. Occured if the parent of the flattened sub-query is also the parent of a sub-query that uses a compound op (i.e. UNION, INTERSECT etc.). (CVS 3994)
FossilOrigin-Name: 1c33829c9ebcf1ff1bd21b161c73a642471b613a
2007-05-14 15:49:43 +00:00
danielk1977
1e4eaeb515 Prevent sub-queries with "LIMIT 0" from leaving an extra value on the vdbe stack. Also updates to fuzz.test. (CVS 3993)
FossilOrigin-Name: b1d1b16e9857a1c05f60cf2ae15f5a534b0dd0ac
2007-05-14 14:04:59 +00:00
drh
4f07e5fbdf Remove terms with operator TK_AS from the expression tree. Ticket #2356. (CVS 3991)
FossilOrigin-Name: 5627ff74be9242418434a06fe5c104d1f9128cab
2007-05-14 11:34:46 +00:00
drh
84f31128b2 Make REINDEX robust in the face of malloc() errors. (CVS 3990)
FossilOrigin-Name: dbe417745d3d4ed875715ad7083d7345d1b6a56f
2007-05-12 15:00:14 +00:00
drh
cf1be45fe2 Make the ANALYZE command robust in the face of malloc() failures. (CVS 3989)
FossilOrigin-Name: c08658e1f8598941ebddddb98942b98cfcb86e7a
2007-05-12 12:08:51 +00:00
danielk1977
39c9604a02 Fix another variant of the "IN (...)" b-tree problem. (CVS 3988)
FossilOrigin-Name: 260338c4b2b18c9f4da8bc7fe3eda306dcaa4e38
2007-05-12 10:41:47 +00:00
danielk1977
4aeff62ee0 Fix an obscure b-tree bug that applied to transient trees used for IN(...) expressions. (CVS 3987)
FossilOrigin-Name: 96c7232f8b208cd1c50063f7946bb6dbc386abd6
2007-05-12 09:30:47 +00:00
danielk1977
1f7c83e286 Check in some changes to fuzz.test. Still failing. (CVS 3985)
FossilOrigin-Name: 6f346a6be9803b84260509352315f8fa1e820490
2007-05-11 16:58:03 +00:00
danielk1977
bcfc4bc769 Expand the expressions tested by fuzz.test. Fix for (CAST zeroblob() AS text). (CVS 3983)
FossilOrigin-Name: 4e1bb41f302c13095aa9c638e59ae11417f49682
2007-05-11 10:10:33 +00:00
danielk1977
d908f5ab7f Fix a problem with inserting zeroblob() into an indexed column. (CVS 3982)
FossilOrigin-Name: ccef5d2daaa5a88dd3f23666f022296ef42f9d73
2007-05-11 07:08:28 +00:00
drh
4e05c83bc3 Additional parsing bugs fixed. (CVS 3981)
FossilOrigin-Name: d12a8924c6083cdff14990b4fd036ca386c2e34a
2007-05-11 01:44:50 +00:00
drh
db83f8231f Make sure that the REGISTER token generates a valid Expr. REGISTER will
cause the tokenizer to abort, but the parser might do several reduce
actions prior to that abort and those reduce actions sometimes need a
valid Expr. (CVS 3980)

FossilOrigin-Name: d146f01a02579339c5dc86bbe59f246bd6c05c63
2007-05-11 00:20:08 +00:00
drh
e718efe113 When converting literal BLOBs to text using the encoding of the main
database.  Ticket #2349. (CVS 3975)

FossilOrigin-Name: a57afaff424448ffed8f2344e5eb461f503bfb6e
2007-05-10 21:14:03 +00:00
danielk1977
639f45ff06 Simplify failing case in fuzz.test. (CVS 3974)
FossilOrigin-Name: a54c74990caf22c0008a7029e24594e83048ffbc
2007-05-10 17:38:57 +00:00
danielk1977
f75232f748 Add cases to fuzz.test. Some tests in this file fail at the moment. (CVS 3973)
FossilOrigin-Name: 1e8fcb3fbed7beb8bb1370953ecf3d4b9db01ede
2007-05-10 17:32:48 +00:00
drh
53c1402157 Add some UTF-8 test infrastructure. Treat NaN as NULL. The printf routines
print infinity as "Inf" not as "NaN".  Ticket #2345. (CVS 3972)

FossilOrigin-Name: ffe615a71107a38b6f60c7baf4284a5b0aecdc22
2007-05-10 17:23:11 +00:00
danielk1977
def0fec8e0 Add new test file fuzz.test, to test SQLite with fuzzily generated SQL. (CVS 3971)
FossilOrigin-Name: 1e9e6fe75d01d8cf4e1a23505c45f28491f1e902
2007-05-10 15:37:52 +00:00
danielk1977
89a43bc588 Another test for overflow in strftime(). It was not broken. (CVS 3969)
FossilOrigin-Name: 5800d0327ebc122e679ef860b58098b3c08eb709
2007-05-10 11:43:53 +00:00
danielk1977
fc9760654a Add code to enforce the MAX_EXPR_DEPTH limit. (CVS 3968)
FossilOrigin-Name: 2c9c94a24d52a1c9f5d1b32cbdff794a2dd74126
2007-05-10 10:46:56 +00:00
drh
e305f43f17 Make sure compound queries inside a subquery only return a single result
column.  Ticket #2347. (CVS 3967)

FossilOrigin-Name: 66954bdd81dabfb60306de8480b5477a4acb1d9e
2007-05-09 22:56:39 +00:00
drh
b63f274589 Fix a problem with strange expressions being fed to an ATTACH or DETACH
statement. (CVS 3965)

FossilOrigin-Name: 0c91dc9ee0c5d441a7789b631476515260cb887f
2007-05-09 20:31:29 +00:00
danielk1977
de3bea7ba4 Fix an obscure cache corruption that could occur after an SQLITE_FULL error. (CVS 3964)
FossilOrigin-Name: e8e879aca67dee959bab42627028964c474da72f
2007-05-09 15:56:39 +00:00
danielk1977
832b2664e6 Add further test cases for compile time limits. (CVS 3963)
FossilOrigin-Name: 9bf2c594a48a4661700f0833562ee2b3ff7b761c
2007-05-09 11:37:22 +00:00
danielk1977
b56fe1ff27 Fix enforcement of the LIKE_PATTERN limit. (CVS 3962)
FossilOrigin-Name: 8819617b7cf7ccd64bf6bb4ba208f37126964ec2
2007-05-09 08:24:44 +00:00
danielk1977
7a15a4beef Add a few more tests to sqllimit1.test. (CVS 3954)
FossilOrigin-Name: eeee6b71e5643511320cbe15bafa170cfd02877f
2007-05-08 17:54:43 +00:00
danielk1977
428de1c03a Add a test case that uses a trigger to insert many rows to sqllimits1.test. (CVS 3953)
FossilOrigin-Name: 6368222558d00f968b49f862bfe672573e86fbcf
2007-05-08 16:13:45 +00:00
danielk1977
b0ab63cd8e Add new test file sqllimits1.test. (CVS 3952)
FossilOrigin-Name: c8974603976ebc02edbc9ab271e87e57f8eb365e
2007-05-08 15:59:05 +00:00
danielk1977
17374e8f94 Fix a potential buffer overrun in the replace() function. (CVS 3947)
FossilOrigin-Name: b0fb4a3cf6ddbc17ccd0c719b34a720d9090bc93
2007-05-08 14:39:04 +00:00
danielk1977
4b5710e486 Avoid evaluating (INT_MIN/-1) with 32 bit signed numbers. It can cause SIGFPE. (CVS 3945)
FossilOrigin-Name: 2f186e916c982cde557e0bc1b925b10e6d58f8a1
2007-05-08 13:57:34 +00:00
danielk1977
dce872b94e Do not crash in the internal functions sqlite_rename_table() or sqlite_rename_trigger() if they are somehow passed unexpected input. (CVS 3944)
FossilOrigin-Name: c2f90b465e37ea49c9e44415f6461e4f636bb64f
2007-05-08 12:37:45 +00:00
drh
c797d4dccd Begin implementing a new system of upper bounds on the capabilities
of SQLite.  By clearly defining the upper bounds, we make those
upper bounds explicitly testable.  This check-in is just infrastructure.
The upper bounds are not yet enforced. (CVS 3941)

FossilOrigin-Name: 93b623b232a43f78d2c90bfa2389dd5b28ad7280
2007-05-08 01:08:49 +00:00
drh
02d858364b Fix an NULL deref in the randomblob() function following a malloc failure. (CVS 3940)
FossilOrigin-Name: 011e7db253f9a60c19977215eab1687930f15637
2007-05-07 19:31:15 +00:00