Pomelo.EntityFrameworkCore.MySql

Pomelo.EntityFrameworkCore.MySql copied to clipboard

Getting different SQL output for the same LINQ Query since upgrading to .NET 8

2

### The issue The problem i am facing since .NET 8.0 and Pomelo 8.0 is that the same LINQ query outputs different SQL. The latest SQL output is a query...

robherman

MySQL operations break after InvalidOperationException: Can't Replace Active Reader

2

### Steps to reproduce We are using .NET 8 and DI in our project. We have several categorized classes that create a new scope from the IServiceScopeFactory in order to...

adanvdo

Input string was not in a correct format when compare with TimeSpan

1

### Steps to reproduce The model: ```cs class Table { public int Id { get; set; } public DateTimeOffset Time { get; set; } } ``` ```cs await dbContext.Table.Where(i =>...

hez2010

After upgrading from 7.0.0 to 8.0.2, SQL translation results are changed and this version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'.

9

### Steps to reproduce After updating Pomelo.EntityFrameworkCore.MySql from 7.0.0 to 8.0.2, the following code now exits abnormally The reason is that the SQL that used to use the EXISTS clause...

karuakun

Replace JSON_EXTRACT utilisation with JSON_VALUE

8

### Steps to reproduce Run the custom project to see it crashing [PomeloBugJsonExtract.zip](https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/files/14668199/PomeloBugJsonExtract.zip) ### The issue In some places, in the code, `JSON_EXTRACT` is used for getting value of a...

Angelinsky7

We will use `JSON_VALUE()` for scalar JSON values from now on, because it seems to handle `null` values correctly. `JSON_EXTRACT()` will return a **string** with the contents of `null` for...

lauxjpn

ServerVersion.AutoDetect(connectionString) fails

9

### Steps to reproduce Ideally include a complete code listing that we can run to reproduce the issue. Alternatively, you can provide a project/solution that we can run. ### The...

pantonis

Change return type of all `EF.Functions.DateDiff` extension methods related to units of `SECOND` or smaller from `int` to `long`

4

The value returned for `TIMESTAMPDIFF` function calls of valid dates can exceed `Int32.MaxValue`, but currently, all our `EF.Functions.DateDiff` extension methods use `int` as the return type. We should change this...

lauxjpn

References: - [13.2.2 The DATE, DATETIME, and TIMESTAMP Types](https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html#function_cast) - [CAST(timestamp_value AT TIME ZONE timezone_specifier AS DATETIME[(precision)])](https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html#function_cast) There currently seems to be no such support in MariaDB. Probably similar to...

lauxjpn

Custom value conversion fails for byte[] property to GEOMETRY SQL column.

2

### Steps to reproduce The following code below sets up EF model configuration for a CLR property to GEOMETRY sql type with a custom converter but in Pomelo.EntityFrameworkCore.MySql.NetTopologySuite v8.0.1 onwards,...

anasgauba