7ec764a29e
Add comments to test cases. Improvements to the query plan test variable. (CVS 2555)
...
FossilOrigin-Name: ef3a157f469d72cbd2f713f997598ddf47f340d2
2005-07-21 03:48:20 +00:00
fe05af87f8
In where.c, split out the code that selects an index into a separate
...
subroutine. (CVS 2554)
FossilOrigin-Name: c30cbba9ead1b4d07f225b1e8a65d5d5230ea45d
2005-07-21 03:14:59 +00:00
0aa74edd72
Allow an unlimited number of terms in the WHERE clause. The old limit was 100. (CVS 2550)
...
FossilOrigin-Name: ca69f36832d57775e73ac5cdbe0a32d7b759432b
2005-07-16 13:33:20 +00:00
9042f395cc
Fix bugs in the new query plan instrumention logic. (CVS 2549)
...
FossilOrigin-Name: 578490c91331a386f84652db0b3bfd74c82046e1
2005-07-15 23:24:23 +00:00
a4afb65cb7
Make sure there is only one busy counter. Ticket #1315 . (CVS 2543)
...
FossilOrigin-Name: af2a0ba4a38abf208db1ff6f018cf756de2afd5b
2005-07-09 02:16:02 +00:00
57dbd7b324
Allow the IN operator to take a list of arbitrary expressions on its
...
right-hand side. The expressions no longer need to be constant. The
current implementation seems to work but needs more testing and optimization. (CVS 2542)
FossilOrigin-Name: ba56478dd8bc2135749966ff55831fd497883781
2005-07-08 18:25:26 +00:00
9170dd7e1c
Change the name of the OpenTemp opcode to OpenVirtual which is more
...
descriptive of what it does. (CVS 2541)
FossilOrigin-Name: 3bb9ce5f20d0a6bc19df31df9b8e82044c3e6004
2005-07-08 17:13:46 +00:00
70031fa396
Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539)
...
FossilOrigin-Name: b72bff81f9937378417a0af0610d8558279b67a7
2005-07-08 13:53:21 +00:00
d1e4733d07
Tcl interface uses Tcl_Objs to implement user-defined functions, thus allowing
...
BLOB values to be transferred correctly. Ticket #1304 . (CVS 2530)
FossilOrigin-Name: 514aaab3f99637ebb8b6e352f4e29738102579b4
2005-06-26 17:55:33 +00:00
df0bddaef3
The TCL interface binds variables as BLOB only if they have a bytearray
...
representation but no text representation. Ticket #1287 . (CVS 2528)
FossilOrigin-Name: 8c99dca60aebee0ec5de9ed11350de864bc76584
2005-06-25 19:31:48 +00:00
487e262f44
Remove the blob(), text() and numeric() functions added in (2524) and
...
replace them with the standard CAST operator.
Ticket #1287 . (CVS 2527)
FossilOrigin-Name: 17631785f9ee8ab280c82677eb53886912e085bc
2005-06-25 18:42:14 +00:00
7f057c9166
NULL values in a row of a unique index cause the row to be distinct.
...
Ticket #1301 . More testing and optimization needs to be done on this
before closing the ticket. (CVS 2526)
FossilOrigin-Name: 06a71b162b032fc5b56d18919a784d4ee94dde7c
2005-06-24 03:53:06 +00:00
5708d2deac
Add built-in functions numeric(), text(), and blob() that coerce types.
...
Ticket #1287 . (CVS 2524)
FossilOrigin-Name: affb0fa2e8c5ff497838ba3c2994cdb1f6f50c68
2005-06-22 10:53:59 +00:00
288d37f1b4
Allow parameters to be introduced by characters ':', '$' and '#'. This
...
is an experimental change. (CVS 2523)
FossilOrigin-Name: f3427a139c3bd4faf9134ec6290b3eb829c0a19f
2005-06-22 08:48:06 +00:00
78776ecdb1
Do not record existance the sqlite_sequence table until it is actually
...
created. Ticket #1283 . (CVS 2513)
FossilOrigin-Name: 95256d953c179372dcc5ead6c407672c8161a8c1
2005-06-14 02:12:46 +00:00
af6df11f8a
Add tests to make sure statement journals are only opened when necessary. (CVS 2500)
...
FossilOrigin-Name: 914d6e6549446a6ddf25e5da57d2fe9446750625
2005-06-07 02:12:30 +00:00
ed8a3bb108
Reference count Table structures so that they are not deallocated too soon.
...
Ticket #1210 . (CVS 2498)
FossilOrigin-Name: e73d25c7419d580c47925494621df26d2fb9f27e
2005-06-06 21:19:56 +00:00
473d179d8a
Return SQLITE_MISUSE when passing a NULL pointer into sqlite3_bind routines.
...
Ticket #1219 . (CVS 2497)
FossilOrigin-Name: 12c32f139bae3cb7ca520451bfc15f9f7d94833d
2005-06-06 17:54:55 +00:00
ba0232a0df
Any non-zero value is considered TRUE in a WHERE clause. Ticket #1211 . (CVS 2496)
...
FossilOrigin-Name: 0f7af623791d8d2ed35c3978ab12316912d9b6f8
2005-06-06 17:27:19 +00:00
873fac0cae
Avoid ambiguous column name errors when the column name is in the USING clause
...
of a join. Ticket #743 . (CVS 2495)
FossilOrigin-Name: 6a51bdeeff8312fa54fa2b1200f823428f35d605
2005-06-06 17:11:46 +00:00
355ef36114
Naming the join columns in the result set of a natural join does not result
...
in an "ambiguous column name" error. Ticket #1217 . (CVS 2494)
FossilOrigin-Name: 265fb6079c0a4b7a93f063939436db494ff1d56c
2005-06-06 16:59:24 +00:00
7c3d64f151
Do not allow parameters in VIEW definitions. Ticket #1270 . (CVS 2492)
...
FossilOrigin-Name: 0d46289f02aad526f462a3ceceb1bca1b9f6a543
2005-06-06 15:32:08 +00:00
defc997230
Fix a bug in the malloc2 tests introduced by checkin (2473). (CVS 2489)
...
FossilOrigin-Name: fafaa18eea1e7142e1094b5f6d544d20c9df7c0f
2005-06-06 14:45:42 +00:00
a38b4134e7
Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488)
...
FossilOrigin-Name: 6bc372978364a1a4bfa14732a818a6bba613b1e3
2005-05-29 14:23:12 +00:00
44ee5bf795
Minor changes to help build and test SSE. (CVS 2487)
...
FossilOrigin-Name: 3ac4a212bd70abb94d24830c73f7121df51125c7
2005-05-27 09:41:12 +00:00
3e1d8e6356
Add an experimental sqlite3_get_autocommit() API used to test whether or not
...
changes are committed automatically. (CVS 2486)
FossilOrigin-Name: 4a7f1275857602e3841ccb2d43a5c4d3d3e87bff
2005-05-26 16:23:34 +00:00
105afed6a0
Add a -cleanup option to Tcl test proc do_ioerr_test. (CVS 2485)
...
FossilOrigin-Name: b0a898c05a2285c87d7da4d47dd697c58a0d4d58
2005-05-26 15:20:53 +00:00
15ccce1c0d
Make sure that the use of a double-quoted string literal does not trick
...
the optimizer into using a correlated subquery when a static
subquery would suffice. (CVS 2477)
FossilOrigin-Name: ef4059e3afa1a61a9e59df00cdfedc57d8df9fec
2005-05-23 15:06:39 +00:00
eb43e5c7b7
The cache_size pragma should not reset the synchronous pragma. Ticket #1260 . (CVS 2474)
...
FossilOrigin-Name: 2db2b32f269062b006ae5c4a302d116cdab8f9ec
2005-05-22 20:30:39 +00:00
1c7880e501
Do not allow the pagesize of :memory: databases to be changed. Silently
...
ignore PRAGMA page_size=N requests for :memory: databases.
Ticket #1144 and #1252 . (CVS 2466)
FossilOrigin-Name: f29a1d882623d8ff14f35a302aef63a16388bcb3
2005-05-20 20:01:55 +00:00
0405a34d11
Fix a datatype in trigger6.test that changed due to the previous check-in. (CVS 2454)
...
FossilOrigin-Name: c2af7d2c947bcec507087cc3a1e5b21e6322e4cd
2005-05-05 11:04:50 +00:00
c7f269d551
In the TCL interface, user-defined functions preserve the datatype returned
...
by the Tcl procedure. (CVS 2453)
FossilOrigin-Name: 99dcba1fb1fdaa2b8bc85046b00c14f6af596e8f
2005-05-05 10:30:29 +00:00
7e62779a58
Prevent a segfault described by ticket #1229 . (CVS 2450)
...
FossilOrigin-Name: 0667eae9a97059125a77bd90452d19dc17c30a12
2005-04-29 02:10:00 +00:00
f8db1bc03b
Remove some vestigal code. Add the experimental sqlite3_transfer_bindings()
...
API. (CVS 2446)
FossilOrigin-Name: 88b39436f00d645cdb6333a7413c698c42227d3f
2005-04-22 02:38:37 +00:00
b47d45ccbf
Correctly store large integers. Ticket #1212 . (CVS 2445)
...
FossilOrigin-Name: 00e20690bb8cc6522c9c48f36f0c3336ae007827
2005-04-15 12:04:34 +00:00
c7e22ee254
Added tests to exercise delete, insert, and update triggers on views (tkt #1169 ) (CVS 2444)
...
FossilOrigin-Name: 6cd19ddcba5fbea1be04b44699c911294618e948
2005-04-08 19:48:27 +00:00
55c45f2e1e
Apply Tcl 'nullvalue' patch from Stefan Finzel. (CVS 2441)
...
FossilOrigin-Name: 9906ae37b9be684b615a1190cf8798513baa799a
2005-04-03 23:54:43 +00:00
495c09a49a
Make the ORDER BY clause return equal elements in the same order they were
...
seen (a stable sort). It was returning them in exactly the reverse order. (CVS 2439)
FossilOrigin-Name: e8391491a68018406e30c2a699a4cab9e0de092c
2005-04-01 10:47:40 +00:00
f4f8fd51e4
Make sure integer primary keys larger than 2^31 are handled
...
properly. Ticket #1188 . (CVS 2436)
FossilOrigin-Name: 1d04c2ab299430959b8a193d4679cbc4c0be31a4
2005-03-31 18:40:04 +00:00
bc04f8529d
Reduce the space allocated for the runtime virtual machine stack. (CVS 2428)
...
FossilOrigin-Name: 7d6818da33a87076d1faf35ffc15a3aada0533b3
2005-03-29 08:26:13 +00:00
53c0f7480b
Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427)
...
FossilOrigin-Name: c41d55443c2dd532147962b87f542fb7d37075fd
2005-03-29 03:10:59 +00:00
92fd9d285f
Changes to alter3.test to allow it to work with a codec. (CVS 2423)
...
FossilOrigin-Name: 9e856bab2bbb77004b049827b4a275aa6c48096b
2005-03-28 16:50:22 +00:00
f0b5792bdc
Use SQL function substr() correctly from ALTER TABLE code. Ticket #1182 . (CVS 2420)
...
FossilOrigin-Name: ccb9f4022b3ccb1cc2ab001628fd38becfbf8efe
2005-03-28 00:07:16 +00:00
b3a2cced6b
Correctly allocate new columns array in ALTER TABLE .. ADD COLUMN. Ticket #1183 . (CVS 2419)
...
FossilOrigin-Name: 3c86e63389b286a49106d8d7009cc63e3914d40f
2005-03-27 01:56:30 +00:00
6b456a2b46
Add function to recover from a malloc() failure. (CVS 2414)
...
FossilOrigin-Name: 1f9d10d7965c95d1e35f64cf4c3f128adabd41f2
2005-03-21 04:04:02 +00:00
38fba69135
Fix an infinite loop in the code generator for INSERT. Ticket #1140 . (CVS 2410)
...
FossilOrigin-Name: 876d09d9145775956913e975c29e81d7553839ac
2005-03-21 01:20:58 +00:00
4cb29b4cfc
Allow the character "T" between date and time in ISO-8601 date/time formats.
...
Ticket #1170 . (CVS 2408)
FossilOrigin-Name: 2bf88daa57b01216c7bbe67972f479ee12be1193
2005-03-21 00:43:44 +00:00
ab34b8f65a
Fix for ticket #1167 (CVS 2405)
...
FossilOrigin-Name: d9aa0aa9ae2ca0dec976ba2ae4cd7047132be45b
2005-03-20 23:18:57 +00:00
8aa60cb746
Do not attempt to read the journal file on windows because manditory locking
...
on windows will not allow it. Ticket #1166 . (CVS 2404)
FossilOrigin-Name: 1865e0d81c827cc879dde96c6a9f42e740b6a560
2005-03-20 22:54:56 +00:00
41712ef171
Tentative fix for ticket #1171 . More research and testing needed. (CVS 2402)
...
FossilOrigin-Name: f0a39cee78472b93cce5304fc255285ddea7d2bf
2005-03-20 19:10:12 +00:00
