Function TestTypesCasting

tests/integration/types_test.go:283–301

TestTypesCasting tests type casting

(t *testing.T)

	}
	runQueryTests(t, tests)
}

// TestTypesCasting tests type casting
func TestTypesCasting(t *testing.T) {
	tests := []QueryTest{
		// CAST syntax
		{Name: "cast_int_to_text", Query: "SELECT CAST(123 AS TEXT)"},
		{Name: "cast_text_to_int", Query: "SELECT CAST('123' AS INTEGER)"},
		{Name: "cast_float_to_int", Query: "SELECT CAST(3.7 AS INTEGER)"},
		{Name: "cast_bool_to_int", Query: "SELECT CAST(TRUE AS INTEGER)"},

		// :: syntax
		{Name: "colon_int_to_text", Query: "SELECT 123::TEXT"},
		{Name: "colon_text_to_int", Query: "SELECT '123'::INTEGER"},
		{Name: "colon_timestamp", Query: "SELECT '2024-01-15 12:30:45'::TIMESTAMP"},

		// Implicit casting
		{Name: "implicit_int_to_float", Query: "SELECT 1 + 1.5"},
		{Name: "implicit_concat", Query: "SELECT 'count: ' || 5"},
	}
	runQueryTests(t, tests)
}