MySQL Bugs: #72468: Unknown column 'p1' in 'field list'

Bug #72468	Unknown column 'p1' in 'field list'
Submitted:	28 Apr 2014 3:30	Modified:	19 Apr 2016 7:36
Reporter:	Mike Peters	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	6.8.3	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
I tried using this connector in Visual Studio 2012 SSIS. I am using an ADO.NET SqlClient Data Provider source and ADO.NET MySQL Data Provider destination, and I get this error when it tries to insert data into MySQL:

An exception has occurred during data insertion, the message returned from the provider is: Unknown column 'p1' in 'field list'

How to repeat:
Use Connector/NET 6.8.3 in a SSIS package to insert data into a MySQL database. Source is a SQL database, but not sure if that matters or not.

Hello  Mike Peters,

Thank you for the bug report.
Please try with latest version of MySQL Connector/NET 6.9.6 and make sure use sql_mode as 'ANSI' in connection or globally.

Thanks,
Chiranjeevi.

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

I had the same result (unknown column ...) with ADO.NET Connector 6.9.8 and with set 'ANSI'. Where the hell does this p1 come from?
rgds.
Volker

Hello Volker Trimkowski,

Thank you for your feedback.
I could not repeat the issue at our end using with Connector/NET 6.9.8, Visual Studio 2013 and SQL Server 2014. 
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.

Hi guys,

The issue still can be reproduced uisng SSIS and latest version of MySQL (mysql-connector-net-8.0.13): for ADO NET. The ANSI mode for the MySQL connection has beend set. Simply create a SSIS package copying data from SQL server to MySQL table using ADO NET Destination for MySQL. 
MySQL version is 10.1.37-MariaDB-0+deb9u1 Debian 9.6
Working with Visuao Studio 2013, and IntegrationServices 12.0

An exception has occurred during data insertion, the message returned from the provider is: Unknown column 'p1' in 'field list'

When I have disabled setting ANSI for the connection to MySQL, ther an error is different and pointing to SyntaxIssue. But it allow to see SQL command send to MySQL and it not seems to be correct I think: 
INSERT INTO test_IG_SSIS ("rec_id") VALUES (p1).

wuld apprecuate you feedback other then "can not repro/Can't repeat" - as this one seems to be well known issue for users.

thank you.

This is also affecting me. 

Visual Studio Professional 2017
MySQL Connector Net 8.0.18
MySQL Server 5.7.18-log
Microsoft SQL Server 2014 (SP3-GDR)

Before executing the data flow to MySQL from SQL Server, I run:
SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ANSI_QUOTES';

Hi,I'm have same problem "[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: Unknown column 'p1' in 'field list'
"
Please advice.

Visual Studio Professional 2017
MySQL Connector Net 8.0.20
MySQL Server 8.0.20
Microsoft SQL Server 2016