wrong display inside query when query failed

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
michabbb
Posts: 203
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

wrong display inside query when query failed

Post by michabbb » Fri 14 Jan 2022 14:02

hi alex,

i don´t know if that is intended to be that way, but when the MySQL error says:

Code: Select all

Unknown column 'i.bs_sort' in 'order clause'
dbforge marks the field inside the field list:

Image

and NOT field inside the ORDER:

Code: Select all

ORDER BY i.bs_sort, i.id;
but for my understanding, the "red lines" should be displayed in the "ORDER BY"
and not where it currently gets marked.

thanks,
micha

version: latest enterprise

alexa
Devart Team
Posts: 3072
Joined: Fri 24 Jun 2011 14:17

Re: wrong display inside query when query failed

Post by alexa » Tue 18 Jan 2022 12:31

Could you please provide us the CREATE definition of the table along with the query you are typing?

A video or screenshots would be of help.

michabbb
Posts: 203
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

Re: wrong display inside query when query failed

Post by michabbb » Tue 18 Jan 2022 12:50

hi alex,

i guess it has nothing to do with the table itself, more with the specific error,
you can test with any table (I guess):

Image

the MySQL error is:

Code: Select all

Unknown column 'i.bs_sort' in 'order clause
because MySQL doesn´t know the column that is used "inside the order",
I guess it would make more sense if dbforge would highlight the specific column
"inside the ORDER by" and not - as you see in my screenshot - in the SELECT part.

cheers,
micha

michabbb
Posts: 203
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

Re: wrong display inside query when query failed

Post by michabbb » Tue 18 Jan 2022 13:40

in another example dbforge marks the field correctly:

Image

:-)

Post Reply