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

Error when creating trigger from SQL editor #3445

Open
JustCameToHelp opened this Issue Oct 28, 2018 · 1 comment

Comments

2 participants
@JustCameToHelp

JustCameToHelp commented Oct 28, 2018

Details

When creating a trigger in SQL editor, SQLiteStudio produces an error:

[11:41:41] Error while executing SQL query on database 'test': incomplete input

Creating trigger with user interface works OK.

Steps to reproduce

CREATE TABLE foo (
  n INTEGER
);

CREATE TRIGGER trig
         AFTER UPDATE
            ON foo
BEGIN
  DELETE FROM foo
        WHERE n > 100;
END;

Note: After running CREATE TRIGGER statement, selected text ends before first semicolon.

Operating system

Ubuntu 16.04.5 LTS

SQLiteStudio version

3.2.1

@pawelsalawa

This comment has been minimized.

Owner

pawelsalawa commented Oct 28, 2018

It's a problem with proper detection of where the CREATE TRIGGER statement ends. If you select manually the whole CREATE TRIGGER until the final END; and then hit execution, it will run fine.

Still, there is an issue with proper detection o whole statement i it's not preselected manually, so this report will be used to track & fix this.

@pawelsalawa pawelsalawa added the bug label Oct 28, 2018

@pawelsalawa pawelsalawa added this to the 3.2.2 milestone Oct 28, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment