-- [umshastr@hod03]~/bugs: cat Bug88105.java import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.sql.PreparedStatement; import java.lang.String; import java.util.*; import java.io.*; import java.sql.SQLException; public class Bug88105 { public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { Properties props = new Properties(); props.setProperty("user", "root"); props.setProperty("password", ""); props.setProperty("rewriteBatchedStatements", "true"); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test",props); conn.setAutoCommit(false); PreparedStatement stmt = conn.prepareStatement("INSERT INTO NORMAL_TABLE (COL) VALUES (?)"); for (int i = 0; i < 10; i++) { stmt.setString(1, "" + i); stmt.addBatch(); } stmt.executeBatch(); conn.commit(); stmt = conn.prepareStatement("INSERT INTO TABLE_WITH_SELECT (COL) VALUES (?)"); for (int i = 0; i < 10; i++) { stmt.setString(1, "" + i); stmt.addBatch(); } stmt.executeBatch(); conn.commit(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } [umshastr@hod03]~/bugs: javac -cp '.:mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar' Bug88105.java [umshastr@hod03]~/bugs: java -cp '.:mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar' Bug88105 Mon Oct 16 07:50:35 CEST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. -- change TABLE_WITH_SELECT to `TABLE_WITH_SELECT` [umshastr@hod03]~/bugs: vi Bug88105.java [umshastr@hod03]~/bugs: javac -cp '.:mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar' Bug88105.java [umshastr@hod03]~/bugs: java -cp '.:mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar' Bug88105 Mon Oct 16 07:53:11 CEST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. [umshastr@hod03]~/bugs: ## extract from general log [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: cat 88105/hod03.log bin/mysqld, Version: 5.7.19-log (MySQL Community Server (GPL)). started with: Tcp port: 3306 Unix socket: /tmp/mysql_ushastry.sock Time Id Command Argument 2017-10-16T05:50:35.957901Z 4 Connect root@localhost on test using TCP/IP 2017-10-16T05:50:35.962925Z 4 Query /* mysql-connector-java-5.1.44 ( Revision: b3cda4f864902ffdde495b9df93937c3e20009be ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout 2017-10-16T05:50:35.987119Z 4 Query SET NAMES latin1 2017-10-16T05:50:35.987313Z 4 Query SET character_set_results = NULL 2017-10-16T05:50:35.987734Z 4 Query SET autocommit=1 2017-10-16T05:50:35.989019Z 4 Query SET autocommit=0 2017-10-16T05:50:36.005784Z 4 Query select @@session.tx_read_only 2017-10-16T05:50:36.006846Z 4 Query INSERT INTO NORMAL_TABLE (COL) VALUES ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9') 2017-10-16T05:50:36.014094Z 4 Query commit 2017-10-16T05:50:36.015423Z 4 Query select @@session.tx_read_only 2017-10-16T05:50:36.018430Z 4 Query select @@session.tx_read_only 2017-10-16T05:50:36.018667Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('0'); 2017-10-16T05:50:36.018960Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('1'); 2017-10-16T05:50:36.019048Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('2'); 2017-10-16T05:50:36.019138Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('3'); 2017-10-16T05:50:36.019229Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('4'); 2017-10-16T05:50:36.019306Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('5'); 2017-10-16T05:50:36.019394Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('6'); 2017-10-16T05:50:36.019470Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('7'); 2017-10-16T05:50:36.019555Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('8'); 2017-10-16T05:50:36.019634Z 4 Query INSERT INTO TABLE_WITH_SELECT (COL) VALUES ('9') 2017-10-16T05:50:36.064481Z 4 Query commit 2017-10-16T05:50:36.065056Z 4 Query rollback 2017-10-16T05:50:36.065223Z 4 Quit 2017-10-16T05:50:43.895918Z 3 Quit 2017-10-16T05:52:39.097943Z 5 Connect root@localhost on using Socket 2017-10-16T05:52:39.098105Z 5 Query select @@version_comment limit 1 2017-10-16T05:52:39.181615Z 5 Query select USER() 2017-10-16T05:52:41.214796Z 5 Query SELECT DATABASE() 2017-10-16T05:52:41.214882Z 5 Init DB test 2017-10-16T05:52:44.170527Z 5 Query show tables 2017-10-16T05:52:50.245188Z 5 Query truncate table NORMAL_TABLE 2017-10-16T05:52:56.989033Z 5 Query truncate table TABLE_WITH_SELECT 2017-10-16T05:53:12.016131Z 6 Connect root@localhost on test using TCP/IP -- embeded table name in backticks 2017-10-16T05:53:12.021153Z 6 Query /* mysql-connector-java-5.1.44 ( Revision: b3cda4f864902ffdde495b9df93937c3e20009be ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout 2017-10-16T05:53:12.044971Z 6 Query SET NAMES latin1 2017-10-16T05:53:12.045174Z 6 Query SET character_set_results = NULL 2017-10-16T05:53:12.045599Z 6 Query SET autocommit=1 2017-10-16T05:53:12.046877Z 6 Query SET autocommit=0 2017-10-16T05:53:12.059873Z 6 Query select @@session.tx_read_only 2017-10-16T05:53:12.060919Z 6 Query INSERT INTO NORMAL_TABLE (COL) VALUES ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9') 2017-10-16T05:53:12.061442Z 6 Query commit 2017-10-16T05:53:12.062963Z 6 Query select @@session.tx_read_only 2017-10-16T05:53:12.063313Z 6 Query INSERT INTO `TABLE_WITH_SELECT` (COL) VALUES ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9') 2017-10-16T05:53:12.063666Z 6 Query commit 2017-10-16T05:53:12.064240Z 6 Query rollback 2017-10-16T05:53:12.064421Z 6 Quit 2017-10-16T05:53:17.083337Z 5 Quit [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: