Skip to content

Crash when switching to "Browse Data" #2288

@th

Description

@th

Details for the issue

What did you do?

Loaded my project file, which starts me in the Execute SQL view. Clicked on the Brose Data Tab.

I could share the project file (and SQLite database), but don't want to make it publically available on GitHub.

It's an SQLite database with less than 2000 rows. I have added a view that picks out about zero to thirty rows (depending on the current day):

CREATE VIEW eligible as SELECT * FROM entries WHERE date < date('now','-28 months') OR (date < date('now','-6 months') AND (leaveout = 'FALSE')) ORDER BY date ASC

I can query in the Execute SQL tab using SELECT * FROM eligible limit 2; without problems.

I also have two triggers:

CREATE TRIGGER eligible_change_leaveout
INSTEAD OF UPDATE OF leaveout ON eligible
BEGIN
UPDATE submissions SET leaveout=NEW.leaveout
WHERE id=NEW.id;
END

CREATE TRIGGER eligible_change_date
INSTEAD OF UPDATE OF date ON eligible
BEGIN
UPDATE submissions SET date=NEW.date
WHERE id=NEW.id;
END

What did you expect to see?

My data, starting in a view I have added and used previously.

What did you see instead?

The application crashes without any error message.

Useful extra information

The info below often helps, please fill it out if you're able to. :)

What operating system are you using?

  • [X ] Windows: ( version: 10 H2___ )
  • Linux: ( distro: ___ )
  • macOS: ( version: ___ )
  • Other: ___

What is your DB4S version?

  • [X ] 3.12.0-(release)
  • 3.11.2
  • 3.11.1
  • 3.10.1
  • Other: ___

Did you also

Metadata

Metadata

Assignees

Labels

bugConfirmed bugs or reports that are very likely to be bugs.

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions