Groups > comp.databases.postgresql > #845

Re: issue with UPDATE

Path	csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Robert Klemme <shortcutter@googlemail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: issue with UPDATE
Date	Sat, 6 Oct 2018 13:17:41 +0200
Lines	55
Message-ID	<g1rjumF8qufU1@mid.individual.net> (permalink)
References	<9b72e44b-fa9b-47cf-8cf2-668f047fbc53@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net jmWTRSbla9dD6BcB9rc3yw/x7VKWt58MsBEl0lx/s/d2hCfbc=
Cancel-Lock	sha1:VQjAR+X0dDvHmLd0YIQnrIpljMw=
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1
In-Reply-To	<9b72e44b-fa9b-47cf-8cf2-668f047fbc53@googlegroups.com>
Content-Language	en-US
Xref	csiph.com comp.databases.postgresql:845

Show key headers only | View raw

On 05.10.2018 18:44, lboc80@gmail.com wrote:
> I'm stuck with an UPDATE, probably I'm messing something up:
> 
> 
> the amount of rows in the '`proj_los`' table expected to be updated are 32, but only 8 get updated,

No, 174202 get updated.

> unless I add an AND condition.
> 
>      select count(*) from import.tmp_kk where root_id = '57b2e67b-5862-499a-a471-0f2f6b23440e';
>      > 32
>      
>      
>    
>    
> 1) correct result -> using last AND clause (`root_id = '57b2e67b-5862-499a-a471-0f2f6b23440e'`)
> 
>      
>      sql> update
>             proj_los as oko
>             set lo_root_id = import.tmp_kk.root_id
>             from import.tmp_kk
>             where oko.lo_id = import.tmp_kk.lo_id
>             and import.tmp_kk.root_id = '57b2e67b-5862-499a-a471-0f2f6b23440e'
>      [2018-10-05 18:13:59] 32 rows affected in 50 ms
>      
>      
>      select count(*) from proj_los where lo_root_id = '57b2e67b-5862-499a-a471-0f2f6b23440e';
>      
>      > 32
>      
>      
>      
>      
> 2) wrong result
>      
>      sql> update
>               proj_los as oko
>             set lo_root_id = import.tmp_kk.root_id
>             from import.tmp_kk
>             where oko.lo_id = import.tmp_kk.lo_id;
>      [2018-10-05 18:17:31] 174202 rows affected in 17 s 427 ms
>      
>      select count(*) from proj_los where lo_root_id = '57b2e67b-5862-499a-a471-0f2f6b23440e';
>      
>      > 8
> 
> Any help on this?
> 


-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

issue with UPDATE lboc80@gmail.com - 2018-10-05 09:44 -0700
  Re: issue with UPDATE Robert Klemme <shortcutter@googlemail.com> - 2018-10-06 13:17 +0200

csiph-web