Row with values from previous row

Hello,

I have a table with few thousands entries which could be represented with these few lines:
```
ID;Column1;Column2;Column3
1;"line1";"CompanyA";""
2;"line2";"CompanyA";"someText"
3;"line3";"CompanyA";""
```

I am using the HFSQL driver to retrieve information from a database with the same name.

By executing the following code, I got wrong information:

```
sql_request = 'SELECT id, Column1, Column2, Column3 FROM TABLE WHERE Column2 in ('CompanyA') LIMIT 400'
await cursor.execute(sql_request)
rows = []
while row := await cursor.fetchone():
rows.append(self.obj_helper(row))
await cursor.close()
return rows
```

Result:
1;"line1";"CompanyA"; ""
2;"line2";"CompanyA";"someText"
3;"line3";"CompanyA"**;"someText"**

Where can I dig to understand why, after a line with a correct string, a row without value for one of its column takes the previous entry ?
Thank you,
R