[Libreoffice-bugs] [Bug 116253] With MariaDB JDBC connection & Filter property set, an empty Combo Box shows 'NULL' when record inserted

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #18 from Howard Johnson <webmaster at OutWestClassifieds.org> ---
Created attachment 143735
  --> https://bugs.documentfoundation.org/attachment.cgi?id=143735&action=edit
New NullBug test: SQL to create new test database and table

Overview of basic things necessary to demonstrate this bug:

1) MySQL data connection, via MariaDB (Not Oracle's MySQL).  (HSQLDB seems to
be immune from this.)

2) A table control.

3) The table control's Form properties, Data tab, 'Filter' set, 
      e.g. (`Value` = 1)


============================================================
Steps to reproduce this bug:

1) Create a test database and table in a MariaDB 10.2 server using the
following SQL:

-----------------------------------------------------
DROP DATABASE IF EXISTS `NullBug`;
CREATE DATABASE IF NOT EXISTS `NullBug`;
USE `NullBug`;

DROP TABLE IF EXISTS `NullBug`;
CREATE TABLE IF NOT EXISTS `NullBug` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Value` int(11) DEFAULT NULL,
  `Text` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `Account ID` (`Value`),
  KEY `To` (`Text`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-----------------------------------------------------


2) Download and run the NullBug.odb.

3) Open the form.

4) Under 'Value' enter the number 5 and then hit the down arrow (to insert the
record).


Expected result:  the box under 'Text' should remain empty.

Buggy result:  the box under 'Text' gets the text 'NULL' entered in it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180724/ef15f84e/attachment.html>