Details
-
Type:
Improvement
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 2.2, 2.3
-
Fix Version/s: None
-
Component/s: Platforms
-
Security Level: All
-
Labels:None
Description
For a query such as
x = CASE WHEN id=$1 THEN CAST($2 AS int)
there doesn't seem to be a way to correctly assign the type across multiple platforms. E.g. Postgres required "int" but mysql just requires "unsigned". Attempting to use "int" here with mysql will fail.
The method Doctrine\DBAL\Platforms method getIntegerTypeDeclarationSQL will return something like "INT unsigned" for sql, which also fails.