Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit2b4be93

Browse files
author
Thomas G. Lockhart
committed
Modify to match current expected output
 after adding separate sections for DEFAULT and CHECK.
1 parentb8967bf commit2b4be93

File tree

1 file changed

+149
-66
lines changed

1 file changed

+149
-66
lines changed

‎src/test/regress/output/constraints.source‎

Lines changed: 149 additions & 66 deletions
Original file line numberDiff line numberDiff line change
@@ -1,36 +1,90 @@
1-
QUERY: drop sequence seq;
2-
WARN:Relation seq Does Not Exist!
3-
QUERY: drop table test;
4-
WARN:Relation test Does Not Exist!
5-
QUERY: create sequence seq;
6-
QUERY: create table test (x int default nextval ( 'seq') ,
7-
y text default '-NULL-', z int default -1 * currval('seq') )
8-
constraint test1 check (x > 3 and y <> 'check failed' and x < 8 ),
9-
check x + z = 0;
10-
QUERY: insert into test values (null, null, null);
11-
WARN:ExecAppend: rejected due to CHECK constraint test1
12-
QUERY: insert into test values (null, null, -2);
13-
WARN:ExecAppend: rejected due to CHECK constraint test1
14-
QUERY: select * from test;
1+
QUERY: CREATE TABLE DEFAULT_TBL (i int DEFAULT 100,
2+
x text DEFAULT 'vadim', f float8 DEFAULT 123.456);
3+
QUERY: INSERT INTO DEFAULT_TBL VALUES (1, 'thomas', 57.0613);
4+
QUERY: INSERT INTO DEFAULT_TBL VALUES (1, 'bruce');
5+
QUERY: INSERT INTO DEFAULT_TBL (i, f) VALUES (2, 987.654);
6+
QUERY: INSERT INTO DEFAULT_TBL (x) VALUES ('tgl');
7+
QUERY: SELECT '' AS four, * FROM DEFAULT_TBL;
8+
four| i|x | f
9+
----+---+------+-------
10+
| 1|thomas|57.0613
11+
| 1|bruce |123.456
12+
| 2|vadim |987.654
13+
|100|tgl |123.456
14+
(4 rows)
15+
16+
QUERY: CREATE SEQUENCE DEFAULT_SEQ;
17+
QUERY: CREATE TABLE DEFAULTEXPR_TBL (i1 int DEFAULT 100 + (200-199) * 2,
18+
i2 int DEFAULT nextval('default_seq'));
19+
QUERY: INSERT INTO DEFAULTEXPR_TBL VALUES (-1, -2);
20+
QUERY: INSERT INTO DEFAULTEXPR_TBL (i1) VALUES (-3);
21+
QUERY: INSERT INTO DEFAULTEXPR_TBL (i2) VALUES (-4);
22+
QUERY: INSERT INTO DEFAULTEXPR_TBL (i2) VALUES (NULL);
23+
QUERY: SELECT '' AS four, * FROM DEFAULTEXPR_TBL;
24+
four| i1|i2
25+
----+---+--
26+
| -1|-2
27+
| -3| 1
28+
|102|-4
29+
|102| 2
30+
(4 rows)
31+
32+
QUERY: CREATE TABLE error_tbl (i int DEFAULT (100, ));
33+
WARN:parser: parse error at or near ","
34+
QUERY: CREATE TABLE error_tbl (b1 bool DEFAULT 1 < 2);
35+
WARN:boolean expressions not supported in DEFAULT
36+
QUERY: CREATE TABLE CHECK_TBL (x int)
37+
CONSTRAINT CHECK_CON CHECK (x > 3);
38+
QUERY: INSERT INTO CHECK_TBL VALUES (5);
39+
QUERY: INSERT INTO CHECK_TBL VALUES (4);
40+
QUERY: INSERT INTO CHECK_TBL VALUES (3);
41+
WARN:ExecAppend: rejected due to CHECK constraint check_con
42+
QUERY: INSERT INTO CHECK_TBL VALUES (2);
43+
WARN:ExecAppend: rejected due to CHECK constraint check_con
44+
QUERY: INSERT INTO CHECK_TBL VALUES (6);
45+
QUERY: INSERT INTO CHECK_TBL VALUES (1);
46+
WARN:ExecAppend: rejected due to CHECK constraint check_con
47+
QUERY: CREATE SEQUENCE CHECK_SEQ;
48+
QUERY: CREATE TABLE CHECK2_TBL (x int, y text, z int)
49+
CONSTRAINT SEQUENCE_CON CHECK (x > 3 and y <> 'check failed' and x < 8);
50+
QUERY: INSERT INTO CHECK2_TBL VALUES (4, 'check ok', -2);
51+
QUERY: INSERT INTO CHECK2_TBL VALUES (1, 'x check failed', -2);
52+
WARN:ExecAppend: rejected due to CHECK constraint sequence_con
53+
QUERY: INSERT INTO CHECK2_TBL VALUES (5, 'z check failed', 10);
54+
QUERY: INSERT INTO CHECK2_TBL VALUES (0, 'check failed', -2);
55+
WARN:ExecAppend: rejected due to CHECK constraint sequence_con
56+
QUERY: INSERT INTO CHECK2_TBL VALUES (6, 'check failed', 11);
57+
WARN:ExecAppend: rejected due to CHECK constraint sequence_con
58+
QUERY: INSERT INTO CHECK2_TBL VALUES (7, 'check ok', 7);
59+
QUERY: CREATE SEQUENCE INSERT_SEQ;
60+
QUERY: CREATE TABLE INSERT_TBL (x INT DEFAULT nextval('insert_seq'),
61+
y TEXT DEFAULT '-NULL-', z INT DEFAULT -1 * currval('insert_seq') )
62+
CONSTRAINT INSERT_CON CHECK (x > 3 AND y <> 'check failed' AND x < 8),
63+
CHECK x + z = 0;
64+
QUERY: INSERT INTO INSERT_TBL VALUES (null, null, null);
65+
WARN:ExecAppend: rejected due to CHECK constraint insert_con
66+
QUERY: INSERT INTO INSERT_TBL VALUES (null, null, -2);
67+
WARN:ExecAppend: rejected due to CHECK constraint insert_con
68+
QUERY: SELECT * FROM INSERT_TBL;
1569
x|y|z
1670
-+-+-
1771
(0 rows)
1872

19-
QUERY:select nextval('seq');
73+
QUERY:SELECT nextval('insert_seq');
2074
nextval
2175
-------
2276
3
2377
(1 row)
2478

25-
QUERY:insert into test values (null, null, null);
26-
QUERY:insert into test values (1, null, -2);
79+
QUERY:INSERT INTO INSERT_TBL VALUES (null, null, null);
80+
QUERY:INSERT INTO INSERT_TBL VALUES (1, null, -2);
2781
WARN:ExecAppend: rejected due to CHECK constraint $2
28-
QUERY:insert into test values (7, null, -7);
29-
QUERY:insert into test values (5, 'check failed', -5);
30-
WARN:ExecAppend: rejected due to CHECK constrainttest1
31-
QUERY:insert into test values (7, '!check failed', -7);
32-
QUERY:insert into test values (null, null, null);
33-
QUERY:select *from test;
82+
QUERY:INSERT INTO INSERT_TBL VALUES (7, null, -7);
83+
QUERY:INSERT INTO INSERT_TBL VALUES (5, 'check failed', -5);
84+
WARN:ExecAppend: rejected due to CHECK constraintinsert_con
85+
QUERY:INSERT INTO INSERT_TBL VALUES (7, '!check failed', -7);
86+
QUERY:INSERT INTO INSERT_TBL VALUES (null, null, null);
87+
QUERY:SELECT *FROM INSERT_TBL;
3488
x|y | z
3589
-+-------------+--
3690
4|-NULL- |-4
@@ -39,14 +93,14 @@ x|y | z
3993
5|-NULL- |-5
4094
(4 rows)
4195

42-
QUERY:insert into test values (null, 'check failed', 5);
96+
QUERY:INSERT INTO INSERT_TBL VALUES (null, 'check failed', 5);
4397
WARN:ExecAppend: rejected due to CHECK constraint $2
44-
QUERY:insert into test values (5, 'check failed', null);
98+
QUERY:INSERT INTO INSERT_TBL VALUES (5, 'check failed', null);
4599
WARN:ExecAppend: rejected due to CHECK constraint $2
46-
QUERY:insert into test values (5, '!check failed', null);
100+
QUERY:INSERT INTO INSERT_TBL VALUES (5, '!check failed', null);
47101
WARN:ExecAppend: rejected due to CHECK constraint $2
48-
QUERY:insert into test values (null, null, null);
49-
QUERY:select *from test;
102+
QUERY:INSERT INTO INSERT_TBL VALUES (null, null, null);
103+
QUERY:SELECT *FROM INSERT_TBL;
50104
x|y | z
51105
-+-------------+--
52106
4|-NULL- |-4
@@ -56,84 +110,113 @@ x|y | z
56110
7|-NULL- |-7
57111
(5 rows)
58112

59-
QUERY:insert into test values (null, null, null);
60-
WARN:ExecAppend: rejected due to CHECK constrainttest1
61-
QUERY:select currval('seq');
113+
QUERY:INSERT INTO INSERT_TBL VALUES (null, null, null);
114+
WARN:ExecAppend: rejected due to CHECK constraintinsert_con
115+
QUERY:SELECT currval('insert_seq');
62116
currval
63117
-------
64118
8
65119
(1 row)
66120

67-
QUERY: drop table test;
68-
QUERY: drop sequence seq;
69-
QUERY: create sequence seq start 4;
70-
QUERY: create table dummy (xd int, yd text, zd int);
71-
QUERY: create table test (x int default nextval ( 'seq') ,
72-
y text default '-NULL-', z int default -1 * currval('seq') )
73-
constraint test1 check (x > 3 and y <> 'check failed' and x < 7 ), check
74-
x + z = 0;
75-
QUERY: select nextval('seq');
76-
NOTICE:seq.nextval: sequence was re-created
121+
QUERY: DELETE FROM INSERT_TBL;
122+
QUERY: DROP SEQUENCE INSERT_SEQ;
123+
QUERY: CREATE SEQUENCE INSERT_SEQ START 4;
124+
QUERY: CREATE TABLE TEMP (xd INT, yd TEXT, zd INT);
125+
QUERY: SELECT nextval('insert_seq');
126+
NOTICE:insert_seq.nextval: sequence was re-created
77127

78128
nextval
79129
-------
80130
4
81131
(1 row)
82132

83-
QUERY:insert into dummy values (null, null, null);
84-
QUERY:insert into dummy values (5, '!check failed', null);
85-
QUERY:insert into dummy values (null, 'try again', null);
86-
QUERY:insert into test select *from dummy;
87-
QUERY:select *from test;
133+
QUERY:INSERT INTO TEMP VALUES (null, null, null);
134+
QUERY:INSERT INTO TEMP VALUES (5, '!check failed', null);
135+
QUERY:INSERT INTO TEMP VALUES (null, 'try again', null);
136+
QUERY:INSERT INTO INSERT_TBL SELECT *FROM TEMP;
137+
QUERY:SELECT *FROM INSERT_TBL;
88138
x|y | z
89139
-+-------------+--
90140
5|-NULL- |-5
91141
5|!check failed|-5
92142
6|try again |-6
93143
(3 rows)
94144

95-
QUERY: insert into test select * from dummy where yd = 'try again';
96-
WARN:ExecAppend: rejected due to CHECK constraint test1
97-
QUERY: update test set x = null where x = 6;
145+
QUERY: INSERT INTO INSERT_TBL SELECT * FROM TEMP WHERE yd = 'try again';
146+
QUERY: SELECT * FROM INSERT_TBL;
147+
x|y | z
148+
-+-------------+--
149+
5|-NULL- |-5
150+
5|!check failed|-5
151+
6|try again |-6
152+
7|try again |-7
153+
(4 rows)
154+
155+
QUERY: DROP TABLE TEMP;
156+
QUERY: UPDATE INSERT_TBL SET x = NULL WHERE x = 6;
98157
WARN:ExecReplace: rejected due to CHECK constraint $2
99-
QUERY:select currval('seq');
158+
QUERY:SELECT currval('insert_seq');
100159
currval
101160
-------
102161
8
103162
(1 row)
104163

105-
QUERY: drop table test;
106-
QUERY: drop sequence seq;
107-
QUERY: create sequence seq start 4;
108-
QUERY: create table test (x int default nextval ( 'seq') ,
109-
y text default '-NULL-', z int default -1 * currval('seq') )
110-
constraint test1 check (x > 3 and y <> 'check failed' and x < 7 ), check
111-
x + z = 0;
112-
QUERY: copy test from '_OBJWD_/data/constro.data';
113-
NOTICE:seq.nextval: sequence was re-created
114-
QUERY: select * from test;
164+
QUERY: SELECT * FROM INSERT_TBL;
165+
x|y | z
166+
-+-------------+--
167+
5|-NULL- |-5
168+
5|!check failed|-5
169+
6|try again |-6
170+
7|try again |-7
171+
(4 rows)
172+
173+
QUERY: UPDATE INSERT_TBL SET x = 6 WHERE x = 6;
174+
QUERY: SELECT * FROM INSERT_TBL;
175+
x|y | z
176+
-+-------------+--
177+
5|-NULL- |-5
178+
5|!check failed|-5
179+
7|try again |-7
180+
6|try again |-6
181+
(4 rows)
182+
183+
QUERY: UPDATE INSERT_TBL SET x = -z, z = -x;
184+
QUERY: SELECT * FROM INSERT_TBL;
185+
x|y | z
186+
-+-------------+--
187+
5|-NULL- |-5
188+
5|!check failed|-5
189+
7|try again |-7
190+
6|try again |-6
191+
(4 rows)
192+
193+
QUERY: CREATE SEQUENCE COPY_SEQ START 4;
194+
QUERY: CREATE TABLE COPY_TBL (x INT DEFAULT nextval('copy_seq'),
195+
y TEXT DEFAULT '-NULL-', z INT DEFAULT -1 * currval('copy_seq') )
196+
CONSTRAINT COPY_CON CHECK (x > 3 AND y <> 'check failed' AND x < 7 ),
197+
CHECK x + z = 0;
198+
QUERY: COPY COPY_TBL FROM '_OBJWD_/data/constro.data';
199+
QUERY: SELECT * FROM COPY_TBL;
115200
x|y | z
116201
-+------+--
117202
4|-NULL-|-4
118203
5|-NULL-|-5
119204
6|-NULL-|-6
120205
(3 rows)
121206

122-
QUERY:copy test from '_OBJWD_/data/constrf.data';
123-
WARN:CopyFrom: rejected due to CHECK constrainttest1
124-
QUERY:select *from test;
207+
QUERY:COPY COPY_TBL FROM '_OBJWD_/data/constrf.data';
208+
WARN:CopyFrom: rejected due to CHECK constraintcopy_con
209+
QUERY:SELECT *FROM COPY_TBL;
125210
x|y | z
126211
-+------+--
127212
4|-NULL-|-4
128213
5|-NULL-|-5
129214
6|-NULL-|-6
130215
(3 rows)
131216

132-
QUERY: select nextval('seq') - 1 as currval;
217+
QUERY: select nextval('copy_seq') - 1 as currval;
133218
currval
134219
-------
135220
7
136221
(1 row)
137222

138-
QUERY: drop sequence seq;
139-
QUERY: drop table test;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp