sequelize-sscce icon indicating copy to clipboard operation
sequelize-sscce copied to clipboard

Published 20 hours ago • verified publisher icon sequelize

Location data model will fail to create in MySQL 8

Open thomasmost opened this issue 3 years ago • 3 comments

Fails with error: SequelizeDatabaseError: FUNCTION db.GeomFromText does not exist

thomasmost avatar Mar 10 '21 19:03 thomasmost

Hello! I noticed you are talking about MySQL 8, but the SSCCE is running against MySQL 5.7. This reminds me that we should have tests running against other versions too. Perhaps this is not the only issue with mysql 8. Can you also edit this part so your SSCCE runs against mysql 8?

papb avatar Mar 12 '21 18:03 papb

@papb Yes! Thank you for pointing me in the right direction

thomasmost avatar Mar 13 '21 21:03 thomasmost

I believe this issue can now be closed since support and tests for the new ST_GeomFromText API were added in [email protected] (and I tested in 6.17.0)

Reference: https://github.com/sequelize/sequelize/issues/13086

thomasmost avatar Mar 06 '22 21:03 thomasmost