Regression query work on FB2.5.3 but not work on FB3
----------------------------------------------------
Key: CORE-4815
URL: http://tracker.firebirdsql.org/browse/CORE-4815
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Beta 2
Reporter: Karol Bieniaszewski
Query work on FB2.5.3 but not work on current FB3 (WI-T3.0.0.31844 Firebird 3.0
Beta 2)
SQL Message : -206
Column does not belong to referenced table
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -206
Column unknown
RF.RDB$FIELD_NAME
At line 19, column 79
SELECT
(SELECT
COUNT(DISTINCT D.RDB$DEPENDENT_NAME)
FROM
RDB$DEPENDENCIES D
INNER JOIN RDB$RELATIONS R2 ON R2.RDB$RELATION_NAME =
D.RDB$DEPENDENT_NAME
WHERE
D.RDB$DEPENDED_ON_NAME = R.RDB$RELATION_NAME) AS POWIAZANYCH,
RF.*, R.RDB$EXTERNAL_FILE, R.RDB$RELATION_TYPE, R.RDB$VIEW_SOURCE, F.*,
CS.RDB$CHARACTER_SET_NAME AS CHARACTER_SET_NAME, RC.RDB$CONSTRAINT_NAME
FROM
RDB$RELATION_FIELDS RF
INNER JOIN RDB$RELATIONS R ON R.RDB$RELATION_NAME = RF.RDB$RELATION_NAME
INNER JOIN RDB$FIELDS F ON F.RDB$FIELD_NAME = RF.RDB$FIELD_SOURCE
LEFT JOIN RDB$CHARACTER_SETS CS ON CS.RDB$CHARACTER_SET_ID =
F.RDB$CHARACTER_SET_ID
LEFT JOIN (RDB$RELATION_CONSTRAINTS RC
INNER JOIN RDB$CHECK_CONSTRAINTS CC ON CC.RDB$CONSTRAINT_NAME =
RC.RDB$CONSTRAINT_NAME AND CC.RDB$TRIGGER_NAME = RF.RDB$FIELD_NAME AND
RC.RDB$CONSTRAINT_TYPE STARTING WITH 'NOT NULL') ON RC.RDB$RELATION_NAME =
RF.RDB$RELATION_NAME
WHERE
(R.RDB$SYSTEM_FLAG IS NULL OR R.RDB$SYSTEM_FLAG <> 1)
ORDER BY
R.RDB$RELATION_TYPE ASC, 1 DESC, RF.RDB$RELATION_NAME,
RF.RDB$FIELD_POSITION ASC
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
