{"record":{"id":"c4bfeb85a3e0b440","repo":"hibernate/hibernate-orm","slug":"unrecognized-trim-specification","errorCode":null,"errorMessage":"Unrecognized trim specification","messagePattern":"Unrecognized trim specification","errorType":"exception","errorClass":"ParsingException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/query/hql/internal/SemanticQueryBuilder.java","lineNumber":5548,"sourceCode":"\t\t\t\tnull,\n\t\t\t\tqueryEngine()\n\t\t);\n\t}\n\n\t@Override\n\tpublic SqmTrimSpecification visitTrimSpecification(HqlParser.TrimSpecificationContext ctx) {\n\t\t// JPA says the default is BOTH\n\t\tfinal var trimSpec = ctx != null ? trimSpec( ctx ) : TrimSpec.BOTH;\n\t\treturn new SqmTrimSpecification( trimSpec, nodeBuilder() );\n\t}\n\n\tprivate static TrimSpec trimSpec(HqlParser.TrimSpecificationContext ctx) {\n\t\tfinal var symbol = ((TerminalNode) ctx.getChild( 0 )).getSymbol();\n\t\treturn switch ( symbol.getType() ) {\n\t\t\tcase HqlParser.LEADING -> TrimSpec.LEADING;\n\t\t\tcase HqlParser.TRAILING -> TrimSpec.TRAILING;\n\t\t\tcase HqlParser.BOTH -> TrimSpec.BOTH;\n\t\t\tdefault -> throw new ParsingException( \"Unrecognized trim specification\" );\n\t\t};\n\t}\n\n\t@Override\n\tpublic SqmExpression<Character> visitTrimCharacter(HqlParser.TrimCharacterContext ctx) {\n\t\tfinal String trimCharText;\n\t\tif ( ctx == null ) {\n\t\t\t// JPA says space is the default\n\t\t\ttrimCharText = \" \";\n\t\t}\n\t\telse {\n\t\t\tfinal var parameter = ctx.parameter();\n\t\t\tif ( parameter != null ) {\n\t\t\t\t//noinspection unchecked\n\t\t\t\treturn (SqmExpression<Character>) parameter.accept( this );\n\t\t\t}\n\t\t\telse {\n\t\t\t\ttrimCharText = unquoteStringLiteral( ctx.getText() );","sourceCodeStart":5530,"sourceCodeEnd":5566,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/query/hql/internal/SemanticQueryBuilder.java#L5530-L5566","documentation":"Error \"Unrecognized trim specification\" thrown in hibernate/hibernate-orm.","triggerScenarios":"An invalid keyword/field is used in a datetime, pad, or trim expression: Unrecognized trim specification","commonSituations":"HQL queries using extract(), pad(), or trim() with a field/specification keyword that is not one of the documented values.","solutions":["The trim specification is not recognized. Use LEADING, TRAILING, or BOTH in the trim() function."],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"fad1729dce015f908198d57a8d80274a30f905a5","analyzedAt":"2026-08-22T04:13:57.527Z","schemaVersion":2},"datasetVersion":"2026-08-22T09:17:25.309Z"}