ATLAS分表实现完成,但是在使用时发现有些疑问,不知道是不是使用不当还是altas本身不支持造成,求解答!
1.进行分表的表不能使用别名:譬如order数据表根据group_num进行分表 select * from order a where a.group_num = xx 报表不存在的错误,而select * from order where group_num = xx可以正确的查询出结果,求解惑
2.分表情况1,SQL语句select (select sum(order_amount) from order where group_num =xx),(select count(1) from order where group_num =xx) from dual 又报表不存在的错误,而select (select sum(order_amount) from order where group_num =xx) from dual 可以正常使用,求解惑
1.进行分表的表不能使用别名:譬如order数据表根据group_num进行分表 select * from order a where a.group_num = xx 报表不存在的错误,而select * from order where group_num = xx可以正确的查询出结果,求解惑
2.分表情况1,SQL语句select (select sum(order_amount) from order where group_num =xx),(select count(1) from order where group_num =xx) from dual 又报表不存在的错误,而select (select sum(order_amount) from order where group_num =xx) from dual 可以正常使用,求解惑