Uploaded image for project: 'PUBLIC - Liferay Commerce'
  1. PUBLIC - Liferay Commerce
  2. COMMERCE-2260

WarehouseInventory cannot be retrieved due to invalid SQL

    Details

    • JDK:
      Oracle Sun JDK 8
    • Application Servers:
      Apache Tomcat 9.0.x
    • Databases:
      MySQL 5.7
    • Portal Version/s:
      7.1.x

      Description

      The query to retrieve warehouses is incorrect. It is missing a 'AND' in the WHERE-clause.

      com.liferay.commerce.inventory.service.persistence.impl.CommerceInventoryWarehouseFinderImpl.findByG_S(CommerceInventoryWarehouseFinderImpl.java:66)

      You can find the faulty code here: https://github.com/liferay/com-liferay-commerce/blob/7.1.x-next/commerce-inventory-service/src/main/resources/META-INF/custom-sql/default.xml

       

        Attachments

          Activity

            People

            • Assignee:
              alessandro.iovane Alessandro Iovane
              Reporter:
              gverhemeldonck Gunther Verhemeldonck
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2.0.7