[KYLIN-2558] ODBC: SQLPrepare(SQLPrepareW) should prepare query metadata

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v1.6.0
• Fix Version/s: v2.1.0
• Component/s: Driver - ODBC
• Assignee: Yifan Zhang
• Reporter: Yifan Zhang
• Created: 21/Apr/17 02:12
• Updated: 22/Aug/17 03:15
• Resolved: 22/Aug/17 03:14

Description

When use SSRS BI to save query to dataset, error will be thrown out.

Root cause, SQLPrepareW does not prepare column info and SQLNumResultCols will fail.

driver_debug.log

[DEBUG]SQLPrepareW called on: 191574520
[INFO ]SQLFreeStmt called, 191574520 with option 0
[DEBUG]SQLFreeStmt called for Result
[DEBUG]The query being prepared is :
[DEBUG]SELECT   COUNT(*) AS AA

FROM      kylin_sales
[DEBUG]SQLNumResultCols called
[DEBUG]_SQLPutDiagRow called, handle type is 3
[DEBUG]DiagMsg: [Kylin][ODBC 1.0(w) Driver]no resultset or IRD