Skip to content

Support cast "signed" / "unsigned" for MySQL #1606

@Patrick-Ullrich

Description

@Patrick-Ullrich

Currently cast does not accept signed and unsigned.

However in mysql:

SELECT cast("0" AS integer)

will result in:
Query 1 ERROR at Line 1: : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'integer)' at line 1

The correct syntax be:

SELECT cast("0" AS signed)

or

SELECT cast("0" AS unsigned)

Metadata

Metadata

Assignees

No one assigned

    Labels

    apiRelated to library's APIenhancementNew feature or requestmysqlRelated to MySQLtypescriptRelated to Typescript

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions