Are string comparisons case-insensitive?

1

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…

2

@monocongo

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

WHERE UPPER(column_name) = ‘VALUE_IN_UPPER_CASE’