Issue with Parent/Child Cascading Variable

Hello,

I’m seeing some weird behavior with cascading parent/child variables. I’m using Grafana 6.2.4. I have two pretty simple tables in MySQL to demonstrate the issue using a State and City table as shown below:



If I select “San Francisco” and “Los Angeles” in the City (child) table:

then select “California” in the State (parent) table:

“San Francisco” and “Los Angeles” are displayed as “1” and “2”, respectively, which are their primary keys in the City (child) table:

However, if I click the City drop down, “San Francisco” and “Los Angeles” are displayed correctly.

Anyone know what’s going on here?

Here is variable declaration for State:

and City:

Thanks in advance,

Brian