{"record":{"id":"15cb6684ba42dc05","repo":"hibernate/hibernate-orm","slug":"unsupported-week-field-ctx-gettext","errorCode":null,"errorMessage":"Unsupported week field [{ctx.getText()}]","messagePattern":"Unsupported week field \\[(.+?)\\]","errorType":"exception","errorClass":"ParsingException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/query/hql/internal/SemanticQueryBuilder.java","lineNumber":5014,"sourceCode":"\t\t\t\t\tnew SqmExtractUnit<>( DAY_OF_WEEK, nodeBuilder().getIntegerType(), nodeBuilder );\n\t\t\tcase HqlParser.YEAR ->\n\t\t\t\t\tnew SqmExtractUnit<>( DAY_OF_YEAR, nodeBuilder().getIntegerType(), nodeBuilder );\n\t\t\tdefault -> throw new ParsingException( \"Unsupported day field [\" + ctx.getText() + \"]\" );\n\t\t};\n\t}\n\n\t@Override\n\tpublic Object visitWeekField(HqlParser.WeekFieldContext ctx) {\n\t\tfinal var nodeBuilder = nodeBuilder();\n\t\tfinal var symbol = ((TerminalNode) ctx.getChild( 2 )).getSymbol();\n\t\treturn switch ( symbol.getType() ) {\n\t\t\tcase HqlParser.MONTH ->\n\t\t\t\t//this is computed from DAY_OF_MONTH/7\n\t\t\t\t\tnew SqmExtractUnit<>( WEEK_OF_MONTH, nodeBuilder().getIntegerType(), nodeBuilder );\n\t\t\tcase HqlParser.YEAR ->\n\t\t\t\t//this is computed from DAY_OF_YEAR/7\n\t\t\t\t\tnew SqmExtractUnit<>( WEEK_OF_YEAR, nodeBuilder().getIntegerType(), nodeBuilder );\n\t\t\tdefault -> throw new ParsingException( \"Unsupported week field [\" + ctx.getText() + \"]\" );\n\t\t};\n\t}\n\n\t@Override\n\tpublic Object visitDateOrTimeField(HqlParser.DateOrTimeFieldContext ctx) {\n\t\tfinal var nodeBuilder = nodeBuilder();\n\t\tfinal var symbol = ((TerminalNode) ctx.getChild( 0 )).getSymbol();\n\t\treturn switch ( symbol.getType() ) {\n\t\t\tcase HqlParser.DATE -> isExtractingJdbcTemporalType\n\t\t\t\t\t? new SqmExtractUnit<>( DATE, resolveExpressibleTypeBasic( Date.class ), nodeBuilder )\n\t\t\t\t\t: new SqmExtractUnit<>( DATE, resolveExpressibleTypeBasic( LocalDate.class ), nodeBuilder );\n\t\t\tcase HqlParser.TIME -> isExtractingJdbcTemporalType\n\t\t\t\t\t? new SqmExtractUnit<>( TIME, resolveExpressibleTypeBasic( Time.class ), nodeBuilder )\n\t\t\t\t\t: new SqmExtractUnit<>( TIME, resolveExpressibleTypeBasic( LocalTime.class ), nodeBuilder );\n\t\t\tdefault -> throw new ParsingException( \"Unsupported date or time field [\" + ctx.getText() + \"]\" );\n\t\t};\n\t}\n","sourceCodeStart":4996,"sourceCodeEnd":5032,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/query/hql/internal/SemanticQueryBuilder.java#L4996-L5032","documentation":"Error \"Unsupported week field [{ctx.getText()}]\" thrown in hibernate/hibernate-orm.","triggerScenarios":"An invalid keyword/field is used in a datetime, pad, or trim expression: Unsupported week field [<value>]","commonSituations":"HQL queries using extract(), pad(), or trim() with a field/specification keyword that is not one of the documented values.","solutions":["The requested week field is not supported. Use a supported week field per the HQL documentation."],"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"}