Changeset: 66746805f421 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=66746805f421 Added Files: sql/test/remote/Tests/ssbm.stable.out.int128 Modified Files: sql/test/remote/Tests/ssbm.stable.out Branch: default Log Message:
remote/ssbm: approve 64-bit integer output diffs (truncated from 672 to 300 lines): diff --git a/sql/test/remote/Tests/ssbm.stable.out b/sql/test/remote/Tests/ssbm.stable.out --- a/sql/test/remote/Tests/ssbm.stable.out +++ b/sql/test/remote/Tests/ssbm.stable.out @@ -8,28 +8,28 @@ 60175 rows in mergetable # Q1 % .L1 # table_name % revenue # name -% hugeint # type +% bigint # type % 10 # length [ 4199635969 ] # Q2 % .L1 # table_name % revenue # name -% hugeint # type +% bigint # type % 9 # length [ 927530712 ] # Q3 % .L1 # table_name % revenue # name -% hugeint # type +% bigint # type % 9 # length [ 213477639 ] # Q4 % .L1, .dwdate, .part # table_name % L1, d_year, p_brand1 # name -% hugeint, int, clob # type +% bigint, int, clob # type % 8, 4, 9 # length [ 35741623, 1992, "MFGR#1211" ] [ 13582129, 1992, "MFGR#1212" ] @@ -190,7 +190,7 @@ 60175 rows in mergetable # Q5 % .L1, .dwdate, .part # table_name % L1, d_year, p_brand1 # name -% hugeint, int, clob # type +% bigint, int, clob # type % 8, 4, 9 # length [ 10306232, 1992, "MFGR#2221" ] [ 7096296, 1992, "MFGR#2222" ] @@ -241,7 +241,7 @@ 60175 rows in mergetable # Q6 % .L1, .dwdate, .part # table_name % L1, d_year, p_brand1 # name -% hugeint, int, clob # type +% bigint, int, clob # type % 8, 4, 9 # length [ 2535744, 1992, "MFGR#2221" ] [ 5646414, 1993, "MFGR#2221" ] @@ -254,7 +254,7 @@ 60175 rows in mergetable # Q7 % .customer, .supplier, .dwdate, .L1 # table_name % c_nation, s_nation, d_year, revenue # name -% clob, clob, int, hugeint # type +% clob, clob, int, bigint # type % 9, 9, 4, 9 # length [ "INDONESIA", "VIETNAM", 1992, 172784923 ] [ "INDONESIA", "INDIA", 1992, 121272321 ] @@ -410,25 +410,25 @@ 60175 rows in mergetable # Q8 % .customer, .supplier, .dwdate, . # table_name % c_city, s_city, d_year, revenue # name -% clob, clob, int, hugeint # type +% clob, clob, int, bigint # type % 0, 0, 1, 1 # length # Q09 % .customer, .supplier, .dwdate, . # table_name % c_city, s_city, d_year, revenue # name -% clob, clob, int, hugeint # type +% clob, clob, int, bigint # type % 0, 0, 1, 1 # length # Q10 % .customer, .supplier, .dwdate, . # table_name % c_city, s_city, d_year, revenue # name -% clob, clob, int, hugeint # type +% clob, clob, int, bigint # type % 0, 0, 1, 1 # length # Q11 % .dwdate, .customer, . # table_name % d_year, c_nation, profit1 # name -% int, clob, hugeint # type +% int, clob, bigint # type % 4, 9, 9 # length [ 1992, "ARGENTINA", 60236596 ] [ 1992, "BRAZIL", 50116740 ] @@ -462,7 +462,7 @@ 60175 rows in mergetable # Q12 % .dwdate, .supplier, .part, . # table_name % d_year, s_nation, p_category, profit1 # name -% int, clob, clob, hugeint # type +% int, clob, clob, bigint # type % 4, 13, 7, 8 # length [ 1997, "ARGENTINA", "MFGR#11", 6011959 ] [ 1997, "ARGENTINA", "MFGR#12", 10930453 ] @@ -544,7 +544,7 @@ 60175 rows in mergetable # Q13 % .dwdate, .supplier, .part, . # table_name % d_year, s_city, p_brand1, profit1 # name -% int, clob, clob, hugeint # type +% int, clob, clob, bigint # type % 4, 10, 9, 7 # length [ 1997, "UNITED ST2", "MFGR#1433", 2636841 ] [ 1997, "UNITED ST6", "MFGR#1415", 5022945 ] diff --git a/sql/test/remote/Tests/ssbm.stable.out.int128 b/sql/test/remote/Tests/ssbm.stable.out.int128 new file mode 100644 --- /dev/null +++ b/sql/test/remote/Tests/ssbm.stable.out.int128 @@ -0,0 +1,556 @@ +stdout of test 'ssbm` in directory 'sql/test/remote` itself: + +Ready. + +60175 rows in mergetable + +# manually adapted test output from ssbm test cases +# Q1 +% .L1 # table_name +% revenue # name +% hugeint # type +% 10 # length +[ 4199635969 ] + +# Q2 +% .L1 # table_name +% revenue # name +% hugeint # type +% 9 # length +[ 927530712 ] + +# Q3 +% .L1 # table_name +% revenue # name +% hugeint # type +% 9 # length +[ 213477639 ] + +# Q4 +% .L1, .dwdate, .part # table_name +% L1, d_year, p_brand1 # name +% hugeint, int, clob # type +% 8, 4, 9 # length +[ 35741623, 1992, "MFGR#1211" ] +[ 13582129, 1992, "MFGR#1212" ] +[ 2420150, 1992, "MFGR#1217" ] +[ 7015912, 1992, "MFGR#1219" ] +[ 2641607, 1992, "MFGR#122" ] +[ 2563912, 1992, "MFGR#1221" ] +[ 6003315, 1992, "MFGR#1223" ] +[ 8704784, 1992, "MFGR#1224" ] +[ 13700463, 1992, "MFGR#1225" ] +[ 12610793, 1992, "MFGR#1226" ] +[ 5995739, 1992, "MFGR#1228" ] +[ 7552882, 1992, "MFGR#1230" ] +[ 13184783, 1992, "MFGR#1232" ] +[ 3231894, 1992, "MFGR#1240" ] +[ 7214844, 1992, "MFGR#125" ] +[ 35054814, 1992, "MFGR#127" ] +[ 15102503, 1992, "MFGR#128" ] +[ 7639101, 1992, "MFGR#129" ] +[ 3339630, 1993, "MFGR#121" ] +[ 11514911, 1993, "MFGR#1211" ] +[ 4294668, 1993, "MFGR#1212" ] +[ 8122643, 1993, "MFGR#1213" ] +[ 3678145, 1993, "MFGR#1214" ] +[ 7325684, 1993, "MFGR#1217" ] +[ 16038869, 1993, "MFGR#1218" ] +[ 26560659, 1993, "MFGR#1219" ] +[ 5551142, 1993, "MFGR#1220" ] +[ 3484096, 1993, "MFGR#1222" ] +[ 21747351, 1993, "MFGR#1223" ] +[ 5762459, 1993, "MFGR#1224" ] +[ 10279155, 1993, "MFGR#1225" ] +[ 9952878, 1993, "MFGR#1226" ] +[ 6572535, 1993, "MFGR#1228" ] +[ 10193031, 1993, "MFGR#1230" ] +[ 12137253, 1993, "MFGR#1233" ] +[ 6960104, 1993, "MFGR#1236" ] +[ 10329821, 1993, "MFGR#1239" ] +[ 4258048, 1993, "MFGR#1240" ] +[ 1382981, 1993, "MFGR#125" ] +[ 2821764, 1993, "MFGR#126" ] +[ 14693311, 1993, "MFGR#127" ] +[ 1799648, 1993, "MFGR#128" ] +[ 5071393, 1993, "MFGR#129" ] +[ 18995020, 1994, "MFGR#121" ] +[ 4586682, 1994, "MFGR#1211" ] +[ 19530708, 1994, "MFGR#1212" ] +[ 1728488, 1994, "MFGR#1213" ] +[ 13010765, 1994, "MFGR#1218" ] +[ 10997176, 1994, "MFGR#1219" ] +[ 4554495, 1994, "MFGR#122" ] +[ 8557774, 1994, "MFGR#1220" ] +[ 5584069, 1994, "MFGR#1222" ] +[ 10104525, 1994, "MFGR#1223" ] +[ 4775592, 1994, "MFGR#1224" ] +[ 10713992, 1994, "MFGR#1225" ] +[ 3750100, 1994, "MFGR#1226" ] +[ 1794201, 1994, "MFGR#123" ] +[ 5980941, 1994, "MFGR#1232" ] +[ 7859272, 1994, "MFGR#1233" ] +[ 3550796, 1994, "MFGR#1236" ] +[ 2106877, 1994, "MFGR#1238" ] +[ 14223208, 1994, "MFGR#1239" ] +[ 4027318, 1994, "MFGR#1240" ] +[ 17777153, 1994, "MFGR#125" ] +[ 4869251, 1994, "MFGR#126" ] +[ 15392246, 1994, "MFGR#127" ] +[ 900044, 1994, "MFGR#128" ] +[ 5656126, 1994, "MFGR#129" ] +[ 1097742, 1995, "MFGR#1211" ] +[ 2707025, 1995, "MFGR#1213" ] +[ 4200351, 1995, "MFGR#1214" ] +[ 2509211, 1995, "MFGR#1217" ] +[ 5595420, 1995, "MFGR#1218" ] +[ 9841612, 1995, "MFGR#1219" ] +[ 4624540, 1995, "MFGR#1220" ] +[ 19279359, 1995, "MFGR#1222" ] +[ 5452000, 1995, "MFGR#1223" ] +[ 18723136, 1995, "MFGR#1224" ] +[ 14590136, 1995, "MFGR#1225" ] +[ 8338345, 1995, "MFGR#1226" ] +[ 8260673, 1995, "MFGR#1228" ] +[ 97819, 1995, "MFGR#1230" ] +[ 6377178, 1995, "MFGR#1232" ] +[ 14117772, 1995, "MFGR#1233" ] +[ 22661695, 1995, "MFGR#1236" ] +[ 5142893, 1995, "MFGR#1239" ] +[ 17227363, 1995, "MFGR#1240" ] +[ 7873139, 1995, "MFGR#125" ] +[ 14385634, 1995, "MFGR#128" ] +[ 4383708, 1995, "MFGR#129" ] +[ 12158316, 1996, "MFGR#121" ] +[ 13534131, 1996, "MFGR#1211" ] +[ 27850979, 1996, "MFGR#1212" ] +[ 784827, 1996, "MFGR#1218" ] +[ 1069800, 1996, "MFGR#122" ] +[ 4348542, 1996, "MFGR#1221" ] +[ 8295332, 1996, "MFGR#1222" ] +[ 11183976, 1996, "MFGR#1224" ] +[ 19971623, 1996, "MFGR#1225" ] +[ 10005626, 1996, "MFGR#1232" ] +[ 5135891, 1996, "MFGR#1236" ] +[ 4613081, 1996, "MFGR#1239" ] +[ 16358592, 1996, "MFGR#1240" ] +[ 18374286, 1996, "MFGR#125" ] +[ 4288542, 1996, "MFGR#126" ] +[ 32750117, 1996, "MFGR#127" ] +[ 128577, 1996, "MFGR#128" ] +[ 6040770, 1996, "MFGR#129" ] +[ 4313787, 1997, "MFGR#121" ] +[ 15464411, 1997, "MFGR#1211" ] +[ 17725171, 1997, "MFGR#1212" ] +[ 2137125, 1997, "MFGR#1213" ] +[ 4188998, 1997, "MFGR#1214" ] +[ 4172057, 1997, "MFGR#1217" ] +[ 15556327, 1997, "MFGR#1219" ] +[ 5953230, 1997, "MFGR#122" ] +[ 10529427, 1997, "MFGR#1220" ] +[ 9097752, 1997, "MFGR#1221" ] +[ 8668003, 1997, "MFGR#1222" ] +[ 18232285, 1997, "MFGR#1223" ] +[ 13859956, 1997, "MFGR#1224" ] +[ 2793729, 1997, "MFGR#1225" ] +[ 19174753, 1997, "MFGR#1226" ] +[ 5128426, 1997, "MFGR#123" ] +[ 4304076, 1997, "MFGR#1230" ] +[ 8866362, 1997, "MFGR#1232" ] +[ 5328122, 1997, "MFGR#1233" ] +[ 13735907, 1997, "MFGR#1236" ] +[ 10755017, 1997, "MFGR#1240" ] +[ 327046, 1997, "MFGR#125" ] +[ 13218597, 1997, "MFGR#127" ] +[ 10434877, 1997, "MFGR#128" ] +[ 8052920, 1997, "MFGR#129" ] +[ 10864281, 1998, "MFGR#121" ] +[ 2140471, 1998, "MFGR#1211" ] +[ 15949227, 1998, "MFGR#1212" ] +[ 9091580, 1998, "MFGR#1217" ] +[ 7834997, 1998, "MFGR#1219" ] +[ 2319634, 1998, "MFGR#1220" ] +[ 19485508, 1998, "MFGR#1222" ] +[ 1919741, 1998, "MFGR#1223" ] +[ 7617265, 1998, "MFGR#1224" ] +[ 4074189, 1998, "MFGR#1225" ] +[ 7341274, 1998, "MFGR#123" ] +[ 2607543, 1998, "MFGR#1230" ] +[ 13307853, 1998, "MFGR#1232" ] +[ 5316438, 1998, "MFGR#1233" ] +[ 1879252, 1998, "MFGR#1236" ] +[ 2738610, 1998, "MFGR#1238" ] +[ 733435, 1998, "MFGR#1239" ] +[ 5151646, 1998, "MFGR#1240" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list