#2021-09-15 00:34:55: 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-15 00:34:55: client2: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:56: DFLOWworker1013: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:56: DFLOWworker1013: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:56: 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-15 00:34:56: 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-15 00:34:56: 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-15 00:34:56: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 00:34:56: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:56: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in JOIN conditions
#2021-09-15 00:34:56: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!RANK: window function 'rank' not allowed in JOIN conditions
#2021-09-15 00:34:56: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:56: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:56: DFLOWworker1014: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:56: DFLOWworker1014: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:56: 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-15 00:34:56: DFLOWworker999: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:56: DFLOWworker999: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:56: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:56: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: no such unary operator 'first'(int)
#2021-09-15 00:34:56: DFLOWworker1002: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:56: DFLOWworker1002: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:56: 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-15 00:34:56: 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-15 00:34:56: DFLOWworker1018: numFromStr: !ERROR: not a number
#2021-09-15 00:34:56: DFLOWworker1018: convert_str_any: !ERROR: 22018!conversion of string to type bte failed.
#2021-09-15 00:34:56: DFLOWworker1018: createExceptionInternal: !ERROR: MALException:batcalc.bte:22018!conversion of string to type bte failed.
#2021-09-15 00:34:56: 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-15 00:34:56: 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-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'sum' not allowed in GROUP BY clause
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function
#2021-09-15 00:34:56: DFLOWworker1010: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:56: DFLOWworker1010: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:56: DFLOWworker1009: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:56: DFLOWworker1009: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:56: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: the order by column number (2) is not in the number of projections range (1)
#2021-09-15 00:34:57: DFLOWworker982: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker982: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:57: DFLOWworker991: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker991: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: client10: createExceptionInternal: !ERROR: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-15 00:34:57: client10: createExceptionInternal: !ERROR: MALException:reorder:42000!Error in optimizer reorder: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-15 00:34:57: client10: createExceptionInternal: !ERROR: MALException:reorder:42000!Error in optimizer reorder: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-15 00:34:57: DFLOWworker990: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker990: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col2' in query results without an aggregate function
#2021-09-15 00:34:57: DFLOWworker1010: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1010: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: DFLOWworker1005: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1005: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: DFLOWworker1006: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1006: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col8' in query results without an aggregate function
#2021-09-15 00:34:57: DFLOWworker1003: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1003: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:57: DFLOWworker990: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker990: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!PARTITION BY: subqueries not allowed in PARTITION BY clause
#2021-09-15 00:34:57: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: DFLOWworker979: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker979: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.col1' in query results without an aggregate function
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate function 'sum' not allowed in GROUP BY clause
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in JOIN conditions
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'avg' not allowed in GROUP BY clause
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed on an unique value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed in JOIN conditions
#2021-09-15 00:34:57: DFLOWworker1012: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1012: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too many columns
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too many columns
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col0' unknown
#2021-09-15 00:34:57: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: 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-15 00:34:57: DFLOWworker1018: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1018: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:57: DFLOWworker974: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker974: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: DFLOWworker1011: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1011: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: DFLOWworker1008: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1008: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:57: DFLOWworker1018: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1018: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:57: DFLOWworker1016: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1016: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:57: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function
#2021-09-15 00:34:57: DFLOWworker1004: hashjoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker1004: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2021-09-15 00:34:57: DFLOWworker977: hashjoin: !ERROR: more than one match
#2021-09-15 00:34:57: DFLOWworker977: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:58: DFLOWworker1017: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker1006: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1006: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MIN: aggregate functions not allowed in functions in FROM
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: window function 'max' not allowed in functions in FROM
#2021-09-15 00:34:58: client12: 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]);	#[10] (0) MANIFOLDremapMultiplex 28 <- 29 30 26 
#2021-09-15 00:34:58: client12: 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]);	#[12] (0) MANIFOLDremapMultiplex 31 <- 32 33 29 
#2021-09-15 00:34:58: DFLOWworker980: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker980: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker1005: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1005: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker989: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker989: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function
#2021-09-15 00:34:58: DFLOWworker1008: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1008: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker983: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker983: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker1008: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1008: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker974: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:58: DFLOWworker993: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:58: DFLOWworker979: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:58: DFLOWworker1000: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MIN: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses (use subquery)
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!COUNT: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses (use subquery)
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!COUNT: window function 'count' not allowed in WHERE clause
#2021-09-15 00:34:58: DFLOWworker1017: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1017: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: DFLOWworker998: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker998: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed in WHERE clause
#2021-09-15 00:34:58: DFLOWworker991: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker991: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: DFLOWworker1007: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1007: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker974: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker974: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker1002: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1002: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker1000: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1000: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker977: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker977: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!UPDATE: The number of specified columns between the SET clause and the right side don't match (2 != 1)
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!UPDATE: The number of specified columns between the SET clause and the right side don't match (2 != 3)
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!UPDATE: Multiple assignments to same column 'col5'
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!UPDATE: Multiple assignments to same column 'col5'
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: window function 'max' not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses (use subquery)
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MIN: missing group by
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!INSERT INTO: column 'col1' specified more than once
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: missing group by
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed on an unique value
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!COUNT: missing group by
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!COUNT: window function 'count' not allowed in CALL
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: no such window function 'row_number'(any)
#2021-09-15 00:34:58: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: no such window function 'ntile'(any, tinyint)
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "another_t.col2" from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!RETURN: number of columns do not match
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!RETURN: TABLE return not allowed for non table returning functions
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:58: DFLOWworker995: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:58: DFLOWworker1018: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:58: DFLOWworker997: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.col1' in query results without an aggregate function
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.col1' in query results without an aggregate function
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "i1.i" from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "i1.i" from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "another_t.col1" from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col1' ambiguous
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 00:34:58: DFLOWworker1006: hashjoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1006: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 00:34:58: DFLOWworker992: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 00:34:58: DFLOWworker999: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker999: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: DFLOWworker980: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker980: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: DFLOWworker1006: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1006: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: DFLOWworker977: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker977: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "i1.i" from outer query
#2021-09-15 00:34:58: DFLOWworker1000: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1000: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker1005: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1005: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker977: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker977: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MERGE: subqueries not supported inside MERGE conditions
#2021-09-15 00:34:58: DFLOWworker1007: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1007: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker975: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker975: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:58: client14: numFromStr: !ERROR: not a number
#2021-09-15 00:34:58: client14: VARconvert: !ERROR: 22018!conversion of string 'not a number' to type int failed.
#2021-09-15 00:34:58: client14: createExceptionInternal: !ERROR: MALException:calc.int:22018!conversion of string 'not a number' to type int failed.
#2021-09-15 00:34:58: DFLOWworker1005: numFromStr: !ERROR: not a number
#2021-09-15 00:34:58: DFLOWworker1005: VARconvert: !ERROR: 22018!conversion of string 'not a number' to type int failed.
#2021-09-15 00:34:58: DFLOWworker1005: createExceptionInternal: !ERROR: MALException:calc.int:22018!conversion of string 'not a number' to type int failed.
#2021-09-15 00:34:58: DFLOWworker1016: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1016: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: DFLOWworker1012: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1012: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:58: DFLOWworker1016: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:58: DFLOWworker1016: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:58: DFLOWworker1014: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:59: DFLOWworker972: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:59: DFLOWworker972: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:59: DFLOWworker998: createExceptionInternal: !ERROR: MALException:algebra.fetch:Illegal argument: cannot fetch a single row from an empty input
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MIN: aggregate function 'min' not allowed in GROUP BY clause
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 00:34:59: DFLOWworker986: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:59: DFLOWworker986: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:59: DFLOWworker978: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:59: DFLOWworker978: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:59: DFLOWworker1012: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:59: DFLOWworker1012: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:59: DFLOWworker1023: mergejoin: !ERROR: more than one match
#2021-09-15 00:34:59: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 00:34:59: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 00:34:59: DFLOWworker978: BATsubcross: !ERROR: more than one match
#2021-09-15 00:34:59: DFLOWworker978: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 00:34:59: DFLOWworker1012: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 00:34:59: DFLOWworker987: hashjoin: !ERROR: more than one match
#2021-09-15 00:34:59: DFLOWworker987: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2021-09-15 00:34:59: client17: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column