Skip to content

[BUG] JSQLParser Version : 4.8: Does not support "ALTER FUNCTION" or "ALTER PROCEDURE". #1978

Description

@chaseven

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)

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions