#348 SQL: SQL Server square brackets quoting isn't supported everywhere

open
nobody
SQL (1)
5
2014-12-06
2013-06-26
No

The SQL Server square brackets quoting is only supported for tables, not everywhere an identifier is expected.

This breaks the output of the Test/bug1944150.sql test case. With trunk it gives:

cash_trade_comment. Test/bug1944150.sql /^CREATE TRIGGER [tr_d_cash_trade_comment] ON dbo.cash_trade_comment$/;"    T

See that tr_d_cash_trade_comment is completely missing, and that the tag's name is cash_trade_comment. (with the dot). It should actually be:

cash_trade_comment.tr_d_cash_trade_comment  Test/bug1944150.sql /^CREATE TRIGGER [tr_d_cash_trade_comment] ON dbo.cash_trade_comment$/;"    T

Attached patch fixes the issue by generalizing support for square brackets quoting. My checks shows no change in test cases output apart for the above.

1 Attachments

Related

Feature Requests: #63

Discussion

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks