Ahasuerus - 2018-01-03
  • Description has changed:

Diff:

--- old
+++ new
@@ -1 +1,9 @@
-Advanced Searches on 'not exactly' and 'does not contain' can fail if the referenced field belongs to another table. The problem has been confirmed with Advanced Title Searches which use 'not exactly' and 'does not contain' on Series names and Advanced Publication Searches which use 'not exactly' and 'does not contain' on Publication Series names. Advanced Publication Searches which use 'not exactly' and 'does not contain' on Publisher names appear to be OK. We need to determine why it's working for the latter but not the former.
+Advanced Searches on 'not exactly' and 'does not contain' can fail if the referenced field belongs to another table. The problem has been confirmed for Advanced Title Searches which use 'not exactly' and 'does not contain' on Series names and Advanced Publication Searches which use 'not exactly' and 'does not contain' on Publication Series names. For example, an Advanced Publication Search on:
+
+1. Author's Name is exactly Poul Anderson
+2. Title contains !
+3. Publication Series is not exactly Ace Double
+
+finds only 2 publication records. There are other eligible publication records like the Dennis Dobson edition of "Let the Spacemen Beware!", but they are ignored because they are not in a publication series.
+
+The problem with the SQL query is that it always does a join between the main table (title or publication) and the supporting table (series, publication series, etc.) If a row in the main table doesn't point to a row in the supporting table, the query doens't retrieve it.