SQLite

All files named ”test/e_createtable.test”
Login

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

History for test/e_createtable.test

2023-02-18
20:31
[31b9bcb6ac] part of check-in [655991f5d9] Fix stale requirement marks and fix a typo in the documentation for sqlite3_preupdate_hook(). (check-in: [655991f5d9] user: drh branch: trunk, size: 73457)
2022-02-07
01:09
[e3b9782e80] part of check-in [9a206e37fb] When create table/view fails due to name taken, say which took it. (check-in: [9a206e37fb] user: larrybr branch: trunk, size: 73477)
2021-11-20
13:30
[04c50b7fe4] part of check-in [0eafbc2f31] New test cases for STRICT and NOT NULL in PRIMARY KEY. (check-in: [0eafbc2f31] user: drh branch: trunk, size: 73479)
2021-03-20
15:11
[7997c0106c] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 73126)
2020-08-27
18:36
[7107f5deda] 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: 73144)
2020-07-29
16:18
[87eea82741] 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: 73126)
2020-03-20
20:54
[ea27082d6f] part of check-in [75c85ca32f] Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias. (check-in: [75c85ca32f] user: dan branch: main-alias-fix, size: 73125)
2018-09-13
13:17
[1c602347e7] part of check-in [628d5c0aa0] Fix a requirement mark on a test script. No changes to code. (check-in: [628d5c0aa0] user: drh branch: trunk, size: 72897)
2018-05-04
18:32
[e1c4512b9e] part of check-in [7fdad122a2] Fix requirements marks. No code changes. (check-in: [7fdad122a2] user: drh branch: trunk, size: 72902)
2018-05-02
19:42
[ef30054d1e] part of check-in [dab5e52948] More test case updates. Tests are all running now. (check-in: [dab5e52948] user: drh branch: rework-EQP, size: 72887)
2015-09-11
20:54
[d4c6059d44] part of check-in [86781093bd] Update evidence marks due to wording changes in requirements text. No changes to code. (check-in: [86781093bd] user: drh branch: trunk, size: 72899)
2014-10-03
14:54
[c7e67b49e6] part of check-in [440705b98a] Update to requirements marks related to changes in the memory allocation interface and enhancement of the documentation regarding DEFAULT clauses in CREATE TABLE. (check-in: [440705b98a] user: drh branch: trunk, size: 72915)
2014-08-08
18:26
[181653f6f4] part of check-in [7556bd9aa5] Update requirements marks. No changes to code. (check-in: [7556bd9aa5] user: drh branch: trunk, size: 72873)
2014-04-26
19:23
[ed82efcedc] part of check-in [f5a2636581] Update requirements marks to fix typos in the requirements text. No changes to code. (check-in: [f5a2636581] user: drh branch: trunk, size: 72874)
2013-11-27
19:17
[ee95d48664] part of check-in [ec2d47a1db] Update documentation of sqlite3_column() for clarity. Update evidence marks on test cases. (check-in: [ec2d47a1db] user: drh branch: trunk, size: 72819)
2013-11-26
23:27
[a4561b9306] part of check-in [0978bac6b8] Make sure the update hook is not invoked for WITHOUT ROWID tables, as the documentation specifies. This bug was found while adding requirements marks, so a few extraneous requirements marks are included in this check-in. (check-in: [0978bac6b8] user: drh branch: trunk, size: 72819)
2013-11-09
19:47
[3b453432cd] part of check-in [8a0366285b] Updates to requirements marks. No changes to code. (check-in: [8a0366285b] user: drh branch: trunk, size: 72468)
2013-11-05
13:33
[f1d21fa142] 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: 71974)
01:59
[b0dcad4160] 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: 71587)
2013-08-02
23:40
[ee9b70a383] part of check-in [213020769f] Updates to requirements marks. No code changes. (check-in: [213020769f] user: drh branch: trunk, size: 71537)
2013-06-10
23:30
[ddf3b2e450] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 71773)
2013-03-21
21:20
[d4e17024b1] part of check-in [6f6e2d5094] Many spelling fixes in comments. No changes to code. (check-in: [6f6e2d5094] user: mistachkin branch: trunk, size: 71809)
2012-09-15
18:45
[0a24657361] part of check-in [cfaa7bc128] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 71810)
2011-12-30
16:07
[48598b15e8] part of check-in [1bb23a3b52] Fix up requirements marks for syntax diagrams to reflect the new and improved GIF renderings. (check-in: [1bb23a3b52] user: drh branch: trunk, size: 71795)
2011-04-20
13:35
[4771686a58] part of check-in [d8b149f5e4] Update a comment in e_createtable.test. (check-in: [d8b149f5e4] user: dan branch: trunk, size: 72053)
2011-01-28
01:57
[b40fc61bc4] part of check-in [4847c6cb71] Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. (check-in: [4847c6cb71] user: drh branch: stat2-enhancement, size: 72052)
2010-11-13
16:42
[b8f5286879] part of check-in [6611b76b02] Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. (check-in: [6611b76b02] user: dan branch: experimental, size: 72052)
2010-11-11
11:43
[5fd86f532e] part of check-in [7ae068952f] Fix a bug in the EXPLAIN QUERY PLAN code. (check-in: [7ae068952f] user: dan branch: experimental, size: 72039)
10:36
[0aa5dadca8] part of check-in [30904ef841] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef841] user: dan branch: experimental, size: 72039)
2010-10-08
16:09
[049dcbd95e] part of check-in [38bec827f1] Add tests to e_createtable.test. (check-in: [38bec827f1] user: dan branch: trunk, size: 71977)
2010-10-04
10:45
[9c7921d3e4] part of check-in [70f511872e] Add tests for table-constraints to e_createtable.test. (check-in: [70f511872e] user: dan branch: trunk, size: 60977)
2010-10-01
19:04
[03597fda51] part of check-in [fb8db5581d] Add tests for CHECK and UNIQUE constraints to e_createtable.test. (check-in: [fb8db5581d] user: dan branch: trunk, size: 53433)
2010-09-30
18:43
[38ab5e0107] part of check-in [0a4528d629] Add further tests to e_createtable.test. (check-in: [0a4528d629] user: dan branch: trunk, size: 46880)
2010-09-29
18:26
[b4dbe3c0c9] part of check-in [f34dc54d46] Add test cases to e_createtable.test. (check-in: [f34dc54d46] user: dan branch: trunk, size: 37633)
13:31
[0d2278deb9] part of check-in [1ef0dc9328] Add tests for "CREATE TABLE ... AS SELECT ..." statements to e_createtable.test. (check-in: [1ef0dc9328] user: dan branch: trunk, size: 27651)
2010-09-28
17:34
[089acf08bb] part of check-in [6251e58740] Add tests to e_createtable.test. Allow a table to be created if there is an index of the same name in a different attached database. (check-in: [6251e58740] user: dan branch: trunk, size: 20170)
2010-09-25
17:29
Added: [2b3257a5b7] part of check-in [20e16fef55] Add new file e_createtable.test. (check-in: [20e16fef55] user: dan branch: trunk, size: 10986)