matrixorigin / matrixorigin/matrixone

[Bug]: lower_case_table_names.sql row 129 flaky — lower_case_table_names value mismatch in multi-CN PROXY

Open
#27,265 1 comment 0 reactions 1 assignee Claimed by @jiangxinmeng1 View on GitHub
kind/bug needs-triage
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

## Problem

`lower_case_table_names.sql` row 129 fails in multi-CN PROXY BVT:

```sql
select @@lower_case_table_names;
Expected: 1
Actual: 0
```

The test sets `lower_case_table_names=1` but a different CN in the PROXY cluster returns `0`. This is a multi-CN system variable propagation timing issue — the variable change hasn't propagated to all CNs when the query executes on a different CN.

## Recent Occurrences

| Date | PR/Run | Job |
|---|---|---|
| 2026-08-18 | [PR #27227](https://github.com/matrixorigin/matrixone/actions/runs/32104863887/job/95613494743) | BVT PROXY |

## Suggested Fix

1. Add `SET GLOBAL lower_case_table_names = 1` with explicit wait/sync before querying
2. Or use `-- @retry` or `-- @ignore` directives for multi-CN variable propagation timing
3. Or increase variable propagation timeout in PROXY environment

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.