FOR UPDATE OF list does not work with columns qualified with a relation alias.
------------------------------------------------------------------------------
Key: CORE-3723
URL: http://tracker.firebirdsql.org/browse/CORE-3723
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 2.1.3, 2.1.2,
2.0.5, 2.1.1, 2.1.0
Environment: Any environment
Reporter: Jason Wharton
The following query fails:
SELECT R.RDB$DESCRIPTION
, R.RDB$VIEW_SOURCE
, R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
ORDER BY R.RDB$RELATION_NAME
FOR UPDATE OF R.RDB$DESCRIPTION
Here is the SQL trace from IBO when I attempted to open this query:
/*---
PREPARE STATEMENT
TR_HANDLE = 27
STMT_HANDLE = 26
SELECT R.RDB$DESCRIPTION
, R.RDB$VIEW_SOURCE
, R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
ORDER BY R.RDB$RELATION_NAME ASC
FOR UPDATE OF R.RDB$DESCRIPTION
FIELDS = [ Version 1 SQLd 3 SQLn 30
RDB$RELATIONS.RDB$DESCRIPTION = <NIL>
RDB$RELATIONS.RDB$VIEW_SOURCE = <NIL>
RDB$RELATIONS.RDB$RELATION_NAME = <NIL> ]
ERRCODE = 335544569
----*/
/*---
INTERPRET BUFFER =
ERRCODE = 17
----*/
/*---
INTERPRET BUFFER = Dynamic SQL Error
ERRCODE = 21
----*/
/*---
INTERPRET BUFFER = SQL error code = -104
ERRCODE = 33
----*/
/*---
INTERPRET BUFFER = Token unknown - line 6, column 16
ERRCODE = 1
----*/
/*---
INTERPRET BUFFER = .
ERRCODE = -1
----*/
--
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
------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
