Bonjour Sinisa,
SM> There were some bug fixes with packed keys.
SM> 3.23.47 will soon be out and it would be fine if you could test your
SM> case with it again.
I tried to do
>alter table historique_AMS PACK_KEYS=0;
But it did not correct the problem.
Then I wanted check if the PACK_KEYS was equal to 0 when I do a
"mysqldump -d" of the table.
But I forgot the "-d" ... and here is what I found : There are some
"\r" at the end of some symbols ! (see below)
I don't know yet if this is a bug from my programs, but I don't
think so.
Any idea of how these "\r" appeared ? Could these have been added by
Mysql ?
Does it explain to you why the following query returns 31 rows
mysql> select * from historique_AMS where symbole='1rAUNIA';
while the following returns 306 rows ?
mysql> select * from historique_AMS_bak where symbole='1rAUNIA' order by date desc;
Regards,
Alex.
INSERT INTO historique_AMS VALUES
('1aA13456\r','2000-09-28',104.40000,104.40000,104.40000,104.40000,0);
INSERT INTO historique_AMS VALUES
('1aA850737','2000-09-28',8.00000,8.00000,8.00000,8.00000,0);
INSERT INTO historique_AMS VALUES
('1aA716338','2000-09-28',101.80000,101.80000,101.80000,101.80000,0);
INSERT INTO historique_AMS VALUES
('1aAAABTE','2001-11-06',138.50000,141.00000,137.20000,140.00000,7280);
INSERT INTO historique_AMS VALUES
('1aAFINTO','2000-09-28',36.00000,36.00000,36.00000,36.00000,0);
INSERT INTO historique_AMS VALUES
('1aAFTUSF','2000-09-28',23.45000,23.45000,23.45000,23.45000,0);
INSERT INTO historique_AMS VALUES
('1aA12283','2000-09-28',104.00000,104.00000,104.00000,104.00000,250000);
INSERT INTO historique_AMS VALUES
('1aA12299','2000-09-28',99.75000,99.75000,98.75000,98.75000,19000);
INSERT INTO historique_AMS VALUES
('1aA148140\r','2000-09-28',101.50000,101.50000,101.50000,101.50000,0);
INSERT INTO historique_AMS VALUES
('1rAOPG','2001-11-08',37.70000,37.90000,37.15000,37.45000,10317);
INSERT INTO historique_AMS VALUES
('1rAFOBRA\r','2000-09-28',27.50000,27.50000,27.50000,27.50000,0);
INSERT INTO historique_AMS VALUES
('1rAFOBR\r','2000-09-28',24.00000,24.00000,24.00000,24.00000,0);
INSERT INTO historique_AMS VALUES
('1aAFEF\r','2000-09-28',36.95000,36.95000,36.05000,36.95000,5006);
INSERT INTO historique_AMS VALUES
('1aAFEFSC\r','2000-09-28',68.25000,68.25000,68.25000,68.25000,0);
INSERT INTO historique_AMS VALUES
('1aAFORJA\r','2000-09-28',34.95000,35.00000,34.65000,35.00000,2064);
INSERT INTO historique_AMS VALUES
('1aAFRODF\r','2000-09-28',49.30000,49.30000,49.30000,49.30000,8528);
INSERT INTO historique_AMS VALUES
('1aAFRNX\r','2000-09-28',25.82000,25.82000,25.82000,25.82000,38920);
INSERT INTO historique_AMS VALUES
('1aAFRNI\r','2000-09-28',24.25000,24.30000,24.25000,24.25000,61900);
INSERT INTO historique_AMS VALUES
('1aAFRNV\r','2000-09-28',25.12000,25.12000,25.12000,25.12000,41454);
INSERT INTO historique_AMS VALUES
('1rAFOCCA\r','2000-09-28',914.00000,914.00000,914.00000,914.00000,0);
INSERT INTO historique_AMS VALUES
('1aAFBAMF\r','2000-09-28',33.25000,33.75000,33.25000,33.75000,1438);
INSERT INTO historique_AMS VALUES
('1rAFOCCB\r','2000-09-28',25.15000,25.15000,25.15000,25.15000,14250);
INSERT INTO historique_AMS VALUES
('1rAFORDA','2000-09-28',27.00000,27.00000,27.00000,27.00000,0);
INSERT INTO historique_AMS VALUES
('1aAFRNAF\r','2000-09-28',66.20000,66.20000,66.20000,66.20000,78);
INSERT INTO historique_AMS VALUES
('1aAFBNAS','2000-09-28',51.90000,51.90000,51.00000,51.00000,9447);
INSERT INTO historique_AMS VALUES
('1aAFRNUI\r','2000-09-28',52.98000,52.98000,52.98000,52.98000,760);
INSERT INTO historique_AMS VALUES
('1aAFOWMF\r','2000-09-28',53.50000,53.50000,53.00000,53.00000,18889);
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
