With version v1.5.43 timestamps returned by INSERT and SELECT doesn't match.
How to reproduce:
CREATE TABLE IF NOT EXISTS objects
(
version INT64 NOT NULL,
created_at TIMESTAMP NOT NULL DEFAULT (CURRENT_TIMESTAMP()),
) PRIMARY KEY (version)
INSERT INTO objects (version) VALUES(1) THEN RETURN objects.created_at
SELECT created_at from objects where version = 1Sample output:
INSERT INTO objects (version) VALUES(1) THEN RETURN objects.created_at
created_at
2025-11-20T10:36:22.906313Z
SELECT created_at from objects where version = 1
created_at
2025-11-20T10:36:22.906463Z <- doesn't match previous value
For production Spanner instance this sample returns the same values.
With version v1.5.43 timestamps returned by INSERT and SELECT doesn't match.
How to reproduce:
Sample output:
For production Spanner instance this sample returns the same values.