[adminer-tracker] [ adminer-Bugs and Features-2856291 ] wrong sql while changing table column: int->datetime

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

Bugs and Features item #2856291, was opened at 2009-09-10 20:51
Message generated for change (Tracker Item Submitted) made by asdfasdf4
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2856291&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: Adminer
Group: 2.0.0
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: asdf asdf (asdfasdf4)
Assigned to: Jakub Vrána (jakubvrana)
Summary: wrong sql while changing table column: int->datetime

Initial Comment:
Hi, when i change table column (name=tries) from int(3) default '0' into datetime column(lastloginfail) Adminer generates wrong sql: ... CHANGE `tries` `lastloginfail` datetime NULL DEFAULT '0' COMMENT '' AFTER `lastlogin`,

SQLs to reproduce this scenario:

CREATE TABLE `test` (
  `tries` int(3) NOT NULL COMMENT ''
)  AUTO_INCREMENT=0 COMMENT='';


ALTER TABLE `test`
ALTER `tries` SET DEFAULT '0';

ALTER TABLE `test`
CHANGE `tries` `lastlogin` datetime NOT NULL DEFAULT '0' COMMENT '' FIRST,
RENAME TO `test`,
ENGINE='MyISAM' COLLATE 'latin1_swedish_ci' AUTO_INCREMENT=0 COMMENT='';

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

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