Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong parameters usage when using restriction on catalogr/schema on non-table schema tables [DNET489] #475

Closed
firebird-automations opened this issue Mar 25, 2013 · 1 comment

Comments

@firebird-automations
Copy link

Submitted by: @cincuranet

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

Commits: dbdce38

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: vNext [ 10491 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants