Re: Installation 4.1.1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

Bertrand Lanneau wrote:
> Hi,
>
> Ok, I stole the file in the tar distribution and succeeded in the
> installation of mysql 4.1.1 .
>
> I then checked some new features i was interested in:
> - you wrote in the changelog that mysql 4.1.1 count now characters and
> no more bytes.
> I checked the length of "abé" and got 4 ... it doesn't work.
> - I had mentionned a bug two months ago : crash of mysql with the execution of
> create table t1 (col1 varchar(20) PRIMARY KEY, col2 varchar(30) not null,
unique index(col2));
> insert into t1 set col1="abc", col2="Ikéa";
> update t1 set col2="Ikea" where col2="Ikéa";
> This still crashes mysql...  :-(


How does this crashes MySQL? Please fill in repeatable test case and include
your server and client character set settings. If you already did that tell us
what Bug number in http://bugs.mysql.com is.



mysql> create table t1 (col1 varchar(20) PRIMARY KEY, col2 varchar(30) not null,
unique index(col2));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 set col1="abc", col2="Ikéa";
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1;
+------+-------+
| col1 | col2  |
+------+-------+
| abc  | Ikéa |
+------+-------+
1 row in set (0.00 sec)


mysql> select * from t1 where col2="Ikéa";
+------+-------+
| col1 | col2  |
+------+-------+
| abc  | Ikéa |
+------+-------+
1 row in set (0.00 sec)


mysql> update t1 set col2="Ikea" where col2="Ikéa";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from t1;
+------+------+
| col1 | col2 |
+------+------+
| abc  | Ikea |
+------+------+
1 row in set (0.00 sec)


Nothing wrong here.

For LENGHT() function I agree it is broken:


update t1 set col1="abé" where col2="Ikea";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select col1, length(col1) from t1;
+------+--------------+
| col1 | length(col1) |
+------+--------------+
| abé |            4 |
+------+--------------+
1 row in set (0.00 sec)


However CHAR_LENGTH() works well.

mysql> select col1, length(col1), char_length(col1) from t1;
+------+--------------+-------------------+
| col1 | length(col1) | char_length(col1) |
+------+--------------+-------------------+
| abé |            4 |                 3 |
+------+--------------+-------------------+



> Bertrand Lanneau.

Best regards

- --
 Are you MySQL certified? -> http://www.mysql.com/certification
 For technical support contracts, visit https://order.mysql.com/?ref=msal
    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /    Mr. Alexander Keremidarski <[email protected]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
 /_/  /_/\_, /___/\___\_\___/   Sofia, Bulgaria
         <___/  www.mysql.com


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/1blMeehWBZ4HcYkRAvd1AKCu6VpoalO1dCqs7OUXRvViePR1IQCgu2AN
teRunhRjg1CP1TITXdoqdiQ=
=x7hQ
-----END PGP SIGNATURE-----


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]