[IMPALA-11486] Syntax error on parameterized Query

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.9.0
• Component/s: Clients
• Environment: windows10 odbc driver 2.6.16
• Epic Color: ghx-label-8
• Assignee: Unassigned
• Reporter: CWYU
• Created: 09/Aug/22 04:00
• Updated: 09/Aug/22 06:37

Description

I have an issue the same as IMPALA-9750 Syntax error on parameterized Query - ASF JIRA (apache.org) tarmstrong 

ERROR [42000] [Cloudera][ImpalaODBC] (360) Syntax error occurred during query execution: [HY000] : AnalysisException: Syntax error in line 1:

...lt.fdc_lot_run where eqid=? and year=2021 and month=10...
                            ^
Encountered: Unexpected character
Expected: CASE, CAST, DEFAULT, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, REPLACE, TRUNCATE, TRUE, IDENTIFIER

CAUSED BY: Exception: Syntax error

 

dev environment

• windows 10
• .net framework C# 4.8
• impala odbc driver 2.6.16

 

test code

   var command = (System.Data.Odbc.OdbcCommand)conn.CreateCommand();
                command.CommandText = "select * from default.fdc_lot_run where eqid=? and year=2021 and month=10 and day=15";
                command.Parameters.Add("eqid", System.Data.Odbc.OdbcType.VarChar).Value = "CACMPW01";

                var rs = command.ExecuteReader(); // here exception...
                var x = rs.Read();
                rs.Close();

 

 failed in parameterized query.