stacked bar graph does not "stack" all data with same label

[aedion-a]

Introduction

The stacked bar graph does not handle well same label.

To Reproduce

CREATE TABLE `test` (
  `series` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `x`      varchar(4)  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value`  bigint(21)  NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `test` (`series`, `x`, `value`) VALUES
('1 an <= x', '1/5', 1),
('x < 6 mois', '1/5', 1),
('x < 6 mois', '3/5', 1),
('x < 6 mois', '4/5', 1),
('1 an <= x', '5/5', 9),
('6 mois <= x < 1 an', '5/5', 9),
('x < 6 mois', '5/5', 14);
COMMIT;

select 
    'chart'   as component,
    'freq' as title,
    'bar'     as type,
    TRUE      as horizontal,
    TRUE      as stacked,
    TRUE      as labels,
    true as toolbar,
    'pink'    as color,
    'azure'   as color,
    'lime'    as color;

select * from test;

Actual behavior

The three "5/5" (three values: 9, 9, 14) are not represented on the same line.

Screenshots

Version information

• OS: Xubuntu
• Database: MariaDB 10.3
• SQLPage Version: 0.31

[lovasoa]

Thanks for the report ! The fix will be in 0.32 :)