Re: Make foo=null a warning by default.

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: Make foo=null a warning by default.
Дата
Msg-id alpine.DEB.2.21.1807160950140.3767@lancre
обсуждение исходный текст
Ответ на Re: Make foo=null a warning by default.  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers
Hello Heikki,

> The use case for transform_null_equals='warn' that I see is to wean off an 
> application that uses transform_null_equals='on', to find all the queries 
> that rely on it. But I'm not too excited about that either. The documented 
> case for using transform_null_equals='on' is compatibility with Microsoft 
> Access, and this wouldn't help with that. Besides, it's easy enough to grep 
> the application or the server log for " = NULL", to find all such queries.

I'm in favor in having this feature, even if off by default, because I 
could enable it and it would help my students when learning SQL in 
interactive sessions, where "grep '= *NULL'" cannot be issued.

-- 
Fabien.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: Make foo=null a warning by default.
Следующее
От: Phil Florent
Дата:
Сообщение: RE: Internal error XX000 with enable_partition_pruning=on, pg 11beta1 on Debian