-
-
Couldn't load subscription status.
- Fork 154
Closed
Labels
bugSomething isn't workingSomething isn't working
Description
Introduction
On this time series, the tooltip goes from one year to the next for no reason.
To Reproduce
CREATE TABLE`test`(
`series` int(4) DEFAULT NULL,
`y` bigint(21) NOT NULL DEFAULT '0',
`x` varchar(19) COLLATE utf8mb4_unicode_ci DEFAULT NULL
);
INSERT INTO `test` (`series`, `y`, `x`) VALUES
(2022, 3, '2022-01-31 00:00:00'),
(2022, 2, '2022-03-31 00:00:00'),
(2022, 2, '2022-04-30 00:00:00'),
(2022, 2, '2022-05-31 00:00:00'),
(2022, 3, '2022-06-30 00:00:00'),
(2022, 7, '2022-07-31 00:00:00'),
(2022, 1, '2022-08-31 00:00:00'),
(2022, 3, '2022-09-30 00:00:00'),
(2022, 15, '2022-11-30 00:00:00'),
(2022, 6, '2022-12-31 00:00:00'),
(2023, 1, '2023-01-31 00:00:00'),
(2023, 6, '2023-02-28 00:00:00'),
(2023, 16, '2023-03-31 00:00:00'),
(2023, 3, '2023-04-30 00:00:00'),
(2023, 9, '2023-06-30 00:00:00'),
(2023, 4, '2023-07-31 00:00:00'),
(2023, 8, '2023-08-31 00:00:00'),
(2023, 7, '2023-09-30 00:00:00'),
(2023, 2, '2023-10-31 00:00:00'),
(2023, 14, '2023-12-31 00:00:00'),
(2024, 2, '2024-01-31 00:00:00'),
(2024, 2, '2024-02-29 00:00:00'),
(2024, 3, '2024-03-31 00:00:00'),
(2024, 2, '2024-04-30 00:00:00'),
(2024, 3, '2024-05-31 00:00:00'),
(2024, 4, '2024-06-30 00:00:00'),
(2024, 2, '2024-07-31 00:00:00'),
(2024, 12, '2024-08-31 00:00:00'),
(2024, 9, '2024-09-30 00:00:00'),
(2024, 2, '2024-11-30 00:00:00'),
(2024, 3, '2024-12-31 00:00:00');
COMMIT;Actual behavior
select
'chart' as component,
'test' as title,
'line' as type,
'green' as color,
'indigo' as color,
'pink' as color,
true as time,
5 as marker;
SELECT * from test;Screenshots
cursor on the first node (tooltip on the first node of the first graph)
cursor on the second node (tooltip on the first node of the third graph)
Version information
- OS: Xubuntu
- Database: MariaDB 10.3
- SQLPage Version: 0.31
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working

