2022-09-09 mysql列存储引擎-POC-需求分析-第二版-有问题的SQL

摘要:

在解决了POC的崩溃问题后, 需求方提出第二版的需求，本文进行记录

关联issuse: bug: [POC] After the tianmu_ini_allowmysqlQuerypath parameter is enabled, the user-defined dynamic function is invoked, and the query result is null · Issue #479 · stoneatom/stonedb · GitHub

相关问题: https://stoneatom.yuque.com/staff-ft8n1u/luxxoy/dc73f9

有问题的SQL:

优化前:

    SELECT sale.usid AS usid,
        cus.corpname AS corpname,
        sale.iscenicid AS iscenicid,
        salde.itickettypeid AS itickettypeid,
        price.icrowdkindid