u-deheafaddcebebfhbdjfb 4 weeks ago
大家好! 现聊天记录同步站点如下: shardingsphere官方交流1群聊天记录同步站点https://wewe.t9t.io/chat/ASF%20ShardingSphere%E5%AE%98%E6%96%B9%E4%BA%A4%E6%B5%81%E7%BE%A41%E5%8F%B7 shardingsphere官方交流2群聊天记录同步站点 https://wewe.t9t.io/chat/ASF%20ShardingSphere%E5%AE%98%E6%96%B9%E4%BA%A4%E6%B5%81%E7%BE%A42%E5%8F%B7 shardingsphere官方交流3群聊天记录同步站点 https://wewe.t9t.io/chat/ASF%20ShardingSphere%E5%AE%98%E6%96%B9%E4%BA%A4%E6%B5%81%E7%BE%A43%E5%8F%B7 shardingsphere官方交流4群聊天记录同步站点 https://wewe.t9t.io/chat/ASF%20ShardingSphere%E5%AE%98%E6%96%B9%E4%BA%A4%E6%B5%81%E7%BE%A44%E5%8F%B7 只要访问相应群站点,就能看到实时聊天记录。 大家可以在Members 修改自己在该站点显示的个人信息,就会在站点的聊天记录中显示出来
u-bhb 4 weeks ago
问一下 分库分表查询 select count(*) 查询,提示 please add alias for aggregate selections 的问题
u-bhb 4 weeks ago
版本号4.0.0-RC2
u-bhb 4 weeks ago
单库分表查询没有问题 分库分表查询不行
u-c 4 weeks ago
@oko 报错信息能否翻译一下
u-bhb 4 weeks ago
Caused by: java.lang.IllegalStateException: Can't find index: AggregationSelectItem(type=COUNT, innerExpression=(*), alias=Optional.absent(), derivedAggregationItems=[], index=-1), please add alias for aggregate selections select count(*) 聚合函数查询列没有设置别名
u-bhb 4 weeks ago
@张亮@京东数科 验证了一下 用 nativeQuery 重写了 select count(*) as count 就正常了
u-c 4 weeks ago
<update id="addUseCountByIds">     update config_option_detail     set gmt_modified = #{gmtModified}, use_count = use_count + <foreach item="item" index="index" collection="list" open=" case id " separator=" " close=" end"> when #{index} then #{item} </foreach> where id in <foreach item="item" index="index" collection="list" open="(" separator="," close=")"> #{index} </foreach> </update> ———————————————— 版权声明:本文为CSDN博主「Monicase」的原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接及本声明。 原文链接:https://blog.csdn.net/symptoms216/article/details/79854513
u-c 4 weeks ago
@八尾猫 好的,我的意思是shardingjdbc 3.x 版本, 是否支持mybatis foreach的方式,做批量更新,类似如下实现
u-c 4 weeks ago
现在用的3.0.0版本, 貌似sql解析不了
u-ded 4 weeks ago
不是批量修改的问题,你用了case when 语法,3.0.0版本不支持case when
u-c 4 weeks ago
@oko [emoji]
u-bhb 4 weeks ago
能在ASF层面规避一下就好了
u-bhb 4 weeks ago
ASF ShardingSphere
u-c 4 weeks ago
ASF = Apache Software Foundation
u-c 4 weeks ago
我要换一下群名,我没想过有人把asf当成我们的代号