1
0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-28 10:57:26 +03:00
Commit Graph

1316 Commits

Author SHA1 Message Date
danielk1977
517eb64616 Tables created with the CREATE TABLE <tbl> AS SELECT ... syntax now inherit
column declaration types from the SELECT statement. (CVS 1538)

FossilOrigin-Name: 31c1668dbc2b84438a5b78b0270f58b37b03791d
2004-06-07 10:00:31 +00:00
danielk1977
8e227875dd Add pragma to set/get text encoding. Also fix an obscure problem where a
temp trigger could be accidently dropped. (CVS 1537)

FossilOrigin-Name: 983221b038813c5a7892564896e39597c223c4c3
2004-06-07 07:52:17 +00:00
drh
e54ca3fe2e Progress towards getting locking to work on windows. (CVS 1536)
FossilOrigin-Name: 4f7c0961ad6cb7082bf7716f0c7ca16a8742c039
2004-06-07 01:52:14 +00:00
danielk1977
ad7dd42558 Performance improvements for LIKE. It is still too slow though. (CVS 1535)
FossilOrigin-Name: 30b81507fc404355751705c6f9856c178249eff1
2004-06-06 12:41:49 +00:00
danielk1977
d02eb1fdf4 Enhance user function API to support association of meta-data with constant
arguments and the specification of text encoding preference. The LIKE
operator takes advantage of both. (CVS 1534)

FossilOrigin-Name: 92337d8f79b9754cd61c73e7db2e792a1f482f50
2004-06-06 09:44:03 +00:00
drh
51c6d9633f Added sqlite3OsLock for win32. Assertion fault in attach.test. (CVS 1533)
FossilOrigin-Name: 9e6cd9ec75f726ef85e60f593aaa895791315071
2004-06-06 00:42:25 +00:00
danielk1977
682f68b020 Add the sqlite3_set_auxdata() and sqlite3_get_auxdata() APIs. (CVS 1532)
FossilOrigin-Name: c2899b437366d879258ab4f6ae47868441010eca
2004-06-05 10:22:17 +00:00
danielk1977
2a02e33950 Ensure blob values survive the ".dump" command of the shell. (CVS 1531)
FossilOrigin-Name: e82eb722b0e0b223ddaf7d85669792c33594f9da
2004-06-05 08:04:36 +00:00
drh
a2fce64acc Critical bugs fixed in btree.c. Incompatible file format change. Unrelated
comment fix in select.c (CVS 1530)

FossilOrigin-Name: cb1ffabf86996ab20dfffcb5f133fa9a9b56bbe2
2004-06-05 00:01:44 +00:00
danielk1977
9eed505701 Defer the exclusive db lock until the pager cache is flushed to disk. 41
tests now fail. (CVS 1528)

FossilOrigin-Name: d2f69e5ef2f261a00bb8427a4e2a1638ecfd17a9
2004-06-04 10:38:30 +00:00
danielk1977
24162fe668 Move the 'busy-callback' logic to the pager layer. (CVS 1527)
FossilOrigin-Name: ff70b6d2b60c143e3ada0606ceff97571998c7e3
2004-06-04 06:22:00 +00:00
danielk1977
13adf8a071 Untested updates to support atomic multi-file transactions (CVS 1526)
FossilOrigin-Name: d57e5252c8baaf615c2cd218a33356ea5d95a5e2
2004-06-03 16:08:41 +00:00
danielk1977
ecb2a9644b Fix a segfault in sqlite3OsLock() (CVS 1525)
FossilOrigin-Name: 51348b82c4d5801091537b80059d770410774905
2004-06-02 06:30:16 +00:00
drh
7a224deb5f Work toward combining the OP_MakeKey, OP_MakeIdxKey, and OP_MakeRecord
opcodes into one.  The work is incomplete. (CVS 1524)

FossilOrigin-Name: 165d69a04cca719dec2b042117f848f153721a1d
2004-06-02 01:22:02 +00:00
drh
df0148931d Remove the sqlite3_libencoding() api and the ISO8859 encoding option. (CVS 1523)
FossilOrigin-Name: b53640ed2232aaf173a71636073477d80407d11f
2004-06-02 00:41:09 +00:00
danielk1977
193c72f84e Fix a bug with UTF-16 byte-order-marks on big-endian hosts. (CVS 1522)
FossilOrigin-Name: c17b864103fe5e6def0f650eadb7b2cc6e87144f
2004-06-02 00:29:24 +00:00
danielk1977
9a1d0abed4 Unix version of sqlite3OsLock(). (CVS 1520)
FossilOrigin-Name: 023d1760c1a720632b25c98d14bf521ab91861e2
2004-06-01 14:09:28 +00:00
danielk1977
d1a2553ae6 Remove the sqlite3_open_varargs() API. (CVS 1515)
FossilOrigin-Name: 6902fb1b49fdf0e38265fa26198690243cdc2f58
2004-06-01 00:03:52 +00:00
danielk1977
f20b21c8fd Remove the sqlite3_error_string() API. (CVS 1514)
FossilOrigin-Name: af8e2006d808031a040f293c44f3bfbe841b866b
2004-05-31 23:56:42 +00:00
drh
3f4fedb2c4 Change the name of the sqlite3_freemem API function to just sqlite3_free. (CVS 1512)
FossilOrigin-Name: f3b80bbb97ed0b0c1cf634068f28f23802ec71a8
2004-05-31 19:34:33 +00:00
drh
9c054830b4 Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511)
FossilOrigin-Name: adf7e29ff60dc559f64832fadb09f0b9decc0e76
2004-05-31 18:51:57 +00:00
drh
1d482dd917 Change the name of the include file to "sqlite3.h". The names of the shell
command and static library become "sqlite3" and "libsqlite3.a". (CVS 1510)

FossilOrigin-Name: 4c37b6d2b78e88e2a9dfed4d764caeb0f626f92e
2004-05-31 18:23:07 +00:00
danielk1977
11146c9c2e Use read-only transactions. (CVS 1504)
FossilOrigin-Name: 6c100887eeb32631e1aa914a69db959e1f58f192
2004-05-31 11:51:44 +00:00
danielk1977
77d83ba50f Bugfix for previous checkin. (CVS 1503)
FossilOrigin-Name: 5f869fbfc029eb2601d1d967685517d007d002a4
2004-05-31 10:08:14 +00:00
danielk1977
ee5741ea78 Add read-transactions to the btree and vdbe. The compiler doesn't invoke
them yet. (CVS 1502)

FossilOrigin-Name: 6b43633a96c674a5d470578ef80ebf2227da0682
2004-05-31 10:01:34 +00:00
danielk1977
33752f8acf Remove the <ON CONFLICT> clause from BEGIN (CVS 1501)
FossilOrigin-Name: 9029274b6129140064bd7ac34df7eaba00d28efb
2004-05-31 08:55:33 +00:00
danielk1977
1d850a72c2 Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500)
FossilOrigin-Name: b8ed812c92f2dbb4431d45aeb41646ceb53e0cbc
2004-05-31 08:26:49 +00:00
drh
a19b775db9 Add 3-byte and 6-byte integer serial types. This makes databases smaller
and faster.  Should we go ahead and add 5- and 7-byte integer types too? (CVS 1499)

FossilOrigin-Name: e6685af815c4c0c7f09bb097a59a121862b865cf
2004-05-30 21:14:58 +00:00
drh
e51c44f481 Various speed enhancements. (CVS 1498)
FossilOrigin-Name: a0db15bba64af0c529d5be366659bca1165ff21b
2004-05-30 20:46:09 +00:00
drh
271efa5a28 Improved comments and speed tweaks to btree.c. (CVS 1497)
FossilOrigin-Name: c86b7c065a798cd108189b96e87d100115862ff2
2004-05-30 19:19:05 +00:00
drh
3a41a3fe66 Additional minor speed improvements. (CVS 1496)
FossilOrigin-Name: a90264c0a4c73097fe0ae8933dcebb15b8eaa2bb
2004-05-30 02:14:17 +00:00
drh
696b32fa4e Faster version of sqlite3VdbeSerialGet. (CVS 1495)
FossilOrigin-Name: 80985505fe8ba8e505842dae95d37bf412fc586d
2004-05-30 01:51:52 +00:00
drh
6fec076238 Do not include the P3 parameter on OP_Integer opcodes if the integer will fit
in 32 bits.  The P3 conversion is slow. (CVS 1494)

FossilOrigin-Name: fcd84ebabca72023e76e6954514948aa9a3ab999
2004-05-30 01:38:43 +00:00
drh
436051582f A file format change for btree.c makes it between 10 and 20% faster. (CVS 1493)
FossilOrigin-Name: cbcaece7f45a0bc994e6c54a996afa4e6529da6a
2004-05-29 21:46:49 +00:00
danielk1977
0f69c1e3ec Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they are executed. (CVS 1492)
FossilOrigin-Name: 3225de8902b0e7e60c4d9f3a5ef51bc74f57d364
2004-05-29 11:24:50 +00:00
danielk1977
bd26f925e0 Ensure vacuum handles table names with spaces in them. (CVS 1491)
FossilOrigin-Name: 0a6689be843e695902fbfef863f128915545499e
2004-05-29 10:43:06 +00:00
danielk1977
3df6b2570f Fix vacuum so that it works with blobs. (CVS 1490)
FossilOrigin-Name: 4feb4b9a71ce7a92924d2358a7ccecb4cca19223
2004-05-29 10:23:19 +00:00
danielk1977
e7d00f5825 Avoid arithmetic on void pointers. (CVS 1489)
FossilOrigin-Name: 3d68703e2e4e793012cb3c13a6744e915475e006
2004-05-29 02:44:02 +00:00
danielk1977
ef2cb63e9e Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488)
FossilOrigin-Name: 4060a37d0baaa60c50f2dde4a1ab344133fcabbb
2004-05-29 02:37:19 +00:00
drh
51846b56ed Factor common code for generating index keys into a procedure. Other
speed improvements and bug fixes. (CVS 1487)

FossilOrigin-Name: 6661bb5f9c1692f94b8b7d900b6be07f027e6324
2004-05-28 16:00:21 +00:00
danielk1977
76d505baad Fix a bug in the sqlite3_column_decltype() API. (CVS 1486)
FossilOrigin-Name: c8a40218c20cf5d0abad330e8fa59ca4c36e7608
2004-05-28 13:13:02 +00:00
danielk1977
48dec7e215 Allow CREATE and DROP VIEW on attached databases. (CVS 1485)
FossilOrigin-Name: ad879a957d93c0b49c289947826b451d3ea37e5b
2004-05-28 12:33:30 +00:00
danielk1977
a8858103c9 Allow DROP TABLE and DROP INDEX on attached databases. (CVS 1484)
FossilOrigin-Name: 2fb3708e10a06660ad1974ef8e9742b706a0a9fc
2004-05-28 12:11:21 +00:00
danielk1977
cbb18d2256 Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483)
FossilOrigin-Name: 4984a130ccf3b8e486941a5d0d0cc70a691f0dac
2004-05-28 11:37:27 +00:00
drh
d578820154 Tables and indices use the same record format. (CVS 1482)
FossilOrigin-Name: 1b15b32bdbccae555243e67aa011139c50dc2fb3
2004-05-28 08:21:05 +00:00
drh
f3218fea00 Tables and indices use the same record format. (CVS 1481)
FossilOrigin-Name: ebd564d10b0ecd7ff15cbd6cd2b979c9f767476c
2004-05-28 08:21:02 +00:00
drh
25aa1b4580 Remove the encoding argument from sqlite3VdbeSerialGet. Use the 32-bit
version of sqlite3GetVarint for schema-level parameters. (CVS 1480)

FossilOrigin-Name: 321f8c463520e99681de878b743027c570b73e35
2004-05-28 01:39:01 +00:00
danielk1977
61de0d1b99 Add API functions sqlite3_open_varargs(), sqlite3_open16_varargs() and
sqlite3_complete16(). (CVS 1479)

FossilOrigin-Name: 203af2b2e3a25f4fe0e128e350c21834cad0bd7f
2004-05-27 23:56:16 +00:00
drh
d3194f5a4a Change the record format to include an extra varint at the beginning to record the number of bytes in the header. (CVS 1478)
FossilOrigin-Name: 0c4d138807f367d75b3fb5b2dadf206df725659f
2004-05-27 19:59:32 +00:00
drh
5f3b4ab53c Remove the COPY command. (CVS 1477)
FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43
2004-05-27 17:22:54 +00:00