Repository Issue Activity (beta)

#186 Materializing an `EXISTS` input changes a `RIGHT JOIN` result

#185 Materializing a computed derived column changes a false `HAVING` result

#184 Materializing a shared `UNION` CTE changes a scalar `ORDER BY ... LIMIT` result

#181 `SECOND()` returns the year component for a `DATE` value produced by a scalar subquery

#183 AliSQL loses the `IN` equality condition after merging a derived subquery

#182 Temporal extraction evaluates a scalar expression from an empty merged derived table

#173 AliSQL: INTERSECT and EXCEPT do not fold provably empty branches

#174 AliSQL: redundant IS NOT NULL after BETWEEN recomputes an expensive expression

#175 AliSQL: double negation changes the result of ALL and ANY quantified comparisons

#172 AliSQL: adding OR FALSE evaluates an expensive subquery despite an impossible HAVING clause

#171 AliSQL: duplicating an equivalent EXISTS predicate causes a 424x slowdown

#170 Deployment Architecture Issues

#163 Grouped `BIT` bytes change inside `UNION ALL` after projection-only view materialization.

#164 Grouped `BIT` bytes change when consumed by `GROUP_CONCAT` after view materialization.

#162 Grouped aggregate output changes from `NULL` to a numeric value after view materialization.

#161 Zero-time aggregate output turns into current-date midnight after view materialization.

#160 One grouped `DISTINCT` row is dropped after projection-only view materialization

#159 One joined row losses after right-side projection view materialization in a self-join

#158 AliSQL flips grouped `HAVING MIN(SET)` results after projection-only view materialization

#157 Corrupt database file

#153 以后会不会考虑数据自动归档和归档数据自动加载功能

#156 VECTOR INDEX with M=200 returns farthest candidates on 1D monotonic vectors

#155 不会又是一场声势浩大的面子工程吧？

#152 Potential memory leak in hlindex_open when open_table_from_share fails

#154 AliSQL 8.4.7 版本有计划开源吗