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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
# name: test/sql/attach/attach_enums.test
# description: Test ATTACH of a database with custom enums
# group: [attach]
statement ok
ATTACH '__TEST_DIR__/attach_enums.db' AS db1
statement ok
CREATE TYPE db1.mood AS ENUM ('sad', 'ok', 'happy');
query I
SELECT enum_range(NULL::db1.mood) AS my_enum_range;
----
[sad, ok, happy]
query I
SELECT enum_range(NULL::db1.main.mood) AS my_enum_range;
----
[sad, ok, happy]
statement error
SELECT enum_range(NULL::xx.db1.main.mood) AS my_enum_range;
----
Too many qualifications for type name
statement ok
DROP TYPE db1.mood
statement ok
DROP TYPE IF EXISTS db1.main.mood
statement ok
CREATE TYPE db1.mood AS ENUM ('sad', 'ok', 'happy');
statement ok
CREATE TABLE db1.person (
name text,
current_mood mood
);
statement ok
INSERT INTO db1.person VALUES ('Moe', 'happy');
query TT
select * from db1.person
----
Moe happy
statement ok
DETACH db1
statement ok
ATTACH '__TEST_DIR__/attach_enums.db' AS db1 (READ_ONLY)
query TT
select * from db1.person
----
Moe happy
statement ok
ATTACH '__TEST_DIR__/attach_enums_2.db' AS db2
statement ok
CREATE TYPE db2.mood AS ENUM ('ble','grr','kkcry');
statement ok
CREATE TABLE db2.person (
name text,
current_mood mood
);
statement ok
INSERT INTO db2.person VALUES ('Moe', 'kkcry');
query TT
select * from db1.person
----
Moe happy
query TT
select * from db2.person
----
Moe kkcry
|
