Works fine on NT version 3.22.20
Works fine on Solaris 2.7 Intel version 3.23.5-alpha.
>
>Hi,
>
>Solaris x86 2.6, MySQL 3.22.27 works fine.
>
>Maybe you should go to the local shop, and buy a big box of tissues!
>
>Quentin
>
>> -----Original Message-----
>> From: Kiyanosh Kamdar [SMTP:kenk@stripped]
>> Sent: Thursday, January 20, 2000 12:32 PM
>> To: mysql@stripped
>> Subject: Try This!!! Please...
>>
>> Hello,
>>
>> Please try the following and tell me what kind of output you get. I
>> am getting very strange results. I am in tears now. :(
>>
>>
>> create table stuff (
>> bit bigint not null,
>> name varchar(255) not null,
>>
>> unique(bit),
>> unique(name)
>> );
>>
>> insert into stuff (bit,name) values(pow(2,0),"name1");
>> insert into stuff (bit,name) values(pow(2,1),"name2");
>> insert into stuff (bit,name) values(pow(2,2),"name3");
>> insert into stuff (bit,name) values(pow(2,3),"name4");
>> insert into stuff (bit,name) values(pow(2,4),"name5");
>> insert into stuff (bit,name) values(pow(2,5),"name6");
>> insert into stuff (bit,name) values(pow(2,6),"name7");
>> insert into stuff (bit,name) values(pow(2,7),"name8");
>>
>>
>> Now try this and tell me what the result is:
>>
>> select (bit&0xff) !=0 from stuff where name="name2";
>>
>> **WHY** is this the empty set
>>
>> Try this again:
>>
>> select * from stuff order by bit;
>>
>> **WHY** does the row with bit=128 get listed first????
>>
>> HELP please!!!
>>
>> Thanks
>>
>> Ken
>>
>> Details:
>>
>> mysql Ver 9.38 Distrib 3.22.30, for sun-solaris2.6 (sparc)
>>
>> Connection id: 21
>> Current database: bugs
>> Current user: kenk@localhost
>> Server version 3.22.30
>> Protocol version 10
>>
>>
>>
>>
>> --
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>> posting. To request this thread, e-mail mysql-thread24754@stripped
>>
>> To unsubscribe, send a message to:
>> <mysql-unsubscribe-quentin.bennett=trilogy.co.nz@stripped>
>
>
>
>
>==========================================================================
>This e-mail message has been scanned and cleared by MailMarshal
>MailMarshal Web Site: http://www.mailmarshal.com/
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread24756@stripped
>
>To unsubscribe, send a message to:
> <mysql-unsubscribe-cj=interlog.com@stripped>
>
>
>
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped
