Wrong parameters usage when using restriction on catalogr/schema on non-table
schema tables
-------------------------------------------------------------------------------------------
Key: DNET-489
URL: http://tracker.firebirdsql.org/browse/DNET-489
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 3.0.2.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Calling ".GetSchema("Procedures", new[] { null, "dbo", "test" });" results into:
SELECT
null AS PROCEDURE_CATALOG,
null AS PROCEDURE_SCHEMA,
rdb$procedure_name AS PROCEDURE_NAME,
rdb$procedure_inputs AS INPUTS,
rdb$procedure_outputs AS OUTPUTS,
rdb$system_flag AS IS_SYSTEM_PROCEDURE,
rdb$procedure_source AS SOURCE,
rdb$description AS DESCRIPTION
FROM rdb$procedures WHERE rdb$procedure_name =
@p0 ORDER BY rdb$procedure_name
FirebirdSql.Data.FirebirdClient Information: 0 : Parameters:
FirebirdSql.Data.FirebirdClient Information: 0 : Name:@p0 Type:VarChar
Used Value:dbo
FirebirdSql.Data.FirebirdClient Information: 0 : Name:@p1 Type:VarChar
Used Value:test
So the wrong parameter is used and another parameter is generated even if nod
needed nor used.
It should be i.e.:
SELECT
null AS PROCEDURE_CATALOG,
'Firebird' AS PROCEDURE_SCHEMA,
rdb$procedure_name AS PROCEDURE_NAME,
rdb$procedure_inputs AS INPUTS,
rdb$procedure_outputs AS OUTPUTS,
rdb$system_flag AS IS_SYSTEM_PROCEDURE,
rdb$procedure_source AS SOURCE,
rdb$description AS DESCRIPTION
FROM rdb$procedures WHERE rdb$procedure_name =
@p0 ORDER BY rdb$procedure_name
Parameters:
Name:@p0 Type:VarChar Used Value:test
--
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
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
