sqlparse icon indicating copy to clipboard operation
sqlparse copied to clipboard

Numeric, decimal data types are parsing the precision scale as column

Open BhuviTheDataGuy opened this issue 4 years ago • 0 comments

I think this is a bug. (but please verify)

This is my same SQL query

CREATE TABLE foo (
             id integer primary key,
             title NUMERIC(38,6)  not null,
             description text);

And Im running this example python code (given from this repo) . And this is the output.

NAME: id           DEFINITION: integer primary key
NAME: title        DEFINITION: NUMERIC 38
NAME: 6            DEFINITION: not null
NAME: description  DEFINITION: text

This numeric data type is giving an issue.

BhuviTheDataGuy avatar Aug 04 '20 15:08 BhuviTheDataGuy