Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Sat, Dec 30 2006 11:52 PM	Permanent Link
"Ralf Bertoldi"	there is a bug in 4.25 b1 with IF's and strings. Table mytable Field1 boolean Field2 string 2 Records False, '' True, '' True, 'something' SQL: SELECT IF(Field1, Field2,'') FROM mytable; Result in 4.24 '' '' 'something' Result in 4.25 '' '' '' if the first matching IF is '' then the rest of the result set is ''... regards Ralf
Sun, Dec 31 2006 12:11 AM	Permanent Link
"Ralf Bertoldi"	sorry, just saw that it was fixed in Build2.. > > there is a bug in 4.25 b1 with IF's and strings. > > Table mytable > Field1 boolean > Field2 string > > 2 Records > False, '' > True, '' > True, 'something' > > SQL: > SELECT IF(Field1, Field2,'') FROM mytable; > > Result in 4.24 > '' > '' > 'something' > > Result in 4.25 > '' > '' > '' > > > if the first matching IF is '' then the rest of the result set is > ''... > > > regards > Ralf --