Parameter value mixup

I wrote two manual SQL queries with parameters with the same names but with different values like this:

```
var result = await Enumerable
.Range(1, 2)
.Select(index => dbContext
.Set()
.FromSqlRaw(
"SELECT @date AS Date",
new SqlParameter("date", new DateOnly(2024, 1, index))))
.Aggregate(Queryable.Union)
.ToListAsync();

foreach (var line in result)
{
Console.WriteLine(line.Date);
}
```

I expected to get two results with 2024-01-01 and 2024-01-02 but got only the result 2024-01-01.
However, this works as expected:

```
var result = await Enumerable
.Range(1, 2)
.Select(index => dbContext
.Set()
.FromSqlRaw(
"SELECT {0} AS Date",
new DateOnly(2024, 1, index)))
.Aggregate(Queryable.Union)
.ToListAsync();

foreach (var line in result)
{
Console.WriteLine(line.Date);
}
```

I have created an example project showcasing the bug: https://github.com/samuel-utbult-oborgen/ef-core-bug
I suspect this could be because the variable "date" is created for the combined query and its value is set to 2024-01-01 while the value 2024-01-02 is ignored. The parameters should reasonably be isolated between the queries as they are specified for each query respectively.

EF Core version: 8.0.1
Database provider: (e.g. Microsoft.EntityFrameworkCore.SqlServer)
Target framework: (e.g. .NET 8.0)
Operating system: macOS Sonoma 14.2.1