René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SQLite rowcount is corrupted when combining UPDATE RETURNING w/ id IN (?)","articleBody":"# Bug report\r\n\r\nThe rowcount from an sqlite UPDATE RETURNING query with WHERE id IN (?) used (but not == ?) will be 0.\r\n\r\nThe reproduction case from #93421 runs successfully.  The modified reproduction case below errors with:\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"C:\\Data\\R\\git\\electrumsv\\x.py\", line 41, in \u003cmodule\u003e\r\n    go()\r\n  File \"C:\\Data\\R\\git\\electrumsv\\x.py\", line 35, in go\r\n    assert rowcount == 1, (rowcount, f\"was updated: {updated_value=='v2'}\")\r\nAssertionError: (0, 'was updated: True')\r\n```\r\n\r\nReproduction case.\r\n\r\n```python\r\nimport os\r\nimport sqlite3\r\n\r\n\r\n\r\ndef go():\r\n    # create table\r\n    cursor = conn.cursor()\r\n    cursor.execute(\r\n        \"\"\"CREATE TABLE some_table (\r\n        id INTEGER NOT NULL,\r\n        flags INTEGER NOT NULL,\r\n        value VARCHAR(40) NOT NULL,\r\n        PRIMARY KEY (id)\r\n    )\r\n    \"\"\"\r\n    )\r\n    cursor.close()\r\n    conn.commit()\r\n\r\n    # run operation\r\n    cursor = conn.cursor()\r\n    cursor.execute(\r\n        \"INSERT INTO some_table (id, flags, value) VALUES (1, 4, 'v1')\"\r\n    )\r\n    ident = 1\r\n\r\n    cursor.execute(\r\n        \"UPDATE some_table SET value='v2' \"\r\n        \"WHERE id IN (?) RETURNING id\",\r\n        (ident,),\r\n    )\r\n    rowcount = cursor.rowcount\r\n    updated_value = cursor.execute(\"SELECT value FROM some_table WHERE id=1\").fetchone()[0]\r\n    assert rowcount == 1, (rowcount, f\"was updated: {updated_value=='v2'}\")\r\n\r\nif os.path.exists(\"file.db\"):\r\n    os.unlink(\"file.db\")\r\n\r\nconn = sqlite3.connect(\"file.db\")\r\ngo()\r\n# never reaches here\r\n```\r\n\r\n# Your environment\r\n\r\nThis is the 3.10.9 windows install from python.org on my computer. My coworker installed the version on his Windows computer and could reproduce it as well.\r\n```\r\nPython 3.10.9 (tags/v3.10.9:1dd9be6, Dec  6 2022, 20:01:21) [MSC v.1934 64 bit (AMD64)] on win32\r\n```\r\n\r\nMy coworker has also had it happen on MacOS with 3.10.8\r\n```\r\n3.10.8 (main, Oct 13 2022, 10:17:43) [Clang 14.0.0 (clang-1400.0.29.102)]\r\n```\r\n 3.2 GHz 8-Core Intel Xeon W\n\n\u003c!-- gh-linked-prs --\u003e\n### Linked PRs\n* gh-104287\n* gh-104381\n\u003c!-- /gh-linked-prs --\u003e\n","author":{"url":"https://github.com/rt121212121","@type":"Person","name":"rt121212121"},"datePublished":"2023-01-18T06:33:10.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":8},"url":"https://github.com/101117/cpython/issues/101117"}