databend
databend copied to clipboard
Feature: eliminate constant subquery
Summary
For the following case:
CREATE TABLE date_sub_query_test (
ID BIGINT NULL,
test_time timestamp NULL
)
explain select * from date_sub_query_test where test_time >= (select now());
We can eliminate the constant subquery and avoid join.