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

Lionel Elie Mamane <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTOURBUG
           Severity|enhancement                 |normal

--- Comment #7 from Lionel Elie Mamane <[email protected]> ---
Since the JDBC drivers (by necessity) shows us the datatypes as signed, I'm
going to set this as "NOTOURBUG" for the JDBC part.

The behaviour with the native driver of setting 0 seems to be the behaviour of
MySQL, since LibreOffice (as noted later in the bug) will send the value as a
negative value:

mysql> CREATE TEMPORARY TABLE F (i tinyint unsigned);
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT INTO F VALUES ((-5));
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> SELECT * FROM F;
+------+
| i    |
+------+
|    0 |
+------+
1 row in set (0.00 sec)

As such, also NOTOURBUG.

As to the behaviour of mapping negative value "v" to 256+v, that's how casting
from signed to unsigned happens in C/C++... Maybe that could be improved in
LibreOffice <shrug> You can fork it into its own bug entry if you want.

-- 
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