issue_comments: 1074337997

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/datasette/issues/1679#issuecomment-1074337997 https://api.github.com/repos/simonw/datasette/issues/1679 1074337997 IC_kwDOBm6k_c5ACRjN 9599 2022-03-21T19:37:08Z 2022-03-21T19:37:08Z OWNER

This is weird: ```python import sqlite3

db = sqlite3.connect(":memory:")

i = 0

def count(): global i i += 1

db.set_progress_handler(count, 1)

db.execute(""" with recursive counter(x) as ( select 0 union select x + 1 from counter ) select * from counter limit 10000; """)

print(i) Outputs `24`. But if you try the same thing in the SQLite console: sqlite> .stats vmstep sqlite> with recursive counter(x) as ( ...> select 0 ...> union ...> select x + 1 from counter ...> ) ...> select * from counter limit 10000; ... VM-steps: 200007 ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1175854982