1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
# name: test/sql/catalog/case_insensitive_binder.test
# description: Test case insensitive binder
# group: [catalog]
statement ok
CREATE TABLE "MyTable"(i integer);
statement ok
SELECT * FROM mytable;
statement ok
SELECT * FROM MyTable;
statement ok
SELECT * FROM "MyTable";
statement ok
ALTER TABLE MyTable ADD COLUMN j INTEGER;
statement ok
ALTER TABLE MyTable RENAME TO "MyOtherTable"
statement ok
DROP TABLE MyOtherTable;
statement ok
CREATE TABLE "ABC"(i integer);
statement error
CREATE TABLE "AbC"(i integer);
----
statement ok
SELECT * FROM "ABC";
statement ok
SELECT * FROM abc; -- error: which table did I mean?
statement ok
ALTER TABLE abc ADD COLUMN j INTEGER;
statement error
ALTER TABLE "ABC" ADD COLUMN "J" INTEGER;
----
statement ok
DROP TABLE abc
|
