Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bit fields are showing wrong value #2307

Closed
nikomakela opened this issue Oct 26, 2015 · 1 comment
Closed

Bit fields are showing wrong value #2307

nikomakela opened this issue Oct 26, 2015 · 1 comment

Comments

@nikomakela
Copy link

Bit fields are showing wrong value. I got a bit field (size 1) like is_enabled or password_expired in sec_user table. For example, I'm sure all the users are enabled (value should be 1), but UI shows that almost every another row is disabled (value is 00000000). The very same fields works well with Sequel Pro version 1.0.2. See the screenshots below.

Table is created with following SQL:

CREATE TABLE `sec_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `account_expired` bit(1) NOT NULL,
  `account_locked` bit(1) NOT NULL,
  `enabled` bit(1) NOT NULL,
  `password` varchar(255) COLLATE utf8_bin NOT NULL,
  `password_expired` bit(1) NOT NULL,
  `username` varchar(255) COLLATE utf8_bin NOT NULL,
  `class` varchar(255) COLLATE utf8_bin NOT NULL,
  `email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `firstname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `last_logged_in_date` datetime DEFAULT NULL,
  `locale` varchar(5) COLLATE utf8_bin DEFAULT NULL,
  `logged_in_from` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `online` bit(1) DEFAULT NULL,
  `password_expiry_date` datetime DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `registration_completed` bit(1) DEFAULT NULL,
  `surname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `sv_number` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username_uniq_1427272446531` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Screenshot of sec_user table with Sequel Pro 1.0.2:
screen shot 2015-10-26 at 10 00 35

Screenshot of sec_user table with Sequel Pro 1.1:
screen shot 2015-10-26 at 10 02 11

@dmoagx
Copy link
Member

dmoagx commented Oct 26, 2015

Duplicate of #2254

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants