This issue has been created
There is 1 update.
 
 
Test Reporting Application / cid:jira-generated-image-avatar-7633d4ad-9fde-46d5-aec7-b7c178197cdc TESTREPORT-57 Open

Hibernate HHH000174 warnings flood the logs when sorting test LiveTables by an environment column

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-2c6c95ab-fb3a-4865-b087-686928077a96 Charpentier Lucas created this issue on 01/Oct/26 16:10
 
Summary: Hibernate HHH000174 warnings flood the logs when sorting test LiveTables by an environment column
Issue Type: cid:jira-generated-image-avatar-7633d4ad-9fde-46d5-aec7-b7c178197cdc Bug
Affects Versions: 2.9.2
Assignee: Unassigned
Created: 01/Oct/26 16:10
Priority: cid:jira-generated-image-static-major-0d92c225-3357-4e84-baaf-6ec5addc4aa1 Major
Reporter: Charpentier Lucas
Difficulty: Unknown
Description:

Steps to reproduce

  1. Install Test Reporting Application 2.9.2.
  2. Open a test space home page with a few tests and executions.
  3. Sort the LiveTable by an environment column, e.g. "Java" or "Servlet Container".

Result

The server logs are flooded with Hibernate warnings, dozens per LiveTable request (more than 1,100 lines after a few sorts, about 60% of the log):

WARN  o.h.d.f.TemplateRenderer - HHH000174: Function template anticipated 3 arguments, but 2 arguments encountered
WARN  o.h.d.f.TemplateRenderer - HHH000174: Function template anticipated 4 arguments, but 1 arguments encountered

The LiveTable results are still correct.

Expected

No warnings in the logs.

Cause

The version ordering built by the versionOrderClauses macro in QA.LiveTableResults (introduced by TESTREPORT-27 and used when sorting environment columns by version) uses locate() with 2 arguments and trim() with 1 argument, while Hibernate's dialect templates are locate(?1, ?2, ?3) and trim(?1 ?2 ?3 ?4). Hibernate still generates valid SQL but logs a warning for each call. Passing the start position to locate (e.g. locate('-', x, 1)) and using trim(both ' ' from x) should remove them.

 
 

1 update

 
cid:jira-generated-image-avatar-2c6c95ab-fb3a-4865-b087-686928077a96 Changes by Charpentier Lucas on 01/Oct/26 16:10
 
Assignee: Charpentier Lucas