Description: Hello,

I am working with mysqld-max-nt under windows 2000 and unsing InnoDb tables.

After running the following select:

Select cod,nom from grupos where cod <'005' order by cod desc limit 1

mysqld crashes.

Also it crashes whith limit 10, limit 50, or whatever limit you indicate.

However, the following selects run ok: Select cod,nom from grupos where cod <'005' order by cod desc (without
limit) Select * from grupos where cod <’D01’ order by cod desc limit 1 Select * from grupos where strcmp(cod,’005')<0 order by cod desc limit 1 Select * from grupos where cod < 005 order by cod desc limit 1 Select * from grupos where cod <5 order by cod desc limit 1

This error only occurs with InnoDb tables and MySql 4.0.3 (with Mysql
3.23.52 it runs ok). With MyIsam tables it runs ok even under mysql 4.0.3

Table definition and data. CREATE TABLE grupos ( Cod char(3) NOT NULL default '', Nom varchar(40) NOT NULL default '', CVt varchar(9) NOT NULL default '', CCm varchar(9) NOT NULL default '', Garantia tinyint(4) unsigned NOT NULL default '0', Fam char(2) NOT NULL default '', LineaProducto char(3) NOT NULL default '', PRIMARY KEY (Cod), UNIQUE KEY Nombre (Nom,Cod) ) TYPE=InnoDB;

-- -- Dumping data for table 'grupos'

--

INSERT INTO grupos VALUES ('001','COMP. UHF L. BLANCA BAJA II
R-134/600/12','','',0,'AA',''); INSERT INTO grupos VALUES ('002','COMP. UHF AIRE
ACONDICIONADO','','',0,'AA',''); INSERT INTO grupos VALUES ('003','COMP. ASPERA LINEA BLANCA
R134/600/12','','',0,'AB',''); INSERT INTO grupos VALUES ('004','COMP. ASPERA AIRE
ACONDICIONADO','','',0,'AB',''); INSERT INTO grupos VALUES ('005','COMP. DANFOSS','','',0,'AC',''); INSERT INTO grupos VALUES ('006','CONTROLES REFRIG. Y ELECTRONICA
DANFOSS','','',0,'AC',''); INSERT INTO grupos VALUES ('007','INDUSTRIAL DANFOSS','','',0,'AC',''); INSERT INTO grupos VALUES ('008','CALEFACCION Y AIRE ACONDICIONADO
DANFOSS','','',0,'AC',''); INSERT INTO grupos VALUES ('009','ELECTRICIDAD DANFOSS','','',0,'AC',''); INSERT INTO grupos VALUES ('010','COMP. MT/MTZ HASTA 160','','',0,'AD',''); INSERT INTO grupos VALUES ('011','REPUESTO BITZER','','',0,'AE',''); INSERT INTO grupos VALUES ('012','COMP./UNID. BITZER HASTA 7,5 CV
OCTAGON','','',0,'AE',''); INSERT INTO grupos VALUES ('013','COMPRESORES SCROLL/UNIDADES','','',0,'AE',''); INSERT INTO grupos VALUES ('014','REPUESTO FRASCOLD','','',0,'AF','');

Thanks in advance, Rafa.

P.D: Sorry for my english.

How-To-Repeat: Select cod,nom from grupos where cod <'005' order by cod desc limit 1, Fix: -

Synopsis: MySql/InnoDB crashes after a Select...order by DESC... LIMIT...

Submitter-Id: <submitter ID> Originator: Rafa Organization: Pecomark MySQL support: none Severity: non-critical Priority: medium Category: mysqld-max-nt Class: sw-bug Release: mysqld 4.0.3 beta(InnoDB)

Exectutable: mysqld-max-nt Environment: Pentium III-MMX, 500 MHZ, 540 MB System: Windows 2000 Compiler: - Architecture: i

__________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/