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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider