2022-12-01 mysql列存储引擎-将exists子查询转换为between操作-分析

摘要:

mysql列存储引擎-将exists子查询转换为between操作-分析

相关场景: 2022-12-01 mysql列存储引擎-主键在exists子句时候查询错误-记录_帝尊悟世的博客-CSDN博客

分析:

转换为between操作的堆栈:
 

(gdb) bt
#0  Tianmu::core::ConditionEncoder::TransformOtherThanINsOnNumerics (this=0x7f38223266b0) at /home/jenkins/workspace/stonedb5.7-zsl-centos7.9-75-133/storage/tianmu/core/condition_encoder.cpp:370
#1  0x000000000307565c in Tianmu::core::ConditionEncoder::EncodeConditionOnNumerics (this=0x7f38223266b0)
    at /home/jenkins/workspace/stonedb5.7-zsl-centos7.9-75-133/storage/tianmu/core/condition_encoder.cpp:231
#2  0x00000000030743ad in Tianmu::core::ConditionEncoder::DoEncode (this=0x7f38223266b0) at /home/jenkins/workspace/stonedb5.7-zsl-centos7.9-75-133/storage/tianmu/