Function TestTypesCharacter

tests/integration/types_test.go:49–77

TestTypesCharacter tests character/string type handling

(t *testing.T)

// TestTypesCharacter tests character/string type handling
func TestTypesCharacter(t *testing.T) {
	tests := []QueryTest{
		// Basic types
		{Name: "text_literal", Query: "SELECT 'hello'::TEXT"},
		{Name: "varchar_literal", Query: "SELECT 'hello'::VARCHAR"},
		{Name: "varchar_limit", Query: "SELECT 'hello'::VARCHAR(10)"},
		{Name: "char_fixed", Query: "SELECT 'hi'::CHAR(10)"},
		{Name: "character_varying", Query: "SELECT 'hello'::CHARACTER VARYING(100)"},

		// Empty and whitespace
		{Name: "empty_string", Query: "SELECT ''::TEXT"},
		{Name: "whitespace_string", Query: "SELECT '   '::TEXT"},

		// Special characters
		{Name: "string_with_quotes", Query: "SELECT 'it''s a test'::TEXT"},
		{Name: "string_with_newline", Query: "SELECT E'line1\\nline2'::TEXT"},
		{Name: "string_with_tab", Query: "SELECT E'col1\\tcol2'::TEXT"},

		// Unicode
		{Name: "unicode_string", Query: "SELECT 'Hello, \u4e16\u754c'::TEXT"},
		{Name: "emoji_string", Query: "SELECT '\U0001f600\U0001f389'::TEXT"},

		// From table
		{Name: "select_text_column", Query: "SELECT text_col FROM types_test WHERE id = 1"},
		{Name: "select_varchar_column", Query: "SELECT varchar_col FROM types_test WHERE id = 1"},
		{Name: "select_char_column", Query: "SELECT char_col FROM types_test WHERE id = 1"},
	}
	runQueryTests(t, tests)
}

// TestTypesDateTime tests date/time type handling
func TestTypesDateTime(t *testing.T) {