Test subquery3.sql (id a7c289e8f33c) (err)
subquery3.stable.out.FILTERED 2019-12-03 20:04:32.862653411 +0100subquery3.test.out.FILTERED 2019-12-03 20:04:32.872653861 +0100
+ 1 Statistics about stdout of test 'subquery3` in directory 'sql/test/subquery`: 1
+ 2 56 lines, 345 words, 1441 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 56 lines, 345 words, 1441 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 140 lines, 879 words, 5291 chars in all lines 4
+ 5 5
+ 6 stdout of test 'subquery3` in directory 'sql/test/subquery` itself: 6
+ 7 7
+ 8 8
+ 9 # 20:04:32 > 9
+ 10 # 20:04:32 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=8" "--set" "mapi_open=true" "--set" "mapi_port=31146" "--set" "mapi_usock=/var/tmp/mtest-96478/.s.monetdb.31146" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/home/monet/testing/a7c289e8f33c-6-1-1/tests/sql/dbfarm/mTests_sql_test_subquery" "--set" "embedded_c=true" 10
+ 11 # 20:04:32 > 11
+ 12 12
+ 13 # MonetDB 5 server v11.35.4 13
+ 14 # This is an unreleased version 14
+ 15 # Serving database 'mTests_sql_test_subquery', using 8 threads 15
+ 16 # Compiled for powerpc64-unknown-linux-gnu/64bit with 128bit integers 16
+ 17 # Found 255.358 GiB available main-memory of which we use 208.117 GiB 17
+ 18 # Copyright (c) 1993 - July 2008 CWI. 18
+ 19 # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved 19
+ 20 # Visit https://www.monetdb.org/ for further information 20
+ 21 # Listening for connection requests on mapi:monetdb://power8:31146/ 21
+ 22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-96478/.s.monetdb.31146 22
+ 23 # MonetDB/GIS module loaded 23
+ 24 # MonetDB/SQL module loaded 24
+ 25 25
+ 26 # 20:04:32 > 26
+ 27 # 20:04:32 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-96478" "--port=31146" 27
+ 28 # 20:04:32 > 28
+ 29 29
+ 30 #CREATE TABLE tbl_ProductSales (ColID int, Product_Category varchar(64), Product_Name varchar(64), TotalSales int); 30
+ 31 #INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100); 31
+ 32 [ 4 ] 32
+ 33 #CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT, col8 INT); 33
+ 34 #INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888); 34
+ 35 [ 4 ] 35
+ 36 #SELECT 36
+ 37 # NOT MAX(t1.col6) IN (SELECT SUM(t1.col6) FROM tbl_ProductSales tp HAVING MAX(t1.col1) > MIN(tp.colID)) 37
+ 38 #FROM another_T t1 38
+ 39 #GROUP BY t1.col6, t1.col7; 39
+ 40 % sys. # table_name 40
+ 41 # sys.L12 # table_name 41
+ 42 % L # name 42
+ 43 # L12 # name 43
+ 44 % boolean # type 44
+ 45 % 5 # length 45
+ 46 [ false ] 46
+ 47 [ false ] 47
+ 48 [ false ] 48
+ 49 [ false ] 49
+ 50 #SELECT 50
+ 51 # (SELECT MAX(ColID + col2) FROM tbl_ProductSales) * DENSE_RANK() OVER (PARTITION BY AVG(DISTINCT col5)), 51
+ 52 # AVG(col1) * MIN(col8) OVER (PARTITION BY col5 ORDER BY col1 ROWS UNBOUNDED PRECEDING) evil, 52
+ 53 # MAX(col3) / 10 + SUM(col1) * 10 53
+ 54 #FROM another_T 54
+ 55 #GROUP BY col1, col2, col5, col8; 55
+ 56 % sys.another_t, sys.another_t, sys.another_t, sys.another_t, ., sys., ., sys., sys. # table_name 56
+ 57 # sys.another_t, sys.another_t, sys.another_t, sys.another_t, .L4, sys.L12, .L14, sys.L20, sys.L23 # table_name 57
+ 58 % col1, col2, col5, col8, L, L, L, evil, L # name 58
+ 59 # col1, col2, col5, col8, L4, L12, L14, evil, L23 # name 59
+ 60 % int, int, int, int, bigint, int, hugeint, double, hugeint # type 60
+ 61 % 4, 4, 4, 4, 4, 1, 4, 24, 5 # length 61
+ 62 [ 1, 2, 5, 8, 6, 1, 6, 8, 10 ] 62
+ 63 [ 11, 22, 55, 88, 26, 1, 26, 968, 113 ] 63
+ 64 [ 111, 222, 555, 888, 226, 1, 226, 98568, 1143 ] 64
+ 65 [ 1111, 2222, 5555, 8888, 2226, 1, 2226, 9874568, 11443 ] 65
+ 66 #SELECT 66
+ 67 # EXISTS (SELECT col1 WHERE TRUE), 67
+ 68 # EXISTS (SELECT col1 WHERE FALSE), 68
+ 69 # EXISTS (SELECT col1 WHERE NULL), 69
+ 70 # NOT EXISTS (SELECT col1 WHERE TRUE), 70
+ 71 # NOT EXISTS (SELECT col1 WHERE FALSE), 71
+ 72 # NOT EXISTS (SELECT col1 WHERE NULL) 72
+ 73 #FROM another_T t1; 73
+ 74 % ., ., ., ., ., . # table_name 74
+ 75 # .L4, .L10, .L14, .L20, .L24, .L30 # table_name 75
+ 76 % L, L, L, L, L, L # name 76
+ 77 # L4, L10, L14, L20, L24, L30 # name 77
+ 78 % boolean, boolean, boolean, boolean, boolean, boolean # type 78
+ 79 % 5, 5, 5, 5, 5, 5 # length 79
+ 80 [ true, true, true, false, false, false ] 80
+ 81 [ true, true, true, false, false, false ] 81
+ 82 [ true, true, true, false, false, false ] 82
+ 83 [ true, true, true, false, false, false ] 83
+ 84 #SELECT 84
+ 85 # EXISTS (SELECT AVG(col1) WHERE TRUE), 85
+ 86 # EXISTS (SELECT AVG(col1) WHERE FALSE), 86
+ 87 # EXISTS (SELECT AVG(col1) WHERE NULL), 87
+ 88 # NOT EXISTS (SELECT AVG(col1) WHERE TRUE), 88
+ 89 # NOT EXISTS (SELECT AVG(col1) WHERE FALSE), 89
+ 90 # NOT EXISTS (SELECT AVG(col1) WHERE NULL) 90
+ 91 #FROM another_T t1; 91
+ 92 % ., ., ., ., ., . # table_name 92
+ 93 # .L7, .L16, .L25, .L34, .L43, .L52 # table_name 93
+ 94 % L, L, L, L, L, L # name 94
+ 95 # L7, L16, L25, L34, L43, L52 # name 95
+ 96 % boolean, boolean, boolean, boolean, boolean, boolean # type 96
+ 97 % 5, 5, 5, 5, 5, 5 # length 97
+ 98 [ true, true, true, false, false, false ] 98
+ 99 [ true, true, true, false, false, false ] 99
+ 100 [ true, true, true, false, false, false ] 100
+ 101 [ true, true, true, false, false, false ] 101
+ 102 #SELECT 102
+ 103 # (SELECT MAX(t1.col2) * SUM(AVG(ColID)) OVER (PARTITION BY SUM(ColID) ORDER BY MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 103
+ 104 #FROM another_T t1; 104
+ 105 % . # table_name 105
+ 106 # .L25 # table_name 106
+ 107 % L # name 107
+ 108 # L25 # name 108
+ 109 % double # type 109
+ 110 % 24 # length 110
+ 111 [ 5555 ] 111
+ 112 #SELECT 112
+ 113 # (SELECT MAX(ColID) * SUM(AVG(ColID)) OVER (PARTITION BY SUM(ColID) ORDER BY MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 113
+ 114 #FROM another_T t1; --MonetDB outputs this one right, but we should leave it here, as it doesn't trigger an error 114
+ 115 % sys. # table_name 115
+ 116 # sys.L11 # table_name 116
+ 117 % L # name 117
+ 118 # L11 # name 118
+ 119 % double # type 119
+ 120 % 24 # length 120
+ 121 [ 10 ] 121
+ 122 [ 10 ] 122
+ 123 [ 10 ] 123
+ 124 [ 10 ] 124
+ 125 #SELECT 125
+ 126 # (SELECT SUM(SUM(col2)) OVER (PARTITION BY SUM(col2) ORDER BY MAX(col1) ROWS UNBOUNDED PRECEDING) FROM another_T) 126
+ 127 #FROM another_T t1 127
+ 128 #GROUP BY col1; --MonetDB outputs this one right, but we should leave it here, as it doesn't trigger an error 128
+ 129 % sys. # table_name 129
+ 130 # sys.L6 # table_name 130
+ 131 % L # name 131
+ 132 # L6 # name 132
+ 133 % hugeint # type 133
+ 134 % 4 # length 134
+ 135 [ 2468 ] 135
+ 136 [ 2468 ] 136
+ 137 [ 2468 ] 137
+ 138 [ 2468 ] 138
+ 139 #DROP TABLE tbl_ProductSales; 139
+ 140 #DROP TABLE another_T; 140
+ 141 141
+ 142 # 20:04:32 > 142
+ 143 # 20:04:32 > "Done." 143
+ 144 # 20:04:32 > 144
+ 145 145