home / github / issue_comments

Menu
  • GraphQL API

issue_comments: 688499924

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/149#issuecomment-688499924 https://api.github.com/repos/simonw/sqlite-utils/issues/149 688499924 MDEyOklzc3VlQ29tbWVudDY4ODQ5OTkyNA== 9599 2020-09-07T20:25:40Z 2020-09-07T20:25:50Z OWNER https://www.sqlite.org/pragma.html#pragma_recursive_triggers says: > Prior to SQLite [version 3.6.18](https://www.sqlite.org/releaselog/3_6_18.html) (2009-09-11), recursive triggers were not supported. The behavior of SQLite was always as if this pragma was set to OFF. Support for recursive triggers was added in version 3.6.18 but was initially turned OFF by default, for compatibility. Recursive triggers may be turned on by default in future versions of SQLite. So I think the fix is to turn on `recursive_triggers` globally by default for `sqlite-utils`. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} 695319258  
Powered by Datasette · Queries took 0.773ms