{"record":{"id":"d7cbcb93af60f6d1","repo":"temporalio/temporal","slug":"only-one-expression-is-allowed-for-s-d7cbcb","errorCode":null,"errorMessage":"only one expression is allowed for %s","messagePattern":"only one expression is allowed for (.+?)","errorType":"validation","errorClass":null,"httpStatus":null,"severity":"error","filePath":"common/archiver/s3store/query_parser.go","lineNumber":177,"sourceCode":"\tcase StartTime:\n\t\ttimestamp, err := sqlquery.ConvertToTime(valStr)\n\t\tif err != nil {\n\t\t\treturn err\n\t\t}\n\t\tif op != \"=\" {\n\t\t\treturn fmt.Errorf(\"only operation = is support for %s\", StartTime)\n\t\t}\n\t\tparsedQuery.startTime = &timestamp\n\tcase SearchPrecision:\n\t\tval, err := sqlquery.ExtractStringValue(valStr)\n\t\tif err != nil {\n\t\t\treturn err\n\t\t}\n\t\tif op != \"=\" {\n\t\t\treturn fmt.Errorf(\"only operation = is support for %s\", SearchPrecision)\n\t\t}\n\t\tif parsedQuery.searchPrecision != nil && *parsedQuery.searchPrecision != val {\n\t\t\treturn fmt.Errorf(\"only one expression is allowed for %s\", SearchPrecision)\n\t\t}\n\t\tswitch val {\n\t\tcase PrecisionDay:\n\t\tcase PrecisionHour:\n\t\tcase PrecisionMinute:\n\t\tcase PrecisionSecond:\n\t\tdefault:\n\t\t\treturn fmt.Errorf(\"invalid value for %s: %s\", SearchPrecision, val)\n\t\t}\n\t\tparsedQuery.searchPrecision = new(val)\n\n\tdefault:\n\t\treturn fmt.Errorf(\"unknown filter name: %s\", colNameStr)\n\t}\n\n\treturn nil\n}\n","sourceCodeStart":159,"sourceCodeEnd":195,"githubUrl":"https://github.com/temporalio/temporal/blob/bde624efd13fbd3843654058db6d9c716166318b/common/archiver/s3store/query_parser.go#L159-L195","documentation":"Returned by the S3 archival query parser when a query string for a Visibility SQL filter contains more than one expression for the given field (e.g. multiple comparisons on the same key). Only a single expression per field is supported.","triggerScenarios":"Parsing `SearchPrecision = \"Day\" AND SearchPrecision = \"Hour\"` — parsedQuery.searchPrecision is already set and differs from the new value, so the error is returned.","commonSituations":"Query builders emitting a precision clause for both StartTime and CloseTime; combining query fragments that each add their own precision; user confusion between AND semantics and single-value constraints.","solutions":["Emit exactly one SearchPrecision clause per query","Deduplicate precision clauses in query-builder code, keeping the first value","Remember a query may contain only one of StartTime or CloseTime anyway, so one precision suffices"],"exampleFix":"// before\n`StartTime = \"2023-01-01\" AND SearchPrecision = \"Day\" AND SearchPrecision = \"Hour\"`\n// after\n`StartTime = \"2023-01-01\" AND SearchPrecision = \"Day\"`","handlingStrategy":"validation","validationCode":"if strings.Count(q, \"SearchPrecision\") > 1 {\n    return fmt.Errorf(\"query must contain at most one SearchPrecision filter\")\n}","typeGuard":null,"tryCatchPattern":"parsed, err := parser.Parse(q)\nif err != nil {\n    if strings.Contains(err.Error(), \"only one expression is allowed\") {\n        return nil, fmt.Errorf(\"conflicting SearchPrecision values: %w\", err)\n    }\n    return err\n}","preventionTips":["Emit the precision clause exactly once, alongside the single time filter","Deduplicate composed query fragments","Only attach precision when StartTime or CloseTime is present (it is required then)"],"tags":["go","archiver","s3store","query-parser","duplicate-filter"],"backgroundTag":"duplicate-query-filter","analyzedSha":"bde624efd13fbd3843654058db6d9c716166318b","analyzedAt":"2026-09-01T07:18:39.080Z","contentChangedAt":null,"schemaVersion":2},"datasetVersion":"2026-09-08T10:18:20.063Z"}