[Improvement] PostgreSQL serial column not supported
- Dominant language
- Java
- Stars
- 3.2k
- Forks
- 935
- Avg merge
- 1d 15h
- Merged PRs (30d)
- 315
Description
### Version
main branch
### Describe what's wrong
If you try to view a PostgreSQL table with a serial type the Gravitino UI gives an error.
### Error message and/or stacktrace
UI give this error:
"Unknown data type for literal: JdbcTypeBean{typeName='serial', columnSize='10', scale='0'}"
### How to reproduce
Using the lastest playground, create a table and view in the UI.
```SQL
create table hr.new_departments (
department_id serial NOT NULL,
department_name varchar(100) NULL
);
```
### Additional context
_No response_
Contributor guide
Research direction
Start by reproducing the issue in the latest playground using the provided CREATE TABLE statement, then trace the UI path that displays the PostgreSQL table and reports the unknown serial type. Done means a table with a serial column can be viewed in the UI without the reported data-type error; no specific source file or test is named in the issue.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, postgresql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100