GeezerVison is showing github.com — Some SQL server syntax does not support parsing · Issue #1682 · JSQLParser/JSqlParser
Some SQL server syntax does not support parsing #1682DescriptionHi,
I found it unsupported when parsing part of SQLServer syntax.
example:
1, select [id],[name],[age] from [Student]
Because the column name contains the special symbol "[" or "]"
2, declare @Flag int
set @Flag = 1
Because the column name contains the special symbol "@" in SetStatement
3, begin
...
end
This syntax is not supported
4, use LibName
go
...
go
This syntax is not supported Activitymanticore-projects commented on Dec 5, 2022 SconyHui commented on Dec 5, 2022 Yes, I'm using version 4.6 SconyHui commented on Dec 5, 2022 eg：
select [id],[name],[age] from [Student]
 manticore-projects commented on Dec 5, 2022 Please activate SquaredBracket Quotation. manticore-projects commented on Dec 5, 2022 SconyHui commented on Dec 5, 2022 SconyHui commented on Dec 5, 2022 Thank you. The question has been solved
But I also have problems using this syntax
 manticore-projects commented on Dec 5, 2022 SET @localVariable is likely not supported.
You would either need to contribute a PR or sponsor the implementation. SconyHui commented on Dec 5, 2022 I will apply to the company SconyHui commented on Dec 6, 2022 Hi,
Is the combination of BEGIIN END and IF not supported
 manticore-projects commented on Dec 6, 2022 SconyHui commented on Dec 6, 2022 Thank you very much. I will find another way to solve this problem manticore-projects commented on Dec 6, 2022 I will provide a correction and improvement in the evening. On 6 Dec 2022 07:32, SconyHui ***@***.***> wrote:
Thank you very much. I will find another way to solve this problem
—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: ***@***.***> added 2 commits that reference this issue on Dec 9, 2022This issue will close once commit f9eee97 is merged into the 'master' branch.f9eee97 This issue will close once commit 42b429f is merged into the 'master' branch.42b429f wumpz commented on Dec 10, 2022 manticore-projects commented on Dec 10, 2022
@manticore-projects Did he sponsor the set improvement?
No. :(
But I have to parse some MS SQL Server scripts for myself and so I did not mind. added a commit that references this issue on Dec 22, 2022This issue will close once commit 8d9db70 is merged into the 'master' branch.8d9db70
MetadataMetadataDevelopmentNo branches or pull requestsIssue actions
|
