0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
14 lines
602 B
SQL
14 lines
602 B
SQL
-- Test table name case sensitivity handling across different SQLite operations
|
|
-- Create tables with different case patterns to verify consistent name resolution
|
|
CREATE TABLE users (id integer primary key, name text);
|
|
CREATE TABLE "Authors" (id integer primary key, name text);
|
|
CREATE TABLE Books (id integer primary key, title text);
|
|
|
|
-- Create a temporary table to test drop operations
|
|
CREATE TABLE temp_orders (id integer primary key);
|
|
DROP TABLE temp_orders;
|
|
|
|
-- Create another temp table with quoted identifier
|
|
CREATE TABLE "temp_products" (id integer primary key);
|
|
DROP TABLE "temp_products";
|