mklyazhev opened a new issue, #37973:
URL: https://github.com/apache/shardingsphere/issues/37973

   ## Question
   
   I am using ShardingSphere version 5.5.2. I discovered a bug in the SQLServer 
parser regarding `SET QUOTED_IDENTIFIER` and `SET TEXTSIZE` statements (or 
maybe something else), which are currently not supported.
   
   Error example:
   
`org.apache.shardingsphere.infra.exception.dialect.exception.syntax.sql.DialectSQLParsingException:
 You have an error in your SQL syntax: no viable alternative at input 
'SETTEXTSIZE'.`
   
   I decided to implement support for these commands and successfully created a 
patch for version 5.5.2 locally. I then checked for existing issues or upcoming 
support in newer versions but found nothing specific, aside from the issue: 
#29149.
   
   I intended to submit a Pull Request with this fix. However, when I checked 
the current master branch, I noticed that the project structure has changed. In 
this new structure, I couldn't find any DAL statements for SQLServer (only dcl 
and ddl exist).
   
   This raises a question: Has the functionality from the previous version not 
been fully migrated to master yet?
   I compared this with other dialects (MySQL, PostgreSQL, Oracle, etc.) and 
noticed that some have dal packages while others seem to be missing components 
as well.
   
   If this functionality is planned to be migrated or added later, I would like 
to contribute my implementation to ensure these errors are fixed in the next 
release.
   
   _Apologies if I selected the wrong Issue type, as this situation seemed a 
bit unusual._
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: 
[email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to