sqlite3 reports parsing issues under free-threaded Python 3.13.2

[andfoy]

Bug report

Bug description:

The following set of sqlite instructions fail under free-threaded CPython 3.13.2t, whereas they are passing under standard 3.13.2

import sqlite3
conn = sqlite3.connect(":memory")
cursor = conn.cursor()
cursor.execute("""CREATE TABLE test3 (
                 s VARCHAR,
                 x INTEGER GENERATED ALWAYS AS (INSTR(s, ","))
             );""")

Traceback:

Traceback (most recent call last):
  File "<python-input-3>", line 1, in <module>
    cursor.execute("""CREATE TABLE test3 (
    ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^
                    s VARCHAR,
                    ^^^^^^^^^^
                    x INTEGER GENERATED ALWAYS AS (INSTR(s, ","))
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
                );""")
                ^^^^^^
sqlite3.OperationalError: no such column: "," - should this be a string literal in single-quotes?

Passing interpreter:

Python 3.13.2 | packaged by conda-forge | (main, Feb 17 2025, 14:10:22) [GCC 13.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
... conn = sqlite3.connect(":memory")
... cursor = conn.cursor()
... cursor.execute("""CREATE TABLE test3 (
...                  s VARCHAR,
...                  x INTEGER GENERATED ALWAYS AS (INSTR(s, ","))
...              );""")
... 
<sqlite3.Cursor object at 0x71ef99cc45c0>
>>> 

CPython versions tested on:

3.13

Operating systems tested on:

Linux

[brianschubert]

(note: there appears to be a typo in the conn = sqlite3.connect(":memory") line: ":memory" -> ":memory:")

I can't reproduce this on a fresh build of 3.13.2t:

$ git switch --detach v3.13.2
$ make clean && ./configure --with-pydebug --disable-gil && make -j
$ ./python
Python 3.13.2 experimental free-threading build (tags/v3.13.2:4f8bb3947cf, Apr 10 2025, 15:09:28) [GCC 11.4.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
... conn = sqlite3.connect(":memory:")
... cursor = conn.cursor()
... cursor.execute("""CREATE TABLE test3 (
...                  s VARCHAR,
...                  x INTEGER GENERATED ALWAYS AS (INSTR(s, ","))
...              );""")
...              
<sqlite3.Cursor object at 0x20000d2b2d0>
>>> 

[andfoy]

I can't reproduce the issue in 3.13.3t:

Python 3.13.3 experimental free-threading build | packaged by conda-forge | (main, Apr 10 2025, 22:29:45) [GCC 13.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
... conn = sqlite3.connect(":memory:")
... cursor = conn.cursor()
... cursor.execute("""CREATE TABLE test3 (
...                  s VARCHAR,
...                  x INTEGER GENERATED ALWAYS AS (INSTR(s, ","))
...              );""")
... 
<sqlite3.Cursor object at 0x21086329e80>
>>> 
>>> 

Maybe there was something going on over at conda-forge packaging? Anyways, I'll close this one