string_to_date and NULL gives stackoverflow error
Posted by: Harpreet Sohal
Date: June 02, 2014 12:47PM

Select CASE WHEN length(testDt) > 0 THEN STR_TO_DATE(testDt, '%Y-%m-%d') ELSE NULL END as testDt from tablename

fails with java.lang.StackOverflowError on mysql version 5.5.34 when accessed through jdbc. MySQL version 5.6 works fine through jdbc

Replacing NULL with empty strings ' ' works Select CASE WHEN length(testDt) > 0 THEN STR_TO_DATE(testDt, '%Y-%m-%d') ELSE NULL END as testDt from tablename


Are there any jdbc setting changed in version MySQL 5.6 or can I change any JDBC setting in 5.5.34 so that this can works as is.

Options: ReplyQuote


Subject
Written By
Posted
string_to_date and NULL gives stackoverflow error
June 02, 2014 12:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.