v1.5.17

Bug Fixes

• Fixes the error INTERNAL: ZETASQL_RET_CHECK failure (backend/query/query_engine.cc:521) insert_statement->insert_mode() == zetasql::ResolvedInsertStmt::OR_IGNORE for insertS that use a SELECT statement that returns zero rows.
• Fix commit timestamp handling in DML (fixes #25)

New Feature

• Adding JSONB array extraction functions to pg and emulator.
• Add emulator support for NULLS LAST and NULLS FIRST in queries that implement a postgres function as a SQL rewrite.

v1.5.16

New Features

• Added JSON extraction functions
• Upgrade ZetaSQL dependency to 2023.11.1.
• The maximum permitted number of non-nested subqueries in a SELECT list is increased from 25 to 500.

v1.5.15

Bug Fixes

*   ALTER DATABASE ddl not supported (https://github.com/GoogleCloudPlatform/cloud-spanner-emulator/issues/27)
*   Include varchar limit for varchar types in the spanner\type column of information_schema.columns and information_schema.index_columns tables.
*   Fix foreign key transaction restriction for the transaction with multiple flush.
*   Fix foreign key action effector for unordered referencing FK.

New Feature

*   Support proto and enum types in cloud spanner emulator\.
*   Enable support for JSON converter functions and LAX converters in cloud spanner emulator\
*   Support ALTER DATABASE DDL as a no-op
*   Support Sequence in PostgreSQL.
*   Return unsupported error for upsert queries
*   Add builtin PostgreSQL TVFs
*   Enable Foreign Key Delete Cascade Action.
*   Adding ML_PREDICT_ROW function
*   Enable INSERT OR IGNORE and INSERT OR UPDATE
*   Adding ML.PREDICT function.
*   Support Directed Reads feature

Dependencies

*   upgrade distroless docker build
*   upgrade go language dependency

v1.5.14

Bug Fixes

• ALTER DATABASE ddl not supported (#27)

New Feature

• upgrade distroless docker build
• Support ALTER DATABASE DDL no-op on Cloud Spanner Emulator.
• Fix foreign key transaction restriction for the transaction with multiple flush.
• Support Sequence in PostgreSQL.
• Return unsupported error for upsert queries in Emulator
• Support ALTER DATABASE DDL no-op on Cloud Spanner Emulator.
• Support constant-value batch queries like SELECT 1, which are now supported by Cloud Spanner
• upgrade go language dependency
• Add builtin PostgreSQL TVFs to the Spanner Emulator

v1.5.13

Bug Fixes

• Allow tables with TTL to be deleted.
• Fixing issue reported in b/306031803

New Feature

• Add change stream merge / split churning support.

• upgrade go language dependancy

• upgrade zetasql dependency to 2023.10.1.

• upgrade go language dependancy

• Synchronize backend and emulator parsers.

• Add PostgreSQL dialect support to the Cloud Spanner Emulator

• Allow PLAN query mode and return query parameter types

• Adding emulator support for DROP VIEW IF EXISTS

• Adding emulator support for change streams in PG dialect.

• Add MODEL DDL support.

• Add support for index_strategy hint and allow push_broadcast_hash_join as a value for join_method.

• Add MODEL schema.

• Upgrade ZetaSQL dependency to 2023.11.1.

• Add ML.PREDICT function to the catalog.

• Allow `ON DELETE NO ACTION` foreign key action

• Transaction restriction for the table with Foreign Key DELETE CASCADE action.

• Add Model INFORMATION SCHEMA.

• Add support for PostgreSQL interface arrays unnest, array_length, array() function for creating an array from a subquery, and count() for columns of array type.

• Fix transaction restriction for the table with Foreign Key DELETE CASCADE action.

• Enable COSINE_DISTANCE() and EUCLIDEAN_DISTANCE() functions in the Emulator

• Support Sequence in GoogleSQL.

• Support ALTER INDEX ADD|DROP STORED COLUMN.

• upgrade go language dependency

• update docker to use python3.8

Significant Changes

• Enable support for GENERATE_UUID()
• Generated columns can now be used as primary keys.

v1.5.12

Bug Fixes

• Allow tables with TTL to be deleted.

New Feature

• Added support for PostgreSQL dialect.
• Add change stream merge / split churning support.
• Allow PLAN query mode and return query parameter types
• Enable support for GENERATE_UUID()
• Generated columns can now be used as primary keys.

Significant Changes

• Added support for PostgreSQL dialect.

v1.5.11

New Features

• upgrade portpicker dependancy

• upgrade go language dependancy

• autoformat WORKSPACE and auto update dependancies using gazelle

• Adds support for foreign key delete cascade action to the Cloud emulator schema

• Added Foreign Key DELETE CASCADE action effector

• Add passing and parsing failure test cases to the change streams DDL conformance tests

• Add support for SUPPORTED_OPTIMIZER_VERSIONS with dummy data in emulator

v1.5.10

New Features

• upgrade zetasql dependency
• autoformat WORKSPACE and auto update dependancies using gazelle

v1.5.9

New Features

• Change streams v1 on Emulator

• Added ON DELETE CASCADE action for foreign key to the Cloud Emulator parser

• use baselisk to automatically install the required version of bazel

• Create the TABLES and COLUMN_COLUMN_USAGE information schema tables using metadata

• Create the COLUMNS and VIEWS information schema tables using metadata

v1.5.8

New Features

• upgrade zetasql dependency

• Upgrading googleapis bazel dependency version

• upgrade bazel and zetasql dependency

• Upgrading the google_cloud_cpp version to 2.12.0

• Upgrade JavaCC 6 to 7 for DDL parser.

• Enable overriding the emulator function catalog name.
  HasDefaultValue(),Expression() & ExpressionKind() APIs have been deprecated. Overriden GetExpression() API instead (to be used for default expression evaluations).

• Create an initial subset of the information schema tables using metadata.