Open a connection to MySQL/MariaDB database with direct connector. Create a table through GUI and name the table with spaces, for example "My new Table". Table will be created without any problems. Now try to delete the table through GUI. Impossible to delete the table through GUI. Seems GUI won't mask the table name when trying to drop the table. Same with JDBC connection works well. Same through Tools → SQL will work also (DROP TABLE "My new Table"). This bug appears in all LO-versions with direct driver here. So seems it never worked. By the way: Trying to delete the table through GUI in LO 24.8.0.2 leads to crash from whole LO…
On pc Debian x86-64 with master sources updated today, I don't have a crash but an error. But there's definitely something wrong here.
I gave a try with https://gerrit.libreoffice.org/c/core/+/171457
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/bf2c4cead1980c2e36fa9d51b704d2753e517edf tdf#162339: MariaDB: Table with spaces in table name couldn't be deleted by GUI It will be available in 25.2.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.
Robert: before I cherry-pick this for 24.8, I'd be interested in having some feedback from you (for example, if you still have a crash, if it works...)
I didn't used this option along time ago
Tested again with Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ec5235ddfd62ca490d13fbc2c91e740a44f9950e CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded (2024-08-06) Works well now, no crash here. Thanks Julien!
Thank you Robert for the feedback. Cherry-pick for 24.8 branch waiting for review here: https://gerrit.libreoffice.org/c/core/+/171528
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/core/commit/1d4a961389c31480b85f451b836481965698134c tdf#162339: MariaDB: Table with spaces in table name couldn't be deleted by GUI It will be available in 24.8.1. 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.