databend icon indicating copy to clipboard operation
databend copied to clipboard

bug: databend should sustain case-sensitive for query alias names

Open jackjoesh opened this issue 1 year ago • 1 comments

Search before asking

  • [X] I had searched in the issues and found no similar issues.

Version

Version: v1.2.174-nightly

What's Wrong?

databend should sustain case-sensitive for query alias names, this is very important for mybatis mapping to the java object. And this function shouldn't be controlled by 'unquoted_ident_case_sensitive' due to they are not the same thing

How to Reproduce?

image

If this occurring, mybatis can't map db fields to java object, this is terrible for business system migrating to databend. And this function shouldn't be controlled by 'unquoted_ident_case_sensitive' due to they are not the same thing, still needing to convert some where clauses to lower case.

Are you willing to submit PR?

  • [ ] Yes I am willing to submit a PR!

jackjoesh avatar Jan 02 '24 13:01 jackjoesh

Maybe you need:

select order_id as `orderId` from blob_test limit 5;

wubx avatar Jan 02 '24 22:01 wubx