https://bugs.freedesktop.org/show_bug.cgi?id=88631

            Bug ID: 88631
           Summary: EDITING - mysql(jdbc) tinyint(1) fields display as
                    Boolean tickboxes in table view mode
           Product: LibreOffice
           Version: 4.3.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: critical
          Priority: medium
         Component: Database
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 112557
  --> https://bugs.freedesktop.org/attachment.cgi?id=112557&action=edit
test dump file

See bug 88601, comment 2, and comment 3

1) Using mysql-connector-java-5.1.21 JDBC connector
2) Create a test table from mysql cli :

 CREATE TABLE `Table1` (
  `Field1` tinyint(1) unsigned NOT NULL,
  `Field2` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Field2`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1


3) Add the following data :

+--------+--------+
| Field1 | Field2 |
+--------+--------+
|    244 |      1 |
|    255 |      2 |
|    213 |      3 |
|    128 |      4 |
|      1 |      5 |
|      2 |      6 |
|      4 |      7 |
|      5 |      8 |
|    255 |      9 |


Have enclosed dump file

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to