Bug #64253 Workbench crashes when using alias
Submitted: 7 Feb 2012 19:47 Modified: 7 Feb 2012 20:27
Reporter: Conn Warwicker Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.37 CE OS:Windows
Assigned to: CPU Architecture:Any
Tags: alias, crash, workbench

[7 Feb 2012 19:47] Conn Warwicker 
Description:
Basically whenever I use table aliases in the SQL editor, the whole program crashes.

For example, if I do this:

SELECT * FROM users

That works fine. But if I do:

SELECT u.* FROM users u

Then the program crashes, which of course makes it very difficult to do JOINs with multiple tables when using aliases.

The query works fine when run in other places, such as phpmyadmin or directly in MySQL commandline, etc...

How to repeat:
SELECT t.* FROM yourtablename t
[7 Feb 2012 19:48] Conn Warwicker 
Forgot to post the error signature:

Problem signature:
  Problem Event Name:	APPCRASH
  Application Name:	MySQLWorkbench.exe
  Application Version:	5.2.37.8576
  Application Timestamp:	4ef3ccea
  Fault Module Name:	wbprivate.be.dll
  Fault Module Version:	0.0.0.0
  Fault Module Timestamp:	4ef3c8aa
  Exception Code:	c0000005
  Exception Offset:	0000106b
  OS Version:	6.1.7601.2.1.0.768.3
  Locale ID:	2057
  Additional Information 1:	0a9e
  Additional Information 2:	0a9e372d3b4ad19135b953a78882e789
  Additional Information 3:	0a9e
  Additional Information 4:	0a9e372d3b4ad19135b953a78882e789
[7 Feb 2012 20:27] Valeriy Kravchuk 
Looks like a duplicate of bug #64250.