mmm I have an unexpected behavior, on this table:

CREATE TABLE 'tests' (

Ticker SYMBOL capacity 256 CACHE,

H FLOAT,

P_T FLOAT,

timestamp TIMESTAMP

) timestamp (timestamp) PARTITION BY MONTH;

After inserting data, calling from webui:

tests LT JOIN (tests LT JOIN (tests) ON (Ticker)) ON (Ticker)

resulting Ticker type changes to STRING instead of SYMBOL on Ticker1 This causes further problems when adding more ON statements. In the following select:

tests LT JOIN (tests LT JOIN (tests LT JOIN (tests)) ON (Ticker)) ON (Ticker)

The following error message occurs:

right side column 'Ticker1' is of unsupported type

Which is the default error message when trying to

LT JOIN ON

STRING column Any thoughts guys? I have updated the binaries to 7.0.0 but version is still showing 6.6.1

Sounds like it’s deliberate conversion from symbol to string. Some queries have to do for good reasons. Please submit github issue, we may suggest a workaround or a fix

ok, thanks