I use DataGrip 2023.3 with Cloud Spanner Driver 2.9.9
When I try to edit a number in the results table and then click 'Submit' to persist the changes, I get the error
INVALID_ARGUMENT: Value of type NUMERIC cannot be assigned to t.quantity, which has type INT64
Our table definition is
create table stock
(
id STRING(36) not null
constraint PRIMARY_KEY
primary key,
quantity INT64(19) not null,
changedAt TIMESTAMP(35) not null,
);
The resulting update statement is
UPDATE stock t SET t.quantity = 0 WHERE t.id = '0009e060-7ab3-43de-bbc1-082831fbe3ce'
A colleague uses another DB tool and the statement works as expected.
Is there any setting in DataGrip to make this work?