tushar writes:
> On 10/12/2017 03:46 PM, Marko Tiikkaja wrote:
>> The subquery:
>> select n from tv limit 1
>> could in theory return any row due to the lack of ORDER BY. What I'm
>> guessing happened is that you're seeing a synchronized sequential scan
>> in follow-up queries. Add an ORDER
On 10/12/2017 03:46 PM, Marko Tiikkaja wrote:
The subquery:
select n from tv limit 1
could in theory return any row due to the lack of ORDER BY. What I'm
guessing happened is that you're seeing a synchronized sequential scan
in follow-up queries. Add an ORDER BY.
Bang on . After adding
On Thu, Oct 12, 2017 at 12:03 PM, tushar
wrote:
> postgres=# SELECT * FROM ( SELECT n from tv where n= (select * from
> (select n from tv limit 1) c)) as c ;
> n
> --
> 3713
> (1 row)
>
> This time , query is started showing wrong result. Is this an expected
> behavior and if yes -
Hi,
Steps to reproduce -
\\ PG HEAD / PG v10 sources . Connect to psql terminal - create these
following object
create table tv(n int,n1 char(100));
insert into tv values (generate_series(1,100),'aaa');
insert into tv values (generate_series(1,100),'a');
analyze tv;
vacuum tv;
