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

Error choosing table fields with aliases #848

Closed
vjulca opened this issue Jan 10, 2020 · 2 comments
Closed

Error choosing table fields with aliases #848

vjulca opened this issue Jan 10, 2020 · 2 comments

Comments

@vjulca
Copy link

@vjulca vjulca commented Jan 10, 2020

Steps to reproduce this issue

  1. Step 1;

I create the sentence with * to show me all the fields.

SELECT * FROM ADUANAS.REPORTES A WHERE A.CODIGO = '2269' ORDER BY A.CODIGO DESC, A.NROCAMP ASC;

  1. Step 2;

I use the alias of the table to choose only the fields I need.

SELECT A. FROM ADUANAS.REPORTES A WHERE A.CODIGO = '2269' ORDER BY A.CODIGO DESC, A.NROCAMP ASC;

Current behavior

When writing the point I get the following error:

"An error ocurred in the application."

Expected behavior

When writing the point, the fields in the table should be shown, as has always happened.

Possible solution

I have no idea.

Environment

  • HeidiSQL version:

10.3.0.5812

  • Database system and version:

MySQL 5.6.38

  • Operating system:

Windows 10 x64 build 18363

ansgarbecker added a commit that referenced this issue Jan 13, 2020
@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Jan 13, 2020

Should be fixed. Though I now need to create some cache for recurring SQL queries I suppose.

@vjulca

This comment has been minimized.

Copy link
Author

@vjulca vjulca commented Jan 13, 2020

I have done some tests and it is working fine. Thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.