Invalid Date on TypeCast for execute after 3.9.x

[wellwelwel]

Traces

• Issue: Compatibility issue with MySQL2 v3.9 sequelize/sequelize#17141
• Issue: Invalid Date when using sequelize.query sequelize/sequelize#17116
• Branch: https://github.com/sequelize/sequelize/tree/ephys/17141
• Commit: sequelize/sequelize@main...ephys/17141

Challenges from MySQL2 side

• Understand DATETIME behaviors when returned from query and execute
• Analyze how execute returns a DATETIME value in MySQL2 3.5.2
• Analyze how execute returns a DATETIME value in MySQL2 3.9.2
• Reproduce a minimal error case
• Fix it 🚀

Steps for Sequelize

• Reproduce both success and failure cases (old / new versions from MySQL2)
• Test the solution on Sequelize in practice before to merge it