On 21/03/2014 06:00, Pavel Zotov (JIRA) wrote: > Provide name of TABLE / VIEW when some statement violates CHECK. > ---------------------------------------------------------------- > > Key: CORE-4368 > URL: http://tracker.firebirdsql.org/browse/CORE-4368 > Project: Firebird Core > Issue Type: Improvement > Components: Engine > Reporter: Pavel Zotov > > > A message like this: > ----- > The insert failed because a column definition includes validation constraints. > validation error for column ID, value "*** null ***". > At procedure 'SP_RESERVE_WRITE_OFF' line: 131, col: 8. > ----- > > - does not says what table owns this column. > It will be useful to output such info (especially when there is no access to > source code of stored procedure). > Do you think it's ok to output "validation error for column TABLE.ID"?
It's certainly ambiguous if one defines tables and columns names with double quotes and dots. But this is already used for PACKAGE.NAME. Certainly, the best approach was if any non-simple names was output using double quotes, example: "TABLE.X"."COLUMN.Y", but this was never done and would change error messages from the way it is currently. Adriano ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
