# builtin opt gdk_dbpath = C:/cygwin64/home/monet/testing/8f1c6d410860-8-1-3/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 gdk_dbpath = C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-3\tests\sql\dbfarm\mTests_sql_test_subquery # cmdline opt monet_vault_key = C:\cygwin64\home\monet\testing\8f1c6d410860-8-1-3\tests\sql\dbfarm\mTests_sql_test_subquery\.vaultkey #2025-03-25 22:41:10: client0015: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:10: DFLOWworker0018: BATsubcross: ERROR: more than one match #2025-03-25 22:41:10: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:10: DFLOWworker0028: BATsubcross: ERROR: more than one match #2025-03-25 22:41:10: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:10: DFLOWworker0005: BATsubcross: ERROR: more than one match #2025-03-25 22:41:10: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000! #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in JOIN conditions #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RANK: window function 'rank' not allowed in JOIN conditions #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:10: DFLOWworker0028: BATsubcross: ERROR: more than one match #2025-03-25 22:41:10: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:10: DFLOWworker0027: BATsubcross: ERROR: more than one match #2025-03-25 22:41:10: DFLOWworker0027: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested #2025-03-25 22:41:10: client0034: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: no such operator 'first'(int) #2025-03-25 22:41:10: DFLOWworker0033: BATsubcross: ERROR: more than one match #2025-03-25 22:41:10: DFLOWworker0033: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:10: DFLOWworker0033: createExceptionInternal: ERROR: MALException:algebra.subslice:Illegal argument #2025-03-25 22:41:11: DFLOWworker0018: mergejoin: ERROR: more than one match #2025-03-25 22:41:11: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:11: DFLOWworker0018: numFromStr: ERROR: not a number #2025-03-25 22:41:11: DFLOWworker0018: convert_str_fix: ERROR: 22018!conversion of string to type bte failed. #2025-03-25 22:41:11: DFLOWworker0018: createExceptionInternal: ERROR: MALException:batcalc.bte:22018!conversion of string to type bte failed. #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: ORDER BY only allowed on outermost SELECT #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: ORDER BY only allowed on outermost SELECT #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'sum' not allowed in GROUP BY clause #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:11: DFLOWworker0027: BATsubcross: ERROR: more than one match #2025-03-25 22:41:11: DFLOWworker0027: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:11: DFLOWworker0028: BATsubcross: ERROR: more than one match #2025-03-25 22:41:11: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:11: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: the order by column number (2) is not in the number of projections range (1) #2025-03-25 22:41:11: DFLOWworker0004: BATsubcross: ERROR: more than one match #2025-03-25 22:41:11: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:11: DFLOWworker0037: BATsubcross: ERROR: more than one match #2025-03-25 22:41:11: DFLOWworker0037: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0039: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col2' in query results without an aggregate function #2025-03-25 22:41:12: DFLOWworker0028: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: DFLOWworker0037: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0037: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: DFLOWworker0039: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col8' in query results without an aggregate function #2025-03-25 22:41:12: DFLOWworker0037: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0037: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't2.col1' in query results without an aggregate function #2025-03-25 22:41:12: DFLOWworker0018: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!PARTITION BY: subqueries not allowed in PARTITION BY clause #2025-03-25 22:41:12: DFLOWworker0028: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: DFLOWworker0028: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.col1' in query results without an aggregate function #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate function 'sum' not allowed in GROUP BY clause #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'another_t.col5' in query results without an aggregate function #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in JOIN conditions #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'avg' not allowed in GROUP BY clause #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed on an unique value #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed in JOIN conditions #2025-03-25 22:41:12: DFLOWworker0037: selectjoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0037: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too many columns #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too many columns #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col0' unknown #2025-03-25 22:41:12: DFLOWworker0004: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: DFLOWworker0040: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0040: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0004: selectjoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-25 22:41:12: DFLOWworker0044: selectjoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0044: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-25 22:41:12: DFLOWworker0004: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0018: selectjoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-25 22:41:12: DFLOWworker0044: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0044: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: client0042: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:12: DFLOWworker0028: hashjoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match #2025-03-25 22:41:12: DFLOWworker0028: hashjoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:12: DFLOWworker0039: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0044: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0044: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate functions not allowed in functions in FROM #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: window function 'max' not allowed in functions in FROM #2025-03-25 22:41:12: DFLOWworker0039: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0039: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0018: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!subquery must return only one column #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:12: DFLOWworker0039: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0018: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0004: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0028: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:12: DFLOWworker0018: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:12: DFLOWworker0018: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:12: DFLOWworker0044: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses (use subquery) #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'another_t.col5' in query results without an aggregate function #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: aggregate functions not allowed in WHERE clause #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'another_t.col7' in query results without an aggregate function #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses (use subquery) #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: window function 'count' not allowed in WHERE clause #2025-03-25 22:41:12: DFLOWworker0004: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: DFLOWworker0039: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed in WHERE clause #2025-03-25 22:41:12: DFLOWworker0044: mergejoin: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0044: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:12: DFLOWworker0004: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0039: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0039: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0028: BATsubcross: ERROR: more than one match #2025-03-25 22:41:12: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:12: DFLOWworker0039: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: The number of specified columns between the SET clause and the right side don't match (2 != 1) #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: The number of specified columns between the SET clause and the right side don't match (2 != 3) #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Multiple assignments to same column 'col5' #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Multiple assignments to same column 'col5' #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: window function 'max' not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses (use subquery) #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: missing group by #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT INTO: column 'col1' specified more than once #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: missing group by #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed on an unique value #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: missing group by #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: window function 'count' not allowed in CALL #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: no such window function 'row_number'(any) #2025-03-25 22:41:12: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: no such window function 'ntile'(any, tinyint) #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'another_t.col2' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RETURN: number of columns do not match #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RETURN: TABLE return not allowed for non table returning functions #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:13: DFLOWworker0039: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.col1' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.col1' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "i1.i" from outer query #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'another_t.col1' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col1' ambiguous #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-25 22:41:13: DFLOWworker0039: hashjoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: ERROR: table name 'integers' specified more than once #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'another_t.col1' in query results without an aggregate function #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested #2025-03-25 22:41:13: DFLOWworker0044: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0044: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query #2025-03-25 22:41:13: DFLOWworker0044: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0044: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: DFLOWworker0028: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: DFLOWworker0028: selectjoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-25 22:41:13: DFLOWworker0018: selectjoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-25 22:41:13: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i1.i' in query results without an aggregate function #2025-03-25 22:41:13: DFLOWworker0044: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0044: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: DFLOWworker0018: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: DFLOWworker0004: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE: subqueries not supported inside MERGE conditions #2025-03-25 22:41:13: DFLOWworker0004: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: DFLOWworker0018: mergejoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'another_t.col4' in query results without an aggregate function #2025-03-25 22:41:13: client0047: numFromStr: ERROR: not a number #2025-03-25 22:41:13: client0047: VARconvert: ERROR: 22018!conversion of string 'not a number' to type int failed. #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'not a number' to type int failed. #2025-03-25 22:41:13: DFLOWworker0004: numFromStr: ERROR: not a number #2025-03-25 22:41:13: DFLOWworker0004: VARconvert: ERROR: 22018!conversion of string 'not a number' to type int failed. #2025-03-25 22:41:13: DFLOWworker0004: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'not a number' to type int failed. #2025-03-25 22:41:13: DFLOWworker0028: mergejoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:13: DFLOWworker0028: mergejoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:13: DFLOWworker0004: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: DFLOWworker0039: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:13: DFLOWworker0039: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:13: DFLOWworker0039: createExceptionInternal: ERROR: MALException:algebra.fetch:Illegal argument: cannot fetch a single row from an empty input #2025-03-25 22:41:13: DFLOWworker0039: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'tbl_productsales.colid' in query results without an aggregate function #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'tbl_productsales.colid' in query results without an aggregate function #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'tbl_productsales.colid' in query results without an aggregate function #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate function 'min' not allowed in GROUP BY clause #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'integers.i' in query results without an aggregate function #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i2.i' in query results without an aggregate function #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i2.i' in query results without an aggregate function #2025-03-25 22:41:13: DFLOWworker0028: mergejoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:13: DFLOWworker0004: mergejoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:13: DFLOWworker0004: mergejoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:13: DFLOWworker0018: mergejoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match #2025-03-25 22:41:13: client0047: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query #2025-03-25 22:41:13: DFLOWworker0018: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: DFLOWworker0028: BATsubcross: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0028: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-25 22:41:13: DFLOWworker0018: hashjoin: ERROR: more than one match #2025-03-25 22:41:13: DFLOWworker0018: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match #2025-03-25 22:41:14: client0052: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column