# builtin opt 	gdk_dbpath = /export/scratch1/home/monet/testing/ce904debefe6-4-1-2/install/var/monetdb5/dbfarm/demo
# builtin opt 	mapi_port = 50000
# builtin opt 	sql_optimizer = default_pipe
# builtin opt 	sql_debug = 0
# builtin opt 	raw_strings = false
# cmdline opt 	gdk_nr_threads = 0
# cmdline opt 	mapi_listenaddr = all
# cmdline opt 	mapi_port = 0
# cmdline opt 	mapi_usock = /tmp/mtest-1099388/.s.monetdb.${PORT}
# cmdline opt 	gdk_dbpath = /export/scratch1/home/monet/testing/ce904debefe6-4-1-2/tests/sql/dbfarm/mTests_sql_test_subquery
# cmdline opt 	gdk_vm_maxsize = 8589934592
#2021-09-14 22:14:29: client2: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected LIMIT, expecting UNION or EXCEPT or INTERSECT or ')' in: "select i, i >= any(select i1.i from integers i1, integers i2, integers i3, integ"
#2021-09-14 22:14:29: client2: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-14 22:14:30: DFLOWworker1022: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1022: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected LIMIT, expecting UNION or EXCEPT or INTERSECT or ')' in: "select i, (select 42+i1.i from integers limit"
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected LIMIT, expecting UNION or EXCEPT or INTERSECT or ')' in: "select i, (select 42+i1.i from integers limit"
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected LIMIT, expecting UNION or EXCEPT or INTERSECT or ')' in: "select i, (select i+i1.i from integers limit"
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in JOIN conditions
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!RANK: window function 'rank' not allowed in JOIN conditions
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-14 22:14:30: DFLOWworker1017: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected LIMIT, expecting UNION or EXCEPT or INTERSECT or ')' in: "select cast((select i+sum(i1.i) from integers where i=1 limit"
#2021-09-14 22:14:30: DFLOWworker1017: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: no such unary operator 'first'(int)
#2021-09-14 22:14:30: DFLOWworker1016: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1016: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected LIMIT, expecting UNION or EXCEPT or INTERSECT or ')' in: "select i, sum((select sum(i)*i1.i from integers limit"
#2021-09-14 22:14:30: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected LIMIT, expecting UNION or EXCEPT or INTERSECT or ')' in: "select i, (select sum(s1.i) over (order by s1.i) from integers s1, integers s2 w"
#2021-09-14 22:14:30: DFLOWworker1018: numFromStr: !ERROR: not a number
#2021-09-14 22:14:30: DFLOWworker1018: convert_str_any: !ERROR: 22018!conversion of string to type bte failed.
#2021-09-14 22:14:30: DFLOWworker1018: createExceptionInternal: !ERROR: MALException:batcalc.bte:22018!conversion of string to type bte failed.
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected ORDER, expecting UNION or EXCEPT or INTERSECT or ')' in: "select * from integers where i=(select i from integers where i is not null order"
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!syntax error, unexpected ORDER, expecting UNION or EXCEPT or INTERSECT or ')' in: "select * from integers where i=(select i from integers where i is not null order"
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'sum' not allowed in GROUP BY clause
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function
#2021-09-14 22:14:30: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-14 22:14:30: DFLOWworker1016: BATsubcross: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1016: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-14 22:14:30: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: the order by column number (2) is not in the number of projections range (1)
#2021-09-14 22:14:30: DFLOWworker1017: BATsubcross: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-14 22:14:30: DFLOWworker1021: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client10: createExceptionInternal: !ERROR: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-14 22:14:30: client10: createExceptionInternal: !ERROR: MALException:reorder:42000!Error in optimizer reorder: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-14 22:14:30: client10: createExceptionInternal: !ERROR: MALException:reorder:42000!Error in optimizer reorder: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-14 22:14:30: DFLOWworker1017: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col2' in query results without an aggregate function
#2021-09-14 22:14:30: DFLOWworker1018: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1018: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: DFLOWworker1015: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1015: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: DFLOWworker1023: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col8' in query results without an aggregate function
#2021-09-14 22:14:30: DFLOWworker1015: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1015: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-14 22:14:30: DFLOWworker1017: BATsubcross: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!PARTITION BY: subqueries not allowed in PARTITION BY clause
#2021-09-14 22:14:30: DFLOWworker1017: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: DFLOWworker1016: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1016: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.col1' in query results without an aggregate function
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate function 'sum' not allowed in GROUP BY clause
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in JOIN conditions
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'avg' not allowed in GROUP BY clause
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed on an unique value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed in JOIN conditions
#2021-09-14 22:14:30: DFLOWworker1016: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1016: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too many columns
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too many columns
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-14 22:14:30: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col0' unknown
#2021-09-14 22:14:30: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-14 22:14:30: client11: OPTexpandMultiplex: !WARNING: To speedup sql.evilfunction a bulk operator implementation is needed for     X_0:bat[:int] := batmal.multiplex("sql":str, "evilfunction":str, X_1:bat[:int]);	#[9] (0) MANIFOLDremapMultiplex 18 <- 19 20 17 
#2021-09-14 22:14:30: DFLOWworker1022: BATsubcross: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1022: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-14 22:14:30: DFLOWworker1017: mergejoin: !ERROR: more than one match
#2021-09-14 22:14:30: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one mat