After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 763596 - GdaSqlBuilder: Table names not quoted
GdaSqlBuilder: Table names not quoted
Status: RESOLVED OBSOLETE
Product: libgda
Classification: Other
Component: general
unspecified
Other Linux
: Normal normal
: ---
Assigned To: malerba
gnome-db Maintainers
Depends on:
Blocks: 763534
 
 
Reported: 2016-03-14 07:06 UTC by Murray Cumming
Modified: 2018-09-21 13:50 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
test_libgda_table_name_with_space.c (1.44 KB, text/x-csrc)
2016-03-14 07:06 UTC, Murray Cumming 		Details

Description Murray Cumming 2016-03-14 07:06:00 UTC 
Created attachment 323840 [details]
test_libgda_table_name_with_space.c

At least with PostgreSQL, GdaSQLBuilder doesn't seem to quote table names, leading to errors if the table names have spaces, for instance.

Running this test shows this error:

** (process:12975): WARNING **: gda_connection_statement_execute_select() failed: syntax error at or near "with space"
LINE 1: ...tists"."artist_id", "artists"."description" FROM with space
Comment 1 Murray Cumming 2016-03-18 21:50:08 UTC 
This doesn't seem to be specific to the PostgreSQL provider. It happens with the SQLite provider too.
Comment 2 GNOME Infrastructure Team 2018-09-21 13:50:55 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/libgda/issues/87.