[unixODBC-dev] SQLStatistics with null schema name and SQL_ATTR_METADATA_ID statement attribute set to SQL_TRUE

G, Hemanth Kumar Hemanth.G at Teradata.com
Fri Jun 19 13:53:11 BST 2009


Nick,

         One more error of the same kind..

SQLStatistics with schema name as null pointer and with
SQL_ATTR_METADATA_ID statement attribute set to SQL_TRUE, should return
HY009 (Invalid use of null pointer).
But returns SQL_SUCCESS instead.

>From spec: 
-------------------------------
HY009 ( Invalid use of null pointer )
(DM) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE,
and the SchemaName argument was a null pointer.
--------------------------------

SQLINTEGER attr = SQL_TRUE;
SQLSetStmtAttr(hstmt, SQL_ATTR_METADATA_ID, (SQLPOINTER)attr,
SQL_IS_INTEGER);

SQLStatistics(hstmt, NULL, 0, NULL, 0, (SQLCHAR *)"tmp", SQL_NTS, 0, 0);
Expected : HY009 (Invalid use of null poiner)
Received : SQL_SUCCESS

Please verify this once.
And have a nice weekend..

Thanks & Regards,
Hemanth.

> _____________________________________________ 
> From: 	G, Hemanth Kumar  
> Sent:	Friday, June 19, 2009 4:39 PM
> To:	'Development issues and topics for unixODBC'
> Subject:	SQLPrimaryKeys with TableName as null pointer
> 
> Nick,
> 
>         Similar is the case with SQLPrimaryKeys.
> SQLPrimaryKeys with TableName as null pointer should return HY009
> (Invalid use of null pointer). But returns SQL_SUCCESS.
> 
> SQLPrimaryKeys(hstmt, NULL, 0, NULL, 0, NULL, 0);
> Expected : HY009 (Invalid use of null pointer)
> Received : SQL_SUCCESS
> 
> Can you check this one too.
> 
> Thanks
> Hemanth.
> 
> _____________________________________________ 
> From: 	G, Hemanth Kumar  
> Sent:	Friday, June 19, 2009 4:31 PM
> To:	'Development issues and topics for unixODBC'
> Subject:	SQLColumnPrivileges with TableName as NULL pointer
> 
> Nick,
> 
>         SQLColumnPrivileges with TableName as NULL should return HY009
> (Invalid use of null pointer). Instead returns SQL_SUCCESS.
> 
> SQLColumnPrivileges(hstmt, NULL, 0, NULL, 0, NULL, 0, NULL, 0);
> Expected : HY009 (Invalid use of null pointer)
> Received : SQL_SUCCESS.
> 
> Please verify this one.
> 
> Thanks
> Hemanth.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-dev/attachments/20090619/c1a88dad/attachment.html>


More information about the unixODBC-dev mailing list