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
• Status: QA review
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.2.4
• OS: Windows (Windows 8 SL)
• 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] MySQL Verification Team

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