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