Allow NULL values to bootstrap a column alias
Currently, one can bootstrap an alias with a literal value, one cannot do the same with NULL. Please allow NULL to be used as well since it is a valid option.
For example you can do the following:
Select 'ABC' as ColumnName from system.iota;
BUT cannot do:
Select NULL as ColumnName from system.iota;
This is rather annoying. I had to write a function that returns NULL to overcome this limitation.
3
votes
ahinson
shared this idea
Closing. See Alex’s reply.
1 comment
-
AlexWong
commented
This is already possible. The problem with your statement is that NULL does not have a type. The following works:
SELECT Cast( NULL as SQL_VARCHAR(3)) as ColumnName FROM system.iota
