Size of bubbles not respected on scatter chart

[paoliniluis]

Describe the bug
If you have a simple query like

select 1 as size, 1 as x, 5 as y union all
select 10 as size, 2 as x, 5 as y union all
select 100 as size, 1 as x, 10 as y union all
select 1000 as size, 2 as x, 10 as y

then the size of the bubbles will be always the same, no matter the value you use in the bubble size config

Logs
NA

To Reproduce

1. New -> question -> SQL question
2. use the query above
3. select a scatter chart and config the chart according to the columns
4. see the error

Expected behavior
Bubble should have the size of the column "size", not the one from the column "y"

Screenshots

Information about your Metabase Installation:

• Your browser and the version: Brave latest
• Your operating system: Pop-os 22.04
• Your databases: Postgres 14.2
• Metabase version: 1.43.1
• Metabase hosting environment: Docker
• Metabase internal database: Postgres 14.2

Severity
P3

Additional context
Reported by a customer

[flamber]

Regression since 0.43.0, similar to #22527, fixed by #22866.