New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
"Implementation limit exceeded" [DNET518] #500
Comments
Commented by: @cincuranet The Single is translated correctly. You probably meant to use First instead of Single. Provide a test case or TABACCOUNT table structure. |
Commented by: Rand Random (rand.random) Yeah mixed up Single and First sry about this. Tried to reproduce the bug with only tabaccount but it didnt occure, than I did it again with a small sample database with 6 tables, constraints, generators, triggers, domain and this failed again. |
Commented by: Rand Random (rand.random) Sample Solution with Database |
Modified by: Rand Random (rand.random)Attachment: FIREBIRDIMPLEMENTATIONBUG.FDB [ 12367 ] Attachment: FirebirdImplementationBug.zip [ 12368 ] |
Modified by: Rand Random (rand.random)Version: 3.1.1.0 [ 10570 ] Component: http://ADO.NET Provider [ 10041 ] |
Modified by: @cincuranetstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: vNext [ 10571 ] |
Commented by: Rand Random (rand.random) May I ask what the problem was, and when you expect for a release to happen? |
Commented by: @cincuranet You can check the sources to see changes made. |
Modified by: @cincuranet |
Modified by: @cincuranet |
Modified by: @cincuranet |
Modified by: @cincuranet |
Commented by: Rand Random (rand.random) Its been a while and I was wondering how the release is progressing and if there is already and estimated time, |
Commented by: Rand Random (rand.random) 1 day to impatient, thanks for the release. :) |
Submitted by: Rand Random (rand.random)
Is duplicated by DNET520
Is related to DNET513
Attachments:
FIREBIRDIMPLEMENTATIONBUG.FDB
FirebirdImplementationBug.zip
I am still facing the issue when I want to update my EDMX Model, as described here
DNET513
DNET514
Just to make sure I am using the version 3.1.1.0 I did the following in my code:
using (var conx = new EntityModel())
{
var bla = conx.TabAccounts.Where(x => x.AccNr == "1001").Single();
Which sucessfully run, and outputed to this sql query:
SELECT FIRST (2)
"B"."IDACCOUNT" AS "IDACCOUNT",
"B"."IDCOMPANY" AS "IDCOMPANY",
"B"."IDPARENT" AS "IDPARENT",
"B"."ACCNR" AS "ACCNR",
"B"."ACCNRSUB" AS "ACCNRSUB",
"B"."FLAGISSPLIT" AS "FLAGISSPLIT",
"B"."FLAGISSYSTEMACCOUNT" AS "FLAGISSYSTEMACCOUNT",
"B"."TEXTACCOUNTGL" AS "TEXTACCOUNTGL"
FROM "TABACCOUNT" AS "B"
WHERE CAST(_UTF8'1001' AS VARCHAR(8191)) = "B"."ACCNR"
As you notice the VARCHAR(8191) is fixed, but on Update Model from Database it fails.
Also I would like to mention that the .Single method here gets parsed to "SELECT FIRST (2) ...." shouldnt it be "SELECT FIRST (1)..." ?
Hope you can help me out.
Commits: afcaaf0
The text was updated successfully, but these errors were encountered: