(openjpa) branch OPENJPA-2940 updated: [OPENJPA-2940] Fix test on DerbyDB due lack of bool support on default profile

[pcristof]

This is an automated email from the ASF dual-hosted git repository.

cristof pushed a commit to branch OPENJPA-2940
in repository https://gitbox.apache.org/repos/asf/openjpa.git


The following commit(s) were added to refs/heads/OPENJPA-2940 by this push:
     new ec847eafa [OPENJPA-2940] Fix test on DerbyDB due lack of bool support 
on default profile
ec847eafa is described below

commit ec847eafa7e719bd0a0df039b797e310d6531d9b
Author: Paulo Cristovão de Araújo Silva Filho <pcris...@gmail.com>
AuthorDate: Wed May 13 18:21:25 2026 -0300

    [OPENJPA-2940] Fix test on DerbyDB due lack of bool support on default 
profile
---
 .../openjpa/persistence/criteria/TestJPQLSubquery.java      | 13 ++++++++++---
 1 file changed, 10 insertions(+), 3 deletions(-)

diff --git 
a/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/criteria/TestJPQLSubquery.java
 
b/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/criteria/TestJPQLSubquery.java
index d349d02aa..e474f02a1 100644
--- 
a/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/criteria/TestJPQLSubquery.java
+++ 
b/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/criteria/TestJPQLSubquery.java
@@ -1156,9 +1156,16 @@ public class TestJPQLSubquery extends CriteriaTest {
             + "     ELSE false END from Order o2"
             + " where o.customer.id = o2.customer.id)";
 
-        String expectedSQL = "SELECT t0.id FROM CR_ODR t0 WHERE (t0.delivered 
= ("
-            + "SELECT  CASE  WHEN t1.quantity > ? THEN true WHEN t1.quantity = 
? THEN false ELSE false END  "
-            + "FROM CR_ODR t1 WHERE (t0.CUSTOMER_ID = t1.CUSTOMER_ID)))";
+        String expectedSQL = null;
+               if (getDictionary() instanceof DerbyDictionary) {
+                       expectedSQL = "SELECT t0.id FROM CR_ODR t0 WHERE 
(t0.delivered = ("
+                                       + "SELECT  CASE  WHEN t1.quantity > ? 
THEN 1 WHEN t1.quantity = ? THEN 0 ELSE 0 END  "
+                                       + "FROM CR_ODR t1 WHERE (t0.CUSTOMER_ID 
= t1.CUSTOMER_ID)))";
+               } else {
+                       expectedSQL = "SELECT t0.id FROM CR_ODR t0 WHERE 
(t0.delivered = ("
+                                       + "SELECT  CASE  WHEN t1.quantity > ? 
THEN true WHEN t1.quantity = ? THEN false ELSE false END  "
+                                       + "FROM CR_ODR t1 WHERE (t0.CUSTOMER_ID 
= t1.CUSTOMER_ID)))";
+               }
         executeAndCompareSQL(jpql, expectedSQL);
 
         CriteriaQuery<Integer> q = cb.createQuery(Integer.class);