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

Create spatialite trigger with DBManager do not work #45420

Closed
2 tasks done
jmarsac opened this issue Oct 5, 2021 · 1 comment · Fixed by #45553
Closed
2 tasks done

Create spatialite trigger with DBManager do not work #45420

jmarsac opened this issue Oct 5, 2021 · 1 comment · Fixed by #45553
Assignees
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin

Comments

@jmarsac
Copy link

jmarsac commented Oct 5, 2021

What is the bug or the crash?

Trigger code is stripped on first "<" encountered

Steps to reproduce the issue

  1. launch DbManager
  2. connect to spatialite database with a table "test"
  3. open SQL Window
  4. keyin following code
CREATE TRIGGER trg_test AFTER UPDATE ON test 
  BEGIN
    SELECT 1 < 2;
  END;
  1. click on "Execute" button
  2. trigger content is truncated
CREATE TRIGGER trg_test AFTER UPDATE ON test 
  BEGIN
    SELECT 1

Versions

QGIS 3.16.10 LTR

Supported QGIS version

  • I'm running a supported QGIS version according to the roadmap.

New profile

  • I tried with a new QGIS profile

Additional context

If you use a ">" instead of "<"

CREATE TRIGGER trg_test2 AFTER UPDATE ON test 
  BEGIN
    SELECT 1 > 2;
  END;

the trigger is not truncated

@jmarsac jmarsac added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Oct 5, 2021
@gioman gioman changed the title Create spatialite trigger with DbManager Create spatialite trigger with DBManager do not work Oct 6, 2021
@gioman gioman added the DB Manager Relating to the DB Manager core plugin label Oct 6, 2021
@elpaso
Copy link
Contributor

elpaso commented Oct 18, 2021

It is just a visualization issue: the trigger is created ok. The < is confusing the widget (probably interpreted as an HTML tag).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants