jakob / jakob/Postico

[BUG] Creating a table name with length greater than 63 characters silently fails

Open
#460 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Try creating a table with a name "cinema_movie_name_movie_name_identification_algorithm_movie_abcdefghijk".

The GUI will report the table as successfully created.

Refresh the GUI and you will find that the actual created table name is: "cinema_movie_name_movie_name_identification_algorithm_movie_abc".

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the issue in the Postico GUI using the table name from the report, then trace the table-creation and refresh handling. Confirm how the reported success is determined and ensure a table name longer than the supported length is not silently changed; verify that the GUI reflects the actual outcome after refresh.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.