database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
11,784 Commits 1,786 Branches 392 Tags
printf-sql-function
Commit Graph

4523 Commits

Author SHA1 Message Date
drh
3e3f1a5b49 Now supports result sets of the form "TABLE.*" with nested FROM clauses. 
FossilOrigin-Name: 4cf5ed7ea198abc32f8118e79490e77f847f08c1
 2013-01-03 00:45:56 +00:00
drh
d530ee64ca Merge all the latest trunk changes into the name-resolution enhancement branch. 
FossilOrigin-Name: a5f4d2b641f7fafb6f1a312efeffb10f213d2d0a
 2013-01-02 12:29:05 +00:00
drh
384b7fe221 Enhance the table_info pragma so that the pk column shows the order of the 
columns in a multi-column primary key.

FossilOrigin-Name: 3076a89015071e9b40e728bd55160e3a6ed98820
 2013-01-01 13:55:31 +00:00
drh
25846af3be More test cases for the REGEXP operator. Fix minor bugs uncovered by these 
test cases.

FossilOrigin-Name: a611c75061c8e821cb266fcb09759100d4a646b0
 2012-12-31 20:16:35 +00:00
drh
14172743a2 Add the test_regexp.c module containing a cross-platform implementation 
of the REGEXP operator.

FossilOrigin-Name: 46c8c01b751c1ea7fc02cc35e3b5bb99dbe46c4b
 2012-12-31 19:18:38 +00:00
dan
5cc3bea44a Ensure the database size field in the db header of a backup database is set correctly. Fix for [0cfd98ee201]. 
FossilOrigin-Name: ff6857b6ed6a46671006b75157d8cf853a816ef9
 2012-12-21 16:15:35 +00:00
drh
b2bb176b70 Add PRAGMA foreign_key_check. Name the child and parent tables as part of 
a "foreign key mismatch" error.

FossilOrigin-Name: e408dc9080594dc464b8763dece6b365772c6105
 2012-12-20 01:15:20 +00:00
drh
0e8578fc9e A couple more test cases. 
FossilOrigin-Name: 0ae142178d5ff874a4df58d699adad3a41e3d8d2
 2012-12-19 16:32:33 +00:00
drh
11c6387d38 Additional test cases involving the use of a result column specified by its 
"AS" name as a logical term of the WHERE clause.
Ticket [a7b7803e8d1e8699cd].

FossilOrigin-Name: d7cc364e87870746c231b97b648658bf343945fa
 2012-12-19 16:25:55 +00:00
drh
7ee751d241 Proposed fix for ticket [a7b7803e8d1e8699cd8a]. 
FossilOrigin-Name: 3d0e00c731c39af91bad74c6d74853375bac356e
 2012-12-19 15:53:51 +00:00
drh
0dde4739f3 Add commentary to the ExprList object to explain how zSpan is overloaded. 
Add test cases for the new name resolution functionality.

FossilOrigin-Name: 3e7d84db7861911c9b2c7dcdabe0b213bf483d79
 2012-12-19 13:41:03 +00:00
drh
832ee3d4cc Optimize the degenerate case of a FROM clause table name enclosed all by 
itself inside parentheses.  Generate code as if the parentheses did not
exist, rather than the old behavior of manifesting the parenthesized table
into a transient table.  Also, tag every FROM-clause SELECT subquery that is
generated by a parenthesized FROM-clause expression using the SF_NestedFrom
flag.  The new SF_NestedFrom flag is not yet used for anything.

FossilOrigin-Name: 7fecced466d86a66b0b751c5b5608141e134fe2d
 2012-12-18 19:36:11 +00:00
drh
92689d2869 Resolve names in FROM-clause subqueries prior to resolving names in the 
result set expressions of a SELECT statement.

FossilOrigin-Name: 9b67c633d932f3e566f521ee6a9cf3be193436fa
 2012-12-18 16:07:08 +00:00
dan
985cd59c48 On atomic-write capable systems, if copying the contents of an in-memory journal to disk fails, close the (on disk) journal file before returning the error to the caller. This causes the subsequent rollback operation to use the in-memory journal. Fix for [df678d738adb]. 
FossilOrigin-Name: 8183d8d7ae1ff4bad2fcc01adb923b966b347832
 2012-12-18 11:59:39 +00:00
drh
7d22a4d710 Added test cases for PRAGMA foreign_key_check. Fixed a bug that appears 
when the column order of the child and parent differ.

FossilOrigin-Name: 25411f83f99803e39feee368703fd20b4ade8eeb
 2012-12-17 22:32:14 +00:00
drh
4b4b473a1e Add to the foreign_key_check pragma an extra output column "parent" that 
contains the name of the parent table for the constraint that failed.

FossilOrigin-Name: 97f7f7377259ecf562019f62ebed0897cfae236e
 2012-12-17 20:57:15 +00:00
drh
9148defa61 Enhance the error message for "foreign key mismatch" to include the names of 
the child and parent tables.  Begin adding test cases for 
PRAGMA foreign_key_check.  Make sure PRAGMA foreign_key_check gets all
necessary table locks.

FossilOrigin-Name: 0f9963526c299757ff95c153fb05a67cddb6af28
 2012-12-17 20:40:39 +00:00
drh
03597ef6e2 Merge in all the trunk changes that have occurred since this branch was 
opened.

FossilOrigin-Name: 6d507e4de924e2f4556ea4a03ee0fa7d647bf8bb
 2012-12-14 15:54:05 +00:00
dan
4ac391fc05 Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause. 
FossilOrigin-Name: 7280e14cd8f55896451847b432171e8750a07c81
 2012-12-13 16:37:10 +00:00
drh
6949784cc4 Update requirements marks and test cases for multi-VALUE INSERT and to fix 
typos in requirements text.

FossilOrigin-Name: 81d9ee0f0df7f283e69ba1c2845339ea3318cd66
 2012-12-11 19:40:03 +00:00
dan
b136e902ad Modify releasetest.tcl so that it runs the "checksymbols" test on a build without SQLITE_DEBUG defined. If SQLITE_DEBUG is defined, the sqlite3WhereTrace variable causes the test to fail. 
FossilOrigin-Name: 75e545a9e2614fae7db86ecfb84e41ecbe4097ba
 2012-12-10 10:22:48 +00:00
drh
468ef9a87e Refactor collating-sequence handling as a fix for ticket [71e333e7d2e642]. 
The Expr.pColl field is removed from the Expr object.  The COLLATE operator
now becomes a separate instance of Expr in the expression tree.  The code
generator looks up the correct collating function as needed, rather than
referring to Expr.pColl.

FossilOrigin-Name: 8542e6180d4321d45b34f33e481658908ce1430d
 2012-12-08 21:51:24 +00:00
drh
580c8c1816 Veryquick passes all tests now. 
FossilOrigin-Name: 7b96115e81deab0aa0472839cf787ba3f2fc64a7
 2012-12-08 03:34:04 +00:00
drh
85d641f948 Improved error messages when column integers in an ORDER BY clause are 
out of range.

FossilOrigin-Name: bd960d937f8d6521c8ec4b7bd8a77a498dd432d4
 2012-12-07 23:23:53 +00:00
dan
4b2f358938 Ensure the VerifyCookie sub-routine has been run before the database is accessed in an obscure case. Fix for ticket [d6b36be38]. 
FossilOrigin-Name: 2d5f37c99a9e5377409697f5392a1ca55970964e
 2012-12-07 19:28:26 +00:00
drh
0a8a406e9b Some errors in veryquick resolved. Many more to go. 
FossilOrigin-Name: 972443b4eb282d45507da06c75e2cd46dd72326b
 2012-12-07 18:38:16 +00:00
dan
bac19cf904 Do not run test file malloc3.test as part of the inmemory_journal permutation. Explanation is in a comment at the top of malloc3.test. 
FossilOrigin-Name: df1827b19e47724b62fdf6fbedfd4e61add343d3
 2012-12-07 10:55:19 +00:00
dan
f78baafe41 Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6]. 
FossilOrigin-Name: 0c31a46801746191d1a53332d75beda880fe1fd7
 2012-12-06 19:37:22 +00:00
drh
696b33e622 Add the SQLITE_FCNTL_TEMPFILENAME file control that asks the underlying VFS 
to return a new temporary filename.  Per request from NSS team at Mozilla.

FossilOrigin-Name: 1a63b1d5fa5d79f96eddbda6d94bc10248863710
 2012-12-06 19:01:42 +00:00
drh
74358f0c77 Add a test case that demonstrates ticket [71e333e7d2e642]. 
FossilOrigin-Name: cc6e0785df3c2342376351e19ba7dba7b8d2f6a3
 2012-12-06 15:15:15 +00:00
mistachkin
f44d4b41bd Bring the ancient malloc3.test file closer into relevance with the latest core code. 
FossilOrigin-Name: 9793a21c13a1188383b4be64df86629f196ca330
 2012-12-06 04:19:24 +00:00
dan
e825831ee4 Disable a couple of tests in where.test when running the "no_optimization" permutation. 
FossilOrigin-Name: 5e961e37c5357776bcb44c473cb5ee4b59561f07
 2012-12-05 19:04:32 +00:00
dan
97305a7ccb Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test. 
FossilOrigin-Name: 51cbddd51d02bcd954be411ecc83556c049a2680
 2012-12-05 16:44:13 +00:00
dan
9ccaefb172 Fixes to a test case in shared_err.test. The fix is to prevent sqlite3_prepare() from being called when the test intends to test the response of sqlite3_step() to an OOM condition. 
FossilOrigin-Name: 40c143955ebe75f8e73119f9103f36a3c8ac4514
 2012-12-05 14:37:55 +00:00
dan
8411b25c59 Update a couple of test scripts so that they work in auto-vacuum mode. 
FossilOrigin-Name: 04ab2dc6914e4d6fe2682eba08fc1cd1148a44a1
 2012-12-05 09:12:58 +00:00
dan
ec6b07b27b Add a test to ensure that the fix in [b0c1ba655d] has worked. 
FossilOrigin-Name: 41806de5c88e924e306ca737192755c011517426
 2012-12-04 05:24:21 +00:00
mistachkin
585dcb251b Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. 
FossilOrigin-Name: 41fd9dd29034b2269e4b7f2626350124d37b5303
 2012-12-04 00:23:43 +00:00
dan
bba44d0d1b Fix a problem causing the "number-of-documents" field maintained by FTS4 to be set incorrectly. 
FossilOrigin-Name: e38fb02d5ea5daa6992df4dfbbeec92bf7b525f6
 2012-11-27 15:56:38 +00:00
drh
0fbb50ee15 When available, use posix_fallocate() rather than ftruncate() to allocate 
space for mmap()ed -shm files, since posix_fallocate() gives an error if
no disk space is available whereas ftruncate() is silent and leaves the system
vulnerable to a SIGBUS upon first write to the mmap()ed region.
Ticket [5eaa61ea1881040b17449ca043b6f8fd9ca55dc3]

FossilOrigin-Name: 356259617cfad04492a02912fdf781f54a2b4494
 2012-11-13 10:54:12 +00:00
dan
9fc5b4a539 Change os_unix.c to propagate ENOENT errors back to sqlite as SQLITE_IOERR_DELETE_NOENT. Have SQLite ignore these where they are benign and propagate them back to the caller where they may indicate a file-system malfunction of some description. 
FossilOrigin-Name: bed9c172ce624ab7b5b9de9ad42444891717ad9a
 2012-11-09 20:17:26 +00:00
drh
782d68a4cd Try to take into account the cost of inner loops when selecting which table 
of a join to use for the outer loop.

FossilOrigin-Name: 942556342a332b04a11169bb04f387d741ef9488
 2012-11-09 17:59:26 +00:00
drh
24aeee17a1 Add the INSTR() SQL function. 
FossilOrigin-Name: a4c181cbcf9b8baa6e07501a93ef81603d91ba7d
 2012-11-05 13:51:58 +00:00
drh
e0b2d5dabb Adding test cases for ticket [bfbf38e5e9956a] 
FossilOrigin-Name: 62ebfa747635a5593759ea2a28166d054c8eee8a
 2012-11-02 19:08:31 +00:00
drh
21172c4cc0 Add an optimization that attempts to run a subquery as a coroutine rather 
than manifesting it into a temporary table.

FossilOrigin-Name: 7af3acbbd49a2114fcdada9ec907c68ba9b053bd
 2012-10-30 00:29:07 +00:00
dan
e62c0694de Fix a bug in fts3 causing it to return SQLITE_NOMEM when NEAR, OR and some auxiliary functions were used together. Also a segfault in vtab.c that could follow an OOM condition. 
FossilOrigin-Name: 33f4f9817e8b3cb97ce02a4c49bd586332da37b2
 2012-10-25 19:25:39 +00:00
drh
98d312fc3e Improvements to the command-line argument parsing in the 
command-line shell.  Command-line options can now occur either before
or after the database name and first command and are still accepted and
processed.  Command-line options are processed even if no database name
is given (and :memory: is assumed).

FossilOrigin-Name: 317c80cba3688a97ade9cde622cc3bd94cf3436a
 2012-10-25 15:23:14 +00:00
drh
d55e07296b Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, 
and Oracle.

FossilOrigin-Name: 49ccae964f3a8ae5aab87f56503121e09424545f
 2012-10-25 03:07:29 +00:00
dan
1e3e41858f Add a test for the problem fixed by [bf44d73d3e]. 
FossilOrigin-Name: db9b1fa5973d79e29885817d5aedc3a886c2589a
 2012-10-17 16:20:36 +00:00
drh
281bbe2a95 Enable optimization of IN operators on constraints to virtual tables. 
FossilOrigin-Name: aa650746b19e4a6a373f7e47effff3ab2f48e78c
 2012-10-16 23:17:14 +00:00
dan
7eb0575287 Fix a failing assert() in wal.c. 
FossilOrigin-Name: 8745530b9a877db77fe2ca3ea9c6bc99ce033055
 2012-10-15 11:28:24 +00:00