List:Falcon Storage Engine« Previous MessageNext Message »
From:Kevin Lewis Date:October 21 2008 3:46pm
Subject:Re: bug#23692 Solutions
View as plain text  
Vlad,

You are right.  This solution would make 0x0943 less that null.  And you 
know what? It is, according to MyISAM!

mysql> create table m1 (a char(4)) engine myisam;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into m1 values (''), (0x43), (0x4300), (0x4320), (0x4309), 
(0x0943);
Query OK, 6 rows affected (0.02 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> select hex(a) from m1;
+--------+
| hex(a) |
+--------+
|        |
| 43     |
| 4300   |
| 43     |
| 4309   |
| 0943   |
+--------+
6 rows in set (0.00 sec)

mysql> select hex(a) from m1 order by a;
+--------+
| hex(a) |
+--------+
| 0943   |
|        |
| 4300   |
| 4309   |
| 43     |
| 43     |
+--------+
6 rows in set (0.00 sec)

Vladislav Vaintroub wrote:
>> 0x 43 09
>> 0x 43 {20}
>> 0x 43 {[20]}
>> 0x 43 43
> 
> Is '\tA' ==0x 09 41 less than nothing (empty string '',expanded to 0x20) in
> this convention? Is not this anomaly?
> 
>> -----Original Message-----
>> From: Kevin.Lewis@stripped [mailto:Kevin.Lewis@stripped]
>> Sent: Tuesday, October 21, 2008 4:57 PM
>> To: Lars-Erik Bjørk; Jim Starkey; Ann W. Harrison;
>> falcon@stripped
>> Subject: bug#23692 Solutions
> 
> 
> 
Thread
bug#23692 SolutionsKevin Lewis21 Oct
  • RE: bug#23692 SolutionsVladislav Vaintroub21 Oct
    • Re: bug#23692 SolutionsAnn W. Harrison21 Oct
    • Re: bug#23692 SolutionsKevin Lewis21 Oct
      • RE: bug#23692 SolutionsVladislav Vaintroub21 Oct