"Implementation limit exceeded" after upgrading from 3.0.2.0 to 3.1.0.0 -----------------------------------------------------------------------
Key: DNET-513 URL: http://tracker.firebirdsql.org/browse/DNET-513 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 3.1.0.0 Environment: Windows 7 64bit Reporter: NoPyGod Assignee: Jiri Cincura Attachments: Databases.zip, Setting.cs With version 3.0.2.0, the following LINQ query var isMaster = configDb.Settings.Where(x => x.Key == @"\ALPHA\ENVIRONMENT\MASTER").Single().Value == "1"; Was translated into SELECT FIRST (2) "B"."CONFIGKEY" AS "CONFIGKEY", "B"."CONFIGVALUE" AS "CONFIGVALUE" FROM "CONFIGURATION" AS "B" WHERE _UTF8'\ALPHA\ENVIRONMENT\MASTER' = "B"."CONFIGKEY" This works fine. Have been using the ADO.NET provider for months without any trouble But today I tried to upgrade to version 3.1.0.0 of the provider, and now that same linq query is being translated into the SQL below SELECT FIRST (2) "B"."CONFIGKEY" AS "CONFIGKEY", "B"."CONFIGVALUE" AS "CONFIGVALUE" FROM "CONFIGURATION" AS "B" WHERE CAST(_UTF8'\ALPHA\ENVIRONMENT\MASTER' AS VARCHAR(32765)) = "B"."CONFIGKEY" Notice it now CASTs to VARCHAR(32765) This unfortunately is giving an error: Dynamic SQL Error SQL error code = -204 Data type unknown Implementation limit exceeded COLUMN DSQL internal I tried executing the same sql query outside of .NET, from IBExpert, and it also gives the same error there. I have tried so many different things in IBExpert to get this to work but to no avail. I discovered that if I export the table structure and create a new database and import the structure into a new table, I can run the query without problems. I thought this might mean there was a problem with the database so I did the usual gfix, backup restore but that hasn't helped. I've attached a zip containing two databases, one which works and the one which doesn't. Please try running this query to see the error I'm referring to -- SELECT * FROM CONFIGURATION WHERE CONFIGKEY = CAST(_UTF8'TEST' AS VARCHAR(32765)) I don't know if this is a problem with the ADO.NET provider or with the Firebird engine itself, but since 3.0.2.0 worked and 3.1.0.0 doesn't I thought I'd report it here. -- 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 ------------------------------------------------------------------------------ Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider