Hi Vlad ! Why not using
select (select min( a ) is null from a) or null; as a workaround ? Regards, Jocelyn ----- Original Message ----- From: "Vlad Shalnev" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 03, 2004 7:01 AM Subject: Re: Comparing bug in 4.1.7 > > > Sergei Golubchik wrote: > > Hi! > > > > On Dec 02, Vlad Shalnev wrote: > > > > Looks like a bug. > > Could you submit a bugreport at http://bugs.mysql.com ? > > > > I've submitted a bugreport. > > Downgrade to 3.23 and wait for this problem solving. > > Thanks for all > > > > >>It happens after upgrade from 3.23.46. > >> > >>mysql> create table a ( a int not null ); > >>Query OK, 0 rows affected (0.00 sec) > >> > >>mysql> select min( a ) is null or null from a; > >>+--------------------------+ > >>| min( a ) is null or null | > >>+--------------------------+ > >>| NULL | -> Why ??? > >>+--------------------------+ > >>1 row in set (0.00 sec) > >> > >>It is very important for me to solve this problem. Thanks for any help > > > > > > Regards, > > Sergei > > > > -- > -------------------------------------------------------------------------- ------ > Vlad A. Shalnev > E-mail: [EMAIL PROTECTED] > > "Gravity can't be blamed > for someone > falling in love" > > ( Albert Einstein ) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]