This message was deleted.

if

col_a

is a

long

(aka

BIGINT

) column then i believe these are equivalent. if

col_a

is string then they are not, since (2) will insert a cast to number, so for example, the string

100.0

will still match. this means that for string

col_a

, (2) will match more values, and will also be slower (due to the cast)