Usage of field's alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers ----------------------------------------------------------------------------------------------------------------
Key: CORE-4315 URL: http://tracker.firebirdsql.org/browse/CORE-4315 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 1, 2.5.2 Update 1, 3.0 Alpha 2 Reporter: Adriano dos Santos Fernandes create table t1 (n1 integer, n2 integer); -- Do not compile recreate view v1 as select t1.n1 from t1 t1 where t1.n1 < t1.n2 with check option; recreate view v1 as select t1.n1 from t1 where t1.n1 < t1.n2 with check option; recreate view v1 as select x.n1 from t1 x where x.n1 < x.n2 with check option; -- Compile but generates incorrect internal triggers recreate view v1 as select n1 a from t1 where n1 < n2 with check option; -- 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 ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel