Test on qualify_columns seems failing?

[10bas10]

Hey guys,

I was about to prepare a pull request. However when I run the tests without any changes done yet im getting the following error:

ERROR: test_qualify_columns (test_optimizer.TestOptimizer) [(execute) 97, SELECT x.a, i.b FROM x CROSS JOIN UNNEST(SPLIT(b, ',')) AS i(b)]
----------------------------------------------------------------------
Traceback (most recent call last):
  File "C:\Users\USEFRA\source\repos\sqlglot-current\sqlglot\tests\test_optimizer.py", line 136, in check_file
    df1 = self.conn.execute(
duckdb.BinderException: Binder Error: Referenced column "b" not found in FROM clause!

Anybody got an idea how that can be?

[tobymao]

Do you have the latest sqlglot code?

[10bas10]

I did grab the latest version, not sure why it fails on my part only because the build isnt failing in github.

[georgesittas]

Maybe the problem is related to the DuckDB version you're using locally?