Hi,
When we try to execute the sql instruction "ALTER TABLE test MODIFY id varchar(10)" we got an exception :
Exception in thread "main" java.sql.SQLException: Failed to alter table test:Failed to get a string value from com.hxtt.f.e: DATE()
at com.hxtt.b.ak.a(Unknown Source)
at com.hxtt.sql.access.m.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.by.a(Unknown Source)
at com.hxtt.sql.by.a(Unknown Source)
at com.hxtt.sql.by.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.am.if(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.am.executeUpdate(Unknown Source)
The test database :
https://penelope827-my.sharepoint.com/personal/p_gervaise_penelope_fr/_layouts/15/guestaccess.aspx?guestaccesstoken=vHoDzlPAYf%2fVTQskuE8Ueawd5aEgPjSoPHMZ1ZELG5o%3d&docid=05139c61739d243bcb099bfbfc7229480&rev=1&expiration=2017-10-10T15%3a10%3a18.000Z
It's because the table "test" got a column named "date" with a default value : Date(). It's OK for INSERT but doesn't work on ALTER.
Thank you.
|
|
Supported. Please download the latest package.
|
Main
webmaster@hxtt.com