Menu ▾ ▴

#3103 [ok 3.3.8] Big number import creates wrong column type

3.3.6
fixed
Dieter Adriaenssens
Data Import (38)
1
2013-06-11
2010-09-04
Michiel Hazelhof
No

When importing a csv with big numbers (e.g. EAN13) it creates a int(13) column instead of a BIGINT(13).

Example:
8712121001423
8712121001430
8712121001447
8712121001461

Mysql: 5.1.43-1
PHP: 5.2.6-1+lenny9 + suhosin
Phpmyadmin: 3.3.6

Discussion

  • Dieter Adriaenssens

    Dieter Adriaenssens - 2010-09-09

    The current code makes no distinction between INT-sizes. It applies INT to everything that is an integer.

     

  • Dieter Adriaenssens

    Dieter Adriaenssens - 2010-09-09
    • assigned_to: nobody --> ruleant
    • status: open --> open-accepted
     

  • Dieter Adriaenssens

    Dieter Adriaenssens - 2010-09-10

    This bug was fixed in repository and will be part of a future release; thanks for reporting.

     

  • Dieter Adriaenssens

    Dieter Adriaenssens - 2010-09-10
    • priority: 5 --> 1
    • summary: Big number import (e.g. ean13) creates wrong column type --> [ok 3.3.8] Big number import creates wrong column type
    • status: open-accepted --> open-fixed
     

  • Marc Delisle

    Marc Delisle - 2010-10-25
    • status: open-fixed --> closed-fixed
     

  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
Auth0 Logo