jongleb

Try rewrite

1

fx version

Improve Coalesce Function for Proper Type Inference

1

This pull request enhances the coalesce function to provide accurate type inference. Previously, coalesce didn't behave as expected, but with this update, it correctly outputs a not null type if...

### Description This pull request addresses an issue in join operations where column types displayed for requested columns are overridden by types from the tables, leading to inaccuracies. Specifically, in...

## Change: Default to NULL for Fields without explicit NOT NULL ### Description This change ensures that fields without explicit NOT NULL are defaulted to NULL. ### Details - Fields...

This PR adds two tests to ensure proper handling of NULL values by the COALESCE function in various scenarios. - COALESCE correctly handles first not nullable argument. - COALESCE does...

Add JOIN statement tests

2

#### These test shows required improvements to make JOINS work properly. When dealing with a LEFT JOIN, nullability arises under the following scenarios: 1. **No Foreign Key:** - If there...

Please support to check if functions are called from the other. Let me show an example. Let me show an example. This is the code I need to check. I...

This PR updates the code to throw an error during insert operations if NOT NULL fields without default values are missing.

This PR makes gen to consider the inferred nullability of types of tuple elements