sqlite-jdbc-3.21.0.jar cannot execute some SELECT statements

Issue #232 new
Anonymous created an issue

For example, this one produces 'Invalid column Products.ProductName'. In sqlite-jdbc-3.18.0.jar, all is OK.

SELECT Products.ProductName, Orders.CustomerID, strftime('%Y', [OrderDate]) AS OrderYear FROM Products INNER JOIN (Orders INNER JOIN [OrderDetails] ON Orders.OrderID = [OrderDetails].OrderID) ON Products.ProductID = [OrderDetails].ProductID WHERE (((Orders.OrderDate) Between ? And ?)) GROUP BY Products.ProductName, Orders.CustomerID, strftime('%Y', [OrderDate])

Comments (0)

  1. Log in to comment