Bug #75241 Export limit set as in select query results limit row
Submitted: 17 Dec 2014 6:48 Modified: 24 May 2018 15:29
Reporter: Yudha HT Email Updates:
Status: QA review Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.2.4 OS:Microsoft Windows (Windows 8 SL)
Assigned to: CPU Architecture:Any
Tags: export, limit row

[17 Dec 2014 6:48] Yudha HT
Description:
When I set "select query results limit row" in edit > preferences > sql execution to 50, result grid show only 50. But when export to csv the result 50 row only extracted.

But when I set limit on query, all data extracted properly.

How to repeat:
- Set "select query results limit row" in edit > preferences > sql execution to 50.
- Export the data.
- Add limit to the query.
- Export the data.
[17 Dec 2014 6:59] Yudha HT
setting

Attachment: setting.PNG (image/png, text), 23.93 KiB.

[17 Dec 2014 6:59] Yudha HT
query-no-limit sql

Attachment: query-no-limit.PNG (image/png, text), 31.82 KiB.

[17 Dec 2014 6:59] Yudha HT
query-no-limit csv

Attachment: query-no-limit.csv (application/vnd.ms-excel, text), 395 bytes.

[17 Dec 2014 7:00] Yudha HT
query-with-limit sql

Attachment: query-with-limit.PNG (image/png, text), 30.39 KiB.

[17 Dec 2014 7:00] Yudha HT
query-with-limit csv

Attachment: query-with-limit.csv (application/vnd.ms-excel, text), 554 bytes.

[17 Dec 2014 8:18] Umesh Shastry
Hello Yudha HT,

Thank you for the report.
Observed that SQL Editor's preferences set for limiting "Limit Rows" are overridden/ignored by LIMIT <N> of the query.

So this is more or less the same behavior of global vs local i.e if Editor's "Limit Rows" is set to 50, and you execute a query with LIMIT 70, then "Limit Rows" setting is ignored and query LIMIT is used.

I didn't find any info confirming this here http://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-export.html

Thanks,
Umesh