MySQL Bugs: #57072: Exporting a result set to csv

Bug #57072	Exporting a result set to csv
Submitted:	28 Sep 2010 15:52	Modified:	28 Oct 2010 23:11
Reporter:	Matthew Vagnoni	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.28CE	OS:	Windows (Revision 6722)
Assigned to:		CPU Architecture:	Any
Tags:	export, query, toggle limitation of records number

Description:
I did a query like: 
Select something FROM table WHERE col1 = 'blah' and col2 not in (select col2 from table where col1 = 'bar')

The first 1,000 records return fine.  But when I tried to "toggle limitation of records number" button so I can export ALL the records to CSV...i got the error

How to repeat:
See description.  

Suggested fix:
Maybe make it so that it automatically doesn't have the limit of 1,000 records?

How many rows you had in the results (check with select count(*) ... if you are not sure)? What exact error you had got?

Please, send also the results of Help > System Info menu item.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

It was 500,000 to 1,000,000 results expected.  

***
Help->System Info
***

Exception in thread Thread-1:

Traceback (most recent call last):

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 525, in __bootstrap_inner

    self.run()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 477, in run

    self.__target(*self.__args, **self.__kwargs)

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 443, in read_from_script

    if line[0] == 'C':

IndexError: string index out of range

Exception in thread Thread-3:

Traceback (most recent call last):

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 525, in __bootstrap_inner

    self.run()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\python\threading.py", line 477, in run

    self.__target(*self.__args, **self.__kwargs)

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 565, in poll_sources

    cmd.poll()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wba_monitor_be.py", line 405, in poll

    self.ch.stdin.write("cpu\r\n")

IOError: [Errno 22] Invalid argument

MySQL Workbench CE for Windows version 5.2.28

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is not available on this system, so GDI is used for rendering.

OS: Microsoft Windows Server 2003 R2, Standard x64 Edition Service Pack 2 (build 3790)

CPU: 8x Intel(R) Xeon(R) CPU           X5355  @ 2.66GHz, 32.0 GiB RAM

Video adapter info:

Adapter type: ATI ES1000        

Chip Type: ATI ES1000 (0x515E)

BIOS String: BK-ATI VER008.005.028.000

Video Memory: 16384 KB

Current user language: English (United States)

This is a duplicate of bug #55889