https://bugs.documentfoundation.org/show_bug.cgi?id=88601
Doug <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED URL| |https://mariadb.atlassian.n | |et/browse/CONJ-133 Resolution|NOTOURBUG |--- Ever confirmed|0 |1 --- Comment #8 from Doug <[email protected]> --- Cross-reported to MariaDB team which respond as follows: * * * "NOTOURBUG seems wrong. [LibreOffice] should be using the integer type, which is wide enough to incorporate 0-255. Like, short, or int, or if they wish even long. They can consult http://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html to figure out how unsigned types are mapped to correct java types. MariaDB driver uses the same type conversion as ConnectorJ " * * * I also experienced this type-conversion error on MySQL ODBC connector (in addition to the others noted earlier). The common thread is Base's handling of UNSIGNED integers from MySQL/MariaDB. I have not had the opportunity to look 'under the hood', but in the circumstances I think the MariaDB team is right that this bug should be reopened in LibreOffice Base. I am not sure the MariaDB team's solution is exactly right, as it would require there always be a Base integer variable that is larger than the MySQL integer variable-- I expect their solution will break down with an UNSIGNED BIGINT. -- 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
