Menu
▾
▴
[Firebird-net-provider] [FB-Tracker] Created: (DNET-974) Parameter prefix being swapped between ":" and "@" carrying over to other concurrently generated queries.
|
From: Benjamyn W. (JIRA) <tr...@fi...> - 2020-10-08 00:21:36
|
Parameter prefix being swapped between ":" and "@" carrying over to other concurrently generated queries.
---------------------------------------------------------------------------------------------------------
Key: DNET-974
URL: http://tracker.firebirdsql.org/browse/DNET-974
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.5.0.0
Environment: Windows Core 3.1/5.0/Framework 4.8
Reporter: Benjamyn Williams
Assignee: Jiri Cincura
Priority: Critical
Error is described in this "Resolved" issue http://tracker.firebirdsql.org/browse/DNET-945
Critical as this is affecting medical information.
This is an error with concurrent query generation due to the changing of sqlGenerationHelper.ParameterNameMarker in the singleton DbUpdateSqlGenerator within methods AppendUpdateOperation and AppendDeleteOperation when queries are being constructed concurrently.
This has caused mismatches between parameters and the query text where the query would be referring to "@p0" while the parameters object has ":p0".
This needs to be solved so that changing the ParameterNameMarker for named parameters will not affect other concurrent query generation.
Confirmed this by redirecting those particular parts (extracting the internal methods that EF uses) to a new version of sqlGenerationHelper (As it required no dependencies) with ":" instead of using the current one.
The test project on the previous issue was able to replicate this.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
