Test VOC.SQL.py (id c5a742c3bbbc) (err)
VOC.stable.out.FILTERED 2020-11-20 19:54:23.423040600 +0100VOC.test.out.FILTERED 2020-11-20 19:54:23.516774100 +0100
1 Statistics about stdout of test 'VOC` in directory 'sql/test/VOC`: 1 1 Statistics about stdout of test 'VOC` in directory 'sql/test/VOC`: 1
2 9704 lines, 32479 words, 155323 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 9688 lines, 32412 words, 155062 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 9704 lines, 32479 words, 155323 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 9688 lines, 32412 words, 155062 chars in lines not matching '^$|^(\| |)#` 3
4 # 9954 lines, 33482 words, 163157 chars in all lines 4 ! 4 # 9864 lines, 33062 words, 159898 chars in all lines 4
5 5 5 5
..................
# %1 # name
9901 [ 938 ] 9901 9864 [ 938 ] 9864
9902 #SELECT COUNT(*) FROM voyages WHERE particulars LIKE '%_recked%'; 9902 -
9903 % voc.%1 # table_name 9903 -
9904 % % # name 9904 -
9905 # %1 # name 9905 -
9906 % bigint # type 9906 -
9907 % 3 # length 9907 -
9908 [ 358 ] 9908 -
9909 #SELECT chamber, CAST(AVG(invoice) AS integer) AS average 9909 -
9910 #FROM invoices 9910 -
9911 #WHERE invoice IS NOT NULL 9911 -
9912 #GROUP BY chamber 9912 -
9913 #ORDER BY average DESC; 9913 -
9914 % voc.invoices, voc. # table_name 9914 -
9915 % chamber, average # name 9915 -
9916 % char, int # type 9916 -
9917 % 1, 6 # length 9917 -
9918 [ "A", 282997 ] 9918 -
9919 [ "Z", 259301 ] 9919 -
9920 [ "H", 150182 ] 9920 -
9921 [ "R", 149628 ] 9921 -
9922 [ "D", 149523 ] 9922 -
9923 [ "E", 149518 ] 9923 -
9924 [ NULL, 83309 ] 9924 -
9925 #CREATE VIEW extended_onboard AS 9925 -
9926 #SELECT number, number_sup, trip, trip_sup, onboard_at_departure, death_at_cape, 9926 -
9927 # left_at_cape, onboard_at_cape, death_during_voyage, onboard_at_arrival, 9927 -
9928 # death_during_voyage - left_at_cape AS death_at_arrival 9928 -
9929 #FROM onboard_people; 9929 -
9930 9930 -
9931 # 17:10:12 > 9931 -
9932 # 17:10:12 > Mtimeout -timeout 120 mclient -lsql -ftest -e --host=ottar --port=37097 --database=mTests_test_VOC ../../../../../../../scratch1/sjoerd/src/MonetDB/candidate/sql/test/VOC/Tests/../VOCdrop.sql 9932 -
9933 # 17:10:12 > 9933 -
9934 9934 -
9935 #START TRANSACTION; 9935 -
9936 #drop table total cascade; 9936 -
9937 #drop table soldiers cascade; 9937 -
9938 #drop table seafarers cascade; 9938 -
9939 #drop table passengers cascade; 9939 -
9940 #drop table invoices cascade; 9940 -
9941 #drop table impotenten cascade; 9941 -
9942 #drop table craftsmen cascade; 9942 -
9943 #drop table voyages cascade; 9943 -
9944 #commit; 9944 -
9945 9945 -
9946 # 17:10:12 > 9946 -
9947 # 17:10:12 > Mtimeout -timeout 120 mclient -lsql -ftest -e --host=ottar --port=37097 --database=mTests_test_VOC ../../../../../../../scratch1/sjoerd/src/MonetDB/candidate/sql/test/VOC/Tests/../VOCdrop_user.sql 9947 -
9948 # 17:10:12 > 9948 -
9949 9949 -
9950 #START TRANSACTION; 9950 -
9951 #ALTER USER "voc" SET SCHEMA "sys"; 9951 -
9952 #DROP SCHEMA "voc"; 9952 -
9953 #DROP USER "voc"; 9953 -
9954 #commit; 9954 -
9955 9955 9865 9865