Skip site navigation (1) Skip section navigation (2)

Re: No error when FROM is missing in subquery

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "Thomas H(dot)" <me(at)alternize(dot)com>
Cc: nikolay(at)samokhvalov(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: No error when FROM is missing in subquery
Date: 2006-12-19 03:43:31
Message-ID: c2d9e70e0612181943l2a8b2e15qea80ce912984f3bd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 12/18/06, Thomas H. <me(at)alternize(dot)com> wrote:
> >> > Is it a bug? If no, maybe to produce warning in such cases?
>
> oups. just thumbled over this as well when i forgot a FROM in a WHERE ... IN
> (....) and damaged quite some data. the bad query went like this:
>
> SELECT * FROM movies.names WHERE mov_id IN (SELECT DISTINCT mov_id WHERE
> mov_name like '%, %' LIMIT 2)
>
> the subselect is missing a FROM <table>. in that case, pgsql seemed to also
> ignore the LIMIT 2 and returned 3706 records out of ~130000...

and the UPDATE was?

also the limit applies only to the subselect, it has nothing to do
with the upper query so the upper query can return more than number of
rows specified in the subselect...

> no clue which ones :-/
>

LIMIT is often meaningfull only in conjuction with ORDER BY

-- 
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

In response to

Responses

pgsql-bugs by date

Next:From: Thomas H.Date: 2006-12-19 03:57:31
Subject: Re: No error when FROM is missing in subquery
Previous:From: Thomas H.Date: 2006-12-19 03:26:21
Subject: Re: No error when FROM is missing in subquery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group