MySQL joins are not case-sensitive!

user022825

I just realized that joins in SQL in DOMO are not case sensitive! This is a huge problem for me and my team. Here's an example:

 

table_1:

team	manager_id
Sales	John123
Marketing	Joe341

 

table_2:

location	manager_id_2
Michigan	John123
California	JOhn123
Texas	JOHN123

 

 

select

table_1.*,
table_2.*

from table_1

left join table_2 on table_1.manager_id = table_2.manager_id_2

 

I get:

team	manager_id	location	manager_id_2
Sales	John123	Michigan	John123
Sales	John123	Michigan	JOhn123
Sales	John123	Michigan	JOHN123
Marketing	Joe341

 

Can anyone tell how to make the join case sensitive?

GrantSmith

Hi @user022825 

 

You can utilize the BINARY keyword to force MySql dataflow to do a case sensitive join.

 

select

table_1.*,
table_2.*

from table_1

left join table_2 on BINARY table_1.manager_id = table_2.manager_id_2