#At file:///ext/mysql/bzr/backup/bug46266/ based on revid:rafal.somla@strippednpka231y205cg
2854 Rafal Somla 2009-08-11
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
=== 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-11 08:32:23 +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 ������������+3 NULL NULL
+4 2147483647 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 ����� 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 ��������������L NULL
+4 2147483647 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 �������iiiiiiiiiiiiiiiiiiiiiiiii
+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
+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 ���������iiiiiiiiiiiiiiiiiii
+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 ��������������LL 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 ��������iiiiiiiiiiiiiiiiiiiiii
+#
+# 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 ������������� 0
+NULL NULL NULL 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 �������������LL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 �����iiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ����iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 �����������iiiiiiiii
+-2147483648
+2147483647 ���647 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);
+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 ��2147483647 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 �����������iiiiiiiiiiiiii
+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 ����3647 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 ������iiiiiiiiiiiiiiiiiiiiiiiiiiiii
+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 ���������������NULL
+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 ���������iiiiiiiiiiiiiiiiiii
+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 ��������������LL 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 ���LL 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
+�������iiiiiiiiiiiiiii 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 ���647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ��83647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ����������iiiiiiiiiiiii
+-2147483648
+2147483647 ������������������������������������������������������������
+NULL NULL
+2147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-2147483648
+2147483647 ���������iiiiiiiiiiiiiii
+-2147483648
+2147483647 �147483647 iiiiiiiiiiiiiiiiiiiiiiiiiiiiii
+-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-11 08:32:23 +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-20090811083223-jw65ns8twnif15zu.bundle
| Thread |
|---|
| • bzr commit into mysql-5.4 branch (Rafal.Somla:2854) Bug#46266 | Rafal Somla | 11 Aug |