LakeShen created CALCITE-5895:
---------------------------------

             Summary: The result of table sample rate 0  should be empty
                 Key: CALCITE-5895
                 URL: https://issues.apache.org/jira/browse/CALCITE-5895
             Project: Calcite
          Issue Type: Bug
            Reporter: LakeShen
             Fix For: 1.36.0


For The sql:
```sql

select * from emp tablesample bernoulli(0) where empno > 5

```
The plan is :
```sql
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4], 
SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
  LogicalFilter(condition=[>($0, 5)])
    LogicalTableScan(table=[[CATALOG, SALES, EMP]])
```



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to