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

Commite4b27f2

Browse files
author
Thomas G. Lockhart
committed
Make tests match with modified error messages.
1 parentaeecb4e commite4b27f2

File tree

3 files changed

+13
-51
lines changed

3 files changed

+13
-51
lines changed

‎src/test/regress/expected/errors.out

Lines changed: 0 additions & 28 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,6 @@ QUERY: select 1
22
select
33
select * from nonesuch;
44
WARN:parser: parse error at or near "select"
5-
65
QUERY: select nonesuch from pg_database;
76
WARN:attribute "nonesuch" not found
87
QUERY: select * from pg_database where nonesuch = pg_database.datname;
@@ -11,22 +10,18 @@ QUERY: select * from pg_database where pg_database.datname = nonesuch;
1110
WARN:attribute "nonesuch" not found
1211
QUERY: select distinct on foobar from pg_database;
1312
WARN:parser: parse error at or near "from"
14-
1513
QUERY: select distinct on foobar * from pg_database;
1614
WARN:The field specified in the UNIQUE ON clause is not in the targetlist
1715
QUERY: delete from;
1816
WARN:parser: parse error at or near ";"
19-
2017
QUERY: delete from nonesuch;
2118
WARN:nonesuch: Table does not exist.
2219
QUERY: drop table;
2320
WARN:parser: parse error at or near ";"
24-
2521
QUERY: drop table nonesuch;
2622
WARN:Relation nonesuch Does Not Exist!
2723
QUERY: alter table rename;
2824
WARN:parser: parse error at or near "rename"
29-
3025
QUERY: alter table nonesuch rename to newnonesuch;
3126
WARN:renamerel: relation "nonesuch" does not exist
3227
QUERY: alter table nonesuch rename to stud_emp;
@@ -85,62 +80,46 @@ QUERY: create aggregate newcnt1 (sfunc2 = int4inc,
8580
WARN:AggregateCreate: transition function 2 MUST have an initial value
8681
QUERY: drop index;
8782
WARN:parser: parse error at or near ";"
88-
8983
QUERY: drop index 314159;
9084
WARN:parser: parse error at or near "314159"
91-
9285
QUERY: drop index nonesuch;
9386
WARN:index "nonesuch" nonexistent
9487
QUERY: drop aggregate;
9588
WARN:parser: parse error at or near ";"
96-
9789
QUERY: drop aggregate 314159;
9890
WARN:parser: parse error at or near "314159"
99-
10091
QUERY: drop aggregate nonesuch;
10192
WARN:parser: parse error at or near ";"
102-
10393
QUERY: drop aggregate newcnt1;
10494
WARN:parser: parse error at or near ";"
105-
10695
QUERY: drop aggregate newcnt nonesuch;
10796
WARN:RemoveAggregate: type 'nonesuch' does not exist
10897
QUERY: drop aggregate newcnt float4;
10998
WARN:RemoveAggregate: aggregate 'newcnt' for 'float4' does not exist
11099
QUERY: drop function ();
111100
WARN:parser: parse error at or near "("
112-
113101
QUERY: drop function 314159();
114102
WARN:parser: parse error at or near "314159"
115-
116103
QUERY: drop function nonesuch();
117104
WARN:RemoveFunction: function nonesuch() does not exist
118105
QUERY: drop type;
119106
WARN:parser: parse error at or near ";"
120-
121107
QUERY: drop type 314159;
122108
WARN:parser: parse error at or near "314159"
123-
124109
QUERY: drop type nonesuch;
125110
WARN:RemoveType: type 'nonesuch' does not exist
126111
QUERY: drop operator;
127112
WARN:parser: parse error at or near ";"
128-
129113
QUERY: drop operator equals;
130114
WARN:parser: parse error at or near "equals"
131-
132115
QUERY: drop operator ===;
133116
WARN:parser: parse error at or near ";"
134-
135117
QUERY: drop operator int4, int4;
136118
WARN:parser: parse error at or near "int4"
137-
138119
QUERY: drop operator (int4, int4);
139120
WARN:parser: parse error at or near "("
140-
141121
QUERY: drop operator === ();
142122
WARN:parser: parse error at or near ")"
143-
144123
QUERY: drop operator === (int4);
145124
WARN:parser: argument type missing (use NONE for unary operators)
146125
QUERY: drop operator === (int4, int4);
@@ -149,28 +128,21 @@ QUERY: drop operator = (nonesuch);
149128
WARN:parser: argument type missing (use NONE for unary operators)
150129
QUERY: drop operator = ( , int4);
151130
WARN:parser: parse error at or near ","
152-
153131
QUERY: drop operator = (nonesuch, int4);
154132
WARN:RemoveOperator: type 'nonesuch' does not exist
155133
QUERY: drop operator = (int4, nonesuch);
156134
WARN:RemoveOperator: type 'nonesuch' does not exist
157135
QUERY: drop operator = (int4, );
158136
WARN:parser: parse error at or near ")"
159-
160137
QUERY: drop rule;
161138
WARN:parser: parse error at or near ";"
162-
163139
QUERY: drop rule 314159;
164140
WARN:parser: parse error at or near "314159"
165-
166141
QUERY: drop rule nonesuch;
167142
WARN:RewriteGetRuleEventRel: rule "nonesuch" not found
168143
QUERY: drop tuple rule nonesuch;
169144
WARN:parser: parse error at or near "tuple"
170-
171145
QUERY: drop instance rule nonesuch;
172146
WARN:parser: parse error at or near "instance"
173-
174147
QUERY: drop rewrite rule nonesuch;
175148
WARN:parser: parse error at or near "rewrite"
176-

‎src/test/regress/expected/float4.out

Lines changed: 5 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -5,17 +5,13 @@ QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-34.84');
55
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e+20');
66
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e-20');
77
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e40');
8-
WARN:Bad float4 input format -- overflow
9-
8+
WARN:Bad float4 input format -- overflow
109
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e40');
11-
WARN:Bad float4 input format -- overflow
12-
10+
WARN:Bad float4 input format -- overflow
1311
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-40');
14-
WARN:Bad float4 input format -- underflow
15-
12+
WARN:Bad float4 input format -- underflow
1613
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-40');
17-
WARN:Bad float4 input format -- underflow
18-
14+
WARN:Bad float4 input format -- underflow
1915
QUERY: SELECT '' AS five, FLOAT4_TBL.*;
2016
five|f1
2117
----+-----------
@@ -112,7 +108,7 @@ three|f1 |x
112108
(3 rows)
113109

114110
QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT4_TBL f;
115-
WARN:float4div:divide by0.0 error
111+
WARN:float4div: divide byzero error
116112
QUERY: SELECT '' AS five, FLOAT4_TBL.*;
117113
five|f1
118114
----+-----------

‎src/test/regress/expected/float8.out

Lines changed: 8 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -5,17 +5,13 @@ QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84');
55
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200');
66
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200');
77
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
8-
WARN:Bad float8 input format
9-
8+
WARN:Bad float8 input format '10e400'
109
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
11-
WARN:Bad float8 input format
12-
10+
WARN:Bad float8 input format '-10e400'
1311
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
14-
WARN:Bad float8 input format
15-
12+
WARN:Bad float8 input format '10e-400'
1613
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
17-
WARN:Bad float8 input format
18-
14+
WARN:Bad float8 input format '-10e-400'
1915
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
2016
five|f1
2117
----+--------------------
@@ -199,13 +195,11 @@ QUERY: UPDATE FLOAT8_TBL
199195
SET f1 = FLOAT8_TBL.f1 * '-1'
200196
WHERE FLOAT8_TBL.f1 > '0.0';
201197
QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
202-
WARN:Bad float8 input format -- overflow
203-
198+
WARN:Bad float8 input format -- overflow
204199
QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
205-
WARN:pow() returned a floating point out of the range
206-
200+
WARN:pow() result is out of range
207201
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
208-
WARN:can't take log of0!
202+
WARN:can't take log ofzero
209203
QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
210204
WARN:can't take log of a negative number
211205
QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
@@ -219,7 +213,7 @@ bad| ?column?
219213
(5 rows)
220214

221215
QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
222-
WARN:float8div:divide by0.0 error
216+
WARN:float8div: divide byzero error
223217
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
224218
five|f1
225219
----+---------------------

0 commit comments

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