摘要:

mysql列存储-关于join查询结果出错和查询性能的问题-分析

相关ISSUE: bug: When the right table is a derived table of the subquery, the query result will be incorrect either for the left join or for the inner join · Issue #1585 · stoneatom/stonedb · GitHub

问题记录:

1.  查询结果集错误
2.  将inner join转换为left join, 查询执行的性能反而增强了

复现环境:

stonedb:

• 192.168.30.52
• /opt/stonedb57/install/bin/mysql -uroot -pmysql123  -D mbs

/opt/stonedb57/install/bin/mysql -uroot -pmysql123  -D mbs

innodb:

• 192.168.30.42
• /usr/local/my