[Libreoffice-bugs] [Bug 131712] New: Base EDITING Crash on SQL select command or double click on table with non null float field - mysql native connector (mariadb)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131712
           Summary: Base EDITING Crash on SQL select command or double
                    click on table with non null float field - mysql
                    native connector (mariadb)
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ps at chiltern.org.uk

Description:
I have an Libre office Base database file which connects to mariadb on remote
server using mysql (direct) connector.

Most functionality works fine, but there is one table which if I do any of the
following will crash the whole of libreoffice without any recovery facilitate
(straight to OS 'this program as crash - what would you like to do' prompt.
1) Double click on table in table list
2) Right on table and click 'open'
3) Run any SQL select query on that table

Apon reopening Libreoffice it offers you chance to restore, but if you click
start it crashes libreoffice again.

However I can do any of the above on other tables without issue. If I truncate
said table I can do any of the above with out issue. If I make the values the
two float fields 'null' for all rows, I can do any of the above without issue.

Steps to Reproduce:
1.Connect Base to remote mariadb database using mysql (direct) connector
2.create a table with integer key & a float field
3.Open this table by double click on it
4.Create a new entery by adding 1 in the int primary key field.
5.click save on both edit table window and the main database window
6.try to enter a 1 into float field for the entry you've created.

Actual Results:
The 1 is saved to the database ( which you can confirm by connecting to mariadb
via command line, but libreoffice crashes

Expected Results:
Libreoffice shouldn't crash


Reproducible: Always


User Profile Reset: No



Additional Info:
I think this is a bug in the mysql (direct) connector. 

I install Libreoffice via brew and the connector came with it, but internet
implies on some distribution is might be an extension.

I also found this which implied it has recently become part of core
libreoffice, hence why I'm posting bug here:
https://wastack.wordpress.com/2019/02/07/the-new-mysql-driver-in-libreoffice/

-- 
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/20200330/26e0d891/attachment.htm>