warning for subquery that references a table but not its columns

Поиск
Список
Период
Сортировка
От Seamus Abshere
Тема warning for subquery that references a table but not its columns
Дата
Msg-id 1516309526.4088210.1240289384.0CDAD7E3@webmail.messagingengine.com
обсуждение исходный текст
Ответы Re: warning for subquery that references a table but not its columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I almost got bit by this today:

=> select email from subscribed where email not in (select email from tracks);
 email
-------
(0 rows)

=> select email from subscribed where email not in (select tracks.email from tracks);
ERROR:  column tracks.email does not exist
LINE 1: ... email from subscribed where email not in (select tracks.ema...

(the "tracks" table doesn't have an "email" column, so the first query is just meaningless)

Should there be a warning for the first query that you reference "tracks" in a subquery but don't use any columns from
it?

--
Seamus Abshere, SCEA
https://www.faraday.io
https://github.com/seamusabshere
https://linkedin.com/in/seamusabshere


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

Предыдущее
От: Paul Jones
Дата:
Сообщение: Possible hang in 10.1 with JSON query over partially indexedpartitions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Possible hang in 10.1 with JSON query over partially indexed partitions