search

Trivadis / plsql-cop-cli

db* CODECOP Command Line
Other
25 stars 1 forks source link

Parse error when using PL/SQL mod operator #31

Closed PhilippSalvisberg closed 6 months ago

PhilippSalvisberg commented 6 months ago

Example:

declare
   l_var integer;
begin
   l_var := 11 mod 2;
end;
/
PhilippSalvisberg commented 6 months ago

Operator "mod" works only in PL/SQL and not in SQL. This was the reason it was removed in v5.0.0. Should be added again.

PhilippSalvisberg commented 6 months ago

fixed via Azure DevOps commit 80d8c457005ce29f44fc60e222646c8a3109295a