MySQL Bugs: #59809: Conditional Update from Oracle on MYSQL table fails returns ORA-02070 error

Bug #59809	Conditional Update from Oracle on MYSQL table fails returns ORA-02070 error
Submitted:	28 Jan 2011 22:42	Modified:	29 May 2013 8:03
Reporter:	Charu Trikannad	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.01.08.00	OS:	Windows (2008)
Assigned to:	Bogdan Degtyariov	CPU Architecture:	Any
Tags:	MyODBC, Oracle Database Gateway, UPDATE

Description:
update tblusers@htstestdblink set "User_ID" = 723 where "Txt_UserName" = 'ctrikannad';
gives error ORA-02070: database HTSTESTDBLINK does not support some function in this context.

Txt_UserName is defined as varchar(35) in MySQL.

The corresponding sql statement runs correctly.

select * from tblusers@htstestdblink where "Txt_UserName" = 'ctrikannad';

If the attribute in where clause is numeric then it does not give syntax error.
Example:
update tblusers@htstestdblink set "User_ID" = 723 where "GUID_UserID" = '4';

OR 

update tblusers@htstestdblink set "User_ID" = 723 where "GUID_UserID" = 4;

How to repeat:
Used MySQl ODBC connector 3.51
Oracle database version 10.2.0.4
MySQL database version 5.0.90
Oracle database gateway 11g Release 2.

Use the above software.

Please, send the results of

show create table tblusers\G

from the MySQL server.

What exact Connector/ODBC version, 3.51.xx do you use?

MySQL ODBC version is 3.51.22.00

Client is using session sql-mode oracle.

Next I will submit the results of show create.

Can this be an issue with the Oracle Gateway software?

Results of show create on tblusers.

Attachment: tblusers_showcreate.doc (application/msword, text), 130.00 KiB.

I am sorry, my mistake. I had given a wrong MySQL ODBC driver version. I am using MYSQL ODBC 5.1 Driver with exact version as 5.01.08.00 and not 3.51.22.00.

I understand that Oracle Database Gateway does not work with ODBC 3.51.22.00 

Also, the ODBC driver is configured to use utf8 as Character Set.

I hope this helps

Charu,

Which driver manager are you using? UnixODBC, iODBC, DataDirect?
Which version?
Can you generate the ODBC trace?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.