database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
16,935 Commits 1,785 Branches 392 Tags
changebatch
Commit Graph

399 Commits

Author SHA1 Message Date
drh
abfd35ea03 Performance improvement and size reduction in the Expr node allocator 
function sqlite3PExpr().

FossilOrigin-Name: 2a81763e68cdf9b8c46389b1e1a87bc2084b53e7
 2016-12-06 22:47:23 +00:00
drh
de25a88c50 Avoid unnecessary strlen() calls in sqlite3ExprAssignVarNumber() by passing in 
the token length from the parser.

FossilOrigin-Name: d15ae2e530cffea60263f203ac5f89b6790f4bd5
 2016-10-03 15:28:24 +00:00
drh
0cd874bd57 Inline the relevent parts of sqlite3ExprAlloc() into spanExpr(), for a 
performance improvement.

FossilOrigin-Name: fe89225eab777c2c9cb1cbc31092b9e39f516842
 2016-09-26 12:38:22 +00:00
drh
410c301fea Omit the LikeOp object from the parser. Change more sqlite3PExpr() calls into 
sqlite3ExprAlloc() calls.

FossilOrigin-Name: 795454a3fa5f9ccc486593b5e16e8fad38c934fb
 2016-09-24 17:42:43 +00:00
drh
209bc522b0 Add the EP_Leaf flag bit to the Expr.flags field to indicate Expr 
nodes that do not have substructure.  Use that bit to avoid unnecessary
recursion.

FossilOrigin-Name: 8a6ea455cd1bf42ae0a7f1f1789baf88d782db13
 2016-09-23 21:36:24 +00:00
drh
e1c03b6233 Use sqlite3ExprAlloc() instead of sqlite3PExpr() for leaf nodes in the 
expression tree, where appropriate.  This is both smaller and faster.

FossilOrigin-Name: afac0709cec577a7851e3711730712cf12eeb6af
 2016-09-23 20:59:31 +00:00
drh
8bd0d58e1c Fixes for problems following OOM errors. 
FossilOrigin-Name: 9041ee4a6f0e8389297f887f1431ab5cfe783390
 2016-08-20 18:06:14 +00:00
drh
a1251bc40d Add support for vector assignments in the SET clause of an UPDATE statement. 
FossilOrigin-Name: f320d47d6b7b08d9552c8444004bc256348bda90
 2016-08-20 00:51:37 +00:00
drh
b684fd5c4a Merge recent enhancements from trunk. 
FossilOrigin-Name: b17872363b60edab05a5d382a44038aad91e4d9f
 2016-08-19 15:41:24 +00:00
drh
9ef5e7708a Add the capability to VACUUM an attached database by specifying the schema 
name as an argument to the VACUUM command.  Since version 2.0, VACUUM has
accepted an argument which was silently ignored.  Now it has meaning.

FossilOrigin-Name: 29d63059b4d2bb612523ac55ebfef040d054a64f
 2016-08-19 14:20:56 +00:00
drh
c8d0b0b9d4 Since the TK_VECTOR token is not actually used by the parser, make it an 
extra token code added by the tool/addopcodes.tcl script during parser build.

FossilOrigin-Name: b40b202c1f82808d2240e87b22f1e78b2208cb26
 2016-08-18 15:36:03 +00:00
dan
d9ed09d47b Merge latest trunk changes into this branch. 
FossilOrigin-Name: d4f3d52c5a11fc7ad7e8cad76361edbcef13a12f
 2016-07-26 18:15:35 +00:00
drh
a522473c65 Add a new %ifdef to parse.y so that the build works with SQLITE_OMIT_SUBQUERY. 
FossilOrigin-Name: 38a48cfb9a8212970c4a4f8458643c22ed067e8b
 2016-07-25 14:40:43 +00:00
dan
71c57db099 Add some support for using row value constructors in certain parts of SQL expressions. There are many bugs on this branch. 
FossilOrigin-Name: b2204215b231202aef7a218411cc2ddaecf28f35
 2016-07-09 20:23:55 +00:00
drh
9de4757c9c Fix a problem in table-valued functions on the RHS of an IN operator that 
occurs following an OOM error.

FossilOrigin-Name: bead151e72215e6ca2a90eb049cfca414dccea04
 2016-07-02 12:33:21 +00:00
drh
5fbab882c0 Add support for table-valued functions on the RHS of an IN operator. 
FossilOrigin-Name: ac6000f050ff4efcf8a87f0825077dbf4144f073
 2016-07-02 12:08:14 +00:00
drh
62340f8498 An experimental branch with code that allows virtual tables to be declared 
as WITHOUT ROWID tables. This might be useful for virtual tables that model
external data sources that do not have a convenient way of computing a unique
rowid.  The current check-in almost works, but there are still serious issues.

FossilOrigin-Name: 49638f180e26477974cacc69b79e0be0a5e18b29
 2016-05-31 21:18:15 +00:00
drh
7cc84c2cdd Remove the VdbeOp.opflags field and its associated initialization overhead. 
Update mkopcodeh.tcl to reorder opcode numbers to help the resolveP2Values()
routine run faster.

FossilOrigin-Name: 099478fa7521ba52262ef2bf24dd8f0114ce92e1
 2016-04-11 13:36:42 +00:00
drh
8679fbabaa Back off of the parser optimization in the previous check-in, slightly, to 
preserve some backwards compatibility regarding some undocumented behavior
in the '#AAA' style query parameter.

FossilOrigin-Name: ef1966c2469a0f5dbdb31a0287bd37badb2b8f28
 2016-04-11 01:43:33 +00:00
drh
8f3b137fa6 Small size reduction and performance improvement in the parser. 
FossilOrigin-Name: 16df71284bf081c8b3d3aa57c129a07067ddbed3
 2016-04-11 01:26:31 +00:00
drh
08de4f7933 Factor out the common operation of setting the Expr.x.pSelect field of an 
Expr object into a subroutine.

FossilOrigin-Name: 6a5cceee486c5e3625556e4c7076ff90e9d8fa43
 2016-04-11 01:06:47 +00:00
drh
986dde7052 Further simplifications to the grammar. 
FossilOrigin-Name: 519fd03b845c9b53df9e5397282df2e99f36a672
 2016-02-29 13:37:21 +00:00
drh
2881ab6298 Update the parser so that it pulls out the column name and type all in one 
go, rather than using separate reductions.

FossilOrigin-Name: ad3ffe2eec8e8ea2591a78c723d2665735553cb0
 2016-02-27 23:25:36 +00:00
drh
43303de97e More agressive use of /*A-overwrites-X*/ in the parser. Fix an off-by-one 
error in parser stack overflow detection.

FossilOrigin-Name: 417e777701bbf4bd67626d4ca3bc2c5d847f6cd0
 2016-02-17 12:34:03 +00:00
drh
cf82f0d3d2 Enhance Lemon so that if reduce code contains a comment of the form 
"/*A-overwrites-X*/" then a LHS label A is allowed to overwrite the
RHS label X.

FossilOrigin-Name: 5cfe9545d478a2c500083613dd20e14b2ffce645
 2016-02-17 04:33:10 +00:00
drh
dabd04c656 Further improvements to the Lemon-generated code for yy_reduce(). 
FossilOrigin-Name: ef95a7d6490e33a9af4bc7b4b622de7328742ca7
 2016-02-17 01:46:19 +00:00
drh
4dd0d3f819 In Lemon, add the ability for the left-most RHS label to be the same as the 
LHS label, causing the LHS values to be written directly into the stack.

FossilOrigin-Name: 4bb94c7c4c3cb3ccad72c2451d88684130dde845
 2016-02-17 01:18:33 +00:00
drh
45f31be85d Experimental changes to Lemon for improved parser performance. 
FossilOrigin-Name: a65d583ce97b8c08157268bd054479cda3957a94
 2016-02-16 21:19:49 +00:00
drh
4a642b6060 Improvements to the way that OOM errors are processed. 
FossilOrigin-Name: c3ef03478a5788c855b3aef385d43ae7f494f440
 2016-02-05 01:55:27 +00:00
dan
895c00e16a Modify the order of terms in an "if" condition to avoid implicitly comparing a dangling pointer to NULL following an OOM error. 
FossilOrigin-Name: 5372f800835da61736a64dcee8b476bbe7ee2e46
 2016-01-28 18:22:46 +00:00
drh
8549d55ead Small performance and size optimization spotted while working on the 
shared-cache problem.

FossilOrigin-Name: 828958ff77a5c239d55302f570077835c093e0fa
 2016-01-07 17:09:43 +00:00
drh
1a1d3cd2f3 Create the new TK_ASTERISK token to represent the "*" in "SELECT *". Formerly 
that operator was TK_ALL, which was also used for UNION ALL.  Less confusion if
they operator symbols are distinct.

FossilOrigin-Name: 201ac6d449431dadc6b29faecd68b559bd64bc9f
 2015-11-19 16:33:31 +00:00
drh
644f4c1bbb Fix a #define in parse.y that disabled unused code in the generated parser. 
FossilOrigin-Name: f84e3085c87cfffe4aba0eb4c4a3298b4027db83
 2015-11-12 15:04:05 +00:00
drh
3334d08989 Save a few bytes in the parser by using "int" instead of "u8" or "u16" for 
all small integer types.

FossilOrigin-Name: 5dcd212bf6489f4698a0ed0f21497c78379f7c0f
 2015-11-10 13:45:21 +00:00
drh
07b09a9420 Remove an unused non-terminal from the grammar. 
FossilOrigin-Name: 3c37c522883ea9f2eec4f0ba5c5141912c003425
 2015-11-10 00:02:49 +00:00
drh
82415f2d8d Change the parser to use the standard "lempar.c" template over in the tool/ 
folder rather than the customized "lempar.c" found in src/.

FossilOrigin-Name: 0a72991f4e54548f6c3268c5a9cac1c8d6437d26
 2015-11-09 19:33:42 +00:00
drh
9109b7f8e1 Factor out adding NOT expression nodes in the parser into a subroutine. 
FossilOrigin-Name: 001854181640bd9b088f2bc16083d84808c3da18
 2015-10-28 16:05:10 +00:00
drh
108aa00a87 Enhances the parser so that it accepts arbitrary expressions for the arguments 
of an index, though the code generator still rejects everything other than
simple column names.  The sqlite3RestrictColumnListSyntax() routine is removed
since that feature is now handled by the parser.

FossilOrigin-Name: bed42116addabcf3dfdc2e2d51ae183965704988
 2015-08-24 20:21:20 +00:00
drh
8981b904b5 Enhance the CREATE VIEW syntax so that the names of columns of the view can 
be specified after the view name.

FossilOrigin-Name: d794b34da6f9c77dfe17773b0b17b22de72cce7f
 2015-08-24 17:42:49 +00:00
drh
bc622bc045 Disallow the use of COLLATE clauses and the ASC and DESC keywords within 
foreign key constraints and in the argument list to common table expressions.

FossilOrigin-Name: 83cbc4d8761498647794affffa961a4fca311be7
 2015-08-24 15:39:42 +00:00
drh
01d230ce05 A list of arguments following a table name translates into equality 
constraints against hidden columns in that table.

FossilOrigin-Name: 40e12cfe4c29475417ba89fb637b4c763cf74016
 2015-08-19 17:11:37 +00:00
drh
8a48b9c0b1 Minor refactor of the SrcList object so that it is able to hold the argument 
list to a table-valued-function in the FROM clause.

FossilOrigin-Name: b919376147597c4b73421abe5788f893baf1560b
 2015-08-19 15:20:00 +00:00
drh
7cea7f95c7 Using "SELECT ALL" instead of just "SELECT" on a query that uses a single 
unflattenable subquery or view in its FROM clause will force the subquery to
be manifested into a temporary table rather than run incrementally using a
co-routine.  This is a stop-gap means of controlling the decision to manifest
while we try to work out a better to make that decision automatically.

FossilOrigin-Name: a29e117d7ecec05da949348689dbfb0d3acb1280
 2015-05-29 01:35:19 +00:00
drh
fccda8a162 CTEs have never add working rowids. So disallow the use of the "rowid" column 
within CTEs.

FossilOrigin-Name: 0055df0445932a43e42b318ef88672dcbe312c3a
 2015-05-27 13:06:55 +00:00
drh
00d5ab7405 Fix handling of queries with VALUES on the left and UNION ALL SELECT on the 
right and a LIMIT clause.

FossilOrigin-Name: c403502cdce8b82e570e6fc49ab7f5144800c189
 2015-05-20 00:15:27 +00:00
drh
e318a7f84c Restrict the scope of a local-use function in the parser. 
FossilOrigin-Name: cd6598f47480a6189df3e4283231833fd246d7fb
 2015-04-16 23:04:17 +00:00
drh
f3151f0a0d Fix a couple of unreachable branches. 
FossilOrigin-Name: 8f391dffcfe068d48f854784648610d8a86f6bc8
 2015-04-16 20:27:09 +00:00
drh
772460fd4c Improvements to the way VALUES clauses are parsed. 
FossilOrigin-Name: ec5a493ad27593ca78899b3001630c1898b940ff
 2015-04-16 14:13:12 +00:00
dan
80103fc614 Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. 
FossilOrigin-Name: eddc05e7bb31fae74daa86e0504a3478b99fa0f2
 2015-03-20 08:43:59 +00:00
drh
2308ed3854 Propagate the COLLATE operator upward through function calls. 
Initial fix for ticket [ca0d20b6cdddec5e8].

FossilOrigin-Name: c053448a55f9d030e8ffe88cf4fc14ada7f6ec19
 2015-02-09 16:09:34 +00:00