Clicking on a view crashes Heidi

Is this where I post bugs now? Hope so.

I have a view defined in one of my schemas. Don't remember the last time I had to do anything with it. Anyway I'm now unable to get into the view to edit it or see the data. Every time I click on the view in the left pane Heidi crashes.

I'm up to revision 3579 and still have the problem. Here's the bug report:

date/time         : 2010-11-04, 17:03:12, 343ms
computer name     : PC10249
user name         : chris.swearingen <admin>
registered owner  : PC10249 / Golden Eagle Log Homes, Inc.
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 1 day 8 hours
program up time   : 12 seconds
processors        : 4x Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
physical memory   : 1788/3325 MB (free/total)
free disk space   : (C:) 433.79 GB
display mode      : 1280x1024, 32 bit
process id        : $15c8
allocated memory  : 13.70 MB
executable        : heidisql.exe
exec. date/time   : 2010-11-04 17:02
version           : 5.1.0.3579
compiled with     : Delphi 2010
madExcept version : 3.0k
callstack crc     : $95fcec6d, $90365474, $90365474
exception number  : 1
exception class   : Exception
exception message : Regular expression did not match the VIEW code in ParseViewStructure(): CREATE VIEW "users_view" AS select "user_list"."User_ID" AS "User_ID",concat("user_list"."User_FName",' ',"user_list"."User_LName") AS "User_Name","user_list"."User_Email" AS "User_Email" from "user_list".
main thread ($b98):
00760fe7 heidisql.exe mysql_connection 1867 +30 TMySQLConnection.ParseViewStructure
006d1b19 heidisql.exe Main             6804 +10 TMainForm.ParseSelectedTableStructure
006d14c5 heidisql.exe Main             6690 +47 TMainForm.DBtreeFocusChanged
0061cbfe heidisql.exe VirtualTrees              TBaseVirtualTree.DoFocusChange
00621012 heidisql.exe VirtualTrees              TBaseVirtualTree.HandleMouseDown
0053b1b8 heidisql.exe Controls                  TControl.DoMouseDown
00619360 heidisql.exe VirtualTrees              TBaseVirtualTree.WMLButtonDown
00625227 heidisql.exe VirtualTrees              TBaseVirtualTree.WndProc
0053eac8 heidisql.exe Controls                  TWinControl.MainWndProc
0049a524 heidisql.exe Classes                   StdWndProc
7e418a0b USER32.dll                             DispatchMessageW
0056b229 heidisql.exe Forms                     TApplication.ProcessMessage
0056b26e heidisql.exe Forms                     TApplication.HandleMessage
0056b599 heidisql.exe Forms                     TApplication.Run
007a7742 heidisql.exe heidisql           66 +15 initialization

The double quotes in your view code reveals you have enabled ANSI SQL style on your server:

CREATE VIEW "users_view" AS ...

Can you please switch to default SQL and see if that fixes the problem? Will most probably, as the regexp expects backticks where you have double quotes.

Odd. Had to create a new account as I can't login with my other account (I'll post on that in another thread?).

Anyway the view wasn't originally created with any quotes/ticks other than the aliases. I was able to verify this behavior by remoting to the server and going into MySQL Admin to drop and recreate the view. I create it without any quotes/ticks (other than single quotes for aliases) and then went to Heidi and got the same bug report details showing double quotes.

After dropping the view and creating with ticks (`) I was able to get into it via Heidi. Seems the server itself was inserting the double-quotes in when the ticks are missing.