Wrong query results using Jupyter

[wwasilak]

What happens?

In the Collab Notebook, below query returns wrong values.

Link to notebook (official one, from Malloy Docs): https://colab.research.google.com/drive/1eo1fe3878DfUvo1RcyhFUKcFhjdaSlzp?usp=sharing

Query:

%%malloy_query flights run: flights -> { aggregate: max_date is max(dep_time::date) min_date is min(dep_time::date)

}

Generated sql doesn't contain any errors.

To Reproduce

Use notebook from documentation and check query from issue description.

OS:

Google Colab

Malloy Client:

Jupyter Notebooks

Malloy Client Version:

N/A

Database Connection:

DuckDB

[gmaden]

Looks like this is an issue with how renderer is handling timestamps. Since this is using an out of date version of renderer probably first steps needs to be updating Malloy versions.