blob: db51ff633ae40942151e2a175217e30677799031 [file] [log] [blame]
select
count(*)
from
j1 LEFT OUTER JOIN j4
ON ( j1.c_date = j4.c_date
and j1.c_time = j4.c_time
and j1.c_timestamp = j4.c_timestamp
and j1.c_varchar = j4.c_varchar
and j1.c_float = j4.c_float
and j1.c_double = j4.c_double
and j1.d9 = j4.d9
and j1.d18 = j4.d18
and j1.d28 = j4.d28
and j1.d38 = j4.d38
-- drill-1337: join filter on the left side of the outer join
and j1.c_integer > 0
and j1.c_integer IS NOT NULL
)
;