[MDEV-29397] Connect engine ODBC UPDATE triggers error instead of warning Created: 2022-08-26  Updated: 2022-11-08  Resolved: 2022-11-08

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.6
Fix Version/s: 10.3.39

Type: Bug Priority: Minor
Reporter: Andrew Hutchings Assignee: Andrew Hutchings
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-29687 ODBC tables do not quote identifier n... Closed

 Description   

Using the test in MDEV-25767 and executing the following (after fix) causes this:

insert into ACC009_SYNC values ('test', 'a', 'b', 'qwe', 'y', 'asdf', '2020', 1.0,1, 2, 'poi', now());
 
update ACC009_SYNC set COM_CODE='12345' WHERE COM_CODE='test';


ERROR 1296 (HY000): Got error 122 'ACC009: 1 affected rows' from CONNECT

The row is updated.

 Comments   
Comment by Andrew Hutchings [ 2022-11-03 ]

Cause is ODBConn::Rewind returns -1 if there is no m_hstmt, triggering an error condition but this is a valid thing during an UPDATE query. Unfortunately I can't write a test for it as MDEV-29687 has broken the ODBC tests.

Comment by Andrew Hutchings [ 2022-11-07 ]

PR open

Generated at Thu Feb 08 10:08:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.