[MYSQL] Auto-generated columns not migrated

[shubham-yb]

Auto Generated column on MYSQL is not getting migrated and so the rows are not getting generated on the target

This is the schema I used:

drop table if exists auto_gen;

create table auto_gen (
	id int primary key auto_increment,
	first_name VARCHAR(50),
	last_name VARCHAR(50),
	fullname varchar(101) GENERATED ALWAYS AS (CONCAT(first_name,' ',last_name)),
	email VARCHAR(50),
	gender VARCHAR(50),
	ip_address VARCHAR(20)
);

This is the exported schema:

CREATE TABLE auto_gen (
	id serial,
	first_name varchar(50),
	last_name varchar(50),
	fullname varchar(101),
	email varchar(50),
	gender varchar(50),
	ip_address varchar(20),
	PRIMARY KEY (id)
) ;

Table description on the source:

Table description on the target:

[shubham-yb]

Tried with a simple numeric auto generated column as well. Didn't work. Not a voyager issue. Yugabyte-DB doesn't support it yet it seems because the same schema worked for Postgres but not YB.

Just for reference the schema I used was:

drop table if exists auto_price;

create table auto_price (
	id INT,
	first_name VARCHAR(50),
	gender VARCHAR(50),
	price_dollar DECIMAL(7,2),
    price_pound DECIMAL(7,2) generated always as (price_dollar * 0.22) STORED
);

[rahulb-yb]

Did some digging, generated columns are supported from PG12 and up. YB is unable to support generated columns regardless, we will have to file an issue both on ora2pg and add a check for generated columns (if needed) in analyze schema.

Relavant issues:
yugabyte/yugabyte-db#5805
yugabyte/yugabyte-db#9797

Edit:We report cases of generated columns in analyze schema, just need to raise a ticket on ora2pg GH

[shubham-yb]

I have put up the issue on ora2pg.

[shubham-yb]

#355