Existing Cluster Column Chart from beta3 stopped working in beta4

[clementchong]

Datart Version
1.0.0b4

Describe the bug
An existing cluster column chart from beta 3 stopped working in beta 4. The data source is the same and both beta3 and beta4 are running in parallel for regression test. The "# Product" in the dimension is the prod_type_count field from dataset.

Manually creating the chart again in beta 4 has same issue.

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
The charts should display the same in beta 4.

Screenshots

Data seen from beta 3:

Chart from beta 3:

Data seen from beta 4:

Chart seen from beta 4:

Environmental details: (optional, depending on where the bug occurs)

• OS: [e.g. Windows 10]
• Source Database: [e.g. MySQL 8.0.26]
• Browser: [e.g. chrome 94, safari 15]

Additional context
Add any other context about the problem here.

[Cuiyansong]

The issue maybe same as whitespace in database column name, could you try to remove "#" mark and only keep " Products"?

[clementchong]

The issue maybe same as whitespace in database column name, could you try to remove "#" mark and only keep " Products"?

I tried removing the field alias but still same issue.

When I try remove the prod_type from "Color" box, the chart appears but it does not provide the product split information like before.

[Cuiyansong]

I mean could you try to change "# Products" and "# Clients" to " Products" and " Clients"?

[clementchong]

I mean could you try to change "# Products" and "# Clients" to " Products" and " Clients"?

Yes of course. Removed all aliases.

[clementchong]

There are only 3 fields in the SQL and I can see the data but the chart is not rendering.

[Cuiyansong]

Sorry for misunderstanding, let me try to produce the error first.

[clementchong]

ok thank you. I turned on debug but do not see SQL error, hence checking here.

[Cuiyansong]

This issue will be fixed in rc.0, thanks for your contributions 👍🏿 .

[clementchong]

Ok, what is the root cause? Let me know when PR is available. I can merge locally to test. I cannot upgrade to beta 4 for now.

[Cuiyansong]

This is #790 , root cause is number value is not strict equal to string value when compare two value.

[clementchong]

Ok thank you!

[Cuiyansong]

感谢贡献，此问题已验证并修复，如新版本仍然有问题请留言或者重开此问题。

[clementchong]

感谢贡献，此问题已验证并修复，如新版本仍然有问题请留言或者重开此问题。

好的！谢谢你！