#2021-09-15 02:13:44: 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 02:13:44: client2: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:45: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:45: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:45: 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 02:13:45: 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 02:13:45: 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 02:13:45: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 02:13:45: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:46: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in JOIN conditions
#2021-09-15 02:13:46: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!RANK: window function 'rank' not allowed in JOIN conditions
#2021-09-15 02:13:46: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:46: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:46: DFLOWworker1023: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:46: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:46: 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 02:13:46: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:46: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:46: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:46: client7: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: no such unary operator 'first'(int)
#2021-09-15 02:13:46: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:46: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.intersect:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:46: 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 02:13:46: 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 02:13:47: DFLOWworker1023: numFromStr: !ERROR: not a number
#2021-09-15 02:13:47: DFLOWworker1023: convert_str_any: !ERROR: 22018!conversion of string to type bte failed.
#2021-09-15 02:13:47: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:batcalc.bte:22018!conversion of string to type bte failed.
#2021-09-15 02:13:47: 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 02:13:47: 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 02:13:47: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:47: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:47: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:47: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-15 02:13:47: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:47: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'sum' not allowed in GROUP BY clause
#2021-09-15 02:13:47: 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 02:13:47: DFLOWworker1020: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:47: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:47: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:47: DFLOWworker1023: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:47: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:47: client9: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:47: 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 02:13:48: DFLOWworker1023: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:48: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:48: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:48: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:48: client10: createExceptionInternal: !ERROR: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-15 02:13:48: client10: createExceptionInternal: !ERROR: MALException:reorder:42000!Error in optimizer reorder: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-15 02:13:48: client10: createExceptionInternal: !ERROR: MALException:reorder:42000!Error in optimizer reorder: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
#2021-09-15 02:13:49: DFLOWworker1022: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1022: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col2' in query results without an aggregate function
#2021-09-15 02:13:49: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: DFLOWworker1023: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col8' in query results without an aggregate function
#2021-09-15 02:13:49: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:49: DFLOWworker1023: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!PARTITION BY: subqueries not allowed in PARTITION BY clause
#2021-09-15 02:13:49: DFLOWworker1022: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1022: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: 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 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate function 'sum' not allowed in GROUP BY clause
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in JOIN conditions
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'avg' not allowed in GROUP BY clause
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed on an unique value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed in JOIN conditions
#2021-09-15 02:13:49: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too many columns
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too many columns
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2021-09-15 02:13:49: client11: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col0' unknown
#2021-09-15 02:13:49: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:49: DFLOWworker1021: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: DFLOWworker1022: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1022: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:49: DFLOWworker1022: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1022: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:49: DFLOWworker1023: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:49: 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 02:13:49: DFLOWworker1023: hashjoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2021-09-15 02:13:49: DFLOWworker1021: hashjoin: !ERROR: more than one match
#2021-09-15 02:13:49: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:50: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MIN: aggregate functions not allowed in functions in FROM
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MAX: window function 'max' not allowed in functions in FROM
#2021-09-15 02:13:50: DFLOWworker1022: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1022: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1023: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:50: 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 02:13:50: DFLOWworker1023: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1019: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1019: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1019: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:50: DFLOWworker1023: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:50: DFLOWworker1020: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:50: DFLOWworker1022: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:50: 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 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!COUNT: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2021-09-15 02:13:50: 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 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!COUNT: window function 'count' not allowed in WHERE clause
#2021-09-15 02:13:50: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed in WHERE clause
#2021-09-15 02:13:50: DFLOWworker1020: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:50: DFLOWworker1020: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1023: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:50: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:50: 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 02:13:50: 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 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!UPDATE: Multiple assignments to same column 'col5'
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!UPDATE: Multiple assignments to same column 'col5'
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses
#2021-09-15 02:13:50: 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 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MIN: missing group by
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!INSERT INTO: column 'col1' specified more than once
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: missing group by
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed on an unique value
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!COUNT: missing group by
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!COUNT: window function 'count' not allowed in CALL
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: no such window function 'row_number'(any)
#2021-09-15 02:13:50: client12: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: no such window function 'ntile'(any, tinyint)
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "another_t.col2" from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!RETURN: number of columns do not match
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!RETURN: TABLE return not allowed for non table returning functions
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:51: DFLOWworker1023: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:51: DFLOWworker1019: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:51: DFLOWworker1022: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function
#2021-09-15 02:13:51: 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 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function
#2021-09-15 02:13:51: 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 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "i1.i" from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "i1.i" from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "another_t.col1" from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col1' ambiguous
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2021-09-15 02:13:51: DFLOWworker1019: hashjoin: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2021-09-15 02:13:51: DFLOWworker1022: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 02:13:51: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:51: DFLOWworker1022: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1022: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:51: DFLOWworker1021: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:51: DFLOWworker1021: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:51: client13: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "i1.i" from outer query
#2021-09-15 02:13:51: DFLOWworker1019: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:51: DFLOWworker1020: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:51: DFLOWworker1020: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1020: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:51: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MERGE: subqueries not supported inside MERGE conditions
#2021-09-15 02:13:51: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:51: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:52: client14: numFromStr: !ERROR: not a number
#2021-09-15 02:13:52: client14: VARconvert: !ERROR: 22018!conversion of string 'not a number' to type int failed.
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: MALException:calc.int:22018!conversion of string 'not a number' to type int failed.
#2021-09-15 02:13:52: DFLOWworker1019: numFromStr: !ERROR: not a number
#2021-09-15 02:13:52: DFLOWworker1019: VARconvert: !ERROR: 22018!conversion of string 'not a number' to type int failed.
#2021-09-15 02:13:52: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:calc.int:22018!conversion of string 'not a number' to type int failed.
#2021-09-15 02:13:52: DFLOWworker1023: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:52: DFLOWworker1023: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:52: DFLOWworker1021: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:52: DFLOWworker1021: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.fetch:Illegal argument: cannot fetch a single row from an empty input
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!MIN: aggregate function 'min' not allowed in GROUP BY clause
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column in query results without an aggregate function
#2021-09-15 02:13:52: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:52: DFLOWworker1023: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:52: DFLOWworker1023: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1023: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: mergejoin: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2021-09-15 02:13:52: client14: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2021-09-15 02:13:52: DFLOWworker1019: BATsubcross: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: createExceptionInternal: !ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2021-09-15 02:13:52: DFLOWworker1019: createExceptionInternal: !ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2021-09-15 02:13:52: DFLOWworker1021: hashjoin: !ERROR: more than one match
#2021-09-15 02:13:52: DFLOWworker1021: createExceptionInternal: !ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2021-09-15 02:13:53: client17: createExceptionInternal: !ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column