Java tutorial
package it.at.script; import static org.hamcrest.CoreMatchers.*; import static org.junit.Assert.*; import it.at.os.ConnectionScanner; import java.io.IOException; import java.net.URL; import java.util.Enumeration; import java.util.List; import org.apache.commons.lang3.StringEscapeUtils; import org.apache.commons.lang3.StringUtils; import org.junit.Test; public class ConnectionScannerTest { /* use StringBuffer buffer = new StringBuffer(); to avoid [ERROR] COMPILATION ERROR : [INFO] ------------------------------------------------------------- [ERROR] /home/alan/CLab2/mysql-stress-tool/src/test/java/script/at/com/ConnectionScannerTest.java:[45,17] constant string too long [INFO] 1 error [INFO] ------------------------------------------------------------- [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] -------------------------------- */ String resultAHEAD_ROWS = "USE C3000116 " + "UPDATE MLR_TA_USERDB AS U SET U.LOCKED = 1 WHERE U.USERDB_ID = 6394 AND NOT U.LOCKED AND NOT ( SELECT COUNT(*)>0 FROM MLR_TA_NEWSLETTER N LEFT JOIN MLR_TA_DELIVERY D ON N.NEWSLETTER_ID = D.NEWSLETTER_ID WHERE N.USERDB_ID = 6394 AND NOT D.IS_TEST AND D.STATUS NOT IN (3,5,6,7,8,12,13,-3) )" + "SHOW WARNINGS"; String result5143 = "USE C3000119" + "/* mysql-connector-java-5.1.21 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect'" + "/* mysql-connector-java-5.1.21 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment" + "SHOW COLLATION" + "SET NAMES latin1" + "SET character_set_results = NULL" + "SET autocommit=1" + "SET sql_mode='STRICT_TRANS_TABLES'" + "SELECT last_row FROM counters WHERE `name` = 'micro_monitoring_domains_last_update'" + "SELECT micro_monitor_domain_id, domain from micro_monitoring_domains where monitor_domain = 1" + "SELECT micro_monitor_domain_id, domain from micro_monitoring_domains where monitor_domain = 1" + "SELECT micro_monitor_domain_id, domain from micro_monitoring_domains where monitor_domain = 1" + "SELECT micro_monitor_domain_id, domain from micro_monitoring_domains where monitor_domain = 1" + "DELETE FROM MLR_TA_DELIVERY_CACHE WHERE sent = 0 OR sent IS NULL" + "INSERT IGNORE INTO MLR_TA_DELIVERY_CACHE (delivery_id, qualifier_id, newsletter_id, status, delivery_date, delivery_end_date, sent, role, parent_id, row_date) SELECT d.DELIVERY_ID, t.QUALIFIER_ID, d.NEWSLETTER_ID, d.STATUS, d.START_DATE, d.END_DATE, d.RECIPIENTS, d.ROLE, d.PARENT_ID, NOW() FROM `MLR_TA_DELIVERY` as d INNER JOIN MLR_TA_TEMPLATE as t ON d.TEMPLATE_ID = t.TEMPLATE_ID WHERE d.STATUS IN (3, -3, 8, 12, 13, 2) AND d.IS_TEST = 0 AND t.MEDIUM = 0 AND d.RECIPIENTS > 0 AND NOT EXISTS (select delivery_id from MLR_TA_DELIVERY_CACHE WHERE delivery_id = d.DELIVERY_ID)" + "INSERT IGNORE INTO MLR_TA_DELIVERY_CACHE (delivery_id, qualifier_id, newsletter_id, status, delivery_date, delivery_end_date, sent, role, parent_id, row_date) SELECT d.DELIVERY_ID, t.QUALIFIER_ID, d.NEWSLETTER_ID, d.STATUS, d.START_DATE, d.END_DATE, d.RECIPIENTS, d.ROLE, d.PARENT_ID, NOW() FROM `MLR_TA_DELIVERY` as d INNER JOIN MLR_TA_TEMPLATE as t ON d.TEMPLATE_ID = t.TEMPLATE_ID WHERE d.STATUS IN (3, -3, 8, 12, 13, 2) AND t.MEDIUM IN (1, 2, 3) AND d.RECIPIENTS > 0 AND NOT EXISTS (select delivery_id from MLR_TA_DELIVERY_CACHE WHERE delivery_id = d.DELIVERY_ID)" + "SELECT DELIVERY_ID FROM MLR_TA_DELIVERY WHERE IS_TEST = 0 AND ARCHIVED = 0 AND (START_DATE > DATE_SUB(NOW() , INTERVAL 1 MONTH) OR END_DATE >= DATE_SUB(NOW() , INTERVAL 1 MONTH)) AND EXISTS( SELECT delivery_id from MLR_TA_DELIVERY_CACHE WHERE delivery_id = MLR_TA_DELIVERY.DELIVERY_ID AND (update_date < DATE_SUB(NOW(), INTERVAL 1 WEEK)))" + "SELECT delivery_id FROM MLR_TA_DELIVERY_CACHE WHERE ( update_date <= DATE_SUB(NOW(), INTERVAL 120 MINUTE) OR update_date IS NULL OR delivery_date >= DATE_SUB(NOW(), INTERVAL 2 HOUR )) AND ( delivery_date >= DATE_SUB(NOW(), INTERVAL 8 DAY) AND is_triggered = 0) AND STATUS IN(3, -3) AND archived = 0 and sent > 0 ORDER BY update_date ASC"; // String result4320 = // "C3000116@172.17.2.11 on" // + "/* mysql-connector-java-commercial-5.1.32 ( Revision: jess.balint@oracle.com-20140716155848-mlwabor66widht1n ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'license' OR Variable_name = 'init_connect'" // + "/* mysql-connector-java-commercial-5.1.32 ( Revision: jess.balint@oracle.com-20140716155848-mlwabor66widht1n ) */SELECT @@session.auto_increment_increment" // + "SET NAMES latin1" // + "SET character_set_results = NULL" // + "SET autocommit=1" // + "SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.MlrTaUserdb */ insert into `MLR_TA_USERDB` (`CHARSET`, `DB_CONNECTION_TYPE`, `DB_HOST`, `DB_NAME`, `DB_PASSWORD`, `DB_TYPE`, `DB_USER`, `DEFAULT_JOIN_TABLES`, `DEFAULT_QUALIFIER`, `DESCRIPTION`, `EMAIL_FIELD`, `FAX_FIELD`, `FILTER_FIELDS`, `HIDDEN`, `JOIN_TABLES`, `LOCKED`, `MONITORING`, `NAME`, `PHONE_FIELD`, `PRIMARY_KEY_FIELD`, `PUSH_FIELD`, `QUALIFIER`, `READONLY`, `TABLE_NAME`, `TYPE_STRUCT`, `USABLE_FIELDS`, `VERSION_BY`, `VERSION_DATE`) values (_binary'UTF-8', 3, _binary'172.16.8.75', _binary'C3000116', _binary'tETC6laeO0', 0, _binary'C3000116', null, null, _binary'TEST DB for mobile', null, null, null, 0, null, 0, 0, _binary'TEST DB mobile DB', null, _binary'PK_ID', _binary'PUSH_KEY', _binary'1', 0, _binary'', 0, _binary'PUSH_ENDPOINT_TYPE,Field_2,push_endpoint_field,Field_4', 3000116, '2015-01-20 10:32:33')" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "/* update com.at.persistence.model.customer.MlrTaUserdb */ update `MLR_TA_USERDB` set `CHARSET`=_binary'UTF-8', `DB_CONNECTION_TYPE`=3, `DB_HOST`=_binary'172.16.8.75', `DB_NAME`=_binary'C3000116', `DB_PASSWORD`=_binary'tETC6laeO0', `DB_TYPE`=0, `DB_USER`=_binary'C3000116', `DEFAULT_JOIN_TABLES`=null, `DEFAULT_QUALIFIER`=null, `DESCRIPTION`=_binary'TEST DB for mobile', `EMAIL_FIELD`=null, `FAX_FIELD`=null, `FILTER_FIELDS`=null, `HIDDEN`=0, `JOIN_TABLES`=null, `LOCKED`=0, `MONITORING`=0, `NAME`=_binary'TEST DB mobile DB', `PHONE_FIELD`=null, `PRIMARY_KEY_FIELD`=_binary'PK_ID', `PUSH_FIELD`=_binary'PUSH_KEY', `QUALIFIER`=_binary'1', `READONLY`=0, `TABLE_NAME`=_binary'', `TYPE_STRUCT`=0, `USABLE_FIELDS`=_binary'PUSH_ENDPOINT_TYPE,Field_2,push_endpoint_field,Field_4', `VERSION_BY`=3000116, `VERSION_DATE`='2015-01-20 10:32:33' where `USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* update com.at.persistence.model.customer.MlrTaUserdb */ update `MLR_TA_USERDB` set `CHARSET`=_binary'UTF-8', `DB_CONNECTION_TYPE`=3, `DB_HOST`=_binary'172.16.8.75', `DB_NAME`=_binary'C3000116', `DB_PASSWORD`=_binary'tETC6laeO0', `DB_TYPE`=0, `DB_USER`=_binary'C3000116', `DEFAULT_JOIN_TABLES`=null, `DEFAULT_QUALIFIER`=null, `DESCRIPTION`=_binary'TEST DB for mobile', `EMAIL_FIELD`=null, `FAX_FIELD`=null, `FILTER_FIELDS`=null, `HIDDEN`=0, `JOIN_TABLES`=null, `LOCKED`=0, `MONITORING`=0, `NAME`=_binary'TEST DB mobile DB', `PHONE_FIELD`=null, `PRIMARY_KEY_FIELD`=_binary'PK_ID', `PUSH_FIELD`=_binary'PUSH_KEY', `QUALIFIER`=_binary'1', `READONLY`=0, `TABLE_NAME`=_binary'DB_6394', `TYPE_STRUCT`=0, `USABLE_FIELDS`=_binary'PUSH_ENDPOINT_TYPE,Field_2,push_endpoint_field,Field_4', `VERSION_BY`=3000116, `VERSION_DATE`='2015-01-20 10:32:33' where `USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "CREATE TABLE DB_6394 (PK_ID INTEGER(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, PUSH_KEY VARCHAR(255) NOT NULL, Field_2 VARCHAR(255), push_endpoint_field VARCHAR(255), Field_4 VARCHAR(255), KEY INDEX_PUSH_KEY (PUSH_KEY))" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.MlrTaUserdbFieldMetadata */ insert into `MLR_TA_USERDB_FIELD_METADATA` (`id_metadata_field_type`, `is_behavioural`, `is_behavioural_enabled`, `field_name`, `userdb_id`) values (31, 0, 0, _binary'push_endpoint_field', 6394)" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM DB_6394 WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355147, 1421746355164, _binary'COPY_FILE', _binary'AP000003', 7935, 3)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.csv', 10079)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355218, 1421746355220, _binary'CONVERT_TO_CSV', _binary'AP000021', 7935, 21)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10080)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "CREATE TABLE FILE_OP_7935_ LIKE DB_6394" // + "USE C3000116" // + "ALTER TABLE FILE_OP_7935_ ADD COLUMN `is_wrong_recipient` BOOLEAN NOT NULL DEFAULT 0, ADD COLUMN `has_duplicate_local` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, ADD COLUMN `has_duplicate_remote` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, ADD COLUMN `internal_autoincrement` INTEGER UNSIGNED, ADD COLUMN `candidate` INTEGER UNSIGNED, ADD COLUMN `updated` BOOLEAN NOT NULL DEFAULT 0" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355260, 1421746355285, _binary'CREATE_TEMP_TABLE', _binary'AP000005', 7935, 5)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10081)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10081)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10081)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM FILE_OP_7935_ WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM FILE_OP_7935_ WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "LOAD DATA LOCAL INFILE 'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv' INTO TABLE FILE_OP_7935_ FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 0 LINES (PK_ID,PUSH_KEY,Field_2,push_endpoint_field,Field_4)" // + "SHOW COUNT(*) ERRORS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355328, 1421746355343, _binary'LOAD_SOURCE_DATA', _binary'AP000006', 7935, 6)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10082)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10082)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10082)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'0', 10082)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10082)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM FILE_OP_7935_ WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "UPDATE FILE_OP_7935_ SET is_wrong_recipient = is_wrong_recipient + (PUSH_KEY IS NULL OR TRIM(PUSH_KEY) = '')" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* criteria query */ select this_.`field_name` as field_na1_18_0_, this_.`userdb_id` as userdb_i2_18_0_, this_.`id_metadata_field_type` as id_metad3_18_0_, this_.`is_behavioural` as is_behav4_18_0_, this_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB_FIELD_METADATA` this_ where this_.`userdb_id`=6394 and this_.`id_metadata_field_type`=31" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM FILE_OP_7935_ WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "UPDATE FILE_OP_7935_ SET is_wrong_recipient = is_wrong_recipient + (BINARY push_endpoint_field NOT IN ('APN','GCM'))" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355402, 1421746355474, _binary'CHECK_VALID_RECIPIENTS', _binary'AP000007', 7935, 7)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10083)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10083)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10083)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'0', 10083)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10083)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM FILE_OP_7935_ WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "/* criteria query */ select this_.`field_name` as field_na1_18_0_, this_.`userdb_id` as userdb_i2_18_0_, this_.`id_metadata_field_type` as id_metad3_18_0_, this_.`is_behavioural` as is_behav4_18_0_, this_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB_FIELD_METADATA` this_ where this_.`userdb_id`=6394 and this_.`id_metadata_field_type`=31" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "UPDATE FILE_OP_7935_ AS a JOIN ( SELECT PUSH_KEY, push_endpoint_field FROM FILE_OP_7935_ GROUP BY BINARY PUSH_KEY, BINARY push_endpoint_field HAVING count( * )> 1 ) AS b SET a.has_duplicate_local = a.has_duplicate_local + 8 WHERE BINARY a.PUSH_KEY = b.PUSH_KEY AND BINARY a.push_endpoint_field = b.push_endpoint_field" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355531, 1421746355559, _binary'CHECK_LOCALLY_DUPLICATED_RECIPIENTS', _binary'AP000008', 7935, 8)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10084)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10084)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10084)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'0', 10084)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10084)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM FILE_OP_7935_ WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "/* criteria query */ select this_.`field_name` as field_na1_18_0_, this_.`userdb_id` as userdb_i2_18_0_, this_.`id_metadata_field_type` as id_metad3_18_0_, this_.`is_behavioural` as is_behav4_18_0_, this_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB_FIELD_METADATA` this_ where this_.`userdb_id`=6394 and this_.`id_metadata_field_type`=31" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "UPDATE FILE_OP_7935_ AS a JOIN DB_6394 b ON BINARY a.PUSH_KEY = b.PUSH_KEY AND BINARY a.push_endpoint_field = b.push_endpoint_field SET a.has_duplicate_remote = a.has_duplicate_remote + 1" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355615, 1421746355643, _binary'CHECK_REMOTELY_DUPLICATED_RECIPIENTS', _binary'AP000009', 7935, 9)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10085)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10085)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10085)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'0', 10085)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10085)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT `PUSH_KEY`, `Field_2`, `push_endpoint_field`, `Field_4` FROM FILE_OP_7935_ WHERE 1" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355702, 1421746355778, _binary'EXTRACT_DATA', _binary'AP000010', 7935, 10)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_INSERTED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Inserted_Records.csv', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'0', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_UPDATED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Updated_Records.csv', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_KO_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Wrong_Records.csv', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_DELETED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Deleted_Records.csv', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DL_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_File.csv', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_OK_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Selected_Records.csv', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'AFFECTED_RECORDS', _binary'13', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DR_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_DB.csv', 10086)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT COUNT(*) FROM `DB_6394`" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746355884, 1421746355904, _binary'EXECUTE_ALGORITHM', _binary'AP000020', 7935, 20)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_INSERTED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Inserted_Records.csv', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'0', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_UPDATED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Updated_Records.csv', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_KO_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Wrong_Records.csv', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_BEFORE', _binary'0', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_DELETED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Deleted_Records.csv', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DL_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_File.csv', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_AFTER', _binary'13', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_OK_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Selected_Records.csv', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'AFFECTED_RECORDS', _binary'13', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DR_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_DB.csv', 10087)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT COUNT(*) FROM `DB_6394`" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM DB_6394 WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "LOAD DATA LOCAL INFILE '/tmp/jboss/AP/fileOperations/3000116/7935/Selected_Records.csv' INTO TABLE DB_6394 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '' IGNORE 0 LINES (PUSH_KEY,Field_2,push_endpoint_field,Field_4)" // + "SHOW COUNT(*) ERRORS" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT COUNT(*) FROM `DB_6394`" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746356037, 1421746356108, _binary'LOAD_EXTRACTED_DATA', _binary'AP000011', 7935, 11)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_INSERTED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Inserted_Records.csv', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'0', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_UPDATED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Updated_Records.csv', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_KO_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Wrong_Records.csv', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_BEFORE', _binary'0', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_DELETED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Deleted_Records.csv', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DL_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_File.csv', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_AFTER', _binary'13', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_OK_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Selected_Records.csv', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'AFFECTED_RECORDS', _binary'13', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DR_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_DB.csv', 10088)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT PK_ID,PUSH_KEY,Field_2,push_endpoint_field,Field_4 FROM FILE_OP_7935_ where is_wrong_recipient > 0" // + "USE clabanchor" // + "USE C3000116" // + "SELECT PK_ID,PUSH_KEY,Field_2,push_endpoint_field,Field_4 FROM FILE_OP_7935_ where has_duplicate_local > 0" // + "USE clabanchor" // + "USE C3000116" // + "SELECT PK_ID,PUSH_KEY,Field_2,push_endpoint_field,Field_4 FROM FILE_OP_7935_ where has_duplicate_remote > 0" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746356240, 1421746356262, _binary'EXTRACT_STATISTICS', _binary'AP000013', 7935, 13)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_INSERTED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Inserted_Records.csv', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'3', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_UPDATED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Updated_Records.csv', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_KO_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Wrong_Records.csv', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_BEFORE', _binary'0', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_LOCALLY_DUPLICATED_COUNT', _binary'2', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_OK_COUNT', _binary'10', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_DELETED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Deleted_Records.csv', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DL_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_File.csv', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_AFTER', _binary'13', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_OK_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Selected_Records.csv', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'AFFECTED_RECORDS', _binary'13', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'EXTRACTED_ZIP_FILE_NAME', _binary'\\u\\data\\at\\files\\3000116\\FILE_OP_7935.zip', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DR_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_DB.csv', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_REMOTELY_DUPLICATED_COUNT', _binary'0', 10089)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746356411, 1421746356465, _binary'SAVE_PROCESS_REPORT', _binary'AP000012', 7935, 12)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_INSERTED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Inserted_Records.csv', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'3', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_UPDATED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Updated_Records.csv', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_KO_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Wrong_Records.csv', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_BEFORE', _binary'0', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_LOCALLY_DUPLICATED_COUNT', _binary'2', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_OK_COUNT', _binary'10', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_DELETED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Deleted_Records.csv', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DL_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_File.csv', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_AFTER', _binary'13', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_OK_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Selected_Records.csv', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'AFFECTED_RECORDS', _binary'13', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'EXTRACTED_ZIP_FILE_NAME', _binary'\\u\\data\\at\\files\\3000116\\FILE_OP_7935.zip', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DR_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_DB.csv', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_REMOTELY_DUPLICATED_COUNT', _binary'0', 10090)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746356631, 1421746356807, _binary'SEND_EMAIL_REPORT', _binary'AP000014', 7935, 14)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_INSERTED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Inserted_Records.csv', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'3', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_UPDATED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Updated_Records.csv', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_KO_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Wrong_Records.csv', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_BEFORE', _binary'0', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_LOCALLY_DUPLICATED_COUNT', _binary'2', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_OK_COUNT', _binary'10', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_DELETED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Deleted_Records.csv', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DL_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_File.csv', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_AFTER', _binary'13', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_OK_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Selected_Records.csv', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'AFFECTED_RECORDS', _binary'13', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'EXTRACTED_ZIP_FILE_NAME', _binary'\\u\\data\\at\\files\\3000116\\FILE_OP_7935.zip', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DR_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_DB.csv', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_REMOTELY_DUPLICATED_COUNT', _binary'0', 10091)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "DROP TABLE IF EXISTS FILE_OP_7935_" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* update com.at.persistence.model.customer.MlrTaUserdb */ update `MLR_TA_USERDB` set `CHARSET`=_binary'UTF-8', `DB_CONNECTION_TYPE`=3, `DB_HOST`=_binary'172.16.8.75', `DB_NAME`=_binary'C3000116', `DB_PASSWORD`=_binary'tETC6laeO0', `DB_TYPE`=0, `DB_USER`=_binary'C3000116', `DEFAULT_JOIN_TABLES`=null, `DEFAULT_QUALIFIER`=null, `DESCRIPTION`=_binary'TEST DB for mobile', `EMAIL_FIELD`=null, `FAX_FIELD`=null, `FILTER_FIELDS`=null, `HIDDEN`=0, `JOIN_TABLES`=null, `LOCKED`=0, `MONITORING`=0, `NAME`=_binary'TEST DB mobile DB', `PHONE_FIELD`=null, `PRIMARY_KEY_FIELD`=_binary'PK_ID', `PUSH_FIELD`=_binary'PUSH_KEY', `QUALIFIER`=_binary'1', `READONLY`=0, `TABLE_NAME`=_binary'DB_6394', `TYPE_STRUCT`=0, `USABLE_FIELDS`=_binary'PUSH_ENDPOINT_TYPE,Field_2,push_endpoint_field,Field_4', `VERSION_BY`=3000116, `VERSION_DATE`='2015-01-20 10:32:33' where `USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransition */ insert into `wrh_process_transition` (`begins_at`, `ends_at`, `message`, `message_code`, `process_id`, `sub_status_id`) values (1421746356971, 1421746357018, _binary'CLEAN_TEMPORARY_DATA', _binary'AP000015', 7935, 15)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_INSERTED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Inserted_Records.csv', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'LOCAL_SOURCE_FILE_PATH', _binary'C:\\tmp\\jboss\\AP\\fileOperations\\3000116\\7935\\fileOperation4880993734274841690.1421746355218.csv', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_KO_COUNT', _binary'3', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_UPDATED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Updated_Records.csv', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_KO_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Wrong_Records.csv', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_BEFORE', _binary'0', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_LOCALLY_DUPLICATED_COUNT', _binary'2', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_OK_COUNT', _binary'10', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORDS_DELETED_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Deleted_Records.csv', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DL_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_File.csv', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_COUNT_AFTER', _binary'13', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'TEMPORARY_TABLE_NAME', _binary'FILE_OP_7935_', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'SOURCE_FILE_COLUMN_COUNT', _binary'5', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'INPUT_RECORD_COUNT', _binary'13', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_OK_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Selected_Records.csv', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'AFFECTED_RECORDS', _binary'13', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'EXTRACTED_ZIP_FILE_NAME', _binary'\\u\\data\\at\\files\\3000116\\FILE_OP_7935.zip', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (1, _binary'RECORD_DR_FILE_PATH', _binary'/tmp/jboss/AP/fileOperations/3000116/7935/Duplicated_Records_DB.csv', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* insert com.at.persistence.model.customer.WrhProcessTransitionParameter */ insert into `wrh_process_transition_parameter` (parameter_type_id, `key`, `value`, process_transition_id) values (2, _binary'RECORD_REMOTELY_DUPLICATED_COUNT', _binary'0', 10092)" // + "SHOW WARNINGS" // + "select last_insert_id()" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM DB_6394 WHERE false" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "SELECT * FROM DB_6394 WHERE 1 AND (1 = 1)" // + "USE C3000116" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* criteria query */ select this_.`field_name` as field_na1_18_0_, this_.`userdb_id` as userdb_i2_18_0_, this_.`id_metadata_field_type` as id_metad3_18_0_, this_.`is_behavioural` as is_behav4_18_0_, this_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB_FIELD_METADATA` this_ where this_.`userdb_id`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdbFieldMetadata */ select mlrtauserd0_.`field_name` as field_na1_18_0_, mlrtauserd0_.`userdb_id` as userdb_i2_18_0_, mlrtauserd0_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd0_.`is_behavioural` as is_behav4_18_0_, mlrtauserd0_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd0_ where mlrtauserd0_.`field_name`=_binary'push_endpoint_field' and mlrtauserd0_.`userdb_id`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* get current state com.at.persistence.model.customer.MlrTaUserdbFieldMetadata */ select mlrtauserd_.`field_name`, mlrtauserd_.`userdb_id`, mlrtauserd_.`id_metadata_field_type` as id_metad3_18_, mlrtauserd_.`is_behavioural` as is_behav4_18_, mlrtauserd_.`is_behavioural_enabled` as is_behav5_18_ from `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd_ where mlrtauserd_.`field_name`=_binary'push_endpoint_field' and mlrtauserd_.`userdb_id`=6394" // + "SHOW WARNINGS" // + "/* delete com.at.persistence.model.customer.MlrTaUserdbFieldMetadata */ delete from `MLR_TA_USERDB_FIELD_METADATA` where `field_name`=_binary'push_endpoint_field' and `userdb_id`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_1_, mlrtauserd0_.`CHARSET` as CHARSET2_19_1_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_1_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_1_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_1_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_1_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_1_, mlrtauserd0_.`DB_USER` as DB_USER8_19_1_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_1_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_1_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_1_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_1_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_1_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_1_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_1_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_1_, mlrtauserd0_.`LOCKED` as LOCKED17_19_1_, mlrtauserd0_.`MONITORING` as MONITOR18_19_1_, mlrtauserd0_.`NAME` as NAME19_19_1_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_1_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_1_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_1_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_1_, mlrtauserd0_.`READONLY` as READONL24_19_1_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_1_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_1_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_1_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_1_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_1_, mlrtauserd1_.userdb_id as userdb_i2_19_3_, mlrtauserd1_.`field_name` as field_na1_18_3_, mlrtauserd1_.`userdb_id` as userdb_i2_18_3_, mlrtauserd1_.`field_name` as field_na1_18_0_, mlrtauserd1_.`userdb_id` as userdb_i2_18_0_, mlrtauserd1_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd1_.`is_behavioural` as is_behav4_18_0_, mlrtauserd1_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB` mlrtauserd0_ left outer join `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd1_ on mlrtauserd0_.`USERDB_ID`=mlrtauserd1_.userdb_id where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* load com.at.persistence.model.customer.MlrTaUserdb */ select mlrtauserd0_.`USERDB_ID` as USERDB_I1_19_0_, mlrtauserd0_.`CHARSET` as CHARSET2_19_0_, mlrtauserd0_.`DB_CONNECTION_TYPE` as DB_CONNE3_19_0_, mlrtauserd0_.`DB_HOST` as DB_HOST4_19_0_, mlrtauserd0_.`DB_NAME` as DB_NAME5_19_0_, mlrtauserd0_.`DB_PASSWORD` as DB_PASSW6_19_0_, mlrtauserd0_.`DB_TYPE` as DB_TYPE7_19_0_, mlrtauserd0_.`DB_USER` as DB_USER8_19_0_, mlrtauserd0_.`DEFAULT_JOIN_TABLES` as DEFAULT_9_19_0_, mlrtauserd0_.`DEFAULT_QUALIFIER` as DEFAULT10_19_0_, mlrtauserd0_.`DESCRIPTION` as DESCRIP11_19_0_, mlrtauserd0_.`EMAIL_FIELD` as EMAIL_F12_19_0_, mlrtauserd0_.`FAX_FIELD` as FAX_FIE13_19_0_, mlrtauserd0_.`FILTER_FIELDS` as FILTER_14_19_0_, mlrtauserd0_.`HIDDEN` as HIDDEN15_19_0_, mlrtauserd0_.`JOIN_TABLES` as JOIN_TA16_19_0_, mlrtauserd0_.`LOCKED` as LOCKED17_19_0_, mlrtauserd0_.`MONITORING` as MONITOR18_19_0_, mlrtauserd0_.`NAME` as NAME19_19_0_, mlrtauserd0_.`PHONE_FIELD` as PHONE_F20_19_0_, mlrtauserd0_.`PRIMARY_KEY_FIELD` as PRIMARY21_19_0_, mlrtauserd0_.`PUSH_FIELD` as PUSH_FI22_19_0_, mlrtauserd0_.`QUALIFIER` as QUALIFI23_19_0_, mlrtauserd0_.`READONLY` as READONL24_19_0_, mlrtauserd0_.`TABLE_NAME` as TABLE_N25_19_0_, mlrtauserd0_.`TYPE_STRUCT` as TYPE_ST26_19_0_, mlrtauserd0_.`USABLE_FIELDS` as USABLE_27_19_0_, mlrtauserd0_.`VERSION_BY` as VERSION28_19_0_, mlrtauserd0_.`VERSION_DATE` as VERSION29_19_0_ from `MLR_TA_USERDB` mlrtauserd0_ where mlrtauserd0_.`USERDB_ID`=6394" // + "SHOW WARNINGS" // + "/* load one-to-many com.at.persistence.model.customer.MlrTaUserdb.mlrTaUserdbFieldMetadatas */ select mlrtauserd0_.userdb_id as userdb_i2_19_1_, mlrtauserd0_.`field_name` as field_na1_18_1_, mlrtauserd0_.`userdb_id` as userdb_i2_18_1_, mlrtauserd0_.`field_name` as field_na1_18_0_, mlrtauserd0_.`userdb_id` as userdb_i2_18_0_, mlrtauserd0_.`id_metadata_field_type` as id_metad3_18_0_, mlrtauserd0_.`is_behavioural` as is_behav4_18_0_, mlrtauserd0_.`is_behavioural_enabled` as is_behav5_18_0_ from `MLR_TA_USERDB_FIELD_METADATA` mlrtauserd0_ where mlrtauserd0_.userdb_id=6394" // + "SHOW WARNINGS" // + "/* update com.at.persistence.model.customer.MlrTaUserdb */ update `MLR_TA_USERDB` set `CHARSET`=_binary'UTF-8', `DB_CONNECTION_TYPE`=3, `DB_HOST`=_binary'172.16.8.75', `DB_NAME`=null, `DB_PASSWORD`=_binary'tETC6laeO0', `DB_TYPE`=0, `DB_USER`=_binary'C3000116', `DEFAULT_JOIN_TABLES`=null, `DEFAULT_QUALIFIER`=null, `DESCRIPTION`=null, `EMAIL_FIELD`=null, `FAX_FIELD`=null, `FILTER_FIELDS`=null, `HIDDEN`=0, `JOIN_TABLES`=null, `LOCKED`=0, `MONITORING`=0, `NAME`=null, `PHONE_FIELD`=null, `PRIMARY_KEY_FIELD`=_binary'PK_ID', `PUSH_FIELD`=_binary'PUSH_KEY', `QUALIFIER`=null, `READONLY`=0, `TABLE_NAME`=_binary'DB_6394', `TYPE_STRUCT`=0, `USABLE_FIELDS`=_binary'PUSH_ENDPOINT_TYPE,Field_2,push_endpoint_field,Field_4', `VERSION_BY`=3000116, `VERSION_DATE`='2015-01-20 10:32:33' where `USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "/* update com.at.persistence.model.customer.MlrTaUserdb */ update `MLR_TA_USERDB` set `CHARSET`=_binary'UTF-8', `DB_CONNECTION_TYPE`=3, `DB_HOST`=_binary'172.16.8.75', `DB_NAME`=null, `DB_PASSWORD`=_binary'tETC6laeO0', `DB_TYPE`=0, `DB_USER`=_binary'C3000116', `DEFAULT_JOIN_TABLES`=null, `DEFAULT_QUALIFIER`=null, `DESCRIPTION`=null, `EMAIL_FIELD`=null, `FAX_FIELD`=null, `FILTER_FIELDS`=null, `HIDDEN`=0, `JOIN_TABLES`=null, `LOCKED`=0, `MONITORING`=0, `NAME`=null, `PHONE_FIELD`=null, `PRIMARY_KEY_FIELD`=_binary'PK_ID', `PUSH_FIELD`=_binary'PUSH_KEY', `QUALIFIER`=null, `READONLY`=0, `TABLE_NAME`=_binary'DB_6394', `TYPE_STRUCT`=0, `USABLE_FIELDS`=_binary'PUSH_ENDPOINT_TYPE,Field_2,push_endpoint_field,Field_4', `VERSION_BY`=3000116, `VERSION_DATE`='2015-01-20 10:32:33' where `USERDB_ID`=6394" // + "SHOW WARNINGS" // + "/* delete com.at.persistence.model.customer.MlrTaUserdb */ delete from `MLR_TA_USERDB` where `USERDB_ID`=6394" // + "SHOW WARNINGS" // + "USE clabanchor" // + "USE C3000116" // + "DROP TABLE C3000116.DB_6394" // + "USE clabanchor"; @Test public void test5143() throws Exception { final String realPath = getRealPathOfResource("5143"); final String escapeJava = StringEscapeUtils.escapeJava(result5143); for (String sts : new ConnectionScanner(realPath).buildStatemens()) { assertThat(sts, escapeJava, containsString(sts)); } } // @Test // public void test4320() throws Exception { // final String realPath = getRealPathOfResource("4320"); // final String escapeJava = StringEscapeUtils.escapeJava(result4320); // // for (String sts : new ConnectionScanner(realPath).buildStatemens()) { // assertThat(escapeJava, containsString(sts)); // } // } @Test public void testAHEAD_ROWS() throws Exception { final String realPath = getRealPathOfResource("AHEAD_ROWS"); final List<String> buildStatemens = new ConnectionScanner(realPath).buildStatemens(); assertThat(buildStatemens.size(), is(3)); final String escapeJava = StringEscapeUtils.escapeJava(resultAHEAD_ROWS); for (String sts : buildStatemens) { assertThat(escapeJava, containsString(sts)); } } /* NO TEST METHOD UNDER */ public static String getRealPathOfResource(String resourceName) throws IOException { final ClassLoader loader = Thread.currentThread().getContextClassLoader(); final Enumeration<URL> resources = loader.getResources(resourceName); final String path = resources.nextElement().toString(); final String replace = StringUtils.replace(path, "target/test-classes", "src/test/resources"); return StringUtils.substringAfter(replace, "file:"); } }