Allow Symbol columns to INNER JOIN to any column type

[rodryquintero]

Is your feature request related to a problem?

Currenlty unable to use INNER JOIN on a symbol column. The column type on the other table is int. We get the following error:

join column type mismatch

Describe the solution you'd like.

SYMBOL column types should be allowed as JOIN keys to any column data type.

Describe alternatives you've considered.

Creating duplicate columns:

• one for SYMBOL
• one for JOINS

Full Name:

ivan quintero

Affiliation:

Healthcare

Additional context

No response

[nwoolmer]

Hi @rodryquintero,

Does it work with a cast? e.g

create table testJoin1 (
  sym symbol,
  ts timestamp
)

create table testJoin2 (
  i int,
  ts timestamp
)

select * from testJoin1
inner join testJoin2 on sym = i::symbol

Alternatively to i::symbol syntax, you can use cast(i as symbol)

[rodryquintero]

Hello. Would prefer to avoid using CAST. **** Ivan Quintero

…

On Sat, Apr 6, 2024 at 7:13 AM Nick Woolmer ***@***.***> wrote: Hi @rodryquintero <https://github.com/rodryquintero>, Does it work with a cast? e.g create table testJoin1 ( sym symbol, ts timestamp ) create table testJoin2 ( i int, ts timestamp ) select * from testJoin1inner join testJoin2 on sym = i::symbol — Reply to this email directly, view it on GitHub <#4373 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAJWMSVOEHMRJYFREIL7NJDY37RFVAVCNFSM6AAAAABFXUIKJ2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANBRGA3DMMJUHE> . You are receiving this because you were mentioned.Message ID: ***@***.***>