SWJTU-ZhangLei opened a new issue, #8922: URL: https://github.com/apache/incubator-doris/issues/8922
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version MySQL [regression_test_zhanglei_aggregate]> select stddev_pop(distinct c_bigint), stddev_pop(c_double) from datetype; +---------------------------------+------------------------+ | stddev_pop(DISTINCT `c_bigint`) | stddev_pop(`c_double`) | +---------------------------------+------------------------+ | 3145.0576394647451 | 35.210273031541988 | +---------------------------------+------------------------+ 1 row in set (0.008 sec) MySQL [regression_test_zhanglei_aggregate]> select stddev_pop(c_bigint), stddev_pop(c_double) from datetype; +------------------------+------------------------+ | stddev_pop(`c_bigint`) | stddev_pop(`c_double`) | +------------------------+------------------------+ | 3037.0783723835643 | 35.210273031541995 | +------------------------+------------------------+ 1 row in set (0.005 sec) MySQL [regression_test_zhanglei_aggregate]> show globals; ERROR 1105 (HY000): errCode = 2, detailMessage = Syntax error in line 1: show globals ^ Encountered: IDENTIFIER Expected MySQL [regression_test_zhanglei_aggregate]> select stddev_pop(c_bigint), stddev_pop(c_double) from datetype; +------------------------+------------------------+ | stddev_pop(`c_bigint`) | stddev_pop(`c_double`) | +------------------------+------------------------+ | 3037.0783723835643 | 35.210273031541995 | +------------------------+------------------------+ 1 row in set (0.006 sec) MySQL [regression_test_zhanglei_aggregate]> select stddev_pop(c_bigint), stddev_pop(c_double) from datetype; +------------------------+------------------------+ | stddev_pop(`c_bigint`) | stddev_pop(`c_double`) | +------------------------+------------------------+ | 3037.0783723835643 | 35.210273031541995 | +------------------------+------------------------+ 1 row in set (0.005 sec) MySQL [regression_test_zhanglei_aggregate]> select stddev_pop(distinct c_bigint), stddev_pop(c_double) from datetype; +---------------------------------+------------------------+ | stddev_pop(DISTINCT `c_bigint`) | stddev_pop(`c_double`) | +---------------------------------+------------------------+ | 3145.0576394647451 | 35.210273031541988 | +---------------------------------+------------------------+ 1 row in set (0.004 sec) MySQL [regression_test_zhanglei_aggregate]> show variables; +--------------------------------------+-------------------------------+ | Variable_name | Value | +--------------------------------------+-------------------------------+ | SQL_AUTO_IS_NULL | false | | allow_partition_column_nullable | true | | auto_increment_increment | 1 | | autocommit | true | | batch_size | 1024 | | block_encryption_mode | | | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_results | utf8 | | character_set_server | utf8 | | codegen_level | 0 | | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | | cpu_resource_limit | -1 | | default_rowset_type | beta | | delete_without_partition | false | | disable_colocate_plan | false | | disable_join_reorder | false | | disable_streaming_preaggregations | false | | div_precision_increment | 4 | | enable_bucket_shuffle_join | true | | enable_cost_based_join_reorder | false | | enable_exchange_node_parallel_merge | false | | enable_fold_constant_by_be | false | | enable_infer_predicate | false | | enable_insert_strict | false | | enable_lateral_view | false | | enable_odbc_transcation | false | | enable_parallel_outfile | false | | enable_partition_cache | false | | enable_profile | false | | enable_spilling | false | | enable_sql_cache | false | | enable_vectorized_engine | true | | event_scheduler | OFF | | exec_mem_limit | 10737418240 | | extract_wide_range_expr | true | | forward_to_master | true | | init_connect | | | insert_visible_timeout_ms | 10000 | | interactive_timeout | 3600 | | language | /palo/share/english/ | | license | Apache License, Version 2.0 | | load_mem_limit | 0 | | lower_case_table_names | 0 | | max_allowed_packet | 1048576 | | max_pushdown_conditions_per_column | -1 | | max_scan_key_num | -1 | | net_buffer_length | 16384 | | net_read_timeout | 60 | | net_write_timeout | 60 | | parallel_exchange_instance_num | -1 | | parallel_fragment_exec_instance_num | 1 | | partition_prune_algorithm_version | 2 | | performance_schema | OFF | | prefer_join_method | broadcast | | query_cache_size | 1048576 | | query_cache_type | 0 | | query_timeout | 3600 | | resource_group | normal | | return_object_data_as_binary | false | | rewrite_count_distinct_to_bitmap_hll | true | | runtime_bloom_filter_max_size | 16777216 | | runtime_bloom_filter_min_size | 1048576 | | runtime_bloom_filter_size | 2097152 | | runtime_filter_max_in_num | 1024 | | runtime_filter_mode | GLOBAL | | runtime_filter_type | IN_OR_BLOOM_FILTER | | runtime_filter_wait_time_ms | 1000 | | runtime_filters_max_num | 10 | | send_batch_parallelism | 1 | | show_hidden_columns | false | | sql_mode | | | sql_quote_show_create | true | | sql_safe_updates | 0 | | sql_select_limit | 9223372036854775807 | | storage_engine | olap | | system_time_zone | Asia/Shanghai | | test_materialized_view | false | | time_zone | Asia/Shanghai | | transaction_isolation | REPEATABLE-READ | | transaction_read_only | false | | tx_isolation | REPEATABLE-READ | | tx_read_only | false | | use_v2_rollup | false | | version | 5.7.37 | | version_comment | Doris version trunk-c87ac2270 | | wait_timeout | 28800 | +--------------------------------------+-------------------------------+ 89 rows in set (0.005 sec) MySQL [regression_test_zhanglei_aggregate]> select @@version_comment; +-------------------------------+ | @@version_comment | +-------------------------------+ | Doris version trunk-c87ac2270 | +-------------------------------+ 1 row in set (0.002 sec) MySQL [regression_test_zhanglei_aggregate]> show backends; +-----------+-----------------+--------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------------------------+--------+-----------------+-------------------------------------------------------------------------------------------------------------------------------+ | BackendId | Cluster | IP | HeartbeatPort | BePort | HttpPort | BrpcPort | LastStartTime | LastHeartbeat | Alive | SystemDecommissioned | ClusterDecommissioned | TabletNum | DataUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | Tag | ErrMsg | Version | Status | +-----------+-----------------+--------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------------------------+--------+-----------------+-------------------------------------------------------------------------------------------------------------------------------+ | 10004 | default_cluster | 172.21.16.12 | 9050 | 9060 | 8040 | 8060 | 2022-04-08 16:19:39 | 2022-04-08 16:44:59 | true | false | false | 221 | 91.511 GB | 3.415 TB | 8.447 TB | 59.57 % | 85.23 % | {"location" : "default"} | | trunk-c87ac2270 | {"lastSuccessReportTabletsTime":"2022-04-08 16:44:22","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | | 10005 | default_cluster | 172.21.16.15 | 9050 | 9060 | 8040 | 8060 | 2022-04-08 16:19:39 | 2022-04-08 16:44:59 | true | false | false | 208 | 85.433 GB | 3.193 TB | 9.255 TB | 65.49 % | 75.10 % | {"location" : "default"} | | trunk-c87ac2270 | {"lastSuccessReportTabletsTime":"2022-04-08 16:44:11","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | | 10002 | default_cluster | 172.21.16.2 | 9050 | 9060 | 8040 | 8060 | 2022-04-08 16:19:39 | 2022-04-08 16:44:59 | true | false | false | 254 | 26.557 GB | 3.156 TB | 10.562 TB | 70.12 % | 88.66 % | {"location" : "default"} | | trunk-c87ac2270 | {"lastSuccessReportTabletsTime":"2022-04-08 16:44:10","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | | 10003 | default_cluster | 172.21.16.6 | 9050 | 9060 | 8040 | 8060 | 2022-04-08 16:19:39 | 2022-04-08 16:44:59 | true | false | false | 275 | 32.354 GB | 3.239 TB | 9.216 TB | 64.85 % | 79.58 % | {"location" : "default"} | | trunk-c87ac2270 | {"lastSuccessReportTabletsTime":"2022-04-08 16:44:10","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | +-----------+-----------------+--------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------------------------+--------+-----------------+-------------------------------------------------------------------------------------------------------------------------------+ 4 rows in set (0.008 sec) ### What's Wrong? 2022-04-08 16:29:43.185 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select max(upper(c_string)), min(upper(c_string)) from datetype 2022-04-08 16:29:43.251 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select avg(c_bigint), avg(c_double) from datetype 2022-04-08 16:29:43.263 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select avg(distinct c_bigint), avg(distinct c_double) from datetype 2022-04-08 16:29:43.269 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select count(c_bigint),count(c_double),count(c_string),count(c_date),count(c_timestamp),count(c_boolean) from datetype 2022-04-08 16:29:43.279 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select count(distinct c_bigint),count(distinct c_double),count(distinct c_string),count(distinct c_date),count(distinct c_timestamp),count(distinct c_boolean) from datetype 2022-04-08 16:29:43.287 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select max(c_bigint), max(c_double),max(c_string), max(c_date), max(c_timestamp) from datetype 2022-04-08 16:29:43.299 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select min(c_bigint), min(c_double), min(c_string), min(c_date), min(c_timestamp) from datetype 2022-04-08 16:29:43.311 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select count(c_string), max(c_double), avg(c_bigint) from datetype 2022-04-08 16:29:43.322 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select stddev_pop(c_bigint), stddev_pop(c_double) from datetype 2022-04-08 16:29:43.331 INFO [pool-3-thread-1] (Suite.groovy:129) - Execute tag: aggregate, sql: select stddev_pop(distinct c_bigint), stddev_pop(c_double) from datetype 2022-04-08 16:29:43.351 ERROR [pool-3-thread-1] (RegressionTest.groovy:173) - Run aggregate in /home/zhanglei/doris/regression-test/suites/aggregate/aggregate.groovy group aggregate elapsed 1036 failed java.lang.IllegalStateException: 'aggregate' line not match . Detailed results is : 'Tag 'aggregate' wrong, line not match. Expect line is: 3145.0576394647455 35.21027303154199 But real is : 3145.057639464745 35.21027303154199' at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:72) at org.codehaus.groovy.reflection.CachedConstructor.doConstructorInvoke(CachedConstructor.java:59) at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrap.callConstructor(ConstructorSite.java:84) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:59) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:263) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:277) at org.apache.doris.regression.suite.Suite.quickTest(Suite.groovy:165) at org.apache.doris.regression.suite.Suite.quickTest(Suite.groovy) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:107) at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1268) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1035) at groovy.lang.DelegatingMetaClass.invokeMethod(DelegatingMetaClass.java:147) at groovy.lang.MetaObjectProtocol$invokeMethod$0.call(Unknown Source) at org.apache.doris.regression.suite.Suite.invokeMethod(Suite.groovy:198) at org.codehaus.groovy.runtime.callsite.PogoInterceptableSite.call(PogoInterceptableSite.java:45) at org.codehaus.groovy.runtime.callsite.PogoInterceptableSite.callCurrent(PogoInterceptableSite.java:55) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:194) at org.apache.doris.regression.suite.Suite.invokeMethod(Suite.groovy:183) at org.codehaus.groovy.runtime.callsite.PogoInterceptableSite.call(PogoInterceptableSite.java:45) at org.codehaus.groovy.runtime.callsite.PogoInterceptableSite.callCurrent(PogoInterceptableSite.java:55) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:51) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:171) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:185) at aggregate.run(aggregate.groovy:86) at org.apache.doris.regression.RegressionTest$_runSuite_closure5.doCall(RegressionTest.groovy:166) at org.apache.doris.regression.RegressionTest$_runSuite_closure5.call(RegressionTest.groovy) at org.codehaus.groovy.runtime.IOGroovyMethods.withCloseable(IOGroovyMethods.java:1607) at org.apache.doris.regression.RegressionTest.runSuite(RegressionTest.groovy:160) at org.apache.doris.regression.RegressionTest$_runGroupSuites_closure10$_lambda16.doCall(RegressionTest.groovy:212) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) 2022-04-08 16:29:43.360 INFO [pool-2-thread-1] (RegressionTest.groovy:244) - Test 1 suites, failed 1 suites 2022-04-08 16:29:43.361 INFO [pool-2-thread-1] (RegressionTest.groovy:259) - Failure suites: /home/zhanglei/doris/regression-test/suites/aggregate/aggregate.groovy: group=aggregate, name=aggregate 2022-04-08 16:29:43.361 INFO [pool-2-thread-1] (RegressionTest.groovy:277) - Some suites failed. _____ _ ___ _ _____ ____ | ___/ \ |_ _| | | ____| _ \ | |_ / _ \ | || | | _| | | | | | _/ ___ \ | || |___| |___| |_| | |_|/_/ \_\___|_____|_____|____/ ### What You Expected? /home/zhanglei/doris/regression-test/suites/aggregate/aggregate.groovy group aggregate elapsed 1036 failed java.lang.IllegalStateException: 'aggregate' line not match . Detailed results is : 'Tag 'aggregate' wrong, line not match. Expect line is: 3145.0576394647455 35.21027303154199 But real is : 3145.057639464745 35.21027303154199' ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
