LEFT OUTER JOIN and IS NOT NULL

This works fine:

select *
FROM w_8aaa_sales as s
LEFT OUTER JOIN max_dim_date as t
  ON t.the_date = s.saledate

And so does this:

select *
FROM w_8aaa_sales as s
WHERE s.saledate IS NOT NULL

But this does not:

select *
FROM w_8aaa_sales as s
LEFT OUTER JOIN max_dim_date as t
  ON t.the_date = s.saledate
WHERE s.saledate IS NOT NULL

There should be a row for 1975-02-02 on the left.

Please let me know if you can reproduce.

Thanks.
-Larry

Hi @Larry_Parker,

our enginners thinks this issue has been solved around feb 2021. Could you post the version of omnisci db you are running on?

You can get the excat version in omnisql with the version command

omnisql> \version
OmniSci Server Version: 5.5.2-20210222-aefdf7ece2

or from this tab on squirrelsql

Looks like we’re running the following:

omnisci/stable,now 5.4.1-20200928-3d17eec6c1 amd64 [installed,upgradable to: 5.5.2-20210222-aefdf7ece2]

thanks, @Larry_Parker,

The bug should be resolved in 5.5.x. Could you upgrade your system?

Regards,
Candido

Yup, just upgraded and it’s working now.

Thank you!
-Larry

1 Like