sql\test\prepare standard error

# builtin opt 	gdk_dbpath = C:/cygwin64/home/monet/testing/f8e03e321dba-8-1-1/install/var\monetdb5\dbfarm\demo
# builtin opt 	mapi_port = 50000
# builtin opt 	sql_optimizer = default_pipe
# builtin opt 	sql_debug = 0
# builtin opt 	raw_strings = false
# cmdline opt 	gdk_nr_threads = 0
# cmdline opt 	mapi_listenaddr = all
# cmdline opt 	mapi_port = 0
# cmdline opt 	gdk_dbpath = C:\cygwin64\home\monet\testing\f8e03e321dba-8-1-1\tests\sql\dbfarm\mTests_sql_test_prepare
# cmdline opt 	monet_vault_key = C:\cygwin64\home\monet\testing\f8e03e321dba-8-1-1\tests\sql\dbfarm\mTests_sql_test_prepare\.vaultkey
#2024-04-26 00:38:57: client0029: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Variables cannot be declared on the global scope
#2024-04-26 00:38:57: client0030: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'a' unknown
#2024-04-26 00:38:57: client0031: createExceptionInternal: ERROR: ParseException:SQLparser:42000!syntax error, unexpected IDENT in: "iamerror"
#2024-04-26 00:38:57: client0032: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: identifier 'a' unknown
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: SQLException:sql.execute:42000!Could not determine type for argument number 2
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: ParseException:SQLparser:42000!EXEC called with wrong number of arguments: expected 1, got 0
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: ParseException:SQLparser:42000!EXEC called with wrong number of arguments: expected 0, got 1
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0038: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0040: createExceptionInternal: ERROR: ParseException:SQLparser:42000!EXEC called with wrong number of arguments: expected 1, got 0
#2024-04-26 00:38:58: client0040: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0040: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:58: client0040: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:59: DFLOWworker0007: createExceptionInternal: ERROR: MALException:sample.subuniform:Illegal argument p should be between 0 and 1.0
#2024-04-26 00:38:59: client0044: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SEED: cannot have SEED without SAMPLE
#2024-04-26 00:38:59: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot have a parameter (?) on both sides of an expression
#2024-04-26 00:38:59: client0046: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Could not determine type for argument number 1
#2024-04-26 00:38:59: client0046: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:38:59: client0046: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0072: createExceptionInternal: ERROR: ParseException:SQLparser:22000!Type (hugeint) unknown in: "select cast(1 as hugeint)"
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot have a parameter (?) for group by column
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Could not determine type for argument number 1
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Could not determine type for argument number 1
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot have a parameter (?) for IS NOT NULL operator
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: dblFromStr: ERROR: overflow or not a number
#2024-04-26 00:39:03: client0073: VARconvert: ERROR: 22018!conversion of string 'b' to type dbl failed.
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:calc.dbl:22018!conversion of string 'b' to type dbl failed.
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!types bigint(63,0) and sec_interval(13,0) are not equal
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: with DISTINCT ORDER BY expressions must appear in select list
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot have a parameter (?) for group by column
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot have a parameter (?) for order by column
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: no such table returning function 'idontexist'(?, tinyint)
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Could not determine type for argument number 1
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Could not determine type for argument number 1
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Cannot rewrite subquery because of parameter with unknown type
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Could not determine type for argument number 1
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Query projection must have at least one parameter with known SQL type
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0073: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:03: client0075: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Could not determine type for argument number 1
#2024-04-26 00:39:03: client0076: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:03: client0076: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:04: client0077: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:04: client0079: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:04: client0079: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:04: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:04: client0081: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:04: client0082: convert_sht_int: ERROR: 22003!overflow in conversion to DECIMAL(5,5).
#2024-04-26 00:39:04: client0082: createExceptionInternal: ERROR: SQLException:sht_2_int:22003!overflow in conversion to DECIMAL(5,5).
#2024-04-26 00:39:04: client0082: createExceptionInternal: ERROR: MALException:cache.remove:42000!internal error, symbol missing
#2024-04-26 00:39:05: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:05: client0083: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:05: client0085: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:05: client0085: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:05: client0087: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:05: client0087: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:06: client0090: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:06: client0090: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:06: client0094: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:06: client0094: createExceptionInternal: ERROR: ParseException:SQLparser:3F000!DROP ALL FUNCTION: no such function 'evilfunction'
#2024-04-26 00:39:06: client0094: createExceptionInternal: ERROR: ParseException:SQLparser:42000!SELECT: named placeholder ('banana') but named values list is missing
#2024-04-26 00:39:06: client0094: createExceptionInternal: ERROR: ParseException:SQLparser:42000!Named placeholder ('pear') not used in the query.