Segmentation Fault when interleaving fetchmany and fetchone calls

[ffelixg]

Here is a test that crashes the interpreter on my x86 Linux machine:

def test_cursor_rownumber_fetchmany_fetchone_interleave(cursor):
    cursor.execute("select 1 union select 2")
    ((val,),) = cursor.fetchmany(1)
    assert val == 1
    (val,) = cursor.fetchone()
    assert val == 2

Probably the issue has something to do with the fact that fetchmany is fetching data using bound columns but fetchone wants to use SQLGetData.

From a quick analysis it looks like SQLGetData is returning SQL_ERROR, which makes sense if the columns are bound. Then the error value is propagated back to fetchone, which seems to be missing an error check. Because of that fetchone then returns the tuple, but since the function had an error, the value inside the tuple is still a null pointer, which then causes the crash when destructuring with (val,)

[sumitmsft]

Hi @ffelixg Thanks for reaching out. We'll triage and investigate this issue and get back to you. You also mentioned that it crashes, does it throw any error as such which you can share?

[ffelixg]

Sure, this is what I get if I execute the test with pytest. Not very helpful unfortunately, as it is an interpreter crash and not a Python Exception.

malloc_consolidate(): unaligned fastbin chunk detected
Fatal Python error: Aborted