Skip to content

Import: Unable to convert to decimal a text column with the value is 1.0 #5208

@jeromeperez

Description

@jeromeperez

Description

Import: Unable to convert a decimal column when the value is 1.0, with the error
Failed to load preview InvalidTextRepresentation: invalid input syntax for numeric type: “1,0” SQLSTATE: 22P02

Expected behavior

Be able to convert to decimal a text column with the value is 1.0

To Reproduce

  1. new table
  2. choose data import
  3. modify type from text to number decimal
  4. click create

Environment

  • Mathesar version: 0.8.0
  • OS: debian bookworm
  • Browser: brave
  • Browser Version: Brave 1.86.148 (Build officiel) (64 bits)
    Chromium: 144.0.7559.133

Metadata

Metadata

Assignees

No one assigned

    Labels

    needs: triageThis issue has not yet been reviewed by a maintainertype: bug

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions