Row with values from previous row

[RomainDGrey]

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