https://bugs.documentfoundation.org/show_bug.cgi?id=88601

--- Comment #13 from tmonk <[email protected]> ---
Since this post is reported in 2015-Jan,
I wonder how is the test result in latest environment.

Test Environment:
OS: Ubuntu 16.04 LTS

libreoffice 5.4.6.2 (2018-05-15)
Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8

mysql Distrib 5.7.22 (2018-01-15 General Availability)

mysql-connector-java-8.0.11.jar (2018-04-18)

Test Table:

CREATE TABLE Table1 (
Field1 tinyint unsigned NOT NULL,
PRIMARY KEY (Field1) )

Detail:
Insert row from LO-base.  No problem with value from 0 to 255.
If I trying to insert value outside of 0 to 255.
L0-base will block you with error message.

But if I trying to reopen this table when there is a row with value from 128 to
255, the table will fail to load with the following error message :
" The data content could not be loaded.
'234' in column '1' is outside valid range for the datatype TINYINT."

This only happened when this column is set as UNSINGED and PRIMARY KEY.

This is my very first comment in Bugzilla.
Any advice is welcome.

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

Reply via email to