Skip to content

Passed

org.eclipse.persistence.jpa.test.query.TestQuerySyntaxComparisonTests(test-jpa-jse).testCoalesce3_Default

Took 14 ms.

Standard Output

[EL Fine]: sql: 2024.06.12 11:46:13.364--ServerSession(274020961)--Connection(897374976)--Thread(Thread[#1,main,5,main])--SELECT STRVAL2 FROM QUERYSYNTAXENTITY WHERE (COALESCE(?, ?, ?, ?, ?) = INTVAL2)
	bind => [2, 7, 5, 9, 12]
[EL Fine]: sql: 2024.06.12 11:46:13.368--ServerSession(274020961)--Thread(Thread[#1,main,5,main])--VALUES(1)
[EL Warning]: 2024.06.12 11:46:13.370--UnitOfWork(1415857264)--Thread(Thread[#1,main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 5.0.0.v
...[truncated 3130 chars]...
istence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: All the arguments to the COALESCE/VALUE function cannot be parameters. The function needs at least one argument that is not a parameter.
Error Code: 30000
Call: SELECT STRVAL2 FROM QUERYSYNTAXENTITY WHERE (COALESCE(?, ?, ?, ?, ?) = INTVAL2)
	bind => [null, 7, 5, 9, 12]
Query: ReportQuery(referenceClass=QuerySyntaxEntity sql="SELECT STRVAL2 FROM QUERYSYNTAXENTITY WHERE (COALESCE(?, ?, ?, ?, ?) = INTVAL2)")