/ File History
Login

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

History of test/without_rowid1.test

2019-11-07
14:51
Fix the xferCompatibleIndex() function so that it recognizes that a PRIMARY KEY index for a WITHOUT ROWID table is different from a UNIQUE constraint index on the primary key. Ticket [302027baf1374498] file: [9cfb8370] check-in: [34f64f11] user: drh branch: trunk, size: 14160
2019-10-03
14:36
Fix some test script issues that come up with SQLITE_OMIT_VIRTUALTABLE builds. file: [0abe1876] check-in: [3934d2d0] user: dan branch: trunk, size: 13599
2019-08-08
15:24
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. file: [f40c2757] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 13441
2019-07-17
12:42
New test cases for PRAGMA index_xinfo on a WITHOUT ROWID table. And new testcases using index_xinfo to verify that WITHOUT ROWID tables are constructed correctly. file: [edfccaea] check-in: [340378c1] user: drh branch: wor-pk-dups, size: 13582
2019-05-14
00:43
Disable index seek optimizations on REINDEX when the order of primary keys in the index differs from the main table. Fix for ticket [bba7b69f9849b5bf11b4]. file: [89d101a7] check-in: [f7aadfab] user: drh branch: trunk, size: 13030
2019-04-29
13:48
Do not de-duplicate columns index columns associated with a WITHOUT ROWID table if the columns have different collating sequences. This is the fix for ticket [3182d3879020ef3b2]. There is one test case added, but most of the tests are done in TH3. file: [7ac016d2] check-in: [1b1dd4d4] user: drh branch: trunk, size: 12726
2019-04-04
20:55
Add further test cases to improve VDBE branch coverage. file: [b5ec93f7] check-in: [51a95e52] user: dan branch: trunk, size: 12397
17:58
Add test cases to improve coverage of VDBE branches. Still some to go. file: [c3f84b10] check-in: [4cef609d] user: dan branch: trunk, size: 12125
2018-05-02
18:00
Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. file: [533add91] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 11315
2018-04-05
16:26
Fix an instance where an uninitialized VM register might be accessed. Fix for [093420fc0]. This problem was found by OSSFuzz. file: [1cb47a1a] check-in: [a3b02db7] user: dan branch: trunk, size: 11339
2017-09-22
20:18
Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. file: [aafbe8b0] check-in: [8d2a1cca] user: drh branch: est_count_pragma, size: 11485
2017-07-30
18:40
Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136], a problem discovered by OSSFuzz. file: [06b72151] check-in: [5216bfb7] user: drh branch: trunk, size: 10957
2016-10-25
15:39
Enhance the "PRAGMA index_info" and "PRAGMA index_xinfo" statements so that they work on WITHOUT ROWID tables and provide information about the underlying index btree that implements the WITHOUT ROWID table. file: [eaac2455] check-in: [fe49fb03] user: drh branch: index-info-on-table, size: 11024
2015-05-27
13:06
CTEs have never had working rowids. So disallow the use of the "rowid" column within CTEs. file: [1a7b9bd5] check-in: [0055df04] user: drh branch: no-rowid-in-cte, size: 10493
2015-05-26
11:53
Fix a problem with ignoring UNIQUE constraints on WITHOUT ROWID tables rendered redundant by the PRIMARY KEY. file: [4cda656c] check-in: [3b936913] user: dan branch: trunk, size: 9968
2014-06-30
15:23
Fix where.c so that the primary key values appended to every index entry on a WITHOUT ROWID table may be used when useful. file: [7862e605] check-in: [6624a61d] user: dan branch: stat4-without-rowid, size: 9147
2014-02-12
14:43
Make sure "rowid" columns are correctly resolved in joins between normal tables and WITHOUT ROWID tables. Fix for ticket [c34d0557f740c45070]. file: [e00a0a9d] check-in: [5d01426d] user: drh branch: trunk, size: 7201
2013-11-05
16:56
Remove an "explain" command from test script without_rowid1.test that was accidentally committed. file: [aaa26da1] check-in: [4b41d989] user: dan branch: omit-rowid, size: 6765
16:39
Unless the destination table is completely empty, disable the xfer optimization for WITHOUT ROWID tables. file: [ba137a86] check-in: [3877c9f5] user: dan branch: omit-rowid, size: 6819
14:19
Add tests for updates of without-rowid tables that use non-BINARY collation sequences for the primary key columns. And a minor bugfix to the same. file: [0b349aa3] check-in: [99b1fa4b] user: dan branch: omit-rowid, size: 5531
13:33
Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [657fde60] check-in: [54b22192] user: drh branch: omit-rowid, size: 4461
01:59
Add the conflict2.test script. Fix issues discovered by this script. file: [80f14d44] check-in: [294ed337] user: drh branch: omit-rowid, size: 4451
2013-11-02
22:09
Many new test cases added, that mostly work. Currently 18 errors in without_rowid3.test. Also there is a hack marked by a /*FIXME*/ comment on at fkey.c:547 that needs fixing. file: [de6f9e6e] check-in: [39e32187] user: drh branch: omit-rowid, size: 4452
19:34
Change the "idx" name of the primary key index for WITHOUT ROWID tables in sqlite_statN statistics tables to be the name of the table rather than the fabricated index name (ex: sqlite_autoindex_xyz_1). This makes it consistent with sqlite_master table. file: [e9e88261] check-in: [4ee4d310] user: drh branch: omit-rowid, size: 4141
18:46
Update the ANALYZE logic so that it works with WITHOUT ROWID tables. file: [fd74502e] check-in: [9075770e] user: drh branch: omit-rowid, size: 4160
2013-11-01
18:14
Additional UPDATE test cases for WITHOUT ROWID. file: [c25455a4] check-in: [65384ae0] user: drh branch: omit-rowid, size: 4014
17:08
Change the interface to sqlite3GenerateConstraintChecks() for improved lucidity and to fix issues in dealing with UPDATEs for WITHOUT ROWID tables. Make sure iDataCur and iIdxCur are initialized when processing DELETEs of a VIEW. UPDATE processing distinguishes between changes to ROWID and PRIMARY KEY. file: [ad5764bb] check-in: [c525ac56] user: drh branch: omit-rowid, size: 3045
2013-10-31
15:37
Improved comments and variable names in infrastructure routines of UPDATE, DELETE, and INSERT. file: [e4f023e4] check-in: [ad90e762] user: drh branch: omit-rowid, size: 2552
11:15
Refactor the INSERT, DELETE, and UPDATE code generators to distinguish between the "data cursor" and the "first index cursor", which are no longer consecutive in the case of a WITHOUT ROWID table. file: [fb3ceaa2] check-in: [1adfca60] user: drh branch: omit-rowid, size: 2426
2013-10-30
20:22
Continue working to get UPDATE operational for WITHOUT ROWID tables. Fix PRAGMA integrity_check so that it works on WITHOUT ROWID tables. file: [1c3d5a5d] check-in: [0d4fea74] user: drh branch: omit-rowid, size: 2435 Added