Open
@chaseven

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)