Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.5.16
-
None
-
centos 7.6
Description
Step 1: Create a table and insert data
1.Create the database sqltester and enter the database
create database sqltester
use sqltester
2.Execute the attachment file to create a table and insert data
source sqltester_for_parallel_with_index.2k_dp_210col.index_desc.sql
3.Execute the attachment file to create a table and insert data
source sqltester_for_parallel_with_index_view_part_tab.sql
Step 2: Execute the query
select `subq_1`.`c1` AS `c0`,`subq_1`.`c0` AS `c1` from (select pi() AS `c0`,`subq_0`.`c1` AS `c1` from (`t10` `ref_0` left join (select `ref_1`.`c_ytd_payment` AS `c0`,pi() AS `c1` from `t4` `ref_1` where (`ref_1`.`c_first` is null)) `subq_0` on((`subq_0`.`c0` is not null))) where true) `subq_1` where true; |
Step 3: Execute the query
select `subq_1`.`c1` AS `c0`,`subq_1`.`c0` AS `c1` from (select pi() AS `c0`,`subq_0`.`c1` AS `c1` from (`t10` `ref_0` left join (select `ref_1`.`c_ytd_payment` AS `c0`,pi() AS `c1` from `t4` `ref_1` where (`ref_1`.`c_first` is null)) `subq_0` on((`subq_0`.`c0` is not null))) where true) `subq_1` where true group by 1,2; |
The expected result is that the query result will not change after the query is executed, but it will actually change the query result
