Andrea Canciani
Andrea Canciani
> See a somewhat similar problem with SQL Server's COALESCE, in #32519. > > Yeah, we traditionally haven't given enough thought when duplicating SQL expressions in translation; in addition to...
> Yeah, we traditionally haven't given enough thought when duplicating SQL expressions in translation; in addition to the problem of impure functions, expression duplication can create serious performance issues as...
> @ranma42 yes, this is true. The general issue is that EF has no knowledge of which functions (or more generally, nodes) are pure/stable; and this sort of optimization can...
This is a special case of - #19897
@maumar another way to interpret this is that `|` and `&` distribute over each other: - (x | y) & z = (x & z) | (y & z) -...
Yes, this should already be optimized by https://github.com/dotnet/efcore/blob/ecd6104d7db803a976116a49d5855bce85634051/src/EFCore.Relational/Query/SqlNullabilityProcessor.cs#L525-L532 EDIT: clauses whose test is `NULL` instead of `FALSE` are currently left in; I'm working on it.
Modern versions of SQLite have the [standard SQL syntax](https://www.sqlite.org/lang_expr.html) (i.e. `IS [NOT] DISTINCT FROM`) in addition to the `IS` operator that is also available on older ones. According to the...
> @ranma42 I may be missing it, but I can't see mention of index usage specifically for IS DISTINCT FROM in the SQLite docs. I think indexes are not used...
https://github.com/ranma42/efcore/tree/is-not-distinct-from is a WIP branch that explores what happens to the test suite baselines when using `IS` to `RewriteNullSemantics` of `[Not]Equal`. Some care is already taken to avoid regressing good...
https://github.com/angular/angular/issues/23613 is related: basically it covers all of the cases in which a proxy mangles the files, not just the mangling performed by the vite dev server. IIUC the conclusion...