Andrea Canciani
Andrea Canciani
#28225 might be related
@akarboush I can reproduce the issue on SqlServer, but on Sqlite I hit a different exception when running your code: ``` System.InvalidOperationException: Translating this query requires the SQL APPLY operation,...
Am I correct in the assumption that `VisitChildren` and `Update` do not need to recompute the type mapping?
If that assumption holds true, it should be fairly straightforward to split the "simple optimizations" (constant folding & similar) out of the `SqlExpressionFactory` and still get useable expressions. Basically my...
Some other things to consider: - we should be careful about NULL behavior (the transformation is always safe if we do it after the nullability semantics transformation; otherwise it requires...
> > we should be careful about NULL behavior (the transformation is always safe if we do it after the nullability semantics transformation; otherwise it requires handling the NULL case)...
> Following an internal conversation, the following shows that SQL Server doesn't automatically > > [...] > > In other words, on PostgreSQL, IN isn't executed in the same way...
> I think you have that backwards. `a IN (b, NULL)` works the same as C#, because it compiles out to `a = b OR a = NULL` which then...
> So for example, if you have `!(a == b && a == c)` and `b` is nullable (regardless of `a` nullable or not), then you can't do `WHERE NOT...
> Coming back to this after a while... > > We've recently been focusing a bit on reducing duplication of expressions in our generated SQL, especially around null semantics. For...