Are comparisons case-insensitive? If not then is there a COLLATE or something of the sort that is more efficient than wrapping all my string columns with UPPER()?
SELECT table1.*, table2.* FROM table1, table2 WHERE UPPER(table1.col1) = UPPER(table2.col1))
UPPER() in the above query necessary for case-insensitive comparisons in Dremio’s SQL?
Thanks in advance…