Hi,
the last query should be select count(*) from nodes where node_name not in
(select node_name from filespaces)

NOT keyword between column name and IN keyword.

David RIGAUDIERE
Prestataire Logic
SI2M - Direction des Systèmes d’Information Groupe Malakoff Médéric
Direction de la Production Informatique
Gestion des Opérations - Stockage
4 rue de la Redoute 78 280 Guyancourt
01 30 44 53 13
Email : drigaudiere.prestataire AT si2m DOT fr
Email de groupe : dssp-gdo-esdb-ssd-sto-open.group

2015-01-09 15:25 GMT+01:00 Schofield, Neil (Storage & Middleware, Backup &
Restore) <Neil.Schofield AT lloydsbanking DOT com>:

> 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.
>

-- 

------------------------------

SI2M - Siège Social : 21 rue Laffitte, 75317 PARIS Cedex 9 - RCS Paris : 478 
042 831- Forme Juridique : GIE - SIREN/SIRET : 478 042 831 00030