[BUG?] SELECT STATEMENT ON COLUMN WITH NULLS

Kevin Wilson <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
I apologize if this has been reported already but here it is anyway.

1) I have an ASCII column called STATUS that allows NULL.
2) There are 190k+ records with mixed values in this column.
3) Running the following query causes the column that has 
	the value of NULL to be filtered out which results in 
	a inaccurate count:

	select COUNT(*) from call 
	where status != 'CLOSED'

4) Running the following query allows the NULL values to be counted:

	select COUNT(*) from call 
	where status != 'CLOSED' OR STATUS IS NULL	

This occurs in both the SQL Studio as well as the JDBC driver and I will
guess that the ODBC driver is affected as well.

[Sys Info]
SAPDB v7.3.0.34 (ASCII) on SuSE v8.1


Please advise if this was previously reported and I simply missed it and
need to update to .40 of the server.

Thanks,

Kevin

"Those who would give up essential liberty to purchase a little temporary
safety deserve neither liberty nor safety."
     -Benjamin Franklin, 1759
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.