Issue Details (XML | Word | Printable)

Key: CORE-4386
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 3
Watchers: 4

If you were logged in you would be able to see more operations.
Firebird Core

Report more details for "object in use" errors

Created: 05/Apr/14 06:04 PM   Updated: 07/Feb/20 06:39 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.1.6, 2.5.3, 3.0 Beta 2

Issue Links:

QA Status: Done successfully

 Description  « Hide
While a proper metadata naming convention surely helps, the engine could be polite enough to report not only the name of the used object but its type (table/index/procedure/etc) as well. Also, for used indices currently a string "INDEX" is reported instead of the index name.

Thinking about this more, it would be great to have an original DDL command (or at least its shorthand) reported for any DFW error happening during commit. This would radically simplify debugging of multi-command DDL scripts.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 05/Apr/14 06:12 PM
The simplest solution (e.g. "object INDEX "TEST_PK" is in use") is committed into v2.1 and v2.5, a more advanced solution is to be developed for v3.