Function TestTypesNullHandling

tests/integration/types_test.go:251–280

TestTypesNullHandling tests NULL handling across types

(t *testing.T)

	}
	runQueryTests(t, tests)
}

// TestTypesNullHandling tests NULL handling across types
func TestTypesNullHandling(t *testing.T) {
	tests := []QueryTest{
		// NULL comparisons
		{Name: "null_equals", Query: "SELECT NULL = NULL"},
		{Name: "null_is_null", Query: "SELECT NULL IS NULL"},
		{Name: "null_is_not_null", Query: "SELECT NULL IS NOT NULL"},
		{Name: "null_is_distinct_from_null", Query: "SELECT NULL IS DISTINCT FROM NULL"},
		{Name: "null_is_not_distinct_from_null", Query: "SELECT NULL IS NOT DISTINCT FROM NULL"},

		// NULL in expressions
		{Name: "null_arithmetic", Query: "SELECT 1 + NULL"},
		{Name: "null_concat", Query: "SELECT 'hello' || NULL"},
		{Name: "null_and_true", Query: "SELECT NULL AND TRUE"},
		{Name: "null_or_true", Query: "SELECT NULL OR TRUE"},

		// COALESCE
		{Name: "coalesce_null", Query: "SELECT COALESCE(NULL, 'default')"},
		{Name: "coalesce_value", Query: "SELECT COALESCE('value', 'default')"},
		{Name: "coalesce_multiple", Query: "SELECT COALESCE(NULL, NULL, 'third')"},

		// NULLIF
		{Name: "nullif_equal", Query: "SELECT NULLIF(1, 1)"},
		{Name: "nullif_different", Query: "SELECT NULLIF(1, 2)"},

		// From table with NULLs
		{Name: "select_nullable", Query: "SELECT * FROM nullable_test WHERE val1 IS NULL"},
		{Name: "count_nulls", Query: "SELECT COUNT(*), COUNT(val1), COUNT(val2) FROM nullable_test"},
	}
	runQueryTests(t, tests)
}