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