You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
With a Snowflake connection, the output tab doesn't return a row when the value is ''. The value NULL is properly returned but BLANK is not, which is misleading. (I haven't had time to test on other databases, but the bug seems to be in the output tab, not related to the DB engine)
I've used this script to confirm:
CREATE TEMP TABLE DEBUG
(
FRUIT VARCHAR(32)
)
INSERT OVERWRITE INTO DEBUG (FRUIT)
VALUES (''),('APPLE'),('PEACH'),(NULL);
SELECT *
FROM DEBUG;
The output tab mentions 1-4 of 4 rows but the tab includes only:
APPLE
PEACH
NULL
I can't highlight the 4th row with a space inside. This is an issue as NULLs aren't joined in Snowflake but spaces do, and with the current result, it's difficult to find where the issue is.
The solution would be to include the row number next to each row, similarly to what we can see in the Snowflake UI. It would be something like:
1.
2. APPLE
2. PEACH
3. NULL
Thanks in advance!
The text was updated successfully, but these errors were encountered:
With a Snowflake connection, the output tab doesn't return a row when the value is ''. The value NULL is properly returned but BLANK is not, which is misleading. (I haven't had time to test on other databases, but the bug seems to be in the output tab, not related to the DB engine)
I've used this script to confirm:
The output tab mentions 1-4 of 4 rows but the tab includes only:
I can't highlight the 4th row with a space inside. This is an issue as NULLs aren't joined in Snowflake but spaces do, and with the current result, it's difficult to find where the issue is.
The solution would be to include the row number next to each row, similarly to what we can see in the Snowflake UI. It would be something like:
Thanks in advance!
The text was updated successfully, but these errors were encountered: