Incorrect string len

1

i’ve found that Dremio add blanks chars to string.

eg when I run the following query :

SELECT my_string, length(my_string) AS len_string
FROM (
SELECT CASE WHEN RANDOM() > 0.4 THEN ‘high’ ELSE ‘low’ END AS my_string
FROM whatever_dataset
) nested_0

, the length of the string is always 4, but I expect it to be equal to the size of the string i have defined (i expect ‘low’ length value to be 3, not 4)

2

Looks like a bug. Will submit internal ticket. Thank you for reporting.

3

It seems the issue still occurs.

When I run
SELECT my_string, length(my_string) AS len_string
FROM (
SELECT CASE WHEN RANDOM() < 0.4 THEN ‘high’ ELSE ‘low’ END AS my_string)

I can obtain the following result :

image
image.png1032×546 33.6 KB