Function TestTypesNumeric

tests/integration/types_test.go:8–46

TestTypesNumeric tests numeric type handling

(t *testing.T)

// TestTypesNumeric tests numeric type handling
func TestTypesNumeric(t *testing.T) {
	tests := []QueryTest{
		// Integer types
		{Name: "smallint_literal", Query: "SELECT 1::SMALLINT"},
		{Name: "integer_literal", Query: "SELECT 42::INTEGER"},
		{Name: "bigint_literal", Query: "SELECT 9223372036854775807::BIGINT"},
		{Name: "int2_alias", Query: "SELECT 1::INT2"},
		{Name: "int4_alias", Query: "SELECT 1::INT4"},
		{Name: "int8_alias", Query: "SELECT 1::INT8"},

		// Floating point
		{Name: "real_literal", Query: "SELECT 3.14::REAL"},
		{Name: "double_precision", Query: "SELECT 3.14159265358979::DOUBLE PRECISION"},
		{Name: "float4_alias", Query: "SELECT 1.5::FLOAT4"},
		{Name: "float8_alias", Query: "SELECT 1.5::FLOAT8"},

		// Numeric/Decimal
		{Name: "numeric_literal", Query: "SELECT 123.456::NUMERIC"},
		{Name: "numeric_precision", Query: "SELECT 123.456::NUMERIC(10, 2)"},
		{Name: "decimal_alias", Query: "SELECT 123.456::DECIMAL(10, 2)"},

		// Special float values
		{Name: "float_nan", Query: "SELECT 'NaN'::FLOAT"},
		{Name: "float_infinity", Query: "SELECT 'Infinity'::FLOAT"},
		{Name: "float_neg_infinity", Query: "SELECT '-Infinity'::FLOAT"},

		// Integer operations
		{Name: "integer_add", Query: "SELECT 2147483647 + 1::BIGINT"},
		{Name: "integer_multiply", Query: "SELECT 1000000 * 1000000::BIGINT"},
		{Name: "integer_divide", Query: "SELECT 10 / 3"},
		{Name: "integer_modulo", Query: "SELECT 17 % 5"},

		// From table
		{Name: "select_int_columns", Query: "SELECT int2_col, int4_col, int8_col FROM types_test WHERE id = 1"},
		{Name: "select_float_columns", Query: "SELECT float4_col, float8_col FROM types_test WHERE id = 1"},
		{Name: "select_numeric_column", Query: "SELECT numeric_col FROM types_test WHERE id = 1"},
	}
	runQueryTests(t, tests)
}

// TestTypesCharacter tests character/string type handling
func TestTypesCharacter(t *testing.T) {