| Bug #55695 | into outfile fails in workbench, works in client | ||
|---|---|---|---|
| Submitted: | 2 Aug 2010 17:18 | Modified: | 2 Aug 2010 17:23 |
| Reporter: | john burns | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 5.2.25 ( 6303) | OS: | MacOS |
| Assigned to: | CPU Architecture: | Any | |
[2 Aug 2010 17:23]
Johannes Taxacher
This is a duplicate of bug# 52648
[2 Aug 2010 18:22]
Johannes Taxacher
sorry for the typo in previous comment, this is actually a duplicate of Bug #49694
Description: SELECT * from sssz order by `count` desc INTO outfile '/tmp/pqw' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' ; Fails -- incorrect LIMIT keyword inserted by workbench ? How to repeat: Any query with the above structure Suggested fix: remove LIMIT function with outfile, it's probably intended for the UI, not for the outfile anyway.