Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
joins
/
nulleqjoin
/
innrjn_flt2.drill_4985
blob: 38bd9b18df3f6d0e4d3f69fb74f8cf9dff299577 [
file
] [
log
] [
blame
]
SELECT t1
.
col_flt
,
t2
.
col_flt
FROM typeall_l t1 INNER JOIN typeall_r t2
ON CAST
(
t1
.
col_flt AS DOUBLE PRECISION
)
=
CAST
(
t2
.
col_flt AS DOUBLE PRECISION
)
OR
(
t1
.
col_flt IS NULL AND t2
.
col_flt IS NULL
);