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/constraints/unique/test_unique_string.test
# description: UNIQUE constraint on temporary tables with Strings
# group: [unique]
statement ok
CREATE TEMPORARY TABLE integers(i INTEGER, j VARCHAR)
statement ok
CREATE UNIQUE INDEX "uidx" ON "integers" ("j")
statement ok
INSERT INTO integers VALUES (3, '4'), (2, '5')
query IT
SELECT * FROM integers
----
3 4
2 5
statement error
INSERT INTO integers VALUES (6, '6'), (3, '4');
----
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement error
UPDATE integers SET j='77' WHERE j IS NULL
----
query IT
SELECT * FROM integers ORDER BY i, j
----
2 5
3 4
6 NULL
7 NULL
statement ok
UPDATE integers SET j='7777777777777777777777777777' WHERE j IS NULL AND i=6
# we can insert a bunch of null values
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement ok
INSERT INTO integers VALUES (6,NULL), (7,NULL)
statement error
INSERT INTO integers VALUES (3, '4')
----
statement error
INSERT INTO integers VALUES (3, '4')
----
statement ok
DROP TABLE integers
|
