[4.x]: Changing existing field to Lightswitch is broken

[boboldehampsink]

What happened?

Description

SQLSTATE[42701]: Duplicate column: 7 ERROR: column "field_productOnlineStock_quskocqc" of relation "content" already exists
The SQL being executed was: ALTER TABLE "content" ADD "field_productOnlineStock_quskocqc" boolean

Steps to reproduce

1. Create a number field, for example
2. Save it
3. Change to Lightswitch type

Expected behavior

It changes to Lightswitch type

Actual behavior

Error (as above)

Craft CMS version

4.8.8

PHP version

8.3

Operating system and version

No response

Database type and version

PostgreSQL

Image driver and version

No response

Installed plugins and versions

[i-just]

Hi, thanks for reporting! I raised a PR for this.

[brandonkelly]

Craft 4.8.10 is out with the fix for this. Thanks again!