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

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: 19/Jan/16 06:05 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

Issue Links:

QA Status: Done successfully

 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
 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   Change History   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