Changeset: d06776d724f4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d06776d724f4
Modified Files:
sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.err
sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.sql
sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.stable.out
Branch: Oct2020
Log Message:
We don't support clob 'xx' syntax at the moment, also removed queries with
different outputs on 32-bit platforms
diffs (82 lines):
diff --git a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
--- a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
+++ b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
@@ -36,7 +36,7 @@ select convert('e31960fb-dc8b-452d-ab30-
-- using prefix operators
select x'abcd';
select blob 'abcd';
-select clob 'abcde'; -- this fails on Oct2020
+select clob 'abcde'; -- we dont support this at the moment
select cast('abcde' as clob);
select inet '192.168.1.5/24';
select json '{"a":[1,2,4]}';
diff --git
a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.err
b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.err
--- a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.err
+++ b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.err
@@ -5,6 +5,10 @@ stderr of test 'webExamplesCastFunctions
# 19:23:26 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-10408" "--port=37113"
# 19:23:26 >
+MAPI = (monetdb) /var/tmp/mtest-13273/.s.monetdb.36692
+QUERY = select clob 'abcde'; -- we dont support this at the moment
+ERROR = !syntax error in: "select clob"
+CODE = 42000
# 19:01:20 >
# 19:01:20 > "Done."
diff --git
a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
--- a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
+++ b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
@@ -191,12 +191,6 @@ stdout of test 'webExamplesCastFunctions
% blob # type
% 0 # length
[ ABCD ]
-#select clob 'abcde';
-% .%2 # table_name
-% %2 # name
-% clob # type
-% 5 # length
-[ "abcde" ]
#select cast('abcde' as clob);
% .%2 # table_name
% %2 # name
diff --git
a/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.sql
b/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.sql
--- a/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.sql
+++ b/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.sql
@@ -232,14 +232,3 @@ select next_value_for('sys', 'tst2021032
select get_value_for('sys', 'tst20210325');
-- 2
drop sequence tst20210325;
-
--- rotate_xor_hash(arg_1 bigint, arg_2 int, arg_3 any)
-select rotate_xor_hash(1, 1, '1') ;
--- in Oct2020: Error: TypeException:user.main[7]:'calc.rotate_xor_hash'
undefined in: X_1320374:str := calc.rotate_xor_hash(X_1320368:lng,
X_1320370:int, X_1320372:str);
--- Error: TypeException:user.s2272_0[8]:'calc.rotate_xor_hash' undefined in:
X_9:bte := calc.rotate_xor_hash(X_5:lng, X_7:int, X_8:bte);
--- Error: TypeException:user.s1802_0[8]:'calc.rotate_xor_hash' undefined in:
X_9:str := calc.rotate_xor_hash(X_5:lng, X_7:int, X_8:str);
-select rotate_xor_hash(cast(1 as bigint), cast(1 as int), '1') ;
--- 2154528971 on Oct2020
--- 2154528971 on Jun2020
--- 15039430859
-
diff --git
a/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.stable.out
b/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.stable.out
---
a/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.stable.out
+++
b/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.stable.out
@@ -528,18 +528,6 @@ project (
% 1 # length
[ 2 ]
#drop sequence tst20210325;
-#select rotate_xor_hash(1, 1, '1') ;
-% .%2 # table_name
-% %2 # name
-% bigint # type
-% 11 # length
-[ 15039430859 ]
-#select rotate_xor_hash(cast(1 as bigint), cast(1 as int), '1') ;
-% .%2 # table_name
-% %2 # name
-% bigint # type
-% 11 # length
-[ 15039430859 ]
# 21:22:20 >
# 21:22:20 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
