go-tarantool
go-tarantool copied to clipboard
Native UPDATE query not working
When sending the request via go-tarantool, nothing is updated and there are no errors with the CASE "id" WHEN ? THEN construct. However, when the same query is sent via DataGrip, everything works fine.
Example query:
UPDATE "attribute" SET "value" = CASE "id" WHEN ? THEN null END WHERE "id" IN (?)
req := tarantool.NewExecuteRequest(query).Args(args).Context(ctx)
Please provide the space format and a minimal reproducer. Everything works in our test scenarios, so maybe you are doing something wrong:
https://github.com/tarantool/go-tarantool/blob/536864682eaaad428cb2491131ad2c8ab8ae0506/tarantool_test.go#L1293
https://github.com/tarantool/go-tarantool/blob/536864682eaaad428cb2491131ad2c8ab8ae0506/tarantool_test.go#L1364-L1370
In addition, an execute response must be checked in the specific way:
https://github.com/tarantool/go-tarantool/blob/536864682eaaad428cb2491131ad2c8ab8ae0506/tarantool_test.go#L1459-L1461
@oleg-jukovec pay attention to the construction CASE "id" WHEN ? THEN null
@oleg-jukovec pay attention to the construction CASE "id" WHEN ? THEN null
The connector does not process or affect such constructs in any way. It simply passes them on to the Tarantool as is.
But I have this problem.
But I have this problem.
Please show the space format and provide a minimal reproducer.