Bug #4013 MySQL CC insert select 1000 rows limit
Submitted: 4 Jun 2004 16:42 Modified: 4 Jun 2004 17:41
Reporter: Alex Fihman Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQLCC Severity:S2 (Serious)
Version:0.9.4-beta OS:Windows (Windows 2000)
Assigned to: Dean Ellis CPU Architecture:Any

[4 Jun 2004 16:42] Alex Fihman 
Description:
It is not possible to use MySQL control center to copy 
data from one table into another using INSERT INTO .. SELECT FROM .. syntax.
Only 1000 rows are copied.

How to repeat:
in MySQL CC:
1. create tables with same fields.
2. insert 2000 rows in one table.
3. run query:

   insert into a
   select *
   from b

only 1000 rows are copied. 
    

Suggested fix:
remove this limitation
[4 Jun 2004 17:41] Dean Ellis 
This should be caused by your SELECT limit in the MySQL Options for your connection/server properties, assuming you are not using a current MySQL 4.1 binary (which has different behavior).
[7 Jun 2004 10:55] Alex Fihman 
my.ini configuration file

Attachment: my.ini (application/octet-stream, text), 530 bytes.
[7 Jun 2004 10:56] Alex Fihman 
This limitation seems to be hard-coded in the exe itself.
When I connect through ODBC I don't have this problem.
my.ini file is attached
[7 Jun 2004 10:57] Alex Fihman 
Server version is 4.0.15-nt
[7 Jun 2004 15:01] Alex Fihman 
Yes it is hardcoded (CMySQL.cpp). I suggest put this limit into editable 
options. Meanwhile I found a workaround - run following statement:

SET SQL_SELECT_LIMIT=(new limit)
[7 Jun 2004 17:04] Dean Ellis 
The setting is an editable option, as noted previously.
[8 Jun 2004 8:15] Alex Fihman 
Not through a GUI though...
[8 Jun 2004 8:20] Alex Fihman 
Suggestion: add a GUI page with Default Parameters for New Connection.
This would simplify work with CC.
[8 Jun 2004 8:26] Alex Fihman 
Ooopppsss found this Gui. Not in a place where I expected though.