Skip to content

UNSIGNED modifier does not work with unused parameters of INT #35890

@alexey-milovidov

Description

@alexey-milovidov

Describe the unexpected behaviour

:) CREATE TEMPORARY TABLE test (x INT UNSIGNED)

CREATE TEMPORARY TABLE test
(
    `x` INT UNSIGNED
)

Query id: f4fa2663-3a8a-445d-a9cb-de759ac191de

Ok.

0 rows in set. Elapsed: 0.002 sec. 

:) DROP TABLE test

DROP TABLE test

Query id: 32fee2e0-78c4-4fed-8c34-78c5aaab2781

Ok.

0 rows in set. Elapsed: 0.001 sec. 

ubuntu-4gb-nbg1-2 :) CREATE TEMPORARY TABLE test (x INT(11) UNSIGNED)

Syntax error: failed at position 40 ('UNSIGNED')

Metadata

Metadata

Assignees

No one assigned

    Labels

    easy taskGood for first contributorsunexpected behaviourResult is unexpected, but not entirely wrong at the same time.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions