The following query fails for me on OmniSci 5.5.2-20210222-aefdf7ece2.
SELECT COUNT(*) FROM max_dim_date t WHERE EXISTS ( SELECT NULL FROM w_8aaa_sales as s WHERE s.saledate = t.the_date )
I get the following error in DBeaver, which usually indicates an internal error in OmniSci.
[TIOStreamTransport.java:read:130:org.apache.thrift.transport.TTransportException: Socket is closed by peer.]
There’s a one-to-many relationship from
w_8aaa_sales, so I cannot do a join because the count will be incorrect.
Are you able to repro?
Is there another query that I can use to work around the problem?