We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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.
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ALTER" "ALTER"
CREATE OR ALTER FUNCTION getPayments() RETURNS TABLE AS RETURN SELECT * from Payments;
CREATE OR ALTER PROCEDURE SPPayment AS SET NOCOUNT ON;
BEGIN SELECT * FROM Payments; END
JSqlParser version 4.8 Database (SQL Server)
The text was updated successfully, but these errors were encountered:
No branches or pull requests
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)
The text was updated successfully, but these errors were encountered: