Bug #22703 Critical error when data contains Single unterminated left curly bracket
Submitted: 26 Sep 2006 15:51 Modified: 29 Jan 2007 11:12
Reporter: Thomas Norlund Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S1 (Critical)
Version:all OS:Any (all)
Assigned to: Assigned Account CPU Architecture:Any

[26 Sep 2006 15:51] Thomas Norlund 
Description:
When the source-data contains a single "{"-character the error "not a valid escape sequence" is produced in the migration log and worse following datasets are ignored in the migration.

How to repeat:
Enter a singe "{" in a field in your source-database.
Try to do migration.
[26 Sep 2006 16:34] Thomas Norlund 
The bug has probably connection to curly brackets being interpreted to start a escape sequence by JDBC.
[26 Sep 2006 17:01] Michael G. Zinner 
Could you please state which source database vendor you used and which JDBC driver? I tried to repeat the behviour with an MS Access database and a MySQL 4.0 database migrating to MySQL 5.0 but could not reproduce the described behaviour. Thanks1
[27 Sep 2006 10:53] Thomas Norlund 
It was from a SQL Server 2000 to MySQL 5.0 using jre 1.5.0_06.
[27 Sep 2006 11:11] Thomas Norlund 
Concerning JDBC version I assume that it is version 3.1.11 (the one in the lib path of the migration toolkit)
[12 Oct 2006 19:39] Sveta Smirnova 
Could you please provide JDBC connection string you use?
[13 Nov 2006 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[29 Dec 2006 11:12] Sveta Smirnova 
Please try with current 1.1.8 version
[30 Jan 2007 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".