Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.16, 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
-
None
-
None
-
centos 7.6
Description
Step 1: Create a table and insert data
1.Create database sqltester
create database 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
|
ref_0.tinytext_col as c0 |
from |
sqltester.alltypecol_t1 as ref_0 |
where (EXISTS ( |
select |
count( |
18) over (partition by ref_1.c0 order by ref_0.longtext_col) as c2 |
from |
sqltester_1.tx_cmplx_005 as ref_1 |
where (EXISTS ( |
select |
ref_0.mediumint_col as c2 |
from |
sqltester.tx_cmplx_004 as ref_2 |
inner join sqltester.t0_sub_1 as ref_3 |
on (false) |
inner join sqltester_1.t12 as ref_5 |
on (false) |
where (false) |
))
|
and (EXISTS ( |
select |
ref_0.double_col as c1 |
from |
sqltester.t5 as ref_8 |
where false |
))
|
))
|
group by 1 |
order by 1 desc; |
The expected result is empty, but the actual result is not empty
