Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The table editing doesn't support expression default values #1935

Open
tomatofrommars opened this issue Dec 12, 2023 · 1 comment
Open

The table editing doesn't support expression default values #1935

tomatofrommars opened this issue Dec 12, 2023 · 1 comment
Labels
Bug Something isn't working Low priority Lower priority items PR Welcome Issues and fixes available for wide community to help us move forward by creating a PR with solution

Comments

@tomatofrommars
Copy link

  • Sequel Ace Version (including build number): Version 4.0.13 Build 20062
  • Sequel Ace Source (App Store/GitHub/Homebrew): Homebrew
  • macOS Version: 13.6.1 (22G313)
  • Processor Type (Intel/Apple): Intel
  • MySQL Version: 8.0.31
  • macOS Localization: Chinese

Is Issue Present in Latest Beta? Yes

Description
A table with expression default values (for example (JSON_OBJECT())) cannot be inserted by the TABLE EDITOR.

CREATE TABLE IF NOT EXISTS `test__entity_with_json`
( 
`id` BIGINT NOT NULL PRIMARY KEY, 
`alias` JSON NULL DEFAULT (JSON_OBJECT())
) ;

企业微信截图_7908c19a-b070-4b80-afaa-8574ecdde2ff

Steps To Reproduce

  1. Create Table
CREATE TABLE IF NOT EXISTS `test__entity_with_json`
( 
`id` BIGINT NOT NULL PRIMARY KEY, 
`alias` JSON NULL DEFAULT (JSON_OBJECT())
) ;
  1. Select the table and insert values via TABLE EDITOR
    企业微信截图_44976d5a-8c86-48b8-aea1-461513f5c191
  2. Hit enter and the error shows.

Expected Behaviour
企业微信截图_2fbb3d77-696d-44c5-9774-cbf274d73787

Related Issues

Additional Context

@Jason-Morcos Jason-Morcos added Bug Something isn't working PR Welcome Issues and fixes available for wide community to help us move forward by creating a PR with solution Low priority Lower priority items labels Dec 12, 2023
@Jason-Morcos
Copy link
Member

Funky funky, you're welcome to take a stab at fixing this issue and submitting a pull request! I'd be happy to review any PR that comes in.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Something isn't working Low priority Lower priority items PR Welcome Issues and fixes available for wide community to help us move forward by creating a PR with solution
Projects
None yet
Development

No branches or pull requests

2 participants