Function conversionErrorCode

server/conn_errors.go:212–221

conversionErrorCode narrows a "Conversion Error: …" message. DuckDB uses this prefix for both invalid text representations and numeric overflows during casts (e.g. CAST(1000 AS TINYINT));

(msg string)

// this prefix for both invalid text representations and numeric overflows
// during casts (e.g. CAST(1000 AS TINYINT));
func conversionErrorCode(msg string) string {
	lower := strings.ToLower(msg)
	switch {
	case strings.Contains(lower, "out of range"),
		strings.Contains(lower, "overflow"),
		strings.Contains(lower, "would be out of range"):
		return "22003" // numeric_value_out_of_range
	}
	return "22P02" // invalid_text_representation
}

// constraintErrorCode narrows a "Constraint Error: …" message to one of the
// integrity_constraint_violation family codes. DuckDB's messages name the