2859 Rafal Somla 2009-08-13
Bug #46266 - RESTORE fails on a server with lower_case_table_names=2
This problem was fixed by BUG#43444. Enabling test cases which
previously failed due to this bug. They will act as a regression test.
@ mysql-test/suite/backup/t/backup_xpfm_compat_restore_lctn2.test
Enabling test cases which were previously failing because
of the bug.
modified:
mysql-test/suite/backup/r/backup_xpfm_compat_restore_lctn2.result
mysql-test/suite/backup/t/backup_xpfm_compat_restore_lctn2.test
2858 Rafal Somla 2009-08-11
Bug #42999 - If BACKUP to pipe fails, pipe will be removed
In case BACKUP operation is aborted before completion (e.g., due to an error),
Backup_restore_ctx::close() method removes the backup image file which was
created when backup stream was opened. An exception is backup to a named pipe
which is never created but should exist prior to invoking BACKUP command.
Before this patch, the code did not make exception for named pipes which were
removed like regular files. The patch adds logic for detecting this exception
and correctly handling named pipes.
@ mysql-test/suite/backup/t/backup_pipe.test
Added scenario testing the issue.
@ sql/backup/kernel.cc
In Backup_restore_ctx::close() call Stream::close() or Stream::remove() as appropriate. Move error reporting code into the latter methods.
@ sql/backup/stream.cc
- Make stream methods report status via integer return code, not a bool value.
- Remove unused rewind() methods.
- Move error reporting from kernel.cc to close() methods.
- Implementation of Output_stream::remove() method.
@ sql/backup/stream.h
- Make stream methods report status via integer return code, not a bool value.
- Add remove() method to stream class.
- Delete unused rewind() methods.
modified:
mysql-test/suite/backup/r/backup_pipe.result
mysql-test/suite/backup/t/backup_pipe.test
sql/backup/kernel.cc
sql/backup/stream.cc
sql/backup/stream.h
=== modified file 'mysql-test/suite/backup/r/backup_xpfm_compat_restore_lctn2.result'
--- a/mysql-test/suite/backup/r/backup_xpfm_compat_restore_lctn2.result 2009-07-20 09:27:48 +0000
+++ b/mysql-test/suite/backup/r/backup_xpfm_compat_restore_lctn2.result 2009-08-13 09:34:00 +0000
@@ -10387,11 +10387,7 @@ DROP USER 'BUP_USER2';
DROP USER 'BupUser3'@'%';
DROP USER 'no_user'@'%';
#
-# Not safe to restore lctn2 image on lctn2 server
-# This will change when Bug#46266 (RESTORE fails on a server with
-# lower_case_table_names=2) is fixed.
-#
-# Windows 64 lctn1
+# Windows 32 lctn2
#
DROP DATABASE IF EXISTS bup_xpfm_compat_db1;
DROP DATABASE IF EXISTS BUP_XPFM_COMPAT_DB2;
@@ -10419,7 +10415,7 @@ CREATE USER 'no_user'@'%';
#
# Restore.
#
-RESTORE FROM 'backup_xpfm_compat_lctn1-windows_64.bak' OVERWRITE;
+RESTORE FROM 'backup_xpfm_compat_lctn2-windows_32.bak' OVERWRITE;
backup_id
#
#
@@ -10430,9 +10426,9 @@ FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME like 'bup%xpfm%compat%'
ORDER BY LOWER(SCHEMA_NAME);
SCHEMA_NAME
-bupxpfmcompat_db3
+BupXPfmCompat_db3
bup_xpfm_compat_db1
-bup_xpfm_compat_db2
+BUP_XPFM_COMPAT_DB2
SELECT TABLESPACE_NAME
FROM INFORMATION_SCHEMA.TABLESPACES
WHERE TABLESPACE_NAME like 'bup%xpfm%compat%'
@@ -10444,260 +10440,260 @@ WHERE TABLE_SCHEMA like 'bup%xpfm%compat
AND TABLE_TYPE != 'VIEW'
ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME);
TABLE_SCHEMA TABLE_NAME
-bupxpfmcompat_db3 table1
-bupxpfmcompat_db3 table2
-bupxpfmcompat_db3 table3
+BupXPfmCompat_db3 table1
+BupXPfmCompat_db3 TABLE2
+BupXPfmCompat_db3 TaBle3
bup_xpfm_compat_db1 table1
-bup_xpfm_compat_db1 table2
-bup_xpfm_compat_db1 table3
-bup_xpfm_compat_db2 table1
-bup_xpfm_compat_db2 table2
-bup_xpfm_compat_db2 table3
+bup_xpfm_compat_db1 TABLE2
+bup_xpfm_compat_db1 TaBle3
+BUP_XPFM_COMPAT_DB2 table1
+BUP_XPFM_COMPAT_DB2 TABLE2
+BUP_XPFM_COMPAT_DB2 TaBle3
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA like 'bup%xpfm%compat%'
ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME), LOWER(COLUMN_NAME);
TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH NUMERIC_PRECISION
-bupxpfmcompat_db3 table1 c01 bit NULL 1
-bupxpfmcompat_db3 table1 c02 bit NULL 64
-bupxpfmcompat_db3 table1 c03 tinyint NULL 3
-bupxpfmcompat_db3 table1 c04 tinyint NULL 3
-bupxpfmcompat_db3 table1 c05 tinyint NULL 3
-bupxpfmcompat_db3 table1 c06 tinyint NULL 3
-bupxpfmcompat_db3 table1 c07 smallint NULL 5
-bupxpfmcompat_db3 table1 c08 smallint NULL 5
-bupxpfmcompat_db3 table1 c09 smallint NULL 5
-bupxpfmcompat_db3 table1 c10 mediumint NULL 7
-bupxpfmcompat_db3 table1 c11 mediumint NULL 7
-bupxpfmcompat_db3 table1 c12 mediumint NULL 7
-bupxpfmcompat_db3 table1 c13 int NULL 10
-bupxpfmcompat_db3 table1 c14 int NULL 10
-bupxpfmcompat_db3 table1 c15 int NULL 10
-bupxpfmcompat_db3 table1 c16 bigint NULL 19
-bupxpfmcompat_db3 table1 c17 bigint NULL 19
-bupxpfmcompat_db3 table1 c18 bigint NULL 19
-bupxpfmcompat_db3 table1 c19 float NULL 12
-bupxpfmcompat_db3 table1 c20 float NULL 12
-bupxpfmcompat_db3 table1 c21 float NULL 12
-bupxpfmcompat_db3 table1 c22 double NULL 22
-bupxpfmcompat_db3 table1 c23 double NULL 22
-bupxpfmcompat_db3 table1 c24 double NULL 22
-bupxpfmcompat_db3 table1 c25 decimal NULL 10
-bupxpfmcompat_db3 table1 c26 decimal NULL 10
-bupxpfmcompat_db3 table1 c27 decimal NULL 10
-bupxpfmcompat_db3 table1 c28 date NULL NULL
-bupxpfmcompat_db3 table1 c29 datetime NULL NULL
-bupxpfmcompat_db3 table1 c30 timestamp NULL NULL
-bupxpfmcompat_db3 table1 c31 time NULL NULL
-bupxpfmcompat_db3 table1 c32 year NULL NULL
-bupxpfmcompat_db3 table1 c33 char 1 NULL
-bupxpfmcompat_db3 table1 c34 char 0 NULL
-bupxpfmcompat_db3 table1 c35 char 1 NULL
-bupxpfmcompat_db3 table1 c36 char 255 NULL
-bupxpfmcompat_db3 table1 c37 char 1 NULL
-bupxpfmcompat_db3 table1 c38 char 0 NULL
-bupxpfmcompat_db3 table1 c39 char 1 NULL
-bupxpfmcompat_db3 table1 c40 char 255 NULL
-bupxpfmcompat_db3 table1 c41 char 1 NULL
-bupxpfmcompat_db3 table1 c42 char 0 NULL
-bupxpfmcompat_db3 table1 c43 char 1 NULL
-bupxpfmcompat_db3 table1 c44 char 255 NULL
-bupxpfmcompat_db3 table1 c45 varchar 0 NULL
-bupxpfmcompat_db3 table1 c46 varchar 1 NULL
-bupxpfmcompat_db3 table1 c47 varchar 255 NULL
-bupxpfmcompat_db3 table1 c48 varchar 261 NULL
-bupxpfmcompat_db3 table1 c49 varchar 0 NULL
-bupxpfmcompat_db3 table1 c50 varchar 1 NULL
-bupxpfmcompat_db3 table1 c51 varchar 255 NULL
-bupxpfmcompat_db3 table1 c52 varchar 261 NULL
-bupxpfmcompat_db3 table1 c53 varchar 0 NULL
-bupxpfmcompat_db3 table1 c54 varchar 1 NULL
-bupxpfmcompat_db3 table1 c55 varchar 255 NULL
-bupxpfmcompat_db3 table1 c56 varchar 261 NULL
-bupxpfmcompat_db3 table1 c57 binary 1 NULL
-bupxpfmcompat_db3 table1 c58 binary 0 NULL
-bupxpfmcompat_db3 table1 c59 binary 1 NULL
-bupxpfmcompat_db3 table1 c60 binary 255 NULL
-bupxpfmcompat_db3 table1 c61 varbinary 0 NULL
-bupxpfmcompat_db3 table1 c62 varbinary 1 NULL
-bupxpfmcompat_db3 table1 c63 varbinary 255 NULL
-bupxpfmcompat_db3 table1 c64 varbinary 261 NULL
-bupxpfmcompat_db3 table1 c65 tinyblob 255 NULL
-bupxpfmcompat_db3 table1 c66 tinytext 255 NULL
-bupxpfmcompat_db3 table1 c67 tinytext 127 NULL
-bupxpfmcompat_db3 table1 c68 blob 65535 NULL
-bupxpfmcompat_db3 table1 c69 text 65535 NULL
-bupxpfmcompat_db3 table1 c70 text 32767 NULL
-bupxpfmcompat_db3 table1 c71 mediumblob 16777215 NULL
-bupxpfmcompat_db3 table1 c72 mediumtext 16777215 NULL
-bupxpfmcompat_db3 table1 c73 mediumtext 8388607 NULL
-bupxpfmcompat_db3 table1 c74 longblob 4294967295 NULL
-bupxpfmcompat_db3 table1 c75 longtext 4294967295 NULL
-bupxpfmcompat_db3 table1 c76 longtext 2147483647 NULL
-bupxpfmcompat_db3 table1 c77 enum 1 NULL
-bupxpfmcompat_db3 table1 c78 set 5 NULL
-bupxpfmcompat_db3 table1 crn int NULL 10
-bupxpfmcompat_db3 table2 c01 bit NULL 1
-bupxpfmcompat_db3 table2 c02 bit NULL 64
-bupxpfmcompat_db3 table2 c03 tinyint NULL 3
-bupxpfmcompat_db3 table2 c04 tinyint NULL 3
-bupxpfmcompat_db3 table2 c05 tinyint NULL 3
-bupxpfmcompat_db3 table2 c06 tinyint NULL 3
-bupxpfmcompat_db3 table2 c07 smallint NULL 5
-bupxpfmcompat_db3 table2 c08 smallint NULL 5
-bupxpfmcompat_db3 table2 c09 smallint NULL 5
-bupxpfmcompat_db3 table2 c10 mediumint NULL 7
-bupxpfmcompat_db3 table2 c11 mediumint NULL 7
-bupxpfmcompat_db3 table2 c12 mediumint NULL 7
-bupxpfmcompat_db3 table2 c13 int NULL 10
-bupxpfmcompat_db3 table2 c14 int NULL 10
-bupxpfmcompat_db3 table2 c15 int NULL 10
-bupxpfmcompat_db3 table2 c16 bigint NULL 19
-bupxpfmcompat_db3 table2 c17 bigint NULL 19
-bupxpfmcompat_db3 table2 c18 bigint NULL 19
-bupxpfmcompat_db3 table2 c19 float NULL 12
-bupxpfmcompat_db3 table2 c20 float NULL 12
-bupxpfmcompat_db3 table2 c21 float NULL 12
-bupxpfmcompat_db3 table2 c22 double NULL 22
-bupxpfmcompat_db3 table2 c23 double NULL 22
-bupxpfmcompat_db3 table2 c24 double NULL 22
-bupxpfmcompat_db3 table2 c25 decimal NULL 10
-bupxpfmcompat_db3 table2 c26 decimal NULL 10
-bupxpfmcompat_db3 table2 c27 decimal NULL 10
-bupxpfmcompat_db3 table2 c28 date NULL NULL
-bupxpfmcompat_db3 table2 c29 datetime NULL NULL
-bupxpfmcompat_db3 table2 c30 timestamp NULL NULL
-bupxpfmcompat_db3 table2 c31 time NULL NULL
-bupxpfmcompat_db3 table2 c32 year NULL NULL
-bupxpfmcompat_db3 table2 c33 char 1 NULL
-bupxpfmcompat_db3 table2 c34 char 0 NULL
-bupxpfmcompat_db3 table2 c35 char 1 NULL
-bupxpfmcompat_db3 table2 c36 char 255 NULL
-bupxpfmcompat_db3 table2 c37 char 1 NULL
-bupxpfmcompat_db3 table2 c38 char 0 NULL
-bupxpfmcompat_db3 table2 c39 char 1 NULL
-bupxpfmcompat_db3 table2 c40 char 255 NULL
-bupxpfmcompat_db3 table2 c41 char 1 NULL
-bupxpfmcompat_db3 table2 c42 char 0 NULL
-bupxpfmcompat_db3 table2 c43 char 1 NULL
-bupxpfmcompat_db3 table2 c44 char 255 NULL
-bupxpfmcompat_db3 table2 c45 varchar 0 NULL
-bupxpfmcompat_db3 table2 c46 varchar 1 NULL
-bupxpfmcompat_db3 table2 c47 varchar 255 NULL
-bupxpfmcompat_db3 table2 c48 varchar 261 NULL
-bupxpfmcompat_db3 table2 c49 varchar 0 NULL
-bupxpfmcompat_db3 table2 c50 varchar 1 NULL
-bupxpfmcompat_db3 table2 c51 varchar 255 NULL
-bupxpfmcompat_db3 table2 c52 varchar 261 NULL
-bupxpfmcompat_db3 table2 c53 varchar 0 NULL
-bupxpfmcompat_db3 table2 c54 varchar 1 NULL
-bupxpfmcompat_db3 table2 c55 varchar 255 NULL
-bupxpfmcompat_db3 table2 c56 varchar 261 NULL
-bupxpfmcompat_db3 table2 c57 binary 1 NULL
-bupxpfmcompat_db3 table2 c58 binary 0 NULL
-bupxpfmcompat_db3 table2 c59 binary 1 NULL
-bupxpfmcompat_db3 table2 c60 binary 255 NULL
-bupxpfmcompat_db3 table2 c61 varbinary 0 NULL
-bupxpfmcompat_db3 table2 c62 varbinary 1 NULL
-bupxpfmcompat_db3 table2 c63 varbinary 255 NULL
-bupxpfmcompat_db3 table2 c64 varbinary 261 NULL
-bupxpfmcompat_db3 table2 c65 tinyblob 255 NULL
-bupxpfmcompat_db3 table2 c66 tinytext 255 NULL
-bupxpfmcompat_db3 table2 c67 tinytext 127 NULL
-bupxpfmcompat_db3 table2 c68 blob 65535 NULL
-bupxpfmcompat_db3 table2 c69 text 65535 NULL
-bupxpfmcompat_db3 table2 c70 text 32767 NULL
-bupxpfmcompat_db3 table2 c71 mediumblob 16777215 NULL
-bupxpfmcompat_db3 table2 c72 mediumtext 16777215 NULL
-bupxpfmcompat_db3 table2 c73 mediumtext 8388607 NULL
-bupxpfmcompat_db3 table2 c74 longblob 4294967295 NULL
-bupxpfmcompat_db3 table2 c75 longtext 4294967295 NULL
-bupxpfmcompat_db3 table2 c76 longtext 2147483647 NULL
-bupxpfmcompat_db3 table2 c77 enum 1 NULL
-bupxpfmcompat_db3 table2 c78 set 5 NULL
-bupxpfmcompat_db3 table2 crn int NULL 10
-bupxpfmcompat_db3 table3 c01 bit NULL 1
-bupxpfmcompat_db3 table3 c02 bit NULL 64
-bupxpfmcompat_db3 table3 c03 tinyint NULL 3
-bupxpfmcompat_db3 table3 c04 tinyint NULL 3
-bupxpfmcompat_db3 table3 c05 tinyint NULL 3
-bupxpfmcompat_db3 table3 c06 tinyint NULL 3
-bupxpfmcompat_db3 table3 c07 smallint NULL 5
-bupxpfmcompat_db3 table3 c08 smallint NULL 5
-bupxpfmcompat_db3 table3 c09 smallint NULL 5
-bupxpfmcompat_db3 table3 c10 mediumint NULL 7
-bupxpfmcompat_db3 table3 c11 mediumint NULL 7
-bupxpfmcompat_db3 table3 c12 mediumint NULL 7
-bupxpfmcompat_db3 table3 c13 int NULL 10
-bupxpfmcompat_db3 table3 c14 int NULL 10
-bupxpfmcompat_db3 table3 c15 int NULL 10
-bupxpfmcompat_db3 table3 c16 bigint NULL 19
-bupxpfmcompat_db3 table3 c17 bigint NULL 19
-bupxpfmcompat_db3 table3 c18 bigint NULL 19
-bupxpfmcompat_db3 table3 c19 float NULL 12
-bupxpfmcompat_db3 table3 c20 float NULL 12
-bupxpfmcompat_db3 table3 c21 float NULL 12
-bupxpfmcompat_db3 table3 c22 double NULL 22
-bupxpfmcompat_db3 table3 c23 double NULL 22
-bupxpfmcompat_db3 table3 c24 double NULL 22
-bupxpfmcompat_db3 table3 c25 decimal NULL 10
-bupxpfmcompat_db3 table3 c26 decimal NULL 10
-bupxpfmcompat_db3 table3 c27 decimal NULL 10
-bupxpfmcompat_db3 table3 c28 date NULL NULL
-bupxpfmcompat_db3 table3 c29 datetime NULL NULL
-bupxpfmcompat_db3 table3 c30 timestamp NULL NULL
-bupxpfmcompat_db3 table3 c31 time NULL NULL
-bupxpfmcompat_db3 table3 c32 year NULL NULL
-bupxpfmcompat_db3 table3 c33 char 1 NULL
-bupxpfmcompat_db3 table3 c34 char 0 NULL
-bupxpfmcompat_db3 table3 c35 char 1 NULL
-bupxpfmcompat_db3 table3 c36 char 255 NULL
-bupxpfmcompat_db3 table3 c37 char 1 NULL
-bupxpfmcompat_db3 table3 c38 char 0 NULL
-bupxpfmcompat_db3 table3 c39 char 1 NULL
-bupxpfmcompat_db3 table3 c40 char 255 NULL
-bupxpfmcompat_db3 table3 c41 char 1 NULL
-bupxpfmcompat_db3 table3 c42 char 0 NULL
-bupxpfmcompat_db3 table3 c43 char 1 NULL
-bupxpfmcompat_db3 table3 c44 char 255 NULL
-bupxpfmcompat_db3 table3 c45 varchar 0 NULL
-bupxpfmcompat_db3 table3 c46 varchar 1 NULL
-bupxpfmcompat_db3 table3 c47 varchar 255 NULL
-bupxpfmcompat_db3 table3 c48 varchar 261 NULL
-bupxpfmcompat_db3 table3 c49 varchar 0 NULL
-bupxpfmcompat_db3 table3 c50 varchar 1 NULL
-bupxpfmcompat_db3 table3 c51 varchar 255 NULL
-bupxpfmcompat_db3 table3 c52 varchar 261 NULL
-bupxpfmcompat_db3 table3 c53 varchar 0 NULL
-bupxpfmcompat_db3 table3 c54 varchar 1 NULL
-bupxpfmcompat_db3 table3 c55 varchar 255 NULL
-bupxpfmcompat_db3 table3 c56 varchar 261 NULL
-bupxpfmcompat_db3 table3 c57 binary 1 NULL
-bupxpfmcompat_db3 table3 c58 binary 0 NULL
-bupxpfmcompat_db3 table3 c59 binary 1 NULL
-bupxpfmcompat_db3 table3 c60 binary 255 NULL
-bupxpfmcompat_db3 table3 c61 varbinary 0 NULL
-bupxpfmcompat_db3 table3 c62 varbinary 1 NULL
-bupxpfmcompat_db3 table3 c63 varbinary 255 NULL
-bupxpfmcompat_db3 table3 c64 varbinary 261 NULL
-bupxpfmcompat_db3 table3 c65 tinyblob 255 NULL
-bupxpfmcompat_db3 table3 c66 tinytext 255 NULL
-bupxpfmcompat_db3 table3 c67 tinytext 127 NULL
-bupxpfmcompat_db3 table3 c68 blob 65535 NULL
-bupxpfmcompat_db3 table3 c69 text 65535 NULL
-bupxpfmcompat_db3 table3 c70 text 32767 NULL
-bupxpfmcompat_db3 table3 c71 mediumblob 16777215 NULL
-bupxpfmcompat_db3 table3 c72 mediumtext 16777215 NULL
-bupxpfmcompat_db3 table3 c73 mediumtext 8388607 NULL
-bupxpfmcompat_db3 table3 c74 longblob 4294967295 NULL
-bupxpfmcompat_db3 table3 c75 longtext 4294967295 NULL
-bupxpfmcompat_db3 table3 c76 longtext 2147483647 NULL
-bupxpfmcompat_db3 table3 c77 enum 1 NULL
-bupxpfmcompat_db3 table3 c78 set 5 NULL
-bupxpfmcompat_db3 table3 crn int NULL 10
-bupxpfmcompat_db3 view1 c1 int NULL 10
-bupxpfmcompat_db3 view1 c2 int NULL 10
+BupXPfmCompat_db3 table1 c01 bit NULL 1
+BupXPfmCompat_db3 table1 c02 bit NULL 64
+BupXPfmCompat_db3 table1 c03 tinyint NULL 3
+BupXPfmCompat_db3 table1 c04 tinyint NULL 3
+BupXPfmCompat_db3 table1 c05 tinyint NULL 3
+BupXPfmCompat_db3 table1 c06 tinyint NULL 3
+BupXPfmCompat_db3 table1 c07 smallint NULL 5
+BupXPfmCompat_db3 table1 c08 smallint NULL 5
+BupXPfmCompat_db3 table1 c09 smallint NULL 5
+BupXPfmCompat_db3 table1 c10 mediumint NULL 7
+BupXPfmCompat_db3 table1 c11 mediumint NULL 7
+BupXPfmCompat_db3 table1 c12 mediumint NULL 7
+BupXPfmCompat_db3 table1 c13 int NULL 10
+BupXPfmCompat_db3 table1 c14 int NULL 10
+BupXPfmCompat_db3 table1 c15 int NULL 10
+BupXPfmCompat_db3 table1 c16 bigint NULL 19
+BupXPfmCompat_db3 table1 c17 bigint NULL 19
+BupXPfmCompat_db3 table1 c18 bigint NULL 19
+BupXPfmCompat_db3 table1 c19 float NULL 12
+BupXPfmCompat_db3 table1 c20 float NULL 12
+BupXPfmCompat_db3 table1 c21 float NULL 12
+BupXPfmCompat_db3 table1 c22 double NULL 22
+BupXPfmCompat_db3 table1 c23 double NULL 22
+BupXPfmCompat_db3 table1 c24 double NULL 22
+BupXPfmCompat_db3 table1 c25 decimal NULL 10
+BupXPfmCompat_db3 table1 c26 decimal NULL 10
+BupXPfmCompat_db3 table1 c27 decimal NULL 10
+BupXPfmCompat_db3 table1 c28 date NULL NULL
+BupXPfmCompat_db3 table1 c29 datetime NULL NULL
+BupXPfmCompat_db3 table1 c30 timestamp NULL NULL
+BupXPfmCompat_db3 table1 c31 time NULL NULL
+BupXPfmCompat_db3 table1 c32 year NULL NULL
+BupXPfmCompat_db3 table1 c33 char 1 NULL
+BupXPfmCompat_db3 table1 c34 char 0 NULL
+BupXPfmCompat_db3 table1 c35 char 1 NULL
+BupXPfmCompat_db3 table1 c36 char 255 NULL
+BupXPfmCompat_db3 table1 c37 char 1 NULL
+BupXPfmCompat_db3 table1 c38 char 0 NULL
+BupXPfmCompat_db3 table1 c39 char 1 NULL
+BupXPfmCompat_db3 table1 c40 char 255 NULL
+BupXPfmCompat_db3 table1 c41 char 1 NULL
+BupXPfmCompat_db3 table1 c42 char 0 NULL
+BupXPfmCompat_db3 table1 c43 char 1 NULL
+BupXPfmCompat_db3 table1 c44 char 255 NULL
+BupXPfmCompat_db3 table1 c45 varchar 0 NULL
+BupXPfmCompat_db3 table1 c46 varchar 1 NULL
+BupXPfmCompat_db3 table1 c47 varchar 255 NULL
+BupXPfmCompat_db3 table1 c48 varchar 261 NULL
+BupXPfmCompat_db3 table1 c49 varchar 0 NULL
+BupXPfmCompat_db3 table1 c50 varchar 1 NULL
+BupXPfmCompat_db3 table1 c51 varchar 255 NULL
+BupXPfmCompat_db3 table1 c52 varchar 261 NULL
+BupXPfmCompat_db3 table1 c53 varchar 0 NULL
+BupXPfmCompat_db3 table1 c54 varchar 1 NULL
+BupXPfmCompat_db3 table1 c55 varchar 255 NULL
+BupXPfmCompat_db3 table1 c56 varchar 261 NULL
+BupXPfmCompat_db3 table1 c57 binary 1 NULL
+BupXPfmCompat_db3 table1 c58 binary 0 NULL
+BupXPfmCompat_db3 table1 c59 binary 1 NULL
+BupXPfmCompat_db3 table1 c60 binary 255 NULL
+BupXPfmCompat_db3 table1 c61 varbinary 0 NULL
+BupXPfmCompat_db3 table1 c62 varbinary 1 NULL
+BupXPfmCompat_db3 table1 c63 varbinary 255 NULL
+BupXPfmCompat_db3 table1 c64 varbinary 261 NULL
+BupXPfmCompat_db3 table1 c65 tinyblob 255 NULL
+BupXPfmCompat_db3 table1 c66 tinytext 255 NULL
+BupXPfmCompat_db3 table1 c67 tinytext 127 NULL
+BupXPfmCompat_db3 table1 c68 blob 65535 NULL
+BupXPfmCompat_db3 table1 c69 text 65535 NULL
+BupXPfmCompat_db3 table1 c70 text 32767 NULL
+BupXPfmCompat_db3 table1 c71 mediumblob 16777215 NULL
+BupXPfmCompat_db3 table1 c72 mediumtext 16777215 NULL
+BupXPfmCompat_db3 table1 c73 mediumtext 8388607 NULL
+BupXPfmCompat_db3 table1 c74 longblob 4294967295 NULL
+BupXPfmCompat_db3 table1 c75 longtext 4294967295 NULL
+BupXPfmCompat_db3 table1 c76 longtext 2147483647 NULL
+BupXPfmCompat_db3 table1 c77 enum 1 NULL
+BupXPfmCompat_db3 table1 c78 set 5 NULL
+BupXPfmCompat_db3 table1 crn int NULL 10
+BupXPfmCompat_db3 TABLE2 c01 bit NULL 1
+BupXPfmCompat_db3 TABLE2 c02 bit NULL 64
+BupXPfmCompat_db3 TABLE2 c03 tinyint NULL 3
+BupXPfmCompat_db3 TABLE2 c04 tinyint NULL 3
+BupXPfmCompat_db3 TABLE2 c05 tinyint NULL 3
+BupXPfmCompat_db3 TABLE2 c06 tinyint NULL 3
+BupXPfmCompat_db3 TABLE2 c07 smallint NULL 5
+BupXPfmCompat_db3 TABLE2 c08 smallint NULL 5
+BupXPfmCompat_db3 TABLE2 c09 smallint NULL 5
+BupXPfmCompat_db3 TABLE2 c10 mediumint NULL 7
+BupXPfmCompat_db3 TABLE2 c11 mediumint NULL 7
+BupXPfmCompat_db3 TABLE2 c12 mediumint NULL 7
+BupXPfmCompat_db3 TABLE2 c13 int NULL 10
+BupXPfmCompat_db3 TABLE2 c14 int NULL 10
+BupXPfmCompat_db3 TABLE2 c15 int NULL 10
+BupXPfmCompat_db3 TABLE2 c16 bigint NULL 19
+BupXPfmCompat_db3 TABLE2 c17 bigint NULL 19
+BupXPfmCompat_db3 TABLE2 c18 bigint NULL 19
+BupXPfmCompat_db3 TABLE2 c19 float NULL 12
+BupXPfmCompat_db3 TABLE2 c20 float NULL 12
+BupXPfmCompat_db3 TABLE2 c21 float NULL 12
+BupXPfmCompat_db3 TABLE2 c22 double NULL 22
+BupXPfmCompat_db3 TABLE2 c23 double NULL 22
+BupXPfmCompat_db3 TABLE2 c24 double NULL 22
+BupXPfmCompat_db3 TABLE2 c25 decimal NULL 10
+BupXPfmCompat_db3 TABLE2 c26 decimal NULL 10
+BupXPfmCompat_db3 TABLE2 c27 decimal NULL 10
+BupXPfmCompat_db3 TABLE2 c28 date NULL NULL
+BupXPfmCompat_db3 TABLE2 c29 datetime NULL NULL
+BupXPfmCompat_db3 TABLE2 c30 timestamp NULL NULL
+BupXPfmCompat_db3 TABLE2 c31 time NULL NULL
+BupXPfmCompat_db3 TABLE2 c32 year NULL NULL
+BupXPfmCompat_db3 TABLE2 c33 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c34 char 0 NULL
+BupXPfmCompat_db3 TABLE2 c35 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c36 char 255 NULL
+BupXPfmCompat_db3 TABLE2 c37 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c38 char 0 NULL
+BupXPfmCompat_db3 TABLE2 c39 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c40 char 255 NULL
+BupXPfmCompat_db3 TABLE2 c41 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c42 char 0 NULL
+BupXPfmCompat_db3 TABLE2 c43 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c44 char 255 NULL
+BupXPfmCompat_db3 TABLE2 c45 varchar 0 NULL
+BupXPfmCompat_db3 TABLE2 c46 varchar 1 NULL
+BupXPfmCompat_db3 TABLE2 c47 varchar 255 NULL
+BupXPfmCompat_db3 TABLE2 c48 varchar 261 NULL
+BupXPfmCompat_db3 TABLE2 c49 varchar 0 NULL
+BupXPfmCompat_db3 TABLE2 c50 varchar 1 NULL
+BupXPfmCompat_db3 TABLE2 c51 varchar 255 NULL
+BupXPfmCompat_db3 TABLE2 c52 varchar 261 NULL
+BupXPfmCompat_db3 TABLE2 c53 varchar 0 NULL
+BupXPfmCompat_db3 TABLE2 c54 varchar 1 NULL
+BupXPfmCompat_db3 TABLE2 c55 varchar 255 NULL
+BupXPfmCompat_db3 TABLE2 c56 varchar 261 NULL
+BupXPfmCompat_db3 TABLE2 c57 binary 1 NULL
+BupXPfmCompat_db3 TABLE2 c58 binary 0 NULL
+BupXPfmCompat_db3 TABLE2 c59 binary 1 NULL
+BupXPfmCompat_db3 TABLE2 c60 binary 255 NULL
+BupXPfmCompat_db3 TABLE2 c61 varbinary 0 NULL
+BupXPfmCompat_db3 TABLE2 c62 varbinary 1 NULL
+BupXPfmCompat_db3 TABLE2 c63 varbinary 255 NULL
+BupXPfmCompat_db3 TABLE2 c64 varbinary 261 NULL
+BupXPfmCompat_db3 TABLE2 c65 tinyblob 255 NULL
+BupXPfmCompat_db3 TABLE2 c66 tinytext 255 NULL
+BupXPfmCompat_db3 TABLE2 c67 tinytext 127 NULL
+BupXPfmCompat_db3 TABLE2 c68 blob 65535 NULL
+BupXPfmCompat_db3 TABLE2 c69 text 65535 NULL
+BupXPfmCompat_db3 TABLE2 c70 text 32767 NULL
+BupXPfmCompat_db3 TABLE2 c71 mediumblob 16777215 NULL
+BupXPfmCompat_db3 TABLE2 c72 mediumtext 16777215 NULL
+BupXPfmCompat_db3 TABLE2 c73 mediumtext 8388607 NULL
+BupXPfmCompat_db3 TABLE2 c74 longblob 4294967295 NULL
+BupXPfmCompat_db3 TABLE2 c75 longtext 4294967295 NULL
+BupXPfmCompat_db3 TABLE2 c76 longtext 2147483647 NULL
+BupXPfmCompat_db3 TABLE2 c77 enum 1 NULL
+BupXPfmCompat_db3 TABLE2 c78 set 5 NULL
+BupXPfmCompat_db3 TABLE2 crn int NULL 10
+BupXPfmCompat_db3 TaBle3 c01 bit NULL 1
+BupXPfmCompat_db3 TaBle3 c02 bit NULL 64
+BupXPfmCompat_db3 TaBle3 c03 tinyint NULL 3
+BupXPfmCompat_db3 TaBle3 c04 tinyint NULL 3
+BupXPfmCompat_db3 TaBle3 c05 tinyint NULL 3
+BupXPfmCompat_db3 TaBle3 c06 tinyint NULL 3
+BupXPfmCompat_db3 TaBle3 c07 smallint NULL 5
+BupXPfmCompat_db3 TaBle3 c08 smallint NULL 5
+BupXPfmCompat_db3 TaBle3 c09 smallint NULL 5
+BupXPfmCompat_db3 TaBle3 c10 mediumint NULL 7
+BupXPfmCompat_db3 TaBle3 c11 mediumint NULL 7
+BupXPfmCompat_db3 TaBle3 c12 mediumint NULL 7
+BupXPfmCompat_db3 TaBle3 c13 int NULL 10
+BupXPfmCompat_db3 TaBle3 c14 int NULL 10
+BupXPfmCompat_db3 TaBle3 c15 int NULL 10
+BupXPfmCompat_db3 TaBle3 c16 bigint NULL 19
+BupXPfmCompat_db3 TaBle3 c17 bigint NULL 19
+BupXPfmCompat_db3 TaBle3 c18 bigint NULL 19
+BupXPfmCompat_db3 TaBle3 c19 float NULL 12
+BupXPfmCompat_db3 TaBle3 c20 float NULL 12
+BupXPfmCompat_db3 TaBle3 c21 float NULL 12
+BupXPfmCompat_db3 TaBle3 c22 double NULL 22
+BupXPfmCompat_db3 TaBle3 c23 double NULL 22
+BupXPfmCompat_db3 TaBle3 c24 double NULL 22
+BupXPfmCompat_db3 TaBle3 c25 decimal NULL 10
+BupXPfmCompat_db3 TaBle3 c26 decimal NULL 10
+BupXPfmCompat_db3 TaBle3 c27 decimal NULL 10
+BupXPfmCompat_db3 TaBle3 c28 date NULL NULL
+BupXPfmCompat_db3 TaBle3 c29 datetime NULL NULL
+BupXPfmCompat_db3 TaBle3 c30 timestamp NULL NULL
+BupXPfmCompat_db3 TaBle3 c31 time NULL NULL
+BupXPfmCompat_db3 TaBle3 c32 year NULL NULL
+BupXPfmCompat_db3 TaBle3 c33 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c34 char 0 NULL
+BupXPfmCompat_db3 TaBle3 c35 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c36 char 255 NULL
+BupXPfmCompat_db3 TaBle3 c37 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c38 char 0 NULL
+BupXPfmCompat_db3 TaBle3 c39 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c40 char 255 NULL
+BupXPfmCompat_db3 TaBle3 c41 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c42 char 0 NULL
+BupXPfmCompat_db3 TaBle3 c43 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c44 char 255 NULL
+BupXPfmCompat_db3 TaBle3 c45 varchar 0 NULL
+BupXPfmCompat_db3 TaBle3 c46 varchar 1 NULL
+BupXPfmCompat_db3 TaBle3 c47 varchar 255 NULL
+BupXPfmCompat_db3 TaBle3 c48 varchar 261 NULL
+BupXPfmCompat_db3 TaBle3 c49 varchar 0 NULL
+BupXPfmCompat_db3 TaBle3 c50 varchar 1 NULL
+BupXPfmCompat_db3 TaBle3 c51 varchar 255 NULL
+BupXPfmCompat_db3 TaBle3 c52 varchar 261 NULL
+BupXPfmCompat_db3 TaBle3 c53 varchar 0 NULL
+BupXPfmCompat_db3 TaBle3 c54 varchar 1 NULL
+BupXPfmCompat_db3 TaBle3 c55 varchar 255 NULL
+BupXPfmCompat_db3 TaBle3 c56 varchar 261 NULL
+BupXPfmCompat_db3 TaBle3 c57 binary 1 NULL
+BupXPfmCompat_db3 TaBle3 c58 binary 0 NULL
+BupXPfmCompat_db3 TaBle3 c59 binary 1 NULL
+BupXPfmCompat_db3 TaBle3 c60 binary 255 NULL
+BupXPfmCompat_db3 TaBle3 c61 varbinary 0 NULL
+BupXPfmCompat_db3 TaBle3 c62 varbinary 1 NULL
+BupXPfmCompat_db3 TaBle3 c63 varbinary 255 NULL
+BupXPfmCompat_db3 TaBle3 c64 varbinary 261 NULL
+BupXPfmCompat_db3 TaBle3 c65 tinyblob 255 NULL
+BupXPfmCompat_db3 TaBle3 c66 tinytext 255 NULL
+BupXPfmCompat_db3 TaBle3 c67 tinytext 127 NULL
+BupXPfmCompat_db3 TaBle3 c68 blob 65535 NULL
+BupXPfmCompat_db3 TaBle3 c69 text 65535 NULL
+BupXPfmCompat_db3 TaBle3 c70 text 32767 NULL
+BupXPfmCompat_db3 TaBle3 c71 mediumblob 16777215 NULL
+BupXPfmCompat_db3 TaBle3 c72 mediumtext 16777215 NULL
+BupXPfmCompat_db3 TaBle3 c73 mediumtext 8388607 NULL
+BupXPfmCompat_db3 TaBle3 c74 longblob 4294967295 NULL
+BupXPfmCompat_db3 TaBle3 c75 longtext 4294967295 NULL
+BupXPfmCompat_db3 TaBle3 c76 longtext 2147483647 NULL
+BupXPfmCompat_db3 TaBle3 c77 enum 1 NULL
+BupXPfmCompat_db3 TaBle3 c78 set 5 NULL
+BupXPfmCompat_db3 TaBle3 crn int NULL 10
+BupXPfmCompat_db3 view1 c1 int NULL 10
+BupXPfmCompat_db3 view1 c2 int NULL 10
bupxpfmcompat_db3 view2 c1 int NULL 10
bupxpfmcompat_db3 view2 c2 int NULL 10
bupxpfmcompat_db3 view3 c1 int NULL 10
@@ -10781,164 +10777,164 @@ bup_xpfm_compat_db1 table1 c76 longtext
bup_xpfm_compat_db1 table1 c77 enum 1 NULL
bup_xpfm_compat_db1 table1 c78 set 5 NULL
bup_xpfm_compat_db1 table1 crn int NULL 10
-bup_xpfm_compat_db1 table2 c01 bit NULL 1
-bup_xpfm_compat_db1 table2 c02 bit NULL 64
-bup_xpfm_compat_db1 table2 c03 tinyint NULL 3
-bup_xpfm_compat_db1 table2 c04 tinyint NULL 3
-bup_xpfm_compat_db1 table2 c05 tinyint NULL 3
-bup_xpfm_compat_db1 table2 c06 tinyint NULL 3
-bup_xpfm_compat_db1 table2 c07 smallint NULL 5
-bup_xpfm_compat_db1 table2 c08 smallint NULL 5
-bup_xpfm_compat_db1 table2 c09 smallint NULL 5
-bup_xpfm_compat_db1 table2 c10 mediumint NULL 7
-bup_xpfm_compat_db1 table2 c11 mediumint NULL 7
-bup_xpfm_compat_db1 table2 c12 mediumint NULL 7
-bup_xpfm_compat_db1 table2 c13 int NULL 10
-bup_xpfm_compat_db1 table2 c14 int NULL 10
-bup_xpfm_compat_db1 table2 c15 int NULL 10
-bup_xpfm_compat_db1 table2 c16 bigint NULL 19
-bup_xpfm_compat_db1 table2 c17 bigint NULL 19
-bup_xpfm_compat_db1 table2 c18 bigint NULL 19
-bup_xpfm_compat_db1 table2 c19 float NULL 12
-bup_xpfm_compat_db1 table2 c20 float NULL 12
-bup_xpfm_compat_db1 table2 c21 float NULL 12
-bup_xpfm_compat_db1 table2 c22 double NULL 22
-bup_xpfm_compat_db1 table2 c23 double NULL 22
-bup_xpfm_compat_db1 table2 c24 double NULL 22
-bup_xpfm_compat_db1 table2 c25 decimal NULL 10
-bup_xpfm_compat_db1 table2 c26 decimal NULL 10
-bup_xpfm_compat_db1 table2 c27 decimal NULL 10
-bup_xpfm_compat_db1 table2 c28 date NULL NULL
-bup_xpfm_compat_db1 table2 c29 datetime NULL NULL
-bup_xpfm_compat_db1 table2 c30 timestamp NULL NULL
-bup_xpfm_compat_db1 table2 c31 time NULL NULL
-bup_xpfm_compat_db1 table2 c32 year NULL NULL
-bup_xpfm_compat_db1 table2 c33 char 1 NULL
-bup_xpfm_compat_db1 table2 c34 char 0 NULL
-bup_xpfm_compat_db1 table2 c35 char 1 NULL
-bup_xpfm_compat_db1 table2 c36 char 255 NULL
-bup_xpfm_compat_db1 table2 c37 char 1 NULL
-bup_xpfm_compat_db1 table2 c38 char 0 NULL
-bup_xpfm_compat_db1 table2 c39 char 1 NULL
-bup_xpfm_compat_db1 table2 c40 char 255 NULL
-bup_xpfm_compat_db1 table2 c41 char 1 NULL
-bup_xpfm_compat_db1 table2 c42 char 0 NULL
-bup_xpfm_compat_db1 table2 c43 char 1 NULL
-bup_xpfm_compat_db1 table2 c44 char 255 NULL
-bup_xpfm_compat_db1 table2 c45 varchar 0 NULL
-bup_xpfm_compat_db1 table2 c46 varchar 1 NULL
-bup_xpfm_compat_db1 table2 c47 varchar 255 NULL
-bup_xpfm_compat_db1 table2 c48 varchar 261 NULL
-bup_xpfm_compat_db1 table2 c49 varchar 0 NULL
-bup_xpfm_compat_db1 table2 c50 varchar 1 NULL
-bup_xpfm_compat_db1 table2 c51 varchar 255 NULL
-bup_xpfm_compat_db1 table2 c52 varchar 261 NULL
-bup_xpfm_compat_db1 table2 c53 varchar 0 NULL
-bup_xpfm_compat_db1 table2 c54 varchar 1 NULL
-bup_xpfm_compat_db1 table2 c55 varchar 255 NULL
-bup_xpfm_compat_db1 table2 c56 varchar 261 NULL
-bup_xpfm_compat_db1 table2 c57 binary 1 NULL
-bup_xpfm_compat_db1 table2 c58 binary 0 NULL
-bup_xpfm_compat_db1 table2 c59 binary 1 NULL
-bup_xpfm_compat_db1 table2 c60 binary 255 NULL
-bup_xpfm_compat_db1 table2 c61 varbinary 0 NULL
-bup_xpfm_compat_db1 table2 c62 varbinary 1 NULL
-bup_xpfm_compat_db1 table2 c63 varbinary 255 NULL
-bup_xpfm_compat_db1 table2 c64 varbinary 261 NULL
-bup_xpfm_compat_db1 table2 c65 tinyblob 255 NULL
-bup_xpfm_compat_db1 table2 c66 tinytext 255 NULL
-bup_xpfm_compat_db1 table2 c67 tinytext 127 NULL
-bup_xpfm_compat_db1 table2 c68 blob 65535 NULL
-bup_xpfm_compat_db1 table2 c69 text 65535 NULL
-bup_xpfm_compat_db1 table2 c70 text 32767 NULL
-bup_xpfm_compat_db1 table2 c71 mediumblob 16777215 NULL
-bup_xpfm_compat_db1 table2 c72 mediumtext 16777215 NULL
-bup_xpfm_compat_db1 table2 c73 mediumtext 8388607 NULL
-bup_xpfm_compat_db1 table2 c74 longblob 4294967295 NULL
-bup_xpfm_compat_db1 table2 c75 longtext 4294967295 NULL
-bup_xpfm_compat_db1 table2 c76 longtext 2147483647 NULL
-bup_xpfm_compat_db1 table2 c77 enum 1 NULL
-bup_xpfm_compat_db1 table2 c78 set 5 NULL
-bup_xpfm_compat_db1 table2 crn int NULL 10
-bup_xpfm_compat_db1 table3 c01 bit NULL 1
-bup_xpfm_compat_db1 table3 c02 bit NULL 64
-bup_xpfm_compat_db1 table3 c03 tinyint NULL 3
-bup_xpfm_compat_db1 table3 c04 tinyint NULL 3
-bup_xpfm_compat_db1 table3 c05 tinyint NULL 3
-bup_xpfm_compat_db1 table3 c06 tinyint NULL 3
-bup_xpfm_compat_db1 table3 c07 smallint NULL 5
-bup_xpfm_compat_db1 table3 c08 smallint NULL 5
-bup_xpfm_compat_db1 table3 c09 smallint NULL 5
-bup_xpfm_compat_db1 table3 c10 mediumint NULL 7
-bup_xpfm_compat_db1 table3 c11 mediumint NULL 7
-bup_xpfm_compat_db1 table3 c12 mediumint NULL 7
-bup_xpfm_compat_db1 table3 c13 int NULL 10
-bup_xpfm_compat_db1 table3 c14 int NULL 10
-bup_xpfm_compat_db1 table3 c15 int NULL 10
-bup_xpfm_compat_db1 table3 c16 bigint NULL 19
-bup_xpfm_compat_db1 table3 c17 bigint NULL 19
-bup_xpfm_compat_db1 table3 c18 bigint NULL 19
-bup_xpfm_compat_db1 table3 c19 float NULL 12
-bup_xpfm_compat_db1 table3 c20 float NULL 12
-bup_xpfm_compat_db1 table3 c21 float NULL 12
-bup_xpfm_compat_db1 table3 c22 double NULL 22
-bup_xpfm_compat_db1 table3 c23 double NULL 22
-bup_xpfm_compat_db1 table3 c24 double NULL 22
-bup_xpfm_compat_db1 table3 c25 decimal NULL 10
-bup_xpfm_compat_db1 table3 c26 decimal NULL 10
-bup_xpfm_compat_db1 table3 c27 decimal NULL 10
-bup_xpfm_compat_db1 table3 c28 date NULL NULL
-bup_xpfm_compat_db1 table3 c29 datetime NULL NULL
-bup_xpfm_compat_db1 table3 c30 timestamp NULL NULL
-bup_xpfm_compat_db1 table3 c31 time NULL NULL
-bup_xpfm_compat_db1 table3 c32 year NULL NULL
-bup_xpfm_compat_db1 table3 c33 char 1 NULL
-bup_xpfm_compat_db1 table3 c34 char 0 NULL
-bup_xpfm_compat_db1 table3 c35 char 1 NULL
-bup_xpfm_compat_db1 table3 c36 char 255 NULL
-bup_xpfm_compat_db1 table3 c37 char 1 NULL
-bup_xpfm_compat_db1 table3 c38 char 0 NULL
-bup_xpfm_compat_db1 table3 c39 char 1 NULL
-bup_xpfm_compat_db1 table3 c40 char 255 NULL
-bup_xpfm_compat_db1 table3 c41 char 1 NULL
-bup_xpfm_compat_db1 table3 c42 char 0 NULL
-bup_xpfm_compat_db1 table3 c43 char 1 NULL
-bup_xpfm_compat_db1 table3 c44 char 255 NULL
-bup_xpfm_compat_db1 table3 c45 varchar 0 NULL
-bup_xpfm_compat_db1 table3 c46 varchar 1 NULL
-bup_xpfm_compat_db1 table3 c47 varchar 255 NULL
-bup_xpfm_compat_db1 table3 c48 varchar 261 NULL
-bup_xpfm_compat_db1 table3 c49 varchar 0 NULL
-bup_xpfm_compat_db1 table3 c50 varchar 1 NULL
-bup_xpfm_compat_db1 table3 c51 varchar 255 NULL
-bup_xpfm_compat_db1 table3 c52 varchar 261 NULL
-bup_xpfm_compat_db1 table3 c53 varchar 0 NULL
-bup_xpfm_compat_db1 table3 c54 varchar 1 NULL
-bup_xpfm_compat_db1 table3 c55 varchar 255 NULL
-bup_xpfm_compat_db1 table3 c56 varchar 261 NULL
-bup_xpfm_compat_db1 table3 c57 binary 1 NULL
-bup_xpfm_compat_db1 table3 c58 binary 0 NULL
-bup_xpfm_compat_db1 table3 c59 binary 1 NULL
-bup_xpfm_compat_db1 table3 c60 binary 255 NULL
-bup_xpfm_compat_db1 table3 c61 varbinary 0 NULL
-bup_xpfm_compat_db1 table3 c62 varbinary 1 NULL
-bup_xpfm_compat_db1 table3 c63 varbinary 255 NULL
-bup_xpfm_compat_db1 table3 c64 varbinary 261 NULL
-bup_xpfm_compat_db1 table3 c65 tinyblob 255 NULL
-bup_xpfm_compat_db1 table3 c66 tinytext 255 NULL
-bup_xpfm_compat_db1 table3 c67 tinytext 127 NULL
-bup_xpfm_compat_db1 table3 c68 blob 65535 NULL
-bup_xpfm_compat_db1 table3 c69 text 65535 NULL
-bup_xpfm_compat_db1 table3 c70 text 32767 NULL
-bup_xpfm_compat_db1 table3 c71 mediumblob 16777215 NULL
-bup_xpfm_compat_db1 table3 c72 mediumtext 16777215 NULL
-bup_xpfm_compat_db1 table3 c73 mediumtext 8388607 NULL
-bup_xpfm_compat_db1 table3 c74 longblob 4294967295 NULL
-bup_xpfm_compat_db1 table3 c75 longtext 4294967295 NULL
-bup_xpfm_compat_db1 table3 c76 longtext 2147483647 NULL
-bup_xpfm_compat_db1 table3 c77 enum 1 NULL
-bup_xpfm_compat_db1 table3 c78 set 5 NULL
-bup_xpfm_compat_db1 table3 crn int NULL 10
+bup_xpfm_compat_db1 TABLE2 c01 bit NULL 1
+bup_xpfm_compat_db1 TABLE2 c02 bit NULL 64
+bup_xpfm_compat_db1 TABLE2 c03 tinyint NULL 3
+bup_xpfm_compat_db1 TABLE2 c04 tinyint NULL 3
+bup_xpfm_compat_db1 TABLE2 c05 tinyint NULL 3
+bup_xpfm_compat_db1 TABLE2 c06 tinyint NULL 3
+bup_xpfm_compat_db1 TABLE2 c07 smallint NULL 5
+bup_xpfm_compat_db1 TABLE2 c08 smallint NULL 5
+bup_xpfm_compat_db1 TABLE2 c09 smallint NULL 5
+bup_xpfm_compat_db1 TABLE2 c10 mediumint NULL 7
+bup_xpfm_compat_db1 TABLE2 c11 mediumint NULL 7
+bup_xpfm_compat_db1 TABLE2 c12 mediumint NULL 7
+bup_xpfm_compat_db1 TABLE2 c13 int NULL 10
+bup_xpfm_compat_db1 TABLE2 c14 int NULL 10
+bup_xpfm_compat_db1 TABLE2 c15 int NULL 10
+bup_xpfm_compat_db1 TABLE2 c16 bigint NULL 19
+bup_xpfm_compat_db1 TABLE2 c17 bigint NULL 19
+bup_xpfm_compat_db1 TABLE2 c18 bigint NULL 19
+bup_xpfm_compat_db1 TABLE2 c19 float NULL 12
+bup_xpfm_compat_db1 TABLE2 c20 float NULL 12
+bup_xpfm_compat_db1 TABLE2 c21 float NULL 12
+bup_xpfm_compat_db1 TABLE2 c22 double NULL 22
+bup_xpfm_compat_db1 TABLE2 c23 double NULL 22
+bup_xpfm_compat_db1 TABLE2 c24 double NULL 22
+bup_xpfm_compat_db1 TABLE2 c25 decimal NULL 10
+bup_xpfm_compat_db1 TABLE2 c26 decimal NULL 10
+bup_xpfm_compat_db1 TABLE2 c27 decimal NULL 10
+bup_xpfm_compat_db1 TABLE2 c28 date NULL NULL
+bup_xpfm_compat_db1 TABLE2 c29 datetime NULL NULL
+bup_xpfm_compat_db1 TABLE2 c30 timestamp NULL NULL
+bup_xpfm_compat_db1 TABLE2 c31 time NULL NULL
+bup_xpfm_compat_db1 TABLE2 c32 year NULL NULL
+bup_xpfm_compat_db1 TABLE2 c33 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c34 char 0 NULL
+bup_xpfm_compat_db1 TABLE2 c35 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c36 char 255 NULL
+bup_xpfm_compat_db1 TABLE2 c37 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c38 char 0 NULL
+bup_xpfm_compat_db1 TABLE2 c39 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c40 char 255 NULL
+bup_xpfm_compat_db1 TABLE2 c41 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c42 char 0 NULL
+bup_xpfm_compat_db1 TABLE2 c43 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c44 char 255 NULL
+bup_xpfm_compat_db1 TABLE2 c45 varchar 0 NULL
+bup_xpfm_compat_db1 TABLE2 c46 varchar 1 NULL
+bup_xpfm_compat_db1 TABLE2 c47 varchar 255 NULL
+bup_xpfm_compat_db1 TABLE2 c48 varchar 261 NULL
+bup_xpfm_compat_db1 TABLE2 c49 varchar 0 NULL
+bup_xpfm_compat_db1 TABLE2 c50 varchar 1 NULL
+bup_xpfm_compat_db1 TABLE2 c51 varchar 255 NULL
+bup_xpfm_compat_db1 TABLE2 c52 varchar 261 NULL
+bup_xpfm_compat_db1 TABLE2 c53 varchar 0 NULL
+bup_xpfm_compat_db1 TABLE2 c54 varchar 1 NULL
+bup_xpfm_compat_db1 TABLE2 c55 varchar 255 NULL
+bup_xpfm_compat_db1 TABLE2 c56 varchar 261 NULL
+bup_xpfm_compat_db1 TABLE2 c57 binary 1 NULL
+bup_xpfm_compat_db1 TABLE2 c58 binary 0 NULL
+bup_xpfm_compat_db1 TABLE2 c59 binary 1 NULL
+bup_xpfm_compat_db1 TABLE2 c60 binary 255 NULL
+bup_xpfm_compat_db1 TABLE2 c61 varbinary 0 NULL
+bup_xpfm_compat_db1 TABLE2 c62 varbinary 1 NULL
+bup_xpfm_compat_db1 TABLE2 c63 varbinary 255 NULL
+bup_xpfm_compat_db1 TABLE2 c64 varbinary 261 NULL
+bup_xpfm_compat_db1 TABLE2 c65 tinyblob 255 NULL
+bup_xpfm_compat_db1 TABLE2 c66 tinytext 255 NULL
+bup_xpfm_compat_db1 TABLE2 c67 tinytext 127 NULL
+bup_xpfm_compat_db1 TABLE2 c68 blob 65535 NULL
+bup_xpfm_compat_db1 TABLE2 c69 text 65535 NULL
+bup_xpfm_compat_db1 TABLE2 c70 text 32767 NULL
+bup_xpfm_compat_db1 TABLE2 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db1 TABLE2 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db1 TABLE2 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db1 TABLE2 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db1 TABLE2 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db1 TABLE2 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db1 TABLE2 c77 enum 1 NULL
+bup_xpfm_compat_db1 TABLE2 c78 set 5 NULL
+bup_xpfm_compat_db1 TABLE2 crn int NULL 10
+bup_xpfm_compat_db1 TaBle3 c01 bit NULL 1
+bup_xpfm_compat_db1 TaBle3 c02 bit NULL 64
+bup_xpfm_compat_db1 TaBle3 c03 tinyint NULL 3
+bup_xpfm_compat_db1 TaBle3 c04 tinyint NULL 3
+bup_xpfm_compat_db1 TaBle3 c05 tinyint NULL 3
+bup_xpfm_compat_db1 TaBle3 c06 tinyint NULL 3
+bup_xpfm_compat_db1 TaBle3 c07 smallint NULL 5
+bup_xpfm_compat_db1 TaBle3 c08 smallint NULL 5
+bup_xpfm_compat_db1 TaBle3 c09 smallint NULL 5
+bup_xpfm_compat_db1 TaBle3 c10 mediumint NULL 7
+bup_xpfm_compat_db1 TaBle3 c11 mediumint NULL 7
+bup_xpfm_compat_db1 TaBle3 c12 mediumint NULL 7
+bup_xpfm_compat_db1 TaBle3 c13 int NULL 10
+bup_xpfm_compat_db1 TaBle3 c14 int NULL 10
+bup_xpfm_compat_db1 TaBle3 c15 int NULL 10
+bup_xpfm_compat_db1 TaBle3 c16 bigint NULL 19
+bup_xpfm_compat_db1 TaBle3 c17 bigint NULL 19
+bup_xpfm_compat_db1 TaBle3 c18 bigint NULL 19
+bup_xpfm_compat_db1 TaBle3 c19 float NULL 12
+bup_xpfm_compat_db1 TaBle3 c20 float NULL 12
+bup_xpfm_compat_db1 TaBle3 c21 float NULL 12
+bup_xpfm_compat_db1 TaBle3 c22 double NULL 22
+bup_xpfm_compat_db1 TaBle3 c23 double NULL 22
+bup_xpfm_compat_db1 TaBle3 c24 double NULL 22
+bup_xpfm_compat_db1 TaBle3 c25 decimal NULL 10
+bup_xpfm_compat_db1 TaBle3 c26 decimal NULL 10
+bup_xpfm_compat_db1 TaBle3 c27 decimal NULL 10
+bup_xpfm_compat_db1 TaBle3 c28 date NULL NULL
+bup_xpfm_compat_db1 TaBle3 c29 datetime NULL NULL
+bup_xpfm_compat_db1 TaBle3 c30 timestamp NULL NULL
+bup_xpfm_compat_db1 TaBle3 c31 time NULL NULL
+bup_xpfm_compat_db1 TaBle3 c32 year NULL NULL
+bup_xpfm_compat_db1 TaBle3 c33 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c34 char 0 NULL
+bup_xpfm_compat_db1 TaBle3 c35 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c36 char 255 NULL
+bup_xpfm_compat_db1 TaBle3 c37 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c38 char 0 NULL
+bup_xpfm_compat_db1 TaBle3 c39 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c40 char 255 NULL
+bup_xpfm_compat_db1 TaBle3 c41 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c42 char 0 NULL
+bup_xpfm_compat_db1 TaBle3 c43 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c44 char 255 NULL
+bup_xpfm_compat_db1 TaBle3 c45 varchar 0 NULL
+bup_xpfm_compat_db1 TaBle3 c46 varchar 1 NULL
+bup_xpfm_compat_db1 TaBle3 c47 varchar 255 NULL
+bup_xpfm_compat_db1 TaBle3 c48 varchar 261 NULL
+bup_xpfm_compat_db1 TaBle3 c49 varchar 0 NULL
+bup_xpfm_compat_db1 TaBle3 c50 varchar 1 NULL
+bup_xpfm_compat_db1 TaBle3 c51 varchar 255 NULL
+bup_xpfm_compat_db1 TaBle3 c52 varchar 261 NULL
+bup_xpfm_compat_db1 TaBle3 c53 varchar 0 NULL
+bup_xpfm_compat_db1 TaBle3 c54 varchar 1 NULL
+bup_xpfm_compat_db1 TaBle3 c55 varchar 255 NULL
+bup_xpfm_compat_db1 TaBle3 c56 varchar 261 NULL
+bup_xpfm_compat_db1 TaBle3 c57 binary 1 NULL
+bup_xpfm_compat_db1 TaBle3 c58 binary 0 NULL
+bup_xpfm_compat_db1 TaBle3 c59 binary 1 NULL
+bup_xpfm_compat_db1 TaBle3 c60 binary 255 NULL
+bup_xpfm_compat_db1 TaBle3 c61 varbinary 0 NULL
+bup_xpfm_compat_db1 TaBle3 c62 varbinary 1 NULL
+bup_xpfm_compat_db1 TaBle3 c63 varbinary 255 NULL
+bup_xpfm_compat_db1 TaBle3 c64 varbinary 261 NULL
+bup_xpfm_compat_db1 TaBle3 c65 tinyblob 255 NULL
+bup_xpfm_compat_db1 TaBle3 c66 tinytext 255 NULL
+bup_xpfm_compat_db1 TaBle3 c67 tinytext 127 NULL
+bup_xpfm_compat_db1 TaBle3 c68 blob 65535 NULL
+bup_xpfm_compat_db1 TaBle3 c69 text 65535 NULL
+bup_xpfm_compat_db1 TaBle3 c70 text 32767 NULL
+bup_xpfm_compat_db1 TaBle3 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db1 TaBle3 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db1 TaBle3 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db1 TaBle3 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db1 TaBle3 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db1 TaBle3 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db1 TaBle3 c77 enum 1 NULL
+bup_xpfm_compat_db1 TaBle3 c78 set 5 NULL
+bup_xpfm_compat_db1 TaBle3 crn int NULL 10
bup_xpfm_compat_db1 view1 c1 int NULL 10
bup_xpfm_compat_db1 view1 c2 varchar 261 NULL
bup_xpfm_compat_db1 view1 c3 int NULL 10
@@ -10947,108 +10943,1588 @@ bup_xpfm_compat_db1 view2 c2 varchar 261
bup_xpfm_compat_db1 view2 c3 int NULL 10
bup_xpfm_compat_db1 view3 c3 int NULL 10
bup_xpfm_compat_db1 view3 c4 int NULL 10
-bup_xpfm_compat_db2 table1 c01 bit NULL 1
-bup_xpfm_compat_db2 table1 c02 bit NULL 64
-bup_xpfm_compat_db2 table1 c03 tinyint NULL 3
-bup_xpfm_compat_db2 table1 c04 tinyint NULL 3
-bup_xpfm_compat_db2 table1 c05 tinyint NULL 3
-bup_xpfm_compat_db2 table1 c06 tinyint NULL 3
-bup_xpfm_compat_db2 table1 c07 smallint NULL 5
-bup_xpfm_compat_db2 table1 c08 smallint NULL 5
-bup_xpfm_compat_db2 table1 c09 smallint NULL 5
-bup_xpfm_compat_db2 table1 c10 mediumint NULL 7
-bup_xpfm_compat_db2 table1 c11 mediumint NULL 7
-bup_xpfm_compat_db2 table1 c12 mediumint NULL 7
-bup_xpfm_compat_db2 table1 c13 int NULL 10
-bup_xpfm_compat_db2 table1 c14 int NULL 10
-bup_xpfm_compat_db2 table1 c15 int NULL 10
-bup_xpfm_compat_db2 table1 c16 bigint NULL 19
-bup_xpfm_compat_db2 table1 c17 bigint NULL 19
-bup_xpfm_compat_db2 table1 c18 bigint NULL 19
-bup_xpfm_compat_db2 table1 c19 float NULL 12
-bup_xpfm_compat_db2 table1 c20 float NULL 12
-bup_xpfm_compat_db2 table1 c21 float NULL 12
-bup_xpfm_compat_db2 table1 c22 double NULL 22
-bup_xpfm_compat_db2 table1 c23 double NULL 22
-bup_xpfm_compat_db2 table1 c24 double NULL 22
-bup_xpfm_compat_db2 table1 c25 decimal NULL 10
-bup_xpfm_compat_db2 table1 c26 decimal NULL 10
-bup_xpfm_compat_db2 table1 c27 decimal NULL 10
-bup_xpfm_compat_db2 table1 c28 date NULL NULL
-bup_xpfm_compat_db2 table1 c29 datetime NULL NULL
-bup_xpfm_compat_db2 table1 c30 timestamp NULL NULL
-bup_xpfm_compat_db2 table1 c31 time NULL NULL
-bup_xpfm_compat_db2 table1 c32 year NULL NULL
-bup_xpfm_compat_db2 table1 c33 char 1 NULL
-bup_xpfm_compat_db2 table1 c34 char 0 NULL
-bup_xpfm_compat_db2 table1 c35 char 1 NULL
-bup_xpfm_compat_db2 table1 c36 char 255 NULL
-bup_xpfm_compat_db2 table1 c37 char 1 NULL
-bup_xpfm_compat_db2 table1 c38 char 0 NULL
-bup_xpfm_compat_db2 table1 c39 char 1 NULL
-bup_xpfm_compat_db2 table1 c40 char 255 NULL
-bup_xpfm_compat_db2 table1 c41 char 1 NULL
-bup_xpfm_compat_db2 table1 c42 char 0 NULL
-bup_xpfm_compat_db2 table1 c43 char 1 NULL
-bup_xpfm_compat_db2 table1 c44 char 255 NULL
-bup_xpfm_compat_db2 table1 c45 varchar 0 NULL
-bup_xpfm_compat_db2 table1 c46 varchar 1 NULL
-bup_xpfm_compat_db2 table1 c47 varchar 255 NULL
-bup_xpfm_compat_db2 table1 c48 varchar 261 NULL
-bup_xpfm_compat_db2 table1 c49 varchar 0 NULL
-bup_xpfm_compat_db2 table1 c50 varchar 1 NULL
-bup_xpfm_compat_db2 table1 c51 varchar 255 NULL
-bup_xpfm_compat_db2 table1 c52 varchar 261 NULL
-bup_xpfm_compat_db2 table1 c53 varchar 0 NULL
-bup_xpfm_compat_db2 table1 c54 varchar 1 NULL
-bup_xpfm_compat_db2 table1 c55 varchar 255 NULL
-bup_xpfm_compat_db2 table1 c56 varchar 261 NULL
-bup_xpfm_compat_db2 table1 c57 binary 1 NULL
-bup_xpfm_compat_db2 table1 c58 binary 0 NULL
-bup_xpfm_compat_db2 table1 c59 binary 1 NULL
-bup_xpfm_compat_db2 table1 c60 binary 255 NULL
-bup_xpfm_compat_db2 table1 c61 varbinary 0 NULL
-bup_xpfm_compat_db2 table1 c62 varbinary 1 NULL
-bup_xpfm_compat_db2 table1 c63 varbinary 255 NULL
-bup_xpfm_compat_db2 table1 c64 varbinary 261 NULL
-bup_xpfm_compat_db2 table1 c65 tinyblob 255 NULL
-bup_xpfm_compat_db2 table1 c66 tinytext 255 NULL
-bup_xpfm_compat_db2 table1 c67 tinytext 127 NULL
-bup_xpfm_compat_db2 table1 c68 blob 65535 NULL
-bup_xpfm_compat_db2 table1 c69 text 65535 NULL
-bup_xpfm_compat_db2 table1 c70 text 32767 NULL
-bup_xpfm_compat_db2 table1 c71 mediumblob 16777215 NULL
-bup_xpfm_compat_db2 table1 c72 mediumtext 16777215 NULL
-bup_xpfm_compat_db2 table1 c73 mediumtext 8388607 NULL
-bup_xpfm_compat_db2 table1 c74 longblob 4294967295 NULL
-bup_xpfm_compat_db2 table1 c75 longtext 4294967295 NULL
-bup_xpfm_compat_db2 table1 c76 longtext 2147483647 NULL
-bup_xpfm_compat_db2 table1 c77 enum 1 NULL
-bup_xpfm_compat_db2 table1 c78 set 5 NULL
-bup_xpfm_compat_db2 table1 crn int NULL 10
-bup_xpfm_compat_db2 table2 c01 bit NULL 1
-bup_xpfm_compat_db2 table2 c02 bit NULL 64
-bup_xpfm_compat_db2 table2 c03 tinyint NULL 3
-bup_xpfm_compat_db2 table2 c04 tinyint NULL 3
-bup_xpfm_compat_db2 table2 c05 tinyint NULL 3
-bup_xpfm_compat_db2 table2 c06 tinyint NULL 3
-bup_xpfm_compat_db2 table2 c07 smallint NULL 5
-bup_xpfm_compat_db2 table2 c08 smallint NULL 5
-bup_xpfm_compat_db2 table2 c09 smallint NULL 5
-bup_xpfm_compat_db2 table2 c10 mediumint NULL 7
-bup_xpfm_compat_db2 table2 c11 mediumint NULL 7
-bup_xpfm_compat_db2 table2 c12 mediumint NULL 7
-bup_xpfm_compat_db2 table2 c13 int NULL 10
-bup_xpfm_compat_db2 table2 c14 int NULL 10
-bup_xpfm_compat_db2 table2 c15 int NULL 10
-bup_xpfm_compat_db2 table2 c16 bigint NULL 19
-bup_xpfm_compat_db2 table2 c17 bigint NULL 19
-bup_xpfm_compat_db2 table2 c18 bigint NULL 19
-bup_xpfm_compat_db2 table2 c19 float NULL 12
-bup_xpfm_compat_db2 table2 c20 float NULL 12
-bup_xpfm_compat_db2 table2 c21 float NULL 12
-bup_xpfm_compat_db2 table2 c22 double NULL 22
-bup_xpfm_compat_db2 table2 c23 double NULL 22
+BUP_XPFM_COMPAT_DB2 table1 c01 bit NULL 1
+BUP_XPFM_COMPAT_DB2 table1 c02 bit NULL 64
+BUP_XPFM_COMPAT_DB2 table1 c03 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 table1 c04 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 table1 c05 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 table1 c06 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 table1 c07 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 table1 c08 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 table1 c09 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 table1 c10 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 table1 c11 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 table1 c12 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 table1 c13 int NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c14 int NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c15 int NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c16 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 table1 c17 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 table1 c18 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 table1 c19 float NULL 12
+BUP_XPFM_COMPAT_DB2 table1 c20 float NULL 12
+BUP_XPFM_COMPAT_DB2 table1 c21 float NULL 12
+BUP_XPFM_COMPAT_DB2 table1 c22 double NULL 22
+BUP_XPFM_COMPAT_DB2 table1 c23 double NULL 22
+BUP_XPFM_COMPAT_DB2 table1 c24 double NULL 22
+BUP_XPFM_COMPAT_DB2 table1 c25 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c26 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c27 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c28 date NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c29 datetime NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c30 timestamp NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c31 time NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c32 year NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c33 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c34 char 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c35 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c36 char 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c37 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c38 char 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c39 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c40 char 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c41 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c42 char 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c43 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c44 char 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c45 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c46 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c47 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c48 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 table1 c49 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c50 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c51 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c52 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 table1 c53 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c54 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c55 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c56 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 table1 c57 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c58 binary 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c59 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c60 binary 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c61 varbinary 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c62 varbinary 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c63 varbinary 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c64 varbinary 261 NULL
+BUP_XPFM_COMPAT_DB2 table1 c65 tinyblob 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c66 tinytext 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c67 tinytext 127 NULL
+BUP_XPFM_COMPAT_DB2 table1 c68 blob 65535 NULL
+BUP_XPFM_COMPAT_DB2 table1 c69 text 65535 NULL
+BUP_XPFM_COMPAT_DB2 table1 c70 text 32767 NULL
+BUP_XPFM_COMPAT_DB2 table1 c71 mediumblob 16777215 NULL
+BUP_XPFM_COMPAT_DB2 table1 c72 mediumtext 16777215 NULL
+BUP_XPFM_COMPAT_DB2 table1 c73 mediumtext 8388607 NULL
+BUP_XPFM_COMPAT_DB2 table1 c74 longblob 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 table1 c75 longtext 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 table1 c76 longtext 2147483647 NULL
+BUP_XPFM_COMPAT_DB2 table1 c77 enum 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c78 set 5 NULL
+BUP_XPFM_COMPAT_DB2 table1 crn int NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c01 bit NULL 1
+BUP_XPFM_COMPAT_DB2 TABLE2 c02 bit NULL 64
+BUP_XPFM_COMPAT_DB2 TABLE2 c03 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TABLE2 c04 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TABLE2 c05 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TABLE2 c06 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TABLE2 c07 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TABLE2 c08 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TABLE2 c09 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TABLE2 c10 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TABLE2 c11 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TABLE2 c12 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TABLE2 c13 int NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c14 int NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c15 int NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c16 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TABLE2 c17 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TABLE2 c18 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TABLE2 c19 float NULL 12
+BUP_XPFM_COMPAT_DB2 TABLE2 c20 float NULL 12
+BUP_XPFM_COMPAT_DB2 TABLE2 c21 float NULL 12
+BUP_XPFM_COMPAT_DB2 TABLE2 c22 double NULL 22
+BUP_XPFM_COMPAT_DB2 TABLE2 c23 double NULL 22
+BUP_XPFM_COMPAT_DB2 TABLE2 c24 double NULL 22
+BUP_XPFM_COMPAT_DB2 TABLE2 c25 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c26 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c27 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c28 date NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c29 datetime NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c30 timestamp NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c31 time NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c32 year NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c33 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c34 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c35 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c36 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c37 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c38 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c39 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c40 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c41 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c42 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c43 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c44 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c45 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c46 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c47 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c48 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c49 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c50 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c51 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c52 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c53 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c54 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c55 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c56 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c57 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c58 binary 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c59 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c60 binary 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c61 varbinary 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c62 varbinary 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c63 varbinary 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c64 varbinary 261 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c65 tinyblob 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c66 tinytext 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c67 tinytext 127 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c68 blob 65535 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c69 text 65535 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c70 text 32767 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c71 mediumblob 16777215 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c72 mediumtext 16777215 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c73 mediumtext 8388607 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c74 longblob 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c75 longtext 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c76 longtext 2147483647 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c77 enum 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c78 set 5 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 crn int NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c01 bit NULL 1
+BUP_XPFM_COMPAT_DB2 TaBle3 c02 bit NULL 64
+BUP_XPFM_COMPAT_DB2 TaBle3 c03 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TaBle3 c04 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TaBle3 c05 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TaBle3 c06 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TaBle3 c07 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TaBle3 c08 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TaBle3 c09 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TaBle3 c10 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TaBle3 c11 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TaBle3 c12 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TaBle3 c13 int NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c14 int NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c15 int NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c16 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TaBle3 c17 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TaBle3 c18 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TaBle3 c19 float NULL 12
+BUP_XPFM_COMPAT_DB2 TaBle3 c20 float NULL 12
+BUP_XPFM_COMPAT_DB2 TaBle3 c21 float NULL 12
+BUP_XPFM_COMPAT_DB2 TaBle3 c22 double NULL 22
+BUP_XPFM_COMPAT_DB2 TaBle3 c23 double NULL 22
+BUP_XPFM_COMPAT_DB2 TaBle3 c24 double NULL 22
+BUP_XPFM_COMPAT_DB2 TaBle3 c25 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c26 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c27 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c28 date NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c29 datetime NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c30 timestamp NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c31 time NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c32 year NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c33 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c34 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c35 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c36 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c37 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c38 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c39 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c40 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c41 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c42 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c43 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c44 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c45 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c46 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c47 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c48 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c49 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c50 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c51 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c52 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c53 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c54 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c55 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c56 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c57 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c58 binary 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c59 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c60 binary 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c61 varbinary 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c62 varbinary 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c63 varbinary 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c64 varbinary 261 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c65 tinyblob 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c66 tinytext 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c67 tinytext 127 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c68 blob 65535 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c69 text 65535 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c70 text 32767 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c71 mediumblob 16777215 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c72 mediumtext 16777215 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c73 mediumtext 8388607 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c74 longblob 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c75 longtext 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c76 longtext 2147483647 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c77 enum 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c78 set 5 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 crn int NULL 10
+BUP_XPFM_COMPAT_DB2 view1 c1 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 view1 c2 double NULL 8
+BUP_XPFM_COMPAT_DB2 view1 c3 varchar 77 NULL
+BUP_XPFM_COMPAT_DB2 view1 c4 varchar 40 NULL
+bup_xpfm_compat_db2 view2 c1 int NULL 10
+bup_xpfm_compat_db2 view2 c2 varchar 261 NULL
+bup_xpfm_compat_db2 view3 c3 varchar 77 NULL
+bup_xpfm_compat_db2 view3 c4 varchar 40 NULL
+SELECT TABLE_SCHEMA, TABLE_NAME, VIEW_DEFINITION
+FROM INFORMATION_SCHEMA.VIEWS
+WHERE TABLE_SCHEMA like 'bup%xpfm%compat%'
+ ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME);
+TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION
+BupXPfmCompat_db3 view1 select `view1`.`c1` AS `c1`,`view2`.`c1` AS `c2` from (`bup_xpfm_compat_db1`.`view1` join `bup_xpfm_compat_db2`.`view2`) where (`view1`.`c1` = `view2`.`c1`)
+BupXPfmCompat_db3 view2 select `view1`.`c1` AS `c1`,`view2`.`c1` AS `c2` from (`bup_xpfm_compat_db1`.`view1` left join `bup_xpfm_compat_db2`.`view2` on((`view1`.`c1` = `view2`.`c1`)))
+BupXPfmCompat_db3 view3 select `view1`.`c1` AS `c1`,`view1`.`c2` AS `c2` from `bupxpfmcompat_db3`.`view1`
+bup_xpfm_compat_db1 view1 select `bup_xpfm_compat_db1`.`table1`.`c13` AS `c1`,`bup_xpfm_compat_db1`.`table1`.`c48` AS `c2`,`bup_xpfm_compat_db1`.`table1`.`c13` in (select (`bup_xpfm_compat_db1`.`table1`.`c13` + 2) AS `c13+2` from `bup_xpfm_compat_db1`.`table1`) AS `c3`,`bup_xpfm_compat_db1`.`table1`.`c13` = all (select `bup_xpfm_compat_db1`.`table1`.`c13` AS `c13` from `bup_xpfm_compat_db1`.`table1`) AS `c4` from `bup_xpfm_compat_db1`.`table1`
+bup_xpfm_compat_db1 view2 select `view1`.`c2` AS `c2`,`view1`.`c3` AS `c3` from `bup_xpfm_compat_db1`.`view1`
+bup_xpfm_compat_db1 view3 select `view1`.`c3` AS `c3`,`view1`.`c4` AS `c4` from `bup_xpfm_compat_db1`.`view1`
+BUP_XPFM_COMPAT_DB2 view1 select connection_id() AS `c1`,pi() AS `c2`,current_user() AS `c3`,rpad(version(),40,' ') AS `c4`
+BUP_XPFM_COMPAT_DB2 view2 select `bup_xpfm_compat_db2`.`table2`.`c13` AS `c1`,`bup_xpfm_compat_db2`.`table2`.`c48` AS `c2` from (`bup_xpfm_compat_db2`.`table2` join `bup_xpfm_compat_db2`.`table3`) union all select `bup_xpfm_compat_db2`.`table2`.`c13` AS `c13`,`bup_xpfm_compat_db2`.`table2`.`c48` AS `c48` from (`bup_xpfm_compat_db2`.`table2` join `bup_xpfm_compat_db2`.`table3`)
+BUP_XPFM_COMPAT_DB2 view3 select `view1`.`c3` AS `c3`,`view1`.`c4` AS `c4` from `bup_xpfm_compat_db2`.`view1`
+SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
+FROM INFORMATION_SCHEMA.ROUTINES
+WHERE ROUTINE_SCHEMA like 'bup%xpfm%compat%'
+ AND ROUTINE_TYPE = 'PROCEDURE'
+ ORDER BY LOWER(ROUTINE_SCHEMA), LOWER(ROUTINE_NAME);
+ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_DEFINITION
+bupxpfmcompat_db3 proc1 BEGIN
+UPDATE BupXPfmCompat_db3.table1 SET c48='from BupXPfmCompat_db3.proc1';
+END
+bupxpfmcompat_db3 PROC2 BEGIN
+UPDATE BupXPfmCompat_db3.TABLE2 SET c48='from BupXPfmCompat_db3.PROC2';
+END
+bupxpfmcompat_db3 proc3 BEGIN
+UPDATE BupXPfmCompat_db3.TaBle3 SET c48='from BupXPfmCompat_db3.PrOc3';
+END
+bup_xpfm_compat_db1 proc1 BEGIN
+UPDATE bup_xpfm_compat_db1.table1 SET c48='from bup_xpfm_compat_db1.proc1';
+END
+bup_xpfm_compat_db1 PROC2 BEGIN
+UPDATE bup_xpfm_compat_db1.TABLE2 SET c48='from bup_xpfm_compat_db1.PROC2';
+END
+bup_xpfm_compat_db1 PrOc3 BEGIN
+UPDATE bup_xpfm_compat_db1.TaBle3 SET c48='from bup_xpfm_compat_db1.PrOc3';
+END
+bup_xpfm_compat_db2 proc1 BEGIN
+UPDATE BUP_XPFM_COMPAT_DB2.table1 SET c48='from BUP_XPFM_COMPAT_DB2.proc1';
+END
+bup_xpfm_compat_db2 proc2 BEGIN
+UPDATE BUP_XPFM_COMPAT_DB2.TABLE2 SET c48='from BUP_XPFM_COMPAT_DB2.PROC2';
+END
+bup_xpfm_compat_db2 PrOc3 BEGIN
+UPDATE BUP_XPFM_COMPAT_DB2.TaBle3 SET c48='from BUP_XPFM_COMPAT_DB2.PrOc3';
+END
+SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
+FROM INFORMATION_SCHEMA.ROUTINES
+WHERE ROUTINE_SCHEMA like 'bup%xpfm%compat%'
+ AND ROUTINE_TYPE = 'FUNCTION'
+ ORDER BY LOWER(ROUTINE_SCHEMA), LOWER(ROUTINE_NAME);
+ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_DEFINITION
+bupxpfmcompat_db3 func1 BEGIN
+RETURN arg1 * 31;
+END
+bupxpfmcompat_db3 FUNC2 BEGIN
+RETURN arg1 * 32;
+END
+bupxpfmcompat_db3 func3 BEGIN
+RETURN arg1 * 33;
+END
+bup_xpfm_compat_db1 func1 BEGIN
+RETURN arg1 * 11;
+END
+bup_xpfm_compat_db1 FUNC2 BEGIN
+RETURN arg1 * 12;
+END
+bup_xpfm_compat_db1 FuNc3 BEGIN
+RETURN arg1 * 13;
+END
+bup_xpfm_compat_db2 func1 BEGIN
+RETURN arg1 * 21;
+END
+bup_xpfm_compat_db2 func2 BEGIN
+RETURN arg1 * 22;
+END
+bup_xpfm_compat_db2 FuNc3 BEGIN
+RETURN arg1 * 23;
+END
+SELECT TRIGGER_SCHEMA, TRIGGER_NAME, ACTION_TIMING, EVENT_MANIPULATION,
+EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_STATEMENT
+FROM INFORMATION_SCHEMA.TRIGGERS
+WHERE TRIGGER_SCHEMA like 'bup%xpfm%compat%'
+ ORDER BY LOWER(TRIGGER_SCHEMA), LOWER(TRIGGER_NAME);
+TRIGGER_SCHEMA TRIGGER_NAME ACTION_TIMING EVENT_MANIPULATION EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_STATEMENT
+BupXPfmCompat_db3 trigger1 AFTER INSERT BupXPfmCompat_db3 table1 BEGIN
+DELETE FROM BupXPfmCompat_db3.TABLE2
+WHERE BupXPfmCompat_db3.TABLE2.c13 = NEW.c13;
+END
+BupXPfmCompat_db3 TRIGGER2 AFTER INSERT BupXPfmCompat_db3 TABLE2 BEGIN
+DELETE FROM BupXPfmCompat_db3.table1
+WHERE BupXPfmCompat_db3.table1.c13 = NEW.c13;
+END
+BupXPfmCompat_db3 TrigGer3 AFTER INSERT BupXPfmCompat_db3 TaBle3 BEGIN
+INSERT INTO bup_xpfm_compat_db1.table1 SET c13 = 53;
+END
+bup_xpfm_compat_db1 trigger1 AFTER INSERT bup_xpfm_compat_db1 table1 BEGIN
+DELETE FROM bup_xpfm_compat_db1.TABLE2
+WHERE bup_xpfm_compat_db1.TABLE2.c13 = NEW.c13;
+END
+bup_xpfm_compat_db1 TRIGGER2 AFTER INSERT bup_xpfm_compat_db1 TABLE2 BEGIN
+DELETE FROM bup_xpfm_compat_db1.table1
+WHERE bup_xpfm_compat_db1.table1.c13 = NEW.c13;
+END
+bup_xpfm_compat_db1 TrigGer3 AFTER INSERT bup_xpfm_compat_db1 TaBle3 BEGIN
+INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13 = 51;
+END
+BUP_XPFM_COMPAT_DB2 trigger1 AFTER INSERT BUP_XPFM_COMPAT_DB2 table1 BEGIN
+DELETE FROM BUP_XPFM_COMPAT_DB2.TABLE2
+WHERE BUP_XPFM_COMPAT_DB2.TABLE2.c13 = NEW.c13;
+END
+BUP_XPFM_COMPAT_DB2 TRIGGER2 AFTER INSERT BUP_XPFM_COMPAT_DB2 TABLE2 BEGIN
+DELETE FROM BUP_XPFM_COMPAT_DB2.table1
+WHERE BUP_XPFM_COMPAT_DB2.table1.c13 = NEW.c13;
+END
+BUP_XPFM_COMPAT_DB2 TrigGer3 AFTER INSERT BUP_XPFM_COMPAT_DB2 TaBle3 BEGIN
+INSERT INTO BupXPfmCompat_db3.TaBle3 SET c13 = 52;
+END
+SHOW CREATE TRIGGER bup_xpfm_compat_db1.trigger1;
+Trigger trigger1
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER bup_xpfm_compat_db1.trigger1 AFTER INSERT
+ON bup_xpfm_compat_db1.table1 FOR EACH ROW
+BEGIN
+DELETE FROM bup_xpfm_compat_db1.TABLE2
+WHERE bup_xpfm_compat_db1.TABLE2.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER bup_xpfm_compat_db1.TRIGGER2;
+Trigger TRIGGER2
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER bup_xpfm_compat_db1.TRIGGER2 AFTER INSERT
+ON bup_xpfm_compat_db1.TABLE2 FOR EACH ROW
+BEGIN
+DELETE FROM bup_xpfm_compat_db1.table1
+WHERE bup_xpfm_compat_db1.table1.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER bup_xpfm_compat_db1.TrigGer3;
+Trigger TrigGer3
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER bup_xpfm_compat_db1.TrigGer3 AFTER INSERT
+ON bup_xpfm_compat_db1.TaBle3 FOR EACH ROW
+BEGIN
+INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13 = 51;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BUP_XPFM_COMPAT_DB2.trigger1;
+Trigger trigger1
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BUP_XPFM_COMPAT_DB2.trigger1 AFTER INSERT
+ON BUP_XPFM_COMPAT_DB2.table1 FOR EACH ROW
+BEGIN
+DELETE FROM BUP_XPFM_COMPAT_DB2.TABLE2
+WHERE BUP_XPFM_COMPAT_DB2.TABLE2.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BUP_XPFM_COMPAT_DB2.TRIGGER2;
+Trigger TRIGGER2
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BUP_XPFM_COMPAT_DB2.TRIGGER2 AFTER INSERT
+ON BUP_XPFM_COMPAT_DB2.TABLE2 FOR EACH ROW
+BEGIN
+DELETE FROM BUP_XPFM_COMPAT_DB2.table1
+WHERE BUP_XPFM_COMPAT_DB2.table1.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BUP_XPFM_COMPAT_DB2.TrigGer3;
+Trigger TrigGer3
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BUP_XPFM_COMPAT_DB2.TrigGer3 AFTER INSERT
+ON BUP_XPFM_COMPAT_DB2.TaBle3 FOR EACH ROW
+BEGIN
+INSERT INTO BupXPfmCompat_db3.TaBle3 SET c13 = 52;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BupXPfmCompat_db3.trigger1;
+Trigger trigger1
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BupXPfmCompat_db3.trigger1 AFTER INSERT
+ON BupXPfmCompat_db3.table1 FOR EACH ROW
+BEGIN
+DELETE FROM BupXPfmCompat_db3.TABLE2
+WHERE BupXPfmCompat_db3.TABLE2.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BupXPfmCompat_db3.TRIGGER2;
+Trigger TRIGGER2
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BupXPfmCompat_db3.TRIGGER2 AFTER INSERT
+ON BupXPfmCompat_db3.TABLE2 FOR EACH ROW
+BEGIN
+DELETE FROM BupXPfmCompat_db3.table1
+WHERE BupXPfmCompat_db3.table1.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BupXPfmCompat_db3.TrigGer3;
+Trigger TrigGer3
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BupXPfmCompat_db3.TrigGer3 AFTER INSERT
+ON BupXPfmCompat_db3.TaBle3 FOR EACH ROW
+BEGIN
+INSERT INTO bup_xpfm_compat_db1.table1 SET c13 = 53;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SELECT EVENT_SCHEMA, EVENT_NAME, EVENT_DEFINITION
+FROM INFORMATION_SCHEMA.EVENTS
+WHERE EVENT_SCHEMA like 'bup%xpfm%compat%'
+ ORDER BY LOWER(EVENT_SCHEMA), LOWER(EVENT_NAME);
+EVENT_SCHEMA EVENT_NAME EVENT_DEFINITION
+bupxpfmcompat_db3 event1 DELETE FROM BupXPfmCompat_db3.table1 WHERE c13 > 100
+bupxpfmcompat_db3 EVENT2 DELETE FROM BupXPfmCompat_db3.TABLE2 WHERE c13 > 100
+bupxpfmcompat_db3 EvEnt3 DELETE FROM BupXPfmCompat_db3.TaBle3 WHERE c13 > 100
+bup_xpfm_compat_db1 event1 DELETE FROM bup_xpfm_compat_db1.table1 WHERE c13 > 100
+bup_xpfm_compat_db1 EVENT2 DELETE FROM bup_xpfm_compat_db1.TABLE2 WHERE c13 > 100
+bup_xpfm_compat_db1 EvEnt3 DELETE FROM bup_xpfm_compat_db1.TaBle3 WHERE c13 > 100
+bup_xpfm_compat_db2 event1 DELETE FROM BUP_XPFM_COMPAT_DB2.table1 WHERE c13 > 100
+bup_xpfm_compat_db2 EVENT2 DELETE FROM BUP_XPFM_COMPAT_DB2.TABLE2 WHERE c13 > 100
+bup_xpfm_compat_db2 EvEnt3 DELETE FROM BUP_XPFM_COMPAT_DB2.TaBle3 WHERE c13 > 100
+#
+# Check table contents.
+#
+SELECT COUNT(*) FROM bup_xpfm_compat_db1.table1;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM bup_xpfm_compat_db1.table1;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ��147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM bup_xpfm_compat_db1.TABLE2;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM bup_xpfm_compat_db1.TABLE2;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 �����������iiiiiiiiiiiii
+SELECT COUNT(*) FROM bup_xpfm_compat_db1.TaBle3;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM bup_xpfm_compat_db1.TaBle3;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ����647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BUP_XPFM_COMPAT_DB2.table1;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BUP_XPFM_COMPAT_DB2.table1;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 �������������NULL NULL
+4 2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BUP_XPFM_COMPAT_DB2.TABLE2;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BUP_XPFM_COMPAT_DB2.TABLE2;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ������iiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BUP_XPFM_COMPAT_DB2.TaBle3;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BUP_XPFM_COMPAT_DB2.TaBle3;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ���������������ULL
+4 2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BupXPfmCompat_db3.table1;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BupXPfmCompat_db3.table1;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ������������������������������������������������������������
+3 NULL NULL
+4 2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BupXPfmCompat_db3.TABLE2;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BupXPfmCompat_db3.TABLE2;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ����3647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BupXPfmCompat_db3.TaBle3;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BupXPfmCompat_db3.TaBle3;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ��������������L NULL
+4 2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+#
+# Execute views.
+#
+SELECT c1, SUBSTR(c2 FROM 1 FOR 30), c3, c4 FROM bup_xpfm_compat_db1.view1;
+c1 SUBSTR(c2 FROM 1 FOR 30) c3 c4
+-2147483648 NULL 0
+2147483647 ���L NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii NULL 0
+SELECT SUBSTR(c2 FROM 1 FOR 30), c3 FROM bup_xpfm_compat_db1.VIEW2;
+SUBSTR(c2 FROM 1 FOR 30) c3
+ NULL
+������������������������������������������������������������ NULL
+NULL NULL
+iiiiiiiiiiiiiiiiiiiiiiiiiiiiii NULL
+SELECT c3, c4 FROM bup_xpfm_compat_db1.ViEw3;
+c3 c4
+NULL 0
+NULL 0
+NULL NULL
+NULL 0
+SELECT c2, c3 FROM BUP_XPFM_COMPAT_DB2.view1;
+c2 c3
+3.141593 root@localhost
+SELECT c1, SUBSTR(c2 FROM 1 FOR 30) FROM BUP_XPFM_COMPAT_DB2.VIEW2;
+c1 SUBSTR(c2 FROM 1 FOR 30)
+-2147483648
+2147483647 ���47 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 �����������iiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ����������iiiiiiiiiiii
+-2147483648
+2147483647 ��483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 �47483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ���������iiiiiiiiiiiiiiii
+SELECT c3 FROM BUP_XPFM_COMPAT_DB2.ViEw3;
+c3
+root@localhost
+SELECT c1, c2 FROM BupXPfmCompat_db3.view1;
+c1 c2
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+SELECT c1, c2 FROM BupXPfmCompat_db3.VIEW2;
+c1 c2
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+NULL NULL
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+SELECT c1, c2 FROM BupXPfmCompat_db3.ViEw3;
+c1 c2
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+#
+# Execute procedures. They insert their name into c48.
+#
+CALL bup_xpfm_compat_db1.proc1;
+CALL bup_xpfm_compat_db1.PROC2;
+CALL bup_xpfm_compat_db1.PrOc3;
+CALL BUP_XPFM_COMPAT_DB2.proc1;
+CALL BUP_XPFM_COMPAT_DB2.PROC2;
+CALL BUP_XPFM_COMPAT_DB2.PrOc3;
+CALL BupXPfmCompat_db3.proc1;
+CALL BupXPfmCompat_db3.PROC2;
+CALL BupXPfmCompat_db3.PrOc3;
+SELECT c48 FROM bup_xpfm_compat_db1.table1;
+c48
+from bup_xpfm_compat_db1.proc1
+from bup_xpfm_compat_db1.proc1
+from bup_xpfm_compat_db1.proc1
+from bup_xpfm_compat_db1.proc1
+SELECT c48 FROM bup_xpfm_compat_db1.TABLE2;
+c48
+from bup_xpfm_compat_db1.PROC2
+from bup_xpfm_compat_db1.PROC2
+from bup_xpfm_compat_db1.PROC2
+from bup_xpfm_compat_db1.PROC2
+SELECT c48 FROM bup_xpfm_compat_db1.TaBle3;
+c48
+from bup_xpfm_compat_db1.PrOc3
+from bup_xpfm_compat_db1.PrOc3
+from bup_xpfm_compat_db1.PrOc3
+from bup_xpfm_compat_db1.PrOc3
+SELECT c48 FROM BUP_XPFM_COMPAT_DB2.table1;
+c48
+from BUP_XPFM_COMPAT_DB2.proc1
+from BUP_XPFM_COMPAT_DB2.proc1
+from BUP_XPFM_COMPAT_DB2.proc1
+from BUP_XPFM_COMPAT_DB2.proc1
+SELECT c48 FROM BUP_XPFM_COMPAT_DB2.TABLE2;
+c48
+from BUP_XPFM_COMPAT_DB2.PROC2
+from BUP_XPFM_COMPAT_DB2.PROC2
+from BUP_XPFM_COMPAT_DB2.PROC2
+from BUP_XPFM_COMPAT_DB2.PROC2
+SELECT c48 FROM BUP_XPFM_COMPAT_DB2.TaBle3;
+c48
+from BUP_XPFM_COMPAT_DB2.PrOc3
+from BUP_XPFM_COMPAT_DB2.PrOc3
+from BUP_XPFM_COMPAT_DB2.PrOc3
+from BUP_XPFM_COMPAT_DB2.PrOc3
+SELECT c48 FROM BupXPfmCompat_db3.table1;
+c48
+from BupXPfmCompat_db3.proc1
+from BupXPfmCompat_db3.proc1
+from BupXPfmCompat_db3.proc1
+from BupXPfmCompat_db3.proc1
+SELECT c48 FROM BupXPfmCompat_db3.TABLE2;
+c48
+from BupXPfmCompat_db3.PROC2
+from BupXPfmCompat_db3.PROC2
+from BupXPfmCompat_db3.PROC2
+from BupXPfmCompat_db3.PROC2
+SELECT c48 FROM BupXPfmCompat_db3.TaBle3;
+c48
+from BupXPfmCompat_db3.PrOc3
+from BupXPfmCompat_db3.PrOc3
+from BupXPfmCompat_db3.PrOc3
+from BupXPfmCompat_db3.PrOc3
+#
+# Execute functions. They multiply their arg by 11, 12, 13, ..., 32, 33.
+# When Bug#9051 (Stored Functions: Database name in fully qualified name
+# is case sensitive) is fixed, the --error directives and the
+# secondary call of the functions in bup_xpfm_compat_db2 and
+# bupxpfmcompat_db3 shall be removed.
+#
+SELECT bup_xpfm_compat_db1.func1(2);
+bup_xpfm_compat_db1.func1(2)
+22
+SELECT bup_xpfm_compat_db1.FUNC2(3);
+bup_xpfm_compat_db1.FUNC2(3)
+36
+SELECT bup_xpfm_compat_db1.FuNc3(4);
+bup_xpfm_compat_db1.FuNc3(4)
+52
+SELECT BUP_XPFM_COMPAT_DB2.func1(5);
+SELECT bup_xpfm_compat_db2.func1(5);
+bup_xpfm_compat_db2.func1(5)
+105
+SELECT BUP_XPFM_COMPAT_DB2.FUNC2(6);
+SELECT bup_xpfm_compat_db2.FUNC2(6);
+bup_xpfm_compat_db2.FUNC2(6)
+132
+SELECT BUP_XPFM_COMPAT_DB2.FuNc3(7);
+SELECT bup_xpfm_compat_db2.FuNc3(7);
+bup_xpfm_compat_db2.FuNc3(7)
+161
+SELECT BupXPfmCompat_db3.func1(8);
+SELECT bupxpfmcompat_db3.func1(8);
+bupxpfmcompat_db3.func1(8)
+248
+SELECT BupXPfmCompat_db3.FUNC2(9);
+SELECT bupxpfmcompat_db3.FUNC2(9);
+bupxpfmcompat_db3.FUNC2(9)
+288
+SELECT BupXPfmCompat_db3.FuNc3(10);
+SELECT bupxpfmcompat_db3.FuNc3(10);
+bupxpfmcompat_db3.FuNc3(10)
+330
+#
+# Execute triggers.
+# Triggers 1 and 2 delete same row from tables 2 and 1 respectively.
+# Trigger 3 inserts 51, 52, 53 into table 3 of next db respectively.
+#
+INSERT INTO bup_xpfm_compat_db1.table1 SET c13=43 -- del 43 of TABLE2 (no-op);
+INSERT INTO bup_xpfm_compat_db1.TABLE2 SET c13=43 -- del 43 of table1 (ok);
+INSERT INTO bup_xpfm_compat_db1.TaBle3 SET c13=43 -- ins 51 in DB2.TABLE2;
+INSERT INTO bup_xpfm_compat_db1.TABLE2 SET c13=44 -- del 44 of table1 (no-op);
+INSERT INTO bup_xpfm_compat_db1.table1 SET c13=44 -- del 44 of TABLE2 (ok);
+INSERT INTO BUP_XPFM_COMPAT_DB2.table1 SET c13=43 -- del 43 of TABLE2 (no-op);
+INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13=43 -- del 43 of table1 (ok);
+INSERT INTO BUP_XPFM_COMPAT_DB2.TaBle3 SET c13=43 -- ins 52 in db3.TaBle3;
+INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13=44 -- del 44 of table1 (no-op);
+INSERT INTO BUP_XPFM_COMPAT_DB2.table1 SET c13=44 -- del 44 of TABLE2 (ok);
+INSERT INTO BupXPfmCompat_db3.table1 SET c13=43 -- del 43 of TABLE2 (no-op);
+INSERT INTO BupXPfmCompat_db3.TABLE2 SET c13=43 -- del 43 of table1 (ok);
+INSERT INTO BupXPfmCompat_db3.TaBle3 SET c13=43 -- ins 53 in db1.table1;
+INSERT INTO BupXPfmCompat_db3.TABLE2 SET c13=44 -- del 44 of table1 (no-op);
+INSERT INTO BupXPfmCompat_db3.table1 SET c13=44 -- del 44 of TABLE2 (ok);
+SELECT c13 FROM bup_xpfm_compat_db1.table1 WHERE c13 BETWEEN 1 AND 100;
+c13
+44
+53
+53
+SELECT c13 FROM bup_xpfm_compat_db1.TABLE2 WHERE c13 BETWEEN 1 AND 100;
+c13
+43
+SELECT c13 FROM bup_xpfm_compat_db1.TaBle3 WHERE c13 BETWEEN 1 AND 100;
+c13
+43
+SELECT c13 FROM BUP_XPFM_COMPAT_DB2.table1 WHERE c13 BETWEEN 1 AND 100;
+c13
+44
+SELECT c13 FROM BUP_XPFM_COMPAT_DB2.TABLE2 WHERE c13 BETWEEN 1 AND 100;
+c13
+51
+43
+SELECT c13 FROM BUP_XPFM_COMPAT_DB2.TaBle3 WHERE c13 BETWEEN 1 AND 100;
+c13
+43
+SELECT c13 FROM BupXPfmCompat_db3.table1 WHERE c13 BETWEEN 1 AND 100;
+c13
+44
+SELECT c13 FROM BupXPfmCompat_db3.TABLE2 WHERE c13 BETWEEN 1 AND 100;
+c13
+43
+SELECT c13 FROM BupXPfmCompat_db3.TaBle3 WHERE c13 BETWEEN 1 AND 100;
+c13
+52
+43
+#
+# Cleanup.
+#
+SET GLOBAL backupdir = DEFAULT;
+DROP DATABASE bup_xpfm_compat_db1;
+DROP DATABASE BUP_XPFM_COMPAT_DB2;
+DROP DATABASE BupXPfmCompat_db3;
+DROP USER 'bup_user1'@'%';
+DROP USER 'BUP_USER2';
+DROP USER 'BupUser3'@'%';
+DROP USER 'no_user'@'%';
+#
+# Windows 64 lctn1
+#
+DROP DATABASE IF EXISTS bup_xpfm_compat_db1;
+DROP DATABASE IF EXISTS BUP_XPFM_COMPAT_DB2;
+DROP DATABASE IF EXISTS BupXPfmCompat_db3;
+#
+# Check setting of lower_case_table_names.
+#
+SELECT @@lower_case_table_names;
+@@lower_case_table_names
+2
+#
+# Set character set for table contents.
+#
+SET NAMES 'utf8';
+#
+# Create users. Required to exist by RESTORE.
+#
+CREATE USER 'bup_user1'@'%';
+CREATE USER 'BUP_USER2';
+CREATE USER 'BupUser3'@'%';
+CREATE USER 'no_user'@'%';
+#
+# Set backupdir = '$MYSQL_TEST_DIR/suite/backup/std_data'
+#
+#
+# Restore.
+#
+RESTORE FROM 'backup_xpfm_compat_lctn1-windows_64.bak' OVERWRITE;
+backup_id
+#
+#
+# Check object existence.
+#
+SELECT SCHEMA_NAME
+FROM INFORMATION_SCHEMA.SCHEMATA
+WHERE SCHEMA_NAME like 'bup%xpfm%compat%'
+ ORDER BY LOWER(SCHEMA_NAME);
+SCHEMA_NAME
+bupxpfmcompat_db3
+bup_xpfm_compat_db1
+bup_xpfm_compat_db2
+SELECT TABLESPACE_NAME
+FROM INFORMATION_SCHEMA.TABLESPACES
+WHERE TABLESPACE_NAME like 'bup%xpfm%compat%'
+ ORDER BY LOWER(TABLESPACE_NAME);
+TABLESPACE_NAME
+SELECT TABLE_SCHEMA, TABLE_NAME
+FROM INFORMATION_SCHEMA.TABLES
+WHERE TABLE_SCHEMA like 'bup%xpfm%compat%'
+ AND TABLE_TYPE != 'VIEW'
+ ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME);
+TABLE_SCHEMA TABLE_NAME
+bupxpfmcompat_db3 table1
+bupxpfmcompat_db3 table2
+bupxpfmcompat_db3 table3
+bup_xpfm_compat_db1 table1
+bup_xpfm_compat_db1 table2
+bup_xpfm_compat_db1 table3
+bup_xpfm_compat_db2 table1
+bup_xpfm_compat_db2 table2
+bup_xpfm_compat_db2 table3
+SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE,
+CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION
+FROM INFORMATION_SCHEMA.COLUMNS
+WHERE TABLE_SCHEMA like 'bup%xpfm%compat%'
+ ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME), LOWER(COLUMN_NAME);
+TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH NUMERIC_PRECISION
+bupxpfmcompat_db3 table1 c01 bit NULL 1
+bupxpfmcompat_db3 table1 c02 bit NULL 64
+bupxpfmcompat_db3 table1 c03 tinyint NULL 3
+bupxpfmcompat_db3 table1 c04 tinyint NULL 3
+bupxpfmcompat_db3 table1 c05 tinyint NULL 3
+bupxpfmcompat_db3 table1 c06 tinyint NULL 3
+bupxpfmcompat_db3 table1 c07 smallint NULL 5
+bupxpfmcompat_db3 table1 c08 smallint NULL 5
+bupxpfmcompat_db3 table1 c09 smallint NULL 5
+bupxpfmcompat_db3 table1 c10 mediumint NULL 7
+bupxpfmcompat_db3 table1 c11 mediumint NULL 7
+bupxpfmcompat_db3 table1 c12 mediumint NULL 7
+bupxpfmcompat_db3 table1 c13 int NULL 10
+bupxpfmcompat_db3 table1 c14 int NULL 10
+bupxpfmcompat_db3 table1 c15 int NULL 10
+bupxpfmcompat_db3 table1 c16 bigint NULL 19
+bupxpfmcompat_db3 table1 c17 bigint NULL 19
+bupxpfmcompat_db3 table1 c18 bigint NULL 19
+bupxpfmcompat_db3 table1 c19 float NULL 12
+bupxpfmcompat_db3 table1 c20 float NULL 12
+bupxpfmcompat_db3 table1 c21 float NULL 12
+bupxpfmcompat_db3 table1 c22 double NULL 22
+bupxpfmcompat_db3 table1 c23 double NULL 22
+bupxpfmcompat_db3 table1 c24 double NULL 22
+bupxpfmcompat_db3 table1 c25 decimal NULL 10
+bupxpfmcompat_db3 table1 c26 decimal NULL 10
+bupxpfmcompat_db3 table1 c27 decimal NULL 10
+bupxpfmcompat_db3 table1 c28 date NULL NULL
+bupxpfmcompat_db3 table1 c29 datetime NULL NULL
+bupxpfmcompat_db3 table1 c30 timestamp NULL NULL
+bupxpfmcompat_db3 table1 c31 time NULL NULL
+bupxpfmcompat_db3 table1 c32 year NULL NULL
+bupxpfmcompat_db3 table1 c33 char 1 NULL
+bupxpfmcompat_db3 table1 c34 char 0 NULL
+bupxpfmcompat_db3 table1 c35 char 1 NULL
+bupxpfmcompat_db3 table1 c36 char 255 NULL
+bupxpfmcompat_db3 table1 c37 char 1 NULL
+bupxpfmcompat_db3 table1 c38 char 0 NULL
+bupxpfmcompat_db3 table1 c39 char 1 NULL
+bupxpfmcompat_db3 table1 c40 char 255 NULL
+bupxpfmcompat_db3 table1 c41 char 1 NULL
+bupxpfmcompat_db3 table1 c42 char 0 NULL
+bupxpfmcompat_db3 table1 c43 char 1 NULL
+bupxpfmcompat_db3 table1 c44 char 255 NULL
+bupxpfmcompat_db3 table1 c45 varchar 0 NULL
+bupxpfmcompat_db3 table1 c46 varchar 1 NULL
+bupxpfmcompat_db3 table1 c47 varchar 255 NULL
+bupxpfmcompat_db3 table1 c48 varchar 261 NULL
+bupxpfmcompat_db3 table1 c49 varchar 0 NULL
+bupxpfmcompat_db3 table1 c50 varchar 1 NULL
+bupxpfmcompat_db3 table1 c51 varchar 255 NULL
+bupxpfmcompat_db3 table1 c52 varchar 261 NULL
+bupxpfmcompat_db3 table1 c53 varchar 0 NULL
+bupxpfmcompat_db3 table1 c54 varchar 1 NULL
+bupxpfmcompat_db3 table1 c55 varchar 255 NULL
+bupxpfmcompat_db3 table1 c56 varchar 261 NULL
+bupxpfmcompat_db3 table1 c57 binary 1 NULL
+bupxpfmcompat_db3 table1 c58 binary 0 NULL
+bupxpfmcompat_db3 table1 c59 binary 1 NULL
+bupxpfmcompat_db3 table1 c60 binary 255 NULL
+bupxpfmcompat_db3 table1 c61 varbinary 0 NULL
+bupxpfmcompat_db3 table1 c62 varbinary 1 NULL
+bupxpfmcompat_db3 table1 c63 varbinary 255 NULL
+bupxpfmcompat_db3 table1 c64 varbinary 261 NULL
+bupxpfmcompat_db3 table1 c65 tinyblob 255 NULL
+bupxpfmcompat_db3 table1 c66 tinytext 255 NULL
+bupxpfmcompat_db3 table1 c67 tinytext 127 NULL
+bupxpfmcompat_db3 table1 c68 blob 65535 NULL
+bupxpfmcompat_db3 table1 c69 text 65535 NULL
+bupxpfmcompat_db3 table1 c70 text 32767 NULL
+bupxpfmcompat_db3 table1 c71 mediumblob 16777215 NULL
+bupxpfmcompat_db3 table1 c72 mediumtext 16777215 NULL
+bupxpfmcompat_db3 table1 c73 mediumtext 8388607 NULL
+bupxpfmcompat_db3 table1 c74 longblob 4294967295 NULL
+bupxpfmcompat_db3 table1 c75 longtext 4294967295 NULL
+bupxpfmcompat_db3 table1 c76 longtext 2147483647 NULL
+bupxpfmcompat_db3 table1 c77 enum 1 NULL
+bupxpfmcompat_db3 table1 c78 set 5 NULL
+bupxpfmcompat_db3 table1 crn int NULL 10
+bupxpfmcompat_db3 table2 c01 bit NULL 1
+bupxpfmcompat_db3 table2 c02 bit NULL 64
+bupxpfmcompat_db3 table2 c03 tinyint NULL 3
+bupxpfmcompat_db3 table2 c04 tinyint NULL 3
+bupxpfmcompat_db3 table2 c05 tinyint NULL 3
+bupxpfmcompat_db3 table2 c06 tinyint NULL 3
+bupxpfmcompat_db3 table2 c07 smallint NULL 5
+bupxpfmcompat_db3 table2 c08 smallint NULL 5
+bupxpfmcompat_db3 table2 c09 smallint NULL 5
+bupxpfmcompat_db3 table2 c10 mediumint NULL 7
+bupxpfmcompat_db3 table2 c11 mediumint NULL 7
+bupxpfmcompat_db3 table2 c12 mediumint NULL 7
+bupxpfmcompat_db3 table2 c13 int NULL 10
+bupxpfmcompat_db3 table2 c14 int NULL 10
+bupxpfmcompat_db3 table2 c15 int NULL 10
+bupxpfmcompat_db3 table2 c16 bigint NULL 19
+bupxpfmcompat_db3 table2 c17 bigint NULL 19
+bupxpfmcompat_db3 table2 c18 bigint NULL 19
+bupxpfmcompat_db3 table2 c19 float NULL 12
+bupxpfmcompat_db3 table2 c20 float NULL 12
+bupxpfmcompat_db3 table2 c21 float NULL 12
+bupxpfmcompat_db3 table2 c22 double NULL 22
+bupxpfmcompat_db3 table2 c23 double NULL 22
+bupxpfmcompat_db3 table2 c24 double NULL 22
+bupxpfmcompat_db3 table2 c25 decimal NULL 10
+bupxpfmcompat_db3 table2 c26 decimal NULL 10
+bupxpfmcompat_db3 table2 c27 decimal NULL 10
+bupxpfmcompat_db3 table2 c28 date NULL NULL
+bupxpfmcompat_db3 table2 c29 datetime NULL NULL
+bupxpfmcompat_db3 table2 c30 timestamp NULL NULL
+bupxpfmcompat_db3 table2 c31 time NULL NULL
+bupxpfmcompat_db3 table2 c32 year NULL NULL
+bupxpfmcompat_db3 table2 c33 char 1 NULL
+bupxpfmcompat_db3 table2 c34 char 0 NULL
+bupxpfmcompat_db3 table2 c35 char 1 NULL
+bupxpfmcompat_db3 table2 c36 char 255 NULL
+bupxpfmcompat_db3 table2 c37 char 1 NULL
+bupxpfmcompat_db3 table2 c38 char 0 NULL
+bupxpfmcompat_db3 table2 c39 char 1 NULL
+bupxpfmcompat_db3 table2 c40 char 255 NULL
+bupxpfmcompat_db3 table2 c41 char 1 NULL
+bupxpfmcompat_db3 table2 c42 char 0 NULL
+bupxpfmcompat_db3 table2 c43 char 1 NULL
+bupxpfmcompat_db3 table2 c44 char 255 NULL
+bupxpfmcompat_db3 table2 c45 varchar 0 NULL
+bupxpfmcompat_db3 table2 c46 varchar 1 NULL
+bupxpfmcompat_db3 table2 c47 varchar 255 NULL
+bupxpfmcompat_db3 table2 c48 varchar 261 NULL
+bupxpfmcompat_db3 table2 c49 varchar 0 NULL
+bupxpfmcompat_db3 table2 c50 varchar 1 NULL
+bupxpfmcompat_db3 table2 c51 varchar 255 NULL
+bupxpfmcompat_db3 table2 c52 varchar 261 NULL
+bupxpfmcompat_db3 table2 c53 varchar 0 NULL
+bupxpfmcompat_db3 table2 c54 varchar 1 NULL
+bupxpfmcompat_db3 table2 c55 varchar 255 NULL
+bupxpfmcompat_db3 table2 c56 varchar 261 NULL
+bupxpfmcompat_db3 table2 c57 binary 1 NULL
+bupxpfmcompat_db3 table2 c58 binary 0 NULL
+bupxpfmcompat_db3 table2 c59 binary 1 NULL
+bupxpfmcompat_db3 table2 c60 binary 255 NULL
+bupxpfmcompat_db3 table2 c61 varbinary 0 NULL
+bupxpfmcompat_db3 table2 c62 varbinary 1 NULL
+bupxpfmcompat_db3 table2 c63 varbinary 255 NULL
+bupxpfmcompat_db3 table2 c64 varbinary 261 NULL
+bupxpfmcompat_db3 table2 c65 tinyblob 255 NULL
+bupxpfmcompat_db3 table2 c66 tinytext 255 NULL
+bupxpfmcompat_db3 table2 c67 tinytext 127 NULL
+bupxpfmcompat_db3 table2 c68 blob 65535 NULL
+bupxpfmcompat_db3 table2 c69 text 65535 NULL
+bupxpfmcompat_db3 table2 c70 text 32767 NULL
+bupxpfmcompat_db3 table2 c71 mediumblob 16777215 NULL
+bupxpfmcompat_db3 table2 c72 mediumtext 16777215 NULL
+bupxpfmcompat_db3 table2 c73 mediumtext 8388607 NULL
+bupxpfmcompat_db3 table2 c74 longblob 4294967295 NULL
+bupxpfmcompat_db3 table2 c75 longtext 4294967295 NULL
+bupxpfmcompat_db3 table2 c76 longtext 2147483647 NULL
+bupxpfmcompat_db3 table2 c77 enum 1 NULL
+bupxpfmcompat_db3 table2 c78 set 5 NULL
+bupxpfmcompat_db3 table2 crn int NULL 10
+bupxpfmcompat_db3 table3 c01 bit NULL 1
+bupxpfmcompat_db3 table3 c02 bit NULL 64
+bupxpfmcompat_db3 table3 c03 tinyint NULL 3
+bupxpfmcompat_db3 table3 c04 tinyint NULL 3
+bupxpfmcompat_db3 table3 c05 tinyint NULL 3
+bupxpfmcompat_db3 table3 c06 tinyint NULL 3
+bupxpfmcompat_db3 table3 c07 smallint NULL 5
+bupxpfmcompat_db3 table3 c08 smallint NULL 5
+bupxpfmcompat_db3 table3 c09 smallint NULL 5
+bupxpfmcompat_db3 table3 c10 mediumint NULL 7
+bupxpfmcompat_db3 table3 c11 mediumint NULL 7
+bupxpfmcompat_db3 table3 c12 mediumint NULL 7
+bupxpfmcompat_db3 table3 c13 int NULL 10
+bupxpfmcompat_db3 table3 c14 int NULL 10
+bupxpfmcompat_db3 table3 c15 int NULL 10
+bupxpfmcompat_db3 table3 c16 bigint NULL 19
+bupxpfmcompat_db3 table3 c17 bigint NULL 19
+bupxpfmcompat_db3 table3 c18 bigint NULL 19
+bupxpfmcompat_db3 table3 c19 float NULL 12
+bupxpfmcompat_db3 table3 c20 float NULL 12
+bupxpfmcompat_db3 table3 c21 float NULL 12
+bupxpfmcompat_db3 table3 c22 double NULL 22
+bupxpfmcompat_db3 table3 c23 double NULL 22
+bupxpfmcompat_db3 table3 c24 double NULL 22
+bupxpfmcompat_db3 table3 c25 decimal NULL 10
+bupxpfmcompat_db3 table3 c26 decimal NULL 10
+bupxpfmcompat_db3 table3 c27 decimal NULL 10
+bupxpfmcompat_db3 table3 c28 date NULL NULL
+bupxpfmcompat_db3 table3 c29 datetime NULL NULL
+bupxpfmcompat_db3 table3 c30 timestamp NULL NULL
+bupxpfmcompat_db3 table3 c31 time NULL NULL
+bupxpfmcompat_db3 table3 c32 year NULL NULL
+bupxpfmcompat_db3 table3 c33 char 1 NULL
+bupxpfmcompat_db3 table3 c34 char 0 NULL
+bupxpfmcompat_db3 table3 c35 char 1 NULL
+bupxpfmcompat_db3 table3 c36 char 255 NULL
+bupxpfmcompat_db3 table3 c37 char 1 NULL
+bupxpfmcompat_db3 table3 c38 char 0 NULL
+bupxpfmcompat_db3 table3 c39 char 1 NULL
+bupxpfmcompat_db3 table3 c40 char 255 NULL
+bupxpfmcompat_db3 table3 c41 char 1 NULL
+bupxpfmcompat_db3 table3 c42 char 0 NULL
+bupxpfmcompat_db3 table3 c43 char 1 NULL
+bupxpfmcompat_db3 table3 c44 char 255 NULL
+bupxpfmcompat_db3 table3 c45 varchar 0 NULL
+bupxpfmcompat_db3 table3 c46 varchar 1 NULL
+bupxpfmcompat_db3 table3 c47 varchar 255 NULL
+bupxpfmcompat_db3 table3 c48 varchar 261 NULL
+bupxpfmcompat_db3 table3 c49 varchar 0 NULL
+bupxpfmcompat_db3 table3 c50 varchar 1 NULL
+bupxpfmcompat_db3 table3 c51 varchar 255 NULL
+bupxpfmcompat_db3 table3 c52 varchar 261 NULL
+bupxpfmcompat_db3 table3 c53 varchar 0 NULL
+bupxpfmcompat_db3 table3 c54 varchar 1 NULL
+bupxpfmcompat_db3 table3 c55 varchar 255 NULL
+bupxpfmcompat_db3 table3 c56 varchar 261 NULL
+bupxpfmcompat_db3 table3 c57 binary 1 NULL
+bupxpfmcompat_db3 table3 c58 binary 0 NULL
+bupxpfmcompat_db3 table3 c59 binary 1 NULL
+bupxpfmcompat_db3 table3 c60 binary 255 NULL
+bupxpfmcompat_db3 table3 c61 varbinary 0 NULL
+bupxpfmcompat_db3 table3 c62 varbinary 1 NULL
+bupxpfmcompat_db3 table3 c63 varbinary 255 NULL
+bupxpfmcompat_db3 table3 c64 varbinary 261 NULL
+bupxpfmcompat_db3 table3 c65 tinyblob 255 NULL
+bupxpfmcompat_db3 table3 c66 tinytext 255 NULL
+bupxpfmcompat_db3 table3 c67 tinytext 127 NULL
+bupxpfmcompat_db3 table3 c68 blob 65535 NULL
+bupxpfmcompat_db3 table3 c69 text 65535 NULL
+bupxpfmcompat_db3 table3 c70 text 32767 NULL
+bupxpfmcompat_db3 table3 c71 mediumblob 16777215 NULL
+bupxpfmcompat_db3 table3 c72 mediumtext 16777215 NULL
+bupxpfmcompat_db3 table3 c73 mediumtext 8388607 NULL
+bupxpfmcompat_db3 table3 c74 longblob 4294967295 NULL
+bupxpfmcompat_db3 table3 c75 longtext 4294967295 NULL
+bupxpfmcompat_db3 table3 c76 longtext 2147483647 NULL
+bupxpfmcompat_db3 table3 c77 enum 1 NULL
+bupxpfmcompat_db3 table3 c78 set 5 NULL
+bupxpfmcompat_db3 table3 crn int NULL 10
+bupxpfmcompat_db3 view1 c1 int NULL 10
+bupxpfmcompat_db3 view1 c2 int NULL 10
+bupxpfmcompat_db3 view2 c1 int NULL 10
+bupxpfmcompat_db3 view2 c2 int NULL 10
+bupxpfmcompat_db3 view3 c1 int NULL 10
+bupxpfmcompat_db3 view3 c2 int NULL 10
+bup_xpfm_compat_db1 table1 c01 bit NULL 1
+bup_xpfm_compat_db1 table1 c02 bit NULL 64
+bup_xpfm_compat_db1 table1 c03 tinyint NULL 3
+bup_xpfm_compat_db1 table1 c04 tinyint NULL 3
+bup_xpfm_compat_db1 table1 c05 tinyint NULL 3
+bup_xpfm_compat_db1 table1 c06 tinyint NULL 3
+bup_xpfm_compat_db1 table1 c07 smallint NULL 5
+bup_xpfm_compat_db1 table1 c08 smallint NULL 5
+bup_xpfm_compat_db1 table1 c09 smallint NULL 5
+bup_xpfm_compat_db1 table1 c10 mediumint NULL 7
+bup_xpfm_compat_db1 table1 c11 mediumint NULL 7
+bup_xpfm_compat_db1 table1 c12 mediumint NULL 7
+bup_xpfm_compat_db1 table1 c13 int NULL 10
+bup_xpfm_compat_db1 table1 c14 int NULL 10
+bup_xpfm_compat_db1 table1 c15 int NULL 10
+bup_xpfm_compat_db1 table1 c16 bigint NULL 19
+bup_xpfm_compat_db1 table1 c17 bigint NULL 19
+bup_xpfm_compat_db1 table1 c18 bigint NULL 19
+bup_xpfm_compat_db1 table1 c19 float NULL 12
+bup_xpfm_compat_db1 table1 c20 float NULL 12
+bup_xpfm_compat_db1 table1 c21 float NULL 12
+bup_xpfm_compat_db1 table1 c22 double NULL 22
+bup_xpfm_compat_db1 table1 c23 double NULL 22
+bup_xpfm_compat_db1 table1 c24 double NULL 22
+bup_xpfm_compat_db1 table1 c25 decimal NULL 10
+bup_xpfm_compat_db1 table1 c26 decimal NULL 10
+bup_xpfm_compat_db1 table1 c27 decimal NULL 10
+bup_xpfm_compat_db1 table1 c28 date NULL NULL
+bup_xpfm_compat_db1 table1 c29 datetime NULL NULL
+bup_xpfm_compat_db1 table1 c30 timestamp NULL NULL
+bup_xpfm_compat_db1 table1 c31 time NULL NULL
+bup_xpfm_compat_db1 table1 c32 year NULL NULL
+bup_xpfm_compat_db1 table1 c33 char 1 NULL
+bup_xpfm_compat_db1 table1 c34 char 0 NULL
+bup_xpfm_compat_db1 table1 c35 char 1 NULL
+bup_xpfm_compat_db1 table1 c36 char 255 NULL
+bup_xpfm_compat_db1 table1 c37 char 1 NULL
+bup_xpfm_compat_db1 table1 c38 char 0 NULL
+bup_xpfm_compat_db1 table1 c39 char 1 NULL
+bup_xpfm_compat_db1 table1 c40 char 255 NULL
+bup_xpfm_compat_db1 table1 c41 char 1 NULL
+bup_xpfm_compat_db1 table1 c42 char 0 NULL
+bup_xpfm_compat_db1 table1 c43 char 1 NULL
+bup_xpfm_compat_db1 table1 c44 char 255 NULL
+bup_xpfm_compat_db1 table1 c45 varchar 0 NULL
+bup_xpfm_compat_db1 table1 c46 varchar 1 NULL
+bup_xpfm_compat_db1 table1 c47 varchar 255 NULL
+bup_xpfm_compat_db1 table1 c48 varchar 261 NULL
+bup_xpfm_compat_db1 table1 c49 varchar 0 NULL
+bup_xpfm_compat_db1 table1 c50 varchar 1 NULL
+bup_xpfm_compat_db1 table1 c51 varchar 255 NULL
+bup_xpfm_compat_db1 table1 c52 varchar 261 NULL
+bup_xpfm_compat_db1 table1 c53 varchar 0 NULL
+bup_xpfm_compat_db1 table1 c54 varchar 1 NULL
+bup_xpfm_compat_db1 table1 c55 varchar 255 NULL
+bup_xpfm_compat_db1 table1 c56 varchar 261 NULL
+bup_xpfm_compat_db1 table1 c57 binary 1 NULL
+bup_xpfm_compat_db1 table1 c58 binary 0 NULL
+bup_xpfm_compat_db1 table1 c59 binary 1 NULL
+bup_xpfm_compat_db1 table1 c60 binary 255 NULL
+bup_xpfm_compat_db1 table1 c61 varbinary 0 NULL
+bup_xpfm_compat_db1 table1 c62 varbinary 1 NULL
+bup_xpfm_compat_db1 table1 c63 varbinary 255 NULL
+bup_xpfm_compat_db1 table1 c64 varbinary 261 NULL
+bup_xpfm_compat_db1 table1 c65 tinyblob 255 NULL
+bup_xpfm_compat_db1 table1 c66 tinytext 255 NULL
+bup_xpfm_compat_db1 table1 c67 tinytext 127 NULL
+bup_xpfm_compat_db1 table1 c68 blob 65535 NULL
+bup_xpfm_compat_db1 table1 c69 text 65535 NULL
+bup_xpfm_compat_db1 table1 c70 text 32767 NULL
+bup_xpfm_compat_db1 table1 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db1 table1 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db1 table1 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db1 table1 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db1 table1 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db1 table1 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db1 table1 c77 enum 1 NULL
+bup_xpfm_compat_db1 table1 c78 set 5 NULL
+bup_xpfm_compat_db1 table1 crn int NULL 10
+bup_xpfm_compat_db1 table2 c01 bit NULL 1
+bup_xpfm_compat_db1 table2 c02 bit NULL 64
+bup_xpfm_compat_db1 table2 c03 tinyint NULL 3
+bup_xpfm_compat_db1 table2 c04 tinyint NULL 3
+bup_xpfm_compat_db1 table2 c05 tinyint NULL 3
+bup_xpfm_compat_db1 table2 c06 tinyint NULL 3
+bup_xpfm_compat_db1 table2 c07 smallint NULL 5
+bup_xpfm_compat_db1 table2 c08 smallint NULL 5
+bup_xpfm_compat_db1 table2 c09 smallint NULL 5
+bup_xpfm_compat_db1 table2 c10 mediumint NULL 7
+bup_xpfm_compat_db1 table2 c11 mediumint NULL 7
+bup_xpfm_compat_db1 table2 c12 mediumint NULL 7
+bup_xpfm_compat_db1 table2 c13 int NULL 10
+bup_xpfm_compat_db1 table2 c14 int NULL 10
+bup_xpfm_compat_db1 table2 c15 int NULL 10
+bup_xpfm_compat_db1 table2 c16 bigint NULL 19
+bup_xpfm_compat_db1 table2 c17 bigint NULL 19
+bup_xpfm_compat_db1 table2 c18 bigint NULL 19
+bup_xpfm_compat_db1 table2 c19 float NULL 12
+bup_xpfm_compat_db1 table2 c20 float NULL 12
+bup_xpfm_compat_db1 table2 c21 float NULL 12
+bup_xpfm_compat_db1 table2 c22 double NULL 22
+bup_xpfm_compat_db1 table2 c23 double NULL 22
+bup_xpfm_compat_db1 table2 c24 double NULL 22
+bup_xpfm_compat_db1 table2 c25 decimal NULL 10
+bup_xpfm_compat_db1 table2 c26 decimal NULL 10
+bup_xpfm_compat_db1 table2 c27 decimal NULL 10
+bup_xpfm_compat_db1 table2 c28 date NULL NULL
+bup_xpfm_compat_db1 table2 c29 datetime NULL NULL
+bup_xpfm_compat_db1 table2 c30 timestamp NULL NULL
+bup_xpfm_compat_db1 table2 c31 time NULL NULL
+bup_xpfm_compat_db1 table2 c32 year NULL NULL
+bup_xpfm_compat_db1 table2 c33 char 1 NULL
+bup_xpfm_compat_db1 table2 c34 char 0 NULL
+bup_xpfm_compat_db1 table2 c35 char 1 NULL
+bup_xpfm_compat_db1 table2 c36 char 255 NULL
+bup_xpfm_compat_db1 table2 c37 char 1 NULL
+bup_xpfm_compat_db1 table2 c38 char 0 NULL
+bup_xpfm_compat_db1 table2 c39 char 1 NULL
+bup_xpfm_compat_db1 table2 c40 char 255 NULL
+bup_xpfm_compat_db1 table2 c41 char 1 NULL
+bup_xpfm_compat_db1 table2 c42 char 0 NULL
+bup_xpfm_compat_db1 table2 c43 char 1 NULL
+bup_xpfm_compat_db1 table2 c44 char 255 NULL
+bup_xpfm_compat_db1 table2 c45 varchar 0 NULL
+bup_xpfm_compat_db1 table2 c46 varchar 1 NULL
+bup_xpfm_compat_db1 table2 c47 varchar 255 NULL
+bup_xpfm_compat_db1 table2 c48 varchar 261 NULL
+bup_xpfm_compat_db1 table2 c49 varchar 0 NULL
+bup_xpfm_compat_db1 table2 c50 varchar 1 NULL
+bup_xpfm_compat_db1 table2 c51 varchar 255 NULL
+bup_xpfm_compat_db1 table2 c52 varchar 261 NULL
+bup_xpfm_compat_db1 table2 c53 varchar 0 NULL
+bup_xpfm_compat_db1 table2 c54 varchar 1 NULL
+bup_xpfm_compat_db1 table2 c55 varchar 255 NULL
+bup_xpfm_compat_db1 table2 c56 varchar 261 NULL
+bup_xpfm_compat_db1 table2 c57 binary 1 NULL
+bup_xpfm_compat_db1 table2 c58 binary 0 NULL
+bup_xpfm_compat_db1 table2 c59 binary 1 NULL
+bup_xpfm_compat_db1 table2 c60 binary 255 NULL
+bup_xpfm_compat_db1 table2 c61 varbinary 0 NULL
+bup_xpfm_compat_db1 table2 c62 varbinary 1 NULL
+bup_xpfm_compat_db1 table2 c63 varbinary 255 NULL
+bup_xpfm_compat_db1 table2 c64 varbinary 261 NULL
+bup_xpfm_compat_db1 table2 c65 tinyblob 255 NULL
+bup_xpfm_compat_db1 table2 c66 tinytext 255 NULL
+bup_xpfm_compat_db1 table2 c67 tinytext 127 NULL
+bup_xpfm_compat_db1 table2 c68 blob 65535 NULL
+bup_xpfm_compat_db1 table2 c69 text 65535 NULL
+bup_xpfm_compat_db1 table2 c70 text 32767 NULL
+bup_xpfm_compat_db1 table2 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db1 table2 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db1 table2 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db1 table2 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db1 table2 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db1 table2 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db1 table2 c77 enum 1 NULL
+bup_xpfm_compat_db1 table2 c78 set 5 NULL
+bup_xpfm_compat_db1 table2 crn int NULL 10
+bup_xpfm_compat_db1 table3 c01 bit NULL 1
+bup_xpfm_compat_db1 table3 c02 bit NULL 64
+bup_xpfm_compat_db1 table3 c03 tinyint NULL 3
+bup_xpfm_compat_db1 table3 c04 tinyint NULL 3
+bup_xpfm_compat_db1 table3 c05 tinyint NULL 3
+bup_xpfm_compat_db1 table3 c06 tinyint NULL 3
+bup_xpfm_compat_db1 table3 c07 smallint NULL 5
+bup_xpfm_compat_db1 table3 c08 smallint NULL 5
+bup_xpfm_compat_db1 table3 c09 smallint NULL 5
+bup_xpfm_compat_db1 table3 c10 mediumint NULL 7
+bup_xpfm_compat_db1 table3 c11 mediumint NULL 7
+bup_xpfm_compat_db1 table3 c12 mediumint NULL 7
+bup_xpfm_compat_db1 table3 c13 int NULL 10
+bup_xpfm_compat_db1 table3 c14 int NULL 10
+bup_xpfm_compat_db1 table3 c15 int NULL 10
+bup_xpfm_compat_db1 table3 c16 bigint NULL 19
+bup_xpfm_compat_db1 table3 c17 bigint NULL 19
+bup_xpfm_compat_db1 table3 c18 bigint NULL 19
+bup_xpfm_compat_db1 table3 c19 float NULL 12
+bup_xpfm_compat_db1 table3 c20 float NULL 12
+bup_xpfm_compat_db1 table3 c21 float NULL 12
+bup_xpfm_compat_db1 table3 c22 double NULL 22
+bup_xpfm_compat_db1 table3 c23 double NULL 22
+bup_xpfm_compat_db1 table3 c24 double NULL 22
+bup_xpfm_compat_db1 table3 c25 decimal NULL 10
+bup_xpfm_compat_db1 table3 c26 decimal NULL 10
+bup_xpfm_compat_db1 table3 c27 decimal NULL 10
+bup_xpfm_compat_db1 table3 c28 date NULL NULL
+bup_xpfm_compat_db1 table3 c29 datetime NULL NULL
+bup_xpfm_compat_db1 table3 c30 timestamp NULL NULL
+bup_xpfm_compat_db1 table3 c31 time NULL NULL
+bup_xpfm_compat_db1 table3 c32 year NULL NULL
+bup_xpfm_compat_db1 table3 c33 char 1 NULL
+bup_xpfm_compat_db1 table3 c34 char 0 NULL
+bup_xpfm_compat_db1 table3 c35 char 1 NULL
+bup_xpfm_compat_db1 table3 c36 char 255 NULL
+bup_xpfm_compat_db1 table3 c37 char 1 NULL
+bup_xpfm_compat_db1 table3 c38 char 0 NULL
+bup_xpfm_compat_db1 table3 c39 char 1 NULL
+bup_xpfm_compat_db1 table3 c40 char 255 NULL
+bup_xpfm_compat_db1 table3 c41 char 1 NULL
+bup_xpfm_compat_db1 table3 c42 char 0 NULL
+bup_xpfm_compat_db1 table3 c43 char 1 NULL
+bup_xpfm_compat_db1 table3 c44 char 255 NULL
+bup_xpfm_compat_db1 table3 c45 varchar 0 NULL
+bup_xpfm_compat_db1 table3 c46 varchar 1 NULL
+bup_xpfm_compat_db1 table3 c47 varchar 255 NULL
+bup_xpfm_compat_db1 table3 c48 varchar 261 NULL
+bup_xpfm_compat_db1 table3 c49 varchar 0 NULL
+bup_xpfm_compat_db1 table3 c50 varchar 1 NULL
+bup_xpfm_compat_db1 table3 c51 varchar 255 NULL
+bup_xpfm_compat_db1 table3 c52 varchar 261 NULL
+bup_xpfm_compat_db1 table3 c53 varchar 0 NULL
+bup_xpfm_compat_db1 table3 c54 varchar 1 NULL
+bup_xpfm_compat_db1 table3 c55 varchar 255 NULL
+bup_xpfm_compat_db1 table3 c56 varchar 261 NULL
+bup_xpfm_compat_db1 table3 c57 binary 1 NULL
+bup_xpfm_compat_db1 table3 c58 binary 0 NULL
+bup_xpfm_compat_db1 table3 c59 binary 1 NULL
+bup_xpfm_compat_db1 table3 c60 binary 255 NULL
+bup_xpfm_compat_db1 table3 c61 varbinary 0 NULL
+bup_xpfm_compat_db1 table3 c62 varbinary 1 NULL
+bup_xpfm_compat_db1 table3 c63 varbinary 255 NULL
+bup_xpfm_compat_db1 table3 c64 varbinary 261 NULL
+bup_xpfm_compat_db1 table3 c65 tinyblob 255 NULL
+bup_xpfm_compat_db1 table3 c66 tinytext 255 NULL
+bup_xpfm_compat_db1 table3 c67 tinytext 127 NULL
+bup_xpfm_compat_db1 table3 c68 blob 65535 NULL
+bup_xpfm_compat_db1 table3 c69 text 65535 NULL
+bup_xpfm_compat_db1 table3 c70 text 32767 NULL
+bup_xpfm_compat_db1 table3 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db1 table3 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db1 table3 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db1 table3 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db1 table3 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db1 table3 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db1 table3 c77 enum 1 NULL
+bup_xpfm_compat_db1 table3 c78 set 5 NULL
+bup_xpfm_compat_db1 table3 crn int NULL 10
+bup_xpfm_compat_db1 view1 c1 int NULL 10
+bup_xpfm_compat_db1 view1 c2 varchar 261 NULL
+bup_xpfm_compat_db1 view1 c3 int NULL 10
+bup_xpfm_compat_db1 view1 c4 int NULL 10
+bup_xpfm_compat_db1 view2 c2 varchar 261 NULL
+bup_xpfm_compat_db1 view2 c3 int NULL 10
+bup_xpfm_compat_db1 view3 c3 int NULL 10
+bup_xpfm_compat_db1 view3 c4 int NULL 10
+bup_xpfm_compat_db2 table1 c01 bit NULL 1
+bup_xpfm_compat_db2 table1 c02 bit NULL 64
+bup_xpfm_compat_db2 table1 c03 tinyint NULL 3
+bup_xpfm_compat_db2 table1 c04 tinyint NULL 3
+bup_xpfm_compat_db2 table1 c05 tinyint NULL 3
+bup_xpfm_compat_db2 table1 c06 tinyint NULL 3
+bup_xpfm_compat_db2 table1 c07 smallint NULL 5
+bup_xpfm_compat_db2 table1 c08 smallint NULL 5
+bup_xpfm_compat_db2 table1 c09 smallint NULL 5
+bup_xpfm_compat_db2 table1 c10 mediumint NULL 7
+bup_xpfm_compat_db2 table1 c11 mediumint NULL 7
+bup_xpfm_compat_db2 table1 c12 mediumint NULL 7
+bup_xpfm_compat_db2 table1 c13 int NULL 10
+bup_xpfm_compat_db2 table1 c14 int NULL 10
+bup_xpfm_compat_db2 table1 c15 int NULL 10
+bup_xpfm_compat_db2 table1 c16 bigint NULL 19
+bup_xpfm_compat_db2 table1 c17 bigint NULL 19
+bup_xpfm_compat_db2 table1 c18 bigint NULL 19
+bup_xpfm_compat_db2 table1 c19 float NULL 12
+bup_xpfm_compat_db2 table1 c20 float NULL 12
+bup_xpfm_compat_db2 table1 c21 float NULL 12
+bup_xpfm_compat_db2 table1 c22 double NULL 22
+bup_xpfm_compat_db2 table1 c23 double NULL 22
+bup_xpfm_compat_db2 table1 c24 double NULL 22
+bup_xpfm_compat_db2 table1 c25 decimal NULL 10
+bup_xpfm_compat_db2 table1 c26 decimal NULL 10
+bup_xpfm_compat_db2 table1 c27 decimal NULL 10
+bup_xpfm_compat_db2 table1 c28 date NULL NULL
+bup_xpfm_compat_db2 table1 c29 datetime NULL NULL
+bup_xpfm_compat_db2 table1 c30 timestamp NULL NULL
+bup_xpfm_compat_db2 table1 c31 time NULL NULL
+bup_xpfm_compat_db2 table1 c32 year NULL NULL
+bup_xpfm_compat_db2 table1 c33 char 1 NULL
+bup_xpfm_compat_db2 table1 c34 char 0 NULL
+bup_xpfm_compat_db2 table1 c35 char 1 NULL
+bup_xpfm_compat_db2 table1 c36 char 255 NULL
+bup_xpfm_compat_db2 table1 c37 char 1 NULL
+bup_xpfm_compat_db2 table1 c38 char 0 NULL
+bup_xpfm_compat_db2 table1 c39 char 1 NULL
+bup_xpfm_compat_db2 table1 c40 char 255 NULL
+bup_xpfm_compat_db2 table1 c41 char 1 NULL
+bup_xpfm_compat_db2 table1 c42 char 0 NULL
+bup_xpfm_compat_db2 table1 c43 char 1 NULL
+bup_xpfm_compat_db2 table1 c44 char 255 NULL
+bup_xpfm_compat_db2 table1 c45 varchar 0 NULL
+bup_xpfm_compat_db2 table1 c46 varchar 1 NULL
+bup_xpfm_compat_db2 table1 c47 varchar 255 NULL
+bup_xpfm_compat_db2 table1 c48 varchar 261 NULL
+bup_xpfm_compat_db2 table1 c49 varchar 0 NULL
+bup_xpfm_compat_db2 table1 c50 varchar 1 NULL
+bup_xpfm_compat_db2 table1 c51 varchar 255 NULL
+bup_xpfm_compat_db2 table1 c52 varchar 261 NULL
+bup_xpfm_compat_db2 table1 c53 varchar 0 NULL
+bup_xpfm_compat_db2 table1 c54 varchar 1 NULL
+bup_xpfm_compat_db2 table1 c55 varchar 255 NULL
+bup_xpfm_compat_db2 table1 c56 varchar 261 NULL
+bup_xpfm_compat_db2 table1 c57 binary 1 NULL
+bup_xpfm_compat_db2 table1 c58 binary 0 NULL
+bup_xpfm_compat_db2 table1 c59 binary 1 NULL
+bup_xpfm_compat_db2 table1 c60 binary 255 NULL
+bup_xpfm_compat_db2 table1 c61 varbinary 0 NULL
+bup_xpfm_compat_db2 table1 c62 varbinary 1 NULL
+bup_xpfm_compat_db2 table1 c63 varbinary 255 NULL
+bup_xpfm_compat_db2 table1 c64 varbinary 261 NULL
+bup_xpfm_compat_db2 table1 c65 tinyblob 255 NULL
+bup_xpfm_compat_db2 table1 c66 tinytext 255 NULL
+bup_xpfm_compat_db2 table1 c67 tinytext 127 NULL
+bup_xpfm_compat_db2 table1 c68 blob 65535 NULL
+bup_xpfm_compat_db2 table1 c69 text 65535 NULL
+bup_xpfm_compat_db2 table1 c70 text 32767 NULL
+bup_xpfm_compat_db2 table1 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db2 table1 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db2 table1 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db2 table1 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db2 table1 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db2 table1 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db2 table1 c77 enum 1 NULL
+bup_xpfm_compat_db2 table1 c78 set 5 NULL
+bup_xpfm_compat_db2 table1 crn int NULL 10
+bup_xpfm_compat_db2 table2 c01 bit NULL 1
+bup_xpfm_compat_db2 table2 c02 bit NULL 64
+bup_xpfm_compat_db2 table2 c03 tinyint NULL 3
+bup_xpfm_compat_db2 table2 c04 tinyint NULL 3
+bup_xpfm_compat_db2 table2 c05 tinyint NULL 3
+bup_xpfm_compat_db2 table2 c06 tinyint NULL 3
+bup_xpfm_compat_db2 table2 c07 smallint NULL 5
+bup_xpfm_compat_db2 table2 c08 smallint NULL 5
+bup_xpfm_compat_db2 table2 c09 smallint NULL 5
+bup_xpfm_compat_db2 table2 c10 mediumint NULL 7
+bup_xpfm_compat_db2 table2 c11 mediumint NULL 7
+bup_xpfm_compat_db2 table2 c12 mediumint NULL 7
+bup_xpfm_compat_db2 table2 c13 int NULL 10
+bup_xpfm_compat_db2 table2 c14 int NULL 10
+bup_xpfm_compat_db2 table2 c15 int NULL 10
+bup_xpfm_compat_db2 table2 c16 bigint NULL 19
+bup_xpfm_compat_db2 table2 c17 bigint NULL 19
+bup_xpfm_compat_db2 table2 c18 bigint NULL 19
+bup_xpfm_compat_db2 table2 c19 float NULL 12
+bup_xpfm_compat_db2 table2 c20 float NULL 12
+bup_xpfm_compat_db2 table2 c21 float NULL 12
+bup_xpfm_compat_db2 table2 c22 double NULL 22
+bup_xpfm_compat_db2 table2 c23 double NULL 22
bup_xpfm_compat_db2 table2 c24 double NULL 22
bup_xpfm_compat_db2 table2 c25 decimal NULL 10
bup_xpfm_compat_db2 table2 c26 decimal NULL 10
@@ -11197,15 +12673,1499 @@ FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_SCHEMA like 'bup%xpfm%compat%'
ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME);
TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION
-bupxpfmcompat_db3 view1 select `view1`.`c1` AS `c1`,`view2`.`c1` AS `c2` from (`bup_xpfm_compat_db1`.`view1` join `bup_xpfm_compat_db2`.`view2`) where (`view1`.`c1` = `view2`.`c1`)
-bupxpfmcompat_db3 view2 select `view1`.`c1` AS `c1`,`view2`.`c1` AS `c2` from (`bup_xpfm_compat_db1`.`view1` left join `bup_xpfm_compat_db2`.`view2` on((`view1`.`c1` = `view2`.`c1`)))
-bupxpfmcompat_db3 view3 select `view1`.`c1` AS `c1`,`view1`.`c2` AS `c2` from `bupxpfmcompat_db3`.`view1`
+bupxpfmcompat_db3 view1 select `view1`.`c1` AS `c1`,`view2`.`c1` AS `c2` from (`bup_xpfm_compat_db1`.`view1` join `bup_xpfm_compat_db2`.`view2`) where (`view1`.`c1` = `view2`.`c1`)
+bupxpfmcompat_db3 view2 select `view1`.`c1` AS `c1`,`view2`.`c1` AS `c2` from (`bup_xpfm_compat_db1`.`view1` left join `bup_xpfm_compat_db2`.`view2` on((`view1`.`c1` = `view2`.`c1`)))
+bupxpfmcompat_db3 view3 select `view1`.`c1` AS `c1`,`view1`.`c2` AS `c2` from `bupxpfmcompat_db3`.`view1`
+bup_xpfm_compat_db1 view1 select `bup_xpfm_compat_db1`.`table1`.`c13` AS `c1`,`bup_xpfm_compat_db1`.`table1`.`c48` AS `c2`,`bup_xpfm_compat_db1`.`table1`.`c13` in (select (`bup_xpfm_compat_db1`.`table1`.`c13` + 2) AS `c13+2` from `bup_xpfm_compat_db1`.`table1`) AS `c3`,`bup_xpfm_compat_db1`.`table1`.`c13` = all (select `bup_xpfm_compat_db1`.`table1`.`c13` AS `c13` from `bup_xpfm_compat_db1`.`table1`) AS `c4` from `bup_xpfm_compat_db1`.`table1`
+bup_xpfm_compat_db1 view2 select `view1`.`c2` AS `c2`,`view1`.`c3` AS `c3` from `bup_xpfm_compat_db1`.`view1`
+bup_xpfm_compat_db1 view3 select `view1`.`c3` AS `c3`,`view1`.`c4` AS `c4` from `bup_xpfm_compat_db1`.`view1`
+bup_xpfm_compat_db2 view1 select connection_id() AS `c1`,pi() AS `c2`,current_user() AS `c3`,rpad(version(),40,' ') AS `c4`
+bup_xpfm_compat_db2 view2 select `bup_xpfm_compat_db2`.`table2`.`c13` AS `c1`,`bup_xpfm_compat_db2`.`table2`.`c48` AS `c2` from (`bup_xpfm_compat_db2`.`table2` join `bup_xpfm_compat_db2`.`table3`) union all select `bup_xpfm_compat_db2`.`table2`.`c13` AS `c13`,`bup_xpfm_compat_db2`.`table2`.`c48` AS `c48` from (`bup_xpfm_compat_db2`.`table2` join `bup_xpfm_compat_db2`.`table3`)
+bup_xpfm_compat_db2 view3 select `view1`.`c3` AS `c3`,`view1`.`c4` AS `c4` from `bup_xpfm_compat_db2`.`view1`
+SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
+FROM INFORMATION_SCHEMA.ROUTINES
+WHERE ROUTINE_SCHEMA like 'bup%xpfm%compat%'
+ AND ROUTINE_TYPE = 'PROCEDURE'
+ ORDER BY LOWER(ROUTINE_SCHEMA), LOWER(ROUTINE_NAME);
+ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_DEFINITION
+bupxpfmcompat_db3 proc1 BEGIN
+UPDATE BupXPfmCompat_db3.table1 SET c48='from BupXPfmCompat_db3.proc1';
+END
+bupxpfmcompat_db3 PROC2 BEGIN
+UPDATE BupXPfmCompat_db3.TABLE2 SET c48='from BupXPfmCompat_db3.PROC2';
+END
+bupxpfmcompat_db3 proc3 BEGIN
+UPDATE BupXPfmCompat_db3.TaBle3 SET c48='from BupXPfmCompat_db3.PrOc3';
+END
+bup_xpfm_compat_db1 proc1 BEGIN
+UPDATE bup_xpfm_compat_db1.table1 SET c48='from bup_xpfm_compat_db1.proc1';
+END
+bup_xpfm_compat_db1 PROC2 BEGIN
+UPDATE bup_xpfm_compat_db1.TABLE2 SET c48='from bup_xpfm_compat_db1.PROC2';
+END
+bup_xpfm_compat_db1 PrOc3 BEGIN
+UPDATE bup_xpfm_compat_db1.TaBle3 SET c48='from bup_xpfm_compat_db1.PrOc3';
+END
+bup_xpfm_compat_db2 proc1 BEGIN
+UPDATE BUP_XPFM_COMPAT_DB2.table1 SET c48='from BUP_XPFM_COMPAT_DB2.proc1';
+END
+bup_xpfm_compat_db2 proc2 BEGIN
+UPDATE BUP_XPFM_COMPAT_DB2.TABLE2 SET c48='from BUP_XPFM_COMPAT_DB2.PROC2';
+END
+bup_xpfm_compat_db2 PrOc3 BEGIN
+UPDATE BUP_XPFM_COMPAT_DB2.TaBle3 SET c48='from BUP_XPFM_COMPAT_DB2.PrOc3';
+END
+SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
+FROM INFORMATION_SCHEMA.ROUTINES
+WHERE ROUTINE_SCHEMA like 'bup%xpfm%compat%'
+ AND ROUTINE_TYPE = 'FUNCTION'
+ ORDER BY LOWER(ROUTINE_SCHEMA), LOWER(ROUTINE_NAME);
+ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_DEFINITION
+bupxpfmcompat_db3 func1 BEGIN
+RETURN arg1 * 31;
+END
+bupxpfmcompat_db3 FUNC2 BEGIN
+RETURN arg1 * 32;
+END
+bupxpfmcompat_db3 func3 BEGIN
+RETURN arg1 * 33;
+END
+bup_xpfm_compat_db1 func1 BEGIN
+RETURN arg1 * 11;
+END
+bup_xpfm_compat_db1 FUNC2 BEGIN
+RETURN arg1 * 12;
+END
+bup_xpfm_compat_db1 FuNc3 BEGIN
+RETURN arg1 * 13;
+END
+bup_xpfm_compat_db2 func1 BEGIN
+RETURN arg1 * 21;
+END
+bup_xpfm_compat_db2 func2 BEGIN
+RETURN arg1 * 22;
+END
+bup_xpfm_compat_db2 FuNc3 BEGIN
+RETURN arg1 * 23;
+END
+SELECT TRIGGER_SCHEMA, TRIGGER_NAME, ACTION_TIMING, EVENT_MANIPULATION,
+EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_STATEMENT
+FROM INFORMATION_SCHEMA.TRIGGERS
+WHERE TRIGGER_SCHEMA like 'bup%xpfm%compat%'
+ ORDER BY LOWER(TRIGGER_SCHEMA), LOWER(TRIGGER_NAME);
+TRIGGER_SCHEMA TRIGGER_NAME ACTION_TIMING EVENT_MANIPULATION EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_STATEMENT
+bupxpfmcompat_db3 trigger1 AFTER INSERT bupxpfmcompat_db3 table1 BEGIN
+DELETE FROM BupXPfmCompat_db3.TABLE2
+WHERE BupXPfmCompat_db3.TABLE2.c13 = NEW.c13;
+END
+bupxpfmcompat_db3 TRIGGER2 AFTER INSERT bupxpfmcompat_db3 table2 BEGIN
+DELETE FROM BupXPfmCompat_db3.table1
+WHERE BupXPfmCompat_db3.table1.c13 = NEW.c13;
+END
+bupxpfmcompat_db3 TrigGer3 AFTER INSERT bupxpfmcompat_db3 table3 BEGIN
+INSERT INTO bup_xpfm_compat_db1.table1 SET c13 = 53;
+END
+bup_xpfm_compat_db1 trigger1 AFTER INSERT bup_xpfm_compat_db1 table1 BEGIN
+DELETE FROM bup_xpfm_compat_db1.TABLE2
+WHERE bup_xpfm_compat_db1.TABLE2.c13 = NEW.c13;
+END
+bup_xpfm_compat_db1 TRIGGER2 AFTER INSERT bup_xpfm_compat_db1 table2 BEGIN
+DELETE FROM bup_xpfm_compat_db1.table1
+WHERE bup_xpfm_compat_db1.table1.c13 = NEW.c13;
+END
+bup_xpfm_compat_db1 TrigGer3 AFTER INSERT bup_xpfm_compat_db1 table3 BEGIN
+INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13 = 51;
+END
+bup_xpfm_compat_db2 trigger1 AFTER INSERT bup_xpfm_compat_db2 table1 BEGIN
+DELETE FROM BUP_XPFM_COMPAT_DB2.TABLE2
+WHERE BUP_XPFM_COMPAT_DB2.TABLE2.c13 = NEW.c13;
+END
+bup_xpfm_compat_db2 TRIGGER2 AFTER INSERT bup_xpfm_compat_db2 table2 BEGIN
+DELETE FROM BUP_XPFM_COMPAT_DB2.table1
+WHERE BUP_XPFM_COMPAT_DB2.table1.c13 = NEW.c13;
+END
+bup_xpfm_compat_db2 TrigGer3 AFTER INSERT bup_xpfm_compat_db2 table3 BEGIN
+INSERT INTO BupXPfmCompat_db3.TaBle3 SET c13 = 52;
+END
+SHOW CREATE TRIGGER bup_xpfm_compat_db1.trigger1;
+Trigger trigger1
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER bup_xpfm_compat_db1.trigger1 AFTER INSERT
+ON bup_xpfm_compat_db1.table1 FOR EACH ROW
+BEGIN
+DELETE FROM bup_xpfm_compat_db1.TABLE2
+WHERE bup_xpfm_compat_db1.TABLE2.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER bup_xpfm_compat_db1.TRIGGER2;
+Trigger TRIGGER2
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER bup_xpfm_compat_db1.TRIGGER2 AFTER INSERT
+ON bup_xpfm_compat_db1.TABLE2 FOR EACH ROW
+BEGIN
+DELETE FROM bup_xpfm_compat_db1.table1
+WHERE bup_xpfm_compat_db1.table1.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER bup_xpfm_compat_db1.TrigGer3;
+Trigger TrigGer3
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER bup_xpfm_compat_db1.TrigGer3 AFTER INSERT
+ON bup_xpfm_compat_db1.TaBle3 FOR EACH ROW
+BEGIN
+INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13 = 51;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BUP_XPFM_COMPAT_DB2.trigger1;
+Trigger trigger1
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BUP_XPFM_COMPAT_DB2.trigger1 AFTER INSERT
+ON BUP_XPFM_COMPAT_DB2.table1 FOR EACH ROW
+BEGIN
+DELETE FROM BUP_XPFM_COMPAT_DB2.TABLE2
+WHERE BUP_XPFM_COMPAT_DB2.TABLE2.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BUP_XPFM_COMPAT_DB2.TRIGGER2;
+Trigger TRIGGER2
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BUP_XPFM_COMPAT_DB2.TRIGGER2 AFTER INSERT
+ON BUP_XPFM_COMPAT_DB2.TABLE2 FOR EACH ROW
+BEGIN
+DELETE FROM BUP_XPFM_COMPAT_DB2.table1
+WHERE BUP_XPFM_COMPAT_DB2.table1.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BUP_XPFM_COMPAT_DB2.TrigGer3;
+Trigger TrigGer3
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BUP_XPFM_COMPAT_DB2.TrigGer3 AFTER INSERT
+ON BUP_XPFM_COMPAT_DB2.TaBle3 FOR EACH ROW
+BEGIN
+INSERT INTO BupXPfmCompat_db3.TaBle3 SET c13 = 52;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BupXPfmCompat_db3.trigger1;
+Trigger trigger1
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BupXPfmCompat_db3.trigger1 AFTER INSERT
+ON BupXPfmCompat_db3.table1 FOR EACH ROW
+BEGIN
+DELETE FROM BupXPfmCompat_db3.TABLE2
+WHERE BupXPfmCompat_db3.TABLE2.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BupXPfmCompat_db3.TRIGGER2;
+Trigger TRIGGER2
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BupXPfmCompat_db3.TRIGGER2 AFTER INSERT
+ON BupXPfmCompat_db3.TABLE2 FOR EACH ROW
+BEGIN
+DELETE FROM BupXPfmCompat_db3.table1
+WHERE BupXPfmCompat_db3.table1.c13 = NEW.c13;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SHOW CREATE TRIGGER BupXPfmCompat_db3.TrigGer3;
+Trigger TrigGer3
+sql_mode
+SQL Original Statement CREATE DEFINER=`root`@`localhost` TRIGGER BupXPfmCompat_db3.TrigGer3 AFTER INSERT
+ON BupXPfmCompat_db3.TaBle3 FOR EACH ROW
+BEGIN
+INSERT INTO bup_xpfm_compat_db1.table1 SET c13 = 53;
+END
+character_set_client utf8
+collation_connection utf8_general_ci
+Database Collation latin1_swedish_ci
+SELECT EVENT_SCHEMA, EVENT_NAME, EVENT_DEFINITION
+FROM INFORMATION_SCHEMA.EVENTS
+WHERE EVENT_SCHEMA like 'bup%xpfm%compat%'
+ ORDER BY LOWER(EVENT_SCHEMA), LOWER(EVENT_NAME);
+EVENT_SCHEMA EVENT_NAME EVENT_DEFINITION
+bupxpfmcompat_db3 event1 DELETE FROM BupXPfmCompat_db3.table1 WHERE c13 > 100
+bupxpfmcompat_db3 EVENT2 DELETE FROM BupXPfmCompat_db3.TABLE2 WHERE c13 > 100
+bupxpfmcompat_db3 EvEnt3 DELETE FROM BupXPfmCompat_db3.TaBle3 WHERE c13 > 100
+bup_xpfm_compat_db1 event1 DELETE FROM bup_xpfm_compat_db1.table1 WHERE c13 > 100
+bup_xpfm_compat_db1 EVENT2 DELETE FROM bup_xpfm_compat_db1.TABLE2 WHERE c13 > 100
+bup_xpfm_compat_db1 EvEnt3 DELETE FROM bup_xpfm_compat_db1.TaBle3 WHERE c13 > 100
+bup_xpfm_compat_db2 event1 DELETE FROM BUP_XPFM_COMPAT_DB2.table1 WHERE c13 > 100
+bup_xpfm_compat_db2 EVENT2 DELETE FROM BUP_XPFM_COMPAT_DB2.TABLE2 WHERE c13 > 100
+bup_xpfm_compat_db2 EvEnt3 DELETE FROM BUP_XPFM_COMPAT_DB2.TaBle3 WHERE c13 > 100
+#
+# Check table contents.
+#
+SELECT COUNT(*) FROM bup_xpfm_compat_db1.table1;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM bup_xpfm_compat_db1.table1;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ��������iiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM bup_xpfm_compat_db1.TABLE2;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM bup_xpfm_compat_db1.TABLE2;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 �+4 2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM bup_xpfm_compat_db1.TaBle3;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM bup_xpfm_compat_db1.TaBle3;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ����������iiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BUP_XPFM_COMPAT_DB2.table1;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BUP_XPFM_COMPAT_DB2.table1;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ���7483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BUP_XPFM_COMPAT_DB2.TABLE2;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BUP_XPFM_COMPAT_DB2.TABLE2;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ������������
+3 NULL NULL
+4 2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BUP_XPFM_COMPAT_DB2.TaBle3;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BUP_XPFM_COMPAT_DB2.TaBle3;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 �����7 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BupXPfmCompat_db3.table1;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BupXPfmCompat_db3.table1;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ���������������ULL
+4 2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BupXPfmCompat_db3.TABLE2;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BupXPfmCompat_db3.TABLE2;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ������������������������������������������������������������
+3 NULL NULL
+4 2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT COUNT(*) FROM BupXPfmCompat_db3.TaBle3;
+COUNT(*)
+4
+SELECT crn, c13, SUBSTR(c48 FROM 1 FOR 30) FROM BupXPfmCompat_db3.TaBle3;
+crn c13 SUBSTR(c48 FROM 1 FOR 30)
+1 -2147483648
+2 2147483647 ����3647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+#
+# Execute views.
+#
+SELECT c1, SUBSTR(c2 FROM 1 FOR 30), c3, c4 FROM bup_xpfm_compat_db1.view1;
+c1 SUBSTR(c2 FROM 1 FOR 30) c3 c4
+-2147483648 NULL 0
+2147483647 ���������47 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii NULL 0
+SELECT SUBSTR(c2 FROM 1 FOR 30), c3 FROM bup_xpfm_compat_db1.VIEW2;
+SUBSTR(c2 FROM 1 FOR 30) c3
+ NULL
+�������������
+NULL NULL
+iiiiiiiiiiiiiiiiiiiiiiiiiiiiii NULL
+SELECT c3, c4 FROM bup_xpfm_compat_db1.ViEw3;
+c3 c4
+NULL 0
+NULL 0
+NULL NULL
+NULL 0
+SELECT c2, c3 FROM BUP_XPFM_COMPAT_DB2.view1;
+c2 c3
+3.141593 root@localhost
+SELECT c1, SUBSTR(c2 FROM 1 FOR 30) FROM BUP_XPFM_COMPAT_DB2.VIEW2;
+c1 SUBSTR(c2 FROM 1 FOR 30)
+-2147483648
+2147483647 ���������iiiiiiiiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ��������iiiiiiiiiiiiiiiiii
+-2147483648
+2147483647
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ���������������L
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 �������iiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+SELECT c3 FROM BUP_XPFM_COMPAT_DB2.ViEw3;
+c3
+root@localhost
+SELECT c1, c2 FROM BupXPfmCompat_db3.view1;
+c1 c2
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+SELECT c1, c2 FROM BupXPfmCompat_db3.VIEW2;
+c1 c2
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+NULL NULL
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+SELECT c1, c2 FROM BupXPfmCompat_db3.ViEw3;
+c1 c2
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+-2147483648 -2147483648
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+2147483647 2147483647
+#
+# Execute procedures. They insert their name into c48.
+#
+CALL bup_xpfm_compat_db1.proc1;
+CALL bup_xpfm_compat_db1.PROC2;
+CALL bup_xpfm_compat_db1.PrOc3;
+CALL BUP_XPFM_COMPAT_DB2.proc1;
+CALL BUP_XPFM_COMPAT_DB2.PROC2;
+CALL BUP_XPFM_COMPAT_DB2.PrOc3;
+CALL BupXPfmCompat_db3.proc1;
+CALL BupXPfmCompat_db3.PROC2;
+CALL BupXPfmCompat_db3.PrOc3;
+SELECT c48 FROM bup_xpfm_compat_db1.table1;
+c48
+from bup_xpfm_compat_db1.proc1
+from bup_xpfm_compat_db1.proc1
+from bup_xpfm_compat_db1.proc1
+from bup_xpfm_compat_db1.proc1
+SELECT c48 FROM bup_xpfm_compat_db1.TABLE2;
+c48
+from bup_xpfm_compat_db1.PROC2
+from bup_xpfm_compat_db1.PROC2
+from bup_xpfm_compat_db1.PROC2
+from bup_xpfm_compat_db1.PROC2
+SELECT c48 FROM bup_xpfm_compat_db1.TaBle3;
+c48
+from bup_xpfm_compat_db1.PrOc3
+from bup_xpfm_compat_db1.PrOc3
+from bup_xpfm_compat_db1.PrOc3
+from bup_xpfm_compat_db1.PrOc3
+SELECT c48 FROM BUP_XPFM_COMPAT_DB2.table1;
+c48
+from BUP_XPFM_COMPAT_DB2.proc1
+from BUP_XPFM_COMPAT_DB2.proc1
+from BUP_XPFM_COMPAT_DB2.proc1
+from BUP_XPFM_COMPAT_DB2.proc1
+SELECT c48 FROM BUP_XPFM_COMPAT_DB2.TABLE2;
+c48
+from BUP_XPFM_COMPAT_DB2.PROC2
+from BUP_XPFM_COMPAT_DB2.PROC2
+from BUP_XPFM_COMPAT_DB2.PROC2
+from BUP_XPFM_COMPAT_DB2.PROC2
+SELECT c48 FROM BUP_XPFM_COMPAT_DB2.TaBle3;
+c48
+from BUP_XPFM_COMPAT_DB2.PrOc3
+from BUP_XPFM_COMPAT_DB2.PrOc3
+from BUP_XPFM_COMPAT_DB2.PrOc3
+from BUP_XPFM_COMPAT_DB2.PrOc3
+SELECT c48 FROM BupXPfmCompat_db3.table1;
+c48
+from BupXPfmCompat_db3.proc1
+from BupXPfmCompat_db3.proc1
+from BupXPfmCompat_db3.proc1
+from BupXPfmCompat_db3.proc1
+SELECT c48 FROM BupXPfmCompat_db3.TABLE2;
+c48
+from BupXPfmCompat_db3.PROC2
+from BupXPfmCompat_db3.PROC2
+from BupXPfmCompat_db3.PROC2
+from BupXPfmCompat_db3.PROC2
+SELECT c48 FROM BupXPfmCompat_db3.TaBle3;
+c48
+from BupXPfmCompat_db3.PrOc3
+from BupXPfmCompat_db3.PrOc3
+from BupXPfmCompat_db3.PrOc3
+from BupXPfmCompat_db3.PrOc3
+#
+# Execute functions. They multiply their arg by 11, 12, 13, ..., 32, 33.
+# When Bug#9051 (Stored Functions: Database name in fully qualified name
+# is case sensitive) is fixed, the --error directives and the
+# secondary call of the functions in bup_xpfm_compat_db2 and
+# bupxpfmcompat_db3 shall be removed.
+#
+SELECT bup_xpfm_compat_db1.func1(2);
+bup_xpfm_compat_db1.func1(2)
+22
+SELECT bup_xpfm_compat_db1.FUNC2(3);
+bup_xpfm_compat_db1.FUNC2(3)
+36
+SELECT bup_xpfm_compat_db1.FuNc3(4);
+bup_xpfm_compat_db1.FuNc3(4)
+52
+SELECT BUP_XPFM_COMPAT_DB2.func1(5);
+SELECT bup_xpfm_compat_db2.func1(5);
+bup_xpfm_compat_db2.func1(5)
+105
+SELECT BUP_XPFM_COMPAT_DB2.FUNC2(6);
+BUP_XPFM_COMPAT_DB2.FUNC2(6)
+132
+SELECT bup_xpfm_compat_db2.FUNC2(6);
+bup_xpfm_compat_db2.FUNC2(6)
+132
+SELECT BUP_XPFM_COMPAT_DB2.FuNc3(7);
+SELECT bup_xpfm_compat_db2.FuNc3(7);
+bup_xpfm_compat_db2.FuNc3(7)
+161
+SELECT BupXPfmCompat_db3.func1(8);
+SELECT bupxpfmcompat_db3.func1(8);
+bupxpfmcompat_db3.func1(8)
+248
+SELECT BupXPfmCompat_db3.FUNC2(9);
+SELECT bupxpfmcompat_db3.FUNC2(9);
+bupxpfmcompat_db3.FUNC2(9)
+288
+SELECT BupXPfmCompat_db3.FuNc3(10);
+BupXPfmCompat_db3.FuNc3(10)
+330
+SELECT bupxpfmcompat_db3.FuNc3(10);
+bupxpfmcompat_db3.FuNc3(10)
+330
+#
+# Execute triggers.
+# Triggers 1 and 2 delete same row from tables 2 and 1 respectively.
+# Trigger 3 inserts 51, 52, 53 into table 3 of next db respectively.
+#
+INSERT INTO bup_xpfm_compat_db1.table1 SET c13=43 -- del 43 of TABLE2 (no-op);
+INSERT INTO bup_xpfm_compat_db1.TABLE2 SET c13=43 -- del 43 of table1 (ok);
+INSERT INTO bup_xpfm_compat_db1.TaBle3 SET c13=43 -- ins 51 in DB2.TABLE2;
+INSERT INTO bup_xpfm_compat_db1.TABLE2 SET c13=44 -- del 44 of table1 (no-op);
+INSERT INTO bup_xpfm_compat_db1.table1 SET c13=44 -- del 44 of TABLE2 (ok);
+INSERT INTO BUP_XPFM_COMPAT_DB2.table1 SET c13=43 -- del 43 of TABLE2 (no-op);
+INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13=43 -- del 43 of table1 (ok);
+INSERT INTO BUP_XPFM_COMPAT_DB2.TaBle3 SET c13=43 -- ins 52 in db3.TaBle3;
+INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13=44 -- del 44 of table1 (no-op);
+INSERT INTO BUP_XPFM_COMPAT_DB2.table1 SET c13=44 -- del 44 of TABLE2 (ok);
+INSERT INTO BupXPfmCompat_db3.table1 SET c13=43 -- del 43 of TABLE2 (no-op);
+INSERT INTO BupXPfmCompat_db3.TABLE2 SET c13=43 -- del 43 of table1 (ok);
+INSERT INTO BupXPfmCompat_db3.TaBle3 SET c13=43 -- ins 53 in db1.table1;
+INSERT INTO BupXPfmCompat_db3.TABLE2 SET c13=44 -- del 44 of table1 (no-op);
+INSERT INTO BupXPfmCompat_db3.table1 SET c13=44 -- del 44 of TABLE2 (ok);
+SELECT c13 FROM bup_xpfm_compat_db1.table1 WHERE c13 BETWEEN 1 AND 100;
+c13
+44
+53
+53
+SELECT c13 FROM bup_xpfm_compat_db1.TABLE2 WHERE c13 BETWEEN 1 AND 100;
+c13
+43
+SELECT c13 FROM bup_xpfm_compat_db1.TaBle3 WHERE c13 BETWEEN 1 AND 100;
+c13
+43
+SELECT c13 FROM BUP_XPFM_COMPAT_DB2.table1 WHERE c13 BETWEEN 1 AND 100;
+c13
+44
+SELECT c13 FROM BUP_XPFM_COMPAT_DB2.TABLE2 WHERE c13 BETWEEN 1 AND 100;
+c13
+51
+43
+SELECT c13 FROM BUP_XPFM_COMPAT_DB2.TaBle3 WHERE c13 BETWEEN 1 AND 100;
+c13
+43
+SELECT c13 FROM BupXPfmCompat_db3.table1 WHERE c13 BETWEEN 1 AND 100;
+c13
+44
+SELECT c13 FROM BupXPfmCompat_db3.TABLE2 WHERE c13 BETWEEN 1 AND 100;
+c13
+43
+SELECT c13 FROM BupXPfmCompat_db3.TaBle3 WHERE c13 BETWEEN 1 AND 100;
+c13
+52
+43
+#
+# Cleanup.
+#
+SET GLOBAL backupdir = DEFAULT;
+DROP DATABASE bup_xpfm_compat_db1;
+DROP DATABASE BUP_XPFM_COMPAT_DB2;
+DROP DATABASE BupXPfmCompat_db3;
+DROP USER 'bup_user1'@'%';
+DROP USER 'BUP_USER2';
+DROP USER 'BupUser3'@'%';
+DROP USER 'no_user'@'%';
+#
+# Windows 64 lctn2
+#
+DROP DATABASE IF EXISTS bup_xpfm_compat_db1;
+DROP DATABASE IF EXISTS BUP_XPFM_COMPAT_DB2;
+DROP DATABASE IF EXISTS BupXPfmCompat_db3;
+#
+# Check setting of lower_case_table_names.
+#
+SELECT @@lower_case_table_names;
+@@lower_case_table_names
+2
+#
+# Set character set for table contents.
+#
+SET NAMES 'utf8';
+#
+# Create users. Required to exist by RESTORE.
+#
+CREATE USER 'bup_user1'@'%';
+CREATE USER 'BUP_USER2';
+CREATE USER 'BupUser3'@'%';
+CREATE USER 'no_user'@'%';
+#
+# Set backupdir = '$MYSQL_TEST_DIR/suite/backup/std_data'
+#
+#
+# Restore.
+#
+RESTORE FROM 'backup_xpfm_compat_lctn2-windows_64.bak' OVERWRITE;
+backup_id
+#
+#
+# Check object existence.
+#
+SELECT SCHEMA_NAME
+FROM INFORMATION_SCHEMA.SCHEMATA
+WHERE SCHEMA_NAME like 'bup%xpfm%compat%'
+ ORDER BY LOWER(SCHEMA_NAME);
+SCHEMA_NAME
+BupXPfmCompat_db3
+bup_xpfm_compat_db1
+BUP_XPFM_COMPAT_DB2
+SELECT TABLESPACE_NAME
+FROM INFORMATION_SCHEMA.TABLESPACES
+WHERE TABLESPACE_NAME like 'bup%xpfm%compat%'
+ ORDER BY LOWER(TABLESPACE_NAME);
+TABLESPACE_NAME
+SELECT TABLE_SCHEMA, TABLE_NAME
+FROM INFORMATION_SCHEMA.TABLES
+WHERE TABLE_SCHEMA like 'bup%xpfm%compat%'
+ AND TABLE_TYPE != 'VIEW'
+ ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME);
+TABLE_SCHEMA TABLE_NAME
+BupXPfmCompat_db3 table1
+BupXPfmCompat_db3 TABLE2
+BupXPfmCompat_db3 TaBle3
+bup_xpfm_compat_db1 table1
+bup_xpfm_compat_db1 TABLE2
+bup_xpfm_compat_db1 TaBle3
+BUP_XPFM_COMPAT_DB2 table1
+BUP_XPFM_COMPAT_DB2 TABLE2
+BUP_XPFM_COMPAT_DB2 TaBle3
+SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE,
+CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION
+FROM INFORMATION_SCHEMA.COLUMNS
+WHERE TABLE_SCHEMA like 'bup%xpfm%compat%'
+ ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME), LOWER(COLUMN_NAME);
+TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH NUMERIC_PRECISION
+BupXPfmCompat_db3 table1 c01 bit NULL 1
+BupXPfmCompat_db3 table1 c02 bit NULL 64
+BupXPfmCompat_db3 table1 c03 tinyint NULL 3
+BupXPfmCompat_db3 table1 c04 tinyint NULL 3
+BupXPfmCompat_db3 table1 c05 tinyint NULL 3
+BupXPfmCompat_db3 table1 c06 tinyint NULL 3
+BupXPfmCompat_db3 table1 c07 smallint NULL 5
+BupXPfmCompat_db3 table1 c08 smallint NULL 5
+BupXPfmCompat_db3 table1 c09 smallint NULL 5
+BupXPfmCompat_db3 table1 c10 mediumint NULL 7
+BupXPfmCompat_db3 table1 c11 mediumint NULL 7
+BupXPfmCompat_db3 table1 c12 mediumint NULL 7
+BupXPfmCompat_db3 table1 c13 int NULL 10
+BupXPfmCompat_db3 table1 c14 int NULL 10
+BupXPfmCompat_db3 table1 c15 int NULL 10
+BupXPfmCompat_db3 table1 c16 bigint NULL 19
+BupXPfmCompat_db3 table1 c17 bigint NULL 19
+BupXPfmCompat_db3 table1 c18 bigint NULL 19
+BupXPfmCompat_db3 table1 c19 float NULL 12
+BupXPfmCompat_db3 table1 c20 float NULL 12
+BupXPfmCompat_db3 table1 c21 float NULL 12
+BupXPfmCompat_db3 table1 c22 double NULL 22
+BupXPfmCompat_db3 table1 c23 double NULL 22
+BupXPfmCompat_db3 table1 c24 double NULL 22
+BupXPfmCompat_db3 table1 c25 decimal NULL 10
+BupXPfmCompat_db3 table1 c26 decimal NULL 10
+BupXPfmCompat_db3 table1 c27 decimal NULL 10
+BupXPfmCompat_db3 table1 c28 date NULL NULL
+BupXPfmCompat_db3 table1 c29 datetime NULL NULL
+BupXPfmCompat_db3 table1 c30 timestamp NULL NULL
+BupXPfmCompat_db3 table1 c31 time NULL NULL
+BupXPfmCompat_db3 table1 c32 year NULL NULL
+BupXPfmCompat_db3 table1 c33 char 1 NULL
+BupXPfmCompat_db3 table1 c34 char 0 NULL
+BupXPfmCompat_db3 table1 c35 char 1 NULL
+BupXPfmCompat_db3 table1 c36 char 255 NULL
+BupXPfmCompat_db3 table1 c37 char 1 NULL
+BupXPfmCompat_db3 table1 c38 char 0 NULL
+BupXPfmCompat_db3 table1 c39 char 1 NULL
+BupXPfmCompat_db3 table1 c40 char 255 NULL
+BupXPfmCompat_db3 table1 c41 char 1 NULL
+BupXPfmCompat_db3 table1 c42 char 0 NULL
+BupXPfmCompat_db3 table1 c43 char 1 NULL
+BupXPfmCompat_db3 table1 c44 char 255 NULL
+BupXPfmCompat_db3 table1 c45 varchar 0 NULL
+BupXPfmCompat_db3 table1 c46 varchar 1 NULL
+BupXPfmCompat_db3 table1 c47 varchar 255 NULL
+BupXPfmCompat_db3 table1 c48 varchar 261 NULL
+BupXPfmCompat_db3 table1 c49 varchar 0 NULL
+BupXPfmCompat_db3 table1 c50 varchar 1 NULL
+BupXPfmCompat_db3 table1 c51 varchar 255 NULL
+BupXPfmCompat_db3 table1 c52 varchar 261 NULL
+BupXPfmCompat_db3 table1 c53 varchar 0 NULL
+BupXPfmCompat_db3 table1 c54 varchar 1 NULL
+BupXPfmCompat_db3 table1 c55 varchar 255 NULL
+BupXPfmCompat_db3 table1 c56 varchar 261 NULL
+BupXPfmCompat_db3 table1 c57 binary 1 NULL
+BupXPfmCompat_db3 table1 c58 binary 0 NULL
+BupXPfmCompat_db3 table1 c59 binary 1 NULL
+BupXPfmCompat_db3 table1 c60 binary 255 NULL
+BupXPfmCompat_db3 table1 c61 varbinary 0 NULL
+BupXPfmCompat_db3 table1 c62 varbinary 1 NULL
+BupXPfmCompat_db3 table1 c63 varbinary 255 NULL
+BupXPfmCompat_db3 table1 c64 varbinary 261 NULL
+BupXPfmCompat_db3 table1 c65 tinyblob 255 NULL
+BupXPfmCompat_db3 table1 c66 tinytext 255 NULL
+BupXPfmCompat_db3 table1 c67 tinytext 127 NULL
+BupXPfmCompat_db3 table1 c68 blob 65535 NULL
+BupXPfmCompat_db3 table1 c69 text 65535 NULL
+BupXPfmCompat_db3 table1 c70 text 32767 NULL
+BupXPfmCompat_db3 table1 c71 mediumblob 16777215 NULL
+BupXPfmCompat_db3 table1 c72 mediumtext 16777215 NULL
+BupXPfmCompat_db3 table1 c73 mediumtext 8388607 NULL
+BupXPfmCompat_db3 table1 c74 longblob 4294967295 NULL
+BupXPfmCompat_db3 table1 c75 longtext 4294967295 NULL
+BupXPfmCompat_db3 table1 c76 longtext 2147483647 NULL
+BupXPfmCompat_db3 table1 c77 enum 1 NULL
+BupXPfmCompat_db3 table1 c78 set 5 NULL
+BupXPfmCompat_db3 table1 crn int NULL 10
+BupXPfmCompat_db3 TABLE2 c01 bit NULL 1
+BupXPfmCompat_db3 TABLE2 c02 bit NULL 64
+BupXPfmCompat_db3 TABLE2 c03 tinyint NULL 3
+BupXPfmCompat_db3 TABLE2 c04 tinyint NULL 3
+BupXPfmCompat_db3 TABLE2 c05 tinyint NULL 3
+BupXPfmCompat_db3 TABLE2 c06 tinyint NULL 3
+BupXPfmCompat_db3 TABLE2 c07 smallint NULL 5
+BupXPfmCompat_db3 TABLE2 c08 smallint NULL 5
+BupXPfmCompat_db3 TABLE2 c09 smallint NULL 5
+BupXPfmCompat_db3 TABLE2 c10 mediumint NULL 7
+BupXPfmCompat_db3 TABLE2 c11 mediumint NULL 7
+BupXPfmCompat_db3 TABLE2 c12 mediumint NULL 7
+BupXPfmCompat_db3 TABLE2 c13 int NULL 10
+BupXPfmCompat_db3 TABLE2 c14 int NULL 10
+BupXPfmCompat_db3 TABLE2 c15 int NULL 10
+BupXPfmCompat_db3 TABLE2 c16 bigint NULL 19
+BupXPfmCompat_db3 TABLE2 c17 bigint NULL 19
+BupXPfmCompat_db3 TABLE2 c18 bigint NULL 19
+BupXPfmCompat_db3 TABLE2 c19 float NULL 12
+BupXPfmCompat_db3 TABLE2 c20 float NULL 12
+BupXPfmCompat_db3 TABLE2 c21 float NULL 12
+BupXPfmCompat_db3 TABLE2 c22 double NULL 22
+BupXPfmCompat_db3 TABLE2 c23 double NULL 22
+BupXPfmCompat_db3 TABLE2 c24 double NULL 22
+BupXPfmCompat_db3 TABLE2 c25 decimal NULL 10
+BupXPfmCompat_db3 TABLE2 c26 decimal NULL 10
+BupXPfmCompat_db3 TABLE2 c27 decimal NULL 10
+BupXPfmCompat_db3 TABLE2 c28 date NULL NULL
+BupXPfmCompat_db3 TABLE2 c29 datetime NULL NULL
+BupXPfmCompat_db3 TABLE2 c30 timestamp NULL NULL
+BupXPfmCompat_db3 TABLE2 c31 time NULL NULL
+BupXPfmCompat_db3 TABLE2 c32 year NULL NULL
+BupXPfmCompat_db3 TABLE2 c33 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c34 char 0 NULL
+BupXPfmCompat_db3 TABLE2 c35 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c36 char 255 NULL
+BupXPfmCompat_db3 TABLE2 c37 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c38 char 0 NULL
+BupXPfmCompat_db3 TABLE2 c39 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c40 char 255 NULL
+BupXPfmCompat_db3 TABLE2 c41 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c42 char 0 NULL
+BupXPfmCompat_db3 TABLE2 c43 char 1 NULL
+BupXPfmCompat_db3 TABLE2 c44 char 255 NULL
+BupXPfmCompat_db3 TABLE2 c45 varchar 0 NULL
+BupXPfmCompat_db3 TABLE2 c46 varchar 1 NULL
+BupXPfmCompat_db3 TABLE2 c47 varchar 255 NULL
+BupXPfmCompat_db3 TABLE2 c48 varchar 261 NULL
+BupXPfmCompat_db3 TABLE2 c49 varchar 0 NULL
+BupXPfmCompat_db3 TABLE2 c50 varchar 1 NULL
+BupXPfmCompat_db3 TABLE2 c51 varchar 255 NULL
+BupXPfmCompat_db3 TABLE2 c52 varchar 261 NULL
+BupXPfmCompat_db3 TABLE2 c53 varchar 0 NULL
+BupXPfmCompat_db3 TABLE2 c54 varchar 1 NULL
+BupXPfmCompat_db3 TABLE2 c55 varchar 255 NULL
+BupXPfmCompat_db3 TABLE2 c56 varchar 261 NULL
+BupXPfmCompat_db3 TABLE2 c57 binary 1 NULL
+BupXPfmCompat_db3 TABLE2 c58 binary 0 NULL
+BupXPfmCompat_db3 TABLE2 c59 binary 1 NULL
+BupXPfmCompat_db3 TABLE2 c60 binary 255 NULL
+BupXPfmCompat_db3 TABLE2 c61 varbinary 0 NULL
+BupXPfmCompat_db3 TABLE2 c62 varbinary 1 NULL
+BupXPfmCompat_db3 TABLE2 c63 varbinary 255 NULL
+BupXPfmCompat_db3 TABLE2 c64 varbinary 261 NULL
+BupXPfmCompat_db3 TABLE2 c65 tinyblob 255 NULL
+BupXPfmCompat_db3 TABLE2 c66 tinytext 255 NULL
+BupXPfmCompat_db3 TABLE2 c67 tinytext 127 NULL
+BupXPfmCompat_db3 TABLE2 c68 blob 65535 NULL
+BupXPfmCompat_db3 TABLE2 c69 text 65535 NULL
+BupXPfmCompat_db3 TABLE2 c70 text 32767 NULL
+BupXPfmCompat_db3 TABLE2 c71 mediumblob 16777215 NULL
+BupXPfmCompat_db3 TABLE2 c72 mediumtext 16777215 NULL
+BupXPfmCompat_db3 TABLE2 c73 mediumtext 8388607 NULL
+BupXPfmCompat_db3 TABLE2 c74 longblob 4294967295 NULL
+BupXPfmCompat_db3 TABLE2 c75 longtext 4294967295 NULL
+BupXPfmCompat_db3 TABLE2 c76 longtext 2147483647 NULL
+BupXPfmCompat_db3 TABLE2 c77 enum 1 NULL
+BupXPfmCompat_db3 TABLE2 c78 set 5 NULL
+BupXPfmCompat_db3 TABLE2 crn int NULL 10
+BupXPfmCompat_db3 TaBle3 c01 bit NULL 1
+BupXPfmCompat_db3 TaBle3 c02 bit NULL 64
+BupXPfmCompat_db3 TaBle3 c03 tinyint NULL 3
+BupXPfmCompat_db3 TaBle3 c04 tinyint NULL 3
+BupXPfmCompat_db3 TaBle3 c05 tinyint NULL 3
+BupXPfmCompat_db3 TaBle3 c06 tinyint NULL 3
+BupXPfmCompat_db3 TaBle3 c07 smallint NULL 5
+BupXPfmCompat_db3 TaBle3 c08 smallint NULL 5
+BupXPfmCompat_db3 TaBle3 c09 smallint NULL 5
+BupXPfmCompat_db3 TaBle3 c10 mediumint NULL 7
+BupXPfmCompat_db3 TaBle3 c11 mediumint NULL 7
+BupXPfmCompat_db3 TaBle3 c12 mediumint NULL 7
+BupXPfmCompat_db3 TaBle3 c13 int NULL 10
+BupXPfmCompat_db3 TaBle3 c14 int NULL 10
+BupXPfmCompat_db3 TaBle3 c15 int NULL 10
+BupXPfmCompat_db3 TaBle3 c16 bigint NULL 19
+BupXPfmCompat_db3 TaBle3 c17 bigint NULL 19
+BupXPfmCompat_db3 TaBle3 c18 bigint NULL 19
+BupXPfmCompat_db3 TaBle3 c19 float NULL 12
+BupXPfmCompat_db3 TaBle3 c20 float NULL 12
+BupXPfmCompat_db3 TaBle3 c21 float NULL 12
+BupXPfmCompat_db3 TaBle3 c22 double NULL 22
+BupXPfmCompat_db3 TaBle3 c23 double NULL 22
+BupXPfmCompat_db3 TaBle3 c24 double NULL 22
+BupXPfmCompat_db3 TaBle3 c25 decimal NULL 10
+BupXPfmCompat_db3 TaBle3 c26 decimal NULL 10
+BupXPfmCompat_db3 TaBle3 c27 decimal NULL 10
+BupXPfmCompat_db3 TaBle3 c28 date NULL NULL
+BupXPfmCompat_db3 TaBle3 c29 datetime NULL NULL
+BupXPfmCompat_db3 TaBle3 c30 timestamp NULL NULL
+BupXPfmCompat_db3 TaBle3 c31 time NULL NULL
+BupXPfmCompat_db3 TaBle3 c32 year NULL NULL
+BupXPfmCompat_db3 TaBle3 c33 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c34 char 0 NULL
+BupXPfmCompat_db3 TaBle3 c35 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c36 char 255 NULL
+BupXPfmCompat_db3 TaBle3 c37 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c38 char 0 NULL
+BupXPfmCompat_db3 TaBle3 c39 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c40 char 255 NULL
+BupXPfmCompat_db3 TaBle3 c41 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c42 char 0 NULL
+BupXPfmCompat_db3 TaBle3 c43 char 1 NULL
+BupXPfmCompat_db3 TaBle3 c44 char 255 NULL
+BupXPfmCompat_db3 TaBle3 c45 varchar 0 NULL
+BupXPfmCompat_db3 TaBle3 c46 varchar 1 NULL
+BupXPfmCompat_db3 TaBle3 c47 varchar 255 NULL
+BupXPfmCompat_db3 TaBle3 c48 varchar 261 NULL
+BupXPfmCompat_db3 TaBle3 c49 varchar 0 NULL
+BupXPfmCompat_db3 TaBle3 c50 varchar 1 NULL
+BupXPfmCompat_db3 TaBle3 c51 varchar 255 NULL
+BupXPfmCompat_db3 TaBle3 c52 varchar 261 NULL
+BupXPfmCompat_db3 TaBle3 c53 varchar 0 NULL
+BupXPfmCompat_db3 TaBle3 c54 varchar 1 NULL
+BupXPfmCompat_db3 TaBle3 c55 varchar 255 NULL
+BupXPfmCompat_db3 TaBle3 c56 varchar 261 NULL
+BupXPfmCompat_db3 TaBle3 c57 binary 1 NULL
+BupXPfmCompat_db3 TaBle3 c58 binary 0 NULL
+BupXPfmCompat_db3 TaBle3 c59 binary 1 NULL
+BupXPfmCompat_db3 TaBle3 c60 binary 255 NULL
+BupXPfmCompat_db3 TaBle3 c61 varbinary 0 NULL
+BupXPfmCompat_db3 TaBle3 c62 varbinary 1 NULL
+BupXPfmCompat_db3 TaBle3 c63 varbinary 255 NULL
+BupXPfmCompat_db3 TaBle3 c64 varbinary 261 NULL
+BupXPfmCompat_db3 TaBle3 c65 tinyblob 255 NULL
+BupXPfmCompat_db3 TaBle3 c66 tinytext 255 NULL
+BupXPfmCompat_db3 TaBle3 c67 tinytext 127 NULL
+BupXPfmCompat_db3 TaBle3 c68 blob 65535 NULL
+BupXPfmCompat_db3 TaBle3 c69 text 65535 NULL
+BupXPfmCompat_db3 TaBle3 c70 text 32767 NULL
+BupXPfmCompat_db3 TaBle3 c71 mediumblob 16777215 NULL
+BupXPfmCompat_db3 TaBle3 c72 mediumtext 16777215 NULL
+BupXPfmCompat_db3 TaBle3 c73 mediumtext 8388607 NULL
+BupXPfmCompat_db3 TaBle3 c74 longblob 4294967295 NULL
+BupXPfmCompat_db3 TaBle3 c75 longtext 4294967295 NULL
+BupXPfmCompat_db3 TaBle3 c76 longtext 2147483647 NULL
+BupXPfmCompat_db3 TaBle3 c77 enum 1 NULL
+BupXPfmCompat_db3 TaBle3 c78 set 5 NULL
+BupXPfmCompat_db3 TaBle3 crn int NULL 10
+BupXPfmCompat_db3 view1 c1 int NULL 10
+BupXPfmCompat_db3 view1 c2 int NULL 10
+bupxpfmcompat_db3 view2 c1 int NULL 10
+bupxpfmcompat_db3 view2 c2 int NULL 10
+bupxpfmcompat_db3 view3 c1 int NULL 10
+bupxpfmcompat_db3 view3 c2 int NULL 10
+bup_xpfm_compat_db1 table1 c01 bit NULL 1
+bup_xpfm_compat_db1 table1 c02 bit NULL 64
+bup_xpfm_compat_db1 table1 c03 tinyint NULL 3
+bup_xpfm_compat_db1 table1 c04 tinyint NULL 3
+bup_xpfm_compat_db1 table1 c05 tinyint NULL 3
+bup_xpfm_compat_db1 table1 c06 tinyint NULL 3
+bup_xpfm_compat_db1 table1 c07 smallint NULL 5
+bup_xpfm_compat_db1 table1 c08 smallint NULL 5
+bup_xpfm_compat_db1 table1 c09 smallint NULL 5
+bup_xpfm_compat_db1 table1 c10 mediumint NULL 7
+bup_xpfm_compat_db1 table1 c11 mediumint NULL 7
+bup_xpfm_compat_db1 table1 c12 mediumint NULL 7
+bup_xpfm_compat_db1 table1 c13 int NULL 10
+bup_xpfm_compat_db1 table1 c14 int NULL 10
+bup_xpfm_compat_db1 table1 c15 int NULL 10
+bup_xpfm_compat_db1 table1 c16 bigint NULL 19
+bup_xpfm_compat_db1 table1 c17 bigint NULL 19
+bup_xpfm_compat_db1 table1 c18 bigint NULL 19
+bup_xpfm_compat_db1 table1 c19 float NULL 12
+bup_xpfm_compat_db1 table1 c20 float NULL 12
+bup_xpfm_compat_db1 table1 c21 float NULL 12
+bup_xpfm_compat_db1 table1 c22 double NULL 22
+bup_xpfm_compat_db1 table1 c23 double NULL 22
+bup_xpfm_compat_db1 table1 c24 double NULL 22
+bup_xpfm_compat_db1 table1 c25 decimal NULL 10
+bup_xpfm_compat_db1 table1 c26 decimal NULL 10
+bup_xpfm_compat_db1 table1 c27 decimal NULL 10
+bup_xpfm_compat_db1 table1 c28 date NULL NULL
+bup_xpfm_compat_db1 table1 c29 datetime NULL NULL
+bup_xpfm_compat_db1 table1 c30 timestamp NULL NULL
+bup_xpfm_compat_db1 table1 c31 time NULL NULL
+bup_xpfm_compat_db1 table1 c32 year NULL NULL
+bup_xpfm_compat_db1 table1 c33 char 1 NULL
+bup_xpfm_compat_db1 table1 c34 char 0 NULL
+bup_xpfm_compat_db1 table1 c35 char 1 NULL
+bup_xpfm_compat_db1 table1 c36 char 255 NULL
+bup_xpfm_compat_db1 table1 c37 char 1 NULL
+bup_xpfm_compat_db1 table1 c38 char 0 NULL
+bup_xpfm_compat_db1 table1 c39 char 1 NULL
+bup_xpfm_compat_db1 table1 c40 char 255 NULL
+bup_xpfm_compat_db1 table1 c41 char 1 NULL
+bup_xpfm_compat_db1 table1 c42 char 0 NULL
+bup_xpfm_compat_db1 table1 c43 char 1 NULL
+bup_xpfm_compat_db1 table1 c44 char 255 NULL
+bup_xpfm_compat_db1 table1 c45 varchar 0 NULL
+bup_xpfm_compat_db1 table1 c46 varchar 1 NULL
+bup_xpfm_compat_db1 table1 c47 varchar 255 NULL
+bup_xpfm_compat_db1 table1 c48 varchar 261 NULL
+bup_xpfm_compat_db1 table1 c49 varchar 0 NULL
+bup_xpfm_compat_db1 table1 c50 varchar 1 NULL
+bup_xpfm_compat_db1 table1 c51 varchar 255 NULL
+bup_xpfm_compat_db1 table1 c52 varchar 261 NULL
+bup_xpfm_compat_db1 table1 c53 varchar 0 NULL
+bup_xpfm_compat_db1 table1 c54 varchar 1 NULL
+bup_xpfm_compat_db1 table1 c55 varchar 255 NULL
+bup_xpfm_compat_db1 table1 c56 varchar 261 NULL
+bup_xpfm_compat_db1 table1 c57 binary 1 NULL
+bup_xpfm_compat_db1 table1 c58 binary 0 NULL
+bup_xpfm_compat_db1 table1 c59 binary 1 NULL
+bup_xpfm_compat_db1 table1 c60 binary 255 NULL
+bup_xpfm_compat_db1 table1 c61 varbinary 0 NULL
+bup_xpfm_compat_db1 table1 c62 varbinary 1 NULL
+bup_xpfm_compat_db1 table1 c63 varbinary 255 NULL
+bup_xpfm_compat_db1 table1 c64 varbinary 261 NULL
+bup_xpfm_compat_db1 table1 c65 tinyblob 255 NULL
+bup_xpfm_compat_db1 table1 c66 tinytext 255 NULL
+bup_xpfm_compat_db1 table1 c67 tinytext 127 NULL
+bup_xpfm_compat_db1 table1 c68 blob 65535 NULL
+bup_xpfm_compat_db1 table1 c69 text 65535 NULL
+bup_xpfm_compat_db1 table1 c70 text 32767 NULL
+bup_xpfm_compat_db1 table1 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db1 table1 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db1 table1 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db1 table1 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db1 table1 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db1 table1 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db1 table1 c77 enum 1 NULL
+bup_xpfm_compat_db1 table1 c78 set 5 NULL
+bup_xpfm_compat_db1 table1 crn int NULL 10
+bup_xpfm_compat_db1 TABLE2 c01 bit NULL 1
+bup_xpfm_compat_db1 TABLE2 c02 bit NULL 64
+bup_xpfm_compat_db1 TABLE2 c03 tinyint NULL 3
+bup_xpfm_compat_db1 TABLE2 c04 tinyint NULL 3
+bup_xpfm_compat_db1 TABLE2 c05 tinyint NULL 3
+bup_xpfm_compat_db1 TABLE2 c06 tinyint NULL 3
+bup_xpfm_compat_db1 TABLE2 c07 smallint NULL 5
+bup_xpfm_compat_db1 TABLE2 c08 smallint NULL 5
+bup_xpfm_compat_db1 TABLE2 c09 smallint NULL 5
+bup_xpfm_compat_db1 TABLE2 c10 mediumint NULL 7
+bup_xpfm_compat_db1 TABLE2 c11 mediumint NULL 7
+bup_xpfm_compat_db1 TABLE2 c12 mediumint NULL 7
+bup_xpfm_compat_db1 TABLE2 c13 int NULL 10
+bup_xpfm_compat_db1 TABLE2 c14 int NULL 10
+bup_xpfm_compat_db1 TABLE2 c15 int NULL 10
+bup_xpfm_compat_db1 TABLE2 c16 bigint NULL 19
+bup_xpfm_compat_db1 TABLE2 c17 bigint NULL 19
+bup_xpfm_compat_db1 TABLE2 c18 bigint NULL 19
+bup_xpfm_compat_db1 TABLE2 c19 float NULL 12
+bup_xpfm_compat_db1 TABLE2 c20 float NULL 12
+bup_xpfm_compat_db1 TABLE2 c21 float NULL 12
+bup_xpfm_compat_db1 TABLE2 c22 double NULL 22
+bup_xpfm_compat_db1 TABLE2 c23 double NULL 22
+bup_xpfm_compat_db1 TABLE2 c24 double NULL 22
+bup_xpfm_compat_db1 TABLE2 c25 decimal NULL 10
+bup_xpfm_compat_db1 TABLE2 c26 decimal NULL 10
+bup_xpfm_compat_db1 TABLE2 c27 decimal NULL 10
+bup_xpfm_compat_db1 TABLE2 c28 date NULL NULL
+bup_xpfm_compat_db1 TABLE2 c29 datetime NULL NULL
+bup_xpfm_compat_db1 TABLE2 c30 timestamp NULL NULL
+bup_xpfm_compat_db1 TABLE2 c31 time NULL NULL
+bup_xpfm_compat_db1 TABLE2 c32 year NULL NULL
+bup_xpfm_compat_db1 TABLE2 c33 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c34 char 0 NULL
+bup_xpfm_compat_db1 TABLE2 c35 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c36 char 255 NULL
+bup_xpfm_compat_db1 TABLE2 c37 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c38 char 0 NULL
+bup_xpfm_compat_db1 TABLE2 c39 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c40 char 255 NULL
+bup_xpfm_compat_db1 TABLE2 c41 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c42 char 0 NULL
+bup_xpfm_compat_db1 TABLE2 c43 char 1 NULL
+bup_xpfm_compat_db1 TABLE2 c44 char 255 NULL
+bup_xpfm_compat_db1 TABLE2 c45 varchar 0 NULL
+bup_xpfm_compat_db1 TABLE2 c46 varchar 1 NULL
+bup_xpfm_compat_db1 TABLE2 c47 varchar 255 NULL
+bup_xpfm_compat_db1 TABLE2 c48 varchar 261 NULL
+bup_xpfm_compat_db1 TABLE2 c49 varchar 0 NULL
+bup_xpfm_compat_db1 TABLE2 c50 varchar 1 NULL
+bup_xpfm_compat_db1 TABLE2 c51 varchar 255 NULL
+bup_xpfm_compat_db1 TABLE2 c52 varchar 261 NULL
+bup_xpfm_compat_db1 TABLE2 c53 varchar 0 NULL
+bup_xpfm_compat_db1 TABLE2 c54 varchar 1 NULL
+bup_xpfm_compat_db1 TABLE2 c55 varchar 255 NULL
+bup_xpfm_compat_db1 TABLE2 c56 varchar 261 NULL
+bup_xpfm_compat_db1 TABLE2 c57 binary 1 NULL
+bup_xpfm_compat_db1 TABLE2 c58 binary 0 NULL
+bup_xpfm_compat_db1 TABLE2 c59 binary 1 NULL
+bup_xpfm_compat_db1 TABLE2 c60 binary 255 NULL
+bup_xpfm_compat_db1 TABLE2 c61 varbinary 0 NULL
+bup_xpfm_compat_db1 TABLE2 c62 varbinary 1 NULL
+bup_xpfm_compat_db1 TABLE2 c63 varbinary 255 NULL
+bup_xpfm_compat_db1 TABLE2 c64 varbinary 261 NULL
+bup_xpfm_compat_db1 TABLE2 c65 tinyblob 255 NULL
+bup_xpfm_compat_db1 TABLE2 c66 tinytext 255 NULL
+bup_xpfm_compat_db1 TABLE2 c67 tinytext 127 NULL
+bup_xpfm_compat_db1 TABLE2 c68 blob 65535 NULL
+bup_xpfm_compat_db1 TABLE2 c69 text 65535 NULL
+bup_xpfm_compat_db1 TABLE2 c70 text 32767 NULL
+bup_xpfm_compat_db1 TABLE2 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db1 TABLE2 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db1 TABLE2 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db1 TABLE2 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db1 TABLE2 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db1 TABLE2 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db1 TABLE2 c77 enum 1 NULL
+bup_xpfm_compat_db1 TABLE2 c78 set 5 NULL
+bup_xpfm_compat_db1 TABLE2 crn int NULL 10
+bup_xpfm_compat_db1 TaBle3 c01 bit NULL 1
+bup_xpfm_compat_db1 TaBle3 c02 bit NULL 64
+bup_xpfm_compat_db1 TaBle3 c03 tinyint NULL 3
+bup_xpfm_compat_db1 TaBle3 c04 tinyint NULL 3
+bup_xpfm_compat_db1 TaBle3 c05 tinyint NULL 3
+bup_xpfm_compat_db1 TaBle3 c06 tinyint NULL 3
+bup_xpfm_compat_db1 TaBle3 c07 smallint NULL 5
+bup_xpfm_compat_db1 TaBle3 c08 smallint NULL 5
+bup_xpfm_compat_db1 TaBle3 c09 smallint NULL 5
+bup_xpfm_compat_db1 TaBle3 c10 mediumint NULL 7
+bup_xpfm_compat_db1 TaBle3 c11 mediumint NULL 7
+bup_xpfm_compat_db1 TaBle3 c12 mediumint NULL 7
+bup_xpfm_compat_db1 TaBle3 c13 int NULL 10
+bup_xpfm_compat_db1 TaBle3 c14 int NULL 10
+bup_xpfm_compat_db1 TaBle3 c15 int NULL 10
+bup_xpfm_compat_db1 TaBle3 c16 bigint NULL 19
+bup_xpfm_compat_db1 TaBle3 c17 bigint NULL 19
+bup_xpfm_compat_db1 TaBle3 c18 bigint NULL 19
+bup_xpfm_compat_db1 TaBle3 c19 float NULL 12
+bup_xpfm_compat_db1 TaBle3 c20 float NULL 12
+bup_xpfm_compat_db1 TaBle3 c21 float NULL 12
+bup_xpfm_compat_db1 TaBle3 c22 double NULL 22
+bup_xpfm_compat_db1 TaBle3 c23 double NULL 22
+bup_xpfm_compat_db1 TaBle3 c24 double NULL 22
+bup_xpfm_compat_db1 TaBle3 c25 decimal NULL 10
+bup_xpfm_compat_db1 TaBle3 c26 decimal NULL 10
+bup_xpfm_compat_db1 TaBle3 c27 decimal NULL 10
+bup_xpfm_compat_db1 TaBle3 c28 date NULL NULL
+bup_xpfm_compat_db1 TaBle3 c29 datetime NULL NULL
+bup_xpfm_compat_db1 TaBle3 c30 timestamp NULL NULL
+bup_xpfm_compat_db1 TaBle3 c31 time NULL NULL
+bup_xpfm_compat_db1 TaBle3 c32 year NULL NULL
+bup_xpfm_compat_db1 TaBle3 c33 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c34 char 0 NULL
+bup_xpfm_compat_db1 TaBle3 c35 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c36 char 255 NULL
+bup_xpfm_compat_db1 TaBle3 c37 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c38 char 0 NULL
+bup_xpfm_compat_db1 TaBle3 c39 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c40 char 255 NULL
+bup_xpfm_compat_db1 TaBle3 c41 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c42 char 0 NULL
+bup_xpfm_compat_db1 TaBle3 c43 char 1 NULL
+bup_xpfm_compat_db1 TaBle3 c44 char 255 NULL
+bup_xpfm_compat_db1 TaBle3 c45 varchar 0 NULL
+bup_xpfm_compat_db1 TaBle3 c46 varchar 1 NULL
+bup_xpfm_compat_db1 TaBle3 c47 varchar 255 NULL
+bup_xpfm_compat_db1 TaBle3 c48 varchar 261 NULL
+bup_xpfm_compat_db1 TaBle3 c49 varchar 0 NULL
+bup_xpfm_compat_db1 TaBle3 c50 varchar 1 NULL
+bup_xpfm_compat_db1 TaBle3 c51 varchar 255 NULL
+bup_xpfm_compat_db1 TaBle3 c52 varchar 261 NULL
+bup_xpfm_compat_db1 TaBle3 c53 varchar 0 NULL
+bup_xpfm_compat_db1 TaBle3 c54 varchar 1 NULL
+bup_xpfm_compat_db1 TaBle3 c55 varchar 255 NULL
+bup_xpfm_compat_db1 TaBle3 c56 varchar 261 NULL
+bup_xpfm_compat_db1 TaBle3 c57 binary 1 NULL
+bup_xpfm_compat_db1 TaBle3 c58 binary 0 NULL
+bup_xpfm_compat_db1 TaBle3 c59 binary 1 NULL
+bup_xpfm_compat_db1 TaBle3 c60 binary 255 NULL
+bup_xpfm_compat_db1 TaBle3 c61 varbinary 0 NULL
+bup_xpfm_compat_db1 TaBle3 c62 varbinary 1 NULL
+bup_xpfm_compat_db1 TaBle3 c63 varbinary 255 NULL
+bup_xpfm_compat_db1 TaBle3 c64 varbinary 261 NULL
+bup_xpfm_compat_db1 TaBle3 c65 tinyblob 255 NULL
+bup_xpfm_compat_db1 TaBle3 c66 tinytext 255 NULL
+bup_xpfm_compat_db1 TaBle3 c67 tinytext 127 NULL
+bup_xpfm_compat_db1 TaBle3 c68 blob 65535 NULL
+bup_xpfm_compat_db1 TaBle3 c69 text 65535 NULL
+bup_xpfm_compat_db1 TaBle3 c70 text 32767 NULL
+bup_xpfm_compat_db1 TaBle3 c71 mediumblob 16777215 NULL
+bup_xpfm_compat_db1 TaBle3 c72 mediumtext 16777215 NULL
+bup_xpfm_compat_db1 TaBle3 c73 mediumtext 8388607 NULL
+bup_xpfm_compat_db1 TaBle3 c74 longblob 4294967295 NULL
+bup_xpfm_compat_db1 TaBle3 c75 longtext 4294967295 NULL
+bup_xpfm_compat_db1 TaBle3 c76 longtext 2147483647 NULL
+bup_xpfm_compat_db1 TaBle3 c77 enum 1 NULL
+bup_xpfm_compat_db1 TaBle3 c78 set 5 NULL
+bup_xpfm_compat_db1 TaBle3 crn int NULL 10
+bup_xpfm_compat_db1 view1 c1 int NULL 10
+bup_xpfm_compat_db1 view1 c2 varchar 261 NULL
+bup_xpfm_compat_db1 view1 c3 int NULL 10
+bup_xpfm_compat_db1 view1 c4 int NULL 10
+bup_xpfm_compat_db1 view2 c2 varchar 261 NULL
+bup_xpfm_compat_db1 view2 c3 int NULL 10
+bup_xpfm_compat_db1 view3 c3 int NULL 10
+bup_xpfm_compat_db1 view3 c4 int NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c01 bit NULL 1
+BUP_XPFM_COMPAT_DB2 table1 c02 bit NULL 64
+BUP_XPFM_COMPAT_DB2 table1 c03 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 table1 c04 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 table1 c05 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 table1 c06 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 table1 c07 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 table1 c08 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 table1 c09 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 table1 c10 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 table1 c11 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 table1 c12 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 table1 c13 int NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c14 int NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c15 int NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c16 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 table1 c17 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 table1 c18 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 table1 c19 float NULL 12
+BUP_XPFM_COMPAT_DB2 table1 c20 float NULL 12
+BUP_XPFM_COMPAT_DB2 table1 c21 float NULL 12
+BUP_XPFM_COMPAT_DB2 table1 c22 double NULL 22
+BUP_XPFM_COMPAT_DB2 table1 c23 double NULL 22
+BUP_XPFM_COMPAT_DB2 table1 c24 double NULL 22
+BUP_XPFM_COMPAT_DB2 table1 c25 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c26 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c27 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 table1 c28 date NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c29 datetime NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c30 timestamp NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c31 time NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c32 year NULL NULL
+BUP_XPFM_COMPAT_DB2 table1 c33 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c34 char 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c35 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c36 char 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c37 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c38 char 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c39 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c40 char 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c41 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c42 char 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c43 char 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c44 char 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c45 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c46 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c47 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c48 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 table1 c49 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c50 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c51 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c52 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 table1 c53 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c54 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c55 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c56 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 table1 c57 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c58 binary 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c59 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c60 binary 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c61 varbinary 0 NULL
+BUP_XPFM_COMPAT_DB2 table1 c62 varbinary 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c63 varbinary 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c64 varbinary 261 NULL
+BUP_XPFM_COMPAT_DB2 table1 c65 tinyblob 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c66 tinytext 255 NULL
+BUP_XPFM_COMPAT_DB2 table1 c67 tinytext 127 NULL
+BUP_XPFM_COMPAT_DB2 table1 c68 blob 65535 NULL
+BUP_XPFM_COMPAT_DB2 table1 c69 text 65535 NULL
+BUP_XPFM_COMPAT_DB2 table1 c70 text 32767 NULL
+BUP_XPFM_COMPAT_DB2 table1 c71 mediumblob 16777215 NULL
+BUP_XPFM_COMPAT_DB2 table1 c72 mediumtext 16777215 NULL
+BUP_XPFM_COMPAT_DB2 table1 c73 mediumtext 8388607 NULL
+BUP_XPFM_COMPAT_DB2 table1 c74 longblob 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 table1 c75 longtext 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 table1 c76 longtext 2147483647 NULL
+BUP_XPFM_COMPAT_DB2 table1 c77 enum 1 NULL
+BUP_XPFM_COMPAT_DB2 table1 c78 set 5 NULL
+BUP_XPFM_COMPAT_DB2 table1 crn int NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c01 bit NULL 1
+BUP_XPFM_COMPAT_DB2 TABLE2 c02 bit NULL 64
+BUP_XPFM_COMPAT_DB2 TABLE2 c03 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TABLE2 c04 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TABLE2 c05 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TABLE2 c06 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TABLE2 c07 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TABLE2 c08 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TABLE2 c09 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TABLE2 c10 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TABLE2 c11 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TABLE2 c12 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TABLE2 c13 int NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c14 int NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c15 int NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c16 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TABLE2 c17 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TABLE2 c18 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TABLE2 c19 float NULL 12
+BUP_XPFM_COMPAT_DB2 TABLE2 c20 float NULL 12
+BUP_XPFM_COMPAT_DB2 TABLE2 c21 float NULL 12
+BUP_XPFM_COMPAT_DB2 TABLE2 c22 double NULL 22
+BUP_XPFM_COMPAT_DB2 TABLE2 c23 double NULL 22
+BUP_XPFM_COMPAT_DB2 TABLE2 c24 double NULL 22
+BUP_XPFM_COMPAT_DB2 TABLE2 c25 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c26 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c27 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TABLE2 c28 date NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c29 datetime NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c30 timestamp NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c31 time NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c32 year NULL NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c33 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c34 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c35 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c36 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c37 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c38 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c39 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c40 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c41 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c42 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c43 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c44 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c45 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c46 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c47 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c48 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c49 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c50 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c51 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c52 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c53 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c54 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c55 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c56 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c57 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c58 binary 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c59 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c60 binary 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c61 varbinary 0 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c62 varbinary 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c63 varbinary 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c64 varbinary 261 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c65 tinyblob 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c66 tinytext 255 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c67 tinytext 127 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c68 blob 65535 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c69 text 65535 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c70 text 32767 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c71 mediumblob 16777215 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c72 mediumtext 16777215 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c73 mediumtext 8388607 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c74 longblob 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c75 longtext 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c76 longtext 2147483647 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c77 enum 1 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 c78 set 5 NULL
+BUP_XPFM_COMPAT_DB2 TABLE2 crn int NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c01 bit NULL 1
+BUP_XPFM_COMPAT_DB2 TaBle3 c02 bit NULL 64
+BUP_XPFM_COMPAT_DB2 TaBle3 c03 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TaBle3 c04 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TaBle3 c05 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TaBle3 c06 tinyint NULL 3
+BUP_XPFM_COMPAT_DB2 TaBle3 c07 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TaBle3 c08 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TaBle3 c09 smallint NULL 5
+BUP_XPFM_COMPAT_DB2 TaBle3 c10 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TaBle3 c11 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TaBle3 c12 mediumint NULL 7
+BUP_XPFM_COMPAT_DB2 TaBle3 c13 int NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c14 int NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c15 int NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c16 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TaBle3 c17 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TaBle3 c18 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 TaBle3 c19 float NULL 12
+BUP_XPFM_COMPAT_DB2 TaBle3 c20 float NULL 12
+BUP_XPFM_COMPAT_DB2 TaBle3 c21 float NULL 12
+BUP_XPFM_COMPAT_DB2 TaBle3 c22 double NULL 22
+BUP_XPFM_COMPAT_DB2 TaBle3 c23 double NULL 22
+BUP_XPFM_COMPAT_DB2 TaBle3 c24 double NULL 22
+BUP_XPFM_COMPAT_DB2 TaBle3 c25 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c26 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c27 decimal NULL 10
+BUP_XPFM_COMPAT_DB2 TaBle3 c28 date NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c29 datetime NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c30 timestamp NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c31 time NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c32 year NULL NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c33 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c34 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c35 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c36 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c37 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c38 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c39 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c40 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c41 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c42 char 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c43 char 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c44 char 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c45 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c46 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c47 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c48 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c49 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c50 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c51 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c52 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c53 varchar 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c54 varchar 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c55 varchar 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c56 varchar 261 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c57 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c58 binary 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c59 binary 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c60 binary 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c61 varbinary 0 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c62 varbinary 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c63 varbinary 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c64 varbinary 261 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c65 tinyblob 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c66 tinytext 255 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c67 tinytext 127 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c68 blob 65535 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c69 text 65535 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c70 text 32767 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c71 mediumblob 16777215 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c72 mediumtext 16777215 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c73 mediumtext 8388607 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c74 longblob 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c75 longtext 4294967295 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c76 longtext 2147483647 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c77 enum 1 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 c78 set 5 NULL
+BUP_XPFM_COMPAT_DB2 TaBle3 crn int NULL 10
+BUP_XPFM_COMPAT_DB2 view1 c1 bigint NULL 19
+BUP_XPFM_COMPAT_DB2 view1 c2 double NULL 8
+BUP_XPFM_COMPAT_DB2 view1 c3 varchar 77 NULL
+BUP_XPFM_COMPAT_DB2 view1 c4 varchar 40 NULL
+bup_xpfm_compat_db2 view2 c1 int NULL 10
+bup_xpfm_compat_db2 view2 c2 varchar 261 NULL
+bup_xpfm_compat_db2 view3 c3 varchar 77 NULL
+bup_xpfm_compat_db2 view3 c4 varchar 40 NULL
+SELECT TABLE_SCHEMA, TABLE_NAME, VIEW_DEFINITION
+FROM INFORMATION_SCHEMA.VIEWS
+WHERE TABLE_SCHEMA like 'bup%xpfm%compat%'
+ ORDER BY LOWER(TABLE_SCHEMA), LOWER(TABLE_NAME);
+TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION
+BupXPfmCompat_db3 view1 select `view1`.`c1` AS `c1`,`view2`.`c1` AS `c2` from (`bup_xpfm_compat_db1`.`view1` join `bup_xpfm_compat_db2`.`view2`) where (`view1`.`c1` = `view2`.`c1`)
+BupXPfmCompat_db3 view2 select `view1`.`c1` AS `c1`,`view2`.`c1` AS `c2` from (`bup_xpfm_compat_db1`.`view1` left join `bup_xpfm_compat_db2`.`view2` on((`view1`.`c1` = `view2`.`c1`)))
+BupXPfmCompat_db3 view3 select `view1`.`c1` AS `c1`,`view1`.`c2` AS `c2` from `bupxpfmcompat_db3`.`view1`
bup_xpfm_compat_db1 view1 select `bup_xpfm_compat_db1`.`table1`.`c13` AS `c1`,`bup_xpfm_compat_db1`.`table1`.`c48` AS `c2`,`bup_xpfm_compat_db1`.`table1`.`c13` in (select (`bup_xpfm_compat_db1`.`table1`.`c13` + 2) AS `c13+2` from `bup_xpfm_compat_db1`.`table1`) AS `c3`,`bup_xpfm_compat_db1`.`table1`.`c13` = all (select `bup_xpfm_compat_db1`.`table1`.`c13` AS `c13` from `bup_xpfm_compat_db1`.`table1`) AS `c4` from `bup_xpfm_compat_db1`.`table1`
bup_xpfm_compat_db1 view2 select `view1`.`c2` AS `c2`,`view1`.`c3` AS `c3` from `bup_xpfm_compat_db1`.`view1`
bup_xpfm_compat_db1 view3 select `view1`.`c3` AS `c3`,`view1`.`c4` AS `c4` from `bup_xpfm_compat_db1`.`view1`
-bup_xpfm_compat_db2 view1 select connection_id() AS `c1`,pi() AS `c2`,current_user() AS `c3`,rpad(version(),40,' ') AS `c4`
-bup_xpfm_compat_db2 view2 select `bup_xpfm_compat_db2`.`table2`.`c13` AS `c1`,`bup_xpfm_compat_db2`.`table2`.`c48` AS `c2` from (`bup_xpfm_compat_db2`.`table2` join `bup_xpfm_compat_db2`.`table3`) union all select `bup_xpfm_compat_db2`.`table2`.`c13` AS `c13`,`bup_xpfm_compat_db2`.`table2`.`c48` AS `c48` from (`bup_xpfm_compat_db2`.`table2` join `bup_xpfm_compat_db2`.`table3`)
-bup_xpfm_compat_db2 view3 select `view1`.`c3` AS `c3`,`view1`.`c4` AS `c4` from `bup_xpfm_compat_db2`.`view1`
+BUP_XPFM_COMPAT_DB2 view1 select connection_id() AS `c1`,pi() AS `c2`,current_user() AS `c3`,rpad(version(),40,' ') AS `c4`
+BUP_XPFM_COMPAT_DB2 view2 select `bup_xpfm_compat_db2`.`table2`.`c13` AS `c1`,`bup_xpfm_compat_db2`.`table2`.`c48` AS `c2` from (`bup_xpfm_compat_db2`.`table2` join `bup_xpfm_compat_db2`.`table3`) union all select `bup_xpfm_compat_db2`.`table2`.`c13` AS `c13`,`bup_xpfm_compat_db2`.`table2`.`c48` AS `c48` from (`bup_xpfm_compat_db2`.`table2` join `bup_xpfm_compat_db2`.`table3`)
+BUP_XPFM_COMPAT_DB2 view3 select `view1`.`c3` AS `c3`,`view1`.`c4` AS `c4` from `bup_xpfm_compat_db2`.`view1`
SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_SCHEMA like 'bup%xpfm%compat%'
@@ -11278,37 +14238,37 @@ FROM INFORMATION_SCHEMA.TRIGGERS
WHERE TRIGGER_SCHEMA like 'bup%xpfm%compat%'
ORDER BY LOWER(TRIGGER_SCHEMA), LOWER(TRIGGER_NAME);
TRIGGER_SCHEMA TRIGGER_NAME ACTION_TIMING EVENT_MANIPULATION EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_STATEMENT
-bupxpfmcompat_db3 trigger1 AFTER INSERT bupxpfmcompat_db3 table1 BEGIN
+BupXPfmCompat_db3 trigger1 AFTER INSERT BupXPfmCompat_db3 table1 BEGIN
DELETE FROM BupXPfmCompat_db3.TABLE2
WHERE BupXPfmCompat_db3.TABLE2.c13 = NEW.c13;
END
-bupxpfmcompat_db3 TRIGGER2 AFTER INSERT bupxpfmcompat_db3 table2 BEGIN
+BupXPfmCompat_db3 TRIGGER2 AFTER INSERT BupXPfmCompat_db3 TABLE2 BEGIN
DELETE FROM BupXPfmCompat_db3.table1
WHERE BupXPfmCompat_db3.table1.c13 = NEW.c13;
END
-bupxpfmcompat_db3 TrigGer3 AFTER INSERT bupxpfmcompat_db3 table3 BEGIN
+BupXPfmCompat_db3 TrigGer3 AFTER INSERT BupXPfmCompat_db3 TaBle3 BEGIN
INSERT INTO bup_xpfm_compat_db1.table1 SET c13 = 53;
END
bup_xpfm_compat_db1 trigger1 AFTER INSERT bup_xpfm_compat_db1 table1 BEGIN
DELETE FROM bup_xpfm_compat_db1.TABLE2
WHERE bup_xpfm_compat_db1.TABLE2.c13 = NEW.c13;
END
-bup_xpfm_compat_db1 TRIGGER2 AFTER INSERT bup_xpfm_compat_db1 table2 BEGIN
+bup_xpfm_compat_db1 TRIGGER2 AFTER INSERT bup_xpfm_compat_db1 TABLE2 BEGIN
DELETE FROM bup_xpfm_compat_db1.table1
WHERE bup_xpfm_compat_db1.table1.c13 = NEW.c13;
END
-bup_xpfm_compat_db1 TrigGer3 AFTER INSERT bup_xpfm_compat_db1 table3 BEGIN
+bup_xpfm_compat_db1 TrigGer3 AFTER INSERT bup_xpfm_compat_db1 TaBle3 BEGIN
INSERT INTO BUP_XPFM_COMPAT_DB2.TABLE2 SET c13 = 51;
END
-bup_xpfm_compat_db2 trigger1 AFTER INSERT bup_xpfm_compat_db2 table1 BEGIN
+BUP_XPFM_COMPAT_DB2 trigger1 AFTER INSERT BUP_XPFM_COMPAT_DB2 table1 BEGIN
DELETE FROM BUP_XPFM_COMPAT_DB2.TABLE2
WHERE BUP_XPFM_COMPAT_DB2.TABLE2.c13 = NEW.c13;
END
-bup_xpfm_compat_db2 TRIGGER2 AFTER INSERT bup_xpfm_compat_db2 table2 BEGIN
+BUP_XPFM_COMPAT_DB2 TRIGGER2 AFTER INSERT BUP_XPFM_COMPAT_DB2 TABLE2 BEGIN
DELETE FROM BUP_XPFM_COMPAT_DB2.table1
WHERE BUP_XPFM_COMPAT_DB2.table1.c13 = NEW.c13;
END
-bup_xpfm_compat_db2 TrigGer3 AFTER INSERT bup_xpfm_compat_db2 table3 BEGIN
+BUP_XPFM_COMPAT_DB2 TrigGer3 AFTER INSERT BUP_XPFM_COMPAT_DB2 TaBle3 BEGIN
INSERT INTO BupXPfmCompat_db3.TaBle3 SET c13 = 52;
END
SHOW CREATE TRIGGER bup_xpfm_compat_db1.trigger1;
@@ -11789,8 +14749,6 @@ SELECT bup_xpfm_compat_db2.func1(5);
bup_xpfm_compat_db2.func1(5)
105
SELECT BUP_XPFM_COMPAT_DB2.FUNC2(6);
-BUP_XPFM_COMPAT_DB2.FUNC2(6)
-132
SELECT bup_xpfm_compat_db2.FUNC2(6);
bup_xpfm_compat_db2.FUNC2(6)
132
@@ -11807,8 +14765,6 @@ SELECT bupxpfmcompat_db3.FUNC2(9);
bupxpfmcompat_db3.FUNC2(9)
288
SELECT BupXPfmCompat_db3.FuNc3(10);
-BupXPfmCompat_db3.FuNc3(10)
-330
SELECT bupxpfmcompat_db3.FuNc3(10);
bupxpfmcompat_db3.FuNc3(10)
330
@@ -11874,7 +14830,3 @@ DROP USER 'bup_user1'@'%';
DROP USER 'BUP_USER2';
DROP USER 'BupUser3'@'%';
DROP USER 'no_user'@'%';
-#
-# Not safe to restore lctn2 image on lctn2 server
-# This will change when Bug#46266 (RESTORE fails on a server with
-# lower_case_table_names=2) is fixed.
=== modified file 'mysql-test/suite/backup/t/backup_xpfm_compat_restore_lctn2.test'
--- a/mysql-test/suite/backup/t/backup_xpfm_compat_restore_lctn2.test 2009-07-20 09:27:48 +0000
+++ b/mysql-test/suite/backup/t/backup_xpfm_compat_restore_lctn2.test 2009-08-13 09:34:00 +0000
@@ -71,15 +71,11 @@
--source suite/backup/include/backup_xpfm_compat_restore.inc
--echo #
---echo # Not safe to restore lctn2 image on lctn2 server
---echo # This will change when Bug#46266 (RESTORE fails on a server with
---echo # lower_case_table_names=2) is fixed.
-#--echo #
-#--echo # Windows 32 lctn2
-#--echo #
-#--let $IMAGE_FILE = backup_xpfm_compat_lctn2-windows_32.bak
-#--let $SHOW_OBJECTS=suite/backup/include/backup_xpfm_compat_show.inc
-#--source suite/backup/include/backup_xpfm_compat_restore.inc
+--echo # Windows 32 lctn2
+--echo #
+--let $IMAGE_FILE = backup_xpfm_compat_lctn2-windows_32.bak
+--let $SHOW_OBJECTS=suite/backup/include/backup_xpfm_compat_show.inc
+--source suite/backup/include/backup_xpfm_compat_restore.inc
--echo #
--echo # Windows 64 lctn1
@@ -89,13 +85,9 @@
--source suite/backup/include/backup_xpfm_compat_restore.inc
--echo #
---echo # Not safe to restore lctn2 image on lctn2 server
---echo # This will change when Bug#46266 (RESTORE fails on a server with
---echo # lower_case_table_names=2) is fixed.
-#--echo #
-#--echo # Windows 64 lctn2
-#--echo #
-#--let $IMAGE_FILE = backup_xpfm_compat_lctn2-windows_64.bak
-#--let $SHOW_OBJECTS=suite/backup/include/backup_xpfm_compat_show.inc
-#--source suite/backup/include/backup_xpfm_compat_restore.inc
+--echo # Windows 64 lctn2
+--echo #
+--let $IMAGE_FILE = backup_xpfm_compat_lctn2-windows_64.bak
+--let $SHOW_OBJECTS=suite/backup/include/backup_xpfm_compat_show.inc
+--source suite/backup/include/backup_xpfm_compat_restore.inc
Attachment: [text/bzr-bundle] bzr/rafal.somla@sun.com-20090813093400-uqm13abvfhvpvd1d.bundle
| Thread |
|---|
| • bzr push into mysql-6.0-backup branch (Rafal.Somla:2858 to 2859)Bug#46266 | Rafal Somla | 13 Aug |