List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 18 2001 1:38pm
Subject:Re: Similar queries gives different results
View as plain text  
That might depend on the table type of radacct, and the field type of 
username.

Mucahit Celikag wrote:

> Hi,
> 
> I am using mysql running under solaris.
> 
> I am giving two similar queries and geting different results.
> I couldn't find the solution to this problem. 
> 
> Example. 
> 
> Q1.    SELECT username,acctstatrtime,acctstoptime 
>          FROM radacct 
>          WHERE acctstarttime > '2001060112000000';
> 
>          ( Connections to internet after 12:00 - 01/06/2001 )
> 
>          Result of Q1
>          username        acctstarttime                    acctstoptime           
>          jon                   2001-06-01 12:01:00          2001-06-01 12:10:02
>          mike                2001-06-01 13:02:00          2001-06-01 13:15:07
>          simon              2001-06-01 13:06:06          0000-00-00 00:00:00
> 
> Q2.    SELECT username,acctstatrtime,acctstoptime  
>           FROM radacct 
>           WHERE username = 'jon' order by acctstatrtime asc;
>  
>           ( Connections of "jon" up to now. )
> 
>          Result of Q2
>  
>          No result or the list of connections made before  the above date.
>          Does not show the above connection. 
>  
>          But I know in the first query there is connection.
>  
>          How can it be ? Can anyone help me ?
>  
> 
> Thanks 
> 
> Mucahit Celikag
> 
> 
> 
>  


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
Similar queries gives different resultsMucahit Celikag18 Jun
  • Re: Similar queries gives different resultsGerald Clark18 Jun