Inconsistent Results with JSON_UNQUOTE Between Table and View

Description:

When querying data involving JSON_UNQUOTE in a SELECT statement, there is inconsistent behavior between queries executed on a table created via CREATE TABLE AS SELECT and a view created using the same query logic. Specifically, the number of rows returned differs when applying the same WHERE clause on the table and view.

How to repeat:

1.Create t0 and insert data:

2.Create t1 as a table and query it:

3.Create t1 as a view instead and query it:

Expected Result:

The results of the queries on t1 (table) and t1 (view) should be identical, as they are based on the same data and query logic.

Actual Result:

• The query on t1 (table) returns 2 rows.

• The query on t1 (view) returns 3 rows.