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

Triggers disapper when modify fields of a SQLite table #523

Closed
alikia2x opened this issue Jan 25, 2023 · 1 comment
Closed

Triggers disapper when modify fields of a SQLite table #523

alikia2x opened this issue Jan 25, 2023 · 1 comment
Assignees
Labels
bug 🪲 Something isn't working SQLite 🪶

Comments

@alikia2x
Copy link

alikia2x commented Jan 25, 2023

Describe the bug
Triggers disappear when modifying the fields of a SQLite table

To Reproduce
Steps to reproduce the behavior:

  1. Open a SQLite DB.
  2. Right click on a table, then click Settings.
  3. Modify the fields, like changing the data type or default value of a column.
  4. Save the changes.
  5. And the triggers you added will disappear~

Screenshots

  1. Modify something
    1
  2. Save changes
    2
  3. Triggers gone
    3

Application

Antares 0.7.2

Environment

  • OS name: Windows11
  • OS version 22H2
  • DB name SQLite
  • DB version 3.40.0

Possible Reason
I learned how this App modify fields by looking at the console. I noticed that you modified the fields by creating a new table and importing the original data. But you've forgot the trigger in the original table.

@Fabio286 Fabio286 added the bug 🪲 Something isn't working label Jan 25, 2023
@Fabio286 Fabio286 added this to TO FIX Jan 25, 2023
@github-project-automation github-project-automation bot moved this to Needs triage in TO FIX Jan 25, 2023
@Fabio286 Fabio286 moved this from Needs triage to High priority in TO FIX Jan 25, 2023
@github-project-automation github-project-automation bot moved this from High priority to Closed in TO FIX Feb 4, 2023
@Fabio286
Copy link
Member

Fabio286 commented Feb 4, 2023

Fixed!
Thanks for your report.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug 🪲 Something isn't working SQLite 🪶
Projects
No open projects
Status: Closed
Development

No branches or pull requests

2 participants