On Tue, Jun 18, 2019 at 9:56 AM Pantelis Theodosiou <ypercube(at)gmail(dot)com>
wrote:
>
> ...
>
> I think it is correct result. This:
>
> > UPDATE c SET base_id = id / 10;
>
> would result in 9 rows (id from 1 to 9) to be updated with base_id = 0, as
> it should with integer division. These 9 rows will not match the condition:
>
> WHERE c.base_id = a.id
>
> as there is no row in a with a.id = 0
>
>
>
Please ignore the above, I didn't read carefully.
>