njnu-seafish opened a new pull request, #18444: URL: https://github.com/apache/dolphinscheduler/pull/18444
<!--Thanks very much for contributing to Apache DolphinScheduler, we are happy that you want to help us improve DolphinScheduler! --> ## Was this PR generated or assisted by AI? YES. Leverage LLMs to verify that the removed large text fields are indeed unused. ## Purpose of the pull request close #18443 ## Brief change log The WorkflowInstanceMapper was returning all fields including large text/longtext fields (command_param, global_params, history_cmd, var_pool, state_history) for all queries,which caused unnecessary database I/O, network transfer, and memory usage. This commit adds a dedicated listSql SQL fragment that excludes these large fields, and updates the following list query methods to use them: - queryByHostAndStatus - queryTopNWorkflowInstance - queryByTenantCodeAndStatus - queryByWorkerGroupNameAndStatus - queryWorkflowInstanceListPaging - queryByWorkflowDefinitionCode - queryLastSchedulerWorkflow - queryLastManualWorkflow - queryLastRunningWorkflow - queryFirstScheduleWorkflowInstance - queryFirstStartWorkflowInstance - queryByWorkflowDefinitionCodeAndStatus - queryByWorkflowCodeVersionStatus - queryWorkflowInstanceListV2Paging - queryByTriggerCode ## Verify this pull request <!--*(Please pick either of the following options)*--> This pull request is code cleanup without any test coverage. *(or)* This pull request is already covered by existing tests, such as *(please describe tests)*. (or) This change added tests and can be verified as follows: <!--*(example:)* - *Added dolphinscheduler-dao tests for end-to-end.* - *Added CronUtilsTest to verify the change.* - *Manually verified the change by testing locally.* --> (or) ## Pull Request Notice [Pull Request Notice](https://github.com/apache/dolphinscheduler/blob/dev/docs/docs/en/contribute/join/pull-request.md) If your pull request contains incompatible change, you should also add it to `docs/docs/en/guide/upgrade/incompatible.md` -- 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]
