database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-04-23 06:45:40 +03:00
Code
29,842 Commits 1,540 Branches 176 Tags
Commit Graph

9709 Commits

Author SHA1 Message Date
drh
74587e5567 Updates prior to release 2.6.3. (CVS 706) 
FossilOrigin-Name: 34c4149eea7a48927e36867f4e25ff7fac40c66e
 2002-08-13 00:01:16 +00:00
drh
94f3331a0b Fix for ticket #9 (again). The rollback journal files should now also be 
byte-order independent. (CVS 705)

FossilOrigin-Name: 2fb3fdcdf06c1206bf14da640c2f9e599455f0eb
 2002-08-12 12:29:56 +00:00
drh
0d316a40cc Fix for ticket #9: Add the ability to read little-endian database files 
from a big-endian machine and vice versa. (CVS 704)

FossilOrigin-Name: ce4b943bf68c160445a58ffccfbabbbd30d9829b
 2002-08-11 20:10:47 +00:00
drh
68d2e5918a Fix for ticket #131: When a SELECT contains a GROUP BY clause it cannot 
use an index for sorting.  It has to sort as a separate operation after
the GROUP BY is complete. (CVS 702)

FossilOrigin-Name: 18745c67acdf7ebec378f5538174117970e9f5cc
 2002-08-04 00:52:38 +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
f573c99ba7 Fix for ticket #104: Make triggers on views work properly even after closing 
and reopening the database.  Also fixed an unrelated bug in the version
2.6.0 database format upgrade logic.  The upgrade logic bug was found while
testing the trigger fixes. (CVS 697)

FossilOrigin-Name: 04973fc2a6a0c93877de7e564618e0e9fcffc06c
 2002-07-31 00:32:50 +00:00
drh
92ed08a9d7 Fix for ticket #114: Correctly handle SQLITE_BUSY if it occurs during 
database initialization. (CVS 696)

FossilOrigin-Name: 5b814b5df667ccc91d85fbb7f96e523483e9219b
 2002-07-30 18:43:40 +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
danielk1977
368c7f6df1 UPDATE triggers on TEMP tables were broken. (CVS 693) 
FossilOrigin-Name: c080ed01ea51628b86050762f097e702e3aeafdf
 2002-07-21 23:09:55 +00:00
drh
26b3e1bc06 Fix an assertion failure that occurs when attempting to delete all rows of 
a table while the "count_changes" pragma is turned on.  Up the version number
to 2.6.1. (CVS 690)

FossilOrigin-Name: 612df004017b241651074ee859096dd0ee5062b8
 2002-07-19 18:52:40 +00:00
drh
c231172f3f Better detection and reporting of errors when initializing from the 
sqlite_master table. (CVS 688)

FossilOrigin-Name: c8a7b725b7cec792d2148455a4cecbce9dfebe80
 2002-07-19 17:46:38 +00:00
drh
3c2c354e0e Update documentation prior to the release of 2.6.0. (CVS 683) 
FossilOrigin-Name: f2d9191381e956900a14bd80e50678b9d49e19e5
 2002-07-18 02:07:07 +00:00
drh
8e5ba84643 Make the automatic database upgrade work even if there are triggers. Add 
tests for automatic upgrade and for failing if reading a more advanced version
of the database.  Ticket #107. (CVS 682)

FossilOrigin-Name: 0493e39c1cbbe4a38e990a2370181a79606af222
 2002-07-18 01:27:17 +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
53e3fc70bf Fix for ticket #105: Fix the UPDATE command so that it works properly with 
indexed tables when there is a subquery in the WHERE clause.  Add tests
to verify correct operation. (CVS 680)

FossilOrigin-Name: bbca16f88d00cd33ac7229edf3ee4623eff6e62f
 2002-07-16 17:22:50 +00:00
drh
0c36cbe0c2 Fix for ticket #100: Correctly handle ON and USING clauses of JOINs within 
a VIEW. (CVS 679)

FossilOrigin-Name: 93710f7ed7e1baa6acbf4bc32982e046f61ffa44
 2002-07-16 02:05:43 +00:00
drh
ad16844f35 Fix for ticket #102: Honor the ORDER BY clause in subqueries. (CVS 677) 
FossilOrigin-Name: 7e918c8b0df5120e3630811f164defb8c9fedd6d
 2002-07-15 18:55:24 +00:00
drh
485b39b401 Fix for ticket #95: Do not allow automatically created indices (associated 
with UNIQUE or PRIMARY KEY constraints) to be dropped. (CVS 671)

FossilOrigin-Name: 0603eb74e6aca48f62bd95cb6c236b9e559af850
 2002-07-13 03:11:52 +00:00
drh
193a6b4142 More rollback problems: Fix two more errors introduced by checking (410) that 
can cause database corruption after a ROLLBACK.  Also add new tests to make
sure everything is working this time. (CVS 663)

FossilOrigin-Name: f6e24d5ccbcfcf5863ffbd65860dafa2f5663e99
 2002-07-07 16:52:46 +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
2f2c01e51d Fix for ticket #92: Correct the sqliteExprCompare() function so that is takes 
into account the iTable and iColumn fields of the Expr structure.  Otherwise,
"min(a)" and "min(b)" will compare equal to each other in views. (CVS 658)

FossilOrigin-Name: 85793a4f03250166c21007cab3525709592d0866
 2002-07-02 13:05:04 +00:00
drh
5ad1a6c8c4 Fix for tickets #90 and #89: Make the AS keyword optional again. (CVS 654) 
FossilOrigin-Name: 1f8a73b1c3833e3924196458d4c1ecca90f63662
 2002-07-01 12:27:09 +00:00
drh
6cbe1f1bc4 Added additional tests. No new errors found. (CVS 653) 
FossilOrigin-Name: 8924a7f5bab790ab552332d6359028d0d1825e4a
 2002-07-01 00:31: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
3b167c7583 Additional test cases added. The following bug fixed: A segfault was occurring 
if a VIEW consisted of a join with a USING clause. (CVS 651)

FossilOrigin-Name: 96515b813eb57e1f48c28d357d1f38639b2fdcfa
 2002-06-28 12:18:47 +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
411995dc0d Add the sqlite_open_aux_file() API. (CVS 646) 
FossilOrigin-Name: 332164d6455658ca633a1dc49811d9fb0fd4b01c
 2002-06-25 19:31:18 +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
f46f905a1e An optimization: avoid the use of an intermediate table on UNION ALL if there 
is no ORDER BY clause. (CVS 637)

FossilOrigin-Name: 8aa73ce61268a50d353d9a5c878461290195525f
 2002-06-22 02:33:38 +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
c926afbc2d Fix for ticket #73: The ORDER BY clause is significant for subqueries. 
This passes all regression tests, but more testing is needed to exercise
all paths through the new code. (CVS 631)

FossilOrigin-Name: 43c5aff5d078bce9292683cd40311e0dcc81ac14
 2002-06-20 03:38:26 +00:00
drh
27a32783ab Fix for ticket #75: Autoincrement INTEGER PRIMARY KEY fields on an INSERT 
even if the data is coming from a SELECT statement. (CVS 630)

FossilOrigin-Name: d599f75b659809a6e5eee09b0e9e6e90bde5af1e
 2002-06-19 20:32:43 +00:00
drh
e31847449e The query optimizer now attempts to satisfy an ORDER BY clause using 
an index.  Sorting is still used if there are no suitable indices. (CVS 628)

FossilOrigin-Name: f09e19b43ef61073713cf32282c90ea666229eba
 2002-06-19 14:27:05 +00:00
chw
b22f1b58ac Added printf-4.(2-4) test cases to test new %Q format specifier. (CVS 622) 
FossilOrigin-Name: 7d5fc35b5d38230230344b4f70763f75940ab908
 2002-06-16 04:56:36 +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
48185c15c7 Added tests for the new IN operator optimizer and fixed a bug that the 
new tests found.  This completes the implementation of enhancement #63. (CVS 612)

FossilOrigin-Name: 2a710e18176c486525f0abb06644a511a2cd1d7a
 2002-06-09 01:55:20 +00:00
drh
d9e3093038 Fix for ticket #65: If an integer value is too big to be represented as a 
32-bit integer, then treat it as a string. (CVS 611)

FossilOrigin-Name: ad9624798edbd6d0c4652fed3d74fe87498844ff
 2002-06-09 01:16:01 +00:00
drh
f5db2d3ea2 Bug fix: do not segfault if a SELECT without a FROM clause includes 
the * wildcard in the result column list. (CVS 609)

FossilOrigin-Name: d939294994e5f6c7862b66573301e111e56a2681
 2002-06-06 23:42:27 +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
04738cb9ff Add the ability to parse FOREIGN KEYs. Foreign keys are still ignored, 
but at least they now do not cause a syntax error. (CVS 603)

FossilOrigin-Name: 6fdcee3c99e994ef3ab83a0cc57344cdb16210df
 2002-06-02 18:19:00 +00:00
drh
e4de1feb3e Enhance the ORDER BY clause so that an integer term means to sort by the 
corresponding column. (CVS 602)

FossilOrigin-Name: 7acbf84b492202d8b5a05276a95b475027eb5f58
 2002-06-02 16:09:01 +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
0f89253e21 Once it is opened, leave the checkpoint journal file open for the 
duration of a transaction, rather than closing it and reopening it
for each statement.  (Ticket #53) (CVS 599)

FossilOrigin-Name: 7a24336d50e72006b2cc0e4feb292b946e79d5f3
 2002-05-30 12:27:03 +00:00
drh
461c281a2e Bug fix: bad code was generated for when the first operand of a CASE 
was NULL. (CVS 598)

FossilOrigin-Name: 4debc8db929fdc201759ba211acdeadc4e30e8af
 2002-05-30 02:35:11 +00:00
drh
739105c72c Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597) 
FossilOrigin-Name: 19ae12bef210ae5fe171f10833faa38d640c129f
 2002-05-29 23:22:23 +00:00
danielk1977
993b173e55 Update trigger2.test to match checkin 591. Also fix ticket #51 (by documenting problem) (CVS 595) 
FossilOrigin-Name: 5e74d0964b8fd99eda798e3737217aa499cc1726
 2002-05-28 06:55:27 +00:00
drh
c754fa5486 Fix the "alias.*" bug found by Bernie Cosell and reported on the newsgroup. (CVS 593) 
FossilOrigin-Name: f562d542304c0c1b18b0cee78b1ecc353327a02e
 2002-05-27 03:25:51 +00:00