Are string comparisons case-insensitive?

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()?

For example:

SELECT table1.*, table2.*
FROM table1, table2
WHERE UPPER(table1.col1) = UPPER(table2.col1))

Is the UPPER() in the above query necessary for case-insensitive comparisons in Dremio’s SQL?

Thanks in advance…


In general, the literal in the FILTER condition is case sensitive, so you can do