[
https://issues.apache.org/jira/browse/DRILL-8182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton updated DRILL-8182:
--------------------------------
Attachment: Products_Customers_Orders.xlsx
> Excel format plugin sheet scan overwriting bug
> ----------------------------------------------
>
> Key: DRILL-8182
> URL: https://issues.apache.org/jira/browse/DRILL-8182
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Other
> Affects Versions: 1.20.0
> Reporter: James Turton
> Assignee: Charles Givre
> Priority: Major
> Fix For: 2.0.0
>
> Attachments: Products_Customers_Orders.xlsx
>
>
> When a query creates multiple scans against a workbook, targeting different
> sheets using TABLE functions then the resulting datasets appear to get mixed
> with one overwriting the other. To reproduce, run the following query
> against the attachment and note that the value returned from the Products
> sheet is a name from the Customers sheet.
>
> {code:java}
> with cust as (
> select * from TABLE(dfs.tmp.`/Products_Customers_Orders.xlsx` (type =>
> 'excel', sheetName => 'Customers'))
> ),
> prod as (
> select * from TABLE(dfs.tmp.`/Products_Customers_Orders.xlsx` (type =>
> 'excel', sheetName => 'Products'))
> )
> select * from cust join prod on cust.Id = prod.Id;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
