Alexander Alexandrov comments

Results 55 comments of


                                            Alexander Alexandrov

stack exhaustion in mz_transform::Optimizer::optimize with nested unions

Assigning to @ggevay for initial investigation.

stack exhaustion in mz_transform::Optimizer::optimize with nested unions

I'll close this issue because it relates to a specific incident that came from a bug triaging process. I'll create a seprate issue if we don't have one for making...

Likely mis-optimization in `SELECT` subquery

In postgres the same result returns: ``` alexander> create table test1 (a int, b int); create table test2 (a int, b int); create view test3 as select a, b, count(*)...

Likely mis-optimization in `SELECT` subquery

Yeah I mean is this an issue for a query which is ill-defined either way. Looking at the definition ```sql select a, b, ( select c from test3 where a...

Likely mis-optimization in `SELECT` subquery

Got it.

Likely mis-optimization in `SELECT` subquery

```sql select a, b, ( select c from test3) from test1; ``` produces the expected error, whereas ```sql select a, b, ( select c from test3 where a = a...

Likely mis-optimization in `SELECT` subquery

Looks like an optimization bug, the decorrelated plans for the two queries are similar, but the optimized plans are different. Assigning to myself and I will find somebody to look...

Likely mis-optimization in `SELECT` subquery

We can simplify and look just at: ```sql select ( select c from test3 where a = a and b = b ); ``` vs ```sql select ( select c...

Likely mis-optimization in `SELECT` subquery

Assigning this to @ggevay. Please take a look at that after you have opened a PR for the `IN` list planning.

Linear road benchmark

We can coordinate this with the [the BDAPRO project](https://github.com/TU-Berlin-DIMA/BDAPRO.SS16/issues/6).