Skip to content

[BUG]: drizzle kit pull can not generate Mysql POINT type #4606

Open
@justin-rwazi

Description

@justin-rwazi

Report hasn't been filed before.

  • I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.44.2

What version of drizzle-kit are you using?

0.31.1

Other packages

No response

Describe the Bug

Drizzle show warning and missing field inside type

export const locationEntities = mysqlTable("Location", {
	id: int({ unsigned: true }).autoincrement().notNull(),
	// Warning: Can't parse point from database
	// pointType: point("coordinates").notNull(),
	address: varchar({ length: 191 }),
},

SQL migration is fine:

CREATE TABLE `Location` (
	`id` int unsigned AUTO_INCREMENT NOT NULL,
	`coordinates` point NOT NULL,
	`address` varchar(191),
	CONSTRAINT `LocationEntities_id` PRIMARY KEY(`id`)
);

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions