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

Reply via email to