When using backticks to escape an AS clause containing spaces, the syntax hilighting is not handled properly. For example, with no spaces hilighting is as expected:
SELECT
protocol_no AS `ProtocolNo`,
principal_investigator AS `PrincipalInvestigator`,
funding
FROM study;
But when the escaped string contains a space it breaks the syntax hilighting:
SELECT
protocol_no AS `Protocol No`,
principal_investigator AS `Principal Investigator`,
funding
FROM study;
When using backticks to escape an AS clause containing spaces, the syntax hilighting is not handled properly. For example, with no spaces hilighting is as expected:
But when the escaped string contains a space it breaks the syntax hilighting: