When names of tables start with same string, _TABLE_SUFFIX expansion may fail

[llofberg]

What happened?

For example when dataset contains tables "event_" and "event_fresh_", the following query may fail.

select * from `db.event_* where _TABLE_SUFFIX between '20240101' and '20240201'

The error message from "bq" command is following:

Exception raised in query operation: Error processing job 'aaa:bbb_1': failed to scan rows: strconv.parseInt: parsing "_fresh_20240101": invalid syntax

What did you expect to happen?

Expected the query to return rows contained in event_* table.

How can we reproduce it (as minimally and precisely as possible)?

Create two tables event_ and event_fresh_, insert data to both (?) run

select * from `db.event_* where _TABLE_SUFFIX between '20240101' and '20240201'

Anything else we need to know?

Command I used in terminal.

bq query --api http://localhost:9050 --project_id test "select * from `db.event_* where _TABLE_SUFFIX between '20240101' and '20240201' limit 10"