Time Annotation Layer for Mixed Chart

[peppoSVII]

When I try to add an annotation layer to a mixed chart, it doesn't work.
The error message is related to 'P1D' time grain representation.

I tried for different database connections (MariaDB and Big Query) and it fails for both.

How to reproduce the bug

1. Go to your mixed chart
2. Add a new 'Event' or 'Interval' annotation.

Expected results

A new annotation layer on the graph.

Actual results

Error for BQ:
400 Unrecognized Name: P1D at [1:8] Location

Error for MariaDB:
Unknown column 'P1D' in 'field list'

Screenshots

Error for Maria DB:

Error for BQ:

Environment

• superset version: 2.1

[sfirke]

Seems possibly related to #24374

[rusackas]

I'm not sure if this is still an issue in current versions of Superset (3.x). If it is, we can re-open this, or feel free to open a new issue with updated context and a reproducible case using example data. We're no longer supporting Superset 2.x or prior, and it's been a while since this thread saw any activity, so I'm closing this as stale.