https://bugs.documentfoundation.org/show_bug.cgi?id=116253
--- Comment #18 from Howard Johnson <webmas...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs