{"record":{"id":"3b0a56396f053c4e","repo":"hibernate/hibernate-orm","slug":"unrecognized-sort-ordering-sortctx-gettext","errorCode":null,"errorMessage":"Unrecognized sort ordering: \" + sortCtx.getText()","messagePattern":"Unrecognized sort ordering: \" \\+ sortCtx\\.getText\\(\\)","errorType":"exception","errorClass":"UnsupportedOperationException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/query/hql/internal/SemanticQueryBuilder.java","lineNumber":966,"sourceCode":"\t\t\t\t\t\tString.format(\n\t\t\t\t\t\t\t\t\"Search attribute '%s' not found in the CTE %s\",\n\t\t\t\t\t\t\t\tattributeName,\n\t\t\t\t\t\t\t\tcteDefinition.getName()\n\t\t\t\t\t\t),\n\t\t\t\t\t\tquery\n\t\t\t\t);\n\t\t\t}\n\t\t\tSortDirection sortOrder = SortDirection.ASCENDING;\n\t\t\tNulls nullPrecedence = Nulls.NONE;\n\t\t\tint index = 1;\n\t\t\tif ( index < specCtx.getChildCount() ) {\n\t\t\t\tif ( specCtx.getChild( index ) instanceof HqlParser.SortDirectionContext ) {\n\t\t\t\t\tfinal var sortCtx = specCtx.sortDirection();\n\t\t\t\t\tfinal var symbol = ((TerminalNode) sortCtx.getChild( 0 )).getSymbol();\n\t\t\t\t\tsortOrder = switch ( symbol.getType() ) {\n\t\t\t\t\t\tcase HqlParser.ASC -> SortDirection.ASCENDING;\n\t\t\t\t\t\tcase HqlParser.DESC -> SortDirection.DESCENDING;\n\t\t\t\t\t\tdefault -> throw new UnsupportedOperationException(\n\t\t\t\t\t\t\t\t\"Unrecognized sort ordering: \" + sortCtx.getText() );\n\t\t\t\t\t};\n\t\t\t\t\tindex++;\n\t\t\t\t}\n\t\t\t\tif ( index < specCtx.getChildCount() ) {\n\t\t\t\t\tfinal var nullsPrecedenceContext = specCtx.nullsPrecedence();\n\t\t\t\t\tfinal var symbol = ((TerminalNode) nullsPrecedenceContext.getChild( 1 )).getSymbol();\n\t\t\t\t\tnullPrecedence = switch ( symbol.getType() ) {\n\t\t\t\t\t\tcase HqlParser.FIRST -> Nulls.FIRST;\n\t\t\t\t\t\tcase HqlParser.LAST -> Nulls.LAST;\n\t\t\t\t\t\tdefault -> throw new UnsupportedOperationException(\n\t\t\t\t\t\t\t\t\"Unrecognized null precedence: \" + nullsPrecedenceContext.getText() );\n\t\t\t\t\t};\n\t\t\t\t}\n\t\t\t}\n\t\t\tsearchOrders.add( nodeBuilder().search( attribute, sortOrder, nullPrecedence ) );\n\t\t}\n\t\tcteDefinition.search( getCteSearchClauseKind( ctx ), searchAttributeName, searchOrders );","sourceCodeStart":948,"sourceCodeEnd":984,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/query/hql/internal/SemanticQueryBuilder.java#L948-L984","documentation":"Error \"Unrecognized sort ordering: \" + sortCtx.getText()\" thrown in hibernate/hibernate-orm.","triggerScenarios":"A runtime precondition of the Hibernate API is violated.","commonSituations":"Occurs when application code or configuration does not satisfy the documented contract of the API being called.","solutions":["Use 'asc' or 'desc' as the sort ordering in the query.","Fix the order-by clause syntax."],"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"}