wyxxxcat opened a new pull request, #51907:
URL: https://github.com/apache/doris/pull/51907
reproduce: backup and restore Table or restart fe, then insert
master branch mv because of nereids problem
before:
```
desc tbl all
*************************** 26. row ***************************
IndexName: idx
IndexKeysType: AGG_KEYS
Field: mv_date_format(hours_add(happen_time, 1), '%Y-%m-%d %H:00:00')
Type: varchar(65533)
InternalType: varchar(65533)
Null: Yes
Key: true
Default: NULL
Extra:
Visible: true
DefineExpr:
WhereClause:
insert into wrong
[ANALYSIS_ERROR]TStatus: errCode = 2, detailMessage = column has no source
field, column=mva_SUM__CASE WHEN 1 IS NULL THEN 0 ELSE 1 END
```
now
```
desc tbl all
*************************** 26. row ***************************
IndexName: idx
IndexKeysType: AGG_KEYS
Field: mv_date_format(hours_add(happen_time, 1), '%Y-%m-%d %H:00:00')
Type: varchar(65533)
InternalType: varchar(65533)
Null: Yes
Key: true
Default: NULL
Extra:
Visible: true
DefineExpr: date_format(hours_add(`happen_time`, 1), '%Y-%m-%d %H:00:00')
WhereClause: (`k1` > '2025-06-12 00:00:00')
insert into ok
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
