Subject | Firebird 2.0 Bug? |
---|---|
Author | fabianchocron |
Post date | 2006-11-21T03:38:23Z |
Hi All,
I have a view working fine since v1.5, I upgraded to 2.0, and I
cannot "see" some fields from the view, the fields are there, but
they are "blank", like the DB is "hidding" them.
The view is:
CREATE VIEW V_ALL_VIEWS(
VIEW_NAME,
FIELD_POSITION,
FIELD_NAME,
FIELD_TYPE,
FIELD_SIZE)
AS
SELECT T1.RDB$RELATION_NAME,
T1.RDB$FIELD_POSITION ,
T1.RDB$FIELD_NAME ,
T3.RDB$TYPE_NAME ,
T2.RDB$FIELD_LENGTH
FROM RDB$RELATION_FIELDS T1
JOIN RDB$FIELDS T2 ON (T2.RDB$FIELD_NAME =
T1.RDB$FIELD_SOURCE)
JOIN RDB$TYPES T3 ON (T3.RDB$TYPE =
T2.RDB$FIELD_TYPE
AND T3.RDB$FIELD_NAME
= 'RDB$FIELD_TYPE')
WHERE T1.RDB$RELATION_NAME LIKE 'V_%'
;
I have a view working fine since v1.5, I upgraded to 2.0, and I
cannot "see" some fields from the view, the fields are there, but
they are "blank", like the DB is "hidding" them.
The view is:
CREATE VIEW V_ALL_VIEWS(
VIEW_NAME,
FIELD_POSITION,
FIELD_NAME,
FIELD_TYPE,
FIELD_SIZE)
AS
SELECT T1.RDB$RELATION_NAME,
T1.RDB$FIELD_POSITION ,
T1.RDB$FIELD_NAME ,
T3.RDB$TYPE_NAME ,
T2.RDB$FIELD_LENGTH
FROM RDB$RELATION_FIELDS T1
JOIN RDB$FIELDS T2 ON (T2.RDB$FIELD_NAME =
T1.RDB$FIELD_SOURCE)
JOIN RDB$TYPES T3 ON (T3.RDB$TYPE =
T2.RDB$FIELD_TYPE
AND T3.RDB$FIELD_NAME
= 'RDB$FIELD_TYPE')
WHERE T1.RDB$RELATION_NAME LIKE 'V_%'
;