niceSOFT/sqlite: Official Git mirror of the SQLite source tree

test/imposter1.sql

32 строки1 KB

drh

CLI: The .imposter command matches the index name regardless of case.

16 дек 2025, 16:43

16 дек 2025, 16:4393ecf30

#!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