Skip to content

Passed

org.eclipse.persistence.jpa.test.query.TestQueryCase(test-jpa-jse).testQuery_Criteria_Case_Parameters_2

Took 3 ms.

Standard Output

[EL Fine]: sql: 2024.06.12 11:46:12.141--ServerSession(1261661384)--Connection(93241065)--Thread(Thread[#1,main,5,main])--SELECT KEY_CHAR, ITEM_INTEGER1, ITEM_STRING1, ITEM_STRING2, ITEM_STRING3, ITEM_STRING4 FROM SIMPLE_TBL01 WHERE (ITEM_STRING1 = CASE WHEN (ITEM_INTEGER1 = 1000) THEN '047010' WHEN (ITEM_INTEGER1 = 100) THEN '023010' ELSE '033020' END )
[EL Fine]: sql: 2024.06.12 11:46:12.142--ServerSession(1261661384)--Connection(93241065)--Thread(Thread[#1,main,5,main])--SELECT KEY_CHAR, ITEM_INTEGER1, ITEM_STRING1, ITEM_STRING2, ITEM_STRING3, ITEM_STRING4 FROM SIMPLE_TBL01 WHERE (ITEM_STRING1 = CASE WHEN (ITEM_INTEGER1 = 1) THEN 'A' WHEN (ITEM_INTEGER1 = 100) THEN 'B' ELSE 'C' END )