Re: [ADSM-L] Changed SQL behavior under server 6.2.3.1
2015-01-09 09:27:06
Zoltan
Thanks for the response. I'm not sure whether this is platform related - all my
tests were conducted on servers running on AIX. While the problem is not
apparent on v5.x instances, it seems to affect v6.x instances at all our levels.
Like Margaret's experience back in 2012, the problem seems to relate
specifically to the use of NOT in the WHERE clause -eg in the following
example, only the last returns incorrect results:
tsm: XXXXX>select count(*) from nodes
Unnamed[1]
------------
1519
tsm: XXXXX>select count(*) from nodes where node_name in (select node_name from
filespaces)
Unnamed[1]
------------
1413
tsm: XXXXX>select count(*) from nodes where not node_name in (select node_name
from filespaces)
Unnamed[1]
------------
0
Regards
Neil
Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ.
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc.
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000.
Telephone: 08457 21 31 41. Cheltenham & Gloucester plc. Registered Office:
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428.
Telephone: 0845 603 1637
Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential
Regulation Authority and regulated by the Financial Conduct Authority and
Prudential Regulation Authority.
Cheltenham & Gloucester plc is authorised and regulated by the Financial
Conduct Authority.
Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings
is a division of Lloyds Bank plc.
HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in
Scotland no. SC218813.
This e-mail (including any attachments) is private and confidential and may
contain privileged material. If you have received this e-mail in error, please
notify the sender and delete it (including any attachments) immediately. You
must not copy, distribute, disclose or use any of the information in it or any
attachments. Telephone calls may be monitored or recorded.
|
|
|