Issue Details (XML | Word | Printable)

Key: CORE-1841
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

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

If some VIEW used derived tables and long table names\aliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME

Created: 17/Apr/08 04:57 AM   Updated: 26/Jan/09 08:27 AM
Component/s: Engine
Affects Version/s: 2.0.0, 2.0.1, 2.1 Alpha 1, 2.1 Beta 1, 2.0.2, 2.0.3, 2.1 Beta 2, 2.1 RC1, 2.5 Initial, 2.1 RC2
Fix Version/s: 2.5 Alpha 1, 2.1.1, 2.0.5

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
In RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME stored full table alias - concatenation of all outer derived table's names and this table name.
As RDB$CONTEXT_NAME declared as CHAR(31) it is very easy to oferflow it.
In this case such VIEW can't be created.

Example :

create view x (id) as
select RDB$RELATION_ID
 from (select * from RDB$DATABASE long_alias_long_alias_1) long_alias_long_alias_2

This operation is not defined for system tables.
unsuccessful metadata update.
Name longer than database column size.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 08/Dec/08 09:08 AM
Q/A test ok