# builtin opt 	gdk_dbpath = /export/scratch1/home/monet/testing/6adb908b3bc7-4-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 	mapi_usock = /tmp/mtest-1172480/.s.monetdb.${PORT}
# cmdline opt 	gdk_dbpath = /export/scratch1/home/monet/testing/6adb908b3bc7-4-1-1/tests/sql/dbfarm/mTests_sql_test_subquery
# cmdline opt 	gdk_vm_maxsize = 8589934592
# cmdline opt 	monet_vault_key = /export/scratch1/home/monet/testing/6adb908b3bc7-4-1-1/tests/sql/dbfarm/mTests_sql_test_subquery/.vaultkey
#2025-03-24 21:25:25: client0019: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:25: DFLOWworker0011: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: DFLOWworker0006: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0006: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: DFLOWworker0011: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: client0024: createExceptionInternal: ERROR: ParseException:SQLparser:42000!
#2025-03-24 21:25:25: client0024: 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:25:25: client0024: 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:25:25: client0024: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in JOIN conditions
#2025-03-24 21:25:25: client0024: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RANK: window function 'rank' not allowed in JOIN conditions
#2025-03-24 21:25:25: client0024: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2025-03-24 21:25:25: client0024: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:25: DFLOWworker0004: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: DFLOWworker0011: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: client0024: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2025-03-24 21:25:25: client0024: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: no such operator 'first'(int)
#2025-03-24 21:25:25: DFLOWworker0008: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0008: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: DFLOWworker0007: createExceptionInternal: ERROR: MALException:algebra.subslice:Illegal argument
#2025-03-24 21:25:25: DFLOWworker0009: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0009: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0006: numFromStr: ERROR: not a number
#2025-03-24 21:25:25: DFLOWworker0006: convert_str_fix: ERROR: 22018!conversion of string to type bte failed.
#2025-03-24 21:25:25: DFLOWworker0006: createExceptionInternal: ERROR: MALException:batcalc.bte:22018!conversion of string to type bte failed.
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: ORDER BY only allowed on outermost SELECT
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: ORDER BY only allowed on outermost SELECT
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'sum' not allowed in GROUP BY clause
#2025-03-24 21:25:25: client0026: 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:25:25: DFLOWworker0004: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:25: DFLOWworker0003: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0003: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: client0026: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:25: client0026: 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:25:25: DFLOWworker0006: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0006: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: DFLOWworker0004: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: DFLOWworker0008: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0008: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col2' in query results without an aggregate function
#2025-03-24 21:25:25: DFLOWworker0008: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0008: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0008: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0008: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0009: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0009: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col8' in query results without an aggregate function
#2025-03-24 21:25:25: DFLOWworker0005: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: client0028: 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:25:25: DFLOWworker0003: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0003: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!PARTITION BY: subqueries not allowed in PARTITION BY clause
#2025-03-24 21:25:25: DFLOWworker0003: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0003: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0003: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0003: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: client0028: 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:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate function 'sum' not allowed in GROUP BY clause
#2025-03-24 21:25:25: client0028: 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:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in JOIN conditions
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function 'avg' not allowed in GROUP BY clause
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed on an unique value
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed in JOIN conditions
#2025-03-24 21:25:25: DFLOWworker0005: selectjoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot match a tuple to a single value
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too many columns
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too many columns
#2025-03-24 21:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2025-03-24 21:25:25: client0028: 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:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'i' in query results without an aggregate function
#2025-03-24 21:25:25: client0028: 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:25:25: client0028: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col0' unknown
#2025-03-24 21:25:25: DFLOWworker0005: mergejoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: DFLOWworker0003: selectjoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0003: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: selectjoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: selectjoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0007: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0007: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:25: client0028: 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:25:25: DFLOWworker0008: hashjoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0008: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2025-03-24 21:25:25: DFLOWworker0004: hashjoin: ERROR: more than one match
#2025-03-24 21:25:25: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:26: DFLOWworker0007: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0007: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate functions not allowed in functions in FROM
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: window function 'max' not allowed in functions in FROM
#2025-03-24 21:25:26: DFLOWworker0011: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0004: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!subquery must return only one column
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause
#2025-03-24 21:25:26: client0029: 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:25:26: DFLOWworker0010: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0010: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0003: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0003: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: DFLOWworker0005: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: DFLOWworker0010: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: DFLOWworker0006: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: client0029: 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:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions not allowed in WHERE clause
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses
#2025-03-24 21:25:26: client0029: 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:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: aggregate functions not allowed in WHERE clause
#2025-03-24 21:25:26: client0029: 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:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: aggregate functions not allowed in WHERE clause
#2025-03-24 21:25:26: client0029: 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:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: window function 'count' not allowed in WHERE clause
#2025-03-24 21:25:26: DFLOWworker0004: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed in WHERE clause
#2025-03-24 21:25:26: DFLOWworker0006: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0006: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: DFLOWworker0004: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0010: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0010: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0010: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0010: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: DFLOWworker0011: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: client0029: 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:25:26: client0029: 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:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Multiple assignments to same column 'col5'
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Multiple assignments to same column 'col5'
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE clauses
#2025-03-24 21:25:26: client0029: 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:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: missing group by
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT INTO: column 'col1' specified more than once
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: missing group by
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!AVG: window function 'avg' not allowed on an unique value
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: missing group by
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: window function 'count' not allowed in CALL
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CALL: subqueries not supported inside CALL statements
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: no such window function 'row_number'(any)
#2025-03-24 21:25:26: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: no such window function 'ntile'(any, tinyint)
#2025-03-24 21:25:26: client0030: 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:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RETURN: number of columns do not match
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RETURN: TABLE return not allowed for non table returning functions
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: DFLOWworker0011: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function
#2025-03-24 21:25:26: client0030: 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:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'col1' in query results without an aggregate function
#2025-03-24 21:25:26: client0030: 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:25:26: 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:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "i1.i" from outer query
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:26: client0030: 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:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'col1' ambiguous
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column "t1.col5" from outer query
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SUM: aggregate functions cannot be nested
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column
#2025-03-24 21:25:26: DFLOWworker0004: hashjoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "integers" specified more than once
#2025-03-24 21:25:26: 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:25:26: 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:25:26: client0030: 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:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate function calls cannot be nested
#2025-03-24 21:25:26: DFLOWworker0006: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0006: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2025-03-24 21:25:26: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2025-03-24 21:25:26: DFLOWworker0003: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0003: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0010: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0010: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: selectjoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match
#2025-03-24 21:25:26: DFLOWworker0009: selectjoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0009: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match
#2025-03-24 21:25:26: 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:25:26: DFLOWworker0009: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0009: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0007: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0007: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0007: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0007: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: client0031: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE: subqueries not supported inside MERGE conditions
#2025-03-24 21:25:26: DFLOWworker0009: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0009: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0007: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0007: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: client0031: 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:25:26: client0031: numFromStr: ERROR: not a number
#2025-03-24 21:25:26: client0031: VARconvert: ERROR: 22018!conversion of string 'not a number' to type int failed.
#2025-03-24 21:25:26: client0031: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'not a number' to type int failed.
#2025-03-24 21:25:26: DFLOWworker0007: numFromStr: ERROR: not a number
#2025-03-24 21:25:26: DFLOWworker0007: VARconvert: ERROR: 22018!conversion of string 'not a number' to type int failed.
#2025-03-24 21:25:26: DFLOWworker0007: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'not a number' to type int failed.
#2025-03-24 21:25:26: DFLOWworker0004: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0004: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: DFLOWworker0006: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0006: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: DFLOWworker0006: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0006: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0009: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: client0031: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: DFLOWworker0005: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: DFLOWworker0006: createExceptionInternal: ERROR: MALException:algebra.fetch:Illegal argument: cannot fetch a single row from an empty input
#2025-03-24 21:25:26: DFLOWworker0004: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2025-03-24 21:25:26: client0031: 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:25:26: client0031: 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:25:26: client0031: 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:25:26: client0031: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Tuple matching at projections not implemented in the backend yet
#2025-03-24 21:25:26: client0031: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate function 'min' not allowed in GROUP BY clause
#2025-03-24 21:25:26: client0031: 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:25:26: client0031: 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:25:26: client0031: 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:25:26: DFLOWworker0009: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0009: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: DFLOWworker0003: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0003: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: DFLOWworker0008: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0008: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: mergejoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0005: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: mergejoin: more than one match
#2025-03-24 21:25:26: client0031: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery uses ungrouped column from outer query
#2025-03-24 21:25:26: DFLOWworker0011: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0008: BATsubcross: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0008: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: hashjoin: ERROR: more than one match
#2025-03-24 21:25:26: DFLOWworker0011: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match
#2025-03-24 21:25:26: client0036: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column