Quartz Fails When MYSQL emulateLocators=true Is Enabled

[atkawa7]

When emulateLocators=true is enable via MYSQL JDBC API all calls to getObjectFromBlob fail because quartz column do not currently support aliasing.

As a result you get errors such as

org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: Unknown column '' in 'field list'
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2818) ~[quartz-2.5.0.jar:2.5.0]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.lambda$acquireNextTriggers$13(JobStoreSupport.java:2703) ~[quartz-2.5.0.jar:2.5.0]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3736) ~[quartz-2.5.0.jar:2.5.0]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2702) ~[quartz-2.5.0.jar:2.5.0]
	at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:294) ~[quartz-2.5.0.jar:2.5.0]
Caused by: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Unknown column '' in 'field list'
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1522) ~[quartz-2.5.0.jar:2.5.0]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2748) ~[quartz-2.5.0.jar:2.5.0]
	... 4 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Unknown column '' in 'field list'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112) ~[mysql-connector-j-9.2.0.jar:9.2.0]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114) ~[mysql-connector-j-9.2.0.jar:9.2.0]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:990) ~[mysql-connector-j-9.2.0.jar:9.2.0]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1058) ~[mysql-connector-j-9.2.0.jar:9.2.0]
	at com.mysql.cj.jdbc.BlobFromLocator.length(BlobFromLocator.java:286) ~[mysql-connector-j-9.2.0.jar:9.2.0]
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getObjectFromBlob(StdJDBCDelegate.java:3154) ~[quartz-2.5.0.jar:2.5.0]
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1761) ~[quartz-2.5.0.jar:2.5.0]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1519) ~[quartz-2.5.0.jar:2.5.0]
	... 5 common frames omitted