SUPPORTS_ALPHANUMS=True for MySQL

[vmatt]

Describe the bug
I want to validate varchar pk column in MySQL vs Snowflake.

I noticed that sqeleton parses columns as Text(), but for Snowflake, it parses as String_Alphanum(), latter can be used for validation.

I modified MySQL SUPPORTS_APHANUMS = False -> True, after that reladiff runs just fine for my dataset.

Is this flag still needed?

Describe the environment

• sqeleton 0.1.6
• reladiff 0.5.3
• MySQL 8.0.32

[erezsh]

The reason it is false, is because mysql sorts text using "natural sorting" instead of alphanumeric sorting, which are incompatible.

It is possible that your tests worked because you didn't test the right edge-cases.

It might be possible to "trick" mysql to sort correctly, as outlined here: https://www.copterlabs.com/natural-sorting-in-mysql/

But I don't know for sure

[vmatt]

Ah see! I actually forked a repo today to make some adjustment, I'll take a look a try it!

[vmatt]

Ah, now I see your point, actually I'm having issue with another dataset where it fails for the exact reason. It understand now why it's a hard nut to crack, I think we cannot solve this without an UDF / stored procs which normalizes the PK column.