Test 01-22.SQL.bat (id cbeba89afadb) (err)
01-22.stable.out.FILTERED 2019-01-10 00:37:50.750327700 +010001-22.test.out.FILTERED 2019-01-10 00:37:50.781620800 +0100
1 Statistics about stdout of test '01-22` in directory 'sql/benchmarks/tpch`: 1 1 Statistics about stdout of test '01-22` in directory 'sql/benchmarks/tpch`: 1
2 665 lines, 4714 words, 28883 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 660 lines, 4695 words, 28801 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 665 lines, 4714 words, 28883 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 660 lines, 4695 words, 28801 chars in lines not matching '^$|^(\| |)#` 3
4 # 1259 lines, 6837 words, 42711 chars in all lines 4 ! 4 # 1287 lines, 6943 words, 43521 chars in all lines 4
5 5 5 5
..................
# end) / sum(l_extendedprice * (1
709 #from 709 717 #from 717
710 # lineitem, 710 ! 718 # supplier, 718
711 # part 711 ! 719 # revenue0 719
712 #where 712 720 #where 720
713 # l_partkey = p_partkey 713 ! 721 # s_suppkey = supplier_no 721
714 # and l_shipdate >= date '1995-09-01' 714 ! 722 # and total_revenue = ( 722
715 # and l_shipdate < date '1995-09-01' + interval '1' month; 715 ! 723 # select 723
716 % sys. # table_name 716 ! 724 # max(total_revenue) 724
717 # sys.L5 # table_name 717 ! 725 # from 725
718 % promo_revenue # name 718 ! 726 # revenue0 726
719 % decimal # type 719 ! 727 # ) 727
720 % 20 # length 720 ! 728 #order by 728
721 [ 15.48654 ] 721 ! 729 # s_suppkey; 729
722 722 -
723 % sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.revenue0 # table_name 723 730 % sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.revenue0 # table_name 730