Bug #64061 | SELECT with a varchar remains in fetching... state forever, no results returned | ||
---|---|---|---|
Submitted: | 18 Jan 2012 16:45 | Modified: | 26 Jan 2012 4:34 |
Reporter: | David Frankenbach | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
Version: | 5.2.37 CE | OS: | Windows (Win XP) |
Assigned to: | CPU Architecture: | Any | |
Tags: | SELECT, varchar |
[18 Jan 2012 16:45]
David Frankenbach
[18 Jan 2012 18:41]
David Frankenbach
The query works in this release http://downloads.mysql.com/archives/MySQLGUITools/mysql-workbench-oss-5.2.21-rc-win32.msi
[25 Jan 2012 20:48]
Rafael Antonio Bedoy Torres
Hello David, Thanks for your Report, may you please provide more information about your system? Please On Workbench click on Help-> System info and paste the info you got as a comment. Thank you in advance!
[25 Jan 2012 21:30]
David Frankenbach
Rafael - I had to drop back to an older release of the workbench so that I could get the data analysis done. Here's the system info from a release where the queries do work correctly. MySQL Workbench OSS for Windows version 5.2.21 Cairo Version: 1.8.8 Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering. OpenGL Driver Version: 2.1.2 OS: Microsoft Windows XP Professional Service Pack 3 (build 2600) CPU: 2x Intel(R) Core(TM)2 CPU 6400 @ 2.13GHz, 3.0 GiB RAM Video adapter info: Adapter type: NVIDIA GeForce 7900 GS Chip Type: GeForce 7900 GS BIOS String: Version 5.71.22.29.09 Video Memory: 262144 KB
[26 Jan 2012 4:34]
Alfredo Kojima
Duplicate of bug #63867
[26 Jan 2012 4:37]
Alfredo Kojima
If you are willing, please try the following workaround and report back. When selecting from a table that gives the error, add a dummy function to the select list, like: select i_id, natt, ncust, nlive, nstaf, nsubj, dormant, word, concat('', '') from phrases where i_id = 41436966