[MDEV-15926] MEDIUMINT returns wrong I_S attributes - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
Fix Version/s: 10.3.7
Component/s: Data types, Information Schema
Labels:
None

Description

The MEDIUMINT type has the following characteristics depending on signess:

MEDIUMINT SIGNED    -8388608..8388607   (7 digits,  8 characters)

MEDIUNINT UNSIGNED        0..16777215   (8 digits,  8 characters)

But these characteristics are not taken into account precisely:

CREATE OR REPLACE TABLE t1 (a MEDIUMINT, b MEDIUMINT UNSIGNED);

SELECT COLUMN_NAME, NUMERIC_PRECISION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1';

+-------------+-------------------+

| COLUMN_NAME | NUMERIC_PRECISION |

+-------------+-------------------+

| a           |                 7 |

| b           |                 7 |

+-------------+-------------------+

Notice, the precision value for UNSIGNED is wrong. It should be 8 digits.

Attachments

Issue Links

blocks

MDEV-4912 Data type plugin API version 1

Closed

relates to

MDEV-13232 Assertion `(&(&share->intern_lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&share->intern_lock)->m_mutex)->thread)' failed in _ma_state_info_write

Closed

MDEV-15946 MEDIUMINT(N<8) creates a wrong data type on conversion to string

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-04-19 06:28

Updated:: 2018-04-20 14:16

Resolved:: 2018-04-20 14:16

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.