Full text search failing update with counts

[comebackoneyear]

I'm using the latest 1.5.25 version and I get the following error with this setup:

CREATE TABLE T (
  Id STRING(20),
  Text STRING(MAX),
  Text_Tokens TOKENLIST AS (TOKENIZE_FULLTEXT(Text)) HIDDEN,
) PRIMARY KEY(Id);


CREATE TABLE C (
  Id STRING(20),
  count INT64
) PRIMARY KEY(Id);

INSERT INTO T (id, text) VALUES ('1', 'Hello, World!');

INSERT INTO C (id, count) VALUES ('1',0);

The following statement

UPDATE C set count=(SELECT count(*) from T) WHERE id='1';

errors with

ERROR: spanner: code = "Internal", desc = "ZETASQL_RET_CHECK failure (external/com_google_zetasql/zetasql/analyzer/resolver_dml.cc:2348) column_index >= 0 (-1 vs. 0) "`

[silas]

Similar issues: #171, #146