Bug: Wrong Displayorder Data

[GuidoL1982]

Hello,

i open a DataGrid over Table1 -->"Retrieve Data" and changed the generated statement. The result is wrong sort data.

A bug?




MySql Version: 5.5.25a-1~dotdeb.1-log
dbForge Version: 5.0.82

[.jp]

It's a very strange behaviour. I did some tests and couldn't reproduce this case.
Would you please try to execute your query in a new SQL document. Will you get the problem in the Data Grid?
Also try to use a filter in a column header (and sorting) instead of writing additional WHERE and ORDER BY clauses.

By the way, you are using an old build of the tool. Please download the latest one (5.0.97).

[pitterlee]

I think it is by design, but don't you think that my remark has a sense and that should be an enhancement to the product?

[alexa]

Unfortunately, we still were not able to reproduce this issue.

Could you please provide us the CREATE TABLE statement of this table and the hexadecimal representations of the first and last cells containing the value '27628' on the screenshot:

1. Right-click the value in the grid and select 'Data Viewer' from the popup menu.
2. Switch to the hexadecimal view by clicking the corresponding button on the toolbar of the 'Data Viewer' window.

[GuidoL1982]

Sorry for the late answer.

Now i use the Version 5.0.97.
I performed the same steps but i can´t reproduce the problem.

Thank you for the effort

Bye Guido