set tidb_cost_model_version=1; # # Bug#30311271 RAND() < RAND() RESULTS IN IMPOSSIBLE WHERE # # See that the optimizer does not consider two instances of RAND() as # equal. EXPLAIN SELECT 1 WHERE RAND() < RAND(); id estRows task access object operator info Projection_4 0.80 root 1->Column#1 └─Selection_5 0.80 root lt(rand(), rand()) └─TableDual_6 1.00 root rows:1