home / github / issue_comments

Menu
  • Search all tables
  • 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 (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 1.134ms · About: github-to-sqlite