sql/test/mergetables standard error

# builtin opt 	gdk_dbpath = /export/scratch1/home/monet/testing/a62032f034ae-4-1-4/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-2661320/.s.monetdb.${PORT}
# cmdline opt 	gdk_dbpath = /export/scratch1/home/monet/testing/a62032f034ae-4-1-4/tests/sql/dbfarm/mTests_sql_test_mergetables
# cmdline opt 	gdk_vm_maxsize = 8589934592
# cmdline opt 	monet_vault_key = /export/scratch1/home/monet/testing/a62032f034ae-4-1-4/tests/sql/dbfarm/mTests_sql_test_mergetables/.vaultkey
#2024-10-03 20:25:14: client0010: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: can't add/drop a view into a MERGE TABLE
#2024-10-03 20:25:14: client0021: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'emptym' should have at least one table associated
#2024-10-03 20:25:14: client0022: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'unknowntable'
#2024-10-03 20:25:14: client0022: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'part1'
#2024-10-03 20:25:14: client0022: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'mys'.'part1'
#2024-10-03 20:25:14: client0022: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'mys'.'smalltable' should have at least one table associated
#2024-10-03 20:25:14: client0023: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table column type doesn't match MERGE TABLE definition
#2024-10-03 20:25:14: client0023: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table column type doesn't match MERGE TABLE definition
#2024-10-03 20:25:14: client0023: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'complete' should have at least one table associated
#2024-10-03 20:25:14: client0024: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_table:42S02!ALTER TABLE: table 'sys.part1' is already part of MERGE TABLE 'sys.complete'
#2024-10-03 20:25:14: client0024: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_table:42S02!ALTER TABLE: table 'sys.part2' is already part of MERGE TABLE 'sys.complete'
#2024-10-03 20:25:14: client0031: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table part1 (there are database objects which depend on it)
#2024-10-03 20:25:14: client0031: createExceptionInternal: ERROR: SQLException:sql.drop_table:42000!DROP TABLE: unable to drop table part2 (there are database objects which depend on it)
#2024-10-03 20:25:14: client0041: createExceptionInternal: ERROR: SQLException:sql.alter_table_set_access:42000!ALTER TABLE: access changes on MERGE TABLES not supported
#2024-10-03 20:25:14: client0046: createExceptionInternal: ERROR: SQLException:sql.alter_table_del_table:42S02!ALTER TABLE: table 'sys.t1' isn't part of MERGE TABLE 'sys.m'
#2024-10-03 20:25:14: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 't1'
#2024-10-03 20:25:14: client0048: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COPY INTO: cannot copy into merge table 'part1'
#2024-10-03 20:25:14: client0048: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected INTNUM in: "0.0"
#2024-10-03 20:25:14: client0048: createExceptionInternal: ERROR: ParseException:SQLparser:42000!COPY INTO: cannot copy into merge table 'part2'
#2024-10-03 20:25:14: client0048: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected INTNUM in: "2.0"
#2024-10-03 20:25:14: client0048: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'part1' should have at least one table associated
#2024-10-03 20:25:14: client0049: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table column NULL check doesn't match MERGE TABLE definition
#2024-10-03 20:25:14: client0049: createExceptionInternal: ERROR: SQLException:sql.rel_check_tables:3F000!ALTER MERGE TABLE: to be added table column NULL check doesn't match MERGE TABLE definition
#2024-10-03 20:25:14: client0049: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: PRIMARY KEY constraint 'part2.part2_x_pkey' violated
#2024-10-03 20:25:14: client0049: createExceptionInternal: ERROR: SQLException:assert:40002!INSERT INTO: PRIMARY KEY constraint 'part1.part1_x_pkey' violated
#2024-10-03 20:25:14: client0049: createExceptionInternal: ERROR: ParseException:SQLparser:42000!INSERT INTO: cannot insert into merge table 'complete'
#2024-10-03 20:25:14: client0054: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 100*10.
#2024-10-03 20:25:14: client0054: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 100*10.
#2024-10-03 20:25:14: client0054: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 100*10.
#2024-10-03 20:25:14: client0054: mul_bte_bte_bte: ERROR: 22003!overflow in calculation 100*10.
#2024-10-03 20:25:14: client0060: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_table:42S02!ALTER TABLE: cannot add table 'sys.tmp2' to TABLE 'sys.tmp1'
#2024-10-03 20:25:14: client0061: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'sys'.'t2' should have at least one table associated
#2024-10-03 20:25:14: client0061: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'sys'.'t2' should have at least one table associated
#2024-10-03 20:25:14: client0065: createExceptionInternal: ERROR: ParseException:SQLparser:42S22!SELECT: no such column 'ref_12.b'
#2024-10-03 20:25:15: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'mt2' should have at least one table associated
#2024-10-03 20:25:15: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'mt1' should have at least one table associated
#2024-10-03 20:25:15: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'mt1' should have at least one table associated
#2024-10-03 20:25:15: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'mt2' should have at least one table associated
#2024-10-03 20:25:15: client0083: createExceptionInternal: ERROR: SQLException:sql.drop_schema:3F000!DROP SCHEMA: name concurrent_mt does not exist
#2024-10-03 20:25:15: client0113: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead
#2024-10-03 20:25:17: client0139: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'parent' should have at least one table associated
#2024-10-03 20:25:17: client0139: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'sys'.'parent' should have at least one table associated
#2024-10-03 20:25:17: client0140: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'sys'.'parent' should have at least one table associated
#2024-10-03 20:25:17: client0140: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'sys'.'parent' should have at least one table associated
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE TABLE: cannot create persistent table 'tbl' in the schema 'tmp'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE MERGE TABLE: cannot create persistent table 'mtbl' in the schema 'tmp'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!SELECT: no such table 'tmp'.'mtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!MERGE TABLE 'tst'.'mtbl' should have at least one table associated
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: SQLException:sql.alter_table_add_table:42000!ALTER TABLE: a MERGE TABLE can't be a child of itself
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE REPLICA TABLE: cannot create persistent table 'rtbl' in the schema 'tmp'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!SELECT: no such table 'tmp'.'rtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'rtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'tst'.'rtbl' should have at least one table associated
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!REPLICA TABLE 'tst'.'rtbl' should have at least one table associated
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE UNLOGGED TABLE: cannot create persistent table 'utbl' in the schema 'tmp'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!SELECT: no such table 'tmp'.'utbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'utbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!CREATE REMOTE TABLE: cannot create persistent table 'rmtbl' in the schema 'tmp'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!SELECT: no such table 'tmp'.'rmtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'rmtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: IOException:remote.connect:unable to connect to 'mapi:monetdb://localhost:50000/demo': could not create TCP socket: Address family not supported by protocol
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: IllegalArgumentException:remote.put:Illegal argument: connection name is NULL or nil
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: MALException:user.%1[29]:Exception occurred in the remote server, please check the log there
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: IOException:remote.connect:unable to connect to 'mapi:monetdb://localhost:50000/demo': could not create TCP socket: Address family not supported by protocol
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: IllegalArgumentException:remote.put:Illegal argument: connection name is NULL or nil
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: MALException:user.%2[29]:Exception occurred in the remote server, please check the log there
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!CREATE TABLE: local temporary tables should be stored in the 'tmp' schema
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: can't add/drop a temporary table into a MERGE TABLE
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!CREATE TABLE: global temporary tables should be stored in the 'tmp' schema
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42S02!ALTER TABLE: no such table 'tmp'.'mtbl'
#2024-10-03 20:25:17: client0141: createExceptionInternal: ERROR: ParseException:SQLparser:42000!ALTER TABLE: can't add/drop a temporary table into a MERGE TABLE
#2024-10-03 20:25:17: client0142: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead
#2024-10-03 20:25:17: client0145: createExceptionInternal: ERROR: SQLException:sql.commit:40001!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead
#2024-10-03 20:25:17: client0149: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: access denied for kate to table 'sys.allparts'
#2024-10-03 20:25:17: client0149: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: access denied for kate to table 'sys.allparts_2'
#2024-10-03 20:25:17: client0149: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'm' unknown
#2024-10-03 20:25:17: client0150: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'm' unknown