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

Commit2d4a05d

Browse files
committed
Update strings test to reflect the fact that casting to char() will
now truncate or pad to the specified length.
1 parent4952836 commit2d4a05d

File tree

2 files changed

+18
-18
lines changed

2 files changed

+18
-18
lines changed

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

Lines changed: 14 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -45,26 +45,26 @@ SELECT CAST(name 'namefield' AS text) AS "text(name)";
4545
namefield
4646
(1 row)
4747

48-
SELECT CAST(f1 AS char) AS "char(text)" FROM TEXT_TBL;
49-
char(text)
50-
-------------------
51-
doh!
52-
hi de honeighbor
48+
SELECT CAST(f1 AS char(10)) AS "char(text)" FROM TEXT_TBL;
49+
char(text)
50+
------------
51+
doh!
52+
hi de hon
5353
(2 rows)
5454

55-
SELECT CAST(f1 AS char) AS "char(varchar)" FROM VARCHAR_TBL;
55+
SELECT CAST(f1 AS char(10)) AS "char(varchar)" FROM VARCHAR_TBL;
5656
char(varchar)
5757
---------------
58-
a
59-
ab
60-
abcd
61-
abcd
58+
a
59+
ab
60+
abcd
61+
abcd
6262
(4 rows)
6363

64-
SELECT CAST(name 'namefield' AS char) AS "char(name)";
64+
SELECT CAST(name 'namefield' AS char(10)) AS "char(name)";
6565
char(name)
6666
------------
67-
namefield
67+
namefield
6868
(1 row)
6969

7070
SELECT CAST(f1 AS varchar) AS "varchar(text)" FROM TEXT_TBL;
@@ -155,10 +155,10 @@ SELECT text 'text' || ' and unknown' AS "Concat text to unknown type";
155155
text and unknown
156156
(1 row)
157157

158-
SELECT text 'text' || char ' andchar' AS "Concat text to char";
158+
SELECT text 'text' || char(10) ' andcharacters' AS "Concat text to char";
159159
Concat text to char
160160
---------------------
161-
text andchar
161+
text andchara
162162
(1 row)
163163

164164
SELECT text 'text' || varchar ' and varchar' AS "Concat text to varchar";

‎src/test/regress/sql/strings.sql

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -25,11 +25,11 @@ SELECT CAST(f1 AS text) AS "text(varchar)" FROM VARCHAR_TBL;
2525

2626
SELECT CAST(name'namefield'AStext)AS"text(name)";
2727

28-
SELECT CAST(f1ASchar)AS"char(text)"FROM TEXT_TBL;
28+
SELECT CAST(f1ASchar(10))AS"char(text)"FROM TEXT_TBL;
2929

30-
SELECT CAST(f1ASchar)AS"char(varchar)"FROM VARCHAR_TBL;
30+
SELECT CAST(f1ASchar(10))AS"char(varchar)"FROM VARCHAR_TBL;
3131

32-
SELECT CAST(name'namefield'ASchar)AS"char(name)";
32+
SELECT CAST(name'namefield'ASchar(10))AS"char(name)";
3333

3434
SELECT CAST(f1ASvarchar)AS"varchar(text)"FROM TEXT_TBL;
3535

@@ -65,7 +65,7 @@ SELECT 'unknown' || ' and unknown' AS "Concat unknown types";
6565

6666
SELECTtext'text'||' and unknown'AS"Concat text to unknown type";
6767

68-
SELECTtext'text'||char' andchar'AS"Concat text to char";
68+
SELECTtext'text'||char(10)' andcharacters'AS"Concat text to char";
6969

7070
SELECTtext'text'||varchar' and varchar'AS"Concat text to varchar";
7171

0 commit comments

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