mariadb timezone error with named timezones

[seally1186]

What are you doing?

Using mariadb with a named timezone and doing any query:

const sequelize = new Sequelize("mariadb://...", { timezone: "America/Los_Angeles" });
sequelize.query("SELECT 1");

What is actually happening?

SequelizeConnectionError: timezone format error. must be 'local'/'Z' or ±HH:MM. was 'America/Los_Angeles'
    at lib.createConnection.then.catch.err (/var/project/node_modules/sequelize/lib/dialects/mariadb/connection-manager.js:122:19)

It looks like connection-manager.js is handling the timezone (via momentTz), but it's also passing the timezone string directly to the mariadb library, which rejects it.

Dialect: mariadb
Dialect version: mariadb@2.0.3
Database version: N/A
Sequelize version: 5.1.1 and master
Tested with latest release: Yes

[knoxcard]

@rusher - check this out...any ideas?

[rusher]

As indicate by error message, Timezone support is currently limited to "local'/'Z' or ±HH:MM. That's something that will be handled in next version (in about 2 weeks)

[knoxcard]

@rusher - Thanks for the quick replies, as always, much appreciated!

[sushantdhiman]

I believe this #10705 will fix this issue