Issue Details (XML | Word | Printable)

Key: CORE-6127
Type: Improvement Improvement
Status: Open Open
Priority: Trivial Trivial
Assignee: Unassigned
Reporter: rdb_dev
Votes: 2
Watchers: 3
Operations

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

Known domains for calculating fields of view.

Created: 15/Aug/19 07:48 AM   Updated: 15/Aug/19 07:50 AM
Component/s: Engine
Affects Version/s: 3.0.4, 4.0 Beta 1, 2.5.9
Fix Version/s: None

QA Status: No test


 Description  « Hide
When you use calculated fields in a view, whether the field type is cast to a domain through the Cast function, whether it is a known domain from the result of a stored procedure or function, or simply derived dynamically from an expression, in any case, the automatically generated RDB$<number> domain is used to create the view for that field.

Please improve the functionality so that when creating a view, the domains available in the database are taken into account for the calculated fields, if, based on the expression, the domain is known (when the end result is brought to a specific domain via Cast or is a known domain from the result of a stored procedure or function), so that when creating views with such fields, the automatically created RDB$<number>domains do not multiply.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.