ehddnr301 opened a new pull request, #74552: URL: https://github.com/apache/airflow/pull/74552
Searching the Dag list for `카페` can omit `카페매출집계` on PostgreSQL with libc `en_US.utf8` collation. The code-point-derived upper bound does not follow the database's collation order. Use substring equality for non-ASCII display-name prefixes. ASCII prefixes and other prefix filters retain their existing behavior. Update the API description to document the exception. In a warm-cache benchmark with 20,000 synthetic Dags, the sum of median count and list query times increased by approximately 3–5 ms. This avoids database-specific collation handling. Validation: - Core API/Always and common.compat/FAB tests, with and without DB access. - PostgreSQL 16 regression and API cases: 9 passed. - UI tests: 1,865 passed; SimpleAuth UI: 1 passed. - Generated Python API client tests: 360 passed. - Pre-commit/manual checks and affected documentation builds passed. The remaining shared prefix matcher work is tracked separately. related: #74551 --- ##### Was generative AI tooling used to co-author this PR? <!-- If generative AI tooling has been used in the process of authoring this PR, please change below checkbox to `[X]` followed by the name of the tool, uncomment the "Generated-by". --> - [X] Yes — Codex (GPT-6); Claude assisted with the initial investigation. Generated-by: Codex (GPT-6) following [the guidelines](https://github.com/apache/airflow/blob/main/contributing-docs/05_pull_requests.rst#gen-ai-assisted-contributions) --- * Read the **[Pull Request Guidelines](https://github.com/apache/airflow/blob/main/contributing-docs/05_pull_requests.rst#pull-request-guidelines)** for more information. Note: commit author/co-author name and email in commits become permanently public when merged. * For fundamental code changes, an Airflow Improvement Proposal ([AIP](https://cwiki.apache.org/confluence/display/AIRFLOW/Airflow+Improvement+Proposals)) is needed. * When adding dependency, check compliance with the [ASF 3rd Party License Policy](https://www.apache.org/legal/resolved.html#category-x). * For significant user-facing changes create newsfragment: `{pr_number}.significant.rst`, in [airflow-core/newsfragments](https://github.com/apache/airflow/tree/main/airflow-core/newsfragments). You can add this file in a follow-up commit after the PR is created so you know the PR number. --- Drafted-by: Codex (GPT-6) (no human review before posting) -- 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]
