sql/test/merge-partitions standard error

# builtin opt 	gdk_dbpath = /export/scratch1/home/monet/testing/f8e03e321dba-2-1-2/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 = 32
# cmdline opt 	mapi_listenaddr = all
# cmdline opt 	mapi_port = 0
# cmdline opt 	mapi_usock = /tmp/mtest-1418491/.s.monetdb.${PORT}
# cmdline opt 	gdk_dbpath = /export/scratch1/home/monet/testing/f8e03e321dba-2-1-2/tests/sql/dbfarm/mTests_sql_test_merge-partitions
# cmdline opt 	gdk_vm_maxsize = 8589934592
# cmdline opt 	monet_vault_key = /export/scratch1/home/monet/testing/f8e03e321dba-2-1-2/tests/sql/dbfarm/mTests_sql_test_merge-partitions/.vaultkey
#2024-04-26 01:41:54: client0043: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE MERGE TABLE: the partition column 'd' is not part of the table
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42S02!ALTER TABLE: table 'sys.subtable1' is already part of RANGE PARTITION TABLE 'sys.testme'
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER RANGE PARTITION TABLE: to be added table doesn't match RANGE PARTITION TABLE definition
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot add a value partition into a RANGE PARTITION TABLE
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 7 to 9 and 5 to 10 from table sys.subtable1
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 5 to 6 and 5 to 10 from table sys.subtable1
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.subtable2' isn't part of RANGE PARTITION TABLE 'sys.testme'
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table subtable1 (there are database objects which depend on it)
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: ParseException:SQLparser:2BM37!ALTER TABLE: unable to set schema of table 'testme' (there are database objects which depend on it)
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: ParseException:SQLparser:2BM37!ALTER TABLE: unable to set schema of table 'subtable1' (there are database objects which depend on it)
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: ParseException:SQLparser:2BM37!ALTER TABLE: unable to rename table 'subtable1' (there are database objects which depend on it)
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: all children tables of 'sys.testme' must be part of schema 'sys'
#2024-04-26 01:41:54: client0044: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: minimum value is equal to the maximum value
#2024-04-26 01:41:54: client0045: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot add a range partition into a LIST PARTITION TABLE
#2024-04-26 01:41:54: client0045: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:42000!ALTER TABLE: the new partition is conflicting with the existing partition sys.subtable1
#2024-04-26 01:41:54: client0045: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table subtable1 (there are database objects which depend on it)
#2024-04-26 01:41:54: client0046: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:41:54: client0047: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition list of values
#2024-04-26 01:41:54: client0047: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:M0M29!ALTER TABLE: there are values in column a outside the partition list of values
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42S02!ALTER TABLE: table 'sys.subtable1' is already part of RANGE PARTITION TABLE 'sys.listparts'
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42S02!ALTER TABLE: table 'sys.subtable1' is already part of RANGE PARTITION TABLE 'sys.listparts'
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42S02!ALTER TABLE: table 'sys.subtable1' is already part of RANGE PARTITION TABLE 'sys.listparts'
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: minimum value is higher than maximum value
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.subtable1' isn't part of RANGE PARTITION TABLE 'sys.listparts'
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column b outside the partition range
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: minimum value is higher than maximum value
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column b outside the partition range
#2024-04-26 01:41:54: client0048: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:41:54: client0049: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:54: client0049: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: -1 to 1 and 0 to 100 from table sys.sublimits1
#2024-04-26 01:41:54: client0049: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:54: client0049: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:54: client0049: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.sublimits3 is part of merge table sys.testrangelimits and the insert violates the partition range of values
#2024-04-26 01:41:54: client0049: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.sublimits1 is part of merge table sys.testrangelimits and the insert violates the partition range of values
#2024-04-26 01:41:54: client0049: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.sublimits2 is part of merge table sys.testrangelimits and the insert violates the partition range of values
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: range bound cannot be null
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: range bound cannot be null
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: range bound cannot be null
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.subtable1 stores null values and only one partition can store null values at the time
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.subtable1' isn't part of RANGE PARTITION TABLE 'sys.listparts'
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: range bound cannot be null
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: range bound cannot be null
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: range bound cannot be null
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42S02!ALTER TABLE: table 'sys.othersub1' is already part of RANGE PARTITION TABLE 'sys.anothertest'
#2024-04-26 01:41:54: client0050: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column b outside the partition range
#2024-04-26 01:41:54: client0052: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition list of values
#2024-04-26 01:41:54: client0052: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:42000!ALTER TABLE: the new partition is conflicting with the existing partition sys.sublimits2
#2024-04-26 01:41:54: client0052: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: a list value cannot be null
#2024-04-26 01:41:54: client0052: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:42000!ALTER TABLE: the new partition is conflicting with the existing partition sys.sublimits1
#2024-04-26 01:41:54: client0052: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition list of values
#2024-04-26 01:41:54: client0052: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.sublimits3 is part of merge table sys.testvaluespartitions and the insert violates the partition list of values
#2024-04-26 01:41:54: client0052: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.sublimits1 is part of merge table sys.testvaluespartitions and the insert violates the partition list of values
#2024-04-26 01:41:54: client0053: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT INTO: list partitioned table 'testsmallpartitions' has no partitions set
#2024-04-26 01:41:54: client0053: createExceptionInternal: ERROR: ParseException:SQLparser:42000!DELETE FROM: list partitioned table 'testsmallpartitions' has no partitions set
#2024-04-26 01:41:54: client0053: createExceptionInternal: ERROR: ParseException:SQLparser:42000!DELETE FROM: list partitioned table 'testsmallpartitions' has no partitions set
#2024-04-26 01:41:54: client0053: createExceptionInternal: ERROR: ParseException:SQLparser:42000!TRUNCATE: list partitioned table 'testsmallpartitions' has no partitions set
#2024-04-26 01:41:54: client0053: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: list partitioned table 'testsmallpartitions' has no partitions set
#2024-04-26 01:41:55: client0054: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update on the partitioned column is not possible at the moment
#2024-04-26 01:41:55: client0054: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update on the partitioned column is not possible at the moment
#2024-04-26 01:41:55: client0054: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update on the partitioned column is not possible at the moment
#2024-04-26 01:41:55: client0054: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update on the partitioned column is not possible at the moment
#2024-04-26 01:41:55: client0055: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update on the partitioned column is not possible at the moment
#2024-04-26 01:41:55: client0055: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update on the partitioned column is not possible at the moment
#2024-04-26 01:41:55: client0055: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update on the partitioned column is not possible at the moment
#2024-04-26 01:41:55: client0056: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 2005-02-13 01:08:10.000000 to 2006-12-12 23:59:59.000000 and 2000-01-01 00:00:00.000000 to 2009-12-12 23:59:59.000000 from table sys.onedecade
#2024-04-26 01:41:55: client0056: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 1999-01-01 14:06:01.000000 to 2021-07-31 13:09:56.000000 and 2000-01-01 00:00:00.000000 to 2009-12-12 23:59:59.000000 from table sys.onedecade
#2024-04-26 01:41:55: client0056: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 2008-03-12 19:24:50.000000 to 2018-07-31 05:01:47.000000 and 2000-01-01 00:00:00.000000 to 2009-12-12 23:59:59.000000 from table sys.onedecade
#2024-04-26 01:41:55: client0056: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:55: client0056: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.onedecade is part of merge table sys.testtime and the insert violates the partition range of values
#2024-04-26 01:41:55: client0056: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.threedecades stores null values and only one partition can store null values at the time
#2024-04-26 01:41:55: client0056: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:55: client0056: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.fourdecades is part of merge table sys.testtime and the insert violates the partition range of values
#2024-04-26 01:41:55: client0057: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE MERGE TABLE: the partition column 'd' is not part of the table
#2024-04-26 01:41:55: client0057: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE MERGE TABLE: column type geometry(28) not yet supported for the partition column
#2024-04-26 01:41:55: client0057: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE MERGE TABLE: column type json not yet supported for the partition column
#2024-04-26 01:41:55: client0058: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:41:55: client0058: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:55: client0058: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.sublimits1 is part of merge table sys.testme and the insert violates the partition range of values
#2024-04-26 01:41:55: client0058: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.sublimits1 stores null values and only one partition can store null values at the time
#2024-04-26 01:41:55: client0058: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.sublimits1 stores null values and only one partition can store null values at the time
#2024-04-26 01:41:55: client0059: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT INTO: list partitioned table 'testnestedpartitions' has no partitions set
#2024-04-26 01:41:55: client0059: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RANGE PARTITION TABLE 'sys'.'subnested1' should have at least one table associated
#2024-04-26 01:41:55: client0059: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.subnested1 is part of merge table sys.testnestedpartitions and the insert violates the partition list of values
#2024-04-26 01:41:55: client0059: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:55: client0059: createExceptionInternal: ERROR: ParseException:SQLparser:42000!RANGE PARTITION TABLE 'sys'.'subnested2' should have at least one table associated
#2024-04-26 01:41:55: client0059: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:42000!ALTER TABLE: the new partition is conflicting with the existing partition sys.subnested1
#2024-04-26 01:41:55: client0059: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:55: client0059: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 1 to 200 and 0 to 100 from table sys.subt1
#2024-04-26 01:41:55: client0061: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:41:55: client0061: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update on the partitioned column is not possible at the moment
#2024-04-26 01:41:55: client0061: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:41:55: client0061: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.sublimits1 is part of merge table sys.testupdates and the insert violates the partition range of values
#2024-04-26 01:41:55: client0061: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:41:55: client0062: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42S02!ALTER TABLE: table 'sys.subt1' isn't part of RANGE PARTITION TABLE 'sys.updateme'
#2024-04-26 01:41:55: client0062: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:41:55: client0062: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:55: client0062: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.subt1 is part of merge table sys.updateme and the insert violates the partition range of values
#2024-04-26 01:41:55: client0062: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:55: client0062: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:55: client0062: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.subt1 is part of merge table sys.updateme and the insert violates the partition range of values
#2024-04-26 01:41:55: client0063: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:42S02!ALTER TABLE: table 'sys.subt1' isn't part of LIST PARTITION TABLE 'sys.testme'
#2024-04-26 01:41:55: client0063: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:M0M29!ALTER TABLE: there are values in column a outside the partition list of values
#2024-04-26 01:41:55: client0063: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition list of values
#2024-04-26 01:41:55: client0063: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.subt1 is part of merge table sys.testme and the insert violates the partition list of values
#2024-04-26 01:41:55: client0063: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.subt1 is part of merge table sys.testme and the insert violates the partition list of values
#2024-04-26 01:41:55: client0063: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition list of values
#2024-04-26 01:41:55: client0063: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.subt1 is part of merge table sys.testme and the insert violates the partition list of values
#2024-04-26 01:41:56: client0064: createExceptionInternal: ERROR: SQLException:sql.partition:42000!SELECT: no such unary operator 'iamdummy'(int)
#2024-04-26 01:41:56: client0064: numFromStr: ERROR: not a number
#2024-04-26 01:41:56: client0064: VARconvert: ERROR: 22018!conversion of string 'abc' to type int failed.
#2024-04-26 01:41:56: client0064: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'abc' to type int failed.
#2024-04-26 01:41:56: client0064: numFromStr: ERROR: not a number
#2024-04-26 01:41:56: client0064: VARconvert: ERROR: 22018!conversion of string 'abc' to type int failed.
#2024-04-26 01:41:56: client0064: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'abc' to type int failed.
#2024-04-26 01:41:56: DFLOWworker0031: numFromStr: ERROR: not a number
#2024-04-26 01:41:56: DFLOWworker0031: VARconvert: ERROR: 22018!conversion of string 'abc' to type int failed.
#2024-04-26 01:41:56: DFLOWworker0031: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'abc' to type int failed.
#2024-04-26 01:41:56: client0064: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:56: client0064: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.subtable1 is part of merge table sys.testme and the insert violates the partition range of values
#2024-04-26 01:41:56: DFLOWworker0018: createExceptionInternal: ERROR: SQLException:sql.zero_or_one:21000!Cardinality violation, scalar value expected
#2024-04-26 01:41:56: client0064: createExceptionInternal: ERROR: SQLException:sql.partition:42000!SUM: aggregate functions not allowed on an unique value
#2024-04-26 01:41:56: client0064: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE MERGE TABLE: error compiling expression 'SQL feature not yet available for expressions and default values: WINDOW'
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot drop column 'cc': is the partitioned column on the table 'trydropme'
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: SQLException:sql.drop_func:42000!DROP FUNCTION: there are database objects dependent on function dosomething;
#2024-04-26 01:41:56: client0065: numFromStr: ERROR: not a number
#2024-04-26 01:41:56: client0065: VARconvert: ERROR: 22018!conversion of string 'ups' to type lng failed.
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: MALException:calc.lng:22018!conversion of string 'ups' to type lng failed.
#2024-04-26 01:41:56: client0065: numFromStr: ERROR: not a number
#2024-04-26 01:41:56: client0065: VARconvert: ERROR: 22018!conversion of string 'ups' to type lng failed.
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: MALException:calc.lng:22018!conversion of string 'ups' to type lng failed.
#2024-04-26 01:41:56: DFLOWworker0025: numFromStr: ERROR: not a number
#2024-04-26 01:41:56: DFLOWworker0025: VARconvert: ERROR: 22018!conversion of string 'ups' to type lng failed.
#2024-04-26 01:41:56: DFLOWworker0021: numFromStr: ERROR: not a number
#2024-04-26 01:41:56: DFLOWworker0021: VARconvert: ERROR: 22018!conversion of string 'ups' to type lng failed.
#2024-04-26 01:41:56: DFLOWworker0021: createExceptionInternal: ERROR: MALException:calc.lng:22018!conversion of string 'ups' to type lng failed.
#2024-04-26 01:41:56: DFLOWworker0025: createExceptionInternal: ERROR: MALException:calc.lng:22018!conversion of string 'ups' to type lng failed.
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot drop column from LIST PARTITION TABLE 'nexttest' while it has partitions
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot add column to LIST PARTITION TABLE 'nexttest' while it has partitions
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot drop column from a PARTITION of a MERGE or REPLICA TABLE 'subtable1'
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot add column to a PARTITION of a MERGE or REPLICA TABLE 'subtable1'
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot drop column 'a': the expression used in 'nexttest' depends on it
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: SQLException:sql.partition:42000!SELECT: no such unary operator 'dosomethingelse'(int)
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'nexttest'
#2024-04-26 01:41:56: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!DROP TABLE: no such table 'nexttest'
#2024-04-26 01:41:56: client0066: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update a column used by the partition's expression is not possible at the moment
#2024-04-26 01:41:56: client0066: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update a column used by the partition's expression is not possible at the moment
#2024-04-26 01:41:58: client0068: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:42000!ALTER TABLE: there are duplicated values in the list
#2024-04-26 01:41:58: client0068: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:42000!ALTER TABLE: the new partition is conflicting with the existing partition sys.sublimits1
#2024-04-26 01:41:58: client0068: mul_bte_bte_bte: ERROR: 22003!overflow in calculation -100*2.
#2024-04-26 01:41:58: client0068: mul_bte_bte_bte: ERROR: 22003!overflow in calculation -100*2.
#2024-04-26 01:41:59: client0068: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 69 to 538 and 30 to 70 from table sys.sublimits1
#2024-04-26 01:41:59: client0069: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: range partitioned table 'testmeplease' has no partitions set
#2024-04-26 01:41:59: client0069: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: range partitioned table 'testmeplease' has no partitions set
#2024-04-26 01:41:59: client0069: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update a column used by the partition's expression is not possible at the moment
#2024-04-26 01:41:59: client0069: numFromStr: ERROR: not a number
#2024-04-26 01:41:59: client0069: VARconvert: ERROR: 22018!conversion of string 'cannot cast me' to type int failed.
#2024-04-26 01:41:59: client0069: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'cannot cast me' to type int failed.
#2024-04-26 01:41:59: DFLOWworker0034: numFromStr: ERROR: not a number
#2024-04-26 01:41:59: DFLOWworker0034: VARconvert: ERROR: 22018!conversion of string 'cannot cast me' to type int failed.
#2024-04-26 01:41:59: DFLOWworker0034: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'cannot cast me' to type int failed.
#2024-04-26 01:41:59: client0069: numFromStr: ERROR: not a number
#2024-04-26 01:41:59: client0069: VARconvert: ERROR: 22018!conversion of string 'cannot cast me' to type int failed.
#2024-04-26 01:41:59: client0069: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'cannot cast me' to type int failed.
#2024-04-26 01:41:59: DFLOWworker0060: numFromStr: ERROR: not a number
#2024-04-26 01:41:59: DFLOWworker0060: VARconvert: ERROR: 22018!conversion of string 'cannot cast me' to type int failed.
#2024-04-26 01:41:59: DFLOWworker0060: createExceptionInternal: ERROR: MALException:calc.int:22018!conversion of string 'cannot cast me' to type int failed.
#2024-04-26 01:41:59: client0069: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update a column used by the partition's expression is not possible at the moment
#2024-04-26 01:41:59: client0069: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update a column used by the partition's expression is not possible at the moment
#2024-04-26 01:41:59: client0069: createExceptionInternal: ERROR: ParseException:SQLparser:42000!UPDATE: Update a column used by the partition's expression is not possible at the moment
#2024-04-26 01:41:59: client0070: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_value_partition:M0M29!ALTER TABLE: there are values in the expression outside the partition list of values
#2024-04-26 01:41:59: client0070: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in the expression outside the partition range
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT: cannot insert read only table 'subt1'
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER RANGE PARTITION TABLE: to be added table column DEFAULT value doesn't match RANGE PARTITION TABLE definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER RANGE PARTITION TABLE: to be added table column DEFAULT value doesn't match RANGE PARTITION TABLE definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.partition:42000!CREATE TABLE: sys.checkkeys: in a partitioned table, the primary key's columns must match the columns used in the partition definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.partition:42000!CREATE TABLE: sys.checkkeys: in a partitioned table, the primary key's columns must match the columns used in the partition definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.partition:42000!CREATE TABLE: sys.checkkeys: in a partitioned table, the primary key's columns must match the columns used in the partition definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.partition:42000!CREATE TABLE: sys.checkkeys: in a partitioned table, the primary key's columns must match the columns used in the partition definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.partition:42000!CREATE TABLE: sys.checkkeys: in a partitioned table, the primary key's columns must match the columns used in the partition definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER RANGE PARTITION TABLE: to be added table key doesn't match RANGE PARTITION TABLE definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot drop constraint from a PARTITION of a MERGE or REPLICA TABLE 'subt1'
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot add constraint to a PARTITION of a MERGE or REPLICA TABLE 'subt1'
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER RANGE PARTITION TABLE: to be added table column NULL check doesn't match RANGE PARTITION TABLE definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot drop constraint from RANGE PARTITION TABLE 'checkkeys' while it has partitions
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot add constraint to RANGE PARTITION TABLE 'checkkeys' while it has partitions
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: cannot add constraint to RANGE PARTITION TABLE 'checkkeys' while it has partitions
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER RANGE PARTITION TABLE: to be added table key's columns doesn't match RANGE PARTITION TABLE definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER RANGE PARTITION TABLE: to be added table key doesn't match RANGE PARTITION TABLE definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.partition:42000!CREATE TABLE: sys.checkunique: in a partitioned table, the unique key's columns must match the columns used in the partition definition
#2024-04-26 01:41:59: client0071: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER RANGE PARTITION TABLE: to be added table key's columns doesn't match RANGE PARTITION TABLE definition
#2024-04-26 01:41:59: client0072: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:41:59: client0072: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COPY LOADER INTO: not possible for partitioned tables at the moment
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: a range partition is required while adding under a RANGE PARTITION TABLE
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: a value partition is required while adding under a LIST PARTITION TABLE
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.another1 stores every possible value
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.another1 stores every possible value
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.another1 stores every possible value
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.another1 stores every possible value
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.another1 stores null values and only one partition can store null values at the time
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 1 to 2 and absolute min value to absolute max value from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: absolute min value to -1 and absolute min value to absolute max value from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 10 to absolute max value and absolute min value to absolute max value from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.another1 is part of merge table sys.table1 and the insert violates the partition range of values
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.another2 is part of merge table sys.table1 and the insert violates the partition range of values
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.another2' isn't part of RANGE PARTITION TABLE 'sys.table1'
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:M0M29!ALTER TABLE: there are values in column a outside the partition range
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.another2' isn't part of RANGE PARTITION TABLE 'sys.table1'
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: absolute min value to 1 and absolute min value to 2 from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 0 to 1 and absolute min value to 2 from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.another2' isn't part of RANGE PARTITION TABLE 'sys.table1'
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 10 to absolute max value and 2 to absolute max value from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 1 to 3 and 2 to absolute max value from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.another2' isn't part of RANGE PARTITION TABLE 'sys.table1'
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: -100 to -1 and absolute min value to 0 from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: absolute min value to -1 and absolute min value to 0 from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: absolute min value to 0 and absolute min value to 0 from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: absolute min value to absolute max value and absolute min value to 0 from table sys.another1
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: minimum value is equal to the maximum value
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: minimum value is equal to the maximum value
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 10 to 11 and 10 to absolute max value from table sys.another2
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 10 to absolute max value and 10 to absolute max value from table sys.another2
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 20 to absolute max value and 10 to absolute max value from table sys.another2
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 9 to 10 and 0 to 10 from table sys.another3
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 9 to 10 and 0 to 10 from table sys.another3
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: table sys.another4 stores null values and only one partition can store null values at the time
#2024-04-26 01:42:01: client0078: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.another5' isn't part of RANGE PARTITION TABLE 'sys.table1'
#2024-04-26 01:42:02: client0080: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: the insert violates the partition range (NB higher limit exclusive) of values
#2024-04-26 01:42:02: client0080: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.another1 is part of merge table sys.table1 and the insert violates the partition range of values
#2024-04-26 01:42:02: client0080: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 10 to 11 and 10 to 11 from table sys.another1
#2024-04-26 01:42:02: client0080: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 11 to 12 and 11 to 12 from table sys.another2
#2024-04-26 01:42:02: client0080: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 10 to absolute max value and 10 to 11 from table sys.another1
#2024-04-26 01:42:02: client0080: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_range_partition:42000!ALTER TABLE: conflicting partitions: 11 to absolute max value and 11 to 12 from table sys.another2
#2024-04-26 01:42:02: client0080: createExceptionInternal: ERROR: SQLException:assert:M0M29!INSERT: table sys.another2 is part of merge table sys.table1 and the insert violates the partition range of values
#2024-04-26 01:42:02: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT INTO: not possible to insert into a partitioned table with complex indexes at the moment
#2024-04-26 01:42:02: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT INTO: not possible to insert into a partitioned table with complex indexes at the moment
#2024-04-26 01:42:02: client0082: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table another3 (there are database objects which depend on it)