Skip to content
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

constraint_name condition is ignored in KEY_COLUMN_USAGE #55235

Closed
YangKeao opened this issue Aug 6, 2024 · 2 comments · Fixed by #55236
Closed

constraint_name condition is ignored in KEY_COLUMN_USAGE #55235

YangKeao opened this issue Aug 6, 2024 · 2 comments · Fixed by #55236
Labels
severity/major type/bug The issue is confirmed as a bug.

Comments

@YangKeao
Copy link
Member

YangKeao commented Aug 6, 2024

This issue is similar to #55156, and is introduced in #54333.

I'd like to introduce a better way to test these functions 🤔 . It's really easy to make mistakes by not using one of the extracted conditions.
@YangKeao YangKeao added the type/bug The issue is confirmed as a bug. label Aug 6, 2024
@YangKeao
Copy link
Member Author

YangKeao commented Aug 6, 2024

I found this issue by running the typeorm test on TiDB.

@YangKeao
Copy link
Member Author

YangKeao commented Aug 6, 2024 •
edited
Loading

As it may cause some unexpected behavior of some ORM (or any software that depends on the result), I set the severity to major. typeorm will create wrong ALTER TABLE statement because it gets wrong information about the primary index, which is quite scaring.

@YangKeao YangKeao mentioned this issue Aug 6, 2024
Merged
5 tasks
@ti-chi-bot ti-chi-bot bot closed this as completed in 7291829 Aug 7, 2024
@YangKeao YangKeao mentioned this issue Aug 7, 2024
Closed
hawkingrei pushed a commit to hawkingrei/tidb that referenced this issue Aug 8, 2024
@YangKeao @hawkingrei
executor: fix the issue that some extracted conditions are not used i…
469240b 
…n information_schema (pingcap#55236)

close pingcap#55235
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
1 participant
@YangKeao