Changeset: dc19bccafe24 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dc19bccafe24
Modified Files:
sql/test/miscellaneous/Tests/simple_selects.stable.err
sql/test/miscellaneous/Tests/simple_selects.stable.out
Branch: default
Log Message:
Approved output
diffs (137 lines):
diff --git a/sql/test/miscellaneous/Tests/simple_selects.stable.err
b/sql/test/miscellaneous/Tests/simple_selects.stable.err
--- a/sql/test/miscellaneous/Tests/simple_selects.stable.err
+++ b/sql/test/miscellaneous/Tests/simple_selects.stable.err
@@ -69,7 +69,27 @@ MAPI = (monetdb) /var/tmp/mtest-389745/
QUERY = select cast(z as interval month) from x; --error, cannot cast
ERROR = !types timestamp(7,0) and month_interval(3,0) are not equal for column
'z'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-389745/.s.monetdb.32344
+MAPI = (monetdb) /var/tmp/mtest-193867/.s.monetdb.35256
+QUERY = select cast(w as interval second) from x;
+ERROR = !types real(24,0) and sec_interval(13,0) are not equal for column 'w'
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-193867/.s.monetdb.35256
+QUERY = select cast(w as interval month) from x;
+ERROR = !types real(24,0) and month_interval(3,0) are not equal for column 'w'
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-193867/.s.monetdb.35256
+QUERY = select cast(a as interval second) from x;
+ERROR = !types double(53,0) and sec_interval(13,0) are not equal for column 'a'
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-193867/.s.monetdb.35256
+QUERY = select cast(a as interval month) from x;
+ERROR = !types double(53,0) and month_interval(3,0) are not equal for column
'a'
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-193867/.s.monetdb.35256
+QUERY = select cast(b as interval month) from x;
+ERROR = !types decimal(18,3) and month_interval(3,0) are not equal for column
'b'
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-193867/.s.monetdb.35256
QUERY = select "idontexist"."idontexist"(); --error, it doesn't exist
ERROR = !SELECT: no such schema 'idontexist'
CODE = 3F000
diff --git a/sql/test/miscellaneous/Tests/simple_selects.stable.out
b/sql/test/miscellaneous/Tests/simple_selects.stable.out
--- a/sql/test/miscellaneous/Tests/simple_selects.stable.out
+++ b/sql/test/miscellaneous/Tests/simple_selects.stable.out
@@ -158,6 +158,42 @@ stdout of test 'simple_selects` in direc
% time # type
% 8 # length
[ 00:00:01 ]
+#select cast(x as real) from x;
+% sys.x # table_name
+% x # name
+% real # type
+% 15 # length
+[ 1 ]
+#select cast(x as double) from x;
+% sys.x # table_name
+% x # name
+% double # type
+% 24 # length
+[ 1 ]
+#select cast(x as decimal) from x;
+% sys.x # table_name
+% x # name
+% decimal # type
+% 20 # length
+[ 1.000 ]
+#select cast(y as real) from x;
+% sys.x # table_name
+% y # name
+% real # type
+% 15 # length
+[ 1 ]
+#select cast(y as double) from x;
+% sys.x # table_name
+% y # name
+% double # type
+% 24 # length
+[ 1 ]
+#select cast(y as decimal) from x;
+% sys.x # table_name
+% y # name
+% decimal # type
+% 20 # length
+[ 1.000 ]
#insert into x values (null, null);
[ 1 ]
#select cast(x as time) from x;
@@ -167,10 +203,58 @@ stdout of test 'simple_selects` in direc
% 8 # length
[ 00:00:01 ]
[ NULL ]
+#select cast(x as real) from x;
+% sys.x # table_name
+% x # name
+% real # type
+% 15 # length
+[ 1 ]
+[ NULL ]
+#select cast(x as double) from x;
+% sys.x # table_name
+% x # name
+% double # type
+% 24 # length
+[ 1 ]
+[ NULL ]
+#select cast(x as decimal) from x;
+% sys.x # table_name
+% x # name
+% decimal # type
+% 20 # length
+[ 1.000 ]
+[ NULL ]
+#select cast(y as real) from x;
+% sys.x # table_name
+% y # name
+% real # type
+% 15 # length
+[ 1 ]
+[ NULL ]
+#select cast(y as double) from x;
+% sys.x # table_name
+% y # name
+% double # type
+% 24 # length
+[ 1 ]
+[ NULL ]
+#select cast(y as decimal) from x;
+% sys.x # table_name
+% y # name
+% decimal # type
+% 20 # length
+[ 1.000 ]
+[ NULL ]
#drop table x;
#create table x (x time, y date, z timestamp);
#insert into x values (null, null, null);
[ 1 ]
+#select cast(b as interval second) from x;
+% sys.x # table_name
+% b # name
+% sec_interval # type
+% 5 # length
+[ NULL ]
#drop table x;
#select difference('foobar', 'oobar'), difference(NULL, 'oobar'),
difference('foobar', NULL), difference(NULL, NULL),
# editdistance('foobar', 'oobar'), editdistance(NULL, 'oobar'),
editdistance('foobar', NULL), editdistance(NULL, NULL),
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
