Test subquery3.sql (id a7c289e8f33c) (err)
subquery3.stable.out.FILTERED 2019-12-03 21:41:33.854099200 +0100subquery3.test.out.FILTERED 2019-12-03 21:41:33.854099200 +0100
+ 1 Statistics about stdout of test 'subquery3` in directory 'sql/test/subquery`: 1
+ 2 56 lines, 345 words, 1438 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 56 lines, 345 words, 1438 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 139 lines, 863 words, 5031 chars in all lines 4
+ 5 5
+ 6 stdout of test 'subquery3` in directory 'sql/test/subquery` itself: 6
+ 7 7
+ 8 8
+ 9 # 21:41:32 > 9
+ 10 # 21:41:32 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=32775" "--forcemito" "--dbpath=C:\monettesting\a7c289e8f33c-2-1-2\tests\sql\dbfarm\mTests_sql_test_subquery" "--set" "embedded_c=true" 10
+ 11 # 21:41: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 4 threads 15
+ 16 # Compiled for i686-pc-winnt/32bit 16
+ 17 # Found 11.991 GiB available main-memory of which we use 1.500 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://lab03:32775/ 21
+ 22 # MonetDB/GIS module loaded 22
+ 23 # MonetDB/SQL module loaded 23
+ 24 24
+ 25 # 21:41:33 > 25
+ 26 # 21:41:33 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=32775" 26
+ 27 # 21:41:33 > 27
+ 28 28
+ 29 #CREATE TABLE tbl_ProductSales (ColID int, Product_Category varchar(64), Product_Name varchar(64), TotalSales int); 29
+ 30 #INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100); 30
+ 31 [ 4 ] 31
+ 32 #CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT, col8 INT); 32
+ 33 #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); 33
+ 34 [ 4 ] 34
+ 35 #SELECT 35
+ 36 # NOT MAX(t1.col6) IN (SELECT SUM(t1.col6) FROM tbl_ProductSales tp HAVING MAX(t1.col1) > MIN(tp.colID)) 36
+ 37 #FROM another_T t1 37
+ 38 #GROUP BY t1.col6, t1.col7; 38
+ 39 % sys. # table_name 39
+ 40 # sys.L12 # table_name 40
+ 41 % L # name 41
+ 42 # L12 # name 42
+ 43 % boolean # type 43
+ 44 % 5 # length 44
+ 45 [ false ] 45
+ 46 [ false ] 46
+ 47 [ false ] 47
+ 48 [ false ] 48
+ 49 #SELECT 49
+ 50 # (SELECT MAX(ColID + col2) FROM tbl_ProductSales) * DENSE_RANK() OVER (PARTITION BY AVG(DISTINCT col5)), 50
+ 51 # AVG(col1) * MIN(col8) OVER (PARTITION BY col5 ORDER BY col1 ROWS UNBOUNDED PRECEDING) evil, 51
+ 52 # MAX(col3) / 10 + SUM(col1) * 10 52
+ 53 #FROM another_T 53
+ 54 #GROUP BY col1, col2, col5, col8; 54
+ 55 % sys.another_t, sys.another_t, sys.another_t, sys.another_t, ., sys., ., sys., sys. # table_name 55
+ 56 # sys.another_t, sys.another_t, sys.another_t, sys.another_t, .L4, sys.L12, .L14, sys.L20, sys.L23 # table_name 56
+ 57 % col1, col2, col5, col8, L, L, L, evil, L # name 57
+ 58 # col1, col2, col5, col8, L4, L12, L14, evil, L23 # name 58
+ 59 % int, int, int, int, bigint, int, bigint, double, bigint # type 59
+ 60 % 4, 4, 4, 4, 4, 1, 4, 24, 5 # length 60
+ 61 [ 1, 2, 5, 8, 6, 1, 6, 8, 10 ] 61
+ 62 [ 11, 22, 55, 88, 26, 1, 26, 968, 113 ] 62
+ 63 [ 111, 222, 555, 888, 226, 1, 226, 98568, 1143 ] 63
+ 64 [ 1111, 2222, 5555, 8888, 2226, 1, 2226, 9874568, 11443 ] 64
+ 65 #SELECT 65
+ 66 # EXISTS (SELECT col1 WHERE TRUE), 66
+ 67 # EXISTS (SELECT col1 WHERE FALSE), 67
+ 68 # EXISTS (SELECT col1 WHERE NULL), 68
+ 69 # NOT EXISTS (SELECT col1 WHERE TRUE), 69
+ 70 # NOT EXISTS (SELECT col1 WHERE FALSE), 70
+ 71 # NOT EXISTS (SELECT col1 WHERE NULL) 71
+ 72 #FROM another_T t1; 72
+ 73 % ., ., ., ., ., . # table_name 73
+ 74 # .L4, .L10, .L14, .L20, .L24, .L30 # table_name 74
+ 75 % L, L, L, L, L, L # name 75
+ 76 # L4, L10, L14, L20, L24, L30 # name 76
+ 77 % boolean, boolean, boolean, boolean, boolean, boolean # type 77
+ 78 % 5, 5, 5, 5, 5, 5 # length 78
+ 79 [ true, true, true, false, false, false ] 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 #SELECT 83
+ 84 # EXISTS (SELECT AVG(col1) WHERE TRUE), 84
+ 85 # EXISTS (SELECT AVG(col1) WHERE FALSE), 85
+ 86 # EXISTS (SELECT AVG(col1) WHERE NULL), 86
+ 87 # NOT EXISTS (SELECT AVG(col1) WHERE TRUE), 87
+ 88 # NOT EXISTS (SELECT AVG(col1) WHERE FALSE), 88
+ 89 # NOT EXISTS (SELECT AVG(col1) WHERE NULL) 89
+ 90 #FROM another_T t1; 90
+ 91 % ., ., ., ., ., . # table_name 91
+ 92 # .L7, .L16, .L25, .L34, .L43, .L52 # table_name 92
+ 93 % L, L, L, L, L, L # name 93
+ 94 # L7, L16, L25, L34, L43, L52 # name 94
+ 95 % boolean, boolean, boolean, boolean, boolean, boolean # type 95
+ 96 % 5, 5, 5, 5, 5, 5 # length 96
+ 97 [ true, true, true, false, false, false ] 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 #SELECT 101
+ 102 # (SELECT MAX(t1.col2) * SUM(AVG(ColID)) OVER (PARTITION BY SUM(ColID) ORDER BY MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 102
+ 103 #FROM another_T t1; 103
+ 104 % . # table_name 104
+ 105 # .L25 # table_name 105
+ 106 % L # name 106
+ 107 # L25 # name 107
+ 108 % double # type 108
+ 109 % 24 # length 109
+ 110 [ 5555 ] 110
+ 111 #SELECT 111
+ 112 # (SELECT MAX(ColID) * SUM(AVG(ColID)) OVER (PARTITION BY SUM(ColID) ORDER BY MAX(ColID) ROWS UNBOUNDED PRECEDING) FROM tbl_ProductSales) 112
+ 113 #FROM another_T t1; --MonetDB outputs this one right, but we should leave it here, as it doesn't trigger an error 113
+ 114 % sys. # table_name 114
+ 115 # sys.L11 # table_name 115
+ 116 % L # name 116
+ 117 # L11 # name 117
+ 118 % double # type 118
+ 119 % 24 # length 119
+ 120 [ 10 ] 120
+ 121 [ 10 ] 121
+ 122 [ 10 ] 122
+ 123 [ 10 ] 123
+ 124 #SELECT 124
+ 125 # (SELECT SUM(SUM(col2)) OVER (PARTITION BY SUM(col2) ORDER BY MAX(col1) ROWS UNBOUNDED PRECEDING) FROM another_T) 125
+ 126 #FROM another_T t1 126
+ 127 #GROUP BY col1; --MonetDB outputs this one right, but we should leave it here, as it doesn't trigger an error 127
+ 128 % sys. # table_name 128
+ 129 # sys.L6 # table_name 129
+ 130 % L # name 130
+ 131 # L6 # name 131
+ 132 % bigint # type 132
+ 133 % 4 # length 133
+ 134 [ 2468 ] 134
+ 135 [ 2468 ] 135
+ 136 [ 2468 ] 136
+ 137 [ 2468 ] 137
+ 138 #DROP TABLE tbl_ProductSales; 138
+ 139 #DROP TABLE another_T; 139
+ 140 140
+ 141 # 21:41:33 > 141
+ 142 # 21:41:33 > "Done." 142
+ 143 # 21:41:33 > 143
+ 144 144