Open
Description
Validation validation = new Validation(Arrays.asList(DatabaseType.SQLSERVER), sql);
validation.validate();
Does not support "ALTER FUNCTION" or "ALTER PROCEDURE" both scripts below are compiled on SQL Server.
Failing SQL Feature:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ALTER" "ALTER"
SQL Example:
CREATE OR
ALTER FUNCTION getPayments()
RETURNS TABLE
AS
RETURN
SELECT * from Payments;
SQL Example:
CREATE OR ALTER PROCEDURE SPPayment
AS
SET NOCOUNT ON;
BEGIN
SELECT * FROM Payments;
END
Software Information:
JSqlParser version 4.8
Database (SQL Server)