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.prestata...@si2m.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.schofi...@lloydsbanking.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