[Bug] Failed to update savepoint status

[succw]

Search before asking

• I had searched in the issues and found no similar issues.

Java Version

1.8.

Scala Version

2.11.x

StreamPark Version

2.1.1

Flink Version

1.17.1

deploy mode

None

What happened

From version 2.1.1 to 2.1.5 update

Error Exception

### The error may exist in class path resource [mapper/core/SavepointMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: update t_flink_savepoint         set latest = 0         where app_id = ?
### Cause: org.postgresql.util.PSQLException: ERROR: column "latest" is of type boolean but expression is of type integer
  Hint: You will need to rewrite or cast the expression.
  Position: 47
]

---

UPDATE t_flink_savepoint
SET latest = CAST(0 AS BOOLEAN)  -- Explicitly cast 0 to BOOLEAN
WHERE app_id = ?;

Screenshots

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!(您是否要贡献这个PR?)

Code of Conduct

• I agree to follow this project's Code of Conduct