SQLite

All files named ”test/without_rowid1.test”
Login

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

History for test/without_rowid1.test

2025-04-10
10:18
[f6e75e3282] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 16012)
2025-02-21
20:35
[545a98bde0] part of check-in [5822feec43] The number of declared columns in an index is limited to SQLITE_LIMIT_COLUMN. But the actual number of columns in the implementation might need to be twice as much to account for the primary key at the end. Ensure that the code is able to deal with this. This is a correction to check-in [d7729dbbf231d57c]. (check-in: [5822feec43] user: drh branch: trunk, size: 16024)
17:03
[7120af6764] part of check-in [d7729dbbf2] Detect when a UNIQUE or PRIMARY KEY on a WITHOUT ROWID table would need to use more than SQLITE_LIMIT_COLUMN columns and raise an error. Also include some unrelated compiler warning fixes. (check-in: [d7729dbbf2] user: drh branch: trunk, size: 15813)
2022-02-11
21:20
[a5210b8770] part of check-in [ca22a64e6f] Fix a test in without_rowid1.test so that it is disabled without ALTER TABLE support, as it uses ALTER TABLE. (check-in: [ca22a64e6f] user: drh branch: trunk, size: 15254)
2022-01-01
17:21
[78fd9b437f] part of check-in [c76a4c0b3c] Remove an obsolete assert() statement that no longer does anything useful and which is not always true. Fix for PoC #1 of forum post d7338bf4901f1151. (check-in: [c76a4c0b3c] user: drh branch: trunk, size: 15210)
2021-10-01
20:39
[df3de14f1c] part of check-in [2f7c946c5f] Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: [2f7c946c5f] user: dan branch: trunk, size: 14713)
2021-09-21
17:26
[a1c144156d] part of check-in [2c0e7ae541] Add the "PRAGMA table_list" command with its corresponding eponymous table-valued function: "pragma_table_list". (check-in: [2c0e7ae541] user: drh branch: trunk, size: 14668)
2021-05-13
13:43
[6abc5d497f] part of check-in [c21bc5a235] The content columns of the index-btree that implements a WITHOUT ROWID table are not ordered and so the query planner should not assume they are ordered. Fix for the issue identified by forum post 6c8960f545. (check-in: [c21bc5a235] user: drh branch: trunk, size: 14573)
2020-08-27
18:36
[e4034c0849] part of check-in [5ce34a955b] Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints. (check-in: [5ce34a955b] user: drh branch: trunk, size: 14165)
2020-07-29
16:18
[33092134f3] 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: 14161)
2019-11-07
14:51
[9cfb83705c] part of check-in [34f64f11ca] 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] (check-in: [34f64f11ca] user: drh branch: trunk, size: 14160)
2019-10-03
14:36
[0abe18762b] part of check-in [3934d2d08e] Fix some test script issues that come up with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [3934d2d08e] user: dan branch: trunk, size: 13599)
2019-08-08
15:24
[f40c275727] part of check-in [1e17ea2fd1] 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. (check-in: [1e17ea2fd1] user: drh branch: omit-stat3, size: 13441)
2019-07-17
12:42
[edfccaea4c] part of check-in [340378c1e6] 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. (check-in: [340378c1e6] user: drh branch: wor-pk-dups, size: 13582)
2019-05-14
00:43
[89d101a7c6] part of check-in [f7aadfab3b] Disable index seek optimizations on REINDEX when the order of primary keys in the index differs from the main table. Fix for ticket [bba7b69f9849b5bf11b4]. (check-in: [f7aadfab3b] user: drh branch: trunk, size: 13030)
2019-04-29
13:48
[7ac016d203] part of check-in [1b1dd4d48c] 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. (check-in: [1b1dd4d48c] user: drh branch: trunk, size: 12726)
2019-04-04
20:55
[b5ec93f7df] part of check-in [51a95e52fc] Add further test cases to improve VDBE branch coverage. (check-in: [51a95e52fc] user: dan branch: trunk, size: 12397)
17:58
[c3f84b1095] part of check-in [4cef609d61] Add test cases to improve coverage of VDBE branches. Still some to go. (check-in: [4cef609d61] user: dan branch: trunk, size: 12125)
2018-05-02
18:00
[533add9100] part of check-in [5f0e803e33] 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. (check-in: [5f0e803e33] user: drh branch: rework-EQP, size: 11315)
2018-04-05
16:26
[1cb47a1a5b] part of check-in [a3b02db746] Fix an instance where an uninitialized VM register might be accessed. Fix for [093420fc0]. This problem was found by OSSFuzz. (check-in: [a3b02db746] user: dan branch: trunk, size: 11339)
2017-09-22
20:18
[aafbe8b016] part of check-in [8d2a1cca61] 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. (check-in: [8d2a1cca61] user: drh branch: est_count_pragma, size: 11485)
2017-07-30
18:40
[06b7215130] part of check-in [5216bfb73f] 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. (check-in: [5216bfb73f] user: drh branch: trunk, size: 10957)
2016-10-25
15:39
[eaac24556e] part of check-in [fe49fb0313] 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. (check-in: [fe49fb0313] user: drh branch: index-info-on-table, size: 11024)
2015-05-27
13:06
[1a7b9bd51b] part of check-in [0055df0445] CTEs have never had working rowids. So disallow the use of the "rowid" column within CTEs. (check-in: [0055df0445] user: drh branch: no-rowid-in-cte, size: 10493)
2015-05-26
11:53
[4cda656cb4] part of check-in [3b936913f3] Fix a problem with ignoring UNIQUE constraints on WITHOUT ROWID tables rendered redundant by the PRIMARY KEY. (check-in: [3b936913f3] user: dan branch: trunk, size: 9968)
2014-06-30
15:23
[7862e60575] part of check-in [6624a61d16] Fix where.c so that the primary key values appended to every index entry on a WITHOUT ROWID table may be used when useful. (check-in: [6624a61d16] user: dan branch: stat4-without-rowid, size: 9147)
2014-02-12
14:43
[e00a0a9dc9] part of check-in [5d01426ddf] Make sure "rowid" columns are correctly resolved in joins between normal tables and WITHOUT ROWID tables. Fix for ticket [c34d0557f740c45070]. (check-in: [5d01426ddf] user: drh branch: trunk, size: 7201)
2013-11-05
16:56
[aaa26da19d] part of check-in [4b41d989e8] Remove an "explain" command from test script without_rowid1.test that was accidentally committed. (check-in: [4b41d989e8] user: dan branch: omit-rowid, size: 6765)
16:39
[ba137a86e4] part of check-in [3877c9f505] Unless the destination table is completely empty, disable the xfer optimization for WITHOUT ROWID tables. (check-in: [3877c9f505] user: dan branch: omit-rowid, size: 6819)
14:19
[0b349aa315] part of check-in [99b1fa4b16] 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. (check-in: [99b1fa4b16] user: dan branch: omit-rowid, size: 5531)
13:33
[657fde6092] part of check-in [54b2219297] 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. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 4461)
01:59
[80f14d449a] part of check-in [294ed33756] Add the conflict2.test script. Fix issues discovered by this script. (check-in: [294ed33756] user: drh branch: omit-rowid, size: 4451)
2013-11-02
22:09
[de6f9e6ea3] part of check-in [39e32187b6] 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. (check-in: [39e32187b6] user: drh branch: omit-rowid, size: 4452)
19:34
[e9e8826168] part of check-in [4ee4d31063] 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. (check-in: [4ee4d31063] user: drh branch: omit-rowid, size: 4141)
18:46
[fd74502ecb] part of check-in [9075770e40] Update the ANALYZE logic so that it works with WITHOUT ROWID tables. (check-in: [9075770e40] user: drh branch: omit-rowid, size: 4160)
2013-11-01
18:14
[c25455a420] part of check-in [65384ae0f0] Additional UPDATE test cases for WITHOUT ROWID. (check-in: [65384ae0f0] user: drh branch: omit-rowid, size: 4014)
17:08
[ad5764bbe2] part of check-in [c525ac5630] 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. (check-in: [c525ac5630] user: drh branch: omit-rowid, size: 3045)
2013-10-31
15:37
[e4f023e49a] part of check-in [ad90e762e5] Improved comments and variable names in infrastructure routines of UPDATE, DELETE, and INSERT. (check-in: [ad90e762e5] user: drh branch: omit-rowid, size: 2552)
11:15
[fb3ceaa20b] part of check-in [1adfca6019] 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. (check-in: [1adfca6019] user: drh branch: omit-rowid, size: 2426)
2013-10-30
20:22
Added: [1c3d5a5df9] part of check-in [0d4fea7462] Continue working to get UPDATE operational for WITHOUT ROWID tables. Fix PRAGMA integrity_check so that it works on WITHOUT ROWID tables. (check-in: [0d4fea7462] user: drh branch: omit-rowid, size: 2435)