jbsmith7741 opened a new pull request, #8766: URL: https://github.com/apache/incubator-devlake/pull/8766
### Summary Fixes a MySQL error that causes every incremental CircleCI sync to fail after the first successful run. Closes #8497. Both `workflow_collector.go` and `job_collector.go` build a `WHERE created_date > ?` clause when `isIncremental = true`, but the actual column in `_tool_circleci_workflows` is `created_at` (derived from the Go struct field `CircleciWorkflow.CreatedAt`). The first sync always succeeds because the `WHERE` clause is skipped entirely on a fresh run — the bug only surfaces on every subsequent incremental run. Fix: change the two `WHERE` clause strings from `created_date` to `created_at` to match the actual schema. No model changes, no migration scripts, and no other files are touched. ### Does this close any open issues? Closes #8497 ### Screenshots NA ### Other Information alternative solution would be to rename the column to create_date which would require a DB migration script and changes through the code. If desired I can switch to that solution, but this was the simplest fix with the less amount of code changes. -- 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]
