Bug #50952 Error: too many SQL Variables
Submitted: 5 Feb 2010 18:32 Modified: 28 May 2010 10:19
Reporter: Billy Earney Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.15 OS:Windows
Assigned to: Sergei Tkachenko CPU Architecture:Any

[5 Feb 2010 18:32] Billy Earney 
Description:
when a do a select * from a table with about 1000 fields, I get a error stating that I have too many SQL Variables.

This did not occur in Query Browser.

How to repeat:
Open Workbench, and select SQL development.

type a select * query from a table with several hundred (1000) fields 
(ie, select * from large_table)
[7 Feb 2010 1:41] MySQL Verification Team 
Error message

Attachment: error.png (image/png, text), 42.24 KiB.
[7 Feb 2010 1:43] MySQL Verification Team 
Client to create table with 1000 columns

Attachment: tb.txt (text/plain), 1.14 KiB.
[7 Feb 2010 1:44] MySQL Verification Team 
Thank you for the bug report.
[26 May 2010 17:18] Johannes Taxacher 
fix confirmed in repository
[28 May 2010 10:19] Tony Bedford 
An entry has been added to the 5.2.22 changelog:

In the SQL Editor, carrying out a SELECT on a table containing more than 1000 columns resulted in the error 'Too many SQL variables'.