# builtin opt gdk_dbpath = /export/scratch1/home/monet/testing/6adb908b3bc7-4-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 = 1 # cmdline opt mapi_listenaddr = all # cmdline opt mapi_port = 0 # cmdline opt mapi_usock = /tmp/mtest-1292738/.s.monetdb.${PORT} # cmdline opt gdk_dbpath = /export/scratch1/home/monet/testing/6adb908b3bc7-4-1-3/tests/sql/dbfarm/mTests_sql_test_SQLancer # cmdline opt gdk_vm_maxsize = 8589934592 # cmdline opt monet_vault_key = /export/scratch1/home/monet/testing/6adb908b3bc7-4-1-3/tests/sql/dbfarm/mTests_sql_test_SQLancer/.vaultkey #2025-03-24 22:03:36: client0010: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected sqlNULL, expecting DISTINCT or NOT in: "alter table t0 alter c0 set default (0.1) is null" #2025-03-24 22:03:36: client0010: convert_str_fix: ERROR: 22018!conversion of string to type int failed. #2025-03-24 22:03:36: client0010: createExceptionInternal: ERROR: MALException:batcalc.int:22018!conversion of string to type int failed. #2025-03-24 22:03:36: client0010: mul_int_int_int: ERROR: 22003!overflow in calculation 816153822*-212060493. #2025-03-24 22:03:36: client0010: mul_int_int_int: ERROR: 22003!overflow in calculation 816153822*-212060493. #2025-03-24 22:03:36: client0010: add_int_int_int: ERROR: 22003!overflow in calculation 2000022046+1143103273. #2025-03-24 22:03:36: client0010: add_int_int_int: ERROR: 22003!overflow in calculation 2000022046+1143103273. #2025-03-24 22:03:36: client0010: add_int_int_int: ERROR: 22003!overflow in calculation 2000022046+1143103273. #2025-03-24 22:03:36: client0010: mul_int_int_int: ERROR: 22003!overflow in calculation 816153822*-212060493. #2025-03-24 22:03:36: client0010: mul_int_int_int: ERROR: 22003!overflow in calculation 816153822*-212060493. #2025-03-24 22:03:36: client0010: add_int_int_int: ERROR: 22003!overflow in calculation 2000022046+1143103273. #2025-03-24 22:03:36: client0010: add_int_int_int: ERROR: 22003!overflow in calculation 2000022046+1143103273. #2025-03-24 22:03:36: client0025: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types tinyint(1,0) and sec_interval(13,0) are not equal #2025-03-24 22:03:36: client0025: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types tinyint(1,0) and month_interval(3,0) are not equal #2025-03-24 22:03:36: client0025: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types tinyint(1,0) and month_interval(3,0) are not equal #2025-03-24 22:03:36: client0025: mul_bte_bte_bte: ERROR: 22003!overflow in calculation -29*6. #2025-03-24 22:03:36: client0025: mul_bte_bte_bte: ERROR: 22003!overflow in calculation -29*6. #2025-03-24 22:03:36: client0025: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 13*10. #2025-03-24 22:03:36: client0025: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 13*10. #2025-03-24 22:03:36: client0025: div_typeswitchloop: ERROR: 22012!division by zero. #2025-03-24 22:03:36: client0025: createExceptionInternal: ERROR: MALException:batcalc./:22012!division by zero. #2025-03-24 22:03:37: client0025: mul_dbl_dbl_dbl: ERROR: 22003!overflow in calculation -1.7976931348623157e+308*10. #2025-03-24 22:03:37: client0025: createExceptionInternal: ERROR: MALException:batcalc.*:22003!overflow in calculation -1.7976931348623157e+308*10. #2025-03-24 22:03:37: client0025: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types boolean(1,0) and tinyint(1,0) are not equal #2025-03-24 22:03:37: client0054: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CONSTRAINT UNIQUE: key 't0_c0_unique' already exists #2025-03-24 22:03:37: client0054: createExceptionInternal: ERROR: SQLException:batcalc.month_interval_str:42000!Wrong format (11313451898) #2025-03-24 22:03:37: client0054: createExceptionInternal: ERROR: SQLException:TYPE:42000!Decimal (0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131) doesn't have format (18.3) #2025-03-24 22:03:37: client0054: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types sec_interval(13,0) and date(0,0) are not equal #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't0.c0' in query results without an aggregate function #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'c0' char(222) is not compatible with the referenced UNIQUE KEY column type time(1) #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'c0' int is not compatible with the referenced UNIQUE KEY column type time(1) #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'c2' blob is not compatible with the referenced UNIQUE KEY column type sec_interval(13) #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'c2' time(1) is not compatible with the referenced UNIQUE KEY column type sec_interval(13) #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!JOIN: no columns of tables 't0' and 'sub0' match #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!JOIN: no columns of tables 't0' and 'sub0' match #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.c1' in query results without an aggregate function #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 't1.c1' in query results without an aggregate function #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: SQLException:str_cast:22001!value too long for type (var)char(10) #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: SQLException:str_cast:22001!value too long for type (var)char(10) #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'v20.vc0' in query results without an aggregate function #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: MALException:mtime.date_submonths:22003!overflow in calculation #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types bigint(63,0) and sec_interval(13,0) are not equal #2025-03-24 22:03:38: client0083: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: PRIMARY KEY constraint 't1.t1_c0_c1_pkey' violated #2025-03-24 22:03:38: client0112: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: NOT NULL constraint violated for column t1.c0 #2025-03-24 22:03:38: client0112: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'v0.c0' in query results without an aggregate function #2025-03-24 22:03:38: client0112: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: PRIMARY KEY constraint 't1.t1_c0_pkey' violated #2025-03-24 22:03:38: client0112: createExceptionInternal: ERROR: ParseException:SQLparser:42000!NATURAL JOIN: common column name 'v0' appears more than once in right table #2025-03-24 22:03:38: client0112: createExceptionInternal: ERROR: ParseException:SQLparser:42000!NATURAL JOIN: common column name 'v0' appears more than once in right table #2025-03-24 22:03:38: client0112: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'sub0.c0' ambiguous #2025-03-24 22:03:39: client0112: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 14*10. #2025-03-24 22:03:39: client0112: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 14*10. #2025-03-24 22:03:39: client0112: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 14*10. #2025-03-24 22:03:39: client0112: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 14*10. #2025-03-24 22:03:39: client0112: mul_int_bte_int: ERROR: 22003!overflow in calculation 1836147184*50. #2025-03-24 22:03:39: client0112: mul_int_bte_int: ERROR: 22003!overflow in calculation 1836147184*50. #2025-03-24 22:03:39: client0153: VARconvert: ERROR: 22018!conversion of string '' to type bit failed. #2025-03-24 22:03:39: client0153: createExceptionInternal: ERROR: MALException:calc.bit:22018!conversion of string '' to type bit failed. #2025-03-24 22:03:39: client0153: VARconvert: ERROR: 22018!conversion of string 'b_P' to type bit failed. #2025-03-24 22:03:39: client0153: createExceptionInternal: ERROR: MALException:calc.bit:22018!conversion of string 'b_P' to type bit failed. #2025-03-24 22:03:39: client0153: VARconvert: ERROR: 22018!conversion of string '' to type bit failed. #2025-03-24 22:03:39: client0153: createExceptionInternal: ERROR: MALException:calc.bit:22018!conversion of string '' to type bit failed. #2025-03-24 22:03:39: client0153: createExceptionInternal: ERROR: SQLException:sql.drop_index:42S12!DROP INDEX: cannot drop index 't0_c1_unique', because the constraint 't0_c1_unique' depends on it #2025-03-24 22:03:39: client0153: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: UNIQUE constraint 't0.t0_c1_unique' violated #2025-03-24 22:03:40: client0153: BATsubcross: ERROR: more than one match #2025-03-24 22:03:40: client0153: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:40: client0153: BATsubcross: ERROR: more than one match #2025-03-24 22:03:40: client0153: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:40: client0196: BATsubcross: ERROR: more than one match #2025-03-24 22:03:40: client0196: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:40: client0196: BATsubcross: ERROR: more than one match #2025-03-24 22:03:40: client0196: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:40: client0196: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "t0" specified more than once #2025-03-24 22:03:40: client0196: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: insufficient privileges for operator 'sys'.'sql_div'(decimal(34,32), decimal(17,16)) #2025-03-24 22:03:40: client0196: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: insufficient privileges for operator 'sys'.'sql_div'(decimal(35,33), decimal(17,16)) #2025-03-24 22:03:40: client0196: BATsubcross: ERROR: more than one match #2025-03-24 22:03:40: client0196: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:40: client0196: BATsubcross: ERROR: more than one match #2025-03-24 22:03:40: client0196: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:40: client0196: BATsubcross: ERROR: more than one match #2025-03-24 22:03:40: client0196: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:40: client0201: createExceptionInternal: ERROR: SQLException:TYPE:42000!Decimal (0.2.3) doesn't have format (10.2) #2025-03-24 22:03:40: client0201: createExceptionInternal: ERROR: SQLException:TYPE:42000!Decimal (0.2.3) doesn't have format (10.2) #2025-03-24 22:03:40: client0201: createExceptionInternal: ERROR: SQLException:TYPE:42000!Decimal (+0..2) doesn't have format (10.2) #2025-03-24 22:03:40: client0201: createExceptionInternal: ERROR: SQLException:TYPE:42000!Decimal (+0..2) doesn't have format (10.2) #2025-03-24 22:03:41: client0201: convert_int_bte: ERROR: 22003!overflow in conversion of 789092170 to bte. #2025-03-24 22:03:41: client0201: convert_int_bte: ERROR: 22003!overflow in conversion of 789092170 to bte. #2025-03-24 22:03:41: client0201: createExceptionInternal: ERROR: MALException:calc.bte:22003!overflow in conversion of 789092170 to bte. #2025-03-24 22:03:41: client0201: convert_int_bte: ERROR: 22003!overflow in conversion of 789092170 to bte. #2025-03-24 22:03:41: client0201: createExceptionInternal: ERROR: MALException:calc.bte:22003!overflow in conversion of 789092170 to bte. #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: PRIMARY KEY constraint 't2.t2_c0_pkey' violated #2025-03-24 22:03:41: client0228: add_int_int_int: ERROR: 22003!overflow in calculation -1377193484+-831664290. #2025-03-24 22:03:41: client0228: add_int_int_int: ERROR: 22003!overflow in calculation -1377193484+-831664290. #2025-03-24 22:03:41: client0228: xor_typeswitchloop: ERROR: 22003!overflow in calculation 1XOR-9223372036854775807. #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: MALException:batcalc.xor:22003!overflow in calculation 1XOR-9223372036854775807. #2025-03-24 22:03:41: client0228: convert_int_bte: ERROR: 22003!overflow in conversion of 1390068457 to bte. #2025-03-24 22:03:41: client0228: convert_int_bte: ERROR: 22003!overflow in conversion of 1390068457 to bte. #2025-03-24 22:03:41: client0228: mul_int_int_int: ERROR: 22003!overflow in calculation -1216247830*-580027885. #2025-03-24 22:03:41: client0228: mul_int_int_int: ERROR: 22003!overflow in calculation -1216247830*-580027885. #2025-03-24 22:03:41: client0228: convert_int_bte: ERROR: 22003!overflow in conversion of 1390068457 to bte. #2025-03-24 22:03:41: client0228: add_int_int_int: ERROR: 22003!overflow in calculation -1660927937+-1322418229. #2025-03-24 22:03:41: client0228: add_int_int_int: ERROR: 22003!overflow in calculation -1660927937+-1322418229. #2025-03-24 22:03:41: client0228: rsh_typeswitchloop: ERROR: VARcalcrsh: shift operand too large in RSH(-1138638151,31055). #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: MALException:calc.>>:VARcalcrsh: shift operand too large in RSH(-1138638151,31055). #2025-03-24 22:03:41: client0228: xor_typeswitchloop: ERROR: 22003!overflow in calculation 1XOR-9223372036854775807. #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: MALException:batcalc.xor:22003!overflow in calculation 1XOR-9223372036854775807. #2025-03-24 22:03:41: client0228: div_dbl_dbl_dbl: ERROR: 22003!overflow in calculation -1.7976931348623157e+308/0.98067827792867723. #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: MALException:calc./:22003!overflow in calculation -1.7976931348623157e+308/0.98067827792867723. #2025-03-24 22:03:41: client0228: div_dbl_dbl_dbl: ERROR: 22003!overflow in calculation -1.7976931348623157e+308/0.98067827792867723. #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: MALException:calc./:22003!overflow in calculation -1.7976931348623157e+308/0.98067827792867723. #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: MALException:round:22003!Overflow in round #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: MALException:round:22003!Overflow in round #2025-03-24 22:03:41: client0228: mod_typeswitchloop: ERROR: 22012!division by zero. #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: MALException:batcalc.%:22012!division by zero. #2025-03-24 22:03:41: client0228: convert_int_bte: ERROR: 22003!overflow in conversion of -1267863719 to bte. #2025-03-24 22:03:41: client0228: convert_int_bte: ERROR: 22003!overflow in conversion of -1267863719 to bte. #2025-03-24 22:03:41: client0228: mul_int_sht_int: ERROR: 22003!overflow in calculation 697298603*25922. #2025-03-24 22:03:41: client0228: mul_int_sht_int: ERROR: 22003!overflow in calculation 697298603*25922. #2025-03-24 22:03:41: client0228: mul_int_sht_int: ERROR: 22003!overflow in calculation 697298603*25922. #2025-03-24 22:03:41: client0228: mul_int_sht_int: ERROR: 22003!overflow in calculation 697298603*25922. #2025-03-24 22:03:41: client0228: mul_int_sht_int: ERROR: 22003!overflow in calculation 697298603*25922. #2025-03-24 22:03:41: client0228: mul_int_sht_int: ERROR: 22003!overflow in calculation 697298603*25922. #2025-03-24 22:03:41: client0228: convert_int_sht: ERROR: 22003!overflow in conversion of 220424338 to sht. #2025-03-24 22:03:41: client0228: convert_int_sht: ERROR: 22003!overflow in conversion of 220424338 to sht. #2025-03-24 22:03:41: client0228: convert_int_sht: ERROR: 22003!overflow in conversion of 220424338 to sht. #2025-03-24 22:03:41: client0228: convert_int_sht: ERROR: 22003!overflow in conversion of 220424338 to sht. #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'v0.vc0' in query results without an aggregate function #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'v0.vc0' in query results without an aggregate function #2025-03-24 22:03:41: client0228: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: PRIMARY KEY constraint 't1.t1_c0_c1_pkey' violated #2025-03-24 22:03:41: client0247: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types varchar(18,0) and decimal(20,2) are not equal #2025-03-24 22:03:41: client0247: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types varchar(4,0) and tinyint(4,0) are not equal #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: FOREIGN KEY constraint 't1.t1_c0_fkey' violated #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: PRIMARY KEY constraint 't1.t1_c0_pkey' violated #2025-03-24 22:03:42: client0280: BATsubcross: ERROR: more than one match #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:42: client0280: BATsubcross: ERROR: more than one match #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:42: client0280: BATsubcross: ERROR: more than one match #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:42: client0280: BATsubcross: ERROR: more than one match #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:42: client0280: BATsubcross: ERROR: more than one match #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE: subqueries not supported inside MERGE conditions #2025-03-24 22:03:42: client0280: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE: subqueries not supported inside MERGE conditions #2025-03-24 22:03:43: client0292: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-24 22:03:43: client0292: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-24 22:03:43: client0292: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-24 22:03:43: client0292: BATsubcross: ERROR: more than one match #2025-03-24 22:03:43: client0292: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:43: client0292: createExceptionInternal: ERROR: MALException:mmath.powf:Math exception: Numerical result out of range #2025-03-24 22:03:43: client0292: createExceptionInternal: ERROR: SQLException:sql.execute:25005!Current transaction is aborted (please ROLLBACK) #2025-03-24 22:03:44: client0321: createExceptionInternal: ERROR: SQLException:sql.alter_table:40002!ALTER TABLE: NOT NULL constraint violated for column t1.c1 #2025-03-24 22:03:44: client0321: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types uuid(0,0) and boolean(1,0) are not equal #2025-03-24 22:03:44: client0321: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE: subqueries not supported inside MERGE conditions #2025-03-24 22:03:44: client0321: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE: set operations not supported inside MERGE conditions #2025-03-24 22:03:44: client0321: sub_int_int_int: ERROR: 22003!overflow in calculation 281921255--1868657623. #2025-03-24 22:03:44: client0321: sub_int_int_int: ERROR: 22003!overflow in calculation 281921255--1868657623. #2025-03-24 22:03:44: client0336: BATsubcross: ERROR: more than one match #2025-03-24 22:03:44: client0336: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:44: client0336: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: NOT NULL constraint violated for column t0.c0 #2025-03-24 22:03:44: client0355: createExceptionInternal: ERROR: MALException:soundex:42000!Soundex function not available for non ASCII strings #2025-03-24 22:03:44: client0355: createExceptionInternal: ERROR: SQLException:assert:40002!UPDATE: UNIQUE constraint 't2.con3' violated #2025-03-24 22:03:45: client0362: BATsubcross: ERROR: more than one match #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:45: client0362: BATsubcross: ERROR: more than one match #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types tinyint(1,0) and day_interval(4,0) are not equal #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0362: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0375: BATsubcross: ERROR: more than one match #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause #2025-03-24 22:03:45: client0375: BATsubcross: ERROR: more than one match #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vz.c0' in query results without an aggregate function #2025-03-24 22:03:45: client0375: BATsubcross: ERROR: more than one match #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:45: client0375: BATsubcross: ERROR: more than one match #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: aggregate functions not allowed in WHERE clause #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: aggregate functions not allowed in WHERE clause #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0375: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function #2025-03-24 22:03:45: client0380: hashjoin: ERROR: more than one match #2025-03-24 22:03:45: client0380: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match #2025-03-24 22:03:45: client0380: hashjoin: ERROR: more than one match #2025-03-24 22:03:45: client0380: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: hashjoin: more than one match #2025-03-24 22:03:45: client0482: createExceptionInternal: ERROR: IllegalArgumentException:inet.setmask:Illegal netmask length value: 48061431 #2025-03-24 22:03:45: client0479: createExceptionInternal: ERROR: IllegalArgumentException:remote.exec:(mapi:monetdb://monetdb@localhost/mTests_sql_test_SQLancer) Illegal netmask length value: 48061431 #2025-03-24 22:03:45: client0479: createExceptionInternal: ERROR: MALException:user.%3[29]:Exception occurred in the remote server, please check the log there #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE VIEW: LIMIT not supported #2025-03-24 22:03:45: client0492: BATsubcross: ERROR: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:45: client0492: selectjoin: ERROR: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:45: client0492: selectjoin: ERROR: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:45: client0492: selectjoin: ERROR: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:45: client0492: selectjoin: ERROR: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:45: client0492: selectjoin: ERROR: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:45: client0492: BATsubcross: ERROR: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:45: client0492: selectjoin: ERROR: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "rt0" specified more than once #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "rt0" specified more than once #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "rt0" specified more than once #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'c0' ambiguous #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'c0' ambiguous #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "rt0" specified more than once #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: relation name "rt0" specified more than once #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'c0' ambiguous #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'c0' ambiguous #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in WHERE clause #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42S22!SELECT: no such column 'x.c0' #2025-03-24 22:03:45: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42S22!SELECT: no such column 'x.c0' #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!subquery must return only one column #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'y.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.y' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too many columns #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Subquery has too few columns #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: subquery must return only one column #2025-03-24 22:03:46: client0492: BATsubcross: ERROR: more than one match #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:46: client0492: BATsubcross: ERROR: more than one match #2025-03-24 22:03:46: client0492: createExceptionInternal: ERROR: MALException:algebra.crossproduct:GDK reported error: BATsubcross: more than one match #2025-03-24 22:03:46: client0493: selectjoin: ERROR: more than one match #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: MALException:algebra.intersect:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected #2025-03-24 22:03:46: client0493: selectjoin: ERROR: more than one match #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:46: client0493: selectjoin: ERROR: more than one match #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:46: client0493: selectjoin: ERROR: more than one match #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: MALException:algebra.semijoin:GDK reported error: selectjoin: more than one match #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed in JOIN conditions #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MAX: aggregate functions not allowed in JOIN conditions #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in JOIN conditions #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in JOIN conditions #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: aggregate functions not allowed in JOIN conditions #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate functions cannot be nested #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate functions cannot be nested #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate functions cannot be nested #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate functions cannot be nested #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: cannot use non GROUP BY column 'x.x' in query results without an aggregate function #2025-03-24 22:03:46: client0493: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COUNT: aggregate functions not allowed in WHERE clause #2025-03-24 22:03:46: client0494: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MIN: aggregate functions cannot be nested