isql query fails to return correct result
-----------------------------------------
Key: CORE-6008
URL: http://tracker.firebirdsql.org/browse/CORE-6008
Project: Firebird Core
Issue Type: Bug
Environment: ISQL Version: LI-V2.5.7.27050 Firebird 2.5
Reporter: Ray Holme
Priority: Minor
This was originally a delete query, but select shows the problem well - I have
a copy of both the query and a minimal backed up DB that I can provide.
The very first query returns erroneous results, the following queries prove the
error;
Database: working.db, User: sysdba
SQL> select count(*) from addresses
CON> where addr_id not in (select addr_id from office_defaults)
CON> and addr_id not in (select addr_id from people)
CON> and addr_id not in (select addr_id from people_more_addrs)
CON> and addr_id not in (select addr_id from patients);
0
SQL> select count(*) from addresses where addr_id in (1596, 5341, 3331, 3534);
4
SQL> select count(*) from office_defaults where addr_id in (1596, 5341, 3331,
3534);
0
SQL> select count(*) from people where addr_id in (1596, 5341, 3331, 3534);
0
SQL> select count(*) from people_more_addrs where addr_id in (1596, 5341, 3331,
3534)
0
SQL> select count(*) from patients where addr_id in (1596, 5341, 3331, 3534);
0
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
