GEN_ID in select can not take aliased field name - Token unknown - line 4, column 13 ------------------------------------------------------------------------------------
Key: CORE-5767 URL: http://tracker.firebirdsql.org/browse/CORE-5767 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.3, 3.0.4 Reporter: Karol Bieniaszewski SELECT r.RDB$GENERATOR_NAME, r.RDB$GENERATOR_ID, r.RDB$SYSTEM_FLAG, r.RDB$DESCRIPTION, r.RDB$SECURITY_CLASS, r.RDB$OWNER_NAME, r.RDB$INITIAL_VALUE, r.RDB$GENERATOR_INCREMENT, GEN_ID(r.RDB$GENERATOR_NAME, 0) AS V FROM RDB$GENERATORS r cause "Token unknown - line 4, column 13" but without "r." alias GEN_ID(RDB$GENERATOR_NAME, 0) AS V it is working -- 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 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel