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 589822 - MetaStore: Table-only update fails after adding field to table with capital letters
MetaStore: Table-only update fails after adding field to table with capital l...
Status: RESOLVED FIXED
Product: libgda
Classification: Other
Component: Client library
4.1.x
Other Linux
: Normal normal
: ---
Assigned To: malerba
gnome-db Maintainers
Depends on:
Blocks: 587051 589102
 
 
Reported: 2009-07-26 22:46 UTC by Murray Cumming
Modified: 2009-08-25 12:55 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
gda_capital_fields_meta_update_fails.c (4.71 KB, text/x-csrc)
2009-07-26 22:47 UTC, Murray Cumming 		Details

Description Murray Cumming 2009-07-26 22:46:21 UTC 
This test case shows that gda_connection_update_meta_store() fails, when specifying that only the meta data for a specific table should be updated, after adding a field to that table, if the table has a name such as "CapitalTest".

These warnings are printed on the terminal:
SUGGEST META UPDATE Returned FALSE: constraint failed
SUGGEST META UPDATE Returned FALSE: constraint failed

And a GdaServerOperationError GError is returned, with the message "constraint failed".

This is with PostgreSQL. SQLite does not seem to have this problem.
Comment 1 Murray Cumming 2009-07-26 22:47:23 UTC 
Created attachment 139256 [details]
gda_capital_fields_meta_update_fails.c
Comment 2 Murray Cumming 2009-07-26 22:55:42 UTC 
(In reply to comment #0)
> And a GdaServerOperationError GError is returned, with the message "constraint
> failed".

I mean, a GdaServerProviderError.
Comment 3 Murray Cumming 2009-08-19 20:43:44 UTC 
Vivien, do you have any idea what might be causing this? I'd have to do a full (slow) metastore update in Glom to workaround this bug.
Comment 4 malerba 2009-08-24 09:48:08 UTC 
Have you checked with the latest master and/or LIBGDA_4.0 branches? It works for me here.
Comment 5 Murray Cumming 2009-08-25 12:55:18 UTC 
Yes, that test case seems to work now (tested with master). Thanks.

I now have some other new meta store update problems in Glom instead, but I'll investigate that separately.