MySQL Bugs: #44673: Clause 'escaped by' on select into outfile

Bug #44673	Clause 'escaped by' on select into outfile
Submitted:	5 May 2009 15:52	Modified:	5 Jun 2009 18:28
Reporter:	Júlio César Gomes Fonseca	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S2 (Serious)
Version:	5.1.32-community	OS:	Windows (Vista Business)
Assigned to:		CPU Architecture:	Any

Description:
Hi...

on select clause { select * from name_table into outfile name_outfile fields terminated by ';' escaped by '"' } my results (1 line for example) are :

1;0121;XXXXXXXX;221;0131;YYYYYYYYY;INTER;2008-08-30 14:15:46;CANCELADO;NORMAL;Nenhum;2008-09-03 15:06:09;CANCELADO CLIENTE;0800218181;CNG;FIXA;8;;;;999999999999;2008-09-03 15:06:10;2008-09-04 12:00:00;N;"N;"N;"N;2;NORMAL;NORMAL;;;"N;;S;1;6355;304694

The problem is the sequence { "N } where should be only { " } as asked in the select clause

How to repeat:
select * from name_table into outfile name_outfile fields terminated by ';' escaped by '"'

Sorry, the correct select clause is :

select * fields terminated by ';' escaped by '"' from name_table into outfile name_outfile

Thank you for the report.

I can not repeat described behavior with current development sources. Additionally version 5.1.32 is a bit old. Please try with current version 5.1.34 and if problem still exists provide output of SHOW CREATE TABLE name_table

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".