Re: NAB : insert into <table> select distinct <fields> => when used on null, distinct causes loss of type knowledge

Hi Tom,

> No, because it never had any: NULL is typeless (type UNKNOWN, to the
> parser). But to do a DISTINCT, the parser has to assign datatypes to all the
> columns (to determine the comparison rules). The default assumption for an
> UNKNOWN constant is type TEXT.

I grok, thanks for the quick reply.

--
Best,

Frank.