Scrambled columns in views

[expired user #11525]'s profile image [expired user #11525] posted 6 years ago in General Permalink

I've just upgraded MySQL server to 8.0, which means I've also imported my databases recently and installed the newest version of Heidi. When I click on the data tab for a view, the columns are displaying in alphabetical order rather than by the ordinal number of the column. The data stays in the same order, so the results look crazy (commas in a varchar column). When I do a select from, the results look fine. What could be causing this? I am attaching the scrambled view, the results of a select, and the show columns output.

3 attachment(s):
  • view_scrambled
  • select_view
  • show_columns
ansgar's profile image ansgar posted 6 years ago Permalink

Could you please post the CREATE TABLE code in a new issue on the bugtracker? I never saw that issue, so I have to dive deeper into it. Only I need a ticket.

[expired user #11728]'s profile image [expired user #11728] posted 6 years ago Permalink

facing same issue after upgrading to MySQL 8.

1 attachment(s):
  • Untitled-01

Please login to leave a reply, or register at first.