Troubleshooting - [QODBC-ALL] - Troubleshooting - Excel crashes when using SQL statement with two inner joins along with unoptimized

Problem Description

I am using Microsoft Excel.

I am using the following SQL statement.

SELECT TransferInventoryLine.TxnDate,
TransferInventoryLine.RefNumber,
TransferInventoryLine.FromInventorySiteFullName,
TransferInventoryLine.ToInventorySiteFullName,
InventorySite.SiteAddressAddr1,
InventorySite.SiteAddressAddr2,
InventorySite.SiteAddressAddr3,
InventorySite.SiteAddressAddr4,
InventorySite.SiteAddressCity,
InventorySite.SiteAddressState,
InventorySite.SiteAddressPostalCode,
InventorySite.SiteAddressCountry,
TransferInventoryLine.Memo,
TransferInventoryLine.TransferInventoryLineQuantityTransferred,
TransferInventoryLine.TransferInventoryLineItemRefFullName,
Item.Description
FROM (TransferInventoryLine unoptimized
INNER JOIN InventorySite unoptimized
ON TransferInventoryLine.ToInventorySiteListID = InventorySite.listen)
INNER JOIN Item
ON TransferInventoryLine.TransferInventoryLineItemRefListID = Item.ListID
WHERE (TransferInventoryLine.TxnDate={d'2020-09-15'})

Solutions

We can reproduce the issue. The issue can be produced in QODBC build 336 and above.

We are working on fixing the issue.

As a workaround, please change the SQL statement.

SELECT TransferInventoryLine.TxnDate,
TransferInventoryLine.RefNumber,
TransferInventoryLine.FromInventorySiteFullName,
TransferInventoryLine.ToInventorySiteFullName,
InventorySite.SiteAddressAddr1,
InventorySite.SiteAddressAddr2,
InventorySite.SiteAddressAddr3,
InventorySite.SiteAddressAddr4,
InventorySite.SiteAddressCity,
InventorySite.SiteAddressState,
InventorySite.SiteAddressPostalCode,
InventorySite.SiteAddressCountry,
TransferInventoryLine.Memo,
TransferInventoryLine.TransferInventoryLineQuantityTransferred,
TransferInventoryLine.TransferInventoryLineItemRefFullName,
Item.Description
FROM TransferInventoryLine, InventorySite, Item
where TransferInventoryLine.ToInventorySiteListID = InventorySite.ListID
and TransferInventoryLine.TransferInventoryLineItemRefListID = Item.ListID
and TransferInventoryLine.TxnDate={d'2020-09-14'}

Click here to raise a support ticket and request if you still face the issue.