Re: UNIX_TIMESTAMP() & INT unsigned problems

2001-12-21 Thread Colin Faber
Michael Widenius wrote: > > Hi! > > > "Colin" == Colin Faber <[EMAIL PROTECTED]> writes: > > >> Description: > > Colin> When attempting to select a result set by subtracting the value > Colin> of an unsigned INT column against UNIX_TIMESTAMP() the result set > Colin> is invalid. > >

UNIX_TIMESTAMP() & INT unsigned problems

2001-12-21 Thread Michael Widenius
Hi! > "Colin" == Colin Faber <[EMAIL PROTECTED]> writes: >> Description: Colin> When attempting to select a result set by subtracting the value Colin> of an unsigned INT column against UNIX_TIMESTAMP() the result set Colin> is invalid. >> How-To-Repeat: Colin> Test case: mysql> creat

Re: UNIX_TIMESTAMP() & INT unsigned problems

2001-12-21 Thread Sinisa Milivojevic
Colin Faber writes: > >Description: > When attempting to select a result set by subtracting the value > of an unsigned INT column against UNIX_TIMESTAMP() the result set > is invalid. > > >How-To-Repeat: > Test case: > [skip] Thank you for your bug report. I have been

UNIX_TIMESTAMP() & INT unsigned problems

2001-12-20 Thread Colin Faber
>Description: When attempting to select a result set by subtracting the value of an unsigned INT column against UNIX_TIMESTAMP() the result set is invalid. >How-To-Repeat: Test case: mysql> create table t (ts int unsigned not null); insert into t values (