150
150
where TABLE_SCHEMA ='mysqltest_LC2';
152
152
drop database mysqltest_LC2;
156
--echo # Bug #11758687: 50924: object names not resolved correctly
157
--echo # on lctn2 systems
160
CREATE DATABASE BUP_XPFM_COMPAT_DB2;
162
CREATE TABLE BUP_XPFM_COMPAT_DB2.TABLE2 (c13 INT) DEFAULT CHARSET latin1;
163
CREATE TABLE BUP_XPFM_COMPAT_DB2.table1 (c13 INT) DEFAULT CHARSET latin1;
164
CREATE TABLE bup_xpfm_compat_db2.table3 (c13 INT) DEFAULT CHARSET latin1;
168
CREATE TRIGGER BUP_XPFM_COMPAT_DB2.trigger1 AFTER INSERT
169
ON BUP_XPFM_COMPAT_DB2.table1 FOR EACH ROW
170
update BUP_XPFM_COMPAT_DB2.table1 set c13=12;
172
CREATE TRIGGER BUP_XPFM_COMPAT_DB2.TRIGGER2 AFTER INSERT
173
ON BUP_XPFM_COMPAT_DB2.TABLE2 FOR EACH ROW
174
update BUP_XPFM_COMPAT_DB2.table1 set c13=12;
176
CREATE TRIGGER BUP_XPFM_COMPAT_DB2.TrigGer3 AFTER INSERT
177
ON BUP_XPFM_COMPAT_DB2.TaBle3 FOR EACH ROW
178
update BUP_XPFM_COMPAT_DB2.table1 set c13=12;
182
SELECT trigger_schema, trigger_name, event_object_table FROM
183
INFORMATION_SCHEMA.TRIGGERS
184
WHERE trigger_schema COLLATE utf8_bin = 'BUP_XPFM_COMPAT_DB2'
185
ORDER BY trigger_schema, trigger_name;
187
DROP DATABASE BUP_XPFM_COMPAT_DB2;
189
--echo End of 5.1 tests