From: Thimble Smith
Date: February 22 2000 9:40am
Subject: Impossible WHERE
List-Archive: http://lists.mysql.com/bugs/12
Message-Id: <20000222044052.B33803@threads.polyesthetic.msg>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Patrice, I am forwarding this to the bugs list, bugs@stripped.
I have verified that the bug still exists in 3.23.11.  We will fix
the bug as soon as we can.

Tim

----- Forwarded message from Patrice FAVRE <p.favre@stripped> -----

Date: Tue, 22 Feb 2000 10:07:46 +0100
From: Patrice FAVRE <p.favre@stripped>
Subject: Impossible WHERE
To: mysql@stripped

I have already posted this question but I haven't received any answer.

When I do the request :
select * from sites where name='patnom' and author='patauteur' and
category=0;
I receive "Empty set" where it should find one row.

This is the result of mysqldump for the table 'sites' :

# MySQL dump 6.6
#
# Host: localhost    Database: CCsites
#--------------------------------------------------------
# Server version        3.23.7-alpha-log

#
# Table structure for table 'sites'
#
CREATE TABLE sites (
  name varchar(50) DEFAULT '' NOT NULL,
  author varchar(50) DEFAULT '' NOT NULL,
  category decimal(10,0) DEFAULT '0' NOT NULL,
  email varchar(50),
  password varchar(50),
  proxy varchar(50),
  bitmap varchar(20),
  msg varchar(255),
  urlscol varchar(127),
  urlhttp varchar(127),
  timeout decimal(10,0),
  nbcnx decimal(10,0),
  creation decimal(10,0),
  livinguntil decimal(10,0),
  lang decimal(10,0),
  type decimal(10,0),
  subcat decimal(10,0),
  subtype decimal(10,0),
  reg char(1),
  scs varchar(255),
  capacity decimal(10,0),
  userISP varchar(50),
  CCident varchar(50) DEFAULT '' NOT NULL,
  PRIMARY KEY (name,author,category)
);

#
# Dumping data for table 'sites'
#

INSERT INTO sites VALUES
('patnom','patauteur',0,'p.favre@stripped',NULL,NULL,'#p2sndnq6ae5g1u6t','essai\nsalut','scol://195.242.78.119:patauteur.patnom',NULL,NULL,NULL,950036174,-882087474,NULL,3,0,3,'1','Pub/patnom/futur_divers.scs',NULL,'pat','CC1');

INSERT INTO sites VALUES
('LeNomDeMonSite','Marc',0,'m.barilley@stripped',NULL,NULL,NULL,NULL,'scol://195.242.78.119:Marc.LeNomDeMonSite',NULL,NULL,NULL,950560434,-881563214,NULL,3,0,3,'1','Pub/LeNomDeMonSite/domus_hibere.scs',NULL,'Marq','CC1');

----- End forwarded message -----

-- 
Tim Smith   < tim@stripped >  :MySQL Development Team:  Boone, NC  USA.