List:General Discussion« Previous MessageNext Message »
From:Leonardus Setiabudi Date:August 24 2004 7:04am
Subject:Re: Problem with 4.1.3 that I not had with 4.0.20
View as plain text  
try this query

SELECT
bytes,
bytes_priv,
bytes_bus,
hits,
hits_priv,
hits_bus,
bytes - ( bytes_priv + bytes_bus ),
hits - (hits_priv + hits_bus)
FROM url_cat_copy
WHERE
(bytes<>round(bytes_priv+bytes_bus,0))
or
(hits<>round(hits_priv + hits_bus,0))

i think its got something to do with the decimal type..
try googling or search in the manual book
i've red somewhere, that a decimal number in computer never as exact
as what they have meant..

HTH
Leo

On Tue, 24 Aug 2004 08:41:47 +0200, Martin Rytz <rytz@stripped> wrote:
> Good Morning Community!
> 
> I have a problem with 4.1.3 that I not had with 4.0.20.
> 
> Here is my table:
> 
> CREATE TABLE url_cat_copy (
>   id int(11) NOT NULL auto_increment,
>   url varchar(100) default NULL,
>   domain varchar(100) default NULL,
>   bytes bigint(20) default NULL,
>   hits bigint(20) default NULL,
>   bytes_priv decimal(20,2) default NULL,
>   hits_priv decimal(20,2) default NULL,
>   bytes_bus decimal(20,2) default NULL,
>   hits_bus decimal(20,2) default NULL,
>   cat1 varchar(100) default NULL,
>   cat2 varchar(100) default NULL,
>   cat3 varchar(100) default NULL,
>   PRIMARY KEY  (id)
> );
> 
> Here is a sample-data:
> 
> INSERT INTO url_cat_copy VALUES (272, '195.120.225.10', '195.120.225.10',
> 3040, 3, 2533.33, 2.50, 506.67, 0.50, 'Shopping', 'Religion',
> 'Music/Webradio');
> 
> Here ist the query:
> 
> SELECT  *
> FROM url_cat_copy
> WHERE bytes - ( bytes_priv + bytes_bus )  <> 0 OR hits - (hits_priv +
> hits_bus) <> 0;
> 
> The result from the query should be no record (empty recordset). With 4.0.20
> it was, with 4.1.3 it is not.
> 
> Can you reconstruct the problem on your 4.1.3 installation? Why has the
> result changed?
> How I must change the query, that the result is an empty recordset again?
> 
> Thank you in advance!
> Martin Rytz
> 
>
Thread
Problem with 4.1.3 that I not had with 4.0.20Martin Rytz24 Aug
  • Re: Problem with 4.1.3 that I not had with 4.0.20Leonardus Setiabudi24 Aug