GNOME Bugzilla – Bug 763534
Glom won't open a database if a table contains spaces
Last modified: 2016-09-29 09:46:52 UTC
If a user create a table with spaces in its name, Glom won't be able to open it at the next launch. Here is the error message: (<unknown>:13928): GLib-GIO-ERROR **: g_menu_item_set_detailed_action: Detailed action name 'tables-list.Test Test Test' has invalid format Trace/BPT trap: 5 Maybe it would force the user not using spaces in the tables names by replacing them with _ Anyhow, it's not really recommended to use spaces in names.
Thanks. This is partly fixed by this: https://git.gnome.org/browse/glom/commit/?id=81098c767894a4e63f27d26414e868c9312d0157
However, the SQL command then fails, which really shouldn't be happening with GdaSqlBuilder, at this point: (gdb) bt
+ Trace 236072
With this output: Glib::RefPtr<Gnome::Gda::DataModel> Glom::DbUtils::query_execute_select(const Glib::RefPtr<const Gnome::Gda::SqlBuilder>&, bool): code=SERVER_PROVIDER_STATEMENT_EXEC_ERROR, message=syntax error at or near "with space" LINE 1: SELECT COUNT (*) FROM (SELECT with space.with space_id FROM ... ^ Glib::RefPtr<Gnome::Gda::DataModel> Glom::DbUtils::query_execute_select(const Glib::RefPtr<const Gnome::Gda::SqlBuilder>&, bool): Error while executing SQL: SELECT COUNT (*) FROM (SELECT with space.with space_id FROM with space) AS "glomarbitraryalias" static bool Glom::ConnectionPool::handle_error_cerr_only(): Internal error (Database): syntax error at or near "with space" LINE 1: SELECT COUNT (*) FROM (SELECT with space.with space_id FROM ... ^
For now, I have added a check in the UI for this: https://git.gnome.org/browse/glom/commit/?id=7b2163c301575a5a6e5d921f07c5d9a648906f1b I would prefer that this was just possible with libgda.