Shopping portlet does not render properly in PostgreSQL

• Type: Regression Bug
• Status: Verified
• Resolution: Unresolved
• Affects Version/s: 7.0.1 CE GA2, 7.0.0 DXP SP1, 7.0.X, Master
• Fix Version/s: None
• Component/s: Util, Util > Shopping
• Labels:
  • EXP7
  • QA-V
• Fix Priority: 4
• Databases:
  PostgreSQL 9.3

Steps to reproduce:

1. Start portal
2. Navigate to Content > Shopping

Expected results:
Shopping portlet appears with all of its buttons and nav tabs.

Actual results:
Nothing appears. Errors are thrown into the console:

20:02:11,448 ERROR [http-nio-8080-exec-10][JDBCExceptionReporter:234] ERROR: UNION types bigint and text cannot be matched_  Position: 348 [Sanitized]
20:02:11,464 ERROR [http-nio-8080-exec-10][IncludeTag:128] Current URL /group/guest/~/control_panel/manage?p_p_id=com_liferay_shopping_web_portlet_ShoppingAdminPortlet&p_p_lifecycle=0&p_p_state=maximized&p_p_auth=kfSFicB8 generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
org.postgresql.util.PSQLException: ERROR: UNION types bigint and text cannot be matched_  Position: 348 [Sanitized]
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2542)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
        at org.hibernate.loader.Loader.list(Loader.java:2271)
        at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
        at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
        at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
        at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:181)
        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:172)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:83)

Reproduced on:
Tomcat 8.0.32 + PostgreSQL 9.3.
Portal ee-7.0.x GIT ID: aab533f621b448478dd3bea89165ce1ed4f56e7c
Master GIT ID: 949ba040ae159219c998308c8fc772074b9d11a3

Cannot be reproduced on:
Tomcat 8.0.32 + MySQL 5.6.
Master GIT ID: 949ba040ae159219c998308c8fc772074b9d11a3