At 12:30 12/04/2001 +0200, BAUMEISTER Alexandre wrote:
Hi,
Maybe this issue is relative at your compiled version or platform
because I wasn't be able to repeat:
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
c:\mysql\bin>mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> create table test (
-> symbole char(20) not null primary key,
-> libelle char(100) not null,
-> index id_lib (libelle(1))
-> ) TYPE=INNOBASE;
Query OK, 0 rows affected (0.06 sec)
mysql> insert into test values('AAAAA','ABCDEF');
Query OK, 1 row affected (0.03 sec)
mysql> select * from test;
+---------+---------+
| symbole | libelle |
+---------+---------+
| AAAAA | ABCDEF |
+---------+---------+
1 row in set (0.00 sec)
mysql> show index from test;
+-------+------------+----------+--------------+-------------+-----------+------
-------+----------+--------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardi
nality | Sub_part | Packed | Comment |
+-------+------------+----------+--------------+-------------+-----------+------
-------+----------+--------+---------+
| test | 0 | PRIMARY | 1 | symbole | A |
NULL | NULL | NULL | |
| test | 1 | id_lib | 1 | libelle | A |
NULL | 1 | NULL | |
+-------+------------+----------+--------------+-------------+-----------+------
-------+----------+--------+---------+
2 rows in set (0.00 sec)
mysql> select * from test where libelle like 'A%';
+---------+---------+
| symbole | libelle |
+---------+---------+
| AAAAA | ABCDEF |
+---------+---------+
1 row in set (0.00 sec)
mysql> select * from test where libelle like 'a%';
+---------+---------+
| symbole | libelle |
+---------+---------+
| AAAAA | ABCDEF |
+---------+---------+
1 row in set (0.02 sec)
mysql>
Regards,
Miguel
>Bonjour,
>
> We found a bug in INNOBASE tables with col_name(length) indexes.
>
> Here is the table :
>
>create table test (
> symbole char(20) not null primary key,
> libelle char(100) not null,
> index id_lib (libelle(1))
>) TYPE=INNOBASE;
>
>
> For the test I insert one row but there can be many, the result is
> the same :
>
>insert into test values('AAAAA','ABCDEF');
>
> I check that the row is in the table :
>
>mysql> select * from test;
>+---------+---------+
>| symbole | libelle |
>+---------+---------+
>| AAAAA | ABCDEF |
>+---------+---------+
>1 row in set (0.00 sec)
>
> I check the indexes in the table :
>
>mysql> show index from test;
>+-------+------------+----------+--------------+--------------+-----------+-------------+----------+--------+---------+
>| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
>| Cardinality | Sub_part | Packed | Comment |
>+-------+------------+----------+--------------+--------------+-----------+-------------+----------+--------+---------+
>| test | 0 | PRIMARY | 1 | symbole |
>A | NULL | NULL | NULL | |
>| test | 1 | id_lib | 1 | libelle |
>A | NULL | 1 | NULL | |
>+-------+------------+----------+--------------+--------------+-----------+-------------+----------+--------+---------+
>2 rows in set (0.00 sec)
>
> But here is the problem :
>
>mysql> select * from test where libelle like 'A%';
>Empty set (0.00 sec)
>
>mysql> select * from test where libelle like 'a%';
>Empty set (0.00 sec)
>
>
> This bug does not occur with a MyISAM table.
>
> We use Myslq-3.23.26 with latest Solaris patch from Heikki, under
> Solaris 2.8 and SPARC 4 CPU.
>
> Regards,
> Alex.
>
>
>
>---------------------------------------------------------------------
>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
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil
<___/ Development Team
---------------------------------------------------------------------
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