Function TestTypesArray

tests/integration/types_test.go:219–248

TestTypesArray tests array type handling

(t *testing.T)

	}
	runQueryTests(t, tests)
}

// TestTypesArray tests array type handling
func TestTypesArray(t *testing.T) {
	tests := []QueryTest{
		// Array literals
		{Name: "int_array", Query: "SELECT ARRAY[1, 2, 3]"},
		{Name: "text_array", Query: "SELECT ARRAY['a', 'b', 'c']"},
		{Name: "nested_array", Query: "SELECT ARRAY[[1, 2], [3, 4]]"},
		{Name: "array_cast", Query: "SELECT '{1,2,3}'::INTEGER[]"},

		// Array access
		{Name: "array_subscript", Query: "SELECT (ARRAY[1, 2, 3])[1]"},
		{Name: "array_slice", Query: "SELECT (ARRAY[1, 2, 3, 4, 5])[2:4]"},

		// Array operators
		{Name: "array_concat", Query: "SELECT ARRAY[1, 2] || ARRAY[3, 4]"},
		{Name: "array_append", Query: "SELECT ARRAY[1, 2] || 3"},
		{Name: "array_prepend", Query: "SELECT 0 || ARRAY[1, 2]"},
		{Name: "array_contains", Query: "SELECT ARRAY[1, 2, 3] @> ARRAY[1]"},
		{Name: "array_contained", Query: "SELECT ARRAY[1] <@ ARRAY[1, 2, 3]"},
		{Name: "array_overlap", Query: "SELECT ARRAY[1, 2] && ARRAY[2, 3]"},

		// ANY/ALL with arrays
		{Name: "any_array", Query: "SELECT 2 = ANY(ARRAY[1, 2, 3])"},
		{Name: "all_array", Query: "SELECT 1 = ALL(ARRAY[1, 1, 1])"},

		// From table
		{Name: "select_array_column", Query: "SELECT int_array FROM array_test WHERE id = 1"},
		{Name: "select_text_array", Query: "SELECT text_array FROM array_test WHERE id = 1"},
	}
	runQueryTests(t, tests)
}