{"record":{"id":"3f022a910d956abf","repo":"jackc/pgx","slug":"cannot-scan-null-into-int","errorCode":null,"errorMessage":"cannot scan NULL into *int","messagePattern":"cannot scan NULL into \\*int","errorType":"exception","errorClass":null,"httpStatus":null,"severity":"error","filePath":"pgtype/builtin_wrappers.go","lineNumber":110,"sourceCode":"\t\treturn fmt.Errorf(\"cannot scan NULL into *int64\")\n\t}\n\n\t*w = int64Wrapper(v.Int64)\n\n\treturn nil\n}\n\nfunc (w int64Wrapper) Int64Value() (Int8, error) {\n\treturn Int8{Int64: int64(w), Valid: true}, nil\n}\n\ntype intWrapper int\n\nfunc (w intWrapper) SkipUnderlyingTypePlan() {}\n\nfunc (w *intWrapper) ScanInt64(v Int8) error {\n\tif !v.Valid {\n\t\treturn fmt.Errorf(\"cannot scan NULL into *int\")\n\t}\n\n\tif v.Int64 < math.MinInt {\n\t\treturn fmt.Errorf(\"%d is less than minimum value for int\", v.Int64)\n\t}\n\tif v.Int64 > math.MaxInt {\n\t\treturn fmt.Errorf(\"%d is greater than maximum value for int\", v.Int64)\n\t}\n\n\t*w = intWrapper(v.Int64)\n\n\treturn nil\n}\n\nfunc (w intWrapper) Int64Value() (Int8, error) {\n\treturn Int8{Int64: int64(w), Valid: true}, nil\n}\n","sourceCodeStart":92,"sourceCodeEnd":128,"githubUrl":"https://github.com/jackc/pgx/blob/ec1a0befd22592cffffdeeb0a50311b506372f4c/pgtype/builtin_wrappers.go#L92-L128","documentation":"intWrapper.ScanInt64 received an invalid (NULL) Int8 while the destination is a plain Go int, which cannot represent NULL.","triggerScenarios":"Thrown at pgtype/builtin_wrappers.go:110 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Scan into *int or a nullable type (pgtype.Int8, sql.NullInt64)","Filter NULLs with IS NOT NULL / COALESCE"],"exampleFix":null,"handlingStrategy":"type-guard","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"}