1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-11 01:42:22 +03:00

19158 Commits

Author SHA1 Message Date
drh
6ff15d0c49 Prototypes for sqlite_encode_binary() and sqlite_decode_binary() added
to sqlite.h. (CVS 1296)

FossilOrigin-Name: 359f0e787ff2d4d10fd23059e2ce99670e93f66a
2004-03-14 22:12:34 +00:00
drh
6da834a8b4 Make sqlite_encode_binary() and sqlite_decode_binary() an official part of
the library. (CVS 1295)

FossilOrigin-Name: 786fe545560ec6c42bb0e344345031f425bf177a
2004-03-14 22:11:59 +00:00
drh
6e17529e97 Fix the min/max optimizer so that it works when the FROM clause is a
subquery.  Ticket #658. (CVS 1293)

FossilOrigin-Name: 31c94acc72d318b5dec0fef1485621943add45c8
2004-03-13 14:00:36 +00:00
drh
1a72d72a7f Typecast to work around a bug in {quote: CodeWarrior} Studio v9.1.
Ticket #654. (CVS 1292)

FossilOrigin-Name: 5864fc6937b933b7da0c00e6c4c2ee1b9b939cff
2004-03-10 18:57:31 +00:00
drh
a0c9a112de The BTree layer now returns SQLITE_READONLY on an attempt to open a write
cursor on a read-only database.  Previously, the failure would not occur
until there was an attempt to write to the cursor. (CVS 1289)

FossilOrigin-Name: 8a8be4687bf9fd88952b303f30f93aa6fed75b60
2004-03-10 13:42:37 +00:00
drh
06333689a7 The shell program now ignores extra whitespace at the end of dot-commands. (CVS 1288)
FossilOrigin-Name: b6817e99bd97f427b1cfd16328d612e1a7d70d0a
2004-03-09 13:37:45 +00:00
rdc
aa5707cd5e Correct duplicate tracing of SQL statements. (CVS 1284)
FossilOrigin-Name: bb67311b3db49ce772533da14f62497c55432fae
2004-03-04 19:09:20 +00:00
drh
79f14b7240 A vdbe stack element might have a string value even after a call to
Integerify().  Ticket #641. (CVS 1283)

FossilOrigin-Name: 3cac4b7b526d6c5dbf394009b534707bcb65b0da
2004-03-03 01:51:24 +00:00
drh
b1aa04fccc Make sure a LIMIT clause on a SELECT cleans up the vdbe stack so that if it
occurs inside a trigger, it won't cause a stack overflow.  Ticket #640. (CVS 1282)

FossilOrigin-Name: 5aaa2939baa972231def086ed5f9d9ba63302532
2004-03-02 18:37:41 +00:00
drh
0d131ab716 One more fix to the new HH:MM:SS modifier. This time add some test
procedures too. (CVS 1280)

FossilOrigin-Name: 7b3b8968ee9a5349dd6e9ae1e7a311bf8906607c
2004-02-29 01:08:17 +00:00
drh
b6829e94bd Try again to get the HH:MM:SS modifier change right... (CVS 1279)
FossilOrigin-Name: e20d51f94ed67b8864a435e5735f61f396662c21
2004-02-29 00:50:33 +00:00
drh
446536a089 Fix a bug in the HH:MM:SS modifier change that was just checked in. (CVS 1278)
FossilOrigin-Name: 248b5500900bc8f401006aaa9b7dac090ae419fa
2004-02-29 00:48:08 +00:00
drh
33a9ad2f8c Allow time modifiers of the form HH:MM:SS.SSS with an option "+" or "-"
prefix.  The specified amount of time is added into the date-time begin
modified. (CVS 1277)

FossilOrigin-Name: 559002a52fe3c42fe71ffce364eff4a036ae6b83
2004-02-29 00:40:32 +00:00
drh
3039c0a896 Fix some compiler warnings in LCC. The warnings did not indicate real
problems.  Ticket #634.  Not all warnings in ticket #634 were fixed. (CVS 1276)

FossilOrigin-Name: e97089b7df3e2fbfcf36062099d02ecb75e9a870
2004-02-29 00:11:30 +00:00
rdc
f146a77677 Add comments and prototype for experimental sqlite_last_statement_changes() API function. Also, allow function to be called from tcl. (CVS 1273)
FossilOrigin-Name: ca99920b0dbf773962b47766d690154fd1276513
2004-02-25 22:51:06 +00:00
drh
268380ca9e Min() and max() functions honor the distinction between TEXT and NUMERIC
data.  Ticket #623.  typeof() is now a user function.  Some tests are
now failing due to ticket #521. (CVS 1272)

FossilOrigin-Name: adbe31adf1ad0ca723203ca3d7dc480324c60d43
2004-02-25 13:47:31 +00:00
drh
d41d73d556 Fix the return type of sqliteRunVacuum. Ticket #627. (CVS 1271)
FossilOrigin-Name: 9c9f4a867a4ea708847cbb0839b7279eb33ecd7c
2004-02-25 02:33:34 +00:00
drh
f73287ceb0 Shell program saves command-line history on a ".quit". Ticket #614. (CVS 1270)
FossilOrigin-Name: 114b72f8608b8e08fad863a1446fb1ef59610efd
2004-02-25 02:25:37 +00:00
drh
946966f2a1 Disable an assert which (as it turns out) is not always true. Ticket #615. (CVS 1269)
FossilOrigin-Name: 2773c1d384b750eee037e6ccc61bc56b5204d690
2004-02-25 02:20:41 +00:00
drh
cd44690ad0 Refactor parts of write operations. (CVS 1268)
FossilOrigin-Name: 5b0147aece7785373e6f7439c32e5f58c6b12562
2004-02-24 01:05:31 +00:00
drh
02f75f19e5 Make sure BEGIN, COMMIT, and ROLLBACK are really no-ops when preceded
by EXPLAIN.  Ticket #626. (CVS 1267)

FossilOrigin-Name: 2af1f065b5eb39fd3ecac00f8a66d1b4186aead5
2004-02-24 01:04:11 +00:00
drh
701a0aebe2 Use sqliteVdbeOp3 instead of sqliteVdbeChangeP3 where applicable. (CVS 1266)
FossilOrigin-Name: 51f1e8f7539596b33bc3365ec8f34041602d049c
2004-02-22 20:05:00 +00:00
drh
d383401c6a Code cleanup in build.c. (CVS 1265)
FossilOrigin-Name: 9211e14cf81f4de125bad246d8a289786f2854aa
2004-02-22 18:56:49 +00:00
drh
f7a9e1ac87 Use sqliteErrorMsg instead of sqliteSetString whereever practical. (CVS 1264)
FossilOrigin-Name: 69aac043af7f93e7b3f036622c0ac9261cae1839
2004-02-22 18:40:56 +00:00
drh
eb9a9e8888 Code cleanup in the date and time functions. (CVS 1263)
FossilOrigin-Name: 9b3bcde1530091602e551435ffd7820eb79727d5
2004-02-22 17:49:32 +00:00
drh
2d3917da29 Rearrange the grammar some so that tokens that are used together appear
together in the grammar file.  This reduces the size of the parser tables
and some of the jump tables in switch statements. (CVS 1262)

FossilOrigin-Name: d372c16ec6621dbab371bff7f1803ca096862984
2004-02-22 16:27:00 +00:00
drh
b621c23775 Test cases for printf of double overflows. (CVS 1260)
FossilOrigin-Name: 96a6d2d3ff5bd0aaff188ee1c5e2f02cbea435b2
2004-02-21 19:41:04 +00:00
drh
3e7bc9ca1c Fix a long-standing memory leak that the new last_insert_rowid() tests
brought to light. (CVS 1259)

FossilOrigin-Name: 7d5ede5b6ef515808995d4631f8d19aca95a9105
2004-02-21 19:17:17 +00:00
drh
5f968436e6 Cleanup the printf code to make it smaller and more modular.
Fix a memory leak in the new OP_ContextPush opcode. (CVS 1258)

FossilOrigin-Name: 2756f7af3382fa9d186ab99cf76f469fb891a3c3
2004-02-21 19:02:30 +00:00
drh
8722318f3c Flag pragmas like vdbe_trace now return their current setting if they
are called with no arguments. (CVS 1257)

FossilOrigin-Name: 6a5fb5b89a98307060bb4a92a499b5d3dba74553
2004-02-21 14:00:29 +00:00
drh
905793e249 More code cleanup and size reduction. (CVS 1256)
FossilOrigin-Name: 8e3eda2a909bd80b2b14ace36ab44303750a4409
2004-02-21 13:31:09 +00:00
drh
8eb2cce55c Enhance date/time functions to work with negative years. Ticket #617. (CVS 1255)
FossilOrigin-Name: ffa971934867b6bbe943c004154d5f161e0ea697
2004-02-21 03:28:18 +00:00
drh
8307ac7521 Turn the short_column_names pragma off by default - for the time being. (CVS 1254)
FossilOrigin-Name: 6954d2c3240459842be655b600c6b160e918e74a
2004-02-20 23:34:07 +00:00
rdc
b0c374ffbb Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1251)
FossilOrigin-Name: 3383413a53bff0fef0765144de3bb9a298a5bb5c
2004-02-20 22:53:38 +00:00
drh
fcabd4641e The name of a result column is now the name of column it originated from, by
default.  This can be turned off with PRAGMA short_column_names=OFF.  This
is to be more like PostgreSQL.  More testing needed. (CVS 1250)

FossilOrigin-Name: 574dd444e7ff00e0fccc3436fe617ad832daae40
2004-02-20 14:50:58 +00:00
drh
9cbe7ca7db Fix a memory leak that occurs if you call sqlite_interrupt() on a query
using aggregate functions where the aggregate function returns a string
longer than 32 characters. (CVS 1248)

FossilOrigin-Name: 2c1e74e58a702fd2be954467a12e69a33b252831
2004-02-18 16:57:23 +00:00
drh
d6502758b4 Remove the NullCallback opcode. Handle the empty_result_set pragma inside
the sqlite_exec() function. (CVS 1244)

FossilOrigin-Name: f72134852bf33d13fd2bc6f35251e4b33bc10fac
2004-02-16 03:44:01 +00:00
drh
826fb5a3f8 Eliminate obsolete code associated with the older callback functionality. (CVS 1243)
FossilOrigin-Name: 2dbc4593ca5c1cf75039c8b4471b1e47faa849f0
2004-02-14 23:59:57 +00:00
drh
1d85d93158 Eliminate the use of callbacks during schema initialization. (CVS 1242)
FossilOrigin-Name: af5c2be4aed1c50f69eb9634cf051a26263dcf51
2004-02-14 23:05:52 +00:00
drh
8a6ac0adbc Fix problems with malloc-failure handling. (CVS 1241)
FossilOrigin-Name: 398bc294c839368e7fa75a97ba8cc8d1639f9436
2004-02-14 17:35:07 +00:00
drh
a1f9b5ee0b The sqlite_exec() function is now implemented using sqlite_compile() and
sqlite_step().  This opens up lots of opportunity to remove old code. (CVS 1240)

FossilOrigin-Name: 9771ad1e811e02e10bb738550fbea447749083c5
2004-02-14 16:31:02 +00:00
drh
eceae45cb5 Fix an uninitialized variable in shell.c that would cause a crash if you
specified SQL on the command-line. (CVS 1238)

FossilOrigin-Name: 5a56090dde10ee29863021356d21c3f8c86e3f46
2004-02-13 20:09:41 +00:00
drh
e72daeb0ac Begin the process over converting sqlite_exec() over to use sqlite_compile()
and sqlite_step().  The new sqlite_exec() is still commented out. (CVS 1237)

FossilOrigin-Name: b8f2ba7880b761e380b95ae63d8ab721f018443e
2004-02-13 16:30:09 +00:00
drh
50350a15c4 Fix a bug in the query flattener when trying to find the datatype of the
rowid of a view.  Also fix a problem with sqlite_compile() and authorization
failures. (CVS 1236)

FossilOrigin-Name: aa0490ccd4a820a707dfb4905e67c01ffb4f758b
2004-02-13 16:22:22 +00:00
drh
78a7583828 Fix an uninitialized variable introduced by check-in (1202). (CVS 1235)
FossilOrigin-Name: 9f149fdc1c6af1c663b91c878ed1903f82f80245
2004-02-13 14:07:12 +00:00
drh
e384a4ed4e Add a new parameter to the (unimplemented) encryption API. (CVS 1234)
FossilOrigin-Name: 5fe8f02306cf1c0af2148835cee0df3003ad0874
2004-02-12 20:49:36 +00:00
drh
c602f9ae01 Add the SQLITE_NOTADB return code for cases when you try to open a file
that does not even remotely resemble an SQLite database file. (CVS 1233)

FossilOrigin-Name: 0c77cee70f078152969933c1d340cea1c86286b0
2004-02-12 19:01:04 +00:00
drh
4d189ca48f Add hooks on each attached database connection for storing auxiliary
information.  Add the USING clause to ATTACH. (CVS 1232)

FossilOrigin-Name: 800c11f4bce014a07110eb539992a609e6418406
2004-02-12 18:46:38 +00:00
drh
3054efee07 All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231)
FossilOrigin-Name: a6b862a9db6d409a53cc13e7008b27d4848b5509
2004-02-12 17:28:13 +00:00
drh
70a931c2ac Remove unused variable. (CVS 1230)
FossilOrigin-Name: 74b234264ba2910ebd38e7b7ebbc369108a235cb
2004-02-12 15:32:53 +00:00