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

[GitHub] [shardingsphere] Cyoking opened a new issue, #24659: The generated sql contains ShardingInsertValuesToken

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

   ## Question
   The shardingSphere I use is version 5.1.1
   
   The following is my mybatis sql
   ```xml
   <insert id="test">
           INSERT INTO test
           (v_uuid, company_id, hash_id, store_id, msku, stock_90_list)
           VALUES
           <foreach collection="tList" item="item" index="index" separator=",">
               (
                   #{item.vUuid},
                   #{item.companyId},
                   #{item.hashId},
                   #{item.storeId},
                   #{item.msku},
                   #{item.stock90List}
               )
           </foreach>
           ON DUPLICATE KEY UPDATE
           company_id  = values(company_id),
           stock_90_list=values(stock_90_list)
   </insert>
   ```
   Below is the value of parsing sql in ParseInfo
   ![image](https://user-images.githubusercontent.com/41101749/225798897-521a4fdd-8f7a-42f6-acb5-cb7cfb818bcf.png)
   
   
   This will result in an error:
   Cause: java.lang.StringIndexOutOfBoundsException: String index out of range: -52


-- 
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


Re: [I] The generated sql contains ShardingInsertValuesToken [shardingsphere]

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

   has this problem been solved? I met this problem too.


-- 
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] Cyoking closed issue #24659: The generated sql contains ShardingInsertValuesToken

Posted by "Cyoking (via GitHub)" <gi...@apache.org>.
Cyoking closed issue #24659: The generated sql contains ShardingInsertValuesToken
URL: https://github.com/apache/shardingsphere/issues/24659


-- 
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] The generated sql contains ShardingInsertValuesToken [shardingsphere]

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

   @darren-wang Can you sumbit new issue to report this exception?


-- 
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