[CWB] [ cwb-Bugs-2959470 ] CQPweb: text_metadata_for_* text_id field should be verified

[SourceForge.net]

Bugs item #2959470, was opened at 2010-02-26 07:27
Message generated for change (Tracker Item Submitted) made by andrewhardie
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=722303&aid=2959470&group_id=131809

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: CQPweb
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Andrew Hardie (andrewhardie)
Assigned to: Andrew Hardie (andrewhardie)
Summary: CQPweb: text_metadata_for_* text_id field should be verified

Initial Comment:
It is currently possible to insert text metadata with non-unique text_ids, which will create interesting errors. Solution:

* Add a UNIQUE constraint on the appropriate mysql table
* make sure an error message explaining what the problem is gets printed.

Similarly, it is possible for text_ids which are not valid C identifiers to be loaded into the table, but this will naturally cause problems later with all the code that assumes text_ids are valid C identifiers. So check this and write code to fall over gracefully.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=722303&aid=2959470&group_id=131809