Re: Value expression strings on relational table update

[Rui Quelhas]

Lianto,

please ignore my previous message. The expression parser operates in DOCUMENT mode by default. In this case, what you want is TABLE mode, so you need to provide that option to "mysqlx.expr()".

In your example, you need to use

.set('age', mysqlx.expr('age + 1', { mode: mysqlx.Mode.TABLE })

This is probably not easy to understand from the documentation, so maybe you can actually report a bug about that.

I don't know what the Shell does exactly but it definitely creates the expression in table mode, which, in that case, might be the default mode or not (I would have to investigate further).


Hope it helps.