Test subquery2.sql (id 6b3b1396de21) (out)
subquery2.stable.err.FILTERED 2019-09-20 08:14:55.705407941 +0200subquery2.test.err.FILTERED 2019-09-20 08:14:55.725408852 +0200
1 Statistics about stderr of test 'subquery2` in directory 'sql/test/subquery`: 1 1 Statistics about stderr of test 'subquery2` in directory 'sql/test/subquery`: 1
2 1 lines, 8 words, 67 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 161 lines, 635 words, 10942 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 67 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 161 lines, 635 words, 10942 chars in lines not matching '^$|^(\| |)#` 3
4 # 18 lines, 63 words, 653 chars in all lines 4 ! 4 # 181 lines, 707 words, 11677 chars in all lines 4
5 5 5 5
..................
# 18 lines, 63 words,
8 8 8 8
9 # 18:55:45 > 9 ! 9 # 08:14:44 > 9
10 # 18:55:45 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39342" "--set" "mapi_usock=/var/tmp/mtest-31262/.s.monetdb.39342" "--set" "monet_prompt=" "--forcemito" "--dbpath=/home/niels/scratch/monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_subquery" "--set" "embedded_c=true" 10 ! 10 # 08:14:44 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=8" "--set" "mapi_open=true" "--set" "mapi_port=33483" "--set" "mapi_usock=/var/tmp/mtest-86706/.s.monetdb.33483" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_subquery" "--set" "embedded_c=true" 10
11 # 18:55:45 > 11 ! 11 # 08:14:44 > 11
12 12 ! 12 12
13 #client1:!ERROR:MALException:client.quit:Server stopped 13 ! 13 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function 13
14 14 ! 14 could not find L4.L4 14
15 # 18:55:46 > 15 ! 15 another_t.col1 15
16 # 18:55:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-31262" "--port=39342" 16 ! 16 mserver5: /home/monet/testing/6b3b1396de21-6-1-1/MonetDB/sql/backends/monet5/rel_bin.c:730: exp_bin: Assertion `s' failed. 16
17 # 18:55:46 > 17 ! 17 17
18 18 ! 18 Aborted 18
19 19 ! 19 PID: 90430 (mserver5) 19
20 # 18:55:46 > 20 ! 20 UID: 1004 (monet) 20
21 # 18:55:46 > "Done." 21 ! 21 GID: 1004 (monet) 21
22 # 18:55:46 > 22 ! 22 Signal: 6 (ABRT) 22
+ 23 Timestamp: Fri 2019-09-20 08:14:45 CEST (10s ago) 23
+ 24 Command Line: mserver5 --debug=10 --set gdk_nr_threads 8 --set mapi_open true --set mapi_port 33483 --set mapi_usock /var/tmp/mtest-86706/.s.monetdb.33483 --forcemito --set gdk_vm_maxsize 8589934592 --dbpath=/home/monet/testing/6b3b1396de21-6-1-1/tests/sql/dbfarm/mTests_sql_test_subquery --set embedded_c true 24
+ 25 Executable: /home/monet/testing/6b3b1396de21-6-1-1/install/bin/mserver5 25
+ 26 Control Group: /user.slice/user-1004.slice/session-18019.scope 26
+ 27 Unit: session-18019.scope 27
+ 28 Slice: user-1004.slice 28
+ 29 Session: 18019 29
+ 30 Owner UID: 1004 (monet) 30
+ 31 Boot ID: 4ba92a54f72741f8b17802ab88fda45e 31
+ 32 Machine ID: a998d3c0aae64c3687c63b8f30bf5431 32
+ 33 Hostname: power8 33
+ 34 Storage: /var/lib/systemd/coredump/core.mserver5.1004.4ba92a54f72741f8b17802ab88fda45e.90430.1568960085000000.lz4 34
+ 35 Message: Process 90430 (mserver5) of user 1004 dumped core. 35
+ 36 36
+ 37 Stack trace of thread 90460: 37
+ 38 #0 0x00007fff8b4d6ec4 raise (libc.so.6) 38
+ 39 #1 0x00007fff8b4b8428 abort (libc.so.6) 39
+ 40 #2 0x00007fff8b4caff0 __assert_fail_base (libc.so.6) 40
+ 41 #3 0x00007fff8b4cb08c __assert_fail (libc.so.6) 41
+ 42 #4 0x00007fff7cd18b18 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 42
+ 43 #5 0x00007fff7cd18b18 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 43
+ 44 #6 0x00007fff7cd18e0 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 44
+ 45 #7 0x00007fff7cd21c14 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 45
+ 46 #8 0x00007fff7cd1596c n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 46
+ 47 #9 0x00007fff7cd21b20 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 47
+ 48 #10 0x00007fff7cd1596c n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 48
+ 49 #11 0x00007fff7cd24248 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 49
+ 50 #12 0x00007fff7cd407f4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 50
+ 51 #13 0x00007fff7cd42a7c n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 51
+ 52 #14 0x00007fff7cd03cf8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 52
+ 53 #15 0x00007fff8c87e7c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 53
+ 54 #16 0x00007fff8c87f1f8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 54
+ 55 #17 0x00007fff8c87fa38 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 55
+ 56 #18 0x00007fff8c944f8c n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 56
+ 57 #19 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 57
+ 58 #20 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 58
+ 59 #21 0x00007fff8b6ac388 start_thread (libpthread.so.0) 59
+ 60 60
+ 61 Stack trace of thread 90445: 61
+ 62 #0 0x00007fff8b6b9ddc do_futex_wait.constprop.1 (libpthread.so.0) 62
+ 63 #1 0x00007fff8b6b9f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 63
+ 64 #2 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 64
+ 65 #3 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 65
+ 66 #4 0x00007fff8c85aa68 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 66
+ 67 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 67
+ 68 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 68
+ 69 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 69
+ 70 70
+ 71 Stack trace of thread 90441: 71
+ 72 #0 0x00007fff8b6b9ddc do_futex_wait.constprop.1 (libpthread.so.0) 72
+ 73 #1 0x00007fff8b6b9f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 73
+ 74 #2 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 74
+ 75 #3 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 75
+ 76 #4 0x00007fff8c85aa68 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 76
+ 77 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 77
+ 78 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 78
+ 79 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 79
+ 80 80
+ 81 Stack trace of thread 90430: 81
+ 82 #0 0x00007fff8b6bc838 __nanosleep (libpthread.so.0) 82
+ 83 #1 0x00007fff8c654f80 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 83
+ 84 #2 0x00007fff8c654f80 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 84
+ 85 #3 0x00000000100039a0 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/bin/mserver5) 85
+ 86 86
+ 87 Stack trace of thread 90454: 87
+ 88 #0 0x00007fff8b6b9ddc do_futex_wait.constprop.1 (libpthread.so.0) 88
+ 89 #1 0x00007fff8b6b9f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 89
+ 90 #2 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 90
+ 91 #3 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 91
+ 92 #4 0x00007fff8c85aa68 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 92
+ 93 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 93
+ 94 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 94
+ 95 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 95
+ 96 96
+ 97 Stack trace of thread 90432: 97
+ 98 #0 0x00007fff8b6bc838 __nanosleep (libpthread.so.0) 98
+ 99 #1 0x00007fff8c654f80 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 99
+ 100 #2 0x00007fff8c654f80 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 100
+ 101 #3 0x00007fff8c877704 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 101
+ 102 #4 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 102
+ 103 #5 0x00007fff8b6ac388 start_thread (libpthread.so.0) 103
+ 104 104
+ 105 Stack trace of thread 90433: 105
+ 106 #0 0x00007fff8b5af71c __select (libc.so.6) 106
+ 107 #1 0x00007fff8c9423b0 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 107
+ 108 #2 0x00007fff8c9423b0 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 108
+ 109 #3 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 109
+ 110 #4 0x00007fff8b6ac388 start_thread (libpthread.so.0) 110
+ 111 111
+ 112 Stack trace of thread 90461: 112
+ 113 #0 0x00007fff8b6b9ddc do_futex_wait.constprop.1 (libpthread.so.0) 113
+ 114 #1 0x00007fff8b6b9f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 114
+ 115 #2 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 115
+ 116 #3 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 116
+ 117 #4 0x00007fff8c85aa68 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 117
+ 118 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 118
+ 119 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 119
+ 120 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 120
+ 121 121
+ 122 Stack trace of thread 90456: 122
+ 123 #0 0x00007fff8b6bc838 __nanosleep (libpthread.so.0) 123
+ 124 #1 0x00007fff8c654f80 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 124
+ 125 #2 0x00007fff8c654f80 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 125
+ 126 #3 0x00007fff7ce969e8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 126
+ 127 #4 0x00007fff7cdbc4bc n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 127
+ 128 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 128
+ 129 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 129
+ 130 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 130
+ 131 131
+ 132 Stack trace of thread 90463: 132
+ 133 #0 0x00007fff8b6b9ddc do_futex_wait.constprop.1 (libpthread.so.0) 133
+ 134 #1 0x00007fff8b6b9f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 134
+ 135 #2 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 135
+ 136 #3 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 136
+ 137 #4 0x00007fff8c85aa68 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 137
+ 138 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 138
+ 139 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 139
+ 140 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 140
+ 141 141
+ 142 Stack trace of thread 90462: 142
+ 143 #0 0x00007fff8b6b9ddc do_futex_wait.constprop.1 (libpthread.so.0) 143
+ 144 #1 0x00007fff8b6b9f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 144
+ 145 #2 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 145
+ 146 #3 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 146
+ 147 #4 0x00007fff8c85aa68 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 147
+ 148 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 148
+ 149 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 149
+ 150 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 150
+ 151 151
+ 152 Stack trace of thread 90450: 152
+ 153 #0 0x00007fff8b6b9ddc do_futex_wait.constprop.1 (libpthread.so.0) 153
+ 154 #1 0x00007fff8b6b9f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 154
+ 155 #2 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 155
+ 156 #3 0x00007fff8c859da8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 156
+ 157 #4 0x00007fff8c85aa68 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libmonetdb5.so.27.0.3) 157
+ 158 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 158
+ 159 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 159
+ 160 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 160
+ 161 161
+ 162 Stack trace of thread 90455: 162
+ 163 #0 0x00007fff8b6bc838 __nanosleep (libpthread.so.0) 163
+ 164 #1 0x00007fff8c654f80 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 164
+ 165 #2 0x00007fff8c654f80 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 165
+ 166 #3 0x00007fff7ce7e1a8 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 166
+ 167 #4 0x00007fff7cdbc45c n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/monetdb5/lib_sql.so) 167
+ 168 #5 0x00007fff8c5e4610 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 168
+ 169 #6 0x00007fff8c6516c4 n/a (/home/monet/testing/6b3b1396de21-6-1-1/install/lib/libbat.so.18.0.4) 169
+ 170 #7 0x00007fff8b6ac388 start_thread (libpthread.so.0) 170
+ 171 171
+ 172 # 08:14:45 > 172
+ 173 # 08:14:45 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-86706" "--port=33483" 173
+ 174 # 08:14:45 > 174
+ 175 175
+ 176 #~ MAPI = (monetdb) /var/tmp/mtest-86706/.s.monetdb.33483 176
+ 177 QUERY = SELECT col1 IN (SELECT ColID + col1 FROM tbl_ProductSales) FROM another_T GROUP BY col1; 177
+ 178 ERROR = !SELECT: cannot use non GROUP BY column in query results without an aggregate function 178
+ 179 CODE = 42000 179
+ 180 180
+ 181 Signal 13 181
+ 182 182
+ 183 # 08:14:55 > 183
+ 184 # 08:14:55 > "Done." 184
+ 185 # 08:14:55 > 185
23 23 186 186