database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
30,215 Commits 1,570 Branches 183 Tags
tcl-init
Commit Graph

2168 Commits

Author SHA1 Message Date
drh
a9e99aee95 Make the distinction between text and numeric data. (CVS 710) 
FossilOrigin-Name: 310ac4fbaf0ed63f98bfacb55259960be03b0c8b
 2002-08-13 23:02:57 +00:00
drh
f1351b6759 Fix for ticket #124: Fix a stack VDBE overflow problem on joins on an 
INTEGER PRIMARY KEY. (CVS 700)

FossilOrigin-Name: fe329e078fa209faf62e08599a00c7efa75b8501
 2002-07-31 19:50:26 +00:00
drh
62160e798c Fix for ticket #71: Correctly handle CR and CRLF line terminators in the 
input files for the COPY command. (CVS 694)

FossilOrigin-Name: be1315755ef801b5ec07f469134e0d33a3ece990
 2002-07-30 17:20:40 +00:00
drh
491791a827 Fix for ticket #107: Fix a design defect in indices that was causing queries 
to fail when using an index on a column containing an empty string.  This
fix is an incompatible file-format change. (CVS 681)

FossilOrigin-Name: 20d152fcddb4fa53556a9c93c7a869600a7c5183
 2002-07-18 00:34:09 +00:00
drh
38640e15af All the code is now in place for SQLite to distinguish between NUMERIC and 
TEXT datatypes.  Still need to turn on the new code and test it. (CVS 659)

FossilOrigin-Name: b4737a16c997a6c139d616211fb6bc4b0fae181c
 2002-07-05 21:42:36 +00:00
drh
a9f9d1c08b Add a few more tests and fix a few bugs that the tests uncovered. (CVS 652) 
FossilOrigin-Name: 91c0db66c86facb21b5b522afadd83d91a488256
 2002-06-29 02:20:08 +00:00
drh
83dcb1ad37 Fix for ticket #84: If the WHERE clause is too complex, issue an error message 
and refuse to do the SELECT.  The cutoff is a WHERE clause with 100 terms. (CVS 650)

FossilOrigin-Name: c07e493b62125e85eaea36b6945f1e146e2792b8
 2002-06-28 01:02:38 +00:00
drh
b13632063d The datatype of the i-th column in the result set is given by the 
azColName(argc+1+i) parameter to the callback. (CVS 647)

FossilOrigin-Name: bdb006b809feb0f29342eb5138c0884d34e95599
 2002-06-26 02:45:03 +00:00
drh
2150432e7c Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in 
addition to the main database file. (CVS 642)

FossilOrigin-Name: 52eba4de301121f254174b74042015bf6069ef11
 2002-06-25 13:16:02 +00:00
drh
e0bc4048a0 Added support for the "sqlite_temp_master" table. Increased the version 
number to 2.5.2. (CVS 640)

FossilOrigin-Name: 9c1432bf7485258e485bd652e3acdaeabbfe8850
 2002-06-25 01:09:11 +00:00
drh
d11d382c99 Fix for bugs #77 and #80: Rework the LIMIT mechanism to be reentrant and to 
clean up the VDBE stack properly. (CVS 636)

FossilOrigin-Name: 9d5523107937e3700c76666fb058694babdd672c
 2002-06-21 23:01:49 +00:00
drh
c9b84a1fb1 This patch contains the beginnings of the data-typing infrastructure. 
The new build-in TypeOf() function is added.  New opcodes for doing
pure text comparisons are added.  Most changes are disabled pending
the 2.6.0 release. (CVS 632)

FossilOrigin-Name: cbbc858d973c2d515c6a2464981316549a241b73
 2002-06-20 11:36:48 +00:00
drh
df199a25bd Make the LIMIT clause work even if the destination of the SELECT is 
something other than a callback.  (Ticket #66) (CVS 619)

FossilOrigin-Name: 699cf362083043615eb88635a228bfa46a315c9c
 2002-06-14 22:38:41 +00:00
danielk1977
6f34903e85 Add RAISE() function, which allows more advanced flow-control in trigger programs (ticket #55) (CVS 614) 
FossilOrigin-Name: d4a2fb10067203a0d49317db747759872e62927e
 2002-06-11 02:25:40 +00:00
drh
d99f70680f Add optimizations for the IN operator in WHERE clauses. This is a partial 
implementation of enhancement #63.  Still need to add test cases. (CVS 610)

FossilOrigin-Name: 8481e841ebdeabe07bf780246bda1aa053eb60b7
 2002-06-08 23:25:08 +00:00
drh
5df72a5ad6 Fix for ticket #62: Do not report an SQLITE_READONLY error until the application 
actually tries to write data into a readonly file.  It is OK to start a
transaction on a read-only file, and doing so will get you a read lock.  This
change allows TEMP tables to be read/write even though the main database is
readonly. (CVS 607)

FossilOrigin-Name: 9ef795d1d756a404d2123ebc19df1985b19c9888
 2002-06-06 23:16:05 +00:00
drh
1288c9561d Multiplying NULL by zero gives NULL, not zero. I misread the test data 
and coded it wrong.  This check-in fixes the problem. (CVS 601)

FossilOrigin-Name: df9cc852ad02dbec5558d3915a0303f7e7b79b2b
 2002-06-01 21:41:10 +00:00
drh
f570f011eb Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION. 
Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison
is considered false, not NULL.  With these changes, NULLs in SQLite now work
the same as in PostgreSQL and in Oracle. (CVS 600)

FossilOrigin-Name: da61aa1d238539dff9c43fd9f464d311e28d669f
 2002-05-31 15:51:25 +00:00
drh
bb113518f9 Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) 
FossilOrigin-Name: 0e268d0c0faa02c3f95e1567cf631b7a04bfbdf0
 2002-05-27 01:04:51 +00:00
drh
f5905aa7be NULL values are distinct. A comparison involving a NULL is always false. 
Operations on a NULL value yield a NULL result.  This change makes SQLite
operate more like the SQL spec, but it may break existing applications that
assumed the old behavior.  All the old tests pass but we still need to add
new tests to better verify the new behavior.  Fix for ticket #44. (CVS 589)

FossilOrigin-Name: 9051173742f1b0e15a809d12a0c9c98fd2c4614d
 2002-05-26 20:54:33 +00:00
drh
ad2d8307ac Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join 
syntax. The basic functionality is there but there is still a lot of testing
to do. (CVS 587)

FossilOrigin-Name: 99bd1f5b9a1a20bfeefe15c00d96a34a5f40923e
 2002-05-24 20:31:36 +00:00
drh
ad3cab52fe Split the IdList structure into IdList and SrcList. SrcList is used to 
represent a FROM clause and IdList is used for everything else.  This change
allows SrcList to grow to support outer joins without burdening the other
uses of IdList. (CVS 584)

FossilOrigin-Name: a167b71d8c27e870bc3079c6132e483bffc83298
 2002-05-24 02:04:32 +00:00
drh
bd5a451d5d Change the names of the PushList and PopList opcodes to ListPush and ListPop 
so that they will appear together with the other List opcodes in the
documentation. (CVS 583)

FossilOrigin-Name: c53b0b9283c5c34def87d58b03fd979d03dc0890
 2002-05-23 22:07:02 +00:00
drh
e4697f5e90 Fix some places where a malloc() failure would lead to a segfault. (CVS 580) 
FossilOrigin-Name: 01ad352c3c82a86d9c94010cbc85d098b8fbc08a
 2002-05-23 02:09:03 +00:00
danielk1977
f29ce55958 Style fixes to triggers code in various *.c files (partial fix to ticket #39) (CVS 571) 
FossilOrigin-Name: 8a4195c7466962291a296e8f53034ea8cb25005f
 2002-05-19 23:43:12 +00:00
drh
9adf9ac4e4 Remove all tabs from the beginning of source code lines. Replace tabs with 
the appropriate number of spaces. (CVS 565)

FossilOrigin-Name: 690f9a163173c4c7af7e8e92e942cee4184c7974
 2002-05-15 11:44:13 +00:00
danielk1977
c3f9bad209 Added FOR EACH ROW triggers functionality (CVS 562) 
FossilOrigin-Name: 794bf67b6b36fce8854d5daff12f21dbb943240c
 2002-05-15 08:30:12 +00:00
drh
c22bd47d55 Improvements to the SQLITE_MISUSE detection logic. Also added test cases 
for this logic, including the new test file "misuse.test". (CVS 559)

FossilOrigin-Name: f42907ce457e012592f8c043dc6c915e87258b35
 2002-05-10 13:14:07 +00:00
drh
247be43d60 Attempt to detect when two or more threads try to use the same database at 
the same time and return an SQLITE_MISUSE error.  Also return this error
if an attempt is made to use a closed database. (CVS 558)

FossilOrigin-Name: a05fabd2df1cb38c555a7b2f31b0ca687db500c2
 2002-05-10 05:44:55 +00:00
drh
0ac6589202 Fix for ticket #1: Implement the GLOB and LIKE operators as functions that 
can be overridden.  This way, a developer can change the LIKE operator to
be case sensitive, for example. (CVS 537)

FossilOrigin-Name: 51572bf71774d7631c7083be90b806e621bc9bee
 2002-04-20 14:24:41 +00:00
drh
c8d30ac109 Fix for bug #15: Add the sqlite_changes() API function for retrieving the 
number of rows that changed in the previous operation. (CVS 526)

FossilOrigin-Name: 6e71493b9dc77d508c3ce90562766789e87e6d80
 2002-04-12 10:08:59 +00:00
drh
fe1a1773a8 Fix for bug #10: Pop the stack by the right amount on an IGNORE so that the 
stack does not grow without bound. (CVS 523)

FossilOrigin-Name: f46acfc3b828620e4e97b09f9aff119b9313e5d7
 2002-04-09 03:15:06 +00:00
drh
5efc18b6da Fix for bug #7: Correctly display the P3 operand in a VDBE trace when the 
operand is really a pointer to a structure. (CVS 512)

FossilOrigin-Name: 734dde765b38d61feaa5520e6481c77022367892
 2002-04-02 01:44:50 +00:00
drh
f2d74ffb74 Fix an uninitialized variable in AggReset() (CVS 432) 
FossilOrigin-Name: 3dcdeae7f620736c1eae52ad78db1efb886ea9c3
 2002-03-18 13:03:54 +00:00
drh
7218ac7098 Bug fix: updates within a transaction would fail if there was existed 
a temporary table. (CVS 425)

FossilOrigin-Name: 02cc2d60b2a5ee50efdbd90df90810ba559a453f
 2002-03-10 21:21:00 +00:00
drh
cd61c2816f Added the default_cache_size and default_synchronous pragmas. Added additional 
tests for pragmas.  Added a new speedtest script. (CVS 421)

FossilOrigin-Name: 161c0c5f5db66815e4345c9b5f7a600c03a67475
 2002-03-06 22:01:34 +00:00
drh
e684090012 Optimizations to the processing of integer comparisons. (CVS 420) 
FossilOrigin-Name: b7a7dae919be0e4c35b1fe8cb24fa7359a4b1200
 2002-03-06 03:08:25 +00:00
drh
603240cf5d Add the ability to turn of calls to fsync() using the "synchronous" pragma. 
Increased the default cache size from 100 to 2000 and made the "cache_size"
pragma persistent. (CVS 418)

FossilOrigin-Name: 414da4af1f4aebc3936ca339fbc7932add081912
 2002-03-05 01:11:12 +00:00
drh
1b2e032999 Bug fixes and additional tests for the subquery flattener. (CVS 411) 
FossilOrigin-Name: 2c05389eda391e38894fc6969e29766df82a8fec
 2002-03-03 02:49:51 +00:00
drh
653bc75992 Remove unused opcodes from the VDBE and fix a bug in the substr() function. (CVS 405) 
FossilOrigin-Name: e8611e0c052ddac477f83df485fa5dc882593de0
 2002-02-28 03:31:10 +00:00
drh
89425d5e02 The new function code passes regression tests. (CVS 403) 
FossilOrigin-Name: b00cf110b1cc671b7200a5ce8b9e704f660763c9
 2002-02-28 03:04:48 +00:00
drh
f55f25f02f Fix the coredump. There are still problems in the test suite though. (CVS 402) 
FossilOrigin-Name: 6af10cc53acc1ffa60de3f0d5880a6b72815404c
 2002-02-28 01:46:11 +00:00
drh
0bce8354b4 Completely remove the old SQL function system and replace it with the 
new user functions.  The code currently compiles but it coredumps on the
test suite.  Do not use in its present state. (CVS 400)

FossilOrigin-Name: 50797fee5066ec9ea23b720e5ab7e8fc8ccc1988
 2002-02-28 00:41:10 +00:00
drh
dd5baa95e8 Try to reduce the number of malloc() for user-defined functions. Begin 
transfering built-in functions over to the user-define function
mechanism. (CVS 399)

FossilOrigin-Name: c4f9e017b449d4036fa8d2bf77b931d4c31d74f7
 2002-02-27 19:50:59 +00:00
drh
1350b030c1 Revise the API for user-defined functions. (CVS 398) 
FossilOrigin-Name: 633951f0fa11c91f93aa2862df84691750c01e73
 2002-02-27 19:00:20 +00:00
drh
e5095355d6 Code for user-defined aggregates added. Legacy tests all pass but there 
has been no testing of the new user-defined aggregate code. (CVS 392)

FossilOrigin-Name: 1e037eb303d8508cb2ea3418e71b03315d895fbd
 2002-02-24 03:25:14 +00:00
drh
8e0a2f903a Added support for user-defined normal functions. Support for user-defined 
aggregates is pending. (CVS 390)

FossilOrigin-Name: c490a1ff951c5d4a2de8e4f8d349189bfaef7f74
 2002-02-23 23:45:45 +00:00
drh
17f7193434 Change the SQLITE_MASTER format to version 2 in preparation for adding views. (CVS 386) 
FossilOrigin-Name: b2a9807fed544e83002366149b9a363759338c5d
 2002-02-21 12:01:27 +00:00
drh
5cf8e8c7fa New ROWIDs are numbered sequentially. (CVS 383) 
FossilOrigin-Name: 1686196a8aea326f616bc8205df99cd84d955ec4
 2002-02-19 22:42:05 +00:00
drh
9562b55115 Optimize simple min() and max() queries. (CVS 382) 
FossilOrigin-Name: cc5abfe392bdb8c3ed00e0610bc2b41851bfc9d7
 2002-02-19 15:00:07 +00:00