New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL(mariadb): Pattern match a varchar column with a non-English scalar value. #673

Closed

goldmedal opened this issue Jul 16, 2024 · 0 comments · Fixed by #675

Labels

bug ibis

Contributor

goldmedal commented Jul 16, 2024

The discord user report this issue: https://discord.com/channels/1227143286951514152/1238608474003345468/1262627269982031872

It seems the Korean literal is converted to a literal U&' ... '. We should check if this behavior is correct.
The lower() function is generated by Wren AI. I'm not sure if it's correct for MariaDB but I think it works in DuckDB

D select lower('시험') = '시험';
┌──────────────────────────┐
│ (lower('시험') = '시험') │
│         boolean          │
├──────────────────────────┤
│ true                     │
└──────────────────────────┘

The text was updated successfully, but these errors were encountered:

goldmedal added bug ibis labels

grieve54706 assigned grieve54706 and unassigned grieve54706

grieve54706 mentioned this issue

Show original characters for string literals instead of escaping #675

Merged

goldmedal closed this as completed in #675

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment