• Alexander Barkov's avatar
    Part#2 for MDEV-12107 sql_mode=ORACLE: Inside routines the CALL keywoard is optional · 7ca2f816
    Alexander Barkov authored
    Allowing qualified procedure names to be used without the CALL keyword:
    
    BEGIN
      test.p1(10);
      test.p2;
    END;
    
    Note:
    - COMMIT and ROLLBACK cannot be used in a direct assignment anymore:
        COMMIT:= 10;
        ROLLBACK:= 10;
      But as they are reserved keywords in Oracle anyway, this is not a problem.
    - SHUTDOWN now also cannot be used in direct a direct assignment:
        SHUTDOWN:=10;
      If this causes migration problems in the future, the grammar should
      be modified.
    
    Note:
      Variables with names COMMIT, ROLLBACK and SHUTDOWN can still be assigned
      with the SET statement, e.g. SET COMMIT=10;
    7ca2f816
sp.result 40.4 KB