Changeset: 98e47f8d1a39 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=98e47f8d1a39
Modified Files:
sql/test/pg_regress/Tests/float4.sql
sql/test/pg_regress/Tests/float4.stable.err
sql/test/pg_regress/Tests/float4.stable.out
Branch: default
Log Message:
Updated float4.stable.*
diffs (192 lines):
diff --git a/sql/test/pg_regress/Tests/float4.sql
b/sql/test/pg_regress/Tests/float4.sql
--- a/sql/test/pg_regress/Tests/float4.sql
+++ b/sql/test/pg_regress/Tests/float4.sql
@@ -41,8 +41,7 @@ SELECT cast('Infinity' as real) / cast('
SELECT cast('nan' as real) / cast('nan' as real);
-SELECT '' AS five, FLOAT4_TBL.*;
-SELECT '' AS five, * FROM FLOAT4_TBL;
+SELECT '' AS five, FLOAT4_TBL.* FROM FLOAT4_TBL;
SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE f.f1 <> '1004.3';
diff --git a/sql/test/pg_regress/Tests/float4.stable.err
b/sql/test/pg_regress/Tests/float4.stable.err
--- a/sql/test/pg_regress/Tests/float4.stable.err
+++ b/sql/test/pg_regress/Tests/float4.stable.err
@@ -29,64 +29,52 @@ stderr of test 'float4` in directory 'sq
# 17:11:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1142" "--port=38959"
# 17:11:19 >
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES ('10e40');
ERROR = !conversion of string '10e40' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e40');
ERROR = !conversion of string '-10e40' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
-QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES (' ');
-ERROR = !conversion of string ' ' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES ('xyz');
ERROR = !conversion of string 'xyz' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES ('5.0.0');
ERROR = !conversion of string '5.0.0' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES ('5 . 0');
ERROR = !conversion of string '5 . 0' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES ('5. 0');
ERROR = !conversion of string '5. 0' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES (' - 3.0');
ERROR = !conversion of string ' - 3.0' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = INSERT INTO FLOAT4_TBL(f1) VALUES ('123 5');
ERROR = !conversion of string '123 5' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
-QUERY = SELECT cast(' NAN ' as real);
-ERROR = !conversion of string ' NAN ' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = SELECT cast('infinity' as real);
ERROR = !conversion of string 'infinity' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
-QUERY = SELECT cast(' -INFINiTY ' as real);
-ERROR = !conversion of string ' -INFINiTY ' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = SELECT cast('N A N' as real);
ERROR = !conversion of string 'N A N' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = SELECT cast('NaN x' as real);
ERROR = !conversion of string 'NaN x' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = SELECT cast(' INFINITY x' as real);
ERROR = !conversion of string ' INFINITY x' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = SELECT cast('Infinity' as real) + 100.0;
ERROR = !conversion of string 'Infinity' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = SELECT cast('Infinity' as real) / cast('Infinity' as real);
ERROR = !conversion of string 'Infinity' to type flt failed.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
-QUERY = SELECT '' AS five, FLOAT4_TBL.*;
-ERROR = !Column expression Table 'float4_tbl' unknown
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = SELECT '' AS bad, f.f1 / '0.0' from FLOAT4_TBL f;
ERROR = !division by zero.
-MAPI = (monetdb) /var/tmp/mtest-25217/.s.monetdb.33492
+MAPI = (monetdb) /var/tmp/mtest-25735/.s.monetdb.30933
QUERY = SELECT '' AS five, f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f;
ERROR = !syntax error, unexpected '.', expecting SCOLON in: "select '' as
five, f.f1, @f."
diff --git a/sql/test/pg_regress/Tests/float4.stable.out
b/sql/test/pg_regress/Tests/float4.stable.out
--- a/sql/test/pg_regress/Tests/float4.stable.out
+++ b/sql/test/pg_regress/Tests/float4.stable.out
@@ -44,6 +44,8 @@ Ready.
[ 1 ]
#INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-40');
[ 1 ]
+#INSERT INTO FLOAT4_TBL(f1) VALUES (' ');
+[ 1 ]
#SELECT cast('NaN' as real);
% .L # table_name
% single_value # name
@@ -56,6 +58,18 @@ Ready.
% real # type
% 15 # length
[ NULL ]
+#SELECT cast(' NAN ' as real);
+% .L # table_name
+% single_value # name
+% real # type
+% 15 # length
+[ NULL ]
+#SELECT cast(' -INFINiTY ' as real);
+% .L # table_name
+% single_value # name
+% real # type
+% 15 # length
+[ -inf ]
#SELECT cast('nan' as real) / cast('nan' as real);
% .L # table_name
% sql_div_single_value # name
@@ -74,6 +88,7 @@ Ready.
[ "", 1 ]
[ "", 1 ]
[ "", -1 ]
+[ "", 0 ]
#SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE f.f1 <> '1004.3';
% .L, sys.f # table_name
% four, f1 # name
@@ -85,6 +100,7 @@ Ready.
[ "", 1 ]
[ "", 1 ]
[ "", -1 ]
+[ "", 0 ]
#SELECT '' AS one, f.* FROM FLOAT4_TBL f WHERE f.f1 = '1004.3';
% .L, sys.f # table_name
% one, f1 # name
@@ -101,6 +117,7 @@ Ready.
[ "", 1 ]
[ "", 1 ]
[ "", -1 ]
+[ "", 0 ]
#SELECT '' AS three, f.* FROM FLOAT4_TBL f WHERE f.f1 < '1004.3';
% .L, sys.f # table_name
% three, f1 # name
@@ -111,6 +128,7 @@ Ready.
[ "", 1 ]
[ "", 1 ]
[ "", -1 ]
+[ "", 0 ]
#SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE '1004.3' >= f.f1;
% .L, sys.f # table_name
% four, f1 # name
@@ -122,6 +140,7 @@ Ready.
[ "", 1 ]
[ "", 1 ]
[ "", -1 ]
+[ "", 0 ]
#SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE f.f1 <= '1004.3';
% .L, sys.f # table_name
% four, f1 # name
@@ -133,6 +152,7 @@ Ready.
[ "", 1 ]
[ "", 1 ]
[ "", -1 ]
+[ "", 0 ]
#SELECT '' AS three, f.f1, f.f1 * '-10' AS x FROM FLOAT4_TBL f
# WHERE f.f1 > '0.0';
% .L, sys.f, sys.L # table_name
@@ -185,6 +205,7 @@ Ready.
[ "", 1 ]
[ "", 1 ]
[ "", -1 ]
+[ "", 0 ]
#UPDATE FLOAT4_TBL
# SET f1 = FLOAT4_TBL.f1 * '-1'
# WHERE FLOAT4_TBL.f1 > '0.0';
@@ -201,6 +222,7 @@ Ready.
[ "", -1 ]
[ "", -1 ]
[ "", -1 ]
+[ "", 0 ]
#DROP TABLE FLOAT4_TBL;
# 18:17:19 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
