title: redshift nulling columns when joining another table
body: <p>table_1 has 35 columns, table_2 has 20 columns</p>
  <p>query is:</p>
  <pre><code>select table1.*,
    table2.f1,
    ...
    table2.f20
  FROM public.table_1 as table1
      left join public.table_2 as table2
      on table1.id = table2.id 
          and table1.arrival_time::date &lt;= table2.end_date::date
          and table2.activity_date &lt; table2.end_date
  ;
  </code></pre>
  <p>this works I expect 469 rows to be returned and that's what I get. However several fields from table_1 get displayed as null instead of the values in the table.</p>
  <p>These fields are NOT part of the join.</p>
  <p>Due to IP concerns I can't provide the full details of the tables, each field in table_1 and table_2 are varchar (don't ask me why a timestamp is stored as a varchar - its a long story that I have no control over)</p>
  <p>This query WORKS in RDS PostgreSQL!</p>
  <p>Any ideas why it has a problem in redshift?</p>