Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[MySQL] Investigate support for migrating GEOMETRY type #137

Open
amit-yb opened this issue May 26, 2022 · 0 comments
Open

[MySQL] Investigate support for migrating GEOMETRY type #137

amit-yb opened this issue May 26, 2022 · 0 comments
Assignees
Labels

Comments

@amit-yb
Copy link
Contributor

amit-yb commented May 26, 2022

Migration from sakila database (https://downloads.mysql.com/docs/sakila-db.zip) from MySQL to YB fails because of a GEOMETRY field address.location.

importing      TABLE      
    ERROR: type "geometry" does not exist (SQLSTATE 42704)
    STATEMENT: CREATE TABLE address (
	address_id smallserial,
	address varchar(50) NOT NULL,
	address2 varchar(50),
	district varchar(20) NOT NULL,
	city_id smallint NOT NULL,
	postal_code varchar(10),
	phone varchar(20) NOT NULL,
	location GEOMETRY NOT NULL,
	last_update timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (address_id)
) 
@kneeraj kneeraj changed the title [MySQL] Support migrating GEOMETRY type [MySQL] Investigate support for migrating GEOMETRY type Jun 30, 2022
@amit-yb amit-yb added the GA1.0 label Jul 1, 2022
@kneeraj kneeraj added testing documentation Improvements or additions to documentation labels Aug 18, 2022
@chetank-yb chetank-yb assigned shubham-yb and unassigned chetank-yb Aug 22, 2022
@shubham-yb shubham-yb removed the documentation Improvements or additions to documentation label Jan 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

4 participants