Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/limit.test
|
2021-03-05
| ||
| 14:08 | [350f5d03c2] part of check-in [90c6b9fcb0] Fix the processing of implied LIMIT clauses when flattening a compound query. (check-in: [90c6b9fcb0] user: drh branch: trunk, size: 17407) | |
|
2015-03-05
| ||
| 01:29 | [0c99a27a87] part of check-in [e7991bc510] New requirements marks on compound SELECT statements. (check-in: [e7991bc510] user: drh branch: trunk, size: 16529) | |
|
2014-03-21
| ||
| 18:16 | [3d7df19c35] part of check-in [179ef81648] Fix the OFFSET clause so that it works correctly on queries that lack a FROM clause. Ticket [07d6a0453d4ed8]. (check-in: [179ef81648] user: drh branch: trunk, size: 16273) | |
|
2013-01-30
| ||
| 01:46 | [cc0ab63385] part of check-in [7d346250e8] Remove some debugging logic accidently left in the limit.test module. (check-in: [7d346250e8] user: drh branch: trunk, size: 15879) | |
|
2013-01-29
| ||
| 23:55 | [d31ab07cd3] part of check-in [497ee36cb8] Fix LIMIT and OFFSET so that they work and do not leak memory even on complex queries involving deeply nested views of UNION ALL compounds. Ticket [db4d96798da8]. Secondary to ticket [d58ccbb3f1b7]. (check-in: [497ee36cb8] user: drh branch: trunk, size: 15973) | |
|
2008-08-02
| ||
| 03:50 | [2db7b3b34f] part of check-in [f1e44eb323] Additional coverage testing. Fix a segfault following OOM in sqltie3_load_extension(). (CVS 5523) (check-in: [f1e44eb323] user: drh branch: trunk, size: 11798) | |
|
2008-01-16
| ||
| 18:20 | [ca61a9fc52] part of check-in [3a289b6d28] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d28] user: danielk1977 branch: trunk, size: 11305) | |
|
2006-06-20
| ||
| 11:01 | [2a87b9cb21] part of check-in [c6ea353bd9] Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) (check-in: [c6ea353bd9] user: danielk1977 branch: trunk, size: 11307) | |
|
2006-04-26
| ||
| 17:39 | [71884068d4] part of check-in [7f3ef7ddba] Get LIMIT 0 working on subqueries. Ticket #1784. (CVS 3177) (check-in: [7f3ef7ddba] user: drh branch: trunk, size: 11254) | |
|
2006-03-03
| ||
| 19:12 | [1d5a45f21f] part of check-in [cdca3383c5] Ignore leading spaces on text to numeric conversions. Ticket #1662. Fixes to test cases broken by the recent changes to round(). (CVS 3118) (check-in: [cdca3383c5] user: drh branch: trunk, size: 11143) | |
|
2006-01-17
| ||
| 09:35 | [f593d0ff02] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 11100) | |
|
2006-01-08
| ||
| 18:10 | [4b538057d5] part of check-in [b2ac0be07e] Get LIMIT and OFFSET working again for negative limits and offsets. Ticket #1586. (CVS 2889) (check-in: [b2ac0be07e] user: drh branch: trunk, size: 11092) | |
|
2005-09-08
| ||
| 10:37 | [39f084f4e5] part of check-in [21adf4bd99] The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: [21adf4bd99] user: drh branch: trunk, size: 10577) | |
|
2005-02-05
| ||
| 12:48 | [270b076f31] part of check-in [515e5033a5] Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) (check-in: [515e5033a5] user: danielk1977 branch: trunk, size: 10589) | |
|
2005-01-21
| ||
| 04:25 | [f833e610ab] part of check-in [d4e19efcef] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efcef] user: danielk1977 branch: trunk, size: 9823) | |
| 03:12 | [9913f3cc79] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 9797) | |
|
2005-01-20
| ||
| 02:17 | [56101a4533] part of check-in [d267fb3ca3] Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) (check-in: [d267fb3ca3] user: danielk1977 branch: trunk, size: 9140) | |
|
2005-01-15
| ||
| 01:52 | [f509165de5] part of check-in [92f9d2b2f4] Test coverage improvements. (CVS 2215) (check-in: [92f9d2b2f4] user: drh branch: trunk, size: 9061) | |
|
2004-12-16
| ||
| 21:09 | [0225cadf96] part of check-in [ece0085f86] Make sure LIMITs are handled correctly on UNION operators. Ticket #1035. (CVS 2166) (check-in: [ece0085f86] user: drh branch: trunk, size: 8900) | |
|
2004-11-22
| ||
| 13:35 | [c7bddad249] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 8275) | |
| 08:43 | [4798e01961] part of check-in [711e8d7695] Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) (check-in: [711e8d7695] user: danielk1977 branch: trunk, size: 8230) | |
|
2004-08-20
| ||
| 18:34 | [f7c06fccd7] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 8185) | |
|
2004-07-19
| ||
| 23:38 | [e4ee72ab48] part of check-in [9d4f43f030] Refinements to the LIMIT patch (1823) for ticket #749. (CVS 1825) (check-in: [9d4f43f030] user: drh branch: trunk, size: 8181) | |
| 23:33 | [c6365450f3] part of check-in [db5ae13db3] Limit occurs after DISTINCT. Ticket #749. (CVS 1824) (check-in: [db5ae13db3] user: drh branch: version_2, size: 8219) | |
| 23:16 | [404a540e3f] part of check-in [e6bc8aa808] LIMIT occurs after DISTINCT. Ticket #749. (CVS 1823) (check-in: [e6bc8aa808] user: drh branch: trunk, size: 7987) | |
|
2004-05-27
| ||
| 17:22 | [60d7f856ee] part of check-in [287f86731c] Remove the COPY command. (CVS 1477) (check-in: [287f86731c] user: drh branch: trunk, size: 7742) | |
|
2004-05-14
| ||
| 21:12 | [94c5dca1e8] part of check-in [8d9eab178f] Cache record headers in the OP_Column opcode. (CVS 1382) (check-in: [8d9eab178f] user: drh branch: trunk, size: 7775) | |
|
2004-03-08
| ||
| 13:26 | [e28ce938dd] part of check-in [2c6bd21ed0] Bump the version number to 2.8.13. Patch up the limit test so that it works in spite of ticket #521 - we don't want any tests failing in an official release even if there are bugs. :-D (CVS 1285) (check-in: [2c6bd21ed0] user: drh branch: trunk, size: 7758) | |
|
2003-07-20
| ||
| 01:16 | [fa2a8b3fe3] part of check-in [543479e3ae] Fix the LIMIT clause so that it applies to the entire query in a compound query. Prior to this change LIMITs on compound queries did not work at all. Ticket #393. (CVS 1058) (check-in: [543479e3ae] user: drh branch: trunk, size: 7738) | |
|
2003-07-16
| ||
| 11:51 | [87ca391044] part of check-in [a31d0bd90a] Make LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346. (CVS 1053) (check-in: [a31d0bd90a] user: drh branch: trunk, size: 5780) | |
| 02:19 | [10991f3f33] part of check-in [e6a752bfef] Allow negative values for LIMIT and OFFSET. Add tests for negative LIMITs and OFFSETs. Make the OFFSET work even if LIMIT is 0 or negative. (CVS 1052) (check-in: [e6a752bfef] user: drh branch: trunk, size: 5629) | |
|
2003-02-20
| ||
| 00:44 | [9ffb965a0f] part of check-in [6ef91a364b] Fix the parsing of the LIMIT clause when the limit and offset are separated by a comma. The offset comes before the limit in that case. Ticket #245. (CVS 872) (check-in: [6ef91a364b] user: drh branch: trunk, size: 4849) | |
|
2002-09-08
| ||
| 17:23 | [9f26f874bc] part of check-in [23fe36c7e8] Fix for ticket #147: Honor the ORDER BY and LIMIT clauses in a SELECT even if the destination of that SELECT is a subroutine call. (CVS 747) (check-in: [23fe36c7e8] user: drh branch: trunk, size: 4580) | |
|
2002-08-13
| ||
| 23:02 | [dd932f7572] part of check-in [310ac4fbaf] Make the distinction between text and numeric data. (CVS 710) (check-in: [310ac4fbaf] user: drh branch: trunk, size: 3582) | |
|
2002-06-21
| ||
| 23:01 | [49b44e027a] part of check-in [9d55231079] Fix for bugs #77 and #80: Rework the LIMIT mechanism to be reentrant and to clean up the VDBE stack properly. (CVS 636) (check-in: [9d55231079] user: drh branch: trunk, size: 3579) | |
|
2002-06-14
| ||
| 22:38 | [96b33e108e] part of check-in [699cf36208] Make the LIMIT clause work even if the destination of the SELECT is something other than a callback. (Ticket #66) (CVS 619) (check-in: [699cf36208] user: drh branch: trunk, size: 2050) | |
|
2002-05-24
| ||
| 16:14 | [6f98bcefc9] part of check-in [e238643efd] Add support for the full SQL join syntax. This is just a parser enhancement. We now recognize all kinds of joins, but we don't actually do anything with them yet. (CVS 586) (check-in: [e238643efd] user: drh branch: trunk, size: 1683) | |
|
2001-11-06
| ||
| 14:10 | Added: [a930f3eba2] part of check-in [177012249a] Added support for LIMIT. (CVS 302) (check-in: [177012249a] user: drh branch: trunk, size: 1671) | |