Changeset: 7e847058f643 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7e847058f643
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
sql/test/pg_regress/Tests/float8.sql
sql/test/pg_regress/Tests/float8.stable.out
sql/test/pg_regress/Tests/float8.stable.out.Windows
Branch: Apr2019
Log Message:
Update pg_regress test for now supported ln() scalar function.
Also added scalar function tests to float4.sql, copied from float8.sql.
diffs (218 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
@@ -70,6 +70,43 @@ SELECT '' AS three, f.f1, f.f1 - '-10' A
-- test divide by zero
SELECT '' AS bad, f.f1 / '0.0' from FLOAT4_TBL f;
+-- absolute value
+SELECT '' AS five, f.f1, abs(f1) AS abs_f1
+ FROM FLOAT4_TBL f;
+
+-- truncate
+SELECT '' AS five, f.f1, truncate(f1) AS trunc_f1
+ FROM FLOAT4_TBL f;
+
+-- round
+SELECT '' AS five, f.f1, round(f.f1, 0) AS round_f1
+ FROM FLOAT4_TBL f;
+
+-- ceil / ceiling
+select ceil(f1) as ceil_f1 from float4_tbl f;
+select ceiling(f1) as ceiling_f1 from float4_tbl f;
+
+-- floor
+select floor(f1) as floor_f1 from float4_tbl f;
+
+-- sign
+select sign(f1) as sign_f1 from float4_tbl f;
+
+-- square root
+SELECT sqrt(cast('64' as double)) AS eight;
+
+SELECT '' AS three, f.f1, sqrt(f.f1) AS sqrt_f1
+ FROM FLOAT4_TBL f
+ WHERE f.f1 > '0.0';
+
+-- power
+SELECT power(cast('144' as double), cast('0.5' as double));
+
+-- take exp of ln(f.f1)
+SELECT '' AS three, f.f1, exp(ln(f.f1)) AS exp_ln_f1
+ FROM FLOAT4_TBL f
+ WHERE f.f1 > '0.0';
+
SELECT '' AS five, * FROM FLOAT4_TBL;
-- test the unary float4abs operator
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
@@ -114,6 +114,11 @@ QUERY = SELECT '' AS bad, f.f1 / '0.0' f
ERROR = !division by zero.
CODE = 22012
MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
+QUERY = SELECT '' AS five, f.f1, truncate(f1) AS trunc_f1
+ FROM FLOAT4_TBL f;
+ERROR = !syntax/parse error,
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-28861/.s.monetdb.34845
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."
CODE = 42000
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
@@ -153,6 +153,114 @@ Ready.
[ "", 1.2346e+20, 1.2346e+20 ]
[ "", 1.2346e-20, 10 ]
[ "", 1e-39, 10 ]
+#SELECT '' AS five, f.f1, abs(f1) AS abs_f1
+# FROM FLOAT4_TBL f;
+% .L2, sys.f, sys.L5 # table_name
+% five, f1, abs_f1 # name
+% char, real, real # type
+% 0, 15, 15 # length
+[ "", 0, 0 ]
+[ "", 1004.3, 1004.3 ]
+[ "", -34.84, 34.84 ]
+[ "", 1.2346e+20, 1.2346e+20 ]
+[ "", 1.2346e-20, 1.2346e-20 ]
+[ "", 1e-39, 1e-39 ]
+[ "", -1e-39, 1e-39 ]
+#SELECT '' AS five, f.f1, round(f.f1, 0) AS round_f1
+# FROM FLOAT4_TBL f;
+% .L2, sys.f, sys.L5 # table_name
+% five, f1, round_f1 # name
+% char, real, real # type
+% 0, 15, 15 # length
+[ "", 0, 0 ]
+[ "", 1004.3, 1004 ]
+[ "", -34.84, -35 ]
+[ "", 1.2346e+20, 1.2346e+20 ]
+[ "", 1.2346e-20, 0 ]
+[ "", 1e-39, 0 ]
+[ "", -1e-39, 0 ]
+#select ceil(f1) as ceil_f1 from float4_tbl f;
+% sys.L2 # table_name
+% ceil_f1 # name
+% real # type
+% 15 # length
+[ 0 ]
+[ 1005 ]
+[ -34 ]
+[ 1.2346e+20 ]
+[ 1 ]
+[ 1 ]
+[ 0 ]
+#select ceiling(f1) as ceiling_f1 from float4_tbl f;
+% sys.L2 # table_name
+% ceiling_f1 # name
+% real # type
+% 15 # length
+[ 0 ]
+[ 1005 ]
+[ -34 ]
+[ 1.2346e+20 ]
+[ 1 ]
+[ 1 ]
+[ 0 ]
+#select floor(f1) as floor_f1 from float4_tbl f;
+% sys.L2 # table_name
+% floor_f1 # name
+% real # type
+% 15 # length
+[ 0 ]
+[ 1004 ]
+[ -35 ]
+[ 1.2346e+20 ]
+[ 0 ]
+[ 0 ]
+[ -1 ]
+#select sign(f1) as sign_f1 from float4_tbl f;
+% sys.L2 # table_name
+% sign_f1 # name
+% tinyint # type
+% 2 # length
+[ 0 ]
+[ 1 ]
+[ -1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ -1 ]
+#SELECT sqrt(cast('64' as double)) AS eight;
+% .L3 # table_name
+% eight # name
+% double # type
+% 24 # length
+[ 8 ]
+#SELECT '' AS three, f.f1, sqrt(f.f1) AS sqrt_f1
+# FROM FLOAT4_TBL f
+# WHERE f.f1 > '0.0';
+% .L2, sys.f, sys.L5 # table_name
+% three, f1, sqrt_f1 # name
+% char, real, real # type
+% 0, 15, 15 # length
+[ "", 1004.3, 31.691 ]
+[ "", 1.2346e+20, 1.1111e+10 ]
+[ "", 1.2346e-20, 1.1111e-10 ]
+[ "", 1e-39, 3.1623e-20 ]
+#SELECT power(cast('144' as double), cast('0.5' as double));
+% .L4 # table_name
+% L4 # name
+% double # type
+% 24 # length
+[ 12 ]
+#SELECT '' AS three, f.f1, exp(ln(f.f1)) AS exp_ln_f1
+# FROM FLOAT4_TBL f
+# WHERE f.f1 > '0.0';
+% .L2, sys.f, sys.L5 # table_name
+% three, f1, exp_ln_f1 # name
+% char, real, real # type
+% 0, 15, 15 # length
+[ "", 1004.3, 1004.3 ]
+[ "", 1.2346e+20, 1.2346e+20 ]
+[ "", 1.2346e-20, 1.2346e-20 ]
+[ "", 1e-39, 1e-39 ]
#SELECT '' AS five, * FROM FLOAT4_TBL;
% .L2, sys.float4_tbl # table_name
% five, f1 # name
diff --git a/sql/test/pg_regress/Tests/float8.sql
b/sql/test/pg_regress/Tests/float8.sql
--- a/sql/test/pg_regress/Tests/float8.sql
+++ b/sql/test/pg_regress/Tests/float8.sql
@@ -110,8 +110,8 @@ SELECT '' AS three, f.f1, sqrt(f.f1) AS
-- power
SELECT power(cast('144' as double), cast('0.5' as double));
--- take exp of ln(f.f1) (in MonetDB ln() is implemented as log())
-SELECT '' AS three, f.f1, exp(log(f.f1)) AS exp_ln_f1
+-- take exp of ln(f.f1)
+SELECT '' AS three, f.f1, exp(ln(f.f1)) AS exp_ln_f1
FROM FLOAT8_TBL f
WHERE f.f1 > '0.0';
diff --git a/sql/test/pg_regress/Tests/float8.stable.out
b/sql/test/pg_regress/Tests/float8.stable.out
--- a/sql/test/pg_regress/Tests/float8.stable.out
+++ b/sql/test/pg_regress/Tests/float8.stable.out
@@ -233,7 +233,7 @@ Ready.
% double # type
% 24 # length
[ 12 ]
-#SELECT '' AS three, f.f1, exp(log(f.f1)) AS exp_ln_f1
+#SELECT '' AS three, f.f1, exp(ln(f.f1)) AS exp_ln_f1
# FROM FLOAT8_TBL f
# WHERE f.f1 > '0.0';
% .L2, sys.f, sys.L5 # table_name
diff --git a/sql/test/pg_regress/Tests/float8.stable.out.Windows
b/sql/test/pg_regress/Tests/float8.stable.out.Windows
--- a/sql/test/pg_regress/Tests/float8.stable.out.Windows
+++ b/sql/test/pg_regress/Tests/float8.stable.out.Windows
@@ -233,7 +233,7 @@ Ready.
% double # type
% 24 # length
[ 12 ]
-#SELECT '' AS three, f.f1, exp(log(f.f1)) AS exp_ln_f1
+#SELECT '' AS three, f.f1, exp(ln(f.f1)) AS exp_ln_f1
# FROM FLOAT8_TBL f
# WHERE f.f1 > '0.0';
% .L2, sys.f, sys.L5 # table_name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
