Changes

1.93.0 (2026-07-15)

Features

• o11y: Regenerate clients for LRO tracing (#20107) (779074e)
• spanner: Abstract Spanner Omni gRPC connection logic for TLS/mTLS/plaintext as foundation of auth login functionality (#14694) (07d1ba5)
• Update API sources and regenerate (#20109) (4314d30)

Bug Fixes

• spanner: Roll back read-write transaction before retrying caller-returned Aborted errors (#20131) (83772f5)
• spanner: Update dynamic channel pool default configuration (#20080) (308659c)

1.92.0 (2026-06-15)

Features

• Enable EEF for cloud spanner when direct access is enabled (#14414) (d7c4e0f)
• add OpenTelemetry metrics for dynamic channel pool (#14613) (b54b4f0)
• add dynamic channel pool (#14611) (51a53ce)
• add option for auto-tagging transactions (#14646) (be0afd9)
• update API sources and regenerate (#14537) (07fe29b)

Bug Fixes

• Support UUID as a base data type (#14117) (f8b9a93)
• handle unused variables (#13088) (b295156)
• propagate previous transaction ID on inline-begin retries (#19955) (827f70e)

1.91.0 (2026-04-22)

1.90.0 (2026-04-14)

Features

• feat(spanner): add EnableDirectAccess field to ClientConfig (#14287) (6adf5b7)
• feat(spanner): Switch to using builtin open telemetry for EEF (#14193)(751febd)
• feat(spanner): complete location-aware routing resilience and observability (#14418 ) (77aa4df)

Bug Fixes

• fix(spanner): set gauge metric start time to match end time (#14289) (e0760b5)
• fix(spanner): update DirectPath detection logic to use ALTS credentials(#14288)(3cd5716)

1.89.0 (2026-03-26)

Features

• Add E2E fallback to the spanner client. (#13518) (16af6a1)
• Add gRPC A66/A94 metrics (#13825) (d695802)
• add SI, adapt, split point related proto (d3eb851)
• include cache updates and routing hint into BeginTransaction and Commit request/response respectively (9c80b8b)
• support Scan from string to NullUUID (#14128) (d897b6d)

Bug Fixes

• guard rollback when aborted commit cleared session handle (#14218) (6315105)
• replace multiplexed session request loop with shared in-flight creation (#14215) (3e3bd2d)

Documentation

• A comment for field execution_options in message .google.spanner.executor.v1.StartTransactionAction is changed (d3eb851)
• A comment for field routing_hint in messages .google.spanner.v1.ResultSet and .google.spanner.v1.PartialResultSet are changed (9c80b8b)
• A comment for message ListCloudInstancesAction is changed (d3eb851)
• A comment for message TransactionExecutionOptions is changed (d3eb851)
• A comment in message .google.spanner.v1.TransactionOptions.ReadWrite.ReadLockMode is changed (9c80b8b)

1.88.0 (2026-02-11)

Features

• Adding Send and Ack Mutation Support for Cloud Spanner Queue (#13616) (1cf600d)
• Exposing total CPU related fields in AutoscalingConfig (db65e79)
• PGNumeric implements Scanner and Valuer (#13722) (85bc9db)
• add ClientContext support (#13775) (e85d706)
• add Secure Parameters to the ClientContext (80379ed)
• add a ClientContext field to Spanner requests (80379ed)
• include cache updates into the ResultSet response (6f31019)
• support struct literal (#13766) (b4a6f4c)

Bug Fixes

• decode PG JSONB array to PGJsonB struct (#13602) (d72d0f4)
• disable config logging by default (#13478) (ad19592)

Performance Improvements

• only create sessions if multiplexed sessions are disabled (#13477) (e44e58f)

Documentation

• A comment for field commit_timestamp in message .google.spanner.v1.BatchWriteResponse is changed (6f31019)
• A comment for field param_types in message .google.spanner.v1.PartitionQueryRequest is changed (6f31019)
• A comment for field params in message .google.spanner.v1.PartitionQueryRequest is changed (6f31019)
• A comment for field transaction_tag in message .google.spanner.v1.RequestOptions is changed (6f31019)
• Update client side metrics and permission issues in README (#13491) (ab56892)
• Update high_priority_cpu_utilization_percent in AutoscalingConfig to be Optional and clarify its behavior when not specified (db65e79)

1.87.0 (2025-12-10)

Features

• Add QueryAdvisorResult for query plan (185951b)
• Add Send and Ack mutations for Queues (185951b)
• Add Spanner location API (185951b)
• Add grpc.xds.resource_type label to xDS client metrics (#13358) (b9196cf)
• Exposing AutoscalingConfig in InstancePartition (185951b)
• improve the SQL formatting when printing out SQL (#13267) (af0806f)
• support subquery in View Join (#13266) (d19f797)

Bug Fixes

• Configure keepAlive time for gRPC TCP connections (#13216) (ca8f64e)
• add env var to allow disabling directpath bound token (#13265) (029bc79)
• avoid double decrement in session counting (#13395) (e036421)
• decoding spanner rows using SelectAll should map values in correct annotations (#13301) (315f65b)
• error instead of panic for iterator after tx end (#13366) (a27c19a)
• fix createMultiplexedSession goroutine leak (#13396) (1805e89)
• transaction_tag should be set on BeginTransactionRequest (#13463) (a429aea)

Documentation

• Update description for the BatchCreateSessionsRequest and Session (185951b)
• Update description for the IsolationLevel (185951b)
• minor update for Spanner Location API (185951b)

1.86.1 (2025-10-22)

Bug Fixes

• spanner: Upgrade gRPC service registration func (8fffca2)

1.86.0 (2025-09-26)

Features

• spanner: Support “readOnly” column tag parsing for Go struct operations (#12895) (003abca)

Bug Fixes

• spanner: Use fresh context for rollback (#12897) (99c7eeb)

1.85.1 (2025-09-12)

Bug Fixes

• spanner: Disable afe_connectivity_error_count metric (#12866) (baab714)

Documentation

• spanner: A comment for enum Kind is changed (51583bd)
• spanner: A comment for enum Priority is changed (51583bd)
• spanner: A comment for enum value LOCK_HINT_EXCLUSIVE in enum LockHint is changed (51583bd)
• spanner: A comment for enum value LOCK_HINT_UNSPECIFIED in enum LockHint is changed (51583bd)
• spanner: A comment for enum value ORDER_BY_PRIMARY_KEY in enum OrderBy is changed (51583bd)
• spanner: A comment for enum value ORDER_BY_UNSPECIFIED in enum OrderBy is changed (51583bd)
• spanner: A comment for enum value PROFILE in enum QueryMode is changed (51583bd)
• spanner: A comment for enum value SERIALIZABLE in enum IsolationLevel is changed (51583bd)
• spanner: A comment for field approximate_last_use_time in message .google.spanner.v1.Session is changed (51583bd)
• spanner: A comment for field auto_failover_disabled in message .google.spanner.v1.DirectedReadOptions is changed (51583bd)
• spanner: A comment for field columns in message .google.spanner.v1.Mutation is changed (51583bd)
• spanner: A comment for field data_boost_enabled in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field data_boost_enabled in message .google.spanner.v1.ReadRequest is changed (51583bd)
• spanner: A comment for field exclude_replicas in message .google.spanner.v1.DirectedReadOptions is changed (51583bd)
• spanner: A comment for field exclude_txn_from_change_streams in message .google.spanner.v1.BatchWriteRequest is changed (51583bd)
• spanner: A comment for field include_replicas in message .google.spanner.v1.DirectedReadOptions is changed (51583bd)
• spanner: A comment for field index in message .google.spanner.v1.PlanNode is changed (51583bd)
• spanner: A comment for field insert_or_update in message .google.spanner.v1.Mutation is changed (51583bd)
• spanner: A comment for field key_set in message .google.spanner.v1.Mutation is changed (51583bd)
• spanner: A comment for field key_set in message .google.spanner.v1.PartitionReadRequest is changed (51583bd)
• spanner: A comment for field key_set in message .google.spanner.v1.ReadRequest is changed (51583bd)
• spanner: A comment for field kind in message .google.spanner.v1.PlanNode is changed (51583bd)
• spanner: A comment for field last_statement in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field last_statements in message .google.spanner.v1.ExecuteBatchDmlRequest is changed (51583bd)
• spanner: A comment for field limit in message .google.spanner.v1.ReadRequest is changed (51583bd)
• spanner: A comment for field location in message .google.spanner.v1.DirectedReadOptions is changed (51583bd)
• spanner: A comment for field max_commit_delay in message .google.spanner.v1.CommitRequest is changed (51583bd)
• spanner: A comment for field max_partitions in message .google.spanner.v1.PartitionOptions is changed (51583bd)
• spanner: A comment for field multiplexed in message .google.spanner.v1.Session is changed (51583bd)
• spanner: A comment for field mutation_key in message .google.spanner.v1.BeginTransactionRequest is changed (51583bd)
• spanner: A comment for field optimizer_statistics_package in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field optimizer_version in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field order_by in message .google.spanner.v1.ReadRequest is changed (51583bd)
• spanner: A comment for field param_types in message .google.spanner.v1.ExecuteBatchDmlRequest is changed (51583bd)
• spanner: A comment for field param_types in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field param_types in message .google.spanner.v1.PartitionQueryRequest is changed (51583bd)
• spanner: A comment for field params in message .google.spanner.v1.ExecuteBatchDmlRequest is changed (51583bd)
• spanner: A comment for field params in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field params in message .google.spanner.v1.PartitionQueryRequest is changed (51583bd)
• spanner: A comment for field partition_size_bytes in message .google.spanner.v1.PartitionOptions is changed (51583bd)
• spanner: A comment for field partition_token in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field partition_token in message .google.spanner.v1.Partition is changed (51583bd)
• spanner: A comment for field partition_token in message .google.spanner.v1.ReadRequest is changed (51583bd)
• spanner: A comment for field plan_nodes in message .google.spanner.v1.QueryPlan is changed (51583bd)
• spanner: A comment for field precommit_token in message .google.spanner.v1.CommitRequest is changed (51583bd)
• spanner: A comment for field precommit_token in message .google.spanner.v1.ExecuteBatchDmlResponse is changed (51583bd)
• spanner: A comment for field ranges in message .google.spanner.v1.KeySet is changed (51583bd)
• spanner: A comment for field replace in message .google.spanner.v1.Mutation is changed (51583bd)
• spanner: A comment for field request_options in message .google.spanner.v1.BeginTransactionRequest is changed (51583bd)
• spanner: A comment for field request_tag in message .google.spanner.v1.RequestOptions is changed (51583bd)
• spanner: A comment for field return_commit_stats in message .google.spanner.v1.CommitRequest is changed (51583bd)
• spanner: A comment for field seqno in message .google.spanner.v1.ExecuteBatchDmlRequest is changed (51583bd)
• spanner: A comment for field seqno in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field session_count in message .google.spanner.v1.BatchCreateSessionsRequest is changed (51583bd)
• spanner: A comment for field session_template in message .google.spanner.v1.BatchCreateSessionsRequest is changed (51583bd)
• spanner: A comment for field short_representation in message .google.spanner.v1.PlanNode is changed (51583bd)
• spanner: A comment for field single_use_transaction in message .google.spanner.v1.CommitRequest is changed (51583bd)
• spanner: A comment for field sql in message .google.spanner.v1.PartitionQueryRequest is changed (51583bd)
• spanner: A comment for field transaction in message .google.spanner.v1.ExecuteSqlRequest is changed (51583bd)
• spanner: A comment for field transaction in message .google.spanner.v1.PartitionQueryRequest is changed (51583bd)
• spanner: A comment for field transaction_tag in message .google.spanner.v1.RequestOptions is changed (51583bd)
• spanner: A comment for field values in message .google.spanner.v1.Mutation is changed (51583bd)
• spanner: A comment for field variable in message .google.spanner.v1.PlanNode is changed (51583bd)
• spanner: A comment for message DirectedReadOptions is changed (51583bd)
• spanner: A comment for message DirectedReadOptions is changed (51583bd)
• spanner: A comment for message DirectedReadOptions is changed (51583bd)
• spanner: A comment for message Mutation is changed (51583bd)
• spanner: A comment for message PartitionOptions is changed (51583bd)
• spanner: A comment for message PlanNode is changed (51583bd)
• spanner: A comment for method BatchWrite in service Spanner is changed (51583bd)
• spanner: A comment for method Commit in service Spanner is changed (51583bd)
• spanner: A comment for method CreateSession in service Spanner is changed (51583bd)
• spanner: A comment for method DeleteSession in service Spanner is changed (51583bd)
• spanner: A comment for method ExecuteSql in service Spanner is changed (51583bd)
• spanner: A comment for method ExecuteStreamingSql in service Spanner is changed (51583bd)
• spanner: A comment for method GetSession in service Spanner is changed (51583bd)
• spanner: A comment for method PartitionQuery in service Spanner is changed (51583bd)
• spanner: A comment for method PartitionRead in service Spanner is changed (51583bd)
• spanner: A comment for method Read in service Spanner is changed (51583bd)
• spanner: A comment for method Rollback in service Spanner is changed (51583bd)

1.85.0 (2025-08-28)

Features

• spanner: Enable multiplex sessions by default for all operations (#12734) (0491ba6)

Performance Improvements

• spanner: Improve mutationProto allocations and performance (#12740) (2a4add5)

1.84.1 (2025-08-06)

Features

• spanner: Release 1.84.1 (#12663) (8b410ec)

Miscellaneous Chores

• spanner: Release 1.84.1 (#12665) (a1ce8c2)

1.84.0 (2025-08-05)

Features

• spanner/adapter: Add last field in AdaptMessageResponse for internal optimization usage (c574e28)
• spanner/admin/database: Proto changes for an internal api (eeb4b1f)
• spanner: A new field snapshot_timestamp is added to message .google.spanner.v1.CommitResponse (ac4970b)
• spanner: Add GCP standard otel attributes (#11652) (f59fcff)

Bug Fixes

• spanner: Context cancel in traces in case of skipping trailers (#12635) (509dc90)
• spanner: Enforce only one resource header (#12618) (4e04b7e)
• spanner: Fix blind retry for ResourceExhausted (#12523) (f9b6e88)
• spanner: Remove stream wrapper for direct path check (#12622) (88a36cd)

Documentation

• spanner: A comment for enum value OPTIMISTIC in enum ReadLockMode is changed (ac4970b)
• spanner: A comment for enum value PESSIMISTIC in enum ReadLockMode is changed (ac4970b)
• spanner: A comment for enum value READ_LOCK_MODE_UNSPECIFIED in enum ReadLockMode is changed (ac4970b)
• spanner: A comment for field commit_stats in message .google.spanner.v1.CommitResponse is changed (ac4970b)
• spanner: A comment for field exclude_txn_from_change_streams in message .google.spanner.v1.TransactionOptions is changed (ac4970b)
• spanner: A comment for field multiplexed_session_previous_transaction_id in message .google.spanner.v1.TransactionOptions is changed (ac4970b)
• spanner: A comment for field precommit_token in message .google.spanner.v1.CommitResponse is changed (ac4970b)
• spanner: A comment for message .google.spanner.v1.MultiplexedSessionPrecommitToken is changed (ac4970b)
• spanner: A comment for message .google.spanner.v1.TransactionOptions is changed (ac4970b)

1.83.0 (2025-06-27)

Features

• spanner/spansql: Add support for TOKENIZE_JSON. (#12338) (72225a5)
• spanner/spansql: Support EXISTS in query parsing (#12439) (f5cb67b)
• spanner: Add new change_stream.proto (40b60a4)
• spanner: Add option for how to call BeginTransaction (#12436) (2cba13b)
• spanner: Wrap proto mutation (#12497) (e655889)

Bug Fixes

• spanner: Pointer type custom struct decoder (#12496) (ac3cafb)

1.82.0 (2025-05-20)

Features

• spanner/admin/database: Add throughput_mode to UpdateDatabaseDdlRequest to be used by Spanner Migration Tool. See https (#12287) (2a9d8ee)

1.81.1 (2025-05-15)

Bug Fixes

• spanner: Do not export metrics during shutdown if prev export was less than 30 seconds ago (#12266) (8ad7511)
• spanner: Fix invalid trace in case of skipping trailers (#12235) (e54c439)

1.81.0 (2025-05-09)

Features

• spanner/spansql: Add support for DROP SEARCH INDEX and ALTER SEARCH INDEX (#11961) (952cd7f)
• spanner: Add support of AFE and GRPC metrics in client-side metrics (#12067) (7b77038)

Bug Fixes

• spanner: Row mismatch in SelectAll using custom type (#12222) (ce6a23a)

1.80.0 (2025-04-23)

Features

• spanner: Add interval type support (#12009) (5152488)

Bug Fixes

• spanner/benchmarks: Update google.golang.org/api to 0.229.0 (3319672)
• spanner/test/opentelemetry/test: Update google.golang.org/api to 0.229.0 (3319672)
• spanner: Retry INTERNAL retriable auth error (#12034) (65c7461)
• spanner: Update google.golang.org/api to 0.229.0 (3319672)

Performance Improvements

• spanner: Skip gRPC trailers for StreamingRead & ExecuteStreamingSql (#11854) (10dc8b7)

1.79.0 (2025-04-08)

Features

• spanner: Allow string values for Scan functions (#11898) (9989dd0)
• spanner: New client(s) (#11946) (c60f28d)

1.78.0 (2025-03-24)

Features

• spanner/spansql: Add support for tokenlist and create search index (#11522) (cd894f8)
• spanner: Support multiplexed sessions for ReadWriteStmtBasedTransaction (#11852) (528d9dd)

Bug Fixes

• spanner/test/opentelemetry/test: Update golang.org/x/net to 0.37.0 (1144978)
• spanner: Revert the ALTS bound token enablement (#11799) (68cfb38)
• spanner: Update golang.org/x/net to 0.37.0 (1144978)

1.77.0 (2025-03-03)

Features

• spanner: A new enum IsolationLevel is added (#11624) (2c4fb44)
• spanner: A new field isolation_level is added to message .google.spanner.v1.TransactionOptions (2c4fb44)
• spanner: Add a last field in the PartialResultSet (#11645) (794ecf7)
• spanner: Add option for LastStatement in transaction (#11638) (d662a45)

Bug Fixes

• spanner: Avoid desructive context augmentation that dropped all headers (#11659) (594732d)

Documentation

• spanner: A comment for enum value OPTIMISTIC in enum ReadLockMode is changed (2c4fb44)
• spanner: A comment for enum value PESSIMISTIC in enum ReadLockMode is changed (2c4fb44)
• spanner: A comment for enum value READ_LOCK_MODE_UNSPECIFIED in enum ReadLockMode is changed (2c4fb44)
• spanner: A comment for field chunked_value in message .google.spanner.v1.PartialResultSet is changed (794ecf7)
• spanner: A comment for field precommit_token in message .google.spanner.v1.PartialResultSet is changed (794ecf7)
• spanner: A comment for field precommit_token in message .google.spanner.v1.ResultSet is changed (794ecf7)
• spanner: A comment for field query_plan in message .google.spanner.v1.ResultSetStats is changed (794ecf7)
• spanner: A comment for field row_count_lower_bound in message .google.spanner.v1.ResultSetStats is changed (794ecf7)
• spanner: A comment for field row_type in message .google.spanner.v1.ResultSetMetadata is changed (794ecf7)
• spanner: A comment for field rows in message .google.spanner.v1.ResultSet is changed (794ecf7)
• spanner: A comment for field stats in message .google.spanner.v1.PartialResultSet is changed (794ecf7)
• spanner: A comment for field stats in message .google.spanner.v1.ResultSet is changed (794ecf7)
• spanner: A comment for field values in message .google.spanner.v1.PartialResultSet is changed (794ecf7)
• spanner: A comment for message ResultSetMetadata is changed (794ecf7)
• spanner: A comment for message ResultSetStats is changed (794ecf7)

1.76.1 (2025-02-21)

Bug Fixes

• spanner: Multiplexed_session_previous_transaction_id is not supported in the request for a non multiplexed session (#11626) (a940bef)

1.76.0 (2025-02-20)

Features

• spanner/admin/database: Add instance partitions field in backup proto (c6a6dc7)
• spanner: Support multiplexed session for read-write transactions & partition ops (#11615) (4b40201)

Performance Improvements

• spanner: Grab debug stack outside of lock (#11587) (0ee82ff)

1.75.0 (2025-02-02)

Features

• spanner/admin/database: Add AddSplitPoints API (59fe58a)

Bug Fixes

• spanner: Inject “x-goog-spanner-request-id” into outgoing client context (#11544) (a8f16ef), refs #11543

1.74.0 (2025-01-24)

Features

• spanner/admin/instance: Exposing FreeInstanceAvailability in InstanceConfig (4254053)
• spanner/admin/instance: Exposing FreeInstanceMetadata in Instance configuration (to define the metadata related to FREE instance type) (4254053)
• spanner/admin/instance: Exposing InstanceType in Instance configuration (to define PROVISIONED or FREE spanner instance) (4254053)
• spanner/admin/instance: Exposing QuorumType in InstanceConfig (4254053)
• spanner/admin/instance: Exposing storage_limit_per_processing_unit in InstanceConfig (4254053)
• spanner: Add the last statement option to ExecuteSqlRequest and ExecuteBatchDmlRequest (8dedb87)
• spanner: Add UUID in Spanner TypeCode enum (46fc993)
• spanner: Implement generation and propagation of “x-goog-spanner-request-id” Header (#11048) (10960c1)

Bug Fixes

• spanner/spansql: PROTO BUNDLE and protobuf type parsing fixes (#11279) (b1ca714)
• spanner/test/opentelemetry/test: Update golang.org/x/net to v0.33.0 (e9b0b69)
• spanner: ReadWriteStmtBasedTransaction would not remember options for retries (#11443) (7d8f0c5)
• spanner: Support setting monitoring host via env and override any endpoint override from spanner options with default one (#11141) (3d61545)
• spanner: Update golang.org/x/net to v0.33.0 (e9b0b69)

Documentation

• spanner/admin/database: Fix typo timzeone -> timezone (a694e11)
• spanner/admin/instance: A comment for enum DefaultBackupScheduleType is changed (4254053)
• spanner/admin/instance: A comment for enum value AUTOMATIC in enum DefaultBackupScheduleType is changed (4254053)
• spanner/admin/instance: A comment for enum value GOOGLE_MANAGED in enum Type is changed (4254053)
• spanner/admin/instance: A comment for enum value NONE in enum DefaultBackupScheduleType is changed (4254053)
• spanner/admin/instance: A comment for enum value USER_MANAGED in enum Type is changed (4254053)
• spanner/admin/instance: A comment for field base_config in message .google.spanner.admin.instance.v1.InstanceConfig is changed (4254053)
• spanner/admin/instance: A comment for field default_backup_schedule_type in message .google.spanner.admin.instance.v1.Instance is changed (4254053)
• spanner/admin/instance: A comment for field filter in message .google.spanner.admin.instance.v1.ListInstanceConfigOperationsRequest is changed (4254053)
• spanner/admin/instance: A comment for field filter in message .google.spanner.admin.instance.v1.ListInstancePartitionOperationsRequest is changed (4254053)
• spanner/admin/instance: A comment for field instance_config in message .google.spanner.admin.instance.v1.CreateInstanceConfigRequest is changed (4254053)
• spanner/admin/instance: A comment for field instance_partition_deadline in message .google.spanner.admin.instance.v1.ListInstancePartitionOperationsRequest is changed (4254053)
• spanner/admin/instance: A comment for field location in message .google.spanner.admin.instance.v1.ReplicaInfo is changed (4254053)
• spanner/admin/instance: A comment for field node_count in message .google.spanner.admin.instance.v1.Instance is changed (4254053)
• spanner/admin/instance: A comment for field node_count in message .google.spanner.admin.instance.v1.InstancePartition is changed (4254053)
• spanner/admin/instance: A comment for field operations in message .google.spanner.admin.instance.v1.ListInstanceConfigOperationsResponse is changed (4254053)
• spanner/admin/instance: A comment for field operations in message .google.spanner.admin.instance.v1.ListInstancePartitionOperationsResponse is changed (4254053)
• spanner/admin/instance: A comment for field optional_replicas in message .google.spanner.admin.instance.v1.InstanceConfig is changed (4254053)
• spanner/admin/instance: A comment for field parent in message .google.spanner.admin.instance.v1.ListInstancePartitionsRequest is changed (4254053)
• spanner/admin/instance: A comment for field processing_units in message .google.spanner.admin.instance.v1.Instance is changed (4254053)
• spanner/admin/instance: A comment for field processing_units in message .google.spanner.admin.instance.v1.InstancePartition is changed (4254053)
• spanner/admin/instance: A comment for field referencing_backups in message .google.spanner.admin.instance.v1.InstancePartition is changed (4254053)
• spanner/admin/instance: A comment for field replicas in message .google.spanner.admin.instance.v1.InstanceConfig is changed (4254053)
• spanner/admin/instance: A comment for field storage_utilization_percent in message .google.spanner.admin.instance.v1.AutoscalingConfig is changed (4254053)
• spanner/admin/instance: A comment for field unreachable in message .google.spanner.admin.instance.v1.ListInstancePartitionsResponse is changed (4254053)
• spanner/admin/instance: A comment for message CreateInstanceConfigRequest is changed (4254053)
• spanner/admin/instance: A comment for message DeleteInstanceConfigRequest is changed (4254053)
• spanner/admin/instance: A comment for message UpdateInstanceConfigRequest is changed (4254053)
• spanner/admin/instance: A comment for method CreateInstance in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method CreateInstanceConfig in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method CreateInstancePartition in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method ListInstanceConfigOperations in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method ListInstanceConfigs in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method ListInstancePartitionOperations in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method MoveInstance in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method UpdateInstance in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method UpdateInstanceConfig in service InstanceAdmin is changed (4254053)
• spanner/admin/instance: A comment for method UpdateInstancePartition in service InstanceAdmin is changed (4254053)

1.73.0 (2024-11-14)

Features

• spanner: Add ResetForRetry method for stmt-based transactions (#10956) (02c191c)

Bug Fixes

• spanner: Add safecheck to avoid deadlock when creating multiplex session (#11131) (8ee5d05)
• spanner: Allow non default service account only when direct path is enabled (#11046) (4250788)
• spanner: Use spanner options when initializing monitoring exporter (#11109) (81413f3)

1.72.0 (2024-11-07)

Features

• spanner/spansql: Add support for protobuf column types & Proto bundles (#10945) (91c6f0f), refs #10944

Bug Fixes

• spanner: Skip exporting metrics if attempt or operation is not captured. (#11095) (1d074b5)

1.71.0 (2024-11-01)

Features

• spanner/admin/instance: Add support for Cloud Spanner Default Backup Schedules (706ecb2)
• spanner: Client built in metrics (#10998) (d81a1a7)

Bug Fixes

• spanner/test/opentelemetry/test: Update google.golang.org/api to v0.203.0 (8bb87d5)
• spanner/test/opentelemetry/test: WARNING: On approximately Dec 1, 2024, an update to Protobuf will change service registration function signatures to use an interface instead of a concrete type in generated .pb.go files. This change is expected to affect very few if any users of this client library. For more information, see https://togithub.com/googleapis/google-cloud-go/issues/11020. (2b8ca4b)
• spanner: Attempt latency for streaming call should capture the total latency till decoding of protos (#11039) (255c6bf)
• spanner: Decode PROTO to custom type variant of base type (#11007) (5e363a3)
• spanner: Update google.golang.org/api to v0.203.0 (8bb87d5)
• spanner: WARNING: On approximately Dec 1, 2024, an update to Protobuf will change service registration function signatures to use an interface instead of a concrete type in generated .pb.go files. This change is expected to affect very few if any users of this client library. For more information, see https://togithub.com/googleapis/google-cloud-go/issues/11020. (2b8ca4b)

1.70.0 (2024-10-14)

Features

• spanner/admin/instance: Define ReplicaComputeCapacity and AsymmetricAutoscalingOption (78d8513)
• spanner: Add INTERVAL API (78d8513)
• spanner: Add new QueryMode enum values (WITH_STATS, WITH_PLAN_AND_STATS) (78d8513)

Documentation

• spanner/admin/instance: A comment for field node_count in message spanner.admin.instance.v1.Instance is changed (78d8513)
• spanner/admin/instance: A comment for field processing_units in message spanner.admin.instance.v1.Instance is changed (78d8513)
• spanner: Update comment for PROFILE QueryMode (78d8513)

1.69.0 (2024-10-03)

Features

• spanner: Add x-goog-spanner-end-to-end-tracing header for requests to Spanner (#10241) (7f61cd5)

Bug Fixes

• spanner: Handle errors (#10943) (c67f964)

Performance Improvements

• spanner: Use passthrough with emulator endpoint (#10947) (9e964dd)

1.68.0 (2024-09-25)

Features

• spanner: Add support for Go 1.23 iterators (84461c0)

Bug Fixes

• spanner/test: Bump dependencies (2ddeb15)
• spanner: Bump dependencies (2ddeb15)
• spanner: Check errors in tests (#10738) (971bfb8)
• spanner: Enable toStruct support for structs with proto message pointer fields (#10704) (42cdde6)
• spanner: Ensure defers run at the right time in tests (#9759) (7ef0ded)
• spanner: Increase spanner ping timeout to give backend more time to process executeSQL requests (#10874) (6997991)
• spanner: Json null handling (#10660) (4c519e3)
• spanner: Support custom encoding and decoding of protos (#10799) (d410907)
• spanner: Unnecessary string formatting fixes (#10736) (1efe5c4)
• spanner: Wait for things to complete (#10095) (7785cad)

Performance Improvements

• spanner: Better error handling (#10734) (c342f65), refs #9749

Documentation

• spanner: Fix Key related document code to add package name (#10711) (bbe7b9c)

1.67.0 (2024-08-15)

Features

• spanner/admin/database: Add resource reference annotation to backup schedules (#10677) (6593c0d)
• spanner/admin/instance: Add edition field to the instance proto (6593c0d)
• spanner: Support commit options in mutation operations. (#10668) (62a56f9)

Bug Fixes

• spanner/test/opentelemetry/test: Update google.golang.org/api to v0.191.0 (5b32644)
• spanner: Update google.golang.org/api to v0.191.0 (5b32644)

Documentation

• spanner/admin/database: Add an example to filter backups based on schedule name (6593c0d)

1.66.0 (2024-08-07)

Features

• spanner/admin/database: Add support for Cloud Spanner Incremental Backups (d949cc0)
• spanner: Add support of multiplexed session support in writeAtleastOnce mutations (#10646) (54009ea)
• spanner: Add support of using multiplexed session with ReadOnlyTransactions (#10269) (7797022)

1.65.0 (2024-07-29)

Features

• spanner/admin/database: Add support for Cloud Spanner Scheduled Backups (3b15f9d)
• spanner: Add RESOURCE_EXHAUSTED to retryable transaction codes (#10412) (29b52dc)

Bug Fixes

• spanner/test: Bump google.golang.org/api@v0.187.0 (8fa9e39)
• spanner/test: Bump google.golang.org/grpc@v1.64.1 (8ecc4e9)
• spanner/test: Update dependencies (257c40b)
• spanner: Bump google.golang.org/api@v0.187.0 (8fa9e39)
• spanner: Bump google.golang.org/grpc@v1.64.1 (8ecc4e9)
• spanner: Fix negative values for max_in_use_sessions metrics #10449 (#10508) (4e180f4)
• spanner: HealthCheck should not decrement num_in_use sessions (#10480) (9b2b47f)
• spanner: Update dependencies (257c40b)

1.64.0 (2024-06-29)

Features

• spanner: Add field lock_hint in spanner.proto (3df3c04)
• spanner: Add field order_by in spanner.proto (3df3c04)
• spanner: Add LockHint feature (#10382) (64bdcb1)
• spanner: Add OrderBy feature (#10289) (07b8bd2)
• spanner: Add support of checking row not found errors from ReadRow and ReadRowUsingIndex (#10405) (5cb0c26)

Bug Fixes

• spanner: Fix data-race caused by TrackSessionHandle (#10321) (23c5fff), refs #10320
• spanner: Fix negative values for max_in_use_sessions metrics (#10449) (a1e198a)
• spanner: Prevent possible panic for Session not found errors (#10386) (ba9711f), refs #10385

1.63.0 (2024-05-24)

Features

• spanner: Fix schema naming (#10194) (215e0c8)
• spanner: Update go mod to use latest grpc lib (#10218) (adf91f9)

1.62.0 (2024-05-15)

Features

• spanner/admin/database: Add support for multi region encryption config (3e25053)
• spanner/executor: Add QueryCancellationAction message in executor protos (292e812)
• spanner: Add RESOURCE_EXHAUSTED to the list of retryable error codes (1d757c6)
• spanner: Add support for Proto Columns (#9315) (3ffbbbe)

Bug Fixes

• spanner: Add ARRAY keywords to keywords (#10079) (8e675cd)
• spanner: Handle unused errors (#10067) (a0c097c)
• spanner: Remove json-iterator dependency (#10099) (3917cca), refs #9380
• spanner: Update staleness bound (#10118) (c07f1e4)

1.61.0 (2024-04-30)

Features

• spanner/admin/instance: Adding EXPECTED_FULFILLMENT_PERIOD to the indicate instance creation times (with FULFILLMENT_PERIOD_NORMAL or FULFILLMENT_PERIOD_EXTENDED ENUM) with the extended instance creation time triggered by On-Demand Capacity... (#9693) (aa93790)
• spanner/executor: Add SessionPoolOptions, SpannerOptions protos in executor protos (2cdc40a)
• spanner: Add support for change streams transaction exclusion option (#9779) (979ce94)
• spanner: Support MultiEndpoint (#9565) (0ac0d26)

Bug Fixes

• spanner/test/opentelemetry/test: Bump x/net to v0.24.0 (ba31ed5)
• spanner: Bump x/net to v0.24.0 (ba31ed5)
• spanner: Fix uint8 conversion (9221c7f)

1.60.0 (2024-03-19)

Features

• spanner: Allow attempt direct path xds via env var (e4b663c)

1.59.0 (2024-03-13)

Features

• spanner/spansql: Support Table rename & Table synonym (#9275) (9b97ce7)
• spanner: Add support of float32 type (#9525) (87d7ea9)

Bug Fixes

• spanner: Add JSON_PARSE_ARRAY to funcNames slice (#9557) (f799597)

1.58.0 (2024-03-06)

Features

• spanner/admin/instance: Add instance partition support to spanner instance proto (ae1f547)
• spanner: Add field for multiplexed session in spanner.proto (a86aa8e)
• spanner: SelectAll struct spanner tag annotation match should be case-insensitive (#9460) (6cd6a73)
• spanner: Update TransactionOptions to include new option exclude_txn_from_change_streams (0195fe9)

1.57.0 (2024-02-13)

Features

• spanner: Add OpenTelemetry implementation (#9254) (fc51cc2)
• spanner: Support max_commit_delay in Spanner transactions (#9299) (a8078f0)

Bug Fixes

• spanner: Enable universe domain resolution options (fd1d569)
• spanner: Internal test package should import local version (#9416) (f377281)
• spanner: SelectAll struct fields match should be case-insensitive (#9417) (7ff5356)
• spanner: Support time.Time and other custom types using SelectAll (#9382) (dc21234)

Documentation

• spanner: Update the comment regarding eligible SQL shapes for PartitionQuery (e60a6ba)

1.56.0 (2024-01-30)

Features

• spanner/admin/database: Add proto descriptors for proto and enum types in create/update/get database ddl requests (97d62c7)
• spanner/spansql: Add support for CREATE VIEW with SQL SECURITY DEFINER (#8754) (5f156e8)
• spanner: Add FLOAT32 enum to TypeCode (97d62c7)
• spanner: Add max_commit_delay API (af2f8b4)
• spanner: Add proto and enum types (00b9900)
• spanner: Add SelectAll method to decode from Spanner iterator.Rows to golang struct (#9206) (802088f)

1.55.0 (2024-01-08)

Features

• spanner: Add directed reads feature (#7668) (a42604a)

1.54.0 (2023-12-14)

Features

• spanner/executor: Add autoscaling config in the instance to support autoscaling in systests (29effe6)
• spanner: New clients (#9127) (2c97389)

Bug Fixes

• spanner: Use json.Number for decoding unknown values from spanner (#9054) (40d1392)

1.53.1 (2023-12-01)

Bug Fixes

• spanner: Handle nil error when cleaning up long running session (#9052) (a93bc26)
• spanner: MarshalJSON function caused errors for certain values (#9063) (afe7c98)

1.53.0 (2023-11-15)

Features

• spanner: Enable long running transaction clean up (#8969) (5d181bb)

1.52.0 (2023-11-14)

Features

• spanner: Add directed_read_option in spanner.proto (#8950) (24e410e)
• spanner: Add DML, DQL, Mutation, Txn Actions and Utility methods for executor framework (#8976) (ca76671)
• spanner: Add lastUseTime property to session (#8942) (b560cfc)
• spanner: Add method (#8945) (411a51e)
• spanner: Add methods to return Row fields (#8953) (e22e70f)
• spanner: Add PG.OID type cod annotation (#8749) (ffb0dda)
• spanner: Admin, Batch, Partition actions for executor framework (#8932) (b2db89e)
• spanner: Auto-generated executor framework proto changes (#8713) (2ca939c)
• spanner: BatchWrite (#8652) (507d232)
• spanner: Executor framework server and worker proxy (#8714) (6b931ee)
• spanner: Fix falkiness (#8977) (ca8d3cb)
• spanner: Long running transaction clean up - disabled (#8177) (461d11e)
• spanner: Update code for session leaks cleanup (#8978) (cc83515)

Bug Fixes

• spanner: Bump google.golang.org/api to v0.149.0 (8d2ab9f)
• spanner: Expose Mutations field in MutationGroup (#8923) (42180cf)
• spanner: Update grpc-go to v1.56.3 (343cea8)
• spanner: Update grpc-go to v1.59.0 (81a97b0)

Documentation

• spanner: Updated comment formatting (24e410e)

1.51.0 (2023-10-17)

Features

• spanner/admin/instance: Add autoscaling config to the instance proto (#8701) (56ce871)

Bug Fixes

• spanner: Update golang.org/x/net to v0.17.0 (174da47)

1.50.0 (2023-10-03)

Features

• spanner/spansql: Add support for aggregate functions (#8498) (d440d75)
• spanner/spansql: Add support for bit functions, sequence functions and GENERATE_UUID (#8482) (3789882)
• spanner/spansql: Add support for SEQUENCE statements (#8481) (ccd0205)
• spanner: Add BatchWrite API (02a899c)
• spanner: Allow non-default service accounts (#8488) (c90dd00)

1.49.0 (2023-08-24)

Features

• spanner/spannertest: Support INSERT DML (#7820) (3dda7b2)

Bug Fixes

• spanner: Transaction was started in a different session (#8467) (6c21558)

1.48.0 (2023-08-18)

Features

• spanner/spansql: Add complete set of math functions (#8246) (d7a238e)
• spanner/spansql: Add support for foreign key actions (#8296) (d78b851)
• spanner/spansql: Add support for IF NOT EXISTS and IF EXISTS clause (#8245) (96840ab)
• spanner: Add integration tests for Bit Reversed Sequences (#7924) (9b6e7c6)

Bug Fixes

• spanner: Reset buffer after abort on first SQL statement (#8440) (d980b42)
• spanner: REST query UpdateMask bug (df52820)

1.47.0 (2023-06-20)

Features

• spanner/admin/database: Add DdlStatementActionInfo and add actions to UpdateDatabaseDdlMetadata (01eff11)
• spanner: Add databoost property for batch transactions (#8152) (fc49c78)
• spanner: Add tests for database roles in PG dialect (#7898) (dc84649)
• spanner: Enable client to server compression (#7899) (3a047d2)
• spanner: Update all direct dependencies (b340d03)

Bug Fixes

• spanner: Fix TestRetryInfoTransactionOutcomeUnknownError flaky behaviour (#7959) (f037795)

1.46.0 (2023-05-12)

Features

• spanner/admin/database: Add support for UpdateDatabase in Cloud Spanner (#7917) (83870f5)
• spanner: Make leader aware routing default enabled for supported RPC requests. (#7912) (d0d3755)

Bug Fixes

• spanner: Update grpc to v1.55.0 (1147ce0)

1.45.1 (2023-04-21)

Bug Fixes

• spanner/spannertest: Send transaction id in result metadata (#7809) (e3bbd5f)
• spanner: Context timeout should be wrapped correctly (#7744) (f8e22f6)

1.45.0 (2023-04-10)

Features

• spanner/spansql: Add support for missing DDL syntax for ALTER CHANGE STREAM (#7429) (d34fe02)
• spanner/spansql: Support fine-grained access control DDL syntax (#6691) (a7edf6b)
• spanner/spansql: Support grant/revoke view, change stream, table function (#7533) (9c61215)
• spanner: Add x-goog-spanner-route-to-leader header to Spanner RPC contexts for RW/PDML transactions. (#7500) (fcab05f)
• spanner: Adding new fields for Serverless analytics (69067f8)
• spanner: Enable custom decoding for list value (#7463) (3aeadcd)
• spanner: Update iam and longrunning deps (91a1f78)

Bug Fixes

• spanner/spansql: Fix SQL for CREATE CHANGE STREAM TableName; case (#7514) (fc5fd86)
• spanner: Correcting the proto field Id for field data_boost_enabled (00fff3a)

1.44.0 (2023-02-01)

Features

• spanner/spansql: Add support for ALTER INDEX statement (#7287) (fbe1bd4)
• spanner/spansql: Add support for managing the optimizer statistics package (#7283) (e528221)
• spanner: Add support for Optimistic Concurrency Control (#7332) (48ba16f)

1.43.0 (2023-01-19)

Features

• spanner/spansql: Add support for change stream value_capture_type option (#7201) (27b3398)
• spanner/spansql: Support default_leader database option (#7187) (88adaa2)
• spanner: Add REST client (06a54a1)
• spanner: Inline begin transaction for ReadWriteTransactions (#7149) (2ce3606)

Bug Fixes

• spanner: Fix integration tests data race (#7229) (a741024)

1.42.0 (2022-12-14)

Features

• spanner: Add database roles (#5701) (6bb95ef)
• spanner: Rewrite signatures and type in terms of new location (620e6d8)

Bug Fixes

• spanner: Fallback to check grpc error message if ResourceType is nil for checking sessionNotFound errors (#7163) (2552e09)

1.41.0 (2022-12-01)

Features

• spanner: Start generating proto stubs (#7030) (41f446f)

1.40.0 (2022-11-03)

Features

• spanner/spansql: Add support for interval arg of some date/timestamp functions (#6950) (1ce0f7d)
• spanner: Configurable logger (#6958) (bd85442), refs #6957
• spanner: PG JSONB support (#6874) (5b14658)
• spanner: Update result_set.proto to return undeclared parameters in ExecuteSql API (de4e16a)
• spanner: Update transaction.proto to include different lock modes (caf4afa)

1.39.0 (2022-09-21)

Features

• spanner/admin/database: Add custom instance config operations (ec1a190)
• spanner/admin/instance: Add custom instance config operations (ef2b0b1)
• spanner/spannersql: Add backticks when name contains a hypen (#6621) (e88ca66)
• spanner/spansql: Add support for create, alter and drop change … (#6669) (cc4620a)
• spanner: Retry spanner transactions and mutations when RST_STREAM error (#6699) (1b56cd0)

Bug Fixes

• spanner/admin/database: Revert add custom instance config operations (change broke client libraries; reverting before any are released) (ec1a190)
• spanner: Destroy session when client is closing (#6700) (a1ce541)
• spanner: Spanner sessions will be cleaned up from the backend (#6679) (c27097e)

1.38.0 (2022-09-03)

Features

• spanner/spannertest: add support for adding and dropping Foreign Keys (#6608) (ccd3614)
• spanner/spansql: add support for coalesce expressions (#6461) (bff16a7)
• spanner: Adds auto-generated CL for googleapis for jsonb (3bc37e2)

Bug Fixes

• spanner: pass userAgent to cloud spanner requests (#6598) (59d162b)

1.37.0 (2022-08-28)

Features

• spanner/admin/database: Add ListDatabaseRoles API to support role based access control (1ffeb95)
• spanner/spansql: add support for nullif expressions (#6423) (5b7bfeb)
• spanner: install grpc rls and xds by default (#6007) (70d562f)
• spanner: set client wide ReadOptions, ApplyOptions, and TransactionOptions (#6486) (757f1ca)

Bug Fixes

• spanner/admin/database: target new spanner db admin service config (1d6fbcc)

1.36.0 (2022-07-23)

Features

• spanner/spansql: add support for IFNULL expressions (#6389) (09e96ce)
• spanner/spansql: support for parsing a DML file (#6349) (267a9bb)

1.35.0 (2022-07-19)

Features

• spanner/admin/instance: Adding two new fields for Instance create_time and update_time (8a1ad06)
• spanner/spansql: add support for if expressions (#6341) (56c858c)

Bug Fixes

• spanner: fix pool.numInUse exceeding MaxOpened (#6344) (882b325)

1.34.1 (2022-07-06)

Bug Fixes

• spanner/spansql: Add tests for INSERT parsing (#6303) (0d19fb5)

1.34.0 (2022-06-17)

Features

• spanner/spansql: add a support for parsing INSERT statement (#6148) (c6185cf)
• spanner: add Session creator role docs: clarify transaction semantics (4134941)

1.33.0 (2022-05-28)

Bug Fixes

• spanner/spansql: fix invalid timestamp literal formats (#6077) (6ab8bed)

Miscellaneous Chores

• spanner: release 1.33.0 (#6104) (54bc54e)

1.32.0 (2022-05-09)

Features

• spanner/spansql: support DEFAULT keyword (#5932) (49c19a9)
• spanner/spansql: support JSON literals (#5968) (b500120)
• spanner: enable row.ToStructLenient to work with STRUCT data type (#5944) (bca8d50)

1.31.0 (2022-04-08)

Features

• spanner/spansql: support case expression (#5836) (3ffdd62)

Bug Fixes

• spanner/spannertest: Improve DDL application delay cancellation. (#5874) (08f1e72)

1.30.1 (2022-03-28)

Bug Fixes

• spanner: early unlock of session pool lock during dumping the tracked session handles to avoid deadlock (#5777) (b007836)

1.30.0 (2022-03-04)

Features

• spanner: add better version metadata to calls (#5515) (dcab7c4), refs #2749
• spanner: add file for tracking version (17b36ea)
• spanner: add support of PGNumeric with integration tests for PG dialect (#5700) (f7e02e1)
• spanner: set versionClient to module version (55f0d92)

Bug Fixes

• spanner/spansql: support GROUP BY without an aggregation function (#5717) (c819ee9)

Miscellaneous Chores

• spanner: release 1.30.0 (#5715) (a19d182)

1.29.0 (2022-01-06)

⚠ BREAKING CHANGES

• spanner: fix data race in spanner integration tests (#5276)

Features

• spanner/spansql: support EXTRACT (#5218) (81b7c85)
• spanner/spansql: support MOD function (#5231) (0a81fbc)
• spanner: add google-c2p dependence (5343756)
• spanner: Add ReadRowWithOptions method (#5240) (c276428)
• spanner: Adding GFE Latency and Header Missing Count Metrics (#5199) (3d8a9ea)

Bug Fixes

• spanner: result from unmarshal of string and spanner.NullString type from json should be consistent. (#5263) (7eaaa47)

Tests

• spanner: fix data race in spanner integration tests (#5276) (22df34b)

Miscellaneous Chores

• spanner: release 1.29.0 (#5292) (9f0b900)

1.28.0 (2021-12-03)

Features

• spanner/spannertest: support JSON_VALUE function (#5173) (ac98735)
• spanner/spansql: support CAST and SAFE_CAST (#5057) (54cbf4c)
• spanner: add ToStructLenient method to decode to struct fields with no error return with un-matched row‘s column with struct’s exported fields. (#5153) (899ffbf)

1.27.0 (2021-10-19)

Features

• spanner: implement valuer and scanner interfaces (#4936) (4537b45)

1.26.0 (2021-10-11)

Features

• spanner/spannertest: implement RowDeletionPolicy in spannertest (#4961) (7800a33), refs #4782
• spanner/spannertest: Support generated columns (#4742) (324d11d)
• spanner/spansql: fill in missing hash functions (#4808) (37ee2d9)
• spanner/spansql: support JSON data type (#4959) (e84e408)
• spanner/spansql: Support multiple joins in query (#4743) (81a308e)

1.25.0 (2021-08-25)

Features

• spanner/spansql: add support for STARTS_WITH function (#4670) (7a56af0), refs #4661
• spanner: add support for JSON data type (#4104) (ade8ab1)

Bug Fixes

• spanner/spannertest: Fix the “LIKE” clause handling for prefix and suffix matches (#4655) (a2118f0)
• spanner: invalid numeric should throw an error (#3926) (cde8697)

1.24.1 (2021-08-11)

Bug Fixes

• spanner/spansql: only add comma after other option (#4551) (3ac1e00)
• spanner: allow decoding null values to spanner.Decoder (#4558) (45ddaca), refs #4552

1.24.0 (2021-07-29)

Features

• spanner/spansql: add ROW DELETION POLICY parsing (#4496) (3d6c6c7)
• spanner/spansql: fix unstable SelectFromTable SQL (#4473) (39bc4ec)
• spanner/spansql: support ALTER DATABASE (#4403) (1458dc9)
• spanner/spansql: support table_hint_expr at from_clause on query_statement (#4457) (7047808)
• spanner: add row.String() and refine error message for decoding a struct array (#4431) (f6258a4)
• spanner: allow untyped nil values in parameterized queries (#4482) (c1ba18b)

Bug Fixes

• spanner/spansql: fix DATE and TIMESTAMP parsing. (#4480) (dec7a67)

1.23.0 (2021-07-08)

Features

• spanner/admin/database: add leader_options to InstanceConfig and default_leader to Database (7aa0e19)

1.22.0 (2021-06-30)

Features

• spanner: support request and transaction tags (#4336) (f08c73a)
• spanner: enable request options for batch read (#4337) (b9081c3)

1.21.0 (2021-06-23)

Miscellaneous Chores

• spanner: trigger a release for low cost instance (#4264) (24c4451)

1.20.0 (2021-06-08)

Features

• spanner: add the support of optimizer statistics package (#2717) (29c7247)

1.19.0 (2021-06-03)

Features

• spanner/spannertest: support multiple aggregations (#3965) (1265dc3)
• spanner/spansql: case insensitive parsing of keywords and functions (#4034) (ddb09d2)
• spanner: add a database name getter to client (#4190) (7fce29a)
• spanner: add custom instance config to tests (#4194) (e935345)

Bug Fixes

• spanner: add missing NUMERIC type to the doc for Row (#4116) (9a3b416)
• spanner: indent code example for Encoder and Decoder (#4128) (7c1f48f)
• spanner: mark SessionPoolConfig.MaxBurst deprecated (#4115) (d60a686)

1.18.0 (2021-04-29)

Features

• spanner/admin/database: add progress field to UpdateDatabaseDdlMetadata (9029071)

1.17.0 (2021-03-31)

Features

• spanner/admin/database: add tagging request options (2b02a03)
• spanner: add RPC Priority request options (b5b4da6)
• spanner: Add support for RPC priority (#3341) (88cf097)

1.16.0 (2021-03-17)

Features

• spanner: add optimizer_statistics_package field in QueryOptions (18c88c4)
• spanner/admin/database: add CMEK fields to backup and database (16597fa)

Bug Fixes

• spanner/spansql: fix parsing of NOT IN operator (#3724) (7636478)

1.15.0 (2021-02-24)

Features

• spanner/admin/database: add CMEK fields to backup and database (47037ed)
• spanner/admin/database: add CMEK fields to backup and database (16597fa)

Bug Fixes

• spanner: parallelize session deletion when closing pool (#3701) (75ac7d2), refs #3685

1.14.1 (2021-02-09)

Bug Fixes

• spanner: restore removed scopes (#3684) (232d3a1)

1.14.0 (2021-02-09)

Features

• spanner/admin/database: adds PITR fields to backup and database (0959f27)
• spanner/spannertest: restructure column alteration implementation (#3616) (176400b)
• spanner/spansql: add complete set of array functions (#3633) (13d50b9)
• spanner/spansql: add complete set of string functions (#3625) (34027ad)
• spanner: add option for returning Spanner commit stats (c7ecf0f)
• spanner: add option for returning Spanner commit stats (7bdebad)
• spanner: support CommitStats (#3444) (b7c3ca6)

Bug Fixes

• spanner/spannertest: support queries in ExecuteSql (#3640) (8eede84), refs #3639
• spanner/spansql: fix SelectFromJoin behavior (#3571) (e0887c7)

1.13.0 (2021-01-15)

Features

• spanner/spannertest: implement ANY_VALUE aggregation function (#3428) (e16c3e9)
• spanner/spannertest: implement FULL JOIN (#3218) (99f7212)
• spanner/spannertest: implement SELECT ... FROM UNNEST(...) (#3431) (deb466f)
• spanner/spannertest: support array literals (#3438) (69e0110)
• spanner/spannertest: support AVG aggregation function (#3286) (4788415)
• spanner/spannertest: support Not Null constraint (#3491) (c36aa07)
• spanner/spannertest: support UPDATE DML (#3201) (1dec6f6)
• spanner/spansql: define structures and parse UPDATE DML statements (#3192) (23b6904)
• spanner/spansql: support DATE and TIMESTAMP literals (#3557) (1961930)
• spanner/spansql: support for parsing generated columns (#3373) (9b1d06f)
• spanner/spansql: support NUMERIC data type (#3411) (1bc65d9)
• spanner: Add a DirectPath fallback integration test (#3487) (de821c5)
• spanner: attempt DirectPath by default (#3516) (bbc61ed)
• spanner: include User agent (#3465) (4e1ef1b)
• spanner: run E2E test over DirectPath (#3466) (18e3a4f)
• spanner: support NUMERIC in mutations (#3328) (fa90737)

Bug Fixes

• spanner: fix session leak (#3461) (11fb917), refs #3460

1.12.0 (2020-11-10)

Features

• spanner: add metadata to RowIterator (#3050) (9a2289c), closes #1805
• spanner: export ToSpannerError (#3133) (b951d8b), closes #3122
• spanner: support rw-transaction with options (#3058) (5130694)
• spanner/spannertest: make SELECT list aliases visible to ORDER BY (#3054) (7d2d83e), closes #3043

v1.11.0

• Features:
  • feat(spanner): add KeySetFromKeys function (#2837)
• Misc:
  • test(spanner): check for Aborted error (#3039)
  • test(spanner): fix potential race condition in TestRsdBlockingStates (#3017)
  • test(spanner): compare data instead of struct (#3013)
  • test(spanner): fix flaky oc_test.go (#2838)
  • docs(spanner): document NULL value (#2885)
• spansql/spannertest:
  • Support JOINs (all but FULL JOIN) (#2936, #2924, #2896, #3042, #3037, #2995, #2945, #2931)
  • feat(spanner/spansql): parse CHECK constraints (#3046)
  • fix(spanner/spansql): fix parsing of unary minus and plus (#2997)
  • fix(spanner/spansql): fix parsing of adjacent inline and leading comments (#2851)
  • fix(spanner/spannertest): fix ORDER BY combined with SELECT aliases (#3043)
  • fix(spanner/spannertest): generate query output columns in construction order (#2990)
  • fix(spanner/spannertest): correct handling of NULL AND FALSE (#2991)
  • fix(spanner/spannertest): correct handling of tri-state boolean expression evaluation (#2983)
  • fix(spanner/spannertest): fix handling of NULL with LIKE operator (#2982)
  • test(spanner/spannertest): migrate most test code to integration_test.go (#2977)
  • test(spanner/spansql): add fuzz target for ParseQuery (#2909)
  • doc(spanner/spannertest): document the implementation (#2996)
  • perf(spanner/spannertest): speed up no-wait DDL changes (#2994)
  • perf(spanner/spansql): make fewer allocations during SQL (#2969)
• Backward Incompatible Changes
  • chore(spanner/spansql): use ID type for identifiers throughout (#2889)
  • chore(spanner/spansql): restructure FROM, TABLESAMPLE (#2888)

v1.10.0

• feat(spanner): add support for NUMERIC data type (#2415)
• feat(spanner): add custom type support to spanner.Key (#2748)
• feat(spanner/spannertest): add support for bool parameter types (#2674)
• fix(spanner): update PDML to take sessions from pool (#2736)
• spanner/spansql: update docs on TableAlteration, ColumnAlteration (#2825)
• spanner/spannertest: support dropping columns (#2823)
• spanner/spannertest: implement GetDatabase (#2802)
• spanner/spannertest: fix aggregation in query evaluation for empty inputs (#2803)

v1.9.0

• Features:
  • feat(spanner): support custom field type (#2614)
• Bugfixes:
  • fix(spanner): call ctx.cancel after stats have been recorded (#2728)
  • fix(spanner): retry session not found for read (#2724)
  • fix(spanner): specify credentials with SPANNER_EMULATOR_HOST (#2701)
  • fix(spanner): update pdml to retry EOS internal error (#2678)
• Misc:
  • test(spanner): unskip tests for emulator (#2675)
• spansql/spannertest:
  • spanner/spansql: restructure types and parsing for column options (#2656)
  • spanner/spannertest: return error for Read with no keys (#2655)

v1.8.0

• Features:
  • feat(spanner): support of client-level custom retry settings (#2599)
  • feat(spanner): add a statement-based way to run read-write transaction. (#2545)
• Bugfixes:
  • fix(spanner): set ‘gccl’ to the request header. (#2609)
  • fix(spanner): add the missing resource prefix (#2605)
  • fix(spanner): fix the upgrade of protobuf. (#2583)
  • fix(spanner): do not copy protobuf messages by value. (#2581)
  • fix(spanner): fix the required resource prefix. (#2580)
  • fix(spanner): add extra field to ignore with cmp (#2577)
  • fix(spanner): remove appengine-specific numChannels. (#2513)
• Misc:
  • test(spanner): log warning instead of fail for stress test (#2559)
  • test(spanner): fix failed TestRsdBlockingStates test (#2597)
  • chore(spanner): cleanup mockserver and mockclient (#2414)

v1.7.0

• Retry:
  • Only retry certain types of internal errors. (#2460)
• Tracing/metrics:
  • Never sample ping() trace spans (#2520)
  • Add oc tests for session pool metrics. (#2416)
• Encoding:
  • Allow encoding struct with custom types to mutation (#2529)
• spannertest:
  • Fix evaluation on IN (#2479)
  • Support MIN/MAX aggregation functions (#2411)
• Misc:
  • Fix TestClient_WithGRPCConnectionPoolAndNumChannels_Misconfigured test (#2539)
  • Cleanup backoff files and rename a variable (#2526)
  • Fix TestIntegration_DML test to return err from tx (#2509)
  • Unskip tests for emulator 0.8.0. (#2494)
  • Fix TestIntegration_StartBackupOperation test. (#2418)
  • Fix flakiness in TestIntegration_BatchDML_Error
  • Unskip TestIntegration_BatchDML and TestIntegration_BatchDML_TwoStatements for emulator by checking the existence of status.
  • Fix TestStressSessionPool test by taking lock while getting sessions from hc.

v1.6.0

• Sessions:
  • Increase the number of sessions in batches instead of one by one when additional sessions are needed. The step size is set to 25, which means that whenever the session pool needs at least one more session, it will create a batch of 25 sessions.
• Emulator:
  • Run integration tests against the emulator in Kokoro Presubmit.
• RPC retrying:
  • Retry CreateDatabase on retryable codes.
• spannertest:
  • Change internal representation of DATE/TIMESTAMP values.
• spansql:
  • Cleanly parse adjacent comment marker/terminator.
  • Support FROM aliases in SELECT statements.
• Misc:
  • Fix comparing errors in tests.
  • Fix flaky session pool test.
  • Increase timeout in TestIntegration_ReadOnlyTransaction.
  • Fix incorrect instance IDs when deleting instances in tests.
  • Clean up test instances.
  • Clearify docs on Aborted transaction.
  • Fix timeout+staleness bound for test
  • Remove the support for resource-based routing.
  • Fix TestTransaction_SessionNotFound test.

v1.5.1

• Fix incorrect decreasing metrics, numReads and numWrites.
• Fix an issue that XXX fields/methods are internal to proto and may change at any time. XXX_Merge panics in proto v1.4.0. Use proto.Merge instead of XXX_Merge.
• spannertest: handle list parameters in RPC interfacea.

v1.5.0

• Metrics
  • Instrument client library with adding OpenCensus metrics. This allows for better monitoring of the session pool.
• Session management
  • Switch the session keepalive method from GetSession to SELECT 1.
• Emulator
  • Use client hooks for admin clients running against an emulator. With this change, users can use SPANNER_EMULATOR_HOST for initializing admin clients when running against an emulator.
• spansql
  • Add space between constraint name and foreign key def.
• Misc
  • Fix segfault when a non-existent credentials file had been specified.
  • Fix cleaning up instances in integration tests.
  • Fix race condition in batch read-only transaction.
  • Fix the flaky TestLIFOTakeWriteSessionOrder test.
  • Fix ITs to order results in SELECT queries.
  • Fix the documentation of timestamp bounds.
  • Fix the regex issue in managing backups.

v1.4.0

• Support managed backups. This includes the API methods for CreateBackup, GetBackup, UpdateBackup, DeleteBackup and others. Also includes a simple wrapper in DatabaseAdminClient to create a backup.
• Update the healthcheck interval. The default interval is updated to 50 mins. By default, the first healthcheck is scheduled between 10 and 55 mins and the subsequent healthchecks are between 45 and 55 mins. This update avoids overloading the backend service with frequent healthchecking.

v1.3.0

• Query options:
  • Adds the support of providing query options (optimizer version) via three ways (precedence follows the order): client-level < environment variables < query-level. The environment variable is set by “SPANNER_OPTIMIZER_VERSION”.
• Connection pooling:
  • Use the new connection pooling in gRPC. This change deprecates ClientConfig.numChannels and users should move to WithGRPCConnectionPool(numChannels) at their earliest convenience. Example:

    // numChannels (deprecated):
    err, client := NewClientWithConfig(ctx, database, ClientConfig{NumChannels: 8})
    
    // gRPC connection pool:
    err, client := NewClientWithConfig(ctx, database, ClientConfig{}, option.WithGRPCConnectionPool(8))
    

• Error handling:
  • Do not rollback after failed commit.
  • Return TransactionOutcomeUnknownError if a DEADLINE_EXCEEDED or CANCELED error occurs while a COMMIT request is in flight.
• spansql:
  • Added support for IN expressions and OFFSET clauses.
  • Fixed parsing of table constraints.
  • Added support for foreign key constraints in ALTER TABLE and CREATE TABLE.
  • Added support for GROUP BY clauses.
• spannertest:
  • Added support for IN expressions and OFFSET clauses.
  • Added support for GROUP BY clauses.
  • Fixed data race in query execution.
  • No longer rejects reads specifying an index to use.
  • Return last commit timestamp as read timestamp when requested.
  • Evaluate add, subtract, multiply, divide, unary negation, unary not, bitwise and/xor/or operations, as well as reporting column types for expressions involving any possible arithmetic operator.arithmetic expressions.
  • Fixed handling of descending primary keys.
• Misc:
  • Change default healthcheck interval to 30 mins to reduce the GetSession calls made to the backend.
  • Add marshal/unmarshal json for nullable types to support NullString, NullInt64, NullFloat64, NullBool, NullTime, NullDate.
  • Use ResourceInfo to extract error.
  • Extract retry info from status.

v1.2.1

• Fix session leakage for ApplyAtLeastOnce. Previously session handles where leaked whenever Commit() returned a non-abort, non-session-not-found error, due to a missing recycle() call.
• Fix error for WriteStruct with pointers. This fixes a specific check for encoding and decoding to pointer types.
• Fix a GRPCStatus issue that returns a Status that has Unknown code if the base error is nil. Now, it always returns a Status based on Code field of current error.

v1.2.0

• Support tracking stacktrace of sessionPool.take() that allows the user to instruct the session pool to keep track of the stacktrace of each goroutine that checks out a session from the pool. This is disabled by default, but it can be enabled by setting SessionPoolConfig.TrackSessionHandles: true.
• Add resource-based routing that includes a step to retrieve the instance-specific endpoint before creating the session client when creating a new spanner client. This is disabled by default, but it can be enabled by setting GOOGLE_CLOUD_SPANNER_ENABLE_RESOURCE_BASED_ROUTING.
• Make logger configurable so that the Spanner client can now be configured to use a specific logger instead of the standard logger.
• Support encoding custom types that point back to supported basic types.
• Allow decoding Spanner values to custom types that point back to supported types.

v1.1.0

• The String() method of NullString, NullTime and NullDate will now return an unquoted string instead of a quoted string. This is a BREAKING CHANGE. If you relied on the old behavior, please use fmt.Sprintf(“%q”, T).
• The Spanner client will now use the new BatchCreateSessions RPC to initialize the session pool. This will improve the startup time of clients that are initialized with a minimum number of sessions greater than zero (i.e. SessionPoolConfig.MinOpened>0).
• Spanner clients that are created with the NewClient method will now default to a minimum of 100 opened sessions in the pool (i.e. SessionPoolConfig.MinOpened=100). This will improve the performance of the first transaction/query that is executed by an application, as a session will normally not have to be created as part of the transaction. Spanner clients that are created with the NewClientWithConfig method are not affected by this change.
• Spanner clients that are created with the NewClient method will now default to a write sessions fraction of 0.2 in the pool (i.e. SessionPoolConfig.WriteSessions=0.2). Spanner clients that are created with the NewClientWithConfig method are not affected by this change.
• The session pool maintenance worker has been improved so it keeps better track of the actual number of sessions needed. It will now less often delete and re-create sessions. This can improve the overall performance of applications with a low transaction rate.

v1.0.0

This is the first tag to carve out spanner as its own module. See: https://github.com/golang/go/wiki/Modules#is-it-possible-to-add-a-module-to-a-multi-module-repository.