Hello!
I have an issue with MonetDB query.
This one
select count(*)
  from catalogedsources c1
  left outer join catalogedsources c2 on (
    c2.cat_id = c1.cat_id + 2
AND ((c1.decl - c2.decl) * (c1.decl - c2.decl))< 1e-06)
 where
    c1.cat_id = 4
   AND c1.decl BETWEEN 77.0 AND 83.0
   AND c1.ra BETWEEN 42.0 AND 48.0
;
works fine. But if I replace "c2.cat_id = c1.cat_id + 2" with "c2.cat_id = 6" - i receive nothing. Not zero, not empty dataset, but just nothing at all. "EXPLAIN" does not work as well.
Also, with more complex join conditions I have no result as well.
I am using:
Welcome to mclient, the MonetDB/SQL interactive terminal (Dec2011-SP1)
Database: MonetDB v11.7.7 (Dec2011-SP1), 'mapi:monetdb://linux-6d2s.site:50000/*****'

What can this be?

Regards,
Alexey