[bug]align with`RowMetaData#getColumnMetadata(String)` specification about r2dbc-mysql HOT 3 CLOSED

It is caused by MySqlNames.binarySearch and Sort Comparator

The searching should do something like C++ std::lower_bound does.

The sorting should consider about index.

from r2dbc-mysql.

Yep, we can just remove case-sensitive mode.

It was a feature for RowMetadata.contains

Implementations may allow escape characters to enforce a particular mode of comparison when querying for presence/absence of a column.

But only the javadoc for contains describes it, I don't see any description about this in the specification: https://r2dbc.io/spec/1.0.0.RELEASE/spec/html/#columnmetadata

from r2dbc-mysql.

@mirromutth
I found that in our current implementation, enclosing a name in backticks causes case-sensitive mode. However, I'm considering removing this feature, since queries like SELECT `t` from (SELECT 1 as `T`) c work in a case-insensitive manner(+mariadb-r2dbc seems not support backtick). What are your thoughts on this?

from r2dbc-mysql.