8000 Tweak "line" test to avoid platform-specific floating-point output · postgrespro/postgres_cluster@a53dee4 · GitHub
[go: up one dir, main page]
Skip to content

Commit a53dee4

Browse files
peterepetere
committed
Tweak "line" test to avoid platform-specific floating-point output
1 parent 4cbb646 commit a53dee4

File tree

2 files changed

+4
-4
lines changed

2 files changed

+4
-4
lines changed

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

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@
66
CREATE TABLE LINE_TBL (s line);
77
INSERT INTO LINE_TBL VALUES ('{1,-1,1}');
88
INSERT INTO LINE_TBL VALUES ('(0,0),(6,6)');
9-
INSERT INTO LINE_TBL VALUES ('10,-10 ,-3,-4');
9+
INSERT INTO LINE_TBL VALUES ('10,-10 ,-5,-4');
1010
INSERT INTO LINE_TBL VALUES ('[-1e6,2e2,3e5, -4e1]');
1111
INSERT INTO LINE_TBL VALUES ('(11,22,33,44)');
1212
INSERT INTO LINE_TBL VALUES ('[(1,0),(1,0)]');
@@ -43,7 +43,7 @@ select * from LINE_TBL;
4343
---------------------------------------------
4444
{1,-1,1}
4545
{1,-1,0}
46-
{-0.461538461538462,-1,-5.38461538461538}
46+
{-0.4,-1,-6}
4747
{-0.000184615384615385,-1,15.3846153846154}
4848
{1,-1,11}
4949
{0,-1,3}
@@ -56,7 +56,7 @@ SELECT * FROM LINE_TBL WHERE (s <-> line '[(1,2),(3,4)]') < 10;
5656
---------------------------------------------
5757
{1,-1,1}
5858
{1,-1,0}
59-
{-0.461538461538462,-1,-5.38461538461538}
59+
{-0.4,-1,-6}
6060
{-0.000184615384615385,-1,15.3846153846154}
6161
{1,-1,11}
6262
{0,-1,3}

‎src/test/regress/sql/line.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@ CREATE TABLE LINE_TBL (s line);
88

99
INSERT INTO LINE_TBL VALUES ('{1,-1,1}');
1010
INSERT INTO LINE_TBL VALUES ('(0,0),(6,6)');
11-
INSERT INTO LINE_TBL VALUES ('10,-10 ,-3,-4');
11+
INSERT INTO LINE_TBL VALUES ('10,-10 ,-5,-4');
1212
INSERT INTO LINE_TBL VALUES ('[-1e6,2e2,3e5, -4e1]');
1313
INSERT INTO LINE_TBL VALUES ('(11,22,33,44)');
1414

0 commit comments

Comments
 (0)
0