in regression-test/suites/nereids_function_p0/agg_function/agg.groovy [23:2441]
select any_value(kint) from fn_test group by kbool order by kbool'''
sql '''
select any_value(kint) from fn_test'''
sql '''
select count(id), any_value(kint) from fn_test group by id order by id'''
sql '''
select count(distinct id), any_value(kint) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), any_value(kint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), any_value(kint) from fn_test'''
sql '''
select any_value(kint) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select any_value(kint) from fn_test_not_nullable'''
sql '''
select count(id), any_value(kint) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), any_value(kint) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), any_value(kint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), any_value(kint) from fn_test'''
// count_by_enum_string result is unstable in one line, so just check not core
sql '''
select count_by_enum(kstr) from fn_test group by kbool order by kbool'''
sql '''
select count_by_enum(kstr) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_TinyInt_gb '''
select avg(ktint) from fn_test group by kbool order by kbool'''
qt_sql_avg_TinyInt '''
select avg(ktint) from fn_test'''
qt_sql_avg_TinyInt_agg_phase_1 '''
select count(id), avg(ktint) from fn_test group by id order by id'''
qt_sql_avg_TinyInt_agg_phase_2 '''
select count(distinct id), avg(ktint) from fn_test'''
qt_sql_avg_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(ktint) from fn_test group by kbool order by kbool'''
qt_sql_avg_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(ktint) from fn_test'''
qt_sql_avg_TinyInt_gb_notnull '''
select avg(ktint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_TinyInt_notnull '''
select avg(ktint) from fn_test_not_nullable'''
qt_sql_avg_TinyInt_agg_phase_1_notnull '''
select count(id), avg(ktint) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_TinyInt_agg_phase_2_notnull '''
select count(distinct id), avg(ktint) from fn_test_not_nullable'''
qt_sql_avg_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(ktint) from fn_test group by kbool order by kbool'''
qt_sql_avg_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(ktint) from fn_test'''
qt_sql_avg_SmallInt_gb '''
select avg(ksint) from fn_test group by kbool order by kbool'''
qt_sql_avg_SmallInt '''
select avg(ksint) from fn_test'''
qt_sql_avg_SmallInt_agg_phase_1 '''
select count(id), avg(ksint) from fn_test group by id order by id'''
qt_sql_avg_SmallInt_agg_phase_2 '''
select count(distinct id), avg(ksint) from fn_test'''
qt_sql_avg_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(ksint) from fn_test group by kbool order by kbool'''
qt_sql_avg_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(ksint) from fn_test'''
qt_sql_avg_SmallInt_gb_notnull '''
select avg(ksint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_SmallInt_notnull '''
select avg(ksint) from fn_test_not_nullable'''
qt_sql_avg_SmallInt_agg_phase_1_notnull '''
select count(id), avg(ksint) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_SmallInt_agg_phase_2_notnull '''
select count(distinct id), avg(ksint) from fn_test_not_nullable'''
qt_sql_avg_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(ksint) from fn_test group by kbool order by kbool'''
qt_sql_avg_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(ksint) from fn_test'''
qt_sql_avg_Integer_gb '''
select avg(kint) from fn_test group by kbool order by kbool'''
qt_sql_avg_Integer '''
select avg(kint) from fn_test'''
qt_sql_avg_Integer_agg_phase_1 '''
select count(id), avg(kint) from fn_test group by id order by id'''
qt_sql_avg_Integer_agg_phase_2 '''
select count(distinct id), avg(kint) from fn_test'''
qt_sql_avg_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(kint) from fn_test group by kbool order by kbool'''
qt_sql_avg_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(kint) from fn_test'''
qt_sql_avg_Integer_gb_notnull '''
select avg(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_Integer_notnull '''
select avg(kint) from fn_test_not_nullable'''
qt_sql_avg_Integer_agg_phase_1_notnull '''
select count(id), avg(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_Integer_agg_phase_2_notnull '''
select count(distinct id), avg(kint) from fn_test_not_nullable'''
qt_sql_avg_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(kint) from fn_test group by kbool order by kbool'''
qt_sql_avg_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(kint) from fn_test'''
qt_sql_avg_BigInt_gb '''
select avg(kbint) from fn_test group by kbool order by kbool'''
qt_sql_avg_BigInt '''
select avg(kbint) from fn_test'''
qt_sql_avg_BigInt_agg_phase_1 '''
select count(id), avg(kbint) from fn_test group by id order by id'''
qt_sql_avg_BigInt_agg_phase_2 '''
select count(distinct id), avg(kbint) from fn_test'''
qt_sql_avg_BigInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(kbint) from fn_test group by kbool order by kbool'''
qt_sql_avg_BigInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(kbint) from fn_test'''
qt_sql_avg_BigInt_gb_notnull '''
select avg(kbint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_BigInt_notnull '''
select avg(kbint) from fn_test_not_nullable'''
qt_sql_avg_BigInt_agg_phase_1_notnull '''
select count(id), avg(kbint) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_BigInt_agg_phase_2_notnull '''
select count(distinct id), avg(kbint) from fn_test_not_nullable'''
qt_sql_avg_BigInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(kbint) from fn_test group by kbool order by kbool'''
qt_sql_avg_BigInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(kbint) from fn_test'''
qt_sql_avg_Double_gb '''
select avg(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_Double '''
select avg(kdbl) from fn_test'''
qt_sql_avg_Double_agg_phase_1 '''
select count(id), avg(kdbl) from fn_test group by id order by id'''
qt_sql_avg_Double_agg_phase_2 '''
select count(distinct id), avg(kdbl) from fn_test'''
qt_sql_avg_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(kdbl) from fn_test'''
qt_sql_avg_Double_gb_notnull '''
select avg(kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_Double_notnull '''
select avg(kdbl) from fn_test_not_nullable'''
qt_sql_avg_Double_agg_phase_1_notnull '''
select count(id), avg(kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_Double_agg_phase_2_notnull '''
select count(distinct id), avg(kdbl) from fn_test_not_nullable'''
qt_sql_avg_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(kdbl) from fn_test'''
qt_sql_avg_DecimalV2_gb '''
select avg(kdcmls1) from fn_test group by kbool order by kbool'''
qt_sql_avg_DecimalV2 '''
select avg(kdcmls1) from fn_test'''
qt_sql_avg_DecimalV2_agg_phase_1 '''
select count(id), avg(kdcmls1) from fn_test group by id order by id'''
qt_sql_avg_DecimalV2_agg_phase_2 '''
select count(distinct id), avg(kdcmls1) from fn_test'''
qt_sql_avg_DecimalV2_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(kdcmls1) from fn_test group by kbool order by kbool'''
qt_sql_avg_DecimalV2_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(kdcmls1) from fn_test'''
qt_sql_avg_DecimalV2_gb_notnull '''
select avg(kdcmls1) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_DecimalV2_notnull '''
select avg(kdcmls1) from fn_test_not_nullable'''
qt_sql_avg_DecimalV2_agg_phase_1_notnull '''
select count(id), avg(kdcmls1) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_DecimalV2_agg_phase_2_notnull '''
select count(distinct id), avg(kdcmls1) from fn_test_not_nullable'''
qt_sql_avg_DecimalV2_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg(kdcmls1) from fn_test group by kbool order by kbool'''
qt_sql_avg_DecimalV2_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg(kdcmls1) from fn_test'''
qt_sql_avg_weighted_TinyInt_Double_gb '''
select avg_weighted(ktint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_TinyInt_Double '''
select avg_weighted(ktint, kdbl) from fn_test'''
qt_sql_avg_weighted_TinyInt_Double_agg_phase_1 '''
select count(id), avg_weighted(ktint, kdbl) from fn_test group by id order by id'''
qt_sql_avg_weighted_TinyInt_Double_agg_phase_2 '''
select count(distinct id), avg_weighted(ktint, kdbl) from fn_test'''
qt_sql_avg_weighted_TinyInt_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(ktint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_TinyInt_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(ktint, kdbl) from fn_test'''
qt_sql_avg_weighted_TinyInt_Double_gb_notnull '''
select avg_weighted(ktint, kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_weighted_TinyInt_Double_notnull '''
select avg_weighted(ktint, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_TinyInt_Double_agg_phase_1_notnull '''
select count(id), avg_weighted(ktint, kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_weighted_TinyInt_Double_agg_phase_2_notnull '''
select count(distinct id), avg_weighted(ktint, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_TinyInt_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(ktint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_TinyInt_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(ktint, kdbl) from fn_test'''
qt_sql_avg_weighted_SmallInt_Double_gb '''
select avg_weighted(ksint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_SmallInt_Double '''
select avg_weighted(ksint, kdbl) from fn_test'''
qt_sql_avg_weighted_SmallInt_Double_agg_phase_1 '''
select count(id), avg_weighted(ksint, kdbl) from fn_test group by id order by id'''
qt_sql_avg_weighted_SmallInt_Double_agg_phase_2 '''
select count(distinct id), avg_weighted(ksint, kdbl) from fn_test'''
qt_sql_avg_weighted_SmallInt_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(ksint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_SmallInt_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(ksint, kdbl) from fn_test'''
qt_sql_avg_weighted_SmallInt_Double_gb_notnull '''
select avg_weighted(ksint, kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_weighted_SmallInt_Double_notnull '''
select avg_weighted(ksint, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_SmallInt_Double_agg_phase_1_notnull '''
select count(id), avg_weighted(ksint, kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_weighted_SmallInt_Double_agg_phase_2_notnull '''
select count(distinct id), avg_weighted(ksint, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_SmallInt_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(ksint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_SmallInt_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(ksint, kdbl) from fn_test'''
qt_sql_avg_weighted_Integer_Double_gb '''
select avg_weighted(kint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Integer_Double '''
select avg_weighted(kint, kdbl) from fn_test'''
qt_sql_avg_weighted_Integer_Double_agg_phase_1 '''
select count(id), avg_weighted(kint, kdbl) from fn_test group by id order by id'''
qt_sql_avg_weighted_Integer_Double_agg_phase_2 '''
select count(distinct id), avg_weighted(kint, kdbl) from fn_test'''
qt_sql_avg_weighted_Integer_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Integer_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kint, kdbl) from fn_test'''
qt_sql_avg_weighted_Integer_Double_gb_notnull '''
select avg_weighted(kint, kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_weighted_Integer_Double_notnull '''
select avg_weighted(kint, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_Integer_Double_agg_phase_1_notnull '''
select count(id), avg_weighted(kint, kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_weighted_Integer_Double_agg_phase_2_notnull '''
select count(distinct id), avg_weighted(kint, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_Integer_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Integer_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kint, kdbl) from fn_test'''
qt_sql_avg_weighted_BigInt_Double_gb '''
select avg_weighted(kbint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_BigInt_Double '''
select avg_weighted(kbint, kdbl) from fn_test'''
qt_sql_avg_weighted_BigInt_Double_agg_phase_1 '''
select count(id), avg_weighted(kbint, kdbl) from fn_test group by id order by id'''
qt_sql_avg_weighted_BigInt_Double_agg_phase_2 '''
select count(distinct id), avg_weighted(kbint, kdbl) from fn_test'''
qt_sql_avg_weighted_BigInt_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kbint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_BigInt_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kbint, kdbl) from fn_test'''
qt_sql_avg_weighted_BigInt_Double_gb_notnull '''
select avg_weighted(kbint, kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_weighted_BigInt_Double_notnull '''
select avg_weighted(kbint, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_BigInt_Double_agg_phase_1_notnull '''
select count(id), avg_weighted(kbint, kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_weighted_BigInt_Double_agg_phase_2_notnull '''
select count(distinct id), avg_weighted(kbint, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_BigInt_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kbint, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_BigInt_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kbint, kdbl) from fn_test'''
qt_sql_avg_weighted_Float_Double_gb '''
select avg_weighted(kfloat, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Float_Double '''
select avg_weighted(kfloat, kdbl) from fn_test'''
qt_sql_avg_weighted_Float_Double_agg_phase_1 '''
select count(id), avg_weighted(kfloat, kdbl) from fn_test group by id order by id'''
qt_sql_avg_weighted_Float_Double_agg_phase_2 '''
select count(distinct id), avg_weighted(kfloat, kdbl) from fn_test'''
qt_sql_avg_weighted_Float_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kfloat, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Float_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kfloat, kdbl) from fn_test'''
qt_sql_avg_weighted_Float_Double_gb_notnull '''
select avg_weighted(kfloat, kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_weighted_Float_Double_notnull '''
select avg_weighted(kfloat, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_Float_Double_agg_phase_1_notnull '''
select count(id), avg_weighted(kfloat, kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_weighted_Float_Double_agg_phase_2_notnull '''
select count(distinct id), avg_weighted(kfloat, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_Float_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kfloat, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Float_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kfloat, kdbl) from fn_test'''
qt_sql_avg_weighted_Double_Double_gb '''
select avg_weighted(kdbl, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Double_Double '''
select avg_weighted(kdbl, kdbl) from fn_test'''
qt_sql_avg_weighted_Double_Double_agg_phase_1 '''
select count(id), avg_weighted(kdbl, kdbl) from fn_test group by id order by id'''
qt_sql_avg_weighted_Double_Double_agg_phase_2 '''
select count(distinct id), avg_weighted(kdbl, kdbl) from fn_test'''
qt_sql_avg_weighted_Double_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kdbl, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Double_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kdbl, kdbl) from fn_test'''
qt_sql_avg_weighted_Double_Double_gb_notnull '''
select avg_weighted(kdbl, kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_weighted_Double_Double_notnull '''
select avg_weighted(kdbl, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_Double_Double_agg_phase_1_notnull '''
select count(id), avg_weighted(kdbl, kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_weighted_Double_Double_agg_phase_2_notnull '''
select count(distinct id), avg_weighted(kdbl, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_Double_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kdbl, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_Double_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kdbl, kdbl) from fn_test'''
qt_sql_avg_weighted_DecimalV2_Double_gb '''
select avg_weighted(kdcmls1, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_DecimalV2_Double '''
select avg_weighted(kdcmls1, kdbl) from fn_test'''
qt_sql_avg_weighted_DecimalV2_Double_agg_phase_1 '''
select count(id), avg_weighted(kdcmls1, kdbl) from fn_test group by id order by id'''
qt_sql_avg_weighted_DecimalV2_Double_agg_phase_2 '''
select count(distinct id), avg_weighted(kdcmls1, kdbl) from fn_test'''
qt_sql_avg_weighted_DecimalV2_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kdcmls1, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_DecimalV2_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kdcmls1, kdbl) from fn_test'''
qt_sql_avg_weighted_DecimalV2_Double_gb_notnull '''
select avg_weighted(kdcmls1, kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_avg_weighted_DecimalV2_Double_notnull '''
select avg_weighted(kdcmls1, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_DecimalV2_Double_agg_phase_1_notnull '''
select count(id), avg_weighted(kdcmls1, kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_avg_weighted_DecimalV2_Double_agg_phase_2_notnull '''
select count(distinct id), avg_weighted(kdcmls1, kdbl) from fn_test_not_nullable'''
qt_sql_avg_weighted_DecimalV2_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), avg_weighted(kdcmls1, kdbl) from fn_test group by kbool order by kbool'''
qt_sql_avg_weighted_DecimalV2_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), avg_weighted(kdcmls1, kdbl) from fn_test'''
qt_sql_bitmap_intersect_Bitmap_gb '''
select bitmap_intersect(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_intersect_Bitmap '''
select bitmap_intersect(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_intersect_Bitmap_agg_phase_1 '''
select count(id), bitmap_intersect(bitmap_hash(kbint)) from fn_test group by id order by id'''
qt_sql_bitmap_intersect_Bitmap_agg_phase_2 '''
select count(distinct id), bitmap_intersect(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_intersect_Bitmap_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_intersect(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_intersect_Bitmap_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_intersect(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_intersect_Bitmap_gb_notnull '''
select bitmap_intersect(bitmap_hash(kbint)) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_bitmap_intersect_Bitmap_notnull '''
select bitmap_intersect(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_bitmap_intersect_Bitmap_agg_phase_1_notnull '''
select count(id), bitmap_intersect(bitmap_hash(kbint)) from fn_test_not_nullable group by id order by id'''
qt_sql_bitmap_intersect_Bitmap_agg_phase_2_notnull '''
select count(distinct id), bitmap_intersect(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_bitmap_intersect_Bitmap_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_intersect(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_intersect_Bitmap_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_intersect(bitmap_hash(kbint)) from fn_test'''
// bitmap_agg
qt_sql_bitmap_agg_tinyint """
select bitmap_count(b) from (select kbool, bitmap_agg(ktint) b from fn_test group by kbool) a order by kbool
"""
qt_sql_bitmap_agg_smallint """
select bitmap_count(b) from (select kbool, bitmap_agg(ksint) b from fn_test group by kbool) a order by kbool
"""
qt_sql_bitmap_agg_int """
select bitmap_count(b) from (select kbool, bitmap_agg(kint) b from fn_test group by kbool) a order by kbool
"""
qt_sql_bitmap_agg_bigint """
select bitmap_count(b) from (select kbool, bitmap_agg(kbint) b from fn_test group by kbool) a order by kbool
"""
qt_sql_bitmap_union_Bitmap_gb '''
select bitmap_union(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_Bitmap '''
select bitmap_union(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_union_Bitmap_agg_phase_1 '''
select count(id), bitmap_union(bitmap_hash(kbint)) from fn_test group by id order by id'''
qt_sql_bitmap_union_Bitmap_agg_phase_2 '''
select count(distinct id), bitmap_union(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_union_Bitmap_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_Bitmap_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_union_Bitmap_gb_notnull '''
select bitmap_union(bitmap_hash(kbint)) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_bitmap_union_Bitmap_notnull '''
select bitmap_union(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_bitmap_union_Bitmap_agg_phase_1_notnull '''
select count(id), bitmap_union(bitmap_hash(kbint)) from fn_test_not_nullable group by id order by id'''
qt_sql_bitmap_union_Bitmap_agg_phase_2_notnull '''
select count(distinct id), bitmap_union(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_bitmap_union_Bitmap_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_Bitmap_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_union_count_Bitmap_gb '''
select bitmap_union_count(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_count_Bitmap '''
select bitmap_union_count(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_union_count_Bitmap_agg_phase_1 '''
select count(id), bitmap_union_count(bitmap_hash(kbint)) from fn_test group by id order by id'''
qt_sql_bitmap_union_count_Bitmap_agg_phase_2 '''
select count(distinct id), bitmap_union_count(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_union_count_Bitmap_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union_count(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_count_Bitmap_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union_count(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_union_count_Bitmap_gb_notnull '''
select bitmap_union_count(bitmap_hash(kbint)) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_bitmap_union_count_Bitmap_notnull '''
select bitmap_union_count(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_bitmap_union_count_Bitmap_agg_phase_1_notnull '''
select count(id), bitmap_union_count(bitmap_hash(kbint)) from fn_test_not_nullable group by id order by id'''
qt_sql_bitmap_union_count_Bitmap_agg_phase_2_notnull '''
select count(distinct id), bitmap_union_count(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_bitmap_union_count_Bitmap_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union_count(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_count_Bitmap_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union_count(bitmap_hash(kbint)) from fn_test'''
qt_sql_bitmap_union_int_SmallInt_gb '''
select bitmap_union_int(ksint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_SmallInt '''
select bitmap_union_int(ksint) from fn_test'''
qt_sql_bitmap_union_int_SmallInt_agg_phase_1 '''
select count(id), bitmap_union_int(ksint) from fn_test group by id order by id'''
qt_sql_bitmap_union_int_SmallInt_agg_phase_2 '''
select count(distinct id), bitmap_union_int(ksint) from fn_test'''
qt_sql_bitmap_union_int_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union_int(ksint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union_int(ksint) from fn_test'''
qt_sql_bitmap_union_int_SmallInt_gb_notnull '''
select bitmap_union_int(ksint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_bitmap_union_int_SmallInt_notnull '''
select bitmap_union_int(ksint) from fn_test_not_nullable'''
qt_sql_bitmap_union_int_SmallInt_agg_phase_1_notnull '''
select count(id), bitmap_union_int(ksint) from fn_test_not_nullable group by id order by id'''
qt_sql_bitmap_union_int_SmallInt_agg_phase_2_notnull '''
select count(distinct id), bitmap_union_int(ksint) from fn_test_not_nullable'''
qt_sql_bitmap_union_int_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union_int(ksint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union_int(ksint) from fn_test'''
qt_sql_bitmap_union_int_TinyInt_gb '''
select bitmap_union_int(ktint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_TinyInt '''
select bitmap_union_int(ktint) from fn_test'''
qt_sql_bitmap_union_int_TinyInt_agg_phase_1 '''
select count(id), bitmap_union_int(ktint) from fn_test group by id order by id'''
qt_sql_bitmap_union_int_TinyInt_agg_phase_2 '''
select count(distinct id), bitmap_union_int(ktint) from fn_test'''
qt_sql_bitmap_union_int_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union_int(ktint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union_int(ktint) from fn_test'''
qt_sql_bitmap_union_int_TinyInt_gb_notnull '''
select bitmap_union_int(ktint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_bitmap_union_int_TinyInt_notnull '''
select bitmap_union_int(ktint) from fn_test_not_nullable'''
qt_sql_bitmap_union_int_TinyInt_agg_phase_1_notnull '''
select count(id), bitmap_union_int(ktint) from fn_test_not_nullable group by id order by id'''
qt_sql_bitmap_union_int_TinyInt_agg_phase_2_notnull '''
select count(distinct id), bitmap_union_int(ktint) from fn_test_not_nullable'''
qt_sql_bitmap_union_int_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union_int(ktint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union_int(ktint) from fn_test'''
qt_sql_bitmap_union_int_Integer_gb '''
select bitmap_union_int(kint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_Integer '''
select bitmap_union_int(kint) from fn_test'''
qt_sql_bitmap_union_int_Integer_agg_phase_1 '''
select count(id), bitmap_union_int(kint) from fn_test group by id order by id'''
qt_sql_bitmap_union_int_Integer_agg_phase_2 '''
select count(distinct id), bitmap_union_int(kint) from fn_test'''
qt_sql_bitmap_union_int_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union_int(kint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union_int(kint) from fn_test'''
qt_sql_bitmap_union_int_Integer_gb_notnull '''
select bitmap_union_int(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_bitmap_union_int_Integer_notnull '''
select bitmap_union_int(kint) from fn_test_not_nullable'''
qt_sql_bitmap_union_int_Integer_agg_phase_1_notnull '''
select count(id), bitmap_union_int(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_bitmap_union_int_Integer_agg_phase_2_notnull '''
select count(distinct id), bitmap_union_int(kint) from fn_test_not_nullable'''
qt_sql_bitmap_union_int_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), bitmap_union_int(kint) from fn_test group by kbool order by kbool'''
qt_sql_bitmap_union_int_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), bitmap_union_int(kint) from fn_test'''
qt_sql_count_gb '''
select count() from fn_test group by kbool order by kbool'''
qt_sql_count '''
select count() from fn_test'''
qt_sql_count_agg_phase_1 '''
select count(id), count() from fn_test group by id order by id'''
qt_sql_count_agg_phase_2 '''
select count(distinct id), count() from fn_test'''
qt_sql_count_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), count() from fn_test group by kbool order by kbool'''
qt_sql_count_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), count() from fn_test'''
qt_sql_count_gb_notnull '''
select count() from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_count_notnull '''
select count() from fn_test_not_nullable'''
qt_sql_count_agg_phase_1_notnull '''
select count(id), count() from fn_test_not_nullable group by id order by id'''
qt_sql_count_agg_phase_2_notnull '''
select count(distinct id), count() from fn_test_not_nullable'''
qt_sql_count_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), count() from fn_test group by kbool order by kbool'''
qt_sql_count_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), count() from fn_test'''
qt_sql_count_array_gb '''
select count(kaint) from fn_test group by kbool order by kbool'''
qt_sql_count_AnyData_gb '''
select count(kint) from fn_test group by kbool order by kbool'''
qt_sql_count_AnyData '''
select count(kint) from fn_test'''
qt_sql_count_AnyData_agg_phase_1 '''
select count(id), count(kint) from fn_test group by id order by id'''
qt_sql_count_AnyData_agg_phase_2 '''
select count(distinct id), count(kint) from fn_test'''
qt_sql_count_AnyData_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), count(kint) from fn_test group by kbool order by kbool'''
qt_sql_count_AnyData_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), count(kint) from fn_test'''
qt_sql_count_AnyData_gb_notnull '''
select count(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_count_AnyData_notnull '''
select count(kint) from fn_test_not_nullable'''
qt_sql_count_AnyData_agg_phase_1_notnull '''
select count(id), count(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_count_AnyData_agg_phase_2_notnull '''
select count(distinct id), count(kint) from fn_test_not_nullable'''
qt_sql_count_AnyData_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), count(kint) from fn_test group by kbool order by kbool'''
qt_sql_count_AnyData_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), count(kint) from fn_test'''
// array intersect result is not stable, we comment them
// qt_sql_group_array_intersect_array_bool '''
// select group_array_intersect(kabool) from fn_test where id<= 2;'''
// qt_sql_group_array_intersect_array_tinyint '''
// select group_array_intersect(katint) from fn_test where id between 7 and 10;'''
// qt_sql_group_array_intersect_array_smallint '''
// select group_array_intersect(kasint) from fn_test;'''
// qt_sql_group_array_intersect_array_int '''
// select group_array_intersect(kaint) from fn_test group by id order by id;'''
// qt_sql_group_array_intersect_array_bigint '''
// select group_array_intersect(kabint) from fn_test where id between 7 and 10;'''
// qt_sql_group_array_intersect_array_largeint '''
// select group_array_intersect(kalint) from fn_test where id = 7;'''
// qt_sql_group_array_intersect_array_float '''
// select group_array_intersect(kafloat) from fn_test where id = 4;'''
// qt_sql_group_array_intersect_array_double '''
// select group_array_intersect(kadbl) from fn_test where id = 1;'''
// qt_sql_group_array_intersect_array_date '''
// select group_array_intersect(kadt) from fn_test where id = 2;'''
// qt_sql_group_array_intersect_array_datetime '''
// select group_array_intersect(kadtm) from fn_test where id = 3;'''
// qt_sql_group_array_intersect_array_datev2 '''
// select group_array_intersect(kadtv2) from fn_test where id = 5;'''
// qt_sql_group_array_intersect_array_datetimev2 '''
// select group_array_intersect(kadtmv2) from fn_test where id = 8;'''
// qt_sql_group_array_intersect_array_char '''
// select group_array_intersect(kachr) from fn_test where id in (0, 3);'''
// qt_sql_group_array_intersect_array_varchar '''
// select group_array_intersect(kavchr) from fn_test where id = 6;'''
// qt_sql_group_array_intersect_array_string '''
// select group_array_intersect(kastr) from fn_test where id in (6, 9);'''
// qt_sql_group_array_intersect_array_decimal '''
// select group_array_intersect(kadcml) from fn_test group by id order by id;'''
// qt_sql_group_array_intersect_array_bool_notnull '''
// select group_array_intersect(kabool) from fn_test_not_nullable where id<= 2;'''
// qt_sql_group_array_intersect_array_tinyint_notnull '''
// select group_array_intersect(katint) from fn_test_not_nullable where id between 7 and 10;'''
// qt_sql_group_array_intersect_array_smallint_notnull '''
// select group_array_intersect(kasint) from fn_test_not_nullable;'''
// qt_sql_group_array_intersect_array_int_notnull '''
// select group_array_intersect(kaint) from fn_test_not_nullable group by id order by id;'''
// qt_sql_group_array_intersect_array_bigint_notnull '''
// select group_array_intersect(kabint) from fn_test_not_nullable where id between 7 and 10;'''
// qt_sql_group_array_intersect_array_largeint_notnull '''
// select group_array_intersect(kalint) from fn_test_not_nullable where id = 7;'''
// qt_sql_group_array_intersect_array_float_notnull '''
// select group_array_intersect(kafloat) from fn_test_not_nullable where id = 4;'''
// qt_sql_group_array_intersect_array_double_notnull '''
// select group_array_intersect(kadbl) from fn_test_not_nullable where id = 1;'''
// qt_sql_group_array_intersect_array_date_notnull '''
// select group_array_intersect(kadt) from fn_test_not_nullable where id = 2;'''
// qt_sql_group_array_intersect_array_datetime_notnull '''
// select group_array_intersect(kadtm) from fn_test_not_nullable where id = 3;'''
// qt_sql_group_array_intersect_array_datev2_notnull '''
// select group_array_intersect(kadtv2) from fn_test_not_nullable where id = 5;'''
// qt_sql_group_array_intersect_array_datetimev2_notnull '''
// select group_array_intersect(kadtmv2) from fn_test_not_nullable where id = 8;'''
// qt_sql_group_array_intersect_array_char_notnull '''
// select group_array_intersect(kachr) from fn_test_not_nullable where id in (0, 3);'''
// qt_sql_group_array_intersect_array_varchar_notnull '''
// select group_array_intersect(kavchr) from fn_test_not_nullable where id = 6;'''
// qt_sql_group_array_intersect_array_string_notnull '''
// select group_array_intersect(kastr) from fn_test_not_nullable where id in (6, 9);'''
// qt_sql_group_array_intersect_array_decimal_notnull '''
// select group_array_intersect(kadcml) from fn_test_not_nullable group by id order by id;'''
qt_sql_group_bit_and_TinyInt_gb '''
select group_bit_and(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_TinyInt '''
select group_bit_and(ktint) from fn_test'''
qt_sql_group_bit_and_TinyInt_agg_phase_1 '''
select count(id), group_bit_and(ktint) from fn_test group by id order by id'''
qt_sql_group_bit_and_TinyInt_agg_phase_2 '''
select count(distinct id), group_bit_and(ktint) from fn_test'''
qt_sql_group_bit_and_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(ktint) from fn_test'''
qt_sql_group_bit_and_TinyInt_gb_notnull '''
select group_bit_and(ktint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_and_TinyInt_notnull '''
select group_bit_and(ktint) from fn_test_not_nullable'''
qt_sql_group_bit_and_TinyInt_agg_phase_1_notnull '''
select count(id), group_bit_and(ktint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_and_TinyInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_and(ktint) from fn_test_not_nullable'''
qt_sql_group_bit_and_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(ktint) from fn_test'''
qt_sql_group_bit_and_SmallInt_gb '''
select group_bit_and(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_SmallInt '''
select group_bit_and(ksint) from fn_test'''
qt_sql_group_bit_and_SmallInt_agg_phase_1 '''
select count(id), group_bit_and(ksint) from fn_test group by id order by id'''
qt_sql_group_bit_and_SmallInt_agg_phase_2 '''
select count(distinct id), group_bit_and(ksint) from fn_test'''
qt_sql_group_bit_and_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(ksint) from fn_test'''
qt_sql_group_bit_and_SmallInt_gb_notnull '''
select group_bit_and(ksint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_and_SmallInt_notnull '''
select group_bit_and(ksint) from fn_test_not_nullable'''
qt_sql_group_bit_and_SmallInt_agg_phase_1_notnull '''
select count(id), group_bit_and(ksint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_and_SmallInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_and(ksint) from fn_test_not_nullable'''
qt_sql_group_bit_and_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(ksint) from fn_test'''
qt_sql_group_bit_and_Integer_gb '''
select group_bit_and(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_Integer '''
select group_bit_and(kint) from fn_test'''
qt_sql_group_bit_and_Integer_agg_phase_1 '''
select count(id), group_bit_and(kint) from fn_test group by id order by id'''
qt_sql_group_bit_and_Integer_agg_phase_2 '''
select count(distinct id), group_bit_and(kint) from fn_test'''
qt_sql_group_bit_and_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(kint) from fn_test'''
qt_sql_group_bit_and_Integer_gb_notnull '''
select group_bit_and(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_and_Integer_notnull '''
select group_bit_and(kint) from fn_test_not_nullable'''
qt_sql_group_bit_and_Integer_agg_phase_1_notnull '''
select count(id), group_bit_and(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_and_Integer_agg_phase_2_notnull '''
select count(distinct id), group_bit_and(kint) from fn_test_not_nullable'''
qt_sql_group_bit_and_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(kint) from fn_test'''
qt_sql_group_bit_and_BigInt_gb '''
select group_bit_and(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_BigInt '''
select group_bit_and(kbint) from fn_test'''
qt_sql_group_bit_and_BigInt_agg_phase_1 '''
select count(id), group_bit_and(kbint) from fn_test group by id order by id'''
qt_sql_group_bit_and_BigInt_agg_phase_2 '''
select count(distinct id), group_bit_and(kbint) from fn_test'''
qt_sql_group_bit_and_BigInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_BigInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(kbint) from fn_test'''
qt_sql_group_bit_and_BigInt_gb_notnull '''
select group_bit_and(kbint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_and_BigInt_notnull '''
select group_bit_and(kbint) from fn_test_not_nullable'''
qt_sql_group_bit_and_BigInt_agg_phase_1_notnull '''
select count(id), group_bit_and(kbint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_and_BigInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_and(kbint) from fn_test_not_nullable'''
qt_sql_group_bit_and_BigInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_BigInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(kbint) from fn_test'''
qt_sql_group_bit_and_LargeInt_gb '''
select group_bit_and(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_LargeInt '''
select group_bit_and(klint) from fn_test'''
qt_sql_group_bit_and_LargeInt_agg_phase_1 '''
select count(id), group_bit_and(klint) from fn_test group by id order by id'''
qt_sql_group_bit_and_LargeInt_agg_phase_2 '''
select count(distinct id), group_bit_and(klint) from fn_test'''
qt_sql_group_bit_and_LargeInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_LargeInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(klint) from fn_test'''
qt_sql_group_bit_and_LargeInt_gb_notnull '''
select group_bit_and(klint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_and_LargeInt_notnull '''
select group_bit_and(klint) from fn_test_not_nullable'''
qt_sql_group_bit_and_LargeInt_agg_phase_1_notnull '''
select count(id), group_bit_and(klint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_and_LargeInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_and(klint) from fn_test_not_nullable'''
qt_sql_group_bit_and_LargeInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_and(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_and_LargeInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_and(klint) from fn_test'''
qt_sql_group_bit_or_TinyInt_gb '''
select group_bit_or(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_TinyInt '''
select group_bit_or(ktint) from fn_test'''
qt_sql_group_bit_or_TinyInt_agg_phase_1 '''
select count(id), group_bit_or(ktint) from fn_test group by id order by id'''
qt_sql_group_bit_or_TinyInt_agg_phase_2 '''
select count(distinct id), group_bit_or(ktint) from fn_test'''
qt_sql_group_bit_or_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(ktint) from fn_test'''
qt_sql_group_bit_or_TinyInt_gb_notnull '''
select group_bit_or(ktint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_or_TinyInt_notnull '''
select group_bit_or(ktint) from fn_test_not_nullable'''
qt_sql_group_bit_or_TinyInt_agg_phase_1_notnull '''
select count(id), group_bit_or(ktint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_or_TinyInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_or(ktint) from fn_test_not_nullable'''
qt_sql_group_bit_or_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(ktint) from fn_test'''
qt_sql_group_bit_or_SmallInt_gb '''
select group_bit_or(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_SmallInt '''
select group_bit_or(ksint) from fn_test'''
qt_sql_group_bit_or_SmallInt_agg_phase_1 '''
select count(id), group_bit_or(ksint) from fn_test group by id order by id'''
qt_sql_group_bit_or_SmallInt_agg_phase_2 '''
select count(distinct id), group_bit_or(ksint) from fn_test'''
qt_sql_group_bit_or_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(ksint) from fn_test'''
qt_sql_group_bit_or_SmallInt_gb_notnull '''
select group_bit_or(ksint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_or_SmallInt_notnull '''
select group_bit_or(ksint) from fn_test_not_nullable'''
qt_sql_group_bit_or_SmallInt_agg_phase_1_notnull '''
select count(id), group_bit_or(ksint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_or_SmallInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_or(ksint) from fn_test_not_nullable'''
qt_sql_group_bit_or_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(ksint) from fn_test'''
qt_sql_group_bit_or_Integer_gb '''
select group_bit_or(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_Integer '''
select group_bit_or(kint) from fn_test'''
qt_sql_group_bit_or_Integer_agg_phase_1 '''
select count(id), group_bit_or(kint) from fn_test group by id order by id'''
qt_sql_group_bit_or_Integer_agg_phase_2 '''
select count(distinct id), group_bit_or(kint) from fn_test'''
qt_sql_group_bit_or_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(kint) from fn_test'''
qt_sql_group_bit_or_Integer_gb_notnull '''
select group_bit_or(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_or_Integer_notnull '''
select group_bit_or(kint) from fn_test_not_nullable'''
qt_sql_group_bit_or_Integer_agg_phase_1_notnull '''
select count(id), group_bit_or(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_or_Integer_agg_phase_2_notnull '''
select count(distinct id), group_bit_or(kint) from fn_test_not_nullable'''
qt_sql_group_bit_or_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(kint) from fn_test'''
qt_sql_group_bit_or_BigInt_gb '''
select group_bit_or(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_BigInt '''
select group_bit_or(kbint) from fn_test'''
qt_sql_group_bit_or_BigInt_agg_phase_1 '''
select count(id), group_bit_or(kbint) from fn_test group by id order by id'''
qt_sql_group_bit_or_BigInt_agg_phase_2 '''
select count(distinct id), group_bit_or(kbint) from fn_test'''
qt_sql_group_bit_or_BigInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_BigInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(kbint) from fn_test'''
qt_sql_group_bit_or_BigInt_gb_notnull '''
select group_bit_or(kbint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_or_BigInt_notnull '''
select group_bit_or(kbint) from fn_test_not_nullable'''
qt_sql_group_bit_or_BigInt_agg_phase_1_notnull '''
select count(id), group_bit_or(kbint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_or_BigInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_or(kbint) from fn_test_not_nullable'''
qt_sql_group_bit_or_BigInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_BigInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(kbint) from fn_test'''
qt_sql_group_bit_or_LargeInt_gb '''
select group_bit_or(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_LargeInt '''
select group_bit_or(klint) from fn_test'''
qt_sql_group_bit_or_LargeInt_agg_phase_1 '''
select count(id), group_bit_or(klint) from fn_test group by id order by id'''
qt_sql_group_bit_or_LargeInt_agg_phase_2 '''
select count(distinct id), group_bit_or(klint) from fn_test'''
qt_sql_group_bit_or_LargeInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_LargeInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(klint) from fn_test'''
qt_sql_group_bit_or_LargeInt_gb_notnull '''
select group_bit_or(klint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_or_LargeInt_notnull '''
select group_bit_or(klint) from fn_test_not_nullable'''
qt_sql_group_bit_or_LargeInt_agg_phase_1_notnull '''
select count(id), group_bit_or(klint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_or_LargeInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_or(klint) from fn_test_not_nullable'''
qt_sql_group_bit_or_LargeInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_or(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_or_LargeInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_or(klint) from fn_test'''
qt_sql_group_bit_xor_TinyInt_gb '''
select group_bit_xor(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_TinyInt '''
select group_bit_xor(ktint) from fn_test'''
qt_sql_group_bit_xor_TinyInt_agg_phase_1 '''
select count(id), group_bit_xor(ktint) from fn_test group by id order by id'''
qt_sql_group_bit_xor_TinyInt_agg_phase_2 '''
select count(distinct id), group_bit_xor(ktint) from fn_test'''
qt_sql_group_bit_xor_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(ktint) from fn_test'''
qt_sql_group_bit_xor_TinyInt_gb_notnull '''
select group_bit_xor(ktint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_xor_TinyInt_notnull '''
select group_bit_xor(ktint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_TinyInt_agg_phase_1_notnull '''
select count(id), group_bit_xor(ktint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_xor_TinyInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_xor(ktint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(ktint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(ktint) from fn_test'''
qt_sql_group_bit_xor_SmallInt_gb '''
select group_bit_xor(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_SmallInt '''
select group_bit_xor(ksint) from fn_test'''
qt_sql_group_bit_xor_SmallInt_agg_phase_1 '''
select count(id), group_bit_xor(ksint) from fn_test group by id order by id'''
qt_sql_group_bit_xor_SmallInt_agg_phase_2 '''
select count(distinct id), group_bit_xor(ksint) from fn_test'''
qt_sql_group_bit_xor_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(ksint) from fn_test'''
qt_sql_group_bit_xor_SmallInt_gb_notnull '''
select group_bit_xor(ksint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_xor_SmallInt_notnull '''
select group_bit_xor(ksint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_SmallInt_agg_phase_1_notnull '''
select count(id), group_bit_xor(ksint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_xor_SmallInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_xor(ksint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(ksint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(ksint) from fn_test'''
qt_sql_group_bit_xor_Integer_gb '''
select group_bit_xor(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_Integer '''
select group_bit_xor(kint) from fn_test'''
qt_sql_group_bit_xor_Integer_agg_phase_1 '''
select count(id), group_bit_xor(kint) from fn_test group by id order by id'''
qt_sql_group_bit_xor_Integer_agg_phase_2 '''
select count(distinct id), group_bit_xor(kint) from fn_test'''
qt_sql_group_bit_xor_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(kint) from fn_test'''
qt_sql_group_bit_xor_Integer_gb_notnull '''
select group_bit_xor(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_xor_Integer_notnull '''
select group_bit_xor(kint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_Integer_agg_phase_1_notnull '''
select count(id), group_bit_xor(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_xor_Integer_agg_phase_2_notnull '''
select count(distinct id), group_bit_xor(kint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(kint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(kint) from fn_test'''
qt_sql_group_bit_xor_BigInt_gb '''
select group_bit_xor(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_BigInt '''
select group_bit_xor(kbint) from fn_test'''
qt_sql_group_bit_xor_BigInt_agg_phase_1 '''
select count(id), group_bit_xor(kbint) from fn_test group by id order by id'''
qt_sql_group_bit_xor_BigInt_agg_phase_2 '''
select count(distinct id), group_bit_xor(kbint) from fn_test'''
qt_sql_group_bit_xor_BigInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_BigInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(kbint) from fn_test'''
qt_sql_group_bit_xor_BigInt_gb_notnull '''
select group_bit_xor(kbint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_xor_BigInt_notnull '''
select group_bit_xor(kbint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_BigInt_agg_phase_1_notnull '''
select count(id), group_bit_xor(kbint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_xor_BigInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_xor(kbint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_BigInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(kbint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_BigInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(kbint) from fn_test'''
qt_sql_group_bit_xor_LargeInt_gb '''
select group_bit_xor(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_LargeInt '''
select group_bit_xor(klint) from fn_test'''
qt_sql_group_bit_xor_LargeInt_agg_phase_1 '''
select count(id), group_bit_xor(klint) from fn_test group by id order by id'''
qt_sql_group_bit_xor_LargeInt_agg_phase_2 '''
select count(distinct id), group_bit_xor(klint) from fn_test'''
qt_sql_group_bit_xor_LargeInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_LargeInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(klint) from fn_test'''
qt_sql_group_bit_xor_LargeInt_gb_notnull '''
select group_bit_xor(klint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bit_xor_LargeInt_notnull '''
select group_bit_xor(klint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_LargeInt_agg_phase_1_notnull '''
select count(id), group_bit_xor(klint) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bit_xor_LargeInt_agg_phase_2_notnull '''
select count(distinct id), group_bit_xor(klint) from fn_test_not_nullable'''
qt_sql_group_bit_xor_LargeInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bit_xor(klint) from fn_test group by kbool order by kbool'''
qt_sql_group_bit_xor_LargeInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bit_xor(klint) from fn_test'''
qt_sql_group_bitmap_xor_Bitmap_gb '''
select group_bitmap_xor(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_group_bitmap_xor_Bitmap '''
select group_bitmap_xor(bitmap_hash(kbint)) from fn_test'''
qt_sql_group_bitmap_xor_Bitmap_agg_phase_1 '''
select count(id), group_bitmap_xor(bitmap_hash(kbint)) from fn_test group by id order by id'''
qt_sql_group_bitmap_xor_Bitmap_agg_phase_2 '''
select count(distinct id), group_bitmap_xor(bitmap_hash(kbint)) from fn_test'''
qt_sql_group_bitmap_xor_Bitmap_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bitmap_xor(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_group_bitmap_xor_Bitmap_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bitmap_xor(bitmap_hash(kbint)) from fn_test'''
qt_sql_group_bitmap_xor_Bitmap_gb_notnull '''
select group_bitmap_xor(bitmap_hash(kbint)) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_group_bitmap_xor_Bitmap_notnull '''
select group_bitmap_xor(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_group_bitmap_xor_Bitmap_agg_phase_1_notnull '''
select count(id), group_bitmap_xor(bitmap_hash(kbint)) from fn_test_not_nullable group by id order by id'''
qt_sql_group_bitmap_xor_Bitmap_agg_phase_2_notnull '''
select count(distinct id), group_bitmap_xor(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_group_bitmap_xor_Bitmap_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), group_bitmap_xor(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_group_bitmap_xor_Bitmap_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), group_bitmap_xor(bitmap_hash(kbint)) from fn_test'''
// qt_sql_group_concat_Varchar_gb '''
// select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint)) from fn_test group by kbool order by kbool'''
// qt_sql_group_concat_Varchar '''
// select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint)) from fn_test'''
// qt_sql_group_concat_Varchar_agg_phase_1 '''
// select count(id), group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint)) from fn_test group by id order by id'''
// qt_sql_group_concat_Varchar_gb_notnull '''
// select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint)) from fn_test_not_nullable group by kbool order by kbool'''
// qt_sql_group_concat_Varchar_notnull '''
// select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint)) from fn_test_not_nullable'''
// qt_sql_group_concat_Varchar_agg_phase_1_notnull '''
// select count(id), group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint)) from fn_test_not_nullable group by id order by id'''
// qt_sql_group_concat_Varchar_AnyData_gb '''
// select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test group by kbool order by kbool'''
// qt_sql_group_concat_Varchar_AnyData '''
// select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test'''
// qt_sql_group_concat_Varchar_AnyData_agg_phase_1 '''
// select count(id), group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test group by id order by id'''
// qt_sql_group_concat_Varchar_AnyData_gb_notnull '''
// select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test_not_nullable group by kbool order by kbool'''
// qt_sql_group_concat_Varchar_AnyData_notnull '''
// select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test_not_nullable'''
// qt_sql_group_concat_Varchar_AnyData_agg_phase_1_notnull '''
// select count(id), group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test_not_nullable group by id order by id'''
// qt_sql_group_concat_Varchar_Varchar_AnyData_gb '''
// select group_concat(distinct cast(abs(kint) as varchar), '_x_' order by abs(ksint), kdt) from fn_test group by kbool order by kbool'''
// qt_sql_group_concat_Varchar_Varchar_AnyData '''
// select group_concat(distinct cast(abs(kint) as varchar), '_x_' order by abs(ksint), kdt) from fn_test'''
// qt_sql_group_concat_Varchar_Varchar_AnyData_agg_phase_1 '''
// select count(id), group_concat(distinct cast(abs(kint) as varchar), '_x_' order by abs(ksint), kdt) from fn_test group by id order by id'''
// qt_sql_group_concat_Varchar_Varchar_AnyData_gb_notnull '''
// select group_concat(distinct cast(abs(kint) as varchar), '_x_' order by abs(ksint), kdt) from fn_test_not_nullable group by kbool order by kbool'''
// qt_sql_group_concat_Varchar_Varchar_AnyData_notnull '''
// select group_concat(distinct cast(abs(kint) as varchar), '_x_' order by abs(ksint), kdt) from fn_test_not_nullable'''
// qt_sql_group_concat_Varchar_Varchar_AnyData_agg_phase_1_notnull '''
// select count(id), group_concat(distinct cast(abs(kint) as varchar), '_x_' order by abs(ksint), kdt) from fn_test_not_nullable group by id order by id'''
sql '''
select histogram(kbool) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kbool) from fn_test'''
sql '''
select histogram(kbool, 10) from fn_test'''
sql '''
select histogram(kbool, 10, 10) from fn_test'''
sql '''
select count(id), histogram(kbool) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kbool) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kbool) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kbool) from fn_test'''
sql '''
select histogram(kbool) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kbool) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kbool) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kbool) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kbool) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kbool) from fn_test'''
sql '''
select histogram(ktint) from fn_test group by kbool order by kbool'''
sql '''
select histogram(ktint) from fn_test'''
sql '''
select count(id), histogram(ktint) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(ktint) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(ktint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(ktint) from fn_test'''
sql '''
select histogram(ktint) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(ktint) from fn_test_not_nullable'''
sql '''
select count(id), histogram(ktint) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(ktint) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(ktint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(ktint) from fn_test'''
sql '''
select histogram(ksint) from fn_test group by kbool order by kbool'''
sql '''
select histogram(ksint) from fn_test'''
sql '''
select count(id), histogram(ksint) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(ksint) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(ksint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(ksint) from fn_test'''
sql '''
select histogram(ksint) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(ksint) from fn_test_not_nullable'''
sql '''
select count(id), histogram(ksint) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(ksint) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(ksint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(ksint) from fn_test'''
sql '''
select histogram(kint) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kint) from fn_test'''
sql '''
select count(id), histogram(kint) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kint) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kint) from fn_test'''
sql '''
select histogram(kint) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kint) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kint) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kint) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kint) from fn_test'''
sql '''
select histogram(kbint) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kbint) from fn_test'''
sql '''
select count(id), histogram(kbint) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kbint) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kbint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kbint) from fn_test'''
sql '''
select histogram(kbint) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kbint) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kbint) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kbint) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kbint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kbint) from fn_test'''
sql '''
select histogram(klint) from fn_test group by kbool order by kbool'''
sql '''
select histogram(klint) from fn_test'''
sql '''
select count(id), histogram(klint) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(klint) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(klint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(klint) from fn_test'''
sql '''
select histogram(klint) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(klint) from fn_test_not_nullable'''
sql '''
select count(id), histogram(klint) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(klint) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(klint) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(klint) from fn_test'''
sql '''
select histogram(kfloat) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kfloat) from fn_test'''
sql '''
select count(id), histogram(kfloat) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kfloat) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kfloat) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kfloat) from fn_test'''
sql '''
select histogram(kfloat) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kfloat) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kfloat) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kfloat) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kfloat) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kfloat) from fn_test'''
sql '''
select histogram(kdbl) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kdbl) from fn_test'''
sql '''
select count(id), histogram(kdbl) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kdbl) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdbl) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdbl) from fn_test'''
sql '''
select histogram(kdbl) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kdbl) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kdbl) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kdbl) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdbl) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdbl) from fn_test'''
sql '''
select histogram(kdcmls1) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kdcmls1) from fn_test'''
sql '''
select count(id), histogram(kdcmls1) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kdcmls1) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdcmls1) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdcmls1) from fn_test'''
sql '''
select histogram(kdcmls1) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kdcmls1) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kdcmls1) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kdcmls1) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdcmls1) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdcmls1) from fn_test'''
sql '''
select histogram(kdt) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kdt) from fn_test'''
sql '''
select count(id), histogram(kdt) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kdt) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdt) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdt) from fn_test'''
sql '''
select histogram(kdt) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kdt) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kdt) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kdt) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdt) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdt) from fn_test'''
sql '''
select histogram(kdtm) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kdtm) from fn_test'''
sql '''
select count(id), histogram(kdtm) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kdtm) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdtm) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdtm) from fn_test'''
sql '''
select histogram(kdtm) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kdtm) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kdtm) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kdtm) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdtm) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdtm) from fn_test'''
sql '''
select histogram(kdtv2) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kdtv2) from fn_test'''
sql '''
select count(id), histogram(kdtv2) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kdtv2) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdtv2) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdtv2) from fn_test'''
sql '''
select histogram(kdtv2) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kdtv2) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kdtv2) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kdtv2) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdtv2) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdtv2) from fn_test'''
sql '''
select histogram(kdtmv2s1) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kdtmv2s1) from fn_test'''
sql '''
select count(id), histogram(kdtmv2s1) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kdtmv2s1) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdtmv2s1) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdtmv2s1) from fn_test'''
sql '''
select histogram(kdtmv2s1) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kdtmv2s1) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kdtmv2s1) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kdtmv2s1) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kdtmv2s1) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kdtmv2s1) from fn_test'''
sql '''
select histogram(kchrs1) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kchrs1) from fn_test'''
sql '''
select count(id), histogram(kchrs1) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kchrs1) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kchrs1) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kchrs1) from fn_test'''
sql '''
select histogram(kchrs1) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kchrs1) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kchrs1) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kchrs1) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kchrs1) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kchrs1) from fn_test'''
sql '''
select histogram(kstr) from fn_test group by kbool order by kbool'''
sql '''
select histogram(kstr) from fn_test'''
sql '''
select count(id), histogram(kstr) from fn_test group by id order by id'''
sql '''
select count(distinct id), histogram(kstr) from fn_test'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kstr) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kstr) from fn_test'''
sql '''
select histogram(kstr) from fn_test_not_nullable group by kbool order by kbool'''
sql '''
select histogram(kstr) from fn_test_not_nullable'''
sql '''
select count(id), histogram(kstr) from fn_test_not_nullable group by id order by id'''
sql '''
select count(distinct id), histogram(kstr) from fn_test_not_nullable'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), histogram(kstr) from fn_test group by kbool order by kbool'''
sql '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), histogram(kstr) from fn_test'''
qt_sql_linear_histogram_TinyInt_gb '''
select linear_histogram(ktint, 2) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_TinyInt '''
select linear_histogram(ktint, 2) from fn_test'''
qt_sql_linear_histogram_TinyInt_offset '''
select linear_histogram(ktint, 2, 1) from fn_test'''
qt_sql_linear_histogram_TinyInt_agg_phase_1 '''
select count(id), linear_histogram(ktint, 2) from fn_test group by id order by id'''
qt_sql_linear_histogram_TinyInt_agg_phase_2 '''
select count(distinct id), linear_histogram(ktint, 2) from fn_test'''
qt_sql_linear_histogram_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(ktint, 2) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(ktint, 2) from fn_test'''
qt_sql_linear_histogram_TinyInt_gb_notnull '''
select linear_histogram(ktint, 2) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_linear_histogram_TinyInt_notnull '''
select linear_histogram(ktint, 2) from fn_test_not_nullable'''
qt_sql_linear_histogram_TinyInt_agg_phase_1_notnull '''
select count(id), linear_histogram(ktint, 2) from fn_test_not_nullable group by id order by id'''
qt_sql_linear_histogram_TinyInt_agg_phase_2_notnull '''
select count(distinct id), linear_histogram(ktint, 2) from fn_test_not_nullable'''
qt_sql_linear_histogram_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(ktint, 2) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(ktint, 2) from fn_test'''
qt_sql_linear_histogram_SmallInt_gb '''
select linear_histogram(ksint, 3) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_SmallInt '''
select linear_histogram(ksint, 3) from fn_test'''
qt_sql_linear_histogram_SmallInt_agg_phase_1 '''
select count(id), linear_histogram(ksint, 3) from fn_test group by id order by id'''
qt_sql_linear_histogram_SmallInt_agg_phase_2 '''
select count(distinct id), linear_histogram(ksint, 3) from fn_test'''
qt_sql_linear_histogram_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(ksint, 3) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(ksint, 3) from fn_test'''
qt_sql_linear_histogram_SmallInt_gb_notnull '''
select linear_histogram(ksint, 3) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_linear_histogram_SmallInt_notnull '''
select linear_histogram(ksint, 3) from fn_test_not_nullable'''
qt_sql_linear_histogram_SmallInt_agg_phase_1_notnull '''
select count(id), linear_histogram(ksint, 3) from fn_test_not_nullable group by id order by id'''
qt_sql_linear_histogram_SmallInt_agg_phase_2_notnull '''
select count(distinct id), linear_histogram(ksint, 3) from fn_test_not_nullable'''
qt_sql_linear_histogram_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(ksint, 3) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(ksint, 3) from fn_test'''
qt_sql_linear_histogram_Integer_gb '''
select linear_histogram(kint, 5) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_Integer '''
select linear_histogram(kint, 5) from fn_test'''
qt_sql_linear_histogram_Integer_agg_phase_1 '''
select count(id), linear_histogram(kint, 5) from fn_test group by id order by id'''
qt_sql_linear_histogram_Integer_agg_phase_2 '''
select count(distinct id), linear_histogram(kint, 5) from fn_test'''
qt_sql_linear_histogram_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(kint, 5) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(kint, 5) from fn_test'''
qt_sql_linear_histogram_Integer_gb_notnull '''
select linear_histogram(kint, 5) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_linear_histogram_Integer_notnull '''
select linear_histogram(kint, 5) from fn_test_not_nullable'''
qt_sql_linear_histogram_Integer_agg_phase_1_notnull '''
select count(id), linear_histogram(kint, 5) from fn_test_not_nullable group by id order by id'''
qt_sql_linear_histogram_Integer_agg_phase_2_notnull '''
select count(distinct id), linear_histogram(kint, 5) from fn_test_not_nullable'''
qt_sql_linear_histogram_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(kint, 5) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(kint, 5) from fn_test'''
qt_sql_linear_histogram_BigInt_gb '''
select linear_histogram(kbint, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_BigInt '''
select linear_histogram(kbint, 10) from fn_test'''
qt_sql_linear_histogram_BigInt_agg_phase_1 '''
select count(id), linear_histogram(kbint, 10) from fn_test group by id order by id'''
qt_sql_linear_histogram_BigInt_agg_phase_2 '''
select count(distinct id), linear_histogram(kbint, 10) from fn_test'''
qt_sql_linear_histogram_BigInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(kbint, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_BigInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(kbint, 10) from fn_test'''
qt_sql_linear_histogram_BigInt_gb_notnull '''
select linear_histogram(kbint, 10) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_linear_histogram_BigInt_notnull '''
select linear_histogram(kbint, 10) from fn_test_not_nullable'''
qt_sql_linear_histogram_BigInt_agg_phase_1_notnull '''
select count(id), linear_histogram(kbint, 10) from fn_test_not_nullable group by id order by id'''
qt_sql_linear_histogram_BigInt_agg_phase_2_notnull '''
select count(distinct id), linear_histogram(kbint, 10) from fn_test_not_nullable'''
qt_sql_linear_histogram_BigInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(kbint, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_BigInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(kbint, 10) from fn_test'''
qt_sql_linear_histogram_Double_gb '''
select linear_histogram(kdbl, 6.0) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_Double '''
select linear_histogram(kdbl, 6.0) from fn_test'''
qt_sql_linear_histogram_Double_agg_phase_1 '''
select count(id), linear_histogram(kdbl, 6.0) from fn_test group by id order by id'''
qt_sql_linear_histogram_Double_agg_phase_2 '''
select count(distinct id), linear_histogram(kdbl, 6.0) from fn_test'''
qt_sql_linear_histogram_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(kdbl, 6.0) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(kdbl, 6.0) from fn_test'''
qt_sql_linear_histogram_Double_gb_notnull '''
select linear_histogram(kdbl, 6.0) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_linear_histogram_Double_notnull '''
select linear_histogram(kdbl, 6.0) from fn_test_not_nullable'''
qt_sql_linear_histogram_Double_agg_phase_1_notnull '''
select count(id), linear_histogram(kdbl, 6.0) from fn_test_not_nullable group by id order by id'''
qt_sql_linear_histogram_Double_agg_phase_2_notnull '''
select count(distinct id), linear_histogram(kdbl, 6.0) from fn_test_not_nullable'''
qt_sql_linear_histogram_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(kdbl, 6.0) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(kdbl, 6.0) from fn_test'''
qt_sql_linear_histogram_DecimalV2_gb '''
select linear_histogram(kdcmls1, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_DecimalV2 '''
select linear_histogram(kdcmls1, 10) from fn_test'''
qt_sql_linear_histogram_DecimalV2_agg_phase_1 '''
select count(id), linear_histogram(kdcmls1, 10) from fn_test group by id order by id'''
qt_sql_linear_histogram_DecimalV2_agg_phase_2 '''
select count(distinct id), linear_histogram(kdcmls1, 10) from fn_test'''
qt_sql_linear_histogram_DecimalV2_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(kdcmls1, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_DecimalV2_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(kdcmls1, 10) from fn_test'''
qt_sql_linear_histogram_DecimalV2_gb_notnull '''
select linear_histogram(kdcmls1, 10) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_linear_histogram_DecimalV2_notnull '''
select linear_histogram(kdcmls1, 10) from fn_test_not_nullable'''
qt_sql_linear_histogram_DecimalV2_agg_phase_1_notnull '''
select count(id), linear_histogram(kdcmls1, 10) from fn_test_not_nullable group by id order by id'''
qt_sql_linear_histogram_DecimalV2_agg_phase_2_notnull '''
select count(distinct id), linear_histogram(kdcmls1, 10) from fn_test_not_nullable'''
qt_sql_linear_histogram_DecimalV2_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(kdcmls1, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_DecimalV2_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(kdcmls1, 10) from fn_test'''
qt_sql_linear_histogram_LargeInt_gb '''
select linear_histogram(klint, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_LargeInt '''
select linear_histogram(klint, 10) from fn_test'''
qt_sql_linear_histogram_LargeInt_agg_phase_1 '''
select count(id), linear_histogram(klint, 10) from fn_test group by id order by id'''
qt_sql_linear_histogram_LargeInt_agg_phase_2 '''
select count(distinct id), linear_histogram(klint, 10) from fn_test'''
qt_sql_linear_histogram_LargeInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(klint, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_LargeInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(klint, 10) from fn_test'''
qt_sql_linear_histogram_LargeInt_gb_notnull '''
select linear_histogram(klint, 10) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_linear_histogram_LargeInt_notnull '''
select linear_histogram(klint, 10) from fn_test_not_nullable'''
qt_sql_linear_histogram_LargeInt_agg_phase_1_notnull '''
select count(id), linear_histogram(klint, 10) from fn_test_not_nullable group by id order by id'''
qt_sql_linear_histogram_LargeInt_agg_phase_2_notnull '''
select count(distinct id), linear_histogram(klint, 10) from fn_test_not_nullable'''
qt_sql_linear_histogram_LargeInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), linear_histogram(klint, 10) from fn_test group by kbool order by kbool'''
qt_sql_linear_histogram_LargeInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), linear_histogram(klint, 10) from fn_test'''
qt_sql_max_by_AnyData_AnyData_gb '''
select max_by(kint, kint) from fn_test group by kbool order by kbool'''
qt_sql_max_by_AnyData_AnyData '''
select max_by(kint, kint) from fn_test'''
qt_sql_max_by_AnyData_AnyData_agg_phase_1 '''
select count(id), max_by(kint, kint) from fn_test group by id order by id'''
qt_sql_max_by_AnyData_AnyData_agg_phase_2 '''
select count(distinct id), max_by(kint, kint) from fn_test'''
qt_sql_max_by_AnyData_AnyData_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), max_by(kint, kint) from fn_test group by kbool order by kbool'''
qt_sql_max_by_AnyData_AnyData_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), max_by(kint, kint) from fn_test'''
qt_sql_max_by_AnyData_AnyData_gb_notnull '''
select max_by(kint, kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_max_by_AnyData_AnyData_notnull '''
select max_by(kint, kint) from fn_test_not_nullable'''
qt_sql_max_by_AnyData_AnyData_agg_phase_1_notnull '''
select count(id), max_by(kint, kint) from fn_test_not_nullable group by id order by id'''
qt_sql_max_by_AnyData_AnyData_agg_phase_2_notnull '''
select count(distinct id), max_by(kint, kint) from fn_test_not_nullable'''
qt_sql_max_by_AnyData_AnyData_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), max_by(kint, kint) from fn_test group by kbool order by kbool'''
qt_sql_max_by_AnyData_AnyData_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), max_by(kint, kint) from fn_test'''
qt_sql_min_by_AnyData_AnyData_gb '''
select min_by(kint, kint) from fn_test group by kbool order by kbool'''
qt_sql_min_by_AnyData_AnyData '''
select min_by(kint, kint) from fn_test'''
qt_sql_min_by_AnyData_AnyData_agg_phase_1 '''
select count(id), min_by(kint, kint) from fn_test group by id order by id'''
qt_sql_min_by_AnyData_AnyData_agg_phase_2 '''
select count(distinct id), min_by(kint, kint) from fn_test'''
qt_sql_min_by_AnyData_AnyData_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), min_by(kint, kint) from fn_test group by kbool order by kbool'''
qt_sql_min_by_AnyData_AnyData_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), min_by(kint, kint) from fn_test'''
qt_sql_min_by_AnyData_AnyData_gb_notnull '''
select min_by(kint, kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_min_by_AnyData_AnyData_notnull '''
select min_by(kint, kint) from fn_test_not_nullable'''
qt_sql_min_by_AnyData_AnyData_agg_phase_1_notnull '''
select count(id), min_by(kint, kint) from fn_test_not_nullable group by id order by id'''
qt_sql_min_by_AnyData_AnyData_agg_phase_2_notnull '''
select count(distinct id), min_by(kint, kint) from fn_test_not_nullable'''
qt_sql_min_by_AnyData_AnyData_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), min_by(kint, kint) from fn_test group by kbool order by kbool'''
qt_sql_min_by_AnyData_AnyData_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), min_by(kint, kint) from fn_test'''
qt_sql_ndv_AnyData_gb '''
select ndv(kint) from fn_test group by kbool order by kbool'''
qt_sql_ndv_AnyData '''
select ndv(kint) from fn_test'''
qt_sql_ndv_AnyData_agg_phase_1 '''
select count(id), ndv(kint) from fn_test group by id order by id'''
qt_sql_ndv_AnyData_agg_phase_2 '''
select count(distinct id), ndv(kint) from fn_test'''
qt_sql_ndv_AnyData_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), ndv(kint) from fn_test group by kbool order by kbool'''
qt_sql_ndv_AnyData_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), ndv(kint) from fn_test'''
qt_sql_ndv_AnyData_gb_notnull '''
select ndv(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_ndv_AnyData_notnull '''
select ndv(kint) from fn_test_not_nullable'''
qt_sql_ndv_AnyData_agg_phase_1_notnull '''
select count(id), ndv(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_ndv_AnyData_agg_phase_2_notnull '''
select count(distinct id), ndv(kint) from fn_test_not_nullable'''
qt_sql_ndv_AnyData_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), ndv(kint) from fn_test group by kbool order by kbool'''
qt_sql_ndv_AnyData_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), ndv(kint) from fn_test'''
// this function result is unstable
// qt_sql_orthogonal_bitmap_union_count_Bitmap_gb '''
// select orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_orthogonal_bitmap_union_count_Bitmap '''
select orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test'''
qt_sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_1 '''
select count(id), orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test group by id order by id'''
// qt_sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_2 '''
// select count(distinct id), orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test'''
// qt_sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_3 '''
// select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test'''
// this function result is unstable
// qt_sql_orthogonal_bitmap_union_count_Bitmap_gb_notnull '''
// select orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_orthogonal_bitmap_union_count_Bitmap_notnull '''
select orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test_not_nullable'''
qt_sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_1_notnull '''
select count(id), orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test_not_nullable group by id order by id'''
// qt_sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_2_notnull '''
// select count(distinct id), orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test_not_nullable'''
// qt_sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_3_notnull '''
// select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test group by kbool order by kbool'''
qt_sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), orthogonal_bitmap_union_count(bitmap_hash(kbint)) from fn_test'''
qt_sql_percentile_BigInt_Double_gb '''
select percentile(kbint, 0.6) from fn_test group by kbool order by kbool'''
qt_sql_percentile_BigInt_Double '''
select percentile(kbint, 0.6) from fn_test'''
qt_sql_percentile_Null_Empty '''
select percentile(1, 0.6) from fn_test where kbint > 100;'''
qt_sql_percentile_BigInt_Double_agg_phase_1 '''
select count(id), percentile(kbint, 0.6) from fn_test group by id order by id'''
qt_sql_percentile_BigInt_Double_agg_phase_2 '''
select count(distinct id), percentile(kbint, 0.6) from fn_test'''
qt_sql_percentile_BigInt_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), percentile(kbint, 0.6) from fn_test group by kbool order by kbool'''
qt_sql_percentile_BigInt_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), percentile(kbint, 0.6) from fn_test'''
qt_sql_percentile_BigInt_Double_gb_notnull '''
select percentile(kbint, 0.6) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_percentile_BigInt_Double_notnull '''
select percentile(kbint, 0.6) from fn_test_not_nullable'''
qt_sql_percentile_BigInt_Double_agg_phase_1_notnull '''
select count(id), percentile(kbint, 0.6) from fn_test_not_nullable group by id order by id'''
qt_sql_percentile_BigInt_Double_agg_phase_2_notnull '''
select count(distinct id), percentile(kbint, 0.6) from fn_test_not_nullable'''
qt_sql_percentile_BigInt_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), percentile(kbint, 0.6) from fn_test group by kbool order by kbool'''
qt_sql_percentile_BigInt_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), percentile(kbint, 0.6) from fn_test'''
qt_sql_percentile_approx_Double_Double_gb '''
select percentile_approx(kdbl, 0.6) from fn_test group by kbool order by kbool'''
qt_sql_percentile_approx_Double_Double '''
select percentile_approx(kdbl, 0.6) from fn_test'''
qt_sql_percentile_approx_Double_Double_agg_phase_1 '''
select count(id), percentile_approx(kdbl, 0.6) from fn_test group by id order by id'''
qt_sql_percentile_approx_Double_Double_agg_phase_2 '''
select count(distinct id), percentile_approx(kdbl, 0.6) from fn_test'''
qt_sql_percentile_approx_Double_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), percentile_approx(kdbl, 0.6) from fn_test group by kbool order by kbool'''
qt_sql_percentile_approx_Double_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), percentile_approx(kdbl, 0.6) from fn_test'''
qt_sql_percentile_approx_Double_Double_gb_notnull '''
select percentile_approx(kdbl, 0.6) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_percentile_approx_Double_Double_notnull '''
select percentile_approx(kdbl, 0.6) from fn_test_not_nullable'''
qt_sql_percentile_approx_Double_Double_agg_phase_1_notnull '''
select count(id), percentile_approx(kdbl, 0.6) from fn_test_not_nullable group by id order by id'''
qt_sql_percentile_approx_Double_Double_agg_phase_2_notnull '''
select count(distinct id), percentile_approx(kdbl, 0.6) from fn_test_not_nullable'''
qt_sql_percentile_approx_Double_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), percentile_approx(kdbl, 0.6) from fn_test group by kbool order by kbool'''
qt_sql_percentile_approx_Double_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), percentile_approx(kdbl, 0.6) from fn_test'''
qt_sql_percentile_approx_Double_Double_Double_gb '''
select percentile_approx(kdbl, 0.6, 4096.0) from fn_test group by kbool order by kbool'''
qt_sql_percentile_approx_Double_Double_Double '''
select percentile_approx(kdbl, 0.6, 4096.0) from fn_test'''
qt_sql_percentile_approx_Double_Double_Double_agg_phase_1 '''
select count(id), percentile_approx(kdbl, 0.6, 4096.0) from fn_test group by id order by id'''
qt_sql_percentile_approx_Double_Double_Double_agg_phase_2 '''
select count(distinct id), percentile_approx(kdbl, 0.6, 4096.0) from fn_test'''
qt_sql_percentile_approx_Double_Double_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), percentile_approx(kdbl, 0.6, 4096.0) from fn_test group by kbool order by kbool'''
qt_sql_percentile_approx_Double_Double_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), percentile_approx(kdbl, 0.6, 4096.0) from fn_test'''
qt_sql_percentile_approx_Double_Double_Double_gb_notnull '''
select percentile_approx(kdbl, 0.6, 4096.0) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_percentile_approx_Double_Double_Double_notnull '''
select percentile_approx(kdbl, 0.6, 4096.0) from fn_test_not_nullable'''
qt_sql_percentile_approx_Double_Double_Double_agg_phase_1_notnull '''
select count(id), percentile_approx(kdbl, 0.6, 4096.0) from fn_test_not_nullable group by id order by id'''
qt_sql_percentile_approx_Double_Double_Double_agg_phase_2_notnull '''
select count(distinct id), percentile_approx(kdbl, 0.6, 4096.0) from fn_test_not_nullable'''
qt_sql_percentile_approx_Double_Double_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), percentile_approx(kdbl, 0.6, 4096.0) from fn_test group by kbool order by kbool'''
qt_sql_percentile_approx_Double_Double_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), percentile_approx(kdbl, 0.6, 4096.0) from fn_test'''
qt_sql_sequence_count_String_DateV2_Boolean_gb '''
select sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateV2_Boolean '''
select sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_count_String_DateV2_Boolean_agg_phase_1 '''
select count(id), sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test group by id order by id'''
qt_sql_sequence_count_String_DateV2_Boolean_agg_phase_2 '''
select count(distinct id), sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_count_String_DateV2_Boolean_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateV2_Boolean_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_count_String_DateV2_Boolean_gb_notnull '''
select sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sequence_count_String_DateV2_Boolean_notnull '''
select sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_count_String_DateV2_Boolean_agg_phase_1_notnull '''
select count(id), sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test_not_nullable group by id order by id'''
qt_sql_sequence_count_String_DateV2_Boolean_agg_phase_2_notnull '''
select count(distinct id), sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_count_String_DateV2_Boolean_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateV2_Boolean_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_count('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_count_String_DateTime_Boolean_gb '''
select sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateTime_Boolean '''
select sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_count_String_DateTime_Boolean_agg_phase_1 '''
select count(id), sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test group by id order by id'''
qt_sql_sequence_count_String_DateTime_Boolean_agg_phase_2 '''
select count(distinct id), sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_count_String_DateTime_Boolean_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateTime_Boolean_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_count_String_DateTime_Boolean_gb_notnull '''
select sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sequence_count_String_DateTime_Boolean_notnull '''
select sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_count_String_DateTime_Boolean_agg_phase_1_notnull '''
select count(id), sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test_not_nullable group by id order by id'''
qt_sql_sequence_count_String_DateTime_Boolean_agg_phase_2_notnull '''
select count(distinct id), sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_count_String_DateTime_Boolean_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateTime_Boolean_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_count('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_gb '''
select sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateTimeV2_Boolean '''
select sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_1 '''
select count(id), sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test group by id order by id'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_2 '''
select count(distinct id), sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_gb_notnull '''
select sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_notnull '''
select sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test_not_nullable'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_1_notnull '''
select count(id), sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test_not_nullable group by id order by id'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_2_notnull '''
select count(distinct id), sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test_not_nullable'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test group by kbool order by kbool'''
qt_sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_count('(?1)(?2)', kdtmv2s1, kint = 1, kint = 5) from fn_test'''
qt_sql_sequence_match_String_DateV2_Boolean_gb '''
select sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateV2_Boolean '''
select sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateV2_Boolean_agg_phase_1 '''
select count(id), sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test group by id order by id'''
qt_sql_sequence_match_String_DateV2_Boolean_agg_phase_2 '''
select count(distinct id), sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateV2_Boolean_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateV2_Boolean_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateV2_Boolean_gb_notnull '''
select sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sequence_match_String_DateV2_Boolean_notnull '''
select sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_match_String_DateV2_Boolean_agg_phase_1_notnull '''
select count(id), sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test_not_nullable group by id order by id'''
qt_sql_sequence_match_String_DateV2_Boolean_agg_phase_2_notnull '''
select count(distinct id), sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_match_String_DateV2_Boolean_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateV2_Boolean_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_match('(?1)(?2)', kdtv2, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateTime_Boolean_gb '''
select sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateTime_Boolean '''
select sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateTime_Boolean_agg_phase_1 '''
select count(id), sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test group by id order by id'''
qt_sql_sequence_match_String_DateTime_Boolean_agg_phase_2 '''
select count(distinct id), sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateTime_Boolean_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateTime_Boolean_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateTime_Boolean_gb_notnull '''
select sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sequence_match_String_DateTime_Boolean_notnull '''
select sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_match_String_DateTime_Boolean_agg_phase_1_notnull '''
select count(id), sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test_not_nullable group by id order by id'''
qt_sql_sequence_match_String_DateTime_Boolean_agg_phase_2_notnull '''
select count(distinct id), sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_match_String_DateTime_Boolean_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateTime_Boolean_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_match('(?1)(?2)', kdtm, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_gb '''
select sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateTimeV2_Boolean '''
select sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_1 '''
select count(id), sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test group by id order by id'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_2 '''
select count(distinct id), sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_gb_notnull '''
select sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_notnull '''
select sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_1_notnull '''
select count(id), sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test_not_nullable group by id order by id'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_2_notnull '''
select count(distinct id), sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test_not_nullable'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test group by kbool order by kbool'''
qt_sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sequence_match('(?1)(?2)', kdtmv2s1, kint = 1, kint = 2) from fn_test'''
qt_sql_stddev_TinyInt_gb '''
select stddev(ktint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_TinyInt '''
select stddev(ktint) from fn_test'''
qt_sql_stddev_TinyInt_agg_phase_1 '''
select count(id), stddev(ktint) from fn_test group by id order by id'''
qt_sql_stddev_TinyInt_agg_phase_2 '''
select count(distinct id), stddev(ktint) from fn_test'''
qt_sql_stddev_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(ktint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(ktint) from fn_test'''
qt_sql_stddev_TinyInt_gb_notnull '''
select stddev(ktint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_TinyInt_notnull '''
select stddev(ktint) from fn_test_not_nullable'''
qt_sql_stddev_TinyInt_agg_phase_1_notnull '''
select count(id), stddev(ktint) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_TinyInt_agg_phase_2_notnull '''
select count(distinct id), stddev(ktint) from fn_test_not_nullable'''
qt_sql_stddev_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(ktint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(ktint) from fn_test'''
qt_sql_stddev_SmallInt_gb '''
select stddev(ksint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_SmallInt '''
select stddev(ksint) from fn_test'''
qt_sql_stddev_SmallInt_agg_phase_1 '''
select count(id), stddev(ksint) from fn_test group by id order by id'''
qt_sql_stddev_SmallInt_agg_phase_2 '''
select count(distinct id), stddev(ksint) from fn_test'''
qt_sql_stddev_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(ksint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(ksint) from fn_test'''
qt_sql_stddev_SmallInt_gb_notnull '''
select stddev(ksint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_SmallInt_notnull '''
select stddev(ksint) from fn_test_not_nullable'''
qt_sql_stddev_SmallInt_agg_phase_1_notnull '''
select count(id), stddev(ksint) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_SmallInt_agg_phase_2_notnull '''
select count(distinct id), stddev(ksint) from fn_test_not_nullable'''
qt_sql_stddev_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(ksint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(ksint) from fn_test'''
qt_sql_stddev_Integer_gb '''
select stddev(kint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Integer '''
select stddev(kint) from fn_test'''
qt_sql_stddev_Integer_agg_phase_1 '''
select count(id), stddev(kint) from fn_test group by id order by id'''
qt_sql_stddev_Integer_agg_phase_2 '''
select count(distinct id), stddev(kint) from fn_test'''
qt_sql_stddev_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kint) from fn_test'''
qt_sql_stddev_Integer_gb_notnull '''
select stddev(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_Integer_notnull '''
select stddev(kint) from fn_test_not_nullable'''
qt_sql_stddev_Integer_agg_phase_1_notnull '''
select count(id), stddev(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_Integer_agg_phase_2_notnull '''
select count(distinct id), stddev(kint) from fn_test_not_nullable'''
qt_sql_stddev_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kint) from fn_test'''
qt_sql_stddev_BigInt_gb '''
select stddev(kbint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_BigInt '''
select stddev(kbint) from fn_test'''
qt_sql_stddev_BigInt_agg_phase_1 '''
select count(id), stddev(kbint) from fn_test group by id order by id'''
qt_sql_stddev_BigInt_agg_phase_2 '''
select count(distinct id), stddev(kbint) from fn_test'''
qt_sql_stddev_BigInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kbint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_BigInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kbint) from fn_test'''
qt_sql_stddev_BigInt_gb_notnull '''
select stddev(kbint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_BigInt_notnull '''
select stddev(kbint) from fn_test_not_nullable'''
qt_sql_stddev_BigInt_agg_phase_1_notnull '''
select count(id), stddev(kbint) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_BigInt_agg_phase_2_notnull '''
select count(distinct id), stddev(kbint) from fn_test_not_nullable'''
qt_sql_stddev_BigInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kbint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_BigInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kbint) from fn_test'''
qt_sql_stddev_Float_gb '''
select stddev(kfloat) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Float '''
select stddev(kfloat) from fn_test'''
qt_sql_stddev_Float_agg_phase_1 '''
select count(id), stddev(kfloat) from fn_test group by id order by id'''
qt_sql_stddev_Float_agg_phase_2 '''
select count(distinct id), stddev(kfloat) from fn_test'''
qt_sql_stddev_Float_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kfloat) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Float_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kfloat) from fn_test'''
qt_sql_stddev_Float_gb_notnull '''
select stddev(kfloat) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_Float_notnull '''
select stddev(kfloat) from fn_test_not_nullable'''
qt_sql_stddev_Float_agg_phase_1_notnull '''
select count(id), stddev(kfloat) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_Float_agg_phase_2_notnull '''
select count(distinct id), stddev(kfloat) from fn_test_not_nullable'''
qt_sql_stddev_Float_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kfloat) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Float_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kfloat) from fn_test'''
qt_sql_stddev_Double_gb '''
select stddev(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Double '''
select stddev(kdbl) from fn_test'''
qt_sql_stddev_Double_agg_phase_1 '''
select count(id), stddev(kdbl) from fn_test group by id order by id'''
qt_sql_stddev_Double_agg_phase_2 '''
select count(distinct id), stddev(kdbl) from fn_test'''
qt_sql_stddev_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kdbl) from fn_test'''
qt_sql_stddev_Double_gb_notnull '''
select stddev(kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_Double_notnull '''
select stddev(kdbl) from fn_test_not_nullable'''
qt_sql_stddev_Double_agg_phase_1_notnull '''
select count(id), stddev(kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_Double_agg_phase_2_notnull '''
select count(distinct id), stddev(kdbl) from fn_test_not_nullable'''
qt_sql_stddev_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_stddev_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kdbl) from fn_test'''
qt_sql_stddev_DecimalV2_gb '''
select stddev(kdcmls1) from fn_test group by kbool order by kbool'''
// qt_sql_stddev_DecimalV2 '''
// select stddev(kdcmls1) from fn_test'''
qt_sql_stddev_DecimalV2_agg_phase_1 '''
select count(id), stddev(kdcmls1) from fn_test group by id order by id'''
qt_sql_stddev_DecimalV2_agg_phase_2 '''
select count(distinct id), stddev(kdcmls1) from fn_test'''
qt_sql_stddev_DecimalV2_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kdcmls1) from fn_test group by kbool order by kbool'''
qt_sql_stddev_DecimalV2_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kdcmls1) from fn_test'''
qt_sql_stddev_DecimalV2_gb_notnull '''
select stddev(kdcmls1) from fn_test_not_nullable group by kbool order by kbool'''
// qt_sql_stddev_DecimalV2_notnull '''
// select stddev(kdcmls1) from fn_test_not_nullable'''
qt_sql_stddev_DecimalV2_agg_phase_1_notnull '''
select count(id), stddev(kdcmls1) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_DecimalV2_agg_phase_2_notnull '''
select count(distinct id), stddev(kdcmls1) from fn_test_not_nullable'''
qt_sql_stddev_DecimalV2_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev(kdcmls1) from fn_test group by kbool order by kbool'''
qt_sql_stddev_DecimalV2_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev(kdcmls1) from fn_test'''
qt_sql_stddev_samp_TinyInt_gb '''
select stddev_samp(ktint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_TinyInt '''
select stddev_samp(ktint) from fn_test'''
qt_sql_stddev_samp_TinyInt_agg_phase_1 '''
select count(id), stddev_samp(ktint) from fn_test group by id order by id'''
qt_sql_stddev_samp_TinyInt_agg_phase_2 '''
select count(distinct id), stddev_samp(ktint) from fn_test'''
qt_sql_stddev_samp_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(ktint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(ktint) from fn_test'''
qt_sql_stddev_samp_TinyInt_gb_notnull '''
select stddev_samp(ktint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_samp_TinyInt_notnull '''
select stddev_samp(ktint) from fn_test_not_nullable'''
qt_sql_stddev_samp_TinyInt_agg_phase_1_notnull '''
select count(id), stddev_samp(ktint) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_samp_TinyInt_agg_phase_2_notnull '''
select count(distinct id), stddev_samp(ktint) from fn_test_not_nullable'''
qt_sql_stddev_samp_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(ktint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(ktint) from fn_test'''
qt_sql_stddev_samp_SmallInt_gb '''
select stddev_samp(ksint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_SmallInt '''
select stddev_samp(ksint) from fn_test'''
qt_sql_stddev_samp_SmallInt_agg_phase_1 '''
select count(id), stddev_samp(ksint) from fn_test group by id order by id'''
qt_sql_stddev_samp_SmallInt_agg_phase_2 '''
select count(distinct id), stddev_samp(ksint) from fn_test'''
qt_sql_stddev_samp_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(ksint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(ksint) from fn_test'''
qt_sql_stddev_samp_SmallInt_gb_notnull '''
select stddev_samp(ksint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_samp_SmallInt_notnull '''
select stddev_samp(ksint) from fn_test_not_nullable'''
qt_sql_stddev_samp_SmallInt_agg_phase_1_notnull '''
select count(id), stddev_samp(ksint) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_samp_SmallInt_agg_phase_2_notnull '''
select count(distinct id), stddev_samp(ksint) from fn_test_not_nullable'''
qt_sql_stddev_samp_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(ksint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(ksint) from fn_test'''
qt_sql_stddev_samp_Integer_gb '''
select stddev_samp(kint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Integer '''
select stddev_samp(kint) from fn_test'''
qt_sql_stddev_samp_Integer_agg_phase_1 '''
select count(id), stddev_samp(kint) from fn_test group by id order by id'''
qt_sql_stddev_samp_Integer_agg_phase_2 '''
select count(distinct id), stddev_samp(kint) from fn_test'''
qt_sql_stddev_samp_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kint) from fn_test'''
qt_sql_stddev_samp_Integer_gb_notnull '''
select stddev_samp(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_samp_Integer_notnull '''
select stddev_samp(kint) from fn_test_not_nullable'''
qt_sql_stddev_samp_Integer_agg_phase_1_notnull '''
select count(id), stddev_samp(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_samp_Integer_agg_phase_2_notnull '''
select count(distinct id), stddev_samp(kint) from fn_test_not_nullable'''
qt_sql_stddev_samp_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kint) from fn_test'''
qt_sql_stddev_samp_BigInt_gb '''
select stddev_samp(kbint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_BigInt '''
select stddev_samp(kbint) from fn_test'''
qt_sql_stddev_samp_BigInt_agg_phase_1 '''
select count(id), stddev_samp(kbint) from fn_test group by id order by id'''
qt_sql_stddev_samp_BigInt_agg_phase_2 '''
select count(distinct id), stddev_samp(kbint) from fn_test'''
qt_sql_stddev_samp_BigInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kbint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_BigInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kbint) from fn_test'''
qt_sql_stddev_samp_BigInt_gb_notnull '''
select stddev_samp(kbint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_samp_BigInt_notnull '''
select stddev_samp(kbint) from fn_test_not_nullable'''
qt_sql_stddev_samp_BigInt_agg_phase_1_notnull '''
select count(id), stddev_samp(kbint) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_samp_BigInt_agg_phase_2_notnull '''
select count(distinct id), stddev_samp(kbint) from fn_test_not_nullable'''
qt_sql_stddev_samp_BigInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kbint) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_BigInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kbint) from fn_test'''
qt_sql_stddev_samp_Float_gb '''
select stddev_samp(kfloat) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Float '''
select stddev_samp(kfloat) from fn_test'''
qt_sql_stddev_samp_Float_agg_phase_1 '''
select count(id), stddev_samp(kfloat) from fn_test group by id order by id'''
qt_sql_stddev_samp_Float_agg_phase_2 '''
select count(distinct id), stddev_samp(kfloat) from fn_test'''
qt_sql_stddev_samp_Float_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kfloat) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Float_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kfloat) from fn_test'''
qt_sql_stddev_samp_Float_gb_notnull '''
select stddev_samp(kfloat) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_samp_Float_notnull '''
select stddev_samp(kfloat) from fn_test_not_nullable'''
qt_sql_stddev_samp_Float_agg_phase_1_notnull '''
select count(id), stddev_samp(kfloat) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_samp_Float_agg_phase_2_notnull '''
select count(distinct id), stddev_samp(kfloat) from fn_test_not_nullable'''
qt_sql_stddev_samp_Float_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kfloat) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Float_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kfloat) from fn_test'''
qt_sql_stddev_samp_Double_gb '''
select stddev_samp(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Double '''
select stddev_samp(kdbl) from fn_test'''
qt_sql_stddev_samp_Double_agg_phase_1 '''
select count(id), stddev_samp(kdbl) from fn_test group by id order by id'''
qt_sql_stddev_samp_Double_agg_phase_2 '''
select count(distinct id), stddev_samp(kdbl) from fn_test'''
qt_sql_stddev_samp_Double_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Double_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kdbl) from fn_test'''
qt_sql_stddev_samp_Double_gb_notnull '''
select stddev_samp(kdbl) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_stddev_samp_Double_notnull '''
select stddev_samp(kdbl) from fn_test_not_nullable'''
qt_sql_stddev_samp_Double_agg_phase_1_notnull '''
select count(id), stddev_samp(kdbl) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_samp_Double_agg_phase_2_notnull '''
select count(distinct id), stddev_samp(kdbl) from fn_test_not_nullable'''
qt_sql_stddev_samp_Double_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kdbl) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_Double_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kdbl) from fn_test'''
// qt_sql_stddev_samp_DecimalV2_gb '''
// select stddev_samp(kdcmls1) from fn_test group by kbool order by kbool'''
// qt_sql_stddev_samp_DecimalV2 '''
// select stddev_samp(kdcmls1) from fn_test'''
qt_sql_stddev_samp_DecimalV2_agg_phase_1 '''
select count(id), stddev_samp(kdcmls1) from fn_test group by id order by id'''
qt_sql_stddev_samp_DecimalV2_agg_phase_2 '''
select count(distinct id), stddev_samp(kdcmls1) from fn_test'''
qt_sql_stddev_samp_DecimalV2_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kdcmls1) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_DecimalV2_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kdcmls1) from fn_test'''
// qt_sql_stddev_samp_DecimalV2_gb_notnull '''
// select stddev_samp(kdcmls1) from fn_test_not_nullable group by kbool order by kbool'''
// qt_sql_stddev_samp_DecimalV2_notnull '''
// select stddev_samp(kdcmls1) from fn_test_not_nullable'''
qt_sql_stddev_samp_DecimalV2_agg_phase_1_notnull '''
select count(id), stddev_samp(kdcmls1) from fn_test_not_nullable group by id order by id'''
qt_sql_stddev_samp_DecimalV2_agg_phase_2_notnull '''
select count(distinct id), stddev_samp(kdcmls1) from fn_test_not_nullable'''
qt_sql_stddev_samp_DecimalV2_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), stddev_samp(kdcmls1) from fn_test group by kbool order by kbool'''
qt_sql_stddev_samp_DecimalV2_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), stddev_samp(kdcmls1) from fn_test'''
qt_sql_sum_Boolean '''
select sum(kbool) from fn_test'''
qt_sql_sum_Boolean_gb '''
select sum(kbool) from fn_test group by id order by id'''
qt_sql_sum_TinyInt_gb '''
select sum(ktint) from fn_test group by kbool order by kbool'''
qt_sql_sum_TinyInt '''
select sum(ktint) from fn_test'''
qt_sql_sum_TinyInt_agg_phase_1 '''
select count(id), sum(ktint) from fn_test group by id order by id'''
qt_sql_sum_TinyInt_agg_phase_2 '''
select count(distinct id), sum(ktint) from fn_test'''
qt_sql_sum_TinyInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sum(ktint) from fn_test group by kbool order by kbool'''
qt_sql_sum_TinyInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sum(ktint) from fn_test'''
qt_sql_sum_TinyInt_gb_notnull '''
select sum(ktint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sum_TinyInt_notnull '''
select sum(ktint) from fn_test_not_nullable'''
qt_sql_sum_TinyInt_agg_phase_1_notnull '''
select count(id), sum(ktint) from fn_test_not_nullable group by id order by id'''
qt_sql_sum_TinyInt_agg_phase_2_notnull '''
select count(distinct id), sum(ktint) from fn_test_not_nullable'''
qt_sql_sum_TinyInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sum(ktint) from fn_test group by kbool order by kbool'''
qt_sql_sum_TinyInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sum(ktint) from fn_test'''
qt_sql_sum_SmallInt_gb '''
select sum(ksint) from fn_test group by kbool order by kbool'''
qt_sql_sum_SmallInt '''
select sum(ksint) from fn_test'''
qt_sql_sum_SmallInt_agg_phase_1 '''
select count(id), sum(ksint) from fn_test group by id order by id'''
qt_sql_sum_SmallInt_agg_phase_2 '''
select count(distinct id), sum(ksint) from fn_test'''
qt_sql_sum_SmallInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sum(ksint) from fn_test group by kbool order by kbool'''
qt_sql_sum_SmallInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sum(ksint) from fn_test'''
qt_sql_sum_SmallInt_gb_notnull '''
select sum(ksint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sum_SmallInt_notnull '''
select sum(ksint) from fn_test_not_nullable'''
qt_sql_sum_SmallInt_agg_phase_1_notnull '''
select count(id), sum(ksint) from fn_test_not_nullable group by id order by id'''
qt_sql_sum_SmallInt_agg_phase_2_notnull '''
select count(distinct id), sum(ksint) from fn_test_not_nullable'''
qt_sql_sum_SmallInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sum(ksint) from fn_test group by kbool order by kbool'''
qt_sql_sum_SmallInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sum(ksint) from fn_test'''
qt_sql_sum_Integer_gb '''
select sum(kint) from fn_test group by kbool order by kbool'''
qt_sql_sum_Integer '''
select sum(kint) from fn_test'''
qt_sql_sum_Integer_agg_phase_1 '''
select count(id), sum(kint) from fn_test group by id order by id'''
qt_sql_sum_Integer_agg_phase_2 '''
select count(distinct id), sum(kint) from fn_test'''
qt_sql_sum_Integer_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sum(kint) from fn_test group by kbool order by kbool'''
qt_sql_sum_Integer_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sum(kint) from fn_test'''
qt_sql_sum_Integer_gb_notnull '''
select sum(kint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sum_Integer_notnull '''
select sum(kint) from fn_test_not_nullable'''
qt_sql_sum_Integer_agg_phase_1_notnull '''
select count(id), sum(kint) from fn_test_not_nullable group by id order by id'''
qt_sql_sum_Integer_agg_phase_2_notnull '''
select count(distinct id), sum(kint) from fn_test_not_nullable'''
qt_sql_sum_Integer_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sum(kint) from fn_test group by kbool order by kbool'''
qt_sql_sum_Integer_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sum(kint) from fn_test'''
qt_sql_sum_BigInt_gb '''
select sum(kbint) from fn_test group by kbool order by kbool'''
qt_sql_sum_BigInt '''
select sum(kbint) from fn_test'''
qt_sql_sum_BigInt_agg_phase_1 '''
select count(id), sum(kbint) from fn_test group by id order by id'''
qt_sql_sum_BigInt_agg_phase_2 '''
select count(distinct id), sum(kbint) from fn_test'''
qt_sql_sum_BigInt_agg_phase_3 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sum(kbint) from fn_test group by kbool order by kbool'''
qt_sql_sum_BigInt_agg_phase_4 '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sum(kbint) from fn_test'''
qt_sql_sum_BigInt_gb_notnull '''
select sum(kbint) from fn_test_not_nullable group by kbool order by kbool'''
qt_sql_sum_BigInt_notnull '''
select sum(kbint) from fn_test_not_nullable'''
qt_sql_sum_BigInt_agg_phase_1_notnull '''
select count(id), sum(kbint) from fn_test_not_nullable group by id order by id'''
qt_sql_sum_BigInt_agg_phase_2_notnull '''
select count(distinct id), sum(kbint) from fn_test_not_nullable'''
qt_sql_sum_BigInt_agg_phase_3_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), sum(kbint) from fn_test group by kbool order by kbool'''
qt_sql_sum_BigInt_agg_phase_4_notnull '''
select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), sum(kbint) from fn_test'''
//not cast float to double
explain {
sql("select sum(kfloat) from fn_test;")
contains "partial_sum(kfloat"
}