'Column name is required in ColumnIdentifier.'

[Brian Boyer]

Team,

Please help.
I am having trouble with an update() function on a MYSQL 8.4 DB on OCI.

Getting the following error:
info: {
severity: 0,
code: 5152,
sqlState: 'HY000',
msg: 'Column name is required in ColumnIdentifier.'
}
Top Lines of Error: at BaseHandler.<computed>(/nmsv7.2/api/node_modules/@mysql/xdevapi/lib/Protocol/InboundHandlers/BaseHandler.js:121:17)
at Array.entry (/nmsv7.2/api/node_modules/@mysql/xdevapi/lib/Protocol/InboundHandlers/BaseHandler.js:92:29)
at WorkQueue.process (/nmsv7.2/api/node_modules/@mysql/xdevapi/lib/WorkQueue.js:77:19)

I dumbed down the update to the following:
var acts_info = session.getSchema('schema).getTable('acts_info')



acts_info.update().where('customer_number like :customer_number')
.bind('customer_number', data.customer_number)
.set('contact_via_mail', data.contact_via_mail)
.execute()


Let me know if you have a solution.

Thanks,

Brian