matrixorigin / matrixorigin/matrixone

[Bug]: show snapshots / show pitr column names changed case between main and 3.0-dev branches

Open
#24,392 0 comments 0 reactions 1 assignee Claimed by @gouhongshen View on GitHub
ai-light kind/bug
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

### Is there an existing issue for the same bug?

- [x] I have checked the existing issues.

### Branch Name

main

### Commit ID

21a86006f838e9401ff046449c91ebcb5e0d7001

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

## Problem Description

The column names returned by `SHOW SNAPSHOTS` and `SHOW PITR` commands have different cases between `main` and `3.0-dev` branches, causing compatibility issues and test failures.

## Branch Comparison

### `main` branch (uppercase)
```sql
SHOW SNAPSHOTS;
-- Returns:
-- SNAPSHOT_NAME TIMESTAMP SNAPSHOT_LEVEL ACCOUNT_NAME DATABASE_NAME TABLE_NAME

SHOW PITR;
-- Returns:
-- PITR_NAME CREATED_TIME MODIFIED_TIME PITR_LEVEL ACCOUNT_NAME DATABASE_NAME TABLE_NAME PITR_LENGTH PITR_UNIT

3.0-dev branch (lowercase)
SHOW SNAPSHOTS;
-- Returns:
-- snapshot_name timestamp snapshot_level account_name database_name table_name

SHOW PITR;
-- Returns:
-- pitr_name created_time modified_time pitr_level account_name database_name table_name pitr_length pitr_unit

### Expected Behavior

_No response_

### Steps to Reproduce

```Markdown
SHOW SNAPSHOTS;
SHOW PITR;
```

### Additional information

_No response_

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.