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