Bug #11090: where with null
| From: | jcastro at elnuevodia dot com | Date: | Thu, 24 May 2001 16:33:19 +0000 |
| Subject: | Bug #11090: where with null | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-56637@lists.php.net to get a copy of this message | ||
From: jcastro@elnuevodia.com
Operating system: Windows 2000 Professional
PHP version: 4.0.5
PHP Bug Type: ODBC related
Bug description: where with null
Database sybase
The following select works using slq advantage and returns values but when I use php I get nothing
and NO errors either.
SELECT
table_name.num_a,
table_name.num_b
from table_name
where table_name.num_b <> null and
table_name.num_a=1111
I also tried
SELECT
table_name.num_a,
table_name.num_b
from table_name
where table_name.num_b != null and
table_name.num_a=1111
In both cases I get no results but when using SQL adavantage from sybase I get the expected results.
The problems comes with the line
table_name.num_b != null
It seems like a bug. Please advise.
Thank you
--
Edit Bug report at: http://bugs.php.net/?id=11090&edit=1