MySQL Bugs: #66592: MySQL Migration Toolkit bug ORA-00936

Bug #66592	MySQL Migration Toolkit bug ORA-00936
Submitted:	29 Aug 2012 12:46	Modified:	29 Aug 2012 13:06
Reporter:	wei liu	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	1.1.17	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	MySQL Migration Toolkit ORA-00936

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When we use MySQL Migration Toolkit to migrate data from Oracle to MySQL, reported error 'ORA-00936 missing expression'. 
And the detail sql is 'select from table'. I think the toolkit generated a wrong SQL, the correct SQL should be 'select * from table'.

How to repeat:
Use migration toolkit migrate table(s) from Oracle10.2.0.4 to MySQL5.5.16.

Old Migration Toolkit is not supported. Please, check migration module of Workbench 5.2.42.