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

Commit4e5c2a8

Browse files
committed
Update regression expected results for to_char() change.
1 parent5d115bb commit4e5c2a8

File tree

3 files changed

+26
-26
lines changed

3 files changed

+26
-26
lines changed

‎src/test/regress/expected/int8-exp-three-digits.out

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -244,13 +244,13 @@ SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL;
244244
(5 rows)
245245

246246
SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
247-
to_char_14 | to_char
248-
------------+-------------------
249-
| 456
250-
| 4567890123456789
251-
| 123
252-
| 4567890123456789
253-
| -4567890123456789
247+
to_char_14 | to_char
248+
------------+--------------------
249+
| 456.
250+
| 4567890123456789.
251+
| 123.
252+
| 4567890123456789.
253+
| -4567890123456789.
254254
(5 rows)
255255

256256
SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;

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

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -244,13 +244,13 @@ SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL;
244244
(5 rows)
245245

246246
SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
247-
to_char_14 | to_char
248-
------------+-------------------
249-
| 456
250-
| 4567890123456789
251-
| 123
252-
| 4567890123456789
253-
| -4567890123456789
247+
to_char_14 | to_char
248+
------------+--------------------
249+
| 456.
250+
| 4567890123456789.
251+
| 123.
252+
| 4567890123456789.
253+
| -4567890123456789.
254254
(5 rows)
255255

256256
SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;

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

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -785,8 +785,8 @@ SELECT '' AS to_char_6, to_char(val, 'FMS9999999999999999.999999999999999')
785785
| +7799461.4119
786786
| +16397.038491
787787
| +93901.57763026
788-
| -83028485
789-
| +74881
788+
| -83028485.
789+
| +74881.
790790
| -24926804.04504742
791791
(10 rows)
792792

@@ -800,8 +800,8 @@ SELECT '' AS to_char_7, to_char(val, 'FM9999999999999999.999999999999999THPR')
800800
| 7799461.4119
801801
| 16397.038491
802802
| 93901.57763026
803-
| <83028485>
804-
| 74881
803+
| <83028485.>
804+
| 74881.
805805
| <24926804.04504742>
806806
(10 rows)
807807

@@ -860,8 +860,8 @@ SELECT '' AS to_char_11, to_char(val, 'FM0999999999999999.999999999999999')
860860
| 0000000007799461.4119
861861
| 0000000000016397.038491
862862
| 0000000000093901.57763026
863-
| -0000000083028485
864-
| 0000000000074881
863+
| -0000000083028485.
864+
| 0000000000074881.
865865
| -0000000024926804.04504742
866866
(10 rows)
867867

@@ -950,8 +950,8 @@ SELECT '' AS to_char_17, to_char(val, 'FM9999999999999999.99999999999999')FROM
950950
| 7799461.4119
951951
| 16397.038491
952952
| 93901.57763026
953-
| -83028485
954-
| 74881
953+
| -83028485.
954+
| 74881.
955955
| -24926804.04504742
956956
(10 rows)
957957

@@ -980,8 +980,8 @@ SELECT '' AS to_char_19, to_char(val, 'FMS 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9
980980
| + 7 7 9 9 4 6 1 . 4 1 1 9
981981
| + 1 6 3 9 7 . 0 3 8 4 9 1
982982
| + 9 3 9 0 1 . 5 7 7 6 3 0 2 6
983-
| - 8 3 0 2 8 4 8 5
984-
| + 7 4 8 8 1
983+
| - 8 3 0 2 8 4 8 5.
984+
| + 7 4 8 8 1.
985985
| - 2 4 9 2 6 8 0 4 . 0 4 5 0 4 7 4 2
986986
(10 rows)
987987

@@ -1025,8 +1025,8 @@ SELECT '' AS to_char_22, to_char(val, 'FM9999999999999999.999999999999999')FROM
10251025
| 7799461.4119
10261026
| 16397.038491
10271027
| 93901.57763026
1028-
| -83028485
1029-
| 74881
1028+
| -83028485.
1029+
| 74881.
10301030
| -24926804.04504742
10311031
(10 rows)
10321032

0 commit comments

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