psqlodbc - prepared statement crash

From: Xuesong Gao <xgao(at)senturus(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: psqlodbc - prepared statement crash
Date: 2019-07-26 13:56:06
Message-ID: SN6PR16MB257432B26AE20A788EECE3CDA9C00@SN6PR16MB2574.namprd16.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I am using MS ODBCTest tool for testing purpose here, and it crashed after I did following steps:

1. Full connect to DSN.

2. SQLPrepare: select city, ? as i from public.city where city = ?

3. SQLBindParameter: number 1, value type SQL_C_CHAR, parameter type SQL_CHAR, value 1;

4. SQLBindParameter: number 2, value type SQL_C_CHAR, parameter type SQL_CHAR, value Abha;

5. SQLExecute

* your ODBC driver version
Unicode x64, 9.06.05.00

* your PostgreSQL database version
PostgreSQL 10, sample database dvdrental

* any error messages you saw on the screen
messages in ODBCTest tool console:
Full Connect(Default)

Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

Successfully connected to DSN 'dvdrental'.
SQLPrepare:
In: StatementHandle = 0x00000000047221C0, StatementText = "select city, ? as i from public.city where city = ...", TextLength = 51
Return: SQL_SUCCESS=0
SQLBindParameter:
In: StatementHandle = 0x00000000047221C0, ParameterNumber = 1, InputOutputtype = SQL_PARAM_INPUT=1, ValueType = SQL_C_CHAR=1,
ParameterType = SQL_CHAR=1, ColumnSize = 0, DecimalDigits = 0, ParameterValuePtr = "1", BufferLength = 0, StrLen_or_IndPtr = SQL_NTS=-3, SQL_LEN_DATA_AT_EXEC = FALSE,
Buffer Size = 600
Return: SQL_SUCCESS=0
SQLBindParameter:
In: StatementHandle = 0x00000000047221C0, ParameterNumber = 2, InputOutputtype = SQL_PARAM_INPUT=1, ValueType = SQL_C_CHAR=1,
ParameterType = SQL_CHAR=1, ColumnSize = 0, DecimalDigits = 0, ParameterValuePtr = "Abha", BufferLength = 0, StrLen_or_IndPtr = SQL_NTS=-3, SQL_LEN_DATA_AT_EXEC = FALSE,
Buffer Size = 600
Return: SQL_SUCCESS=0

* the debug log (mylog_????.log) file (you will have to enable the mylog driver option)
attached

[X]
Song X. Gao
Solutions Architect
Email xgao(at)senturus(dot)com<mailto:xgao(at)senturus(dot)com>
Mobile 732 406 6347
senturus.com<http://www.senturus.com/>

Attachment Content-Type Size
mylog_odbct32w_7728.log application/octet-stream 2.6 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message michael.riksman 2019-07-28 07:45:10 RE: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'
Previous Message Inoue, Hiroshi 2019-07-26 11:28:52 Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'