SQLite

All files named ”test/rowid.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/rowid.test

2024-03-21
10:35
[d27191b5ce] part of check-in [66c69e2f20] Fix all test cases so that they work with SQLITE_ALLOW_ROWID_IN_VIEW. (check-in: [66c69e2f20] user: drh branch: trunk, size: 23446)
2024-03-19
19:56
[aaa2572271] part of check-in [0615bdae2d] Return the error "ambiguous column name: rowid", instead of "no such column: rowid", when a "rowid" reference is ambiguous. (check-in: [0615bdae2d] user: drh branch: rowid-in-view, size: 23439)
16:51
[f1e1516972] part of check-in [0c543c51a8] Update test scripts to account for [8fcea4cd]. (check-in: [0c543c51a8] user: dan branch: rowid-in-view, size: 23430)
15:27
[17e2a82e05] part of check-in [495b8c7b08] Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW. (check-in: [495b8c7b08] user: dan branch: rowid-in-view, size: 23435)
14:55
[9910c999e5] part of check-in [021f34fcfe] Return the error "ambiguous column name: rowid", instead of "no such column: rowid", when a "rowid" reference is ambiguous. (check-in: [021f34fcfe] user: dan branch: ambiguous-rowid-error, size: 22838)
2021-07-01
18:19
[e29025be95] part of check-in [d4097364c5] Allow unqualified "rowid" references to be used in join queries, provided that only one of the source objects has a rowid. Forum post ab5b077c32636e49 (check-in: [d4097364c5] user: dan branch: trunk, size: 22828)
2020-07-29
16:18
[c110a5eb17] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 21779)
2019-05-14
20:25
[bfbd7b97d9] part of check-in [bc7d2c1656] Fix a problem with the fix for [9cf6c9bb51] (commit [658b84d7]) that could cause a cursor to be left in an invalid state following a (rowid < text-value) search. (check-in: [bc7d2c1656] user: dan branch: trunk, size: 21778)
2019-05-08
11:42
[6d43c560e2] part of check-in [a870c196d7] Fix VDBE opcodes OP_SeekLT and OP_SeekLE so that they work on intkey tables with non-numeric text values. (check-in: [a870c196d7] user: dan branch: tkt-9cf6c9bb, size: 21209)
2015-08-31
14:27
[5b7509f384] part of check-in [7bde6d4d8c] Merge the latest enhancements from trunk. (check-in: [7bde6d4d8c] user: drh branch: index-expr, size: 19714)
2015-08-25
16:57
[09fcded0c9] part of check-in [efaabdb716] Add code to maintain indexes with expression arguments across DELETE, INSERT, and UPDATE statements. Legacy tests pass, but the new code paths are still largely untested. The query planner currently makes no effort to use expression indexes. (check-in: [efaabdb716] user: drh branch: index-expr, size: 19628)
2014-09-26
01:10
[742b574158] part of check-in [e93aecc090] If an SQL function makes a recursive call to do an INSERT into the same database, make sure that the last_insert_rowid() for that INSERT is recorded. (check-in: [e93aecc090] user: drh branch: trunk, size: 19601)
2014-09-25
12:31
[9ffee168c4] part of check-in [1330c72e17] Simplification to the random rowid picking logic that begins running when the maximum possible rowid has already been used. (check-in: [1330c72e17] user: drh branch: trunk, size: 19104)
2013-11-27
00:45
[b78b30afb9] part of check-in [b408d78810] Add additional test cases and requirements evidence marks for WITHOUT ROWID. (check-in: [b408d78810] user: drh branch: trunk, size: 19089)
2012-08-25
10:01
[f777404492] part of check-in [9b19b84753] Fix all known instances of 'repeated the' style typos in comments. No changes to code. (check-in: [9b19b84753] user: mistachkin branch: trunk, size: 18977)
2009-06-26
15:14
[e58e0acef3] part of check-in [96729b2d49] Remove the priorNewRowid field from the sqlite3 structure. Use the last_insert_rowid as the initial value when searching for a new random rowid in the OP_NewRowid opcode. (CVS 6824) (check-in: [96729b2d49] user: drh branch: trunk, size: 18981)
2008-01-19
20:11
[1c8fc43c60] part of check-in [af129b6d15] Miscellaneous code simplifications and cleanup and test coverage enhancements. (CVS 4730) (check-in: [af129b6d15] user: drh branch: trunk, size: 18874)
2007-04-25
11:32
[d125991eea] part of check-in [0935cdf82a] Fix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS 3869) (check-in: [0935cdf82a] user: drh branch: trunk, size: 18039)
2005-01-21
03:12
[040a3bef06] 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: 18046)
2004-11-04
04:42
[1ce3f1520d] part of check-in [c33b3a6137] All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) (check-in: [c33b3a6137] user: drh branch: trunk, size: 17755)
2004-06-27
21:31
[b3d059f5c8] part of check-in [792b3c75e7] Remove unused routines from vdbeaux.c. Improve test coverage. (CVS 1746) (check-in: [792b3c75e7] user: drh branch: trunk, size: 17483)
2004-06-19
00:16
[8845b48613] part of check-in [d705d051be] Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) (check-in: [d705d051be] user: drh branch: trunk, size: 17106)
2004-05-13
11:34
[863e6e7587] part of check-in [dbe8385ecf] Various minor fixes and updates to make more test cases pass. (CVS 1370) (check-in: [dbe8385ecf] user: danielk1977 branch: trunk, size: 17113)
2004-01-14
21:59
[77f7e8c7ca] part of check-in [c9ac3db8e0] Fix comparisons of ROWID against floating point numbers so that they work correctly. Ticket #377 and #567. (CVS 1178) (check-in: [c9ac3db8e0] user: drh branch: trunk, size: 17047)
2003-07-06
17:22
[1936d0d866] part of check-in [982aa3356b] Correctly handle comparing an INTEGER PRIMARY KEY against a floating point number. Ticket #377. (CVS 1045) (check-in: [982aa3356b] user: drh branch: trunk, size: 11747)
2003-06-01
01:10
[e4d6d619d8] part of check-in [903adbe802] Add the ability to INSERT or UPDATE using the "rowid" column even on tables that lack an integer primary key. (CVS 991) (check-in: [903adbe802] user: drh branch: trunk, size: 10827)
2003-04-15
19:22
[532b3d8aa0] part of check-in [0b996959b8] Get triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291. This may also fix #159. Still need to add tests so both bugs remain open for the time being. (CVS 908) (check-in: [0b996959b8] user: drh branch: trunk, size: 10768)
14:01
[82bd07c959] part of check-in [96a717661a] Do not record the inserted rowid on when doing an INSERT within a trigger. Ticket #290. (CVS 906) (check-in: [96a717661a] user: drh branch: trunk, size: 10766)
2002-02-19
22:42
[4c55943300] part of check-in [1686196a8a] New ROWIDs are numbered sequentially. (CVS 383) (check-in: [1686196a8a] user: drh branch: trunk, size: 9810)
2002-01-04
03:09
[cb023f2df3] part of check-in [011be9a9d2] An attempt to delete a single row using a WHERE clause that specifies the rowid would result in an error if the rowid did not exist. This problem has been resolved. (CVS 338) (check-in: [011be9a9d2] user: drh branch: trunk, size: 8121)
2001-11-08
00:45
[ba56df896c] part of check-in [262bcd17df] The new code for taking advantage of inequalities in WHERE clauses is in place. It appears to work. (CVS 305) (check-in: [262bcd17df] user: drh branch: trunk, size: 7706)
2001-09-18
02:02
[427bfbbe96] part of check-in [8f28a83aba] Bug fixes. Trying to make it go faster. (CVS 254) (check-in: [8f28a83aba] user: drh branch: trunk, size: 7606)
2001-09-16
00:13
[b6ce03dd39] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 7414)
2001-09-15
00:58
[2329d6c7cf] part of check-in [264f23315e] Release 2.0-alpha-1 (CVS 247) (check-in: [264f23315e] user: drh branch: trunk, size: 7957)
2001-08-19
18:19
[b01e6dec09] part of check-in [c15f6ffc4d] Add index access methods to the DBBE in preparation for adding a new DBBE for the btree.c module. (CVS 236) (check-in: [c15f6ffc4d] user: drh branch: trunk, size: 7944)
2001-04-04
11:48
Added: [128453599d] part of check-in [35a8feed0d] Added transaction support (CVS 196) (check-in: [35a8feed0d] user: drh branch: trunk, size: 7944)