Issue Details (XML | Word | Printable)

Key: DNET-850
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Jiri Cincura
Reporter: Georgi Panayotov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
.NET Data provider

Incorrect SQL generated when 2 or more columns should be returned on update

Created: 09/Sep/18 08:40 PM   Updated: 10/Sep/18 12:12 PM
Component/s: Entity Framework Core
Affects Version/s: 6.3.0.0
Fix Version/s: 6.4.0.0


 Description  « Hide
When I have 2 or more columns that are calculated and they should be returned on update then wrong SQL is generated. I found this on https://github.com/ralmsdeveloper/EntityFrameworkCore.FirebirdSQL , but as I see the code this should appear here too.
The generated code is like:
...
RETURNING COLUMN1 INTO :COLUMN1, COLUMN2 INTO :COLUMN2
...

but it should be:
RETURNING COLUMN1, COLUMN2 INTO :COLUMN1, :COLUMN2

I've created a fork to try to fix the issue - the commit is:
https://github.com/gpanayotov/FirebirdSql.Data.FirebirdClient/commit/17e3255d32a9ca573b7e21d8fb6314a4d98b510c

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.