James Turton created DRILL-8182:
-----------------------------------
Summary: 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
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}
SELECT
c.Name AS Customer, p.Name AS Product, o.Quantity
FROM
TABLE(dfs.tmp.`/Products_Customers_Orders.xlsx` (type => 'excel', sheetName
=> 'Orders')) o
INNER JOIN
TABLE(dfs.tmp.`/Products_Customers_Orders.xlsx` (type => 'excel', sheetName
=> 'Customers')) c ON o.Customer_Id = c.Id
INNER JOIN
TABLE(dfs.tmp.`/Products_Customers_Orders.xlsx` (type => 'excel', sheetName
=> 'Products')) p ON o.Product_Id = p.Id
WHERE
o.Id = 5;{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
