string_to_date and NULL gives stackoverflow error
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.
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.