]> git.ipfire.org Git - thirdparty/sqlite.git/history - src/select.c
Do not omit the ORDER BY clause from a recursive CTE just because the
[thirdparty/sqlite.git] / src / select.c
35 hours ago  drhDo not omit the ORDER BY clause from a recursive CTE... master
9 days ago  drhAllow the query planner access to the argument of LIMIT...
9 days ago  drhBetter optimize queries that use parameters in the...
11 days ago  danBetter handle WHERE terms that are common to two or...
12 days ago  drhAddress a corner-case associated with the call-function...
2024-05-24  drhEnsure that queries like "SELECT func(a) FROM tab GROUP...
2024-05-24  danEnsure that queries like "SELECT indeterministic(a...
2024-05-17  danMerge branches "fix-onerow-opt", "faster-openread"... pending-3.46
2024-05-16  drhFix a case where an error in the ORDER BY clause of...
2024-05-15  drhBack out the assert() fixes from [a9443dbfbe25e588... alter-table-fix
2024-05-08  stephanRename a shadowed local var, as reported in [forum...
2024-04-25  drhImprovement to the way that affinity is determined...
2024-04-25  drhFurther improvements to the computation of affinity... compound-subquery-affinity
2024-04-25  drhBack out the previous change on this branch. In its...
2024-04-24  drhAn experimental minor tweak to the way affinities are...
2024-04-08  drhEnhance the WHERE-clause push-down optimization so...
2024-04-07  drhMerge trunk testing enhancements into the pushdown...
2024-04-07  drhMerge trunk enhancements into the pushdown-subquery...
2024-04-07  drhAdd comments to note the name abiguity between the...
2024-04-06  drhDo not allow changes to sqlite3ExprIsTableConstant...
2024-03-24  drhDo not automatically assume that ROWID is NOT NULL...
2024-03-20  danChange EXPLAIN QUERY PLAN output to say "USE TEMP B...
2024-03-20  danChange EXPLAIN QUERY PLAN output to say "USE TEMP B... eqp-orderby
2024-03-20  drhFix the SQLITE_ALLOW_ROWID_IN_VIEW bug-compatibility...
2024-03-19  drhChange the SQLITE_CONFIG_NO_ROWID_IN_VIEW configuration...
2024-03-19  drhReturn the error "ambiguous column name: rowid", instea...
2024-03-19  drhImprovements to the first check-in on this branch,...
2024-03-19  drhWhen compiled with SQLITE_ALLOW_ROWID_IN_VIEW, rowid...
2024-03-19  drhFirst steps toward getting -DSQLITE_ALLOW_ROWID_IN_VIEW...
2024-03-18  drhAdd the "VALUES-as-coroutine" optimization. Large...
2024-03-16  drhRecognize when an SQL function is constant and can...
2024-03-16  drhActivate the enhanced constant-expression for the
2024-03-16  drhEnhance the sqlite3ExprIsConstant() function so that...
2024-03-13  danMerge trunk into this branch.
2024-03-11  danAttempt to reduce the memory used by VALUES clauses...
2024-02-27  danHave "PRAGMA quick_check" compare the number of entries...
2024-02-27  danAllow "_" characters to appear between any two digits...
2024-02-27  stephanBring the extra-src branch up to date with the trunk. extra-src
2024-02-11  drhImproved AggInfo tracing in debug builds. No changes...
2023-12-15  drhIn the count-of-view optimization, deferring freeing...
2023-12-14  drhEnhance aggregate order-by so that it transmits subtype...
2023-12-14  drhPass subtype information through the aggregate ORDER... agg-orderby-subtype
2023-12-07  drhAdd ALWAYS() on branches added in [ec0ae4030968c782...
2023-12-06  drhWork around LLVM's newfound hatred of function pointer...
2023-11-28  danMerge latest trunk updates into this branch.
2023-11-21  drhMerge all recent trunk fixes and enhancements into...
2023-11-21  larrybrSync w/trunk as pre-merge-to-trunk sanity check.
2023-11-18  drhAnother assertion fault fix, similar to [a9443dbfbe25e5...
2023-11-17  drhMerge the latest trunk enhancements and fixes into...
2023-11-17  drhFix an incorrect assert() associated with ALTER TABLE...
2023-11-15  danChanges so that if SQLITE_ENABLE_SETLK_TIMEOUT is defin...
2023-11-15  drhMerge all the latest enhancements and fixes from trunk...
2023-11-11  larrybrPervasive changes to console_io.{c,h} in support of...
2023-11-10  danFix another problem with mixed join types and the RIGHT...
2023-11-10  drhMerge recent trunk enhancements and fixes into the...
2023-11-10  danFix an obscure problem with the join-strength-reduction...
2023-11-08  drhMerge recent trunk enhancements into the jsonb branch...
2023-11-06  danMerge trunk changes into this branch.
2023-11-03  drhBack out the ALWAYS inserted late yesterday. The fuzze...
2023-11-03  drhMerge all the latest trunk fixes and enhancements into...
2023-11-02  drhMark a branch made always-true by the penultimate check...
2023-11-02  stephanMerge latest JNI pieces into trunk.
2023-11-01  drhBring the jsonb branch up-to-date with version 3.44...
2023-10-30  larrybrRemedy CLI non-UTF8 handling detection flaw [forum... win-utf8-io-split
2023-10-30  drhFix another comment typo. No code changes.
2023-10-30  danAdd FTS5 to default Makefile.msc builds. And UNKNOWN_SQ...
2023-10-30  drhFix typo in a comment. No code changes.
2023-10-28  stephanMerge trunk into jni-post-3.44 branch.
2023-10-25  drhAdd an ALWAYS on branch that was made always-true by...
2023-10-25  drhWhen doing a DISTINCT aggregate that contains an ORDER...
2023-10-23  larrybrClear some picky warnings, sync w/trunk. expert-enhancement
2023-10-19  drhMerge recent trunk enhancements into the jsonb branch.
2023-10-19  drhRemove a faulty assert() that was added just a few...
2023-10-19  drhNew assert() statements to help verify correctness...
2023-10-19  drhAdd support for ORDER BY on the argument list of aggreg...
2023-10-19  drhMerge the latest changes from trunk. agg-orderby
2023-10-18  drhChanges for test coverage.
2023-10-18  drhDeal with an OOM condition while processing aggregate...
2023-10-18  drhMake sure all terms of the ORDER BY within an aggregate...
2023-10-18  drhFix one minor error in order to get all legacy tests...
2023-10-18  drhORDER BY on aggregates seem to work, at least for simpl...
2023-09-24  larrybrSync w/trunk prior to merge back.
2023-09-16  danFix resolution of "rowid" and similar identifiers in...
2023-09-16  drhFix minor code indentation inconsistencies. No functio...
2023-09-16  drhFix a harmless compiler warning.
2023-09-15  danAllow expressions like "<tbl>.rowid" to refer to implic...
2023-09-11  drhAdd support for the sqlite3_get_clientdata() and sqlite...
2023-09-01  stephanCorrect a Tester1.java test which inadvertently created...
2023-08-31  danDo not disable unused columns in a UNION ALL sub-query...
2023-08-10  danMerge latest trunk changes into this branch. wal-shm-exceptions
2023-08-10  stephanMerge trunk into jni branch.
2023-08-07  danEnhance sqlite3_vtab_nochange() so that it works with...
2023-08-07  danChanges so that sqlite3_vtab_nochange() works with... fts5-contentless-delete
2023-08-02  drhStricter enforcement of the idea that a MATERIALIZED...
2023-08-02  drhRemove a condition from query flattening that is now... materialize-order-by
2023-08-02  drhSimplify the select.c logic that enforces the optimizat...
2023-08-02  drhNever flatten a CTE that is labeled MATERIALIZED. ...
2023-08-02  drhWhen a query is inside an AS MATERIALIZED CTE, do not...
2023-07-28  drhMerge the latest trunk enhancements into the wal-shm...
2023-07-28  drhAdd the sqlite3_stmt_explain() API.
next