List:General Discussion« Previous MessageNext Message »
From:Christopher R. Jones Date:January 20 2000 12:36am
Subject:RE: Try This!!! Please...
View as plain text  
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


Thread
Try This!!! Please...Kiyanosh Kamdar20 Jan
  • Re: Try This!!! Please...Jan Dvorak20 Jan
  • RE: Try This!!! Please...David Adams20 Jan
RE: Try This!!! Please...Quentin Bennett20 Jan
RE: Try This!!! Please...Christopher R. Jones20 Jan