Test subquery2.sql (id 6b3b1396de21) (out)
subquery2.stable.err.FILTERED 2019-09-20 09:23:13.071183167 +0200subquery2.test.err.FILTERED 2019-09-20 09:23:13.091184085 +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, 10926 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 67 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 161 lines, 635 words, 10926 chars in lines not matching '^$|^(\| |)#` 3
4 # 18 lines, 63 words, 653 chars in all lines 4 ! 4 # 181 lines, 707 words, 11658 chars in all lines 4
5 5 5 5
..................
# 18 lines, 63 words,
8 8 8 8
9 # 18:55:45 > 9 ! 9 # 09:23:02 > 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 # 09:23:02 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=8" "--set" "mapi_open=true" "--set" "mapi_port=33802" "--set" "mapi_usock=/var/tmp/mtest-2078/.s.monetdb.33802" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_subquery" "--set" "embedded_c=true" 10
11 # 18:55:45 > 11 ! 11 # 09:23:02 > 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-2/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: 1420 (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 09:23:02 CEST (11s ago) 23
+ 24 Command Line: mserver5 --debug=10 --set gdk_nr_threads 8 --set mapi_open true --set mapi_port 33802 --set mapi_usock /var/tmp/mtest-2078/.s.monetdb.33802 --forcemito --set gdk_vm_maxsize 8589934592 --dbpath=/home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_subquery --set embedded_c true 24
+ 25 Executable: /home/monet/testing/6b3b1396de21-6-1-2/install/bin/mserver5 25
+ 26 Control Group: /user.slice/user-1004.slice/session-18057.scope 26
+ 27 Unit: session-18057.scope 27
+ 28 Slice: user-1004.slice 28
+ 29 Session: 18057 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.1420.1568964182000000.lz4 34
+ 35 Message: Process 1420 (mserver5) of user 1004 dumped core. 35
+ 36 36
+ 37 Stack trace of thread 1450: 37
+ 38 #0 0x00007fffb0636ec4 raise (libc.so.6) 38
+ 39 #1 0x00007fffb0618428 abort (libc.so.6) 39
+ 40 #2 0x00007fffb062aff0 __assert_fail_base (libc.so.6) 40
+ 41 #3 0x00007fffb062b08c __assert_fail (libc.so.6) 41
+ 42 #4 0x00007fffa1e953b8 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 42
+ 43 #5 0x00007fffa1e953b8 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 43
+ 44 #6 0x00007fffa1e956a0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 44
+ 45 #7 0x00007fffa1e9e4b4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 45
+ 46 #8 0x00007fffa1e9220c n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 46
+ 47 #9 0x00007fffa1e9e3c0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 47
+ 48 #10 0x00007fffa1e9220c n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 48
+ 49 #11 0x00007fffa1ea0ae8 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 49
+ 50 #12 0x00007fffa1ebcb94 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 50
+ 51 #13 0x00007fffa1ebee1c n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 51
+ 52 #14 0x00007fffa1e80c78 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 52
+ 53 #15 0x00007fffb18edc84 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 53
+ 54 #16 0x00007fffb18ee668 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 54
+ 55 #17 0x00007fffb18eeea8 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 55
+ 56 #18 0x00007fffb19b37bc n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 56
+ 57 #19 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 57
+ 58 #20 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 58
+ 59 #21 0x00007fffb080c388 start_thread (libpthread.so.0) 59
+ 60 60
+ 61 Stack trace of thread 1423: 61
+ 62 #0 0x00007fffb070f71c __select (libc.so.6) 62
+ 63 #1 0x00007fffb19b0c70 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 63
+ 64 #2 0x00007fffb19b0c70 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 64
+ 65 #3 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 65
+ 66 #4 0x00007fffb080c388 start_thread (libpthread.so.0) 66
+ 67 67
+ 68 Stack trace of thread 1436: 68
+ 69 #0 0x00007fffb0819ddc do_futex_wait.constprop.1 (libpthread.so.0) 69
+ 70 #1 0x00007fffb0819f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 70
+ 71 #2 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 71
+ 72 #3 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 72
+ 73 #4 0x00007fffb18ca028 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 73
+ 74 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 74
+ 75 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 75
+ 76 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 76
+ 77 77
+ 78 Stack trace of thread 1431: 78
+ 79 #0 0x00007fffb0819ddc do_futex_wait.constprop.1 (libpthread.so.0) 79
+ 80 #1 0x00007fffb0819f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 80
+ 81 #2 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 81
+ 82 #3 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 82
+ 83 #4 0x00007fffb18ca028 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 83
+ 84 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 84
+ 85 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 85
+ 86 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 86
+ 87 87
+ 88 Stack trace of thread 1440: 88
+ 89 #0 0x00007fffb0819ddc do_futex_wait.constprop.1 (libpthread.so.0) 89
+ 90 #1 0x00007fffb0819f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 90
+ 91 #2 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 91
+ 92 #3 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 92
+ 93 #4 0x00007fffb18ca028 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 93
+ 94 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 94
+ 95 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 95
+ 96 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 96
+ 97 97
+ 98 Stack trace of thread 1434: 98
+ 99 #0 0x00007fffb0819ddc do_futex_wait.constprop.1 (libpthread.so.0) 99
+ 100 #1 0x00007fffb0819f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 100
+ 101 #2 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 101
+ 102 #3 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 102
+ 103 #4 0x00007fffb18ca028 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 103
+ 104 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 104
+ 105 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 105
+ 106 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 106
+ 107 107
+ 108 Stack trace of thread 1420: 108
+ 109 #0 0x00007fffb081c838 __nanosleep (libpthread.so.0) 109
+ 110 #1 0x00007fffb16f08e0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 110
+ 111 #2 0x00007fffb16f08e0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 111
+ 112 #3 0x00000000100039a0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/bin/mserver5) 112
+ 113 113
+ 114 Stack trace of thread 1446: 114
+ 115 #0 0x00007fffb081c838 __nanosleep (libpthread.so.0) 115
+ 116 #1 0x00007fffb16f08e0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 116
+ 117 #2 0x00007fffb16f08e0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 117
+ 118 #3 0x00007fffa1ffaec8 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 118
+ 119 #4 0x00007fffa1f211bc n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 119
+ 120 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 120
+ 121 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 121
+ 122 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 122
+ 123 123
+ 124 Stack trace of thread 1443: 124
+ 125 #0 0x00007fffb0819ddc do_futex_wait.constprop.1 (libpthread.so.0) 125
+ 126 #1 0x00007fffb0819f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 126
+ 127 #2 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 127
+ 128 #3 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 128
+ 129 #4 0x00007fffb18ca028 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 129
+ 130 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 130
+ 131 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 131
+ 132 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 132
+ 133 133
+ 134 Stack trace of thread 1422: 134
+ 135 #0 0x00007fffb081c838 __nanosleep (libpthread.so.0) 135
+ 136 #1 0x00007fffb16f08e0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 136
+ 137 #2 0x00007fffb16f08e0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 137
+ 138 #3 0x00007fffb18e6bc4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 138
+ 139 #4 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 139
+ 140 #5 0x00007fffb080c388 start_thread (libpthread.so.0) 140
+ 141 141
+ 142 Stack trace of thread 1445: 142
+ 143 #0 0x00007fffb081c838 __nanosleep (libpthread.so.0) 143
+ 144 #1 0x00007fffb16f08e0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 144
+ 145 #2 0x00007fffb16f08e0 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 145
+ 146 #3 0x00007fffa1fe26a8 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 146
+ 147 #4 0x00007fffa1f2115c n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/monetdb5/lib_sql.so) 147
+ 148 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 148
+ 149 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 149
+ 150 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 150
+ 151 151
+ 152 Stack trace of thread 1453: 152
+ 153 #0 0x00007fffb0819ddc do_futex_wait.constprop.1 (libpthread.so.0) 153
+ 154 #1 0x00007fffb0819f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 154
+ 155 #2 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 155
+ 156 #3 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 156
+ 157 #4 0x00007fffb18ca028 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 157
+ 158 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 158
+ 159 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 159
+ 160 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 160
+ 161 161
+ 162 Stack trace of thread 1452: 162
+ 163 #0 0x00007fffb0819ddc do_futex_wait.constprop.1 (libpthread.so.0) 163
+ 164 #1 0x00007fffb0819f98 __new_sem_wait_slow.constprop.0 (libpthread.so.0) 164
+ 165 #2 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 165
+ 166 #3 0x00007fffb18c9368 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 166
+ 167 #4 0x00007fffb18ca028 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libmonetdb5.so.27.0.3) 167
+ 168 #5 0x00007fffb1688690 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 168
+ 169 #6 0x00007fffb16ed0e4 n/a (/home/monet/testing/6b3b1396de21-6-1-2/install/lib/libbat.so.18.0.4) 169
+ 170 #7 0x00007fffb080c388 start_thread (libpthread.so.0) 170
+ 171 171
+ 172 # 09:23:02 > 172
+ 173 # 09:23:02 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-2078" "--port=33802" 173
+ 174 # 09:23:02 > 174
+ 175 175
+ 176 #~ MAPI = (monetdb) /var/tmp/mtest-2078/.s.monetdb.33802 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 # 09:23:13 > 183
+ 184 # 09:23:13 > "Done." 184
+ 185 # 09:23:13 > 185
23 23 186 186