search

XiaoMi / soar

SQL Optimizer And Rewriter
Apache License 2.0
8.67k stars 1.32k forks source link

wrong index suggest about column with calculation #232

Closed martianzhang closed 4 years ago

martianzhang commented 4 years ago

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error.

    SELECT * FROM film WHERE length % 20 = 4;

  2. What did you expect to see?

columns with math calculation will not use existed index

  1. What did you see instead?

soar give index suggestion about length column