@@ -47,16 +47,20 @@ def setUp(self):
4747 def assert_logical_type (self , field , name ):
4848 self .assertEqual ((field .metadata or {}).get (b"doris_type" ), name .encode ())
4949
50+ def query (self , sql ):
51+ self .cursor .execute (sql )
52+ table = self .cursor .fetch_arrow_table ()
53+ table .validate (full = True )
54+ return table
55+
5056 def test_largeint_metadata_and_full_range (self ):
51- self .cursor . execute ("""
57+ table = self .query ("""
5258 SELECT CAST('170141183460469231731687303715884105727' AS LARGEINT) AS scalar_value,
5359 named_struct('number', CAST(17 AS LARGEINT), 'text', '17') AS struct_value,
5460 array(CAST('-170141183460469231731687303715884105728' AS LARGEINT),
5561 CAST(NULL AS LARGEINT)) AS array_value,
5662 map(CAST(17 AS LARGEINT), CAST(19 AS LARGEINT)) AS map_value
5763 """ )
58- table = self .cursor .fetch_arrow_table ()
59- table .validate (full = True )
6064 self .assert_logical_type (table .schema .field ("scalar_value" ), "LARGEINT" )
6165 structure = table .schema .field ("struct_value" ).type
6266 self .assert_logical_type (structure .field ("number" ), "LARGEINT" )
@@ -73,18 +77,30 @@ def test_largeint_metadata_and_full_range(self):
7377 self .assertEqual (row ["struct_value" ], {"number" : "17" , "text" : "17" })
7478 self .assertEqual (row ["map_value" ], [("17" , "19" )])
7579
76- def test_other_logical_types (self ):
77- self .cursor .execute ("""
78- SELECT array(CAST('192.0.2.1' AS IPV4)) AS ip4,
79- named_struct('address', CAST('2001:db8::1' AS IPV6)) AS ip6,
80- map('k', CAST('{"n":1}' AS JSON)) AS json_value,
81- array(CAST('{"n":1}' AS VARIANT)) AS variant_value
80+ def test_ipv4_metadata (self ):
81+ table = self .query ("""
82+ SELECT array(CAST('192.0.2.1' AS IPV4)) AS ip4
8283 """ )
83- table = self .cursor .fetch_arrow_table ()
84- table .validate (full = True )
8584 self .assert_logical_type (table .schema .field ("ip4" ).type .value_field , "IPV4" )
85+
86+ def test_ipv6_metadata (self ):
87+ table = self .query ("""
88+ SELECT named_struct('address', CAST('2001:db8::1' AS IPV6)) AS ip6
89+ """ )
8690 self .assert_logical_type (table .schema .field ("ip6" ).type .field ("address" ), "IPV6" )
87- self .assert_logical_type (table .schema .field ("json_value" ).type .item_field , "JSON" )
91+
92+ def test_json_metadata (self ):
93+ # ARRAY/MAP constructors reject JSON; ARRAY_REPEAT preserves its element type.
94+ table = self .query ("""
95+ SELECT array_repeat(CAST('{"n":1}' AS JSON), 1) AS json_value
96+ """ )
97+ self .assert_logical_type (table .schema .field ("json_value" ).type .value_field , "JSON" )
98+
99+ def test_variant_metadata (self ):
100+ # ARRAY rejects legacy VARIANT; ARRAY_REPEAT also supports the default mode.
101+ table = self .query ("""
102+ SELECT array_repeat(CAST('{"n":1}' AS VARIANT), 1) AS variant_value
103+ """ )
88104 self .assert_logical_type (table .schema .field ("variant_value" ).type .value_field , "VARIANT" )
89105
90106
0 commit comments