Mapper query generation error: USING clause is misplaced

Description

via DataStax community (thanks Emile S.!).

the USING TTL clause on UPDATE query should be placed at the beginning of the query

as in:

1 UPDATE users USING TTL 10 SET favs['color'] = 'green' WHERE id = 'jsmith'

The Node.js mapper places the USING clause at the end: https://github.com/datastax/nodejs-driver/blob/v4.1.0/lib/mapping/query-generator.js#L113

Environment

None

Pull Requests

None

Status

Assignee

Jorge Bay Gondra

Reporter

Jorge Bay Gondra

Reviewer

None

Fix versions

Labels

Components

PM Priority

None

Reproduced in

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

Doc Impact

None

Size

None

Affects versions

4.1.0
DSE-2.1.0

Priority

Major