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

SQLForeignKey inconsistent schema use: FKTABLE_SCHEM should return NULL not SYSDBA [ODBC39] #39

Closed
firebird-automations opened this issue May 8, 2008 · 3 comments

Comments

@firebird-automations
Copy link

Submitted by: faridz (faridz)

My application gets dependency of Firebird database tables info by executing SQLForeignKeys to build dependency graph. SQLForeignKeys returns schema info for imported foreign key table as 'SYSDBA'. It should returns schema for referenced foreign key table as NULL since SQLTables returns schema as NULL for the same table.

    rc = ::SQLForeignKeys\( pSQL\-\>Gethstmt\(\),
        NULL, 0,
        NULL, 0,
        NULL, 0,
\( SQLCHAR \* \)   \( dbo\.sCat\.IsEmpty\(\)   ? NULL : \(LPCTSTR\) dbo\.sCat \),
\( SQLSMALLINT \) cbTableCat,
\( SQLCHAR \* \)   \( dbo\.sSchem\.IsEmpty\(\) ? NULL : \(LPCTSTR\) dbo\.sSchem \),
\( SQLSMALLINT \) cbTableSchem,
\( SQLCHAR \* \)   \(LPCTSTR\) dbo\.sName,
\( SQLSMALLINT \) cbTableName \);

resultset excerpt :
...
PKTABLE_CAT -> NULL
PKTABLE_SCHEM -> NULL
FKTABLE_CAT -> NULL
FKTABLE_SCHEM -> SYSDBA ** should return NULL **

Commits: d725eb8 933b020

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

assignee: Vladimir Tsvigun [ praktik ] => Alexander Potapchenko [ lightfore ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

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

resolution: Fixed [ 1 ]

Fix Version: 2.0 Beta [ 10043 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]

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