Skip to content

Dolt uppercases a lowercase non-ASCII initial in SOUNDEX #11546

Description

@Yibo-Dong

what happened

Dolt returns an uppercased Soundex code for a lowercase accented initial, unlike MySQL's preserved lowercase output.

Environment

Dolt main (commit c3b5ce3c67f8677ca08a0a58d8c03cdc95bff8b7). MySQL version 8.0.43.

How to reproduce

Run the corresponding SQL in a fresh Dolt repository.

SELECT FIRST_VALUE(SOUNDEX('é')) OVER () AS actual FROM (SELECT 1 AS z) q;

Expected Result

MySQL returns é000.

Actual Result

Dolt returns É000.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingcorrectnessWe don't return the same result as MySQLcustomer issue

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions