🐛 Bug: column datatype not changing from SingleLineText to Number

[gauravruhela07]

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

1. create a table with column datatype SingleLineText
2. enter any string value
3. remove that value with an empty string
4. now try changing column datatype to Number,
   you will get an error ALTER TABLE "pjars2cq55xvi42"."Table-1" ALTER COLUMN "name" TYPE bigint USING "name"::bigint; ; - invalid input syntax for type bigint: ""
5. when we replace that empty string with number, then the system is allowing me change the column datatype

Desired Behavior

We should be able to change the column datatype from SingleLineText to Number if the values in columns are empty.

Project Details

Node:
Arch: arm64
Platform: macOS
Browser: chrome

Attachments

[gauravruhela07]

@o1lab please review and assign it to me. I am interested to work on this issue.

[gauravruhela07]

Hi @dstala, I am not facing this issue when running app on my local system, however the website still shows the same bug. Can you please verify if it got fixed but the fix is not live yet? Thank you