Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
joins
/
explicit_cast
/
on_c_bigint_and_d28.sql
blob: 3135d0fe0e52b0b10f9d7b4932376b3e02d67c79 [
file
] [
log
] [
blame
]
select
CAST
(
a
.
c_bigint
as
BIGINT
),
CAST
(
b
.
d28
as
BIGINT
)
from
cast_tbl_1 a
,
cast_tbl_2 b
where
CAST
(
a
.
c_bigint
as
BIGINT
)
=
CAST
(
b
.
d28
as
BIGINT
)
order
by
1
,
2
nulls last limit
3
;