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

Closed
opened 2026-01-22 14:26:29 +01:00 by admin · 2 comments
Owner

Originally created by @doctrinebot on GitHub (Feb 28, 2014).

Originally assigned to: @ostrolucky on GitHub.

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.

Originally created by @doctrinebot on GitHub (Feb 28, 2014). Originally assigned to: @ostrolucky on GitHub. 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.
admin added the Bug label 2026-01-22 14:26:29 +01:00
admin closed this issue 2026-01-22 14:26:29 +01:00
Author
Owner

@doctrinebot commented on GitHub (Feb 28, 2014):

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?

@doctrinebot commented on GitHub (Feb 28, 2014): 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?
Author
Owner

@ostrolucky commented on GitHub (Aug 7, 2018):

Closing due to lack of feedback

@ostrolucky commented on GitHub (Aug 7, 2018): Closing due to lack of feedback
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#3729