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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
