TYPE=TRIGGERS
triggers='CREATE DEFINER=`rqg`@`localhost` TRIGGER trigger132301 BEFORE INSERT ON trigger132301 FOR EACH ROW INSERT INTO transforms.trigger232301 SELECT /* QNO 17297 CON_ID 10 */ alias1.`col_int` AS cfield1, alias1.`col_int` AS ifield1 FROM ( `table0_myisam_int` AS alias1 INNER JOIN ( ( `table0_myisam_int` AS alias2 INNER JOIN ( SELECT SQ1_alias1.* FROM ( `table0_myisam_int` AS SQ1_alias1 RIGHT OUTER JOIN ( `table0_myisam_int` AS SQ1_alias2 INNER JOIN `table0_myisam_int` AS SQ1_alias3 ON (SQ1_alias3.`col_int` = SQ1_alias2.`col_int` ) ) ON (SQ1_alias3.`pk` = SQ1_alias2.`col_int` ) ) ) AS alias3 ON (( alias3.`pk` != alias2.`pk` ) OR ( ( alias3.`pk` <> alias2.`pk` ) AND (alias3.`pk` >= alias2.`pk` ) ) ) ) ) ON (( alias3.`pk` < alias2.`pk` ) AND (alias3.`pk` > alias2.`pk` ) ) ) WHERE ( EXISTS ( SELECT SQ2_alias1.`col_int` AS SQ2_ifield1 FROM ( `table0_myisam_int` AS SQ2_alias1, `table0_myisam_int` AS SQ2_alias2 ) WHERE alias3.`pk` IN ( ( SELECT C_SQ1_alias1.`pk` AS C_SQ1_ifield1 FROM `table0_myisam_int` AS C_SQ1_alias1 ) ) AND SQ2_alias1.`pk` <= alias1.`col_int` ) ) AND ( alias1.`col_int` = alias3.`col_int` OR alias1.`pk` = \'x\' ) GROUP BY cfield1, ifield1 HAVING ifield1 != 2 ORDER BY cfield1, ifield1'
sql_modes=1411383296
definers='rqg@localhost'
client_cs_names='latin1'
connection_cl_names='latin1_swedish_ci'
db_cl_names='latin1_swedish_ci'
created=159413873658
