Skip to content


DDC-3001: Date and string values in insert statement are between double quotes (" ") #3768

doctrinebot opened this Issue · 1 comment

2 participants


Jira issue originally created by user puspadhar:

While flushing the entity manager, the sql queries generated for INSERT puts the date and string values inside double quotes and the following error is displayed:
SQLSTATE [21S01, 213]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column name or number of supplied values does not match table definition.
When I copy the statement and replace the double quotes to single quotes, the query is run.


Comment created by @ocramius:

[~puspadhar] can you provide the SQL query that is being attempted, your fixed version as well as the call to DBAL (or ORM) that is causing this problem?

@beberlei beberlei was assigned by doctrinebot
@doctrinebot doctrinebot added the Bug label
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.