History log of /sqlite-3.40.0/test/rowid.test (Results 1 – 25 of 29)
Revision (<<< Hide revision tags) (Show revision tags >>>) Date Author Comments
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0, version-3.38.5, version-3.38.4, relese, version-3.38.3, version-3.38.2, version-3.38.1, version-3.38.0, version-3.37.2, version-3.37.1, version-3.37.0
# b9248ef5 01-Jul-2021 dan <Dan Kennedy>

Allow unqualified "rowid" references to be used in join queries, provided that only one of the source objects has a rowid.

FossilOrigin-Name: d4097364c511709b1874881a0c036640777d1f724165416adf6f53a4

Allow unqualified "rowid" references to be used in join queries, provided that only one of the source objects has a rowid.

FossilOrigin-Name: d4097364c511709b1874881a0c036640777d1f724165416adf6f53a41f8c6e40

show more ...


Revision tags: version-3.36.0, version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3, version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0, version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0, version-3.31.1, version-3.31.0, version-3.30.1, version-3.30.0, version-3.29.0
# a40cb96a 14-May-2019 dan <[email protected]>

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.

FossilOrigin-Name: bc7d2c1656396bb4f

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.

FossilOrigin-Name: bc7d2c1656396bb4f5f1f814e60dbf816cc91c5a521b54ad593cd3da0fe8dcb4

show more ...


# 9edd8c11 08-May-2019 dan <[email protected]>

Fix VDBE opcodes OP_SeekLT and OP_SeekLE so that they work on intkey tables with non-numeric text values.

FossilOrigin-Name: a870c196d78d8b72c7353fa0015e96b2abd4be154541d76328e3a4f9e5da5d04


Revision tags: version-3.28.0, version-3.27.2, version-3.27.1, version-3.27.0, version-3.26.0, version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2, version-3.23.1, version-3.23.0, version-3.22.0, version-3.21.0, version-3.20.1, version-3.19.4, version-3.20.0, version-3.18.2, version-3.18.1, version-3.19.3, version-3.19.2, version-3.19.1, version-3.19.0, version-3.18.0, version-3.17.0, version-3.16.2, version-3.16.1, version-3.16.0, version-3.15.2, version-3.15.1, version-3.15.0, version-3.14.2, version-3.14.1, version-3.14.0, version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0, version-3.11.1, version-3.11.0, version-3.10.2, version-3.10.1, version-3.10.0, version-3.9.2, version-3.9.1, version-3.9.0
# 1f9ca2c8 25-Aug-2015 drh <[email protected]>

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 currentl

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.

FossilOrigin-Name: efaabdb71626bdc03768e87e186c72f6f3da75b2

show more ...


Revision tags: version-3.8.11.1, version-3.8.11, version-3.8.10.2, version-3.8.10.1, version-3.8.10, version-3.8.9, version-3.8.8.3, version-3.8.8.2, version-3.8.8.1, version-3.8.8, version-3.8.7.4, version-3.8.7.3, version-3.8.7.2, version-3.8.7.1, version-3.8.6.1, version-3.8.7
# 3b130beb 26-Sep-2014 drh <[email protected]>

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.

FossilOrigin-Name: e93aecc090c2a1d3c231bb2bde044

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.

FossilOrigin-Name: e93aecc090c2a1d3c231bb2bde044886eff0bdf7

show more ...


# 2c4dc635 25-Sep-2014 drh <[email protected]>

Simplification to the random rowid picking logic that begins running when
the maximum possible rowid has already been used.

FossilOrigin-Name: 1330c72e172324c68ab49e5bb2ceba985935ae01


Revision tags: version-3.8.6, version-3.8.5, version-3.8.4.3, version-3.8.4.2, version-3.8.4.1, version-3.8.4, version-3.8.3.1, version-3.8.3, version-3.8.2
# ef1bd970 27-Nov-2013 drh <[email protected]>

Add additional test cases and requirements evidence marks for WITHOUT ROWID.

FossilOrigin-Name: b408d788105efd007e3546f45d5dd15a5dc5688d


Revision tags: version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0, version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1, version-3.7.14
# d5578433 25-Aug-2012 mistachkin <[email protected]>

Fix all known instances of 'repeated the' style typos in comments. No changes to code.

FossilOrigin-Name: 9b19b847533f944f289d93dcdba29c0d67bf251c


Revision tags: version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11, version-3.7.10, version-3.7.9, version-3.7.8, version-3.7.7.1, version-3.7.7, version-3.7.6.3, version-3.7.6.2, version-3.7.6.1, version-3.7.6, version-3.7.5, version-3.7.4, experimental, version-3.7.2, fts3-refactor, cvs-to-fossil-cutover
# 9ed7a995 26-Jun-2009 drh <[email protected]>

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)

FossilOrigin-Na

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)

FossilOrigin-Name: 96729b2d499f029bfaec6648a592e8ec697d9521

show more ...


Revision tags: version-3.6.15, version-3.6.10
# 91fd4d46 19-Jan-2008 drh <[email protected]>

Miscellaneous code simplifications and cleanup and test coverage
enhancements. (CVS 4730)

FossilOrigin-Name: af129b6d158cc90ce9752dd6383c1de47f7b3e43


# b556ce15 25-Apr-2007 drh <[email protected]>

Fix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS 3869)

FossilOrigin-Name: 0935cdf82a0be599421881117a981d315933bb7e


# 3e8c37e7 21-Jan-2005 danielk1977 <[email protected]>

Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251)

FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a


# 798da52c 04-Nov-2004 drh <[email protected]>

All tests pass even if OMIT_TRIGGER is defined. (CVS 2053)

FossilOrigin-Name: c33b3a613751057e8a46fdcd428b8448329d414d


# 6a179ea7 27-Jun-2004 drh <[email protected]>

Remove unused routines from vdbeaux.c. Improve test coverage. (CVS 1746)

FossilOrigin-Name: 792b3c75e7764bab1473c0d6efc76f1164c943bf


# ef4ac8f9 19-Jun-2004 drh <[email protected]>

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)

FossilOrigin-Name: d705d051bed2b92b6c

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)

FossilOrigin-Name: d705d051bed2b92b6c3bbcc75fe5b056633b9c31

show more ...


# 96fc5fe6 13-May-2004 danielk1977 <[email protected]>

Various minor fixes and updates to make more test cases pass. (CVS 1370)

FossilOrigin-Name: dbe8385ecf1df8bf0b1baf5e811ec5a1de5c4c42


# 751f4121 14-Jan-2004 drh <[email protected]>

Fix comparisons of ROWID against floating point numbers so that they work
correctly. Ticket #377 and #567. (CVS 1178)

FossilOrigin-Name: c9ac3db8e08403398ec344757385334601a59374


# 1dd59e0f 06-Jul-2003 drh <[email protected]>

Correctly handle comparing an INTEGER PRIMARY KEY against a floating point
number. Ticket #377. (CVS 1045)

FossilOrigin-Name: 982aa3356bcc217003cd9e6a829619219c334797


# a0217ba7 01-Jun-2003 drh <[email protected]>

Add the ability to INSERT or UPDATE using the "rowid" column even on tables
that lack an integer primary key. (CVS 991)

FossilOrigin-Name: 903adbe802ca0e987b867e5ad33aae02ad2a43d4


# 70ce3f0c 15-Apr-2003 drh <[email protected]>

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)

FossilOrigin-Name: 0b9

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)

FossilOrigin-Name: 0b996959b8d8bc2c82eab9cccc190befd0056505

show more ...


# 49449834 15-Apr-2003 drh <[email protected]>

Do not record the inserted rowid on when doing an INSERT within a trigger.
Ticket #290. (CVS 906)

FossilOrigin-Name: 96a717661a3b7108fe0cacb588d81fd8e91eb640


# 5cf8e8c7 19-Feb-2002 drh <[email protected]>

New ROWIDs are numbered sequentially. (CVS 383)

FossilOrigin-Name: 1686196a8aea326f616bc8205df99cd84d955ec4


# c6b52df3 04-Jan-2002 drh <[email protected]>

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)

FossilOrigin-Name: 011

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)

FossilOrigin-Name: 011be9a9d2632d261489005d97c69b0a0bc5a108

show more ...


# 487ab3ca 08-Nov-2001 drh <[email protected]>

The new code for taking advantage of inequalities in WHERE clauses
is in place. It appears to work. (CVS 305)

FossilOrigin-Name: 262bcd17df19f45def6144b5a7e0602ca5b03deb


# 1eaa2694 18-Sep-2001 drh <[email protected]>

Bug fixes. Trying to make it go faster. (CVS 254)

FossilOrigin-Name: 8f28a83abac59a2161d486c96386b8df726468d0


12