Function TestTypesJSON

tests/integration/types_test.go:186–216

TestTypesJSON tests JSON type handling

(t *testing.T)

	}
	runQueryTests(t, tests)
}

// TestTypesJSON tests JSON type handling
func TestTypesJSON(t *testing.T) {
	tests := []QueryTest{
		// JSON literals
		{Name: "json_object", Query: "SELECT '{\"a\": 1}'::JSON"},
		{Name: "json_array", Query: "SELECT '[1, 2, 3]'::JSON"},
		{Name: "json_nested", Query: "SELECT '{\"a\": {\"b\": 1}}'::JSON"},
		{Name: "json_string", Query: "SELECT '\"hello\"'::JSON"},
		{Name: "json_number", Query: "SELECT '42'::JSON"},
		{Name: "json_null", Query: "SELECT 'null'::JSON"},

		// JSONB (may be stored as JSON)
		{Name: "jsonb_object", Query: "SELECT '{\"a\": 1}'::JSONB"},
		{Name: "jsonb_array", Query: "SELECT '[1, 2, 3]'::JSONB"},

		// JSON access operators
		{Name: "json_arrow", Query: "SELECT '{\"a\": 1}'::JSON -> 'a'"},
		{Name: "json_double_arrow", Query: "SELECT '{\"a\": 1}'::JSON ->> 'a'"},
		{Name: "json_array_access", Query: "SELECT '[1, 2, 3]'::JSON -> 0"},
		{Name: "json_path", Query: "SELECT '{\"a\": {\"b\": 1}}'::JSON #> '{a,b}'", Skip: SkipUnsupportedByDuckDB},
		{Name: "json_path_text", Query: "SELECT '{\"a\": {\"b\": 1}}'::JSON #>> '{a,b}'", Skip: SkipUnsupportedByDuckDB},

		// JSONB operators
		{Name: "jsonb_contains", Query: "SELECT '{\"a\": 1, \"b\": 2}'::JSONB @> '{\"a\": 1}'::JSONB"},
		{Name: "jsonb_contained", Query: "SELECT '{\"a\": 1}'::JSONB <@ '{\"a\": 1, \"b\": 2}'::JSONB"},
		{Name: "jsonb_exists", Query: "SELECT '{\"a\": 1}'::JSONB ? 'a'"},

		// From table
		{Name: "select_json_data", Query: "SELECT data FROM json_data WHERE id = 1"},
	}
	runQueryTests(t, tests)
}