Usage of field's alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers [CORE4315] #4638
Assignees
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 2 [ 10560 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @asfernandes
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;
Commits: fc6110d FirebirdSQL/fbt-repository@71d614e
The text was updated successfully, but these errors were encountered: