4.1 in production

Hey all,
are people using mysql 4.1.0 of 4.1.1 on production servers yet, or should we
wait for a more stable release?

i know this is somewhat subjective to the use.

I have a major upgrade to my database system coming soon, and i want to
coordinate it with my server upgrade, so im trying to figure out if it is
wise to upgrade mysql yet.

thanks much,
sean peters
speters@wiredata.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: 4.1 in production

Victoria Reznichenko writes:

> "Holly Chamberlain" wrote:
>
>>
>> Does anyone have a good site that contains the current SQL standard? Or
>> does anyone know is ISNULL() and IFNULL(), and similar null testing
>> functions, standard SQL or extensions to SQL?
>
> No, there are no such functions in the SQL-99. In the standard you can
> find IS [NOT] NULL to see if value is NULL or not.

There is[1]. The SQL standard defines following special CASE-END
shortcut functions:

NULLIF() To convert ITEM to NULL
COALESCE() To convert NULL to ITEM (this is what you usually want)

Jari Aalto

------------------------------------------------------------ -----------

[1] The SQL:1992 standard, heading "6.9 ".
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

::=
NULLIF

| COALESCE
{ }...

As standards are backward compatible, this applies to SQL:2008 as well.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org