History log of /sqlite-3.40.0/test/e_createtable.test (Results 1 – 25 of 35)
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
# 6e85b27c 07-Feb-2022 larrybr <[email protected]>

When create table/view fails due to name taken, say which took it.

FossilOrigin-Name: 9a206e37fb49a203a7b5fdc93c41acc39e9ceb37144c78432a235e2f0d54a210


Revision tags: version-3.37.2, version-3.37.1, version-3.37.0
# 6f991147 20-Nov-2021 drh <>

New test cases for STRICT and NOT NULL in PRIMARY KEY.

FossilOrigin-Name: 0eafbc2f31b83f48833b19894ff3252a63c319ff501506ef9f744cca813a3a24


Revision tags: version-3.36.0, version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3
# 8210233c 20-Mar-2021 drh <>

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

FossilOrigin-Name: 50fbd532602d2c316813046ed6be8be2991c281eb5f295c4c28520a0de73862c


Revision tags: version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0
# 92e21ef0 27-Aug-2020 drh <[email protected]>

Include the original text of the CHECK constraint in the error message for
anonymous CHECK constraints.

FossilOrigin-Name: 5ce34a955bb36d77edc9951cb7ac2ef9c876d7d3ff5852af682f558e248f428c


Revision tags: version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0
# 00bd55e1 20-Mar-2020 dan <[email protected]>

Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias.

FossilOrigin-Name: 75c85ca32f9ae4a28fd8f8ff2f7639599413d22af706e979

Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias.

FossilOrigin-Name: 75c85ca32f9ae4a28fd8f8ff2f7639599413d22af706e9799a0e76cc560d14eb

show more ...


Revision tags: version-3.31.1, version-3.31.0, version-3.30.1, version-3.30.0, version-3.29.0, 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
# 396a1036 13-Sep-2018 drh <[email protected]>

Fix a requirement mark on a test script. No changes to code.

FossilOrigin-Name: 628d5c0aa057c05c7cf84c330a51b8a44720c97250eadf0e5e8c750b7a2969c3


Revision tags: version-3.24.0, version-3.23.2
# e3d511c0 04-May-2018 drh <[email protected]>

Fix requirements marks. No code changes.

FossilOrigin-Name: 7fdad122a21e4b01bd678198fd5131dc32febe3af366bd6368505398255f9822


# cdf88760 02-May-2018 drh <[email protected]>

More test case updates. Tests are all running now.

FossilOrigin-Name: dab5e5294813891469660cceb211ac1a1e526715bb57dcdbb1ab90321e6a4dad


Revision tags: 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
# b3366b99 11-Sep-2015 drh <[email protected]>

Update evidence marks due to wording changes in requirements text. No
changes to code.

FossilOrigin-Name: 86781093bdb4c4fdedd228cb1c8961db48a483bb


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
# 8da47419 03-Oct-2014 drh <[email protected]>

Update to requirements marks related to changes in the memory allocation
interface and enhancement of the documentation regarding DEFAULT clauses
in CREATE TABLE.

FossilOrigin-Name: 440705b98a3429b8

Update to requirements marks related to changes in the memory allocation
interface and enhancement of the documentation regarding DEFAULT clauses
in CREATE TABLE.

FossilOrigin-Name: 440705b98a3429b830ea85e71cc1e414bc6d8058

show more ...


Revision tags: version-3.8.6
# e8a537ee 08-Aug-2014 drh <[email protected]>

Update requirements marks. No changes to code.

FossilOrigin-Name: 7556bd9aa5db1b9cd92d0e48effcda9fe96f3128


Revision tags: version-3.8.5
# 1f8bb4b0 26-Apr-2014 drh <[email protected]>

Update requirements marks to fix typos in the requirements text.
No changes to code.

FossilOrigin-Name: f5a263658187250044afc1a74000e6f6962733ca


Revision tags: 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
# 9338642c 27-Nov-2013 drh <[email protected]>

Update documentation of sqlite3_column() for clarity. Update evidence marks
on test cases.

FossilOrigin-Name: ec2d47a1db2349d5c9b4fe465506e0e347f77921


# bbbb0e80 26-Nov-2013 drh <[email protected]>

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 incl

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.

FossilOrigin-Name: 0978bac6b8aee229d7a0d148546f50d380d06a06

show more ...


# eb091cdf 09-Nov-2013 drh <[email protected]>

Updates to requirements marks. No changes to code.

FossilOrigin-Name: 8a0366285b94dc43d932736e7b1eedb71e241857


# f9c8ce3c 05-Nov-2013 drh <[email protected]>

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.

FossilOrigin-Name

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.

FossilOrigin-Name: 54b221929744b1bcdbcc2030fef2e510618afd41

show more ...


# 00012df4 05-Nov-2013 drh <[email protected]>

Add the conflict2.test script. Fix issues discovered by this script.

FossilOrigin-Name: 294ed33756b06375e56c41f1088d42ee48adbdc8


Revision tags: version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0
# 39759747 02-Aug-2013 drh <[email protected]>

Updates to requirements marks. No code changes.

FossilOrigin-Name: 213020769f310aec1591d97756b53891d0b64005


# 5822d6fe 10-Jun-2013 drh <[email protected]>

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the
wherecosttest tool. Other fixes to logarithm cost.

FossilOrigin-Name: aa580e368e3c398b8377b80342dfdd906324c248


Revision tags: version-3.7.17, version-3.7.16.2, version-3.7.16.1
# 48864df9 21-Mar-2013 mistachkin <[email protected]>

Many spelling fixes in comments. No changes to code.

FossilOrigin-Name: 6f6e2d50941e444ebc83604daddcc034137a05b7


Revision tags: version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1
# 3f4d1d1b 15-Sep-2012 drh <[email protected]>

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.

FossilOrigin-Name: cfaa7bc12847a7006ccc93815f

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.

FossilOrigin-Name: cfaa7bc12847a7006ccc93815f2395ad5259744a

show more ...


Revision tags: version-3.7.14, version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11, version-3.7.10
# f4692ccc 30-Dec-2011 drh <[email protected]>

Fix up requirements marks for syntax diagrams to reflect the new and improved
GIF renderings.

FossilOrigin-Name: 1bb23a3b5297e07e08c26362f71aef0c5b978875


Revision tags: version-3.7.9, version-3.7.8, version-3.7.7.1, version-3.7.7, version-3.7.6.3
# fc083ab9 20-Apr-2011 dan <[email protected]>

Update a comment in e_createtable.test.

FossilOrigin-Name: d8b149f5e465f7794739ed0210e1e5c53110ee9a


Revision tags: version-3.7.6.2, version-3.7.6.1, version-3.7.6, version-3.7.5
# 083310df 28-Jan-2011 drh <[email protected]>

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 no

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.

FossilOrigin-Name: 4847c6cb71423248b186ab7842b97c83e2f5fefd

show more ...


Revision tags: version-3.7.4
# 4bc39fa1 13-Nov-2010 dan <[email protected]>

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.

FossilOrigin-Name: 6611b76b0296875fb99

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.

FossilOrigin-Name: 6611b76b0296875fb9903b25dfaa783a9c12eaa1

show more ...


12