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

Commitf901971

Browse files
author
Thomas G. Lockhart
committed
Adjust output to reflect changes in tests.
1 parent07c1837 commitf901971

File tree

8 files changed

+834
-777
lines changed

8 files changed

+834
-777
lines changed

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

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -42,7 +42,7 @@ initial|a|b|c|d|e|f|g|h|i|j|l|m|n|p|q|r|s|t|u|v|w|x|y|z
4242
QUERY: DROP TABLE temp;
4343
QUERY: CREATE TABLE temp (
4444
initial int4
45-
) ARCHIVE = light;
45+
);
4646
QUERY: ALTER TABLE temp ADD COLUMN a int4;
4747
QUERY: ALTER TABLE temp ADD COLUMN b char16;
4848
QUERY: ALTER TABLE temp ADD COLUMN c text;
@@ -78,7 +78,7 @@ QUERY: INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t
7878
'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
7979
'1/3', '1,char16', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
8080
WARN:Relation temp does not have attribute k
81-
QUERY: SELECT * FROM temp[,];
81+
QUERY: SELECT * FROM temp;
8282
initial|a|b|c|d|e|f|g|h|i|j|l|m|n|p|q|r|s|t|u|v|w|x|y|z
8383
-------+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
8484
(0 rows)

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

Lines changed: 36 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -180,5 +180,41 @@ tf_12_ff_4|f1|f1
180180
|t |f
181181
(16 rows)
182182

183+
QUERY: SELECT '' AS "True", BOOLTBL1.*
184+
FROM BOOLTBL1
185+
WHERE f1 IS TRUE;
186+
True|f1
187+
----+--
188+
|t
189+
|t
190+
|t
191+
(3 rows)
192+
193+
QUERY: SELECT '' AS "Not False", BOOLTBL1.*
194+
FROM BOOLTBL1
195+
WHERE f1 IS NOT FALSE;
196+
Not False|f1
197+
---------+--
198+
|t
199+
|t
200+
|t
201+
(3 rows)
202+
203+
QUERY: SELECT '' AS "False", BOOLTBL1.*
204+
FROM BOOLTBL1
205+
WHERE f1 IS FALSE;
206+
False|f1
207+
-----+--
208+
|f
209+
(1 row)
210+
211+
QUERY: SELECT '' AS "Not True", BOOLTBL1.*
212+
FROM BOOLTBL1
213+
WHERE f1 IS NOT TRUE;
214+
Not True|f1
215+
--------+--
216+
|f
217+
(1 row)
218+
183219
QUERY: DROP TABLE BOOLTBL1;
184220
QUERY: DROP TABLE BOOLTBL2;

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

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,9 @@
1+
QUERY: SELECT 'c'::char = 'c'::char AS true;
2+
true
3+
----
4+
t
5+
(1 row)
6+
17
QUERY: CREATE TABLE CHAR_TBL(f1 char);
28
QUERY: INSERT INTO CHAR_TBL (f1) VALUES ('a');
39
QUERY: INSERT INTO CHAR_TBL (f1) VALUES ('A');

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

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,15 @@
1+
QUERY: SELECT 'char 16 string'::char16 = 'char 16 string'::char16 AS "True";
2+
True
3+
----
4+
t
5+
(1 row)
6+
7+
QUERY: SELECT 'char 16 string'::char16 = 'char 16 string '::char16 AS "False";
8+
False
9+
-----
10+
f
11+
(1 row)
12+
113
QUERY: CREATE TABLE CHAR16_TBL(f1 char16);
214
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('ABCDEFGHIJKLMNOP');
315
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('abcdefghijklmnop');

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

Lines changed: 26 additions & 25 deletions
Original file line numberDiff line numberDiff line change
@@ -3,29 +3,30 @@ QUERY: SELECT relname, relhasindex
33
FROM pg_class
44
WHERE relhasindex
55
ORDER BY relname;
6-
relname |relhasindex
7-
-------------+-----------
8-
bt_c16_heap |t
9-
bt_f8_heap |t
10-
bt_i4_heap |t
11-
bt_txt_heap |t
12-
fast_emp4000 |t
13-
hash_c16_heap|t
14-
hash_f8_heap |t
15-
hash_i4_heap |t
16-
hash_txt_heap|t
17-
ihighway |t
18-
onek |t
19-
pg_attrdef |t
20-
pg_attribute |t
21-
pg_class |t
22-
pg_proc |t
23-
pg_relcheck |t
24-
pg_trigger |t
25-
pg_type |t
26-
road |t
27-
shighway |t
28-
tenk1 |t
29-
tenk2 |t
30-
(22 rows)
6+
relname |relhasindex
7+
--------------+-----------
8+
bt_c16_heap |t
9+
bt_f8_heap |t
10+
bt_i4_heap |t
11+
bt_txt_heap |t
12+
fast_emp4000 |t
13+
hash_c16_heap |t
14+
hash_f8_heap |t
15+
hash_i4_heap |t
16+
hash_txt_heap |t
17+
ihighway |t
18+
onek |t
19+
pg_attrdef |t
20+
pg_attribute |t
21+
pg_class |t
22+
pg_description|t
23+
pg_proc |t
24+
pg_relcheck |t
25+
pg_trigger |t
26+
pg_type |t
27+
road |t
28+
shighway |t
29+
tenk1 |t
30+
tenk2 |t
31+
(23 rows)
3132

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

Lines changed: 738 additions & 737 deletions
Large diffs are not rendered by default.

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

Lines changed: 10 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -1,15 +1,3 @@
1-
QUERY: SELECT 'char 16 string'::char16 = 'char 16 string '::char16 AS false;
2-
false
3-
-----
4-
f
5-
(1 row)
6-
7-
QUERY: SELECT 'c'::char = 'c'::char AS true;
8-
true
9-
----
10-
t
11-
(1 row)
12-
131
QUERY: SELECT 'this is a text string'::text = 'this is a text string'::text AS true;
142
true
153
----
@@ -22,3 +10,13 @@ false
2210
f
2311
(1 row)
2412

13+
QUERY: CREATE TABLE TEXT_TBL (f1 text);
14+
QUERY: INSERT INTO TEXT_TBL VALUES ('doh!');
15+
QUERY: INSERT INTO TEXT_TBL VALUES ('hi de ho neighbor');
16+
QUERY: SELECT '' AS two, * FROM TEXT_TBL;
17+
two|f1
18+
---+-----------------
19+
|doh!
20+
|hi de ho neighbor
21+
(2 rows)
22+

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

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -454,6 +454,7 @@ bt_f8_heap
454454
bt_i4_heap
455455
bt_txt_heap
456456
c_star
457+
char_tbl
457458
check2_tbl
458459
check_seq
459460
check_tbl
@@ -503,9 +504,11 @@ stud_emp
503504
student
504505
tenk1
505506
tenk2
507+
text_tbl
506508
timespan_tbl
507509
tinterval_tbl
508510
toyemp
511+
varchar_tbl
509512
xacttest
510-
(65 rows)
513+
(68 rows)
511514

0 commit comments

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