Tweak "line" test to avoid platform-specific floating-point output

petere · petere · commit a53dee43fe58 · 2013-10-12T21:17:59.000-04:00
diff --git a/src/test/regress/expected/line.out b/src/test/regress/expected/line.out
@@ -6,7 +6,7 @@
 CREATE TABLE LINE_TBL (s line);
 INSERT INTO LINE_TBL VALUES ('{1,-1,1}');
 INSERT INTO LINE_TBL VALUES ('(0,0),(6,6)');
-INSERT INTO LINE_TBL VALUES ('10,-10 ,-3,-4');
+INSERT INTO LINE_TBL VALUES ('10,-10 ,-5,-4');
 INSERT INTO LINE_TBL VALUES ('[-1e6,2e2,3e5, -4e1]');
 INSERT INTO LINE_TBL VALUES ('(11,22,33,44)');
 INSERT INTO LINE_TBL VALUES ('[(1,0),(1,0)]');
@@ -43,7 +43,7 @@ select * from LINE_TBL;
 ---------------------------------------------
  {1,-1,1}
  {1,-1,0}
- {-0.461538461538462,-1,-5.38461538461538}
+ {-0.4,-1,-6}
  {-0.000184615384615385,-1,15.3846153846154}
  {1,-1,11}
  {0,-1,3}
@@ -56,7 +56,7 @@ SELECT * FROM LINE_TBL WHERE (s <-> line '[(1,2),(3,4)]') < 10;
 ---------------------------------------------
  {1,-1,1}
  {1,-1,0}
- {-0.461538461538462,-1,-5.38461538461538}
+ {-0.4,-1,-6}
  {-0.000184615384615385,-1,15.3846153846154}
  {1,-1,11}
  {0,-1,3}
diff --git a/src/test/regress/sql/line.sql b/src/test/regress/sql/line.sql
@@ -8,7 +8,7 @@ CREATE TABLE LINE_TBL (s line);
 
 INSERT INTO LINE_TBL VALUES ('{1,-1,1}');
 INSERT INTO LINE_TBL VALUES ('(0,0),(6,6)');
-INSERT INTO LINE_TBL VALUES ('10,-10 ,-3,-4');
+INSERT INTO LINE_TBL VALUES ('10,-10 ,-5,-4');
 INSERT INTO LINE_TBL VALUES ('[-1e6,2e2,3e5, -4e1]');
 INSERT INTO LINE_TBL VALUES ('(11,22,33,44)');
 
