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/
Just updated to 6.4.4 and issue is as stated above
Interestingly it turns out that changing field from 'float' to 'double' resolves the issue, but not sure why.
On pc Debian x86-64 with master sources updated today, I could reproduce this.
Created attachment 159161 [details] bt with debug symbols There's a crash (infinite loop) when trying to reopen the table, I attached part of bt.
Thank you for having spotted this bug! Let's give a try with: https://gerrit.libreoffice.org/c/core/+/91379
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/192ee96db3bc3544c388034b19fa7a9cd6e7537d tdf#131712: fix crash on table with non null float field (mysql native) It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/9e72262b420bad1e54287e35463be55769063608 tdf#131712: fix crash on table with non null float field (mysql native) It will be available in 6.4.4. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/dd4fcaad466dad6e55c3b53170e82ebcc3946a96 tdf#131712: fix crash on table with non null float field (mysql native) It will be available in 6.3.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-6-4-3": https://git.libreoffice.org/core/commit/bc6f350d17b9e80e66add73fb6743b16db320b2c tdf#131712: fix crash on table with non null float field (mysql native) It will be available in 6.4.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.