embucket-labs icon indicating copy to clipboard operation
embucket-labs copied to clipboard

Semi-structured accessor functions return incorrect value

Open rampage644 opened this issue 1 month ago • 1 comments

Here is the difference between Snowflake and embucket:

CREATE OR REPLACE TABLE variant_test_embucket (
      id INT,
      data VARIANT
  );

INSERT INTO variant_test_embucket SELECT 1, PARSE_JSON('{"name": "test", "id": "1d110fd7-0f54-4452-8dc6-c4a3eac02024"}');

 > select data:name as n, length(n), data:id as i, length(i) from variant_test;
+-------------------------------------------------------------------------+
| N      | LENGTH(N) | I                                      | LENGTH(I) |
|--------+-----------+----------------------------------------+-----------|
| "test" | 4         | "1d110fd7-0f54-4452-8dc6-c4a3eac02024" | 36        |
+-------------------------------------------------------------------------+
CREATE OR REPLACE TEMPORARY TABLE variant_test (
         id INT,
         data VARIANT
     );

     INSERT INTO variant_test SELECT 1, PARSE_JSON('{"name": "test", "id": "1d110fd7-0f54-4452-8dc6-c4a3eac02024"}');
+-------+
| count |
|-------|
| 0     |
+-------+

+-------+
| count |
|-------|
| 1     |
+-------+

 > select data:name as n, length(n), data:id as i, length(i) from variant_test;
+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
|        | length(variant_element(embucket.public.variant_test |                                        | length(variant_element(embucket.public.variant_test |
| n      | .data,Utf8("$.name"),Boolean(true)))                | i                                      | .data,Utf8("$.id"),Boolean(true)))                  |
|--------+-----------------------------------------------------+----------------------------------------+-----------------------------------------------------|
| "test" | 6                                                   | "1d110fd7-0f54-4452-8dc6-c4a3eac02024" | 38                                                  |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------+

rampage644 avatar Nov 05 '25 22:11 rampage644

is this related to #1911? cc @rampage644 @osipovartem

DanCodedThis avatar Nov 06 '25 19:11 DanCodedThis