malloy

malloy copied to clipboard

Cannot use join from other source in on statement

3

Repro: ```malloy source: doubles is duckdb.sql(""" SELECT base."generate_series" * 2 as n FROM generate_series(1, 10) as base """) source: nums is duckdb.sql(""" SELECT base."generate_series" as n FROM generate_series(1, 10) as...

christopherswenson

Postgres connections do not error on non existent tables

3

``` run: bigquery.table('nosuchproject.nosuchrable')-> {select: *} run: postgres.table('nosuchschem.nosuchtable')-> {select: *} ``` The bigquery version of this errors, the postgres version is silent but deadly

mtoy-googly-moogly

this is a code debt problem waiting to happen, whatever problem this is solving, this is not the correct solutions.

mtoy-googly-moogly

In the first query, we dont' see the column names for the pivots and we should. The unique thing here is that the pivots are all measures so it really...

lloydtabb

Malloy does not recognize postgres array and composite types

4

### What happens? I attempted to read Postgres arrays and composite types as descried in this doc: https://malloydata.github.io/documentation/patterns/reading_nested However, it seems Malloy does not recognize nested data (arrays and composite...

kylenesbit

Sources with only complex columns generate internal error

1

### What happens? If you have a source that only has columns that are non-scalar, like ``` source: ary is duckdb.sql("SELECT [1,2,3] AS a") ``` you get the message: `undefined...

whscullin

This test is implemented by creating a schema and a table with mixed case, and then running some queries against that table in Malloy to make sure that the generated...

mtoy-googly-moogly

If you name a table in a query that exists but you do not have read access to, what should happen is you get an error when the schema is...

mtoy-googly-moogly

There is some cruft here, if we don't care, delete the file, if we do care, fix the tests.

mtoy-googly-moogly

Found this test for an experimental feature we need to kill. ```TypeScript it('group by join - simple group by', async () => { await expect(` run: aircraft->{ group_by: aircraft_models aggregate:...

mtoy-googly-moogly