message: Duckdb messing my result order
diff: @@ -3,11 +3,9 @@ import pandas as pd
  import numpy
  import pytest
  -def check_result_list(category,res):
  - print (category)
  - print (res)
  - for i in range (len(category)):
  - assert category[i][0] == res[i]
  +def check_result_list(res):
  + for i in range (len(res)):
  + assert res[i][1] == res[i][0]
  def check_create_table(category):
  conn = duckdb.connect()
  @@ -15,7 +13,8 @@ def check_create_table(category):
  conn.execute ("PRAGMA enable_verification")
  df_in = pd.DataFrame({
  'x': pd.Categorical(category, ordered=True),
  - 'y': pd.Categorical(category, ordered=True)
  + 'y': pd.Categorical(category, ordered=True),
  + 'z': category
  })
  df_out = duckdb.query_df(df_in, "data", "SELECT * FROM data").df()
  @@ -25,11 +24,11 @@ def check_create_table(category):
  conn.execute("CREATE TABLE t2 AS SELECT * FROM df_in")
  # Check fetchall
  - res = conn.execute("SELECT t1.x FROM t1").fetchall()
  - check_result_list(res,category)
  + res = conn.execute("SELECT x,z FROM t1").fetchall()
  + check_result_list(res)
  # Do a insert to trigger string -> cat
  - conn.execute("INSERT INTO t1 VALUES ('2','2')")
  + conn.execute("INSERT INTO t1 VALUES ('2','2','2')")
  res = conn.execute("SELECT x FROM t1 where x = '1'").fetchall()
  assert res == [('1',)]
  