"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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
