drawdb-io
[BUG] Cannot import SQL with checks on column level
Describe the bug When Import from SQL is used it fails on importing checks
To Reproduce Steps to reproduce the behavior:
- import the .ddb file
- export as sql as it is
- import the same file again
Expected behavior should import
Screenshots
bug.zip
Desktop (please complete the following information) :
- postgres
- OS: Windows
- Browser Arc Browser (chromium)
Yep the parser seems to fails on checks. Can you please attach the sql file
I added the .zip :)
This isn't supposed to work. The CHECK isn't valid sql that's why the parser is failing as it should.
This isn't supposed to work. The CHECK isn't valid sql that's why the parser is failing as it should.
I think the tooltip is misleading then:
But thanks for the clarification. Greetings!
@drloloto how would you change it
I imported a SQL Script from supabase and probably some internal functions like auth.id() didn't get recognized by drawdb.
I think it would be neat to let the user choose to use drawdb expression check or to just use plain text. Maybe a small checkbox next to the text in my screenshot and one on the import from sql modal with "ignore expression checks" could be a solution.