Re: Insert result does not match record count

On Fri, Jul 19, 2013 at 3:20 PM, Natalie Wenz <nataliewenz@ebureau.com> wrote:
> Hi all,
>
> I am moving some data from one table to another in 9.2.4, and keep seeing this strange scenario:
>
> insert into newtable select data from oldtable where proc_date >= x and proc_date < y;
>
> INSERT 0 78551642
>
> select count(*) from newtable where proc_date >= x and proc_date < y;
>    count
> -----------
>  4373518938

It looks to me like the status report is 32 bits and overflowed.

4,373,518,938 - 2^32 = 78,551,642

Cheers,

Jeff