search

jonwagner / Insight.Database

Fast, lightweight .NET micro-ORM
Other
861 stars 145 forks source link

BulkCopy is not working with MySqlConnector #492

Closed elandev closed 7 months ago

elandev commented 1 year ago

Describe the bug

MySqlBulkdLoaderis working, but when I attempt to use the method connection.BulkCopy with a list, I get the following exception:

MySqlConnector.MySqlException: 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0 * FROM TestInsight; SET sql_select_limit=default' at line 1'

Steps to reproduce

  1. Load the attached project with Visual Studio 2022.
  2. Set up MariaDB as the database (10.11.2-MariaDB).
  3. Edit the server, database name and credentials for the connection string.
  4. Restore Nuget packages and build the solution.
  5. Run the project.

The method BulkLoadDataMySql, which uses MySqlBulkLoaderworks.

The method BulkLoadDataInsightdoes not work and you will see the exception.

Expected behavior

Expected the bulk copy to insert all items in the list.

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

elandev commented 1 year ago

This issue still exists. Is there an update on this?

stale[bot] commented 8 months ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

jonwagner commented 7 months ago

Unfortunately, we can't accept project zip files as reproduction cases. Please paste sufficient code to reproduce here, or submit a PR with a failing test case.