Hi,
Try to do the following:
*) Import the dump file I sent to you attached to this e-mail. There is a
table called l5 and some data in the dump file.
*) run the command:
select conjuge.l5_nome from l5 as conjuge, l5 as parte where parte.l5_parte
= 8 and parte.l5_seq = 0 and conjuge.l5_parte = parte.l5_parteconjuge order
by conjuge.l5_seq desc limit 1;
It shows the error 1105: Unknown error <-- here is the bug!!!
*) run the command:
select conjuge.l5_nome from l5 as conjuge, l5 as parte where parte.l5_parte
= 8 and parte.l5_seq = 0 and conjuge.l5_parte = parte.l5_parteconjuge group
by conjuge.l5_seq having max(conjuge.l5_seq);
It returns an empty set. It is what I would like had happend in the previous command.
My System is Linux Debian Box kernel 2.4.18...
with 768 of ram and MySQl 4.0.13 using InnoDB Tables !!!
I have a dump of table with the bug ! i cant send file to the list...
exists a FTP to put the file ?
sql,query,innodb,hellllp please
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 1647350
$ look into "my eyes" Phone : +55 041 296-2311
look: cannot open my eyes Fax : +55 041 296-6640
-------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
