Steffen Goeldner wrote:
>
> Attached are some results for the Oracle ODBC Driver 08.01.0704,
> generated with MS ODBC Test 03.00.2301 (Odbcte32.exe).
>
> The last result is wrong: tst.c2 should not appear in the result set.
> I created a TAR at Oracle MetaLink. They accepted it as a bug:
>
> BUG# 2008554 SQLFOREIGNKEY() BRINGS BACK WRONG RESULTS
>
> They'll fix that in the next release (8.1.7.5).
Oracle ODBC 8.1.7.5 is available and the bug is fixed.
Steffen
Oracle ODBC Driver 08.01.0705
-----------------------------
SQLForeignKeys:
In: StatementHandle = 0x008A1860,
PkCatalogName = SQL_NULL_HANDLE, NameLength1 = 0
PkSchemaName = "TST" , NameLength2 = 3
PkTableName = "P1" , NameLength3 = 2
FkCatalogName = SQL_NULL_HANDLE, NameLength4 = 0
FkSchemaName = "TST" , NameLength5 = 3
FkTableName = "C1" , NameLength6 = 2
Return: SQL_SUCCESS=0
Get Data All:
"PKTABLE_CAT", "PKTABLE_SCHEM", "PKTABLE_NAME", "PKCOLUMN_NAME", "FKTABLE_CAT",
"FKTABLE_SCHEM", "FKTABLE_NAME", "FKCOLUMN_NAME", "KEY_SEQ", "UPDATE_RULE",
"DELETE_RULE", "FK_NAME", "PK_NAME", "DEFERRABILITY"
<Null>, "TST", "P1", "K1", <Null>, "TST", "C1", "K1", 1, <Null>, 3, "FK_C1", "PK_P1",
<Null>
<Null>, "TST", "P1", "K2", <Null>, "TST", "C1", "K2", 2, <Null>, 3, "FK_C1", "PK_P1",
<Null>
2 rows fetched from 14 columns.
