Bug #92413 | Too Many quotes on binary field using updateRow - preparedStatement | ||
---|---|---|---|
Submitted: | 13 Sep 2018 17:30 | Modified: | 9 Oct 2018 22:34 |
Reporter: | Michael Salvagna | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | Connector / J | Severity: | S3 (Non-critical) |
Version: | 8.0.12 | OS: | Any |
Assigned to: | Filipe Silva | CPU Architecture: | Any |
Tags: | Binary updateRow quotes |
[13 Sep 2018 17:30]
Michael Salvagna
[27 Sep 2018 10:59]
Filipe Silva
Hi Michael, Thank you for your interest in Connector/J and for taking the time to report this issue. I wasn't able to reproduce this behavior. Can you please provide a simple self-contained test case we could use? Please also provide some more info about your environment that may be relevant, such as Connection string properties you may be using, mid-layer frameworks, client operating system and Java version, MySQL server version... Thanks,
[9 Oct 2018 16:05]
Michael Salvagna
We just upgraded our DB engine to MySQL 5.6.40 and the issue is gone. We were previously on MySQL 5.6.34. If anyone has this similar issue and are on MySQL 5.6.34, try upgrading to at least 5.6.40. Cheers!
[9 Oct 2018 22:34]
Filipe Silva
Hi Michael, Good to know it works for your. Thanks,
[26 Feb 2020 17:42]
Rahul Phadnis
We are still seeing this with mysql connector j version: 8.0.19. The refresher sql in UpdatableResultSet is double escaping binary data. For example: SELECT <field names> FROM <table name> WHERE uuid <=> 'x''B949BC73FF074B6299C7A42AC4F496A2''' Here uuid is BINARY(16) column. Please note that this works for version: 5.1.44