Cast of string values to VARCHAR(8191) results in "Implementation limit
exceeded"
----------------------------------------------------------------------------------
Key: DNET-980
URL: http://tracker.firebirdsql.org/browse/DNET-980
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Affects Versions: 7.5.0.0
Reporter: Andrey Belov
Assignee: Jiri Cincura
Generated database query:
SELECT "d"."DOCUMENTDATAID", "d"."ADD_DATE", "d"."AGENCY_CODE",
"d"."DOCTYPEID", "d"."END_DATE", "d"."ISACTIVE", "d"."ISMAIN", "d"."ISSUED_BY",
"d"."ISSUED_DATE", "d"."MILITARY_RANK_ID", "d"."NUMBER", "d"."PATIENTID",
"d"."SERIES", "d"."USERID"
FROM "DOCUMENTDATA" AS "d"
WHERE ("d"."SERIES" = CAST(@__obj_Series_0 AS VARCHAR(8191))) AND ("d"."NUMBER"
= CAST(@__obj_Number_1 AS VARCHAR(8191)))
Full log:
queryContext => new QueryingEnumerable<DocumentData>(
(RelationalQueryContext)queryContext,
RelationalCommandCache,
null,
null,
Func<QueryContext, DbDataReader, ResultContext, int[], ResultCoordinator,
DocumentData>,
FbDataBase.Contexts.FbContext,
DiagnosticsLogger<Query>)
Creating DbCommand for 'ExecuteReader'.
Created DbCommand for 'ExecuteReader' (1ms).
Opening connection to database 'udc' on server 'localhost'.
Opened connection to database 'udc' on server 'localhost'.
Executing DbCommand [Parameters=[@__obj_Series_0='?' (Size = 4),
@__obj_Number_1='?' (Size = 6)], CommandType='Text', CommandTimeout='30']
SELECT "d"."DOCUMENTDATAID", "d"."ADD_DATE", "d"."AGENCY_CODE",
"d"."DOCTYPEID", "d"."END_DATE", "d"."ISACTIVE", "d"."ISMAIN", "d"."ISSUED_BY",
"d"."ISSUED_DATE", "d"."MILITARY_RANK_ID", "d"."NUMBER", "d"."PATIENTID",
"d"."SERIES", "d"."USERID"
FROM "DOCUMENTDATA" AS "d"
WHERE ("d"."SERIES" = CAST(@__obj_Series_0 AS VARCHAR(8191))) AND ("d"."NUMBER"
= CAST(@__obj_Number_1 AS VARCHAR(8191)))
Failed executing DbCommand (29ms) [Parameters=[@__obj_Series_0='?' (Size = 4),
@__obj_Number_1='?' (Size = 6)], CommandType='Text', CommandTimeout='30']
SELECT "d"."DOCUMENTDATAID", "d"."ADD_DATE", "d"."AGENCY_CODE",
"d"."DOCTYPEID", "d"."END_DATE", "d"."ISACTIVE", "d"."ISMAIN", "d"."ISSUED_BY",
"d"."ISSUED_DATE", "d"."MILITARY_RANK_ID", "d"."NUMBER", "d"."PATIENTID",
"d"."SERIES", "d"."USERID"
FROM "DOCUMENTDATA" AS "d"
WHERE ("d"."SERIES" = CAST(@__obj_Series_0 AS VARCHAR(8191))) AND ("d"."NUMBER"
= CAST(@__obj_Number_1 AS VARCHAR(8191)))
Closing connection to database 'udc' on server 'localhost'.
Closed connection to database 'udc' on server 'localhost'.
An exception occurred while iterating over the results of a query for context
type 'FbDataBase.Contexts.FbContext'.
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
---> Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
behavior)
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at
Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject
parameterObject)
at
Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext
_, Boolean result)
at
Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState
state, Func`3 operation, Func`3 verifySucceeded)
at
Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
'FbContext' disposed.
--
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
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
