Changeset: 885bc830f410 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=885bc830f410 Modified Files: sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out Branch: default Log Message:
approved output diffs (71 lines): diff --git a/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out b/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out --- a/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out +++ b/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out @@ -32,8 +32,8 @@ stdout of test 'cast-interval.Bug-6793` #INSERT INTO INTERVAL_TBL (f1) VALUES (4.123); [ 1 ] #SELECT f1, cast(f1 as int), cast(f1 as dec(8,3)), cast(f1 as real) FROM INTERVAL_TBL; -% sys.interval_tbl, sys.L1, sys.L2, sys.L3 # table_name -% f1, L1, L2, L3 # name +% sys.interval_tbl, sys.interval_tbl, sys.interval_tbl, sys.interval_tbl # table_name +% f1, f1, f1, f1 # name % sec_interval, int, decimal, real # type % 5, 1, 10, 15 # length [ 1.123, 1, 1.123, 1.123 ] @@ -41,8 +41,8 @@ stdout of test 'cast-interval.Bug-6793` [ 3.123, 3, 3.123, 3.123 ] [ 4.123, 4, 4.123, 4.123 ] #SELECT count(f1), sum(f1), cast(sum(f1) as int), cast(sum(f1) as dec(8,3)), cast(sum(f1) as real) FROM INTERVAL_TBL; -% sys.L2, sys.L3, sys.L5, sys.L7, sys.L11 # table_name -% L2, L3, L5, L7, L11 # name +% sys.%1, sys.%2, sys.%3, sys.%4, sys.%5 # table_name +% %1, %2, %3, %4, %5 # name % bigint, sec_interval, int, decimal, real # type % 1, 6, 2, 10, 15 # length [ 4, 10.492, 10, 10.492, 10.492 ] @@ -57,26 +57,26 @@ stdout of test 'cast-interval.Bug-6793` #INSERT INTO INTERVAL_TBL (f1) VALUES (4); [ 1 ] #SELECT f1, cast(f1 as int) FROM INTERVAL_TBL; -% sys.interval_tbl, sys.L1 # table_name -% f1, L1 # name +% sys.interval_tbl, sys.interval_tbl # table_name +% f1, f1 # name % month_interval, int # type % 1, 1 # length [ 1, 1 ] [ 2, 2 ] [ 3, 3 ] [ 4, 4 ] -#SELECT f1, cast(f1 as dec(3,0)) FROM INTERVAL_TBL; -% sys.interval_tbl, sys.L1 # table_name -% f1, L1 # name +#SELECT f1, cast(f1 as dec(3,0)) FROM INTERVAL_TBL; -- returns error: types month_interval(3,0) and decimal(3,0) are not equal for column 'f1' +% sys.interval_tbl, sys.interval_tbl # table_name +% f1, f1 # name % month_interval, decimal # type % 1, 4 # length [ 1, 1 ] [ 2, 2 ] [ 3, 3 ] [ 4, 4 ] -#SELECT f1, cast(f1 as real) FROM INTERVAL_TBL; -% sys.interval_tbl, sys.L1 # table_name -% f1, L1 # name +#SELECT f1, cast(f1 as real) FROM INTERVAL_TBL; -- returns error: types month_interval(3,0) and real(24,0) are not equal for column 'f1' +% sys.interval_tbl, sys.interval_tbl # table_name +% f1, f1 # name % month_interval, real # type % 1, 15 # length [ 1, 1 ] @@ -84,8 +84,8 @@ stdout of test 'cast-interval.Bug-6793` [ 3, 3 ] [ 4, 4 ] #SELECT count(f1), sum(f1), cast(sum(f1) as int), cast(sum(f1) as dec(8,3)), cast(sum(f1) as real) FROM INTERVAL_TBL; -% sys.L2, sys.L3, sys.L5, sys.L7, sys.L11 # table_name -% L2, L3, L5, L7, L11 # name +% sys.%1, sys.%2, sys.%3, sys.%4, sys.%5 # table_name +% %1, %2, %3, %4, %5 # name % bigint, month_interval, int, decimal, real # type % 1, 2, 2, 10, 15 # length [ 4, 10, 10, 10.000, 10 ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
