{"record":{"id":"9e0951fbd55a9285","repo":"jackc/pgx","slug":"argument-s-found-in-sql-query-but-not-present-in","errorCode":null,"errorMessage":"argument %s found in sql query but not present in StrictNamedArgs","messagePattern":"argument (.+?) found in sql query but not present in StrictNamedArgs","errorType":"validation","errorClass":null,"httpStatus":null,"severity":"error","filePath":"named_args.go","lineNumber":194,"sourceCode":"\t}\n\n\tsb := strings.Builder{}\n\tfor _, p := range l.parts {\n\t\tswitch p := p.(type) {\n\t\tcase string:\n\t\t\tsb.WriteString(p)\n\t\tcase namedArg:\n\t\t\tsb.WriteRune('$')\n\t\t\tsb.WriteString(strconv.Itoa(l.nameToOrdinal[p]))\n\t\t}\n\t}\n\n\tnewArgs = make([]any, len(l.nameToOrdinal))\n\tfor name, ordinal := range l.nameToOrdinal {\n\t\tvar found bool\n\t\tnewArgs[ordinal-1], found = na[string(name)]\n\t\tif isStrict && !found {\n\t\t\treturn \"\", nil, fmt.Errorf(\"argument %s found in sql query but not present in StrictNamedArgs\", name)\n\t\t}\n\t}\n\n\tif isStrict {\n\t\tfor name := range na {\n\t\t\tif _, found := l.nameToOrdinal[namedArg(name)]; !found {\n\t\t\t\treturn \"\", nil, fmt.Errorf(\"argument %s of StrictNamedArgs not found in sql query\", name)\n\t\t\t}\n\t\t}\n\t}\n\n\treturn sb.String(), newArgs, nil\n}\n\nfunc rawState(l *sqlLexer) stateFn {\n\tfor {\n\t\tr, width := utf8.DecodeRuneInString(l.src[l.pos:])\n\t\tl.pos += width","sourceCodeStart":176,"sourceCodeEnd":212,"githubUrl":"https://github.com/jackc/pgx/blob/ec1a0befd22592cffffdeeb0a50311b506372f4c/named_args.go#L176-L212","documentation":"StrictNamedArgs rewriting found a named parameter in the SQL that has no corresponding entry in the supplied arguments map. Strict semantics require every referenced name to be present.","triggerScenarios":"Thrown at named_args.go:194 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Add the missing name to the NamedArgs map","Use non-strict NamedArgs if unused names should be tolerated","Fix typos between the SQL parameter name and the map key"],"exampleFix":null,"handlingStrategy":"validation","validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"ec1a0befd22592cffffdeeb0a50311b506372f4c","analyzedAt":"2026-08-04T22:52:11.263Z","contentChangedAt":null,"schemaVersion":2},"datasetVersion":"2026-09-23T08:17:48.524Z"}