Why php migration fails on change table column type to string from numeric

Question

I am new to PHP and laravel platform,need your help to resolve PDOException on run the migration task to alter table column type from number to string.

...
public function up()
{
    Schema::table('BuildTable', function (Blueprint $table) {
       $table->string('snapshot_id')->change();
    });

}
....

getting PDOException on run the migration task

Doctrine\DBAL\Driver\PDOException::("SQLSTATE[0A000]: Feature not supported: 7 ERROR:  unimplemented: type conversion from INT8 to VARCHAR(255) requires overwriting existing values which is not yet implemented
HINT:  You have attempted to use a feature that is not yet implemented.

Existing table structure was created using

      Schema::create(
        $this->tablename,
        function (Blueprint $table) {
            $table->increments('id');
            $table->integer('account_id')->unsigned();
            $table->integer('snapshot_id')->unsigned();
            $table->timestamps(6);
            $table->softDeletes('deleted_at', 6)->default(null);
        }
    );

The existing table already have data in snapshot_id

Php version is 7.3.20 running on linux mint OS , Database - cockroachDB

Does this answer your question? How to change column data type in laravel 5.6? — N69S
– N69S, Commented Aug 5, 2020 at 7:35
Chris , the details didn't resolve the issue , I am getting "SQLSTATE[0A000]: Feature not supported: 7 ERROR: unimplemented: type conversion from INT8 to VARCHAR(255) requires overwriting existing values which is not yet implemented — Mishi Reghunadh
– Mishi Reghunadh, Commented Aug 5, 2020 at 7:38
I think the error message is fairly self explanatory. Your table already contains data which has been stored as INT8 and you're asking the engine to convert to VARCHAR(255) which it doesn't know how to do. If the table were empty of data it would be different. Why do you want to convert what looks to be a foreign key to a string anyway? — Peppermintology
– Peppermintology, Commented Aug 5, 2020 at 8:03
@sykez @ Unflux You are correct,Its a database related issue as I am getting similar exception on direct SQL execution in tool too. We are using cockroachDB and it looks like direct data conversion from INT8 to VARCHAR feature not available for this particular version of it — Mishi Reghunadh
– Mishi Reghunadh, Commented Aug 5, 2020 at 12:22

rafiss · Accepted Answer · 2020-08-18 17:10:05Z

2

This feature will be experimentally available in CockroachDB v20.2, which is getting released later this year.

If you want, you can test out with an alpha version (v20.2.0-alpha.2) which has this functionality. See the release notes. To use it, you need to set the following session variable: SET enable_experimental_alter_column_type_general = true;

answered Aug 18, 2020 at 17:10

rafiss

5833 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why php migration fails on change table column type to string from numeric

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related