93ecf30068
Minor fixes to .check. FossilOrigin-Name: 989ebba9ad263abafeddaf4a0e3e1275e83a3a12d7f95c7a451ecf8cbd64a583
33 lines
1.0 KiB
SQL
33 lines
1.0 KiB
SQL
#!sqlite3
|
|
#
|
|
# 2025-12-16
|
|
#
|
|
# The author disclaims copyright to this source code. In place of
|
|
# a legal notice, here is a blessing:
|
|
#
|
|
# May you do good and not evil.
|
|
# May you find forgiveness for yourself and forgive others.
|
|
# May you share freely, never taking more than you give.
|
|
#
|
|
#***********************************************************************
|
|
#
|
|
# Test cases for the .imposter command.
|
|
#
|
|
.mode box -reset
|
|
.testcase 100
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT);
|
|
INSERT INTO t1 VALUES(1,'two',3),(4,'five',6);
|
|
CREATE INDEX t1bc ON t1(b,c);
|
|
.imposter T1BC x1
|
|
----------^^^^--- Different case that the original
|
|
SELECT * FROM x1;
|
|
.check <<END
|
|
CREATE TABLE "x1"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
|
|
╭──────┬───┬─────────╮
|
|
│ b │ c │ _ROWID_ │
|
|
╞══════╪═══╪═════════╡
|
|
│ five │ 6 │ 4 │
|
|
│ two │ 3 │ 1 │
|
|
╰──────┴───┴─────────╯
|
|
END
|