varchar join integer


varchar join integer

Consider two tables ,one has COLUMN_A defined as a VARCHAR(100) and the other has COLUMN_A defined as an INTEGER. When joining these two tables via COLUMN_A what does the optimizer have to do in order to accomplish the join?Convert VARCHAR to INTEGER  or convert INTEGER to VARCHAR? thanks.

Junior Contributor

Re: varchar join integer

When you look at Explain you will see that the VARCHAR is casted to a FLOAT.