[ adminer-Bugs and Features-2935496 ] chyba při změně typu sloupce z timestamp na datetime

[SourceForge.net <no...@so...>]

Bugs and Features item #2935496, was opened at 2010-01-20 10:08
Message generated for change (Tracker Item Submitted) made by paranoiq
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2935496&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Vlasta Neubauer (paranoiq)
Assigned to: Nobody/Anonymous (nobody)
Summary: chyba při změně typu sloupce z timestamp na datetime

Initial Comment:
při změně typu sloupce z timestamp na datetime se chybně předává defaultní hodnota:

ALTER TABLE `test`
CHANGE `ts` `ts` datetime NOT NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '' AFTER `trans`,
RENAME TO `test`,
COMMENT=''

a výsledkem je hláška "Invalid default value for ..."

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2935496&group_id=264133