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.

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

An error in field prompt is found when the field in the query box contain symbols. #1934

Closed
linauror opened this issue Apr 7, 2024 · 1 comment

Comments

@linauror
Copy link

linauror commented Apr 7, 2024

Preconditions

  • HeidiSQL version: 12.6.0.6819
  • Database type and version: MySQL 5.6.21
  • OS: Window 10

Describe the bug

show create table user like this

CREATE TABLE user (
    uid INT(10) NOT NULL AUTO_INCREMENT,
    gender INT(10) NOT NULL DEFAULT '0' COMMENT '1, male 2, female',
    PRIMARY KEY (uid) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB

SQL like this:

SQL1: SELECT * FROM user WHERE gender = 1;
SQL2: SELECT * FROM user WHERE `gender` = 1;

When i selected gender field AND Run command Show SQL completion proposal, the SQL1 can be displayed correctly , but SQL2 cann't.

To Reproduce

1, wirte sql with symbols `
2, selected field
3, Run command Show SQL completion proposal

Screenshots or Crash reports

20240407173759
20240407173820

ansgarbecker added a commit that referenced this issue Apr 14, 2024
@ansgarbecker
Copy link
Collaborator

Should be fixed in the next build.

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

No branches or pull requests

2 participants