You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "RedThreeStone (via GitHub)" <gi...@apache.org> on 2023/08/10 06:05:43 UTC

[GitHub] [shardingsphere] RedThreeStone opened a new issue, #28009: SQL with 'with nolock' is not supported

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

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   4.1.1
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
    ShardingSphere-JDBC
   ### Expected behavior
   SQL can be routed correctly
   ### Actual behavior
   In the SQL server database, SQL with 'with (nolock)‘  cannot be routed
   ### Reason analyze (If you can)
   org.apache.shardingsphere.sql.parser.SQLParserEngine#parse0  return an error SQLStatement,  The value of the attribute 'where' in it is null
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
     @PostMapping("withNoLockTest2")
       public void withNoLockTest2(){
           FulfillOrder fulfillOrder = fulfillOrderMapper.selectByUserId2("123456");
           System.out.println(JSON.toJSONString(fulfillOrder));
       }
   
     <select id="selectByUserId2" resultMap="BaseResultMap">
           select user_id from fulfill_order with(nolock) where user_id=#{userId}
       </select>
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] github-actions[bot] commented on issue #28009: SQL with 'with nolock' is not supported

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #28009:
URL: https://github.com/apache/shardingsphere/issues/28009#issuecomment-1712590772

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] sandynz commented on issue #28009: SQL with 'with nolock' is not supported

Posted by "sandynz (via GitHub)" <gi...@apache.org>.
sandynz commented on issue #28009:
URL: https://github.com/apache/shardingsphere/issues/28009#issuecomment-1673053176

   Looks `nolock` is not supported for SQLServer on master branch too.
   
   Is `nolock` required?


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] SQL with 'with nolock' is not supported [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #28009:
URL: https://github.com/apache/shardingsphere/issues/28009#issuecomment-2212461810

   The version is out of service, please try new version.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] SQL with 'with nolock' is not supported [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #28009: SQL with 'with nolock' is not supported
URL: https://github.com/apache/shardingsphere/issues/28009


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] SQL with 'with nolock' is not supported [shardingsphere]

Posted by "shardcn (via GitHub)" <gi...@apache.org>.
shardcn commented on issue #28009:
URL: https://github.com/apache/shardingsphere/issues/28009#issuecomment-2413276656

   you may write issues of version 4.1.1 here :https://gitee.com/shardcn/shardingsphere_4.1.1


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org