
|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
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.
|
|
Description
|
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.
|
Show » |
|