#3678 (ok 4.0.9) Does not display or manipulate bit(64) fields appropriately

3.5.4
fixed
Marc Delisle
1
2014-02-05
2012-09-11
justin
No

I have a table containing a bit(64) field, that does not display correctly in the 3.5.2.2 version of phpMyAdmin. Previous versions (2.11.10) show the correct data in the field. In the latest version, we get a jumble of 1's and 0's, but not in the proper places. Editing the field also produces an error of "0 rows affected. "Warning: #1264 Out of range value for column 'task_type' at row 1".

PHP: PHP 5.3.2-1ubuntu4.14 with Suhosin-Patch (cli) (built: Feb 11 2012 06:35:39)
MySQL: Distrib 5.1.63, for debian-linux-gnu (x86_64) using readline 6.1
Browser: Firefox 15.0.1
OS: Ubuntu 10.04.4

Here is the text from Create Table, and the "task_type" field is the one not functioning properly:
CREATE TABLE `Task` (
`tid` int(32) unsigned NOT NULL AUTO_INCREMENT,
`requestor_type` enum('Lifecycle','LifecycleVM','Source','SourceVM','Master','External') NOT NULL DEFAULT 'External',
`requestor` int(32) unsigned NOT NULL DEFAULT '0',
`task_type` bit(64) NOT NULL,
`execute` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`recur` smallint(5) unsigned NOT NULL DEFAULT '0',
`target_id` int(32) unsigned NOT NULL DEFAULT '0',
`arg1` varchar(4096) DEFAULT NULL,
`arg2` varchar(4096) DEFAULT NULL,
`arg3` varchar(4096) DEFAULT NULL,
`arg4` varchar(4096) DEFAULT NULL,
`arg5` varchar(4096) DEFAULT NULL,
`arg6` varchar(4096) DEFAULT NULL,
`arg7` varchar(4096) DEFAULT NULL,
`arg8` varchar(4096) DEFAULT NULL,
`arg9` varchar(4096) DEFAULT NULL,
`arg10` varchar(4096) DEFAULT NULL,
`status` enum('Queued','DequeuePending','Rejected','Accepted','ExecutionPending','InProgress','Error','Complete','Cancelled') NOT NULL DEFAULT 'Queued',
`status_msg` varchar(1024) DEFAULT NULL,
`result` varchar(4096) DEFAULT NULL,
PRIMARY KEY (`tid`),
KEY `task_bm` (`task_type`),
KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=247 DEFAULT CHARSET=latin1

Discussion

  • justin
    justin
    2012-11-30

    • milestone: 3018536 --> 3.5.4
     
  • Marc Delisle
    Marc Delisle
    2013-10-08

    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2013-10-09

    • summary: Does not display or manipulate bit(64) fields appropriately --> (ok 4.0.9) Does not display or manipulate bit(64) fields appropriately
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle
    Marc Delisle
    2013-11-26

    • status: resolved --> fixed