View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007806 | VALENTINA STUDIO | Tool - Data Editor | public | 2016-11-16 18:32 | 2016-11-17 20:47 |
| Reporter | Andrea Tasca | Assigned To | Sergey Pashkov | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | Linux 4.4.x | OS | Linux Mint 18 | OS Version | * |
| Product Version | 6.5.x | ||||
| Target Version | 6.6.x | Fixed in Version | 6.6.x | ||
| Summary | 0007806: Data editor does not display Field of type bit correctly | ||||
| Description | Product: Valentina Studio Pro 6.6.2 (64 bit) In data editor fields of type bit are not diplayed correctly | ||||
| Steps To Reproduce | Create a table using the following statements and then open the table in data editor. You can see the result in the attached image. SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` char(255) NOT NULL, `name` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `active` bit(1) NOT NULL DEFAULT b'1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('11111', 'xxx', 'xx', 'xxx', 'xxx', '', '', ''); SET FOREIGN_KEY_CHECKS=1; | ||||
| Tags | No tags attached. | ||||
| Working with DB: | mySQL Server | ||||
| Version of your DB | MySQL 5.7.16 | ||||
 |
active.png (10,425 bytes) |
 |
Thanks for reporting this issue. Fix will be available in the version 6.6.3. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-11-16 18:32 | Andrea Tasca | New Issue | |
| 2016-11-16 18:32 | Andrea Tasca | File Added: active.png | |
| 2016-11-16 19:25 | Sergey Pashkov | Assigned To | => Sergey Pashkov |
| 2016-11-16 19:25 | Sergey Pashkov | Status | new => confirmed |
| 2016-11-17 20:47 | Sergey Pashkov | Note Added: 0009346 | |
| 2016-11-17 20:47 | Sergey Pashkov | Status | confirmed => resolved |
| 2016-11-17 20:47 | Sergey Pashkov | Resolution | open => fixed |
| 2016-11-17 20:47 | Sergey Pashkov | Fixed in Version | => 6.6.x |
| 2016-11-17 20:47 | Sergey Pashkov | Target Version | => 6.6.x |
