search

mysqljs / mysql

A pure node.js JavaScript Client implementing the MySQL protocol.
MIT License
18.31k stars 2.53k forks source link

Processes only a small amount of records #2532

Closed tjakober closed 2 years ago

tjakober commented 3 years ago

I have a problem that my queries processes only th first 46 records of my table. Altough when i am querying using HeidiSQL more than 200 records ar processed. I cannot see any difference to the records after this 45th record.

Any help would be greately appreciated.

It is a simple table with 2 fields:

CREATE TABLE IF NOT EXISTS `temp_winterthur_ext` (
  `time` datetime NOT NULL,
  `value` float DEFAULT NULL,
  PRIMARY KEY (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Program Code:

const fs = require('fs');
const { resolve } = require("path");
var cfg;
try {
    cfg = fs.readFileSync("database.json", 'utf8');
} catch (err) {
    console.log('Could not find configuration file "config.json"');
    process.exit(1);
}
const config = JSON.parse(cfg);

const mysql = require('mysql');

const dbConn = mysql.createConnection({
    host: config.url,
    port: config.port,
    user: config.username,
    password: config.password,
    database: 'things',
    dateStrings: true
  });

dbConn.query('SELECT * from temp_winterthur_ext', (err, aRec, aFields) => {
    console.log('All records', aRec);
});  

dbConn.query('SELECT DATE(`time`), min(value), max(value) from temp_winterthur_ext group by DAY(`time`) ORDER BY DATE(`time`)', (err, aRec, aFields) => {
    console.log('Max Min per Day', aRec);
});

Database:

INSERT INTO `temp_winterthur_ext` (`time`, `value`) VALUES
    ('2021-03-17 15:52:33', 4.9),
    ('2021-03-19 19:31:23', 3.3),
    ('2021-03-19 19:32:19', 3.3),
    ('2021-10-24 14:16:10', 9.5),
    ('2021-10-24 15:06:46', 14.1),
    ('2021-10-24 15:06:47', 9.5),
    ('2021-10-24 15:15:37', 9.5),
    ('2021-10-24 15:15:38', 14.1),
    ('2021-10-24 15:16:33', 9.5),
    ('2021-10-24 15:59:32', 10.5),
    ('2021-10-24 15:59:33', 13.1),
    ('2021-10-24 18:25:20', 10.1),
    ('2021-10-24 18:35:30', 8.5),
    ('2021-10-24 19:10:05', 7.5),
    ('2021-10-24 19:57:57', 6.5),
    ('2021-10-24 21:06:42', 5.5),
    ('2021-10-24 22:41:02', 4.5),
    ('2021-10-25 11:12:24', 7.5),
    ('2021-10-25 11:16:12', 8.5),
    ('2021-10-25 17:00:49', 14.5),
    ('2021-10-25 17:49:57', 13.5),
    ('2021-10-25 18:11:42', 12.5),
    ('2021-10-25 18:29:07', 11.5),
    ('2021-10-25 18:56:02', 10.5),
    ('2021-10-25 19:35:02', 9.5),
    ('2021-10-25 20:02:52', 8.5),
    ('2021-10-25 20:56:33', 7.5),
    ('2021-10-25 22:08:35', 6.5),
    ('2021-10-26 00:36:50', 5.5),
    ('2021-10-26 05:53:51', 6.5),
    ('2021-10-26 09:02:07', 7.5),
    ('2021-10-26 09:34:08', 8.5),
    ('2021-10-26 10:08:33', 9.5),
    ('2021-10-26 10:17:38', 10.5),
    ('2021-10-26 10:58:43', 11.5),
    ('2021-10-26 11:18:53', 12.5),
    ('2021-10-26 13:44:39', 14.5),
    ('2021-10-26 17:55:11', 12.5),
    ('2021-10-26 18:19:21', 11.5),
    ('2021-10-26 19:25:31', 10.5),
    ('2021-10-26 19:55:46', 9.5),
    ('2021-10-26 21:02:26', 8.5),
    ('2021-10-26 22:19:11', 7.5),
    ('2021-10-27 00:05:36', 6.5),
    ('2021-10-27 01:58:31', 5.5),
    ('2021-10-27 03:55:26', 6.5),
    ('2021-10-27 09:02:36', 7.5),
    ('2021-10-27 10:07:26', 8.5),
    ('2021-10-27 10:57:11', 9.5),
    ('2021-10-27 12:46:16', 10.5),
    ('2021-10-27 13:26:01', 11.5),
    ('2021-10-27 14:06:16', 12.5),
    ('2021-10-27 17:45:26', 11.5),
    ('2021-10-27 18:10:51', 10.5),
    ('2021-10-27 18:44:56', 9.5),
    ('2021-10-27 19:34:51', 8.5),
    ('2021-10-27 20:41:41', 7.5),
    ('2021-10-27 21:59:06', 6.5),
    ('2021-10-27 23:46:06', 5.5),
    ('2021-10-28 03:08:26', 6.5),
    ('2021-10-28 08:57:51', 7.5),
    ('2021-10-28 09:55:56', 8.5),
    ('2021-10-28 11:24:46', 9.5),
    ('2021-10-28 11:49:16', 10.5),
    ('2021-10-28 12:22:16', 11.5),
    ('2021-10-28 12:39:01', 12.5),
    ('2021-10-28 12:53:31', 13.5),
    ('2021-10-28 13:32:41', 12.5),
    ('2021-10-28 17:15:01', 11.5),
    ('2021-10-28 17:47:31', 10.5),
    ('2021-10-28 18:13:06', 9.5),
    ('2021-10-28 18:48:26', 8.5),
    ('2021-10-28 19:51:26', 7.5),
    ('2021-10-28 21:05:36', 6.5),
    ('2021-10-28 22:35:01', 5.5),
    ('2021-10-29 00:01:22', 6.5),
    ('2021-10-29 09:49:33', 7.5),
    ('2021-10-29 12:34:13', 8.5),
    ('2021-10-29 13:25:33', 9.5),
    ('2021-10-29 14:11:53', 10.5),
    ('2021-10-29 15:03:43', 11.5),
    ('2021-10-29 16:38:23', 10.5),
    ('2021-10-29 17:27:03', 9.5),
    ('2021-10-29 18:27:23', 8.5),
    ('2021-10-29 21:14:39', 7.5),
    ('2021-10-30 04:30:19', 6.5),
    ('2021-10-30 12:13:09', 7.5),
    ('2021-10-30 14:33:55', 8.5),
    ('2021-10-30 16:09:17', 9.5),
    ('2021-10-30 23:46:00', 8.5),
    ('2021-10-31 08:52:25', 9.5),
    ('2021-10-31 09:21:30', 10.5),
    ('2021-10-31 10:24:30', 11.5),
    ('2021-10-31 10:34:35', 12.5),
    ('2021-10-31 10:44:00', 13.5),
    ('2021-10-31 10:59:55', 14.5),
    ('2021-10-31 11:35:10', 15.5),
    ('2021-10-31 13:26:20', 16.5),
    ('2021-10-31 15:58:55', 15.5),
    ('2021-10-31 16:40:00', 14.5),
    ('2021-10-31 17:08:55', 13.5),
    ('2021-10-31 17:42:40', 12.5),
    ('2021-10-31 18:30:45', 11.5),
    ('2021-10-31 19:44:15', 10.5),
    ('2021-10-31 21:01:45', 9.5),
    ('2021-10-31 22:41:05', 8.5),
    ('2021-11-01 01:03:15', 9.5),
    ('2021-11-01 04:44:10', 10.5),
    ('2021-11-01 07:28:40', 9.5),
    ('2021-11-01 11:21:35', 10.5),
    ('2021-11-01 19:14:20', 9.5),
    ('2021-11-01 20:03:45', 8.5),
    ('2021-11-01 22:52:10', 7.5),
    ('2021-11-02 04:18:46', 6.5),
    ('2021-11-02 09:51:21', 7.5),
    ('2021-11-02 10:40:46', 8.5),
    ('2021-11-02 11:34:26', 9.5),
    ('2021-11-02 12:23:36', 8.5),
    ('2021-11-02 13:02:56', 9.5),
    ('2021-11-02 17:14:16', 8.5),
    ('2021-11-02 17:58:06', 7.5),
    ('2021-11-02 18:54:26', 6.5),
    ('2021-11-02 20:13:41', 5.5),
    ('2021-11-02 22:29:16', 4.5),
    ('2021-11-03 06:18:32', 5.5),
    ('2021-11-03 08:53:32', 6.5),
    ('2021-11-03 09:34:06', 7.5),
    ('2021-11-03 09:54:22', 8.5),
    ('2021-11-03 10:13:32', 9.5),
    ('2021-11-03 11:09:37', 10.5),
    ('2021-11-03 12:27:22', 9.5),
    ('2021-11-03 12:56:32', 8.5),
    ('2021-11-03 17:25:07', 7.5),
    ('2021-11-04 01:01:15', 6.5),
    ('2021-11-04 06:54:20', 5.5),
    ('2021-11-04 09:42:10', 6.5),
    ('2021-11-04 11:33:10', 7.5),
    ('2021-11-04 11:57:00', 8.5),
    ('2021-11-04 13:21:00', 7.5),
    ('2021-11-04 15:26:25', 6.5),
    ('2021-11-04 15:34:55', 5.5),
    ('2021-11-04 17:48:15', 4.5),
    ('2021-11-05 06:00:48', 4.8),
    ('2021-11-05 07:50:18', 5.8),
    ('2021-11-05 08:58:58', 6.8),
    ('2021-11-05 09:34:58', 7.8),
    ('2021-11-05 10:07:43', 8.8),
    ('2021-11-05 10:42:08', 9.8),
    ('2021-11-05 11:14:53', 10.8),
    ('2021-11-05 14:46:58', 9.8),
    ('2021-11-05 16:12:43', 8.8),
    ('2021-11-05 16:36:28', 7.8),
    ('2021-11-05 17:07:23', 6.8),
    ('2021-11-05 17:48:44', 5.8),
    ('2021-11-05 19:13:08', 4.8),
    ('2021-11-05 20:33:18', 3.8),
    ('2021-11-05 22:32:49', 2.8),
    ('2021-11-06 05:41:38', 3.8),
    ('2021-11-06 07:18:18', 4.8),
    ('2021-11-06 08:35:08', 5.8),
    ('2021-11-06 09:32:23', 6.8),
    ('2021-11-06 10:43:58', 7.8),
    ('2021-11-06 10:49:24', 8.8),
    ('2021-11-06 11:06:08', 9.8),
    ('2021-11-06 11:28:53', 10.8),
    ('2021-11-06 14:38:23', 9.8),
    ('2021-11-06 16:13:39', 8.8),
    ('2021-11-06 16:40:09', 7.8),
    ('2021-11-06 17:09:59', 6.8),
    ('2021-11-06 17:40:34', 5.8),
    ('2021-11-06 18:29:58', 4.8),
    ('2021-11-06 19:35:48', 3.8),
    ('2021-11-06 21:11:09', 2.8),
    ('2021-11-06 23:17:59', 1.7),
    ('2021-11-07 00:40:34', 2.7),
    ('2021-11-07 05:05:09', 3.7),
    ('2021-11-07 09:15:49', 4.7),
    ('2021-11-07 09:52:59', 5.7),
    ('2021-11-07 10:08:44', 6.7),
    ('2021-11-07 10:33:04', 7.7),
    ('2021-11-07 11:09:44', 8.8),
    ('2021-11-07 11:20:44', 9.8),
    ('2021-11-07 11:42:14', 10.8),
    ('2021-11-07 12:13:09', 11.8),
    ('2021-11-07 12:44:44', 10.8),
    ('2021-11-07 14:37:54', 9.8),
    ('2021-11-07 17:20:44', 8.8),
    ('2021-11-07 19:02:29', 7.8),
    ('2021-11-08 05:38:44', 6.8),
    ('2021-11-08 06:46:54', 5.8),
    ('2021-11-08 08:31:09', 6.8),
    ('2021-11-08 09:27:09', 7.8),
    ('2021-11-08 10:02:54', 8.8),
    ('2021-11-08 10:52:04', 9.8),
    ('2021-11-08 11:13:54', 10.8),
    ('2021-11-08 11:25:04', 11.8),
    ('2021-11-08 11:29:19', 12.8),
    ('2021-11-08 11:42:09', 11.8),
    ('2021-11-08 12:20:24', 10.8),
    ('2021-11-08 13:36:29', 11.8),
    ('2021-11-08 14:18:39', 10.8),
    ('2021-11-08 15:39:04', 9.8),
    ('2021-11-08 16:26:54', 8.8),
    ('2021-11-08 16:53:34', 7.8),
    ('2021-11-08 17:20:29', 6.8),
    ('2021-11-08 18:14:44', 5.8),
    ('2021-11-08 19:42:59', 4.8),
    ('2021-11-08 20:59:45', 3.8),
    ('2021-11-08 22:57:00', 2.8),
    ('2021-11-09 01:46:24', 1.7),
    ('2021-11-09 07:42:49', 2.7),
    ('2021-11-09 09:11:29', 3.7),
    ('2021-11-09 09:56:24', 4.7),
    ('2021-11-09 10:43:29', 5.7),
    ('2021-11-09 11:13:34', 6.7),
    ('2021-11-09 11:58:29', 7.7),
    ('2021-11-09 13:55:04', 8.8),
    ('2021-11-09 16:15:52', 7.8),
    ('2021-11-09 16:47:17', 6.8),
    ('2021-11-09 17:44:42', 5.8),
    ('2021-11-09 19:03:34', 4.8),
    ('2021-11-09 23:30:13', 3.8),
    ('2021-11-10 01:39:18', 2.8),
    ('2021-11-10 09:22:48', 3.8),
    ('2021-11-10 10:05:33', 4.8),
    ('2021-11-10 10:46:33', 5.8),
    ('2021-11-10 11:13:18', 6.8),
    ('2021-11-10 12:10:33', 7.8),
    ('2021-11-10 13:26:43', 8.8),
    ('2021-11-10 15:59:18', 7.8),
    ('2021-11-10 16:51:48', 6.8);
dougwilson commented 3 years ago

Hello, and sorry you are having trouble. Thank you very much for providing all that information to reproduce. Unless I am missing something, you will be able to see by my steps below that this module produces the exact same results as the official Oracle MySQL CLI program, indicating that if there you are seeing a difference, it may be an issue with HeidiSQL rather than this module.

I don't have any additional context to know if these are the results you are expecting or not, but they are the results those queries provided return for the provided data set.

$ mysql -uroot -pmysql-test
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE test;
Query OK, 1 row affected (0.00 sec)

mysql> USE test;
Database changed
mysql> CREATE TABLE IF NOT EXISTS `temp_winterthur_ext` (
    ->   `time` datetime NOT NULL,
    ->   `value` float DEFAULT NULL,
    ->   PRIMARY KEY (`time`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO `temp_winterthur_ext` (`time`, `value`) VALUES
    -> ('2021-03-17 15:52:33', 4.9),
    -> ('2021-03-19 19:31:23', 3.3),
    -> ('2021-03-19 19:32:19', 3.3),
    -> ('2021-10-24 14:16:10', 9.5),
    -> ('2021-10-24 15:06:46', 14.1),
    -> ('2021-10-24 15:06:47', 9.5),
    -> ('2021-10-24 15:15:37', 9.5),
    -> ('2021-10-24 15:15:38', 14.1),
    -> ('2021-10-24 15:16:33', 9.5),
    -> ('2021-10-24 15:59:32', 10.5),
    -> ('2021-10-24 15:59:33', 13.1),
    -> ('2021-10-24 18:25:20', 10.1),
    -> ('2021-10-24 18:35:30', 8.5),
    -> ('2021-10-24 19:10:05', 7.5),
    -> ('2021-10-24 19:57:57', 6.5),
    -> ('2021-10-24 21:06:42', 5.5),
    -> ('2021-10-24 22:41:02', 4.5),
    -> ('2021-10-25 11:12:24', 7.5),
    -> ('2021-10-25 11:16:12', 8.5),
    -> ('2021-10-25 17:00:49', 14.5),
    -> ('2021-10-25 17:49:57', 13.5),
    -> ('2021-10-25 18:11:42', 12.5),
    -> ('2021-10-25 18:29:07', 11.5),
    -> ('2021-10-25 18:56:02', 10.5),
    -> ('2021-10-25 19:35:02', 9.5),
    -> ('2021-10-25 20:02:52', 8.5),
    -> ('2021-10-25 20:56:33', 7.5),
    -> ('2021-10-25 22:08:35', 6.5),
    -> ('2021-10-26 00:36:50', 5.5),
    -> ('2021-10-26 05:53:51', 6.5),
    -> ('2021-10-26 09:02:07', 7.5),
    -> ('2021-10-26 09:34:08', 8.5),
    -> ('2021-10-26 10:08:33', 9.5),
    -> ('2021-10-26 10:17:38', 10.5),
    -> ('2021-10-26 10:58:43', 11.5),
    -> ('2021-10-26 11:18:53', 12.5),
    -> ('2021-10-26 13:44:39', 14.5),
    -> ('2021-10-26 17:55:11', 12.5),
    -> ('2021-10-26 18:19:21', 11.5),
    -> ('2021-10-26 19:25:31', 10.5),
    -> ('2021-10-26 19:55:46', 9.5),
    -> ('2021-10-26 21:02:26', 8.5),
    -> ('2021-10-26 22:19:11', 7.5),
    -> ('2021-10-27 00:05:36', 6.5),
    -> ('2021-10-27 01:58:31', 5.5),
    -> ('2021-10-27 03:55:26', 6.5),
    -> ('2021-10-27 09:02:36', 7.5),
    -> ('2021-10-27 10:07:26', 8.5),
    -> ('2021-10-27 10:57:11', 9.5),
    -> ('2021-10-27 12:46:16', 10.5),
    -> ('2021-10-27 13:26:01', 11.5),
    -> ('2021-10-27 14:06:16', 12.5),
    -> ('2021-10-27 17:45:26', 11.5),
    -> ('2021-10-27 18:10:51', 10.5),
    -> ('2021-10-27 18:44:56', 9.5),
    -> ('2021-10-27 19:34:51', 8.5),
    -> ('2021-10-27 20:41:41', 7.5),
    -> ('2021-10-27 21:59:06', 6.5),
    -> ('2021-10-27 23:46:06', 5.5),
    -> ('2021-10-28 03:08:26', 6.5),
    -> ('2021-10-28 08:57:51', 7.5),
    -> ('2021-10-28 09:55:56', 8.5),
    -> ('2021-10-28 11:24:46', 9.5),
    -> ('2021-10-28 11:49:16', 10.5),
    -> ('2021-10-28 12:22:16', 11.5),
    -> ('2021-10-28 12:39:01', 12.5),
    -> ('2021-10-28 12:53:31', 13.5),
    -> ('2021-10-28 13:32:41', 12.5),
    -> ('2021-10-28 17:15:01', 11.5),
    -> ('2021-10-28 17:47:31', 10.5),
    -> ('2021-10-28 18:13:06', 9.5),
    -> ('2021-10-28 18:48:26', 8.5),
    -> ('2021-10-28 19:51:26', 7.5),
    -> ('2021-10-28 21:05:36', 6.5),
    -> ('2021-10-28 22:35:01', 5.5),
    -> ('2021-10-29 00:01:22', 6.5),
    -> ('2021-10-29 09:49:33', 7.5),
    -> ('2021-10-29 12:34:13', 8.5),
    -> ('2021-10-29 13:25:33', 9.5),
    -> ('2021-10-29 14:11:53', 10.5),
    -> ('2021-10-29 15:03:43', 11.5),
    -> ('2021-10-29 16:38:23', 10.5),
    -> ('2021-10-29 17:27:03', 9.5),
    -> ('2021-10-29 18:27:23', 8.5),
    -> ('2021-10-29 21:14:39', 7.5),
    -> ('2021-10-30 04:30:19', 6.5),
    -> ('2021-10-30 12:13:09', 7.5),
    -> ('2021-10-30 14:33:55', 8.5),
    -> ('2021-10-30 16:09:17', 9.5),
    -> ('2021-10-30 23:46:00', 8.5),
    -> ('2021-10-31 08:52:25', 9.5),
    -> ('2021-10-31 09:21:30', 10.5),
    -> ('2021-10-31 10:24:30', 11.5),
    -> ('2021-10-31 10:34:35', 12.5),
    -> ('2021-10-31 10:44:00', 13.5),
    -> ('2021-10-31 10:59:55', 14.5),
    -> ('2021-10-31 11:35:10', 15.5),
    -> ('2021-10-31 13:26:20', 16.5),
    -> ('2021-10-31 15:58:55', 15.5),
    -> ('2021-10-31 16:40:00', 14.5),
    -> ('2021-10-31 17:08:55', 13.5),
    -> ('2021-10-31 17:42:40', 12.5),
    -> ('2021-10-31 18:30:45', 11.5),
    -> ('2021-10-31 19:44:15', 10.5),
    -> ('2021-10-31 21:01:45', 9.5),
    -> ('2021-10-31 22:41:05', 8.5),
    -> ('2021-11-01 01:03:15', 9.5),
    -> ('2021-11-01 04:44:10', 10.5),
    -> ('2021-11-01 07:28:40', 9.5),
    -> ('2021-11-01 11:21:35', 10.5),
    -> ('2021-11-01 19:14:20', 9.5),
    -> ('2021-11-01 20:03:45', 8.5),
    -> ('2021-11-01 22:52:10', 7.5),
    -> ('2021-11-02 04:18:46', 6.5),
    -> ('2021-11-02 09:51:21', 7.5),
    -> ('2021-11-02 10:40:46', 8.5),
    -> ('2021-11-02 11:34:26', 9.5),
    -> ('2021-11-02 12:23:36', 8.5),
    -> ('2021-11-02 13:02:56', 9.5),
    -> ('2021-11-02 17:14:16', 8.5),
    -> ('2021-11-02 17:58:06', 7.5),
    -> ('2021-11-02 18:54:26', 6.5),
    -> ('2021-11-02 20:13:41', 5.5),
    -> ('2021-11-02 22:29:16', 4.5),
    -> ('2021-11-03 06:18:32', 5.5),
    -> ('2021-11-03 08:53:32', 6.5),
    -> ('2021-11-03 09:34:06', 7.5),
    -> ('2021-11-03 09:54:22', 8.5),
    -> ('2021-11-03 10:13:32', 9.5),
    -> ('2021-11-03 11:09:37', 10.5),
    -> ('2021-11-03 12:27:22', 9.5),
    -> ('2021-11-03 12:56:32', 8.5),
    -> ('2021-11-03 17:25:07', 7.5),
    -> ('2021-11-04 01:01:15', 6.5),
    -> ('2021-11-04 06:54:20', 5.5),
    -> ('2021-11-04 09:42:10', 6.5),
    -> ('2021-11-04 11:33:10', 7.5),
    -> ('2021-11-04 11:57:00', 8.5),
    -> ('2021-11-04 13:21:00', 7.5),
    -> ('2021-11-04 15:26:25', 6.5),
    -> ('2021-11-04 15:34:55', 5.5),
    -> ('2021-11-04 17:48:15', 4.5),
    -> ('2021-11-05 06:00:48', 4.8),
    -> ('2021-11-05 07:50:18', 5.8),
    -> ('2021-11-05 08:58:58', 6.8),
    -> ('2021-11-05 09:34:58', 7.8),
    -> ('2021-11-05 10:07:43', 8.8),
    -> ('2021-11-05 10:42:08', 9.8),
    -> ('2021-11-05 11:14:53', 10.8),
    -> ('2021-11-05 14:46:58', 9.8),
    -> ('2021-11-05 16:12:43', 8.8),
    -> ('2021-11-05 16:36:28', 7.8),
    -> ('2021-11-05 17:07:23', 6.8),
    -> ('2021-11-05 17:48:44', 5.8),
    -> ('2021-11-05 19:13:08', 4.8),
    -> ('2021-11-05 20:33:18', 3.8),
    -> ('2021-11-05 22:32:49', 2.8),
    -> ('2021-11-06 05:41:38', 3.8),
    -> ('2021-11-06 07:18:18', 4.8),
    -> ('2021-11-06 08:35:08', 5.8),
    -> ('2021-11-06 09:32:23', 6.8),
    -> ('2021-11-06 10:43:58', 7.8),
    -> ('2021-11-06 10:49:24', 8.8),
    -> ('2021-11-06 11:06:08', 9.8),
    -> ('2021-11-06 11:28:53', 10.8),
    -> ('2021-11-06 14:38:23', 9.8),
    -> ('2021-11-06 16:13:39', 8.8),
    -> ('2021-11-06 16:40:09', 7.8),
    -> ('2021-11-06 17:09:59', 6.8),
    -> ('2021-11-06 17:40:34', 5.8),
    -> ('2021-11-06 18:29:58', 4.8),
    -> ('2021-11-06 19:35:48', 3.8),
    -> ('2021-11-06 21:11:09', 2.8),
    -> ('2021-11-06 23:17:59', 1.7),
    -> ('2021-11-07 00:40:34', 2.7),
    -> ('2021-11-07 05:05:09', 3.7),
    -> ('2021-11-07 09:15:49', 4.7),
    -> ('2021-11-07 09:52:59', 5.7),
    -> ('2021-11-07 10:08:44', 6.7),
    -> ('2021-11-07 10:33:04', 7.7),
    -> ('2021-11-07 11:09:44', 8.8),
    -> ('2021-11-07 11:20:44', 9.8),
    -> ('2021-11-07 11:42:14', 10.8),
    -> ('2021-11-07 12:13:09', 11.8),
    -> ('2021-11-07 12:44:44', 10.8),
    -> ('2021-11-07 14:37:54', 9.8),
    -> ('2021-11-07 17:20:44', 8.8),
    -> ('2021-11-07 19:02:29', 7.8),
    -> ('2021-11-08 05:38:44', 6.8),
    -> ('2021-11-08 06:46:54', 5.8),
    -> ('2021-11-08 08:31:09', 6.8),
    -> ('2021-11-08 09:27:09', 7.8),
    -> ('2021-11-08 10:02:54', 8.8),
    -> ('2021-11-08 10:52:04', 9.8),
    -> ('2021-11-08 11:13:54', 10.8),
    -> ('2021-11-08 11:25:04', 11.8),
    -> ('2021-11-08 11:29:19', 12.8),
    -> ('2021-11-08 11:42:09', 11.8),
    -> ('2021-11-08 12:20:24', 10.8),
    -> ('2021-11-08 13:36:29', 11.8),
    -> ('2021-11-08 14:18:39', 10.8),
    -> ('2021-11-08 15:39:04', 9.8),
    -> ('2021-11-08 16:26:54', 8.8),
    -> ('2021-11-08 16:53:34', 7.8),
    -> ('2021-11-08 17:20:29', 6.8),
    -> ('2021-11-08 18:14:44', 5.8),
    -> ('2021-11-08 19:42:59', 4.8),
    -> ('2021-11-08 20:59:45', 3.8),
    -> ('2021-11-08 22:57:00', 2.8),
    -> ('2021-11-09 01:46:24', 1.7),
    -> ('2021-11-09 07:42:49', 2.7),
    -> ('2021-11-09 09:11:29', 3.7),
    -> ('2021-11-09 09:56:24', 4.7),
    -> ('2021-11-09 10:43:29', 5.7),
    -> ('2021-11-09 11:13:34', 6.7),
    -> ('2021-11-09 11:58:29', 7.7),
    -> ('2021-11-09 13:55:04', 8.8),
    -> ('2021-11-09 16:15:52', 7.8),
    -> ('2021-11-09 16:47:17', 6.8),
    -> ('2021-11-09 17:44:42', 5.8),
    -> ('2021-11-09 19:03:34', 4.8),
    -> ('2021-11-09 23:30:13', 3.8),
    -> ('2021-11-10 01:39:18', 2.8),
    -> ('2021-11-10 09:22:48', 3.8),
    -> ('2021-11-10 10:05:33', 4.8),
    -> ('2021-11-10 10:46:33', 5.8),
    -> ('2021-11-10 11:13:18', 6.8),
    -> ('2021-11-10 12:10:33', 7.8),
    -> ('2021-11-10 13:26:43', 8.8),
    -> ('2021-11-10 15:59:18', 7.8),
    -> ('2021-11-10 16:51:48', 6.8);
Query OK, 231 rows affected (0.01 sec)
Records: 231  Duplicates: 0  Warnings: 0

mysql> SELECT * from temp_winterthur_ext;
+---------------------+-------+
| time                | value |
+---------------------+-------+
| 2021-03-17 15:52:33 |   4.9 |
| 2021-03-19 19:31:23 |   3.3 |
| 2021-03-19 19:32:19 |   3.3 |
| 2021-10-24 14:16:10 |   9.5 |
| 2021-10-24 15:06:46 |  14.1 |
| 2021-10-24 15:06:47 |   9.5 |
| 2021-10-24 15:15:37 |   9.5 |
| 2021-10-24 15:15:38 |  14.1 |
| 2021-10-24 15:16:33 |   9.5 |
| 2021-10-24 15:59:32 |  10.5 |
| 2021-10-24 15:59:33 |  13.1 |
| 2021-10-24 18:25:20 |  10.1 |
| 2021-10-24 18:35:30 |   8.5 |
| 2021-10-24 19:10:05 |   7.5 |
| 2021-10-24 19:57:57 |   6.5 |
| 2021-10-24 21:06:42 |   5.5 |
| 2021-10-24 22:41:02 |   4.5 |
| 2021-10-25 11:12:24 |   7.5 |
| 2021-10-25 11:16:12 |   8.5 |
| 2021-10-25 17:00:49 |  14.5 |
| 2021-10-25 17:49:57 |  13.5 |
| 2021-10-25 18:11:42 |  12.5 |
| 2021-10-25 18:29:07 |  11.5 |
| 2021-10-25 18:56:02 |  10.5 |
| 2021-10-25 19:35:02 |   9.5 |
| 2021-10-25 20:02:52 |   8.5 |
| 2021-10-25 20:56:33 |   7.5 |
| 2021-10-25 22:08:35 |   6.5 |
| 2021-10-26 00:36:50 |   5.5 |
| 2021-10-26 05:53:51 |   6.5 |
| 2021-10-26 09:02:07 |   7.5 |
| 2021-10-26 09:34:08 |   8.5 |
| 2021-10-26 10:08:33 |   9.5 |
| 2021-10-26 10:17:38 |  10.5 |
| 2021-10-26 10:58:43 |  11.5 |
| 2021-10-26 11:18:53 |  12.5 |
| 2021-10-26 13:44:39 |  14.5 |
| 2021-10-26 17:55:11 |  12.5 |
| 2021-10-26 18:19:21 |  11.5 |
| 2021-10-26 19:25:31 |  10.5 |
| 2021-10-26 19:55:46 |   9.5 |
| 2021-10-26 21:02:26 |   8.5 |
| 2021-10-26 22:19:11 |   7.5 |
| 2021-10-27 00:05:36 |   6.5 |
| 2021-10-27 01:58:31 |   5.5 |
| 2021-10-27 03:55:26 |   6.5 |
| 2021-10-27 09:02:36 |   7.5 |
| 2021-10-27 10:07:26 |   8.5 |
| 2021-10-27 10:57:11 |   9.5 |
| 2021-10-27 12:46:16 |  10.5 |
| 2021-10-27 13:26:01 |  11.5 |
| 2021-10-27 14:06:16 |  12.5 |
| 2021-10-27 17:45:26 |  11.5 |
| 2021-10-27 18:10:51 |  10.5 |
| 2021-10-27 18:44:56 |   9.5 |
| 2021-10-27 19:34:51 |   8.5 |
| 2021-10-27 20:41:41 |   7.5 |
| 2021-10-27 21:59:06 |   6.5 |
| 2021-10-27 23:46:06 |   5.5 |
| 2021-10-28 03:08:26 |   6.5 |
| 2021-10-28 08:57:51 |   7.5 |
| 2021-10-28 09:55:56 |   8.5 |
| 2021-10-28 11:24:46 |   9.5 |
| 2021-10-28 11:49:16 |  10.5 |
| 2021-10-28 12:22:16 |  11.5 |
| 2021-10-28 12:39:01 |  12.5 |
| 2021-10-28 12:53:31 |  13.5 |
| 2021-10-28 13:32:41 |  12.5 |
| 2021-10-28 17:15:01 |  11.5 |
| 2021-10-28 17:47:31 |  10.5 |
| 2021-10-28 18:13:06 |   9.5 |
| 2021-10-28 18:48:26 |   8.5 |
| 2021-10-28 19:51:26 |   7.5 |
| 2021-10-28 21:05:36 |   6.5 |
| 2021-10-28 22:35:01 |   5.5 |
| 2021-10-29 00:01:22 |   6.5 |
| 2021-10-29 09:49:33 |   7.5 |
| 2021-10-29 12:34:13 |   8.5 |
| 2021-10-29 13:25:33 |   9.5 |
| 2021-10-29 14:11:53 |  10.5 |
| 2021-10-29 15:03:43 |  11.5 |
| 2021-10-29 16:38:23 |  10.5 |
| 2021-10-29 17:27:03 |   9.5 |
| 2021-10-29 18:27:23 |   8.5 |
| 2021-10-29 21:14:39 |   7.5 |
| 2021-10-30 04:30:19 |   6.5 |
| 2021-10-30 12:13:09 |   7.5 |
| 2021-10-30 14:33:55 |   8.5 |
| 2021-10-30 16:09:17 |   9.5 |
| 2021-10-30 23:46:00 |   8.5 |
| 2021-10-31 08:52:25 |   9.5 |
| 2021-10-31 09:21:30 |  10.5 |
| 2021-10-31 10:24:30 |  11.5 |
| 2021-10-31 10:34:35 |  12.5 |
| 2021-10-31 10:44:00 |  13.5 |
| 2021-10-31 10:59:55 |  14.5 |
| 2021-10-31 11:35:10 |  15.5 |
| 2021-10-31 13:26:20 |  16.5 |
| 2021-10-31 15:58:55 |  15.5 |
| 2021-10-31 16:40:00 |  14.5 |
| 2021-10-31 17:08:55 |  13.5 |
| 2021-10-31 17:42:40 |  12.5 |
| 2021-10-31 18:30:45 |  11.5 |
| 2021-10-31 19:44:15 |  10.5 |
| 2021-10-31 21:01:45 |   9.5 |
| 2021-10-31 22:41:05 |   8.5 |
| 2021-11-01 01:03:15 |   9.5 |
| 2021-11-01 04:44:10 |  10.5 |
| 2021-11-01 07:28:40 |   9.5 |
| 2021-11-01 11:21:35 |  10.5 |
| 2021-11-01 19:14:20 |   9.5 |
| 2021-11-01 20:03:45 |   8.5 |
| 2021-11-01 22:52:10 |   7.5 |
| 2021-11-02 04:18:46 |   6.5 |
| 2021-11-02 09:51:21 |   7.5 |
| 2021-11-02 10:40:46 |   8.5 |
| 2021-11-02 11:34:26 |   9.5 |
| 2021-11-02 12:23:36 |   8.5 |
| 2021-11-02 13:02:56 |   9.5 |
| 2021-11-02 17:14:16 |   8.5 |
| 2021-11-02 17:58:06 |   7.5 |
| 2021-11-02 18:54:26 |   6.5 |
| 2021-11-02 20:13:41 |   5.5 |
| 2021-11-02 22:29:16 |   4.5 |
| 2021-11-03 06:18:32 |   5.5 |
| 2021-11-03 08:53:32 |   6.5 |
| 2021-11-03 09:34:06 |   7.5 |
| 2021-11-03 09:54:22 |   8.5 |
| 2021-11-03 10:13:32 |   9.5 |
| 2021-11-03 11:09:37 |  10.5 |
| 2021-11-03 12:27:22 |   9.5 |
| 2021-11-03 12:56:32 |   8.5 |
| 2021-11-03 17:25:07 |   7.5 |
| 2021-11-04 01:01:15 |   6.5 |
| 2021-11-04 06:54:20 |   5.5 |
| 2021-11-04 09:42:10 |   6.5 |
| 2021-11-04 11:33:10 |   7.5 |
| 2021-11-04 11:57:00 |   8.5 |
| 2021-11-04 13:21:00 |   7.5 |
| 2021-11-04 15:26:25 |   6.5 |
| 2021-11-04 15:34:55 |   5.5 |
| 2021-11-04 17:48:15 |   4.5 |
| 2021-11-05 06:00:48 |   4.8 |
| 2021-11-05 07:50:18 |   5.8 |
| 2021-11-05 08:58:58 |   6.8 |
| 2021-11-05 09:34:58 |   7.8 |
| 2021-11-05 10:07:43 |   8.8 |
| 2021-11-05 10:42:08 |   9.8 |
| 2021-11-05 11:14:53 |  10.8 |
| 2021-11-05 14:46:58 |   9.8 |
| 2021-11-05 16:12:43 |   8.8 |
| 2021-11-05 16:36:28 |   7.8 |
| 2021-11-05 17:07:23 |   6.8 |
| 2021-11-05 17:48:44 |   5.8 |
| 2021-11-05 19:13:08 |   4.8 |
| 2021-11-05 20:33:18 |   3.8 |
| 2021-11-05 22:32:49 |   2.8 |
| 2021-11-06 05:41:38 |   3.8 |
| 2021-11-06 07:18:18 |   4.8 |
| 2021-11-06 08:35:08 |   5.8 |
| 2021-11-06 09:32:23 |   6.8 |
| 2021-11-06 10:43:58 |   7.8 |
| 2021-11-06 10:49:24 |   8.8 |
| 2021-11-06 11:06:08 |   9.8 |
| 2021-11-06 11:28:53 |  10.8 |
| 2021-11-06 14:38:23 |   9.8 |
| 2021-11-06 16:13:39 |   8.8 |
| 2021-11-06 16:40:09 |   7.8 |
| 2021-11-06 17:09:59 |   6.8 |
| 2021-11-06 17:40:34 |   5.8 |
| 2021-11-06 18:29:58 |   4.8 |
| 2021-11-06 19:35:48 |   3.8 |
| 2021-11-06 21:11:09 |   2.8 |
| 2021-11-06 23:17:59 |   1.7 |
| 2021-11-07 00:40:34 |   2.7 |
| 2021-11-07 05:05:09 |   3.7 |
| 2021-11-07 09:15:49 |   4.7 |
| 2021-11-07 09:52:59 |   5.7 |
| 2021-11-07 10:08:44 |   6.7 |
| 2021-11-07 10:33:04 |   7.7 |
| 2021-11-07 11:09:44 |   8.8 |
| 2021-11-07 11:20:44 |   9.8 |
| 2021-11-07 11:42:14 |  10.8 |
| 2021-11-07 12:13:09 |  11.8 |
| 2021-11-07 12:44:44 |  10.8 |
| 2021-11-07 14:37:54 |   9.8 |
| 2021-11-07 17:20:44 |   8.8 |
| 2021-11-07 19:02:29 |   7.8 |
| 2021-11-08 05:38:44 |   6.8 |
| 2021-11-08 06:46:54 |   5.8 |
| 2021-11-08 08:31:09 |   6.8 |
| 2021-11-08 09:27:09 |   7.8 |
| 2021-11-08 10:02:54 |   8.8 |
| 2021-11-08 10:52:04 |   9.8 |
| 2021-11-08 11:13:54 |  10.8 |
| 2021-11-08 11:25:04 |  11.8 |
| 2021-11-08 11:29:19 |  12.8 |
| 2021-11-08 11:42:09 |  11.8 |
| 2021-11-08 12:20:24 |  10.8 |
| 2021-11-08 13:36:29 |  11.8 |
| 2021-11-08 14:18:39 |  10.8 |
| 2021-11-08 15:39:04 |   9.8 |
| 2021-11-08 16:26:54 |   8.8 |
| 2021-11-08 16:53:34 |   7.8 |
| 2021-11-08 17:20:29 |   6.8 |
| 2021-11-08 18:14:44 |   5.8 |
| 2021-11-08 19:42:59 |   4.8 |
| 2021-11-08 20:59:45 |   3.8 |
| 2021-11-08 22:57:00 |   2.8 |
| 2021-11-09 01:46:24 |   1.7 |
| 2021-11-09 07:42:49 |   2.7 |
| 2021-11-09 09:11:29 |   3.7 |
| 2021-11-09 09:56:24 |   4.7 |
| 2021-11-09 10:43:29 |   5.7 |
| 2021-11-09 11:13:34 |   6.7 |
| 2021-11-09 11:58:29 |   7.7 |
| 2021-11-09 13:55:04 |   8.8 |
| 2021-11-09 16:15:52 |   7.8 |
| 2021-11-09 16:47:17 |   6.8 |
| 2021-11-09 17:44:42 |   5.8 |
| 2021-11-09 19:03:34 |   4.8 |
| 2021-11-09 23:30:13 |   3.8 |
| 2021-11-10 01:39:18 |   2.8 |
| 2021-11-10 09:22:48 |   3.8 |
| 2021-11-10 10:05:33 |   4.8 |
| 2021-11-10 10:46:33 |   5.8 |
| 2021-11-10 11:13:18 |   6.8 |
| 2021-11-10 12:10:33 |   7.8 |
| 2021-11-10 13:26:43 |   8.8 |
| 2021-11-10 15:59:18 |   7.8 |
| 2021-11-10 16:51:48 |   6.8 |
+---------------------+-------+
231 rows in set (0.00 sec)

mysql> SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT DATE(`time`), min(value), max(value) from temp_winterthur_ext group by DAY(`time`) ORDER BY DATE(`time`);
+--------------+------------+------------+
| DATE(`time`) | min(value) | max(value) |
+--------------+------------+------------+
| 2021-03-17   |        4.9 |        4.9 |
| 2021-03-19   |        3.3 |        3.3 |
| 2021-10-24   |        4.5 |       14.1 |
| 2021-10-25   |        6.5 |       14.5 |
| 2021-10-26   |        5.5 |       14.5 |
| 2021-10-27   |        5.5 |       12.5 |
| 2021-10-28   |        5.5 |       13.5 |
| 2021-10-29   |        6.5 |       11.5 |
| 2021-10-30   |        6.5 |        9.5 |
| 2021-10-31   |        8.5 |       16.5 |
| 2021-11-01   |        7.5 |       10.5 |
| 2021-11-02   |        4.5 |        9.5 |
| 2021-11-03   |        5.5 |       10.5 |
| 2021-11-04   |        4.5 |        8.5 |
| 2021-11-05   |        2.8 |       10.8 |
| 2021-11-06   |        1.7 |       10.8 |
| 2021-11-07   |        2.7 |       11.8 |
| 2021-11-08   |        2.8 |       12.8 |
| 2021-11-09   |        1.7 |        8.8 |
| 2021-11-10   |        2.8 |        8.8 |
+--------------+------------+------------+
20 rows in set (0.00 sec)

mysql> ^DBye

$ node test.js 
All records [
  RowDataPacket { time: '2021-03-17 15:52:33', value: 4.9 },
  RowDataPacket { time: '2021-03-19 19:31:23', value: 3.3 },
  RowDataPacket { time: '2021-03-19 19:32:19', value: 3.3 },
  RowDataPacket { time: '2021-10-24 14:16:10', value: 9.5 },
  RowDataPacket { time: '2021-10-24 15:06:46', value: 14.1 },
  RowDataPacket { time: '2021-10-24 15:06:47', value: 9.5 },
  RowDataPacket { time: '2021-10-24 15:15:37', value: 9.5 },
  RowDataPacket { time: '2021-10-24 15:15:38', value: 14.1 },
  RowDataPacket { time: '2021-10-24 15:16:33', value: 9.5 },
  RowDataPacket { time: '2021-10-24 15:59:32', value: 10.5 },
  RowDataPacket { time: '2021-10-24 15:59:33', value: 13.1 },
  RowDataPacket { time: '2021-10-24 18:25:20', value: 10.1 },
  RowDataPacket { time: '2021-10-24 18:35:30', value: 8.5 },
  RowDataPacket { time: '2021-10-24 19:10:05', value: 7.5 },
  RowDataPacket { time: '2021-10-24 19:57:57', value: 6.5 },
  RowDataPacket { time: '2021-10-24 21:06:42', value: 5.5 },
  RowDataPacket { time: '2021-10-24 22:41:02', value: 4.5 },
  RowDataPacket { time: '2021-10-25 11:12:24', value: 7.5 },
  RowDataPacket { time: '2021-10-25 11:16:12', value: 8.5 },
  RowDataPacket { time: '2021-10-25 17:00:49', value: 14.5 },
  RowDataPacket { time: '2021-10-25 17:49:57', value: 13.5 },
  RowDataPacket { time: '2021-10-25 18:11:42', value: 12.5 },
  RowDataPacket { time: '2021-10-25 18:29:07', value: 11.5 },
  RowDataPacket { time: '2021-10-25 18:56:02', value: 10.5 },
  RowDataPacket { time: '2021-10-25 19:35:02', value: 9.5 },
  RowDataPacket { time: '2021-10-25 20:02:52', value: 8.5 },
  RowDataPacket { time: '2021-10-25 20:56:33', value: 7.5 },
  RowDataPacket { time: '2021-10-25 22:08:35', value: 6.5 },
  RowDataPacket { time: '2021-10-26 00:36:50', value: 5.5 },
  RowDataPacket { time: '2021-10-26 05:53:51', value: 6.5 },
  RowDataPacket { time: '2021-10-26 09:02:07', value: 7.5 },
  RowDataPacket { time: '2021-10-26 09:34:08', value: 8.5 },
  RowDataPacket { time: '2021-10-26 10:08:33', value: 9.5 },
  RowDataPacket { time: '2021-10-26 10:17:38', value: 10.5 },
  RowDataPacket { time: '2021-10-26 10:58:43', value: 11.5 },
  RowDataPacket { time: '2021-10-26 11:18:53', value: 12.5 },
  RowDataPacket { time: '2021-10-26 13:44:39', value: 14.5 },
  RowDataPacket { time: '2021-10-26 17:55:11', value: 12.5 },
  RowDataPacket { time: '2021-10-26 18:19:21', value: 11.5 },
  RowDataPacket { time: '2021-10-26 19:25:31', value: 10.5 },
  RowDataPacket { time: '2021-10-26 19:55:46', value: 9.5 },
  RowDataPacket { time: '2021-10-26 21:02:26', value: 8.5 },
  RowDataPacket { time: '2021-10-26 22:19:11', value: 7.5 },
  RowDataPacket { time: '2021-10-27 00:05:36', value: 6.5 },
  RowDataPacket { time: '2021-10-27 01:58:31', value: 5.5 },
  RowDataPacket { time: '2021-10-27 03:55:26', value: 6.5 },
  RowDataPacket { time: '2021-10-27 09:02:36', value: 7.5 },
  RowDataPacket { time: '2021-10-27 10:07:26', value: 8.5 },
  RowDataPacket { time: '2021-10-27 10:57:11', value: 9.5 },
  RowDataPacket { time: '2021-10-27 12:46:16', value: 10.5 },
  RowDataPacket { time: '2021-10-27 13:26:01', value: 11.5 },
  RowDataPacket { time: '2021-10-27 14:06:16', value: 12.5 },
  RowDataPacket { time: '2021-10-27 17:45:26', value: 11.5 },
  RowDataPacket { time: '2021-10-27 18:10:51', value: 10.5 },
  RowDataPacket { time: '2021-10-27 18:44:56', value: 9.5 },
  RowDataPacket { time: '2021-10-27 19:34:51', value: 8.5 },
  RowDataPacket { time: '2021-10-27 20:41:41', value: 7.5 },
  RowDataPacket { time: '2021-10-27 21:59:06', value: 6.5 },
  RowDataPacket { time: '2021-10-27 23:46:06', value: 5.5 },
  RowDataPacket { time: '2021-10-28 03:08:26', value: 6.5 },
  RowDataPacket { time: '2021-10-28 08:57:51', value: 7.5 },
  RowDataPacket { time: '2021-10-28 09:55:56', value: 8.5 },
  RowDataPacket { time: '2021-10-28 11:24:46', value: 9.5 },
  RowDataPacket { time: '2021-10-28 11:49:16', value: 10.5 },
  RowDataPacket { time: '2021-10-28 12:22:16', value: 11.5 },
  RowDataPacket { time: '2021-10-28 12:39:01', value: 12.5 },
  RowDataPacket { time: '2021-10-28 12:53:31', value: 13.5 },
  RowDataPacket { time: '2021-10-28 13:32:41', value: 12.5 },
  RowDataPacket { time: '2021-10-28 17:15:01', value: 11.5 },
  RowDataPacket { time: '2021-10-28 17:47:31', value: 10.5 },
  RowDataPacket { time: '2021-10-28 18:13:06', value: 9.5 },
  RowDataPacket { time: '2021-10-28 18:48:26', value: 8.5 },
  RowDataPacket { time: '2021-10-28 19:51:26', value: 7.5 },
  RowDataPacket { time: '2021-10-28 21:05:36', value: 6.5 },
  RowDataPacket { time: '2021-10-28 22:35:01', value: 5.5 },
  RowDataPacket { time: '2021-10-29 00:01:22', value: 6.5 },
  RowDataPacket { time: '2021-10-29 09:49:33', value: 7.5 },
  RowDataPacket { time: '2021-10-29 12:34:13', value: 8.5 },
  RowDataPacket { time: '2021-10-29 13:25:33', value: 9.5 },
  RowDataPacket { time: '2021-10-29 14:11:53', value: 10.5 },
  RowDataPacket { time: '2021-10-29 15:03:43', value: 11.5 },
  RowDataPacket { time: '2021-10-29 16:38:23', value: 10.5 },
  RowDataPacket { time: '2021-10-29 17:27:03', value: 9.5 },
  RowDataPacket { time: '2021-10-29 18:27:23', value: 8.5 },
  RowDataPacket { time: '2021-10-29 21:14:39', value: 7.5 },
  RowDataPacket { time: '2021-10-30 04:30:19', value: 6.5 },
  RowDataPacket { time: '2021-10-30 12:13:09', value: 7.5 },
  RowDataPacket { time: '2021-10-30 14:33:55', value: 8.5 },
  RowDataPacket { time: '2021-10-30 16:09:17', value: 9.5 },
  RowDataPacket { time: '2021-10-30 23:46:00', value: 8.5 },
  RowDataPacket { time: '2021-10-31 08:52:25', value: 9.5 },
  RowDataPacket { time: '2021-10-31 09:21:30', value: 10.5 },
  RowDataPacket { time: '2021-10-31 10:24:30', value: 11.5 },
  RowDataPacket { time: '2021-10-31 10:34:35', value: 12.5 },
  RowDataPacket { time: '2021-10-31 10:44:00', value: 13.5 },
  RowDataPacket { time: '2021-10-31 10:59:55', value: 14.5 },
  RowDataPacket { time: '2021-10-31 11:35:10', value: 15.5 },
  RowDataPacket { time: '2021-10-31 13:26:20', value: 16.5 },
  RowDataPacket { time: '2021-10-31 15:58:55', value: 15.5 },
  RowDataPacket { time: '2021-10-31 16:40:00', value: 14.5 },
  ... 131 more items
]
Max Min per Day [
  RowDataPacket {
    'DATE(`time`)': '2021-03-17',
    'min(value)': 4.9,
    'max(value)': 4.9
  },
  RowDataPacket {
    'DATE(`time`)': '2021-03-19',
    'min(value)': 3.3,
    'max(value)': 3.3
  },
  RowDataPacket {
    'DATE(`time`)': '2021-10-24',
    'min(value)': 4.5,
    'max(value)': 14.1
  },
  RowDataPacket {
    'DATE(`time`)': '2021-10-25',
    'min(value)': 6.5,
    'max(value)': 14.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-10-26',
    'min(value)': 5.5,
    'max(value)': 14.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-10-27',
    'min(value)': 5.5,
    'max(value)': 12.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-10-28',
    'min(value)': 5.5,
    'max(value)': 13.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-10-29',
    'min(value)': 6.5,
    'max(value)': 11.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-10-30',
    'min(value)': 6.5,
    'max(value)': 9.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-10-31',
    'min(value)': 8.5,
    'max(value)': 16.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-01',
    'min(value)': 7.5,
    'max(value)': 10.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-02',
    'min(value)': 4.5,
    'max(value)': 9.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-03',
    'min(value)': 5.5,
    'max(value)': 10.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-04',
    'min(value)': 4.5,
    'max(value)': 8.5
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-05',
    'min(value)': 2.8,
    'max(value)': 10.8
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-06',
    'min(value)': 1.7,
    'max(value)': 10.8
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-07',
    'min(value)': 2.7,
    'max(value)': 11.8
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-08',
    'min(value)': 2.8,
    'max(value)': 12.8
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-09',
    'min(value)': 1.7,
    'max(value)': 8.8
  },
  RowDataPacket {
    'DATE(`time`)': '2021-11-10',
    'min(value)': 2.8,
    'max(value)': 8.8
  }
]
tjakober commented 3 years ago

Hi Douglas

Yes this is what I expect as a result. However I get only parts of the records processed:

PS C:\wamp64\www\thingsserver\Nodejs Things Server> node testsql1 All records [ RowDataPacket { time: '2021-03-17 15:52:33', value: 4.9 }, RowDataPacket { time: '2021-03-19 19:31:23', value: 3.3 }, RowDataPacket { time: '2021-03-19 19:32:19', value: 3.3 }, RowDataPacket { time: '2021-10-24 14:16:10', value: 9.5 }, RowDataPacket { time: '2021-10-24 15:06:46', value: 14.1 }, RowDataPacket { time: '2021-10-24 15:06:47', value: 9.5 }, RowDataPacket { time: '2021-10-24 15:15:37', value: 9.5 }, RowDataPacket { time: '2021-10-24 15:15:38', value: 14.1 }, RowDataPacket { time: '2021-10-24 15:16:33', value: 9.5 }, RowDataPacket { time: '2021-10-24 15:59:32', value: 10.5 }, RowDataPacket { time: '2021-10-24 15:59:33', value: 13.1 }, RowDataPacket { time: '2021-10-24 18:25:20', value: 10.1 }, RowDataPacket { time: '2021-10-24 18:35:30', value: 8.5 }, RowDataPacket { time: '2021-10-24 19:10:05', value: 7.5 }, RowDataPacket { time: '2021-10-24 19:57:57', value: 6.5 }, RowDataPacket { time: '2021-10-24 21:06:42', value: 5.5 }, RowDataPacket { time: '2021-10-24 22:41:02', value: 4.5 }, RowDataPacket { time: '2021-10-25 11:12:24', value: 7.5 }, RowDataPacket { time: '2021-10-25 11:16:12', value: 8.5 }, RowDataPacket { time: '2021-10-25 17:00:49', value: 14.5 }, RowDataPacket { time: '2021-10-25 17:49:57', value: 13.5 }, RowDataPacket { time: '2021-10-25 18:11:42', value: 12.5 }, RowDataPacket { time: '2021-10-25 18:29:07', value: 11.5 }, RowDataPacket { time: '2021-10-25 18:56:02', value: 10.5 }, RowDataPacket { time: '2021-10-25 19:35:02', value: 9.5 }, RowDataPacket { time: '2021-10-25 20:02:52', value: 8.5 }, RowDataPacket { time: '2021-10-25 20:56:33', value: 7.5 }, RowDataPacket { time: '2021-10-25 22:08:35', value: 6.5 }, RowDataPacket { time: '2021-10-26 00:36:50', value: 5.5 }, RowDataPacket { time: '2021-10-26 05:53:51', value: 6.5 }, RowDataPacket { time: '2021-10-26 09:02:07', value: 7.5 }, RowDataPacket { time: '2021-10-26 09:34:08', value: 8.5 }, RowDataPacket { time: '2021-10-26 10:08:33', value: 9.5 }, RowDataPacket { time: '2021-10-26 10:17:38', value: 10.5 }, RowDataPacket { time: '2021-10-26 10:58:43', value: 11.5 }, RowDataPacket { time: '2021-10-26 11:18:53', value: 12.5 }, RowDataPacket { time: '2021-10-26 13:44:39', value: 14.5 }, RowDataPacket { time: '2021-10-26 15:59:57', value: 15.5 }, RowDataPacket { time: '2021-10-26 16:40:10', value: 14.5 }, RowDataPacket { time: '2021-10-26 17:32:45', value: 13.5 }, RowDataPacket { time: '2021-10-26 17:51:30', value: 12.5 }, RowDataPacket { time: '2021-10-26 18:19:21', value: 11.5 }, RowDataPacket { time: '2021-10-26 19:25:31', value: 10.5 }, RowDataPacket { time: '2021-10-26 19:55:46', value: 9.5 }, RowDataPacket { time: '2021-10-26 21:02:27', value: 8.5 }, RowDataPacket { time: '2021-10-26 22:19:12', value: 7.5 } ] Max Min per Day [ RowDataPacket { 'DATE(time)': '2021-03-17', 'min(value)': 4.9, 'max(value)': 4.9 }, RowDataPacket { 'DATE(time)': '2021-03-19', 'min(value)': 3.3, 'max(value)': 3.3 }, RowDataPacket { 'DATE(time)': '2021-10-24', 'min(value)': 4.5, 'max(value)': 14.1 }, RowDataPacket { 'DATE(time)': '2021-10-25', 'min(value)': 6.5, 'max(value)': 14.5 }, RowDataPacket { 'DATE(time)': '2021-10-26', 'min(value)': 5.5, 'max(value)': 15.5 } ]

Nothing past 2021-10-26 is in the results. But the results on HeidiSQL are correct, from the same table. I also tried to drop the table and create and fill it again. Same result. I have no clue why this happens. Maybe I have to drop the whole database.

Many thanks for testing this on your computer.

Best regards, Thomas Jakober

Am Mi., 10. Nov. 2021 um 19:57 Uhr schrieb Douglas Wilson < @.***>:

Hello, and sorry you are having trouble. Thank you very much for providing all that information to reproduce. Unless I am missing something, you will be able to see by my steps below that this module produces the exact same results as the official Oracle MySQL CLI program, indicating that if there you are seeing a difference, it may be an issue with HeidiSQL rather than this module.

I don't have any additional context to know if these are the results you are expecting or not, but they are the results those queries provided return for the provided data set.

$ mysql -uroot -pmysql-test mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE test; Query OK, 1 row affected (0.00 sec)

mysql> USE test; Database changed mysql> CREATE TABLE IF NOT EXISTS temp_winterthur_ext ( -> time datetime NOT NULL, -> value float DEFAULT NULL, -> PRIMARY KEY (time) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO temp_winterthur_ext (time, value) VALUES -> ('2021-03-17 15:52:33', 4.9), -> ('2021-03-19 19:31:23', 3.3), -> ('2021-03-19 19:32:19', 3.3), -> ('2021-10-24 14:16:10', 9.5), -> ('2021-10-24 15:06:46', 14.1), -> ('2021-10-24 15:06:47', 9.5), -> ('2021-10-24 15:15:37', 9.5), -> ('2021-10-24 15:15:38', 14.1), -> ('2021-10-24 15:16:33', 9.5), -> ('2021-10-24 15:59:32', 10.5), -> ('2021-10-24 15:59:33', 13.1), -> ('2021-10-24 18:25:20', 10.1), -> ('2021-10-24 18:35:30', 8.5), -> ('2021-10-24 19:10:05', 7.5), -> ('2021-10-24 19:57:57', 6.5), -> ('2021-10-24 21:06:42', 5.5), -> ('2021-10-24 22:41:02', 4.5), -> ('2021-10-25 11:12:24', 7.5), -> ('2021-10-25 11:16:12', 8.5), -> ('2021-10-25 17:00:49', 14.5), -> ('2021-10-25 17:49:57', 13.5), -> ('2021-10-25 18:11:42', 12.5), -> ('2021-10-25 18:29:07', 11.5), -> ('2021-10-25 18:56:02', 10.5), -> ('2021-10-25 19:35:02', 9.5), -> ('2021-10-25 20:02:52', 8.5), -> ('2021-10-25 20:56:33', 7.5), -> ('2021-10-25 22:08:35', 6.5), -> ('2021-10-26 00:36:50', 5.5), -> ('2021-10-26 05:53:51', 6.5), -> ('2021-10-26 09:02:07', 7.5), -> ('2021-10-26 09:34:08', 8.5), -> ('2021-10-26 10:08:33', 9.5), -> ('2021-10-26 10:17:38', 10.5), -> ('2021-10-26 10:58:43', 11.5), -> ('2021-10-26 11:18:53', 12.5), -> ('2021-10-26 13:44:39', 14.5), -> ('2021-10-26 17:55:11', 12.5), -> ('2021-10-26 18:19:21', 11.5), -> ('2021-10-26 19:25:31', 10.5), -> ('2021-10-26 19:55:46', 9.5), -> ('2021-10-26 21:02:26', 8.5), -> ('2021-10-26 22:19:11', 7.5), -> ('2021-10-27 00:05:36', 6.5), -> ('2021-10-27 01:58:31', 5.5), -> ('2021-10-27 03:55:26', 6.5), -> ('2021-10-27 09:02:36', 7.5), -> ('2021-10-27 10:07:26', 8.5), -> ('2021-10-27 10:57:11', 9.5), -> ('2021-10-27 12:46:16', 10.5), -> ('2021-10-27 13:26:01', 11.5), -> ('2021-10-27 14:06:16', 12.5), -> ('2021-10-27 17:45:26', 11.5), -> ('2021-10-27 18:10:51', 10.5), -> ('2021-10-27 18:44:56', 9.5), -> ('2021-10-27 19:34:51', 8.5), -> ('2021-10-27 20:41:41', 7.5), -> ('2021-10-27 21:59:06', 6.5), -> ('2021-10-27 23:46:06', 5.5), -> ('2021-10-28 03:08:26', 6.5), -> ('2021-10-28 08:57:51', 7.5), -> ('2021-10-28 09:55:56', 8.5), -> ('2021-10-28 11:24:46', 9.5), -> ('2021-10-28 11:49:16', 10.5), -> ('2021-10-28 12:22:16', 11.5), -> ('2021-10-28 12:39:01', 12.5), -> ('2021-10-28 12:53:31', 13.5), -> ('2021-10-28 13:32:41', 12.5), -> ('2021-10-28 17:15:01', 11.5), -> ('2021-10-28 17:47:31', 10.5), -> ('2021-10-28 18:13:06', 9.5), -> ('2021-10-28 18:48:26', 8.5), -> ('2021-10-28 19:51:26', 7.5), -> ('2021-10-28 21:05:36', 6.5), -> ('2021-10-28 22:35:01', 5.5), -> ('2021-10-29 00:01:22', 6.5), -> ('2021-10-29 09:49:33', 7.5), -> ('2021-10-29 12:34:13', 8.5), -> ('2021-10-29 13:25:33', 9.5), -> ('2021-10-29 14:11:53', 10.5), -> ('2021-10-29 15:03:43', 11.5), -> ('2021-10-29 16:38:23', 10.5), -> ('2021-10-29 17:27:03', 9.5), -> ('2021-10-29 18:27:23', 8.5), -> ('2021-10-29 21:14:39', 7.5), -> ('2021-10-30 04:30:19', 6.5), -> ('2021-10-30 12:13:09', 7.5), -> ('2021-10-30 14:33:55', 8.5), -> ('2021-10-30 16:09:17', 9.5), -> ('2021-10-30 23:46:00', 8.5), -> ('2021-10-31 08:52:25', 9.5), -> ('2021-10-31 09:21:30', 10.5), -> ('2021-10-31 10:24:30', 11.5), -> ('2021-10-31 10:34:35', 12.5), -> ('2021-10-31 10:44:00', 13.5), -> ('2021-10-31 10:59:55', 14.5), -> ('2021-10-31 11:35:10', 15.5), -> ('2021-10-31 13:26:20', 16.5), -> ('2021-10-31 15:58:55', 15.5), -> ('2021-10-31 16:40:00', 14.5), -> ('2021-10-31 17:08:55', 13.5), -> ('2021-10-31 17:42:40', 12.5), -> ('2021-10-31 18:30:45', 11.5), -> ('2021-10-31 19:44:15', 10.5), -> ('2021-10-31 21:01:45', 9.5), -> ('2021-10-31 22:41:05', 8.5), -> ('2021-11-01 01:03:15', 9.5), -> ('2021-11-01 04:44:10', 10.5), -> ('2021-11-01 07:28:40', 9.5), -> ('2021-11-01 11:21:35', 10.5), -> ('2021-11-01 19:14:20', 9.5), -> ('2021-11-01 20:03:45', 8.5), -> ('2021-11-01 22:52:10', 7.5), -> ('2021-11-02 04:18:46', 6.5), -> ('2021-11-02 09:51:21', 7.5), -> ('2021-11-02 10:40:46', 8.5), -> ('2021-11-02 11:34:26', 9.5), -> ('2021-11-02 12:23:36', 8.5), -> ('2021-11-02 13:02:56', 9.5), -> ('2021-11-02 17:14:16', 8.5), -> ('2021-11-02 17:58:06', 7.5), -> ('2021-11-02 18:54:26', 6.5), -> ('2021-11-02 20:13:41', 5.5), -> ('2021-11-02 22:29:16', 4.5), -> ('2021-11-03 06:18:32', 5.5), -> ('2021-11-03 08:53:32', 6.5), -> ('2021-11-03 09:34:06', 7.5), -> ('2021-11-03 09:54:22', 8.5), -> ('2021-11-03 10:13:32', 9.5), -> ('2021-11-03 11:09:37', 10.5), -> ('2021-11-03 12:27:22', 9.5), -> ('2021-11-03 12:56:32', 8.5), -> ('2021-11-03 17:25:07', 7.5), -> ('2021-11-04 01:01:15', 6.5), -> ('2021-11-04 06:54:20', 5.5), -> ('2021-11-04 09:42:10', 6.5), -> ('2021-11-04 11:33:10', 7.5), -> ('2021-11-04 11:57:00', 8.5), -> ('2021-11-04 13:21:00', 7.5), -> ('2021-11-04 15:26:25', 6.5), -> ('2021-11-04 15:34:55', 5.5), -> ('2021-11-04 17:48:15', 4.5), -> ('2021-11-05 06:00:48', 4.8), -> ('2021-11-05 07:50:18', 5.8), -> ('2021-11-05 08:58:58', 6.8), -> ('2021-11-05 09:34:58', 7.8), -> ('2021-11-05 10:07:43', 8.8), -> ('2021-11-05 10:42:08', 9.8), -> ('2021-11-05 11:14:53', 10.8), -> ('2021-11-05 14:46:58', 9.8), -> ('2021-11-05 16:12:43', 8.8), -> ('2021-11-05 16:36:28', 7.8), -> ('2021-11-05 17:07:23', 6.8), -> ('2021-11-05 17:48:44', 5.8), -> ('2021-11-05 19:13:08', 4.8), -> ('2021-11-05 20:33:18', 3.8), -> ('2021-11-05 22:32:49', 2.8), -> ('2021-11-06 05:41:38', 3.8), -> ('2021-11-06 07:18:18', 4.8), -> ('2021-11-06 08:35:08', 5.8), -> ('2021-11-06 09:32:23', 6.8), -> ('2021-11-06 10:43:58', 7.8), -> ('2021-11-06 10:49:24', 8.8), -> ('2021-11-06 11:06:08', 9.8), -> ('2021-11-06 11:28:53', 10.8), -> ('2021-11-06 14:38:23', 9.8), -> ('2021-11-06 16:13:39', 8.8), -> ('2021-11-06 16:40:09', 7.8), -> ('2021-11-06 17:09:59', 6.8), -> ('2021-11-06 17:40:34', 5.8), -> ('2021-11-06 18:29:58', 4.8), -> ('2021-11-06 19:35:48', 3.8), -> ('2021-11-06 21:11:09', 2.8), -> ('2021-11-06 23:17:59', 1.7), -> ('2021-11-07 00:40:34', 2.7), -> ('2021-11-07 05:05:09', 3.7), -> ('2021-11-07 09:15:49', 4.7), -> ('2021-11-07 09:52:59', 5.7), -> ('2021-11-07 10:08:44', 6.7), -> ('2021-11-07 10:33:04', 7.7), -> ('2021-11-07 11:09:44', 8.8), -> ('2021-11-07 11:20:44', 9.8), -> ('2021-11-07 11:42:14', 10.8), -> ('2021-11-07 12:13:09', 11.8), -> ('2021-11-07 12:44:44', 10.8), -> ('2021-11-07 14:37:54', 9.8), -> ('2021-11-07 17:20:44', 8.8), -> ('2021-11-07 19:02:29', 7.8), -> ('2021-11-08 05:38:44', 6.8), -> ('2021-11-08 06:46:54', 5.8), -> ('2021-11-08 08:31:09', 6.8), -> ('2021-11-08 09:27:09', 7.8), -> ('2021-11-08 10:02:54', 8.8), -> ('2021-11-08 10:52:04', 9.8), -> ('2021-11-08 11:13:54', 10.8), -> ('2021-11-08 11:25:04', 11.8), -> ('2021-11-08 11:29:19', 12.8), -> ('2021-11-08 11:42:09', 11.8), -> ('2021-11-08 12:20:24', 10.8), -> ('2021-11-08 13:36:29', 11.8), -> ('2021-11-08 14:18:39', 10.8), -> ('2021-11-08 15:39:04', 9.8), -> ('2021-11-08 16:26:54', 8.8), -> ('2021-11-08 16:53:34', 7.8), -> ('2021-11-08 17:20:29', 6.8), -> ('2021-11-08 18:14:44', 5.8), -> ('2021-11-08 19:42:59', 4.8), -> ('2021-11-08 20:59:45', 3.8), -> ('2021-11-08 22:57:00', 2.8), -> ('2021-11-09 01:46:24', 1.7), -> ('2021-11-09 07:42:49', 2.7), -> ('2021-11-09 09:11:29', 3.7), -> ('2021-11-09 09:56:24', 4.7), -> ('2021-11-09 10:43:29', 5.7), -> ('2021-11-09 11:13:34', 6.7), -> ('2021-11-09 11:58:29', 7.7), -> ('2021-11-09 13:55:04', 8.8), -> ('2021-11-09 16:15:52', 7.8), -> ('2021-11-09 16:47:17', 6.8), -> ('2021-11-09 17:44:42', 5.8), -> ('2021-11-09 19:03:34', 4.8), -> ('2021-11-09 23:30:13', 3.8), -> ('2021-11-10 01:39:18', 2.8), -> ('2021-11-10 09:22:48', 3.8), -> ('2021-11-10 10:05:33', 4.8), -> ('2021-11-10 10:46:33', 5.8), -> ('2021-11-10 11:13:18', 6.8), -> ('2021-11-10 12:10:33', 7.8), -> ('2021-11-10 13:26:43', 8.8), -> ('2021-11-10 15:59:18', 7.8), -> ('2021-11-10 16:51:48', 6.8); Query OK, 231 rows affected (0.01 sec) Records: 231 Duplicates: 0 Warnings: 0

mysql> SELECT * from temp_winterthur_ext; +---------------------+-------+ | time | value | +---------------------+-------+ | 2021-03-17 15:52:33 | 4.9 | | 2021-03-19 19:31:23 | 3.3 | | 2021-03-19 19:32:19 | 3.3 | | 2021-10-24 14:16:10 | 9.5 | | 2021-10-24 15:06:46 | 14.1 | | 2021-10-24 15:06:47 | 9.5 | | 2021-10-24 15:15:37 | 9.5 | | 2021-10-24 15:15:38 | 14.1 | | 2021-10-24 15:16:33 | 9.5 | | 2021-10-24 15:59:32 | 10.5 | | 2021-10-24 15:59:33 | 13.1 | | 2021-10-24 18:25:20 | 10.1 | | 2021-10-24 18:35:30 | 8.5 | | 2021-10-24 19:10:05 | 7.5 | | 2021-10-24 19:57:57 | 6.5 | | 2021-10-24 21:06:42 | 5.5 | | 2021-10-24 22:41:02 | 4.5 | | 2021-10-25 11:12:24 | 7.5 | | 2021-10-25 11:16:12 | 8.5 | | 2021-10-25 17:00:49 | 14.5 | | 2021-10-25 17:49:57 | 13.5 | | 2021-10-25 18:11:42 | 12.5 | | 2021-10-25 18:29:07 | 11.5 | | 2021-10-25 18:56:02 | 10.5 | | 2021-10-25 19:35:02 | 9.5 | | 2021-10-25 20:02:52 | 8.5 | | 2021-10-25 20:56:33 | 7.5 | | 2021-10-25 22:08:35 | 6.5 | | 2021-10-26 00:36:50 | 5.5 | | 2021-10-26 05:53:51 | 6.5 | | 2021-10-26 09:02:07 | 7.5 | | 2021-10-26 09:34:08 | 8.5 | | 2021-10-26 10:08:33 | 9.5 | | 2021-10-26 10:17:38 | 10.5 | | 2021-10-26 10:58:43 | 11.5 | | 2021-10-26 11:18:53 | 12.5 | | 2021-10-26 13:44:39 | 14.5 | | 2021-10-26 17:55:11 | 12.5 | | 2021-10-26 18:19:21 | 11.5 | | 2021-10-26 19:25:31 | 10.5 | | 2021-10-26 19:55:46 | 9.5 | | 2021-10-26 21:02:26 | 8.5 | | 2021-10-26 22:19:11 | 7.5 | | 2021-10-27 00:05:36 | 6.5 | | 2021-10-27 01:58:31 | 5.5 | | 2021-10-27 03:55:26 | 6.5 | | 2021-10-27 09:02:36 | 7.5 | | 2021-10-27 10:07:26 | 8.5 | | 2021-10-27 10:57:11 | 9.5 | | 2021-10-27 12:46:16 | 10.5 | | 2021-10-27 13:26:01 | 11.5 | | 2021-10-27 14:06:16 | 12.5 | | 2021-10-27 17:45:26 | 11.5 | | 2021-10-27 18:10:51 | 10.5 | | 2021-10-27 18:44:56 | 9.5 | | 2021-10-27 19:34:51 | 8.5 | | 2021-10-27 20:41:41 | 7.5 | | 2021-10-27 21:59:06 | 6.5 | | 2021-10-27 23:46:06 | 5.5 | | 2021-10-28 03:08:26 | 6.5 | | 2021-10-28 08:57:51 | 7.5 | | 2021-10-28 09:55:56 | 8.5 | | 2021-10-28 11:24:46 | 9.5 | | 2021-10-28 11:49:16 | 10.5 | | 2021-10-28 12:22:16 | 11.5 | | 2021-10-28 12:39:01 | 12.5 | | 2021-10-28 12:53:31 | 13.5 | | 2021-10-28 13:32:41 | 12.5 | | 2021-10-28 17:15:01 | 11.5 | | 2021-10-28 17:47:31 | 10.5 | | 2021-10-28 18:13:06 | 9.5 | | 2021-10-28 18:48:26 | 8.5 | | 2021-10-28 19:51:26 | 7.5 | | 2021-10-28 21:05:36 | 6.5 | | 2021-10-28 22:35:01 | 5.5 | | 2021-10-29 00:01:22 | 6.5 | | 2021-10-29 09:49:33 | 7.5 | | 2021-10-29 12:34:13 | 8.5 | | 2021-10-29 13:25:33 | 9.5 | | 2021-10-29 14:11:53 | 10.5 | | 2021-10-29 15:03:43 | 11.5 | | 2021-10-29 16:38:23 | 10.5 | | 2021-10-29 17:27:03 | 9.5 | | 2021-10-29 18:27:23 | 8.5 | | 2021-10-29 21:14:39 | 7.5 | | 2021-10-30 04:30:19 | 6.5 | | 2021-10-30 12:13:09 | 7.5 | | 2021-10-30 14:33:55 | 8.5 | | 2021-10-30 16:09:17 | 9.5 | | 2021-10-30 23:46:00 | 8.5 | | 2021-10-31 08:52:25 | 9.5 | | 2021-10-31 09:21:30 | 10.5 | | 2021-10-31 10:24:30 | 11.5 | | 2021-10-31 10:34:35 | 12.5 | | 2021-10-31 10:44:00 | 13.5 | | 2021-10-31 10:59:55 | 14.5 | | 2021-10-31 11:35:10 | 15.5 | | 2021-10-31 13:26:20 | 16.5 | | 2021-10-31 15:58:55 | 15.5 | | 2021-10-31 16:40:00 | 14.5 | | 2021-10-31 17:08:55 | 13.5 | | 2021-10-31 17:42:40 | 12.5 | | 2021-10-31 18:30:45 | 11.5 | | 2021-10-31 19:44:15 | 10.5 | | 2021-10-31 21:01:45 | 9.5 | | 2021-10-31 22:41:05 | 8.5 | | 2021-11-01 01:03:15 | 9.5 | | 2021-11-01 04:44:10 | 10.5 | | 2021-11-01 07:28:40 | 9.5 | | 2021-11-01 11:21:35 | 10.5 | | 2021-11-01 19:14:20 | 9.5 | | 2021-11-01 20:03:45 | 8.5 | | 2021-11-01 22:52:10 | 7.5 | | 2021-11-02 04:18:46 | 6.5 | | 2021-11-02 09:51:21 | 7.5 | | 2021-11-02 10:40:46 | 8.5 | | 2021-11-02 11:34:26 | 9.5 | | 2021-11-02 12:23:36 | 8.5 | | 2021-11-02 13:02:56 | 9.5 | | 2021-11-02 17:14:16 | 8.5 | | 2021-11-02 17:58:06 | 7.5 | | 2021-11-02 18:54:26 | 6.5 | | 2021-11-02 20:13:41 | 5.5 | | 2021-11-02 22:29:16 | 4.5 | | 2021-11-03 06:18:32 | 5.5 | | 2021-11-03 08:53:32 | 6.5 | | 2021-11-03 09:34:06 | 7.5 | | 2021-11-03 09:54:22 | 8.5 | | 2021-11-03 10:13:32 | 9.5 | | 2021-11-03 11:09:37 | 10.5 | | 2021-11-03 12:27:22 | 9.5 | | 2021-11-03 12:56:32 | 8.5 | | 2021-11-03 17:25:07 | 7.5 | | 2021-11-04 01:01:15 | 6.5 | | 2021-11-04 06:54:20 | 5.5 | | 2021-11-04 09:42:10 | 6.5 | | 2021-11-04 11:33:10 | 7.5 | | 2021-11-04 11:57:00 | 8.5 | | 2021-11-04 13:21:00 | 7.5 | | 2021-11-04 15:26:25 | 6.5 | | 2021-11-04 15:34:55 | 5.5 | | 2021-11-04 17:48:15 | 4.5 | | 2021-11-05 06:00:48 | 4.8 | | 2021-11-05 07:50:18 | 5.8 | | 2021-11-05 08:58:58 | 6.8 | | 2021-11-05 09:34:58 | 7.8 | | 2021-11-05 10:07:43 | 8.8 | | 2021-11-05 10:42:08 | 9.8 | | 2021-11-05 11:14:53 | 10.8 | | 2021-11-05 14:46:58 | 9.8 | | 2021-11-05 16:12:43 | 8.8 | | 2021-11-05 16:36:28 | 7.8 | | 2021-11-05 17:07:23 | 6.8 | | 2021-11-05 17:48:44 | 5.8 | | 2021-11-05 19:13:08 | 4.8 | | 2021-11-05 20:33:18 | 3.8 | | 2021-11-05 22:32:49 | 2.8 | | 2021-11-06 05:41:38 | 3.8 | | 2021-11-06 07:18:18 | 4.8 | | 2021-11-06 08:35:08 | 5.8 | | 2021-11-06 09:32:23 | 6.8 | | 2021-11-06 10:43:58 | 7.8 | | 2021-11-06 10:49:24 | 8.8 | | 2021-11-06 11:06:08 | 9.8 | | 2021-11-06 11:28:53 | 10.8 | | 2021-11-06 14:38:23 | 9.8 | | 2021-11-06 16:13:39 | 8.8 | | 2021-11-06 16:40:09 | 7.8 | | 2021-11-06 17:09:59 | 6.8 | | 2021-11-06 17:40:34 | 5.8 | | 2021-11-06 18:29:58 | 4.8 | | 2021-11-06 19:35:48 | 3.8 | | 2021-11-06 21:11:09 | 2.8 | | 2021-11-06 23:17:59 | 1.7 | | 2021-11-07 00:40:34 | 2.7 | | 2021-11-07 05:05:09 | 3.7 | | 2021-11-07 09:15:49 | 4.7 | | 2021-11-07 09:52:59 | 5.7 | | 2021-11-07 10:08:44 | 6.7 | | 2021-11-07 10:33:04 | 7.7 | | 2021-11-07 11:09:44 | 8.8 | | 2021-11-07 11:20:44 | 9.8 | | 2021-11-07 11:42:14 | 10.8 | | 2021-11-07 12:13:09 | 11.8 | | 2021-11-07 12:44:44 | 10.8 | | 2021-11-07 14:37:54 | 9.8 | | 2021-11-07 17:20:44 | 8.8 | | 2021-11-07 19:02:29 | 7.8 | | 2021-11-08 05:38:44 | 6.8 | | 2021-11-08 06:46:54 | 5.8 | | 2021-11-08 08:31:09 | 6.8 | | 2021-11-08 09:27:09 | 7.8 | | 2021-11-08 10:02:54 | 8.8 | | 2021-11-08 10:52:04 | 9.8 | | 2021-11-08 11:13:54 | 10.8 | | 2021-11-08 11:25:04 | 11.8 | | 2021-11-08 11:29:19 | 12.8 | | 2021-11-08 11:42:09 | 11.8 | | 2021-11-08 12:20:24 | 10.8 | | 2021-11-08 13:36:29 | 11.8 | | 2021-11-08 14:18:39 | 10.8 | | 2021-11-08 15:39:04 | 9.8 | | 2021-11-08 16:26:54 | 8.8 | | 2021-11-08 16:53:34 | 7.8 | | 2021-11-08 17:20:29 | 6.8 | | 2021-11-08 18:14:44 | 5.8 | | 2021-11-08 19:42:59 | 4.8 | | 2021-11-08 20:59:45 | 3.8 | | 2021-11-08 22:57:00 | 2.8 | | 2021-11-09 01:46:24 | 1.7 | | 2021-11-09 07:42:49 | 2.7 | | 2021-11-09 09:11:29 | 3.7 | | 2021-11-09 09:56:24 | 4.7 | | 2021-11-09 10:43:29 | 5.7 | | 2021-11-09 11:13:34 | 6.7 | | 2021-11-09 11:58:29 | 7.7 | | 2021-11-09 13:55:04 | 8.8 | | 2021-11-09 16:15:52 | 7.8 | | 2021-11-09 16:47:17 | 6.8 | | 2021-11-09 17:44:42 | 5.8 | | 2021-11-09 19:03:34 | 4.8 | | 2021-11-09 23:30:13 | 3.8 | | 2021-11-10 01:39:18 | 2.8 | | 2021-11-10 09:22:48 | 3.8 | | 2021-11-10 10:05:33 | 4.8 | | 2021-11-10 10:46:33 | 5.8 | | 2021-11-10 11:13:18 | 6.8 | | 2021-11-10 12:10:33 | 7.8 | | 2021-11-10 13:26:43 | 8.8 | | 2021-11-10 15:59:18 | 7.8 | | 2021-11-10 16:51:48 | 6.8 | +---------------------+-------+ 231 rows in set (0.00 sec)

mysql> SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Query OK, 0 rows affected (0.00 sec)

mysql> SELECT DATE(time), min(value), max(value) from temp_winterthur_ext group by DAY(time) ORDER BY DATE(time); +--------------+------------+------------+ | DATE(time) | min(value) | max(value) | +--------------+------------+------------+ | 2021-03-17 | 4.9 | 4.9 | | 2021-03-19 | 3.3 | 3.3 | | 2021-10-24 | 4.5 | 14.1 | | 2021-10-25 | 6.5 | 14.5 | | 2021-10-26 | 5.5 | 14.5 | | 2021-10-27 | 5.5 | 12.5 | | 2021-10-28 | 5.5 | 13.5 | | 2021-10-29 | 6.5 | 11.5 | | 2021-10-30 | 6.5 | 9.5 | | 2021-10-31 | 8.5 | 16.5 | | 2021-11-01 | 7.5 | 10.5 | | 2021-11-02 | 4.5 | 9.5 | | 2021-11-03 | 5.5 | 10.5 | | 2021-11-04 | 4.5 | 8.5 | | 2021-11-05 | 2.8 | 10.8 | | 2021-11-06 | 1.7 | 10.8 | | 2021-11-07 | 2.7 | 11.8 | | 2021-11-08 | 2.8 | 12.8 | | 2021-11-09 | 1.7 | 8.8 | | 2021-11-10 | 2.8 | 8.8 | +--------------+------------+------------+ 20 rows in set (0.00 sec)

mysql> ^DBye

$ node test.js All records [ RowDataPacket { time: '2021-03-17 15:52:33', value: 4.9 }, RowDataPacket { time: '2021-03-19 19:31:23', value: 3.3 }, RowDataPacket { time: '2021-03-19 19:32:19', value: 3.3 }, RowDataPacket { time: '2021-10-24 14:16:10', value: 9.5 }, RowDataPacket { time: '2021-10-24 15:06:46', value: 14.1 }, RowDataPacket { time: '2021-10-24 15:06:47', value: 9.5 }, RowDataPacket { time: '2021-10-24 15:15:37', value: 9.5 }, RowDataPacket { time: '2021-10-24 15:15:38', value: 14.1 }, RowDataPacket { time: '2021-10-24 15:16:33', value: 9.5 }, RowDataPacket { time: '2021-10-24 15:59:32', value: 10.5 }, RowDataPacket { time: '2021-10-24 15:59:33', value: 13.1 }, RowDataPacket { time: '2021-10-24 18:25:20', value: 10.1 }, RowDataPacket { time: '2021-10-24 18:35:30', value: 8.5 }, RowDataPacket { time: '2021-10-24 19:10:05', value: 7.5 }, RowDataPacket { time: '2021-10-24 19:57:57', value: 6.5 }, RowDataPacket { time: '2021-10-24 21:06:42', value: 5.5 }, RowDataPacket { time: '2021-10-24 22:41:02', value: 4.5 }, RowDataPacket { time: '2021-10-25 11:12:24', value: 7.5 }, RowDataPacket { time: '2021-10-25 11:16:12', value: 8.5 }, RowDataPacket { time: '2021-10-25 17:00:49', value: 14.5 }, RowDataPacket { time: '2021-10-25 17:49:57', value: 13.5 }, RowDataPacket { time: '2021-10-25 18:11:42', value: 12.5 }, RowDataPacket { time: '2021-10-25 18:29:07', value: 11.5 }, RowDataPacket { time: '2021-10-25 18:56:02', value: 10.5 }, RowDataPacket { time: '2021-10-25 19:35:02', value: 9.5 }, RowDataPacket { time: '2021-10-25 20:02:52', value: 8.5 }, RowDataPacket { time: '2021-10-25 20:56:33', value: 7.5 }, RowDataPacket { time: '2021-10-25 22:08:35', value: 6.5 }, RowDataPacket { time: '2021-10-26 00:36:50', value: 5.5 }, RowDataPacket { time: '2021-10-26 05:53:51', value: 6.5 }, RowDataPacket { time: '2021-10-26 09:02:07', value: 7.5 }, RowDataPacket { time: '2021-10-26 09:34:08', value: 8.5 }, RowDataPacket { time: '2021-10-26 10:08:33', value: 9.5 }, RowDataPacket { time: '2021-10-26 10:17:38', value: 10.5 }, RowDataPacket { time: '2021-10-26 10:58:43', value: 11.5 }, RowDataPacket { time: '2021-10-26 11:18:53', value: 12.5 }, RowDataPacket { time: '2021-10-26 13:44:39', value: 14.5 }, RowDataPacket { time: '2021-10-26 17:55:11', value: 12.5 }, RowDataPacket { time: '2021-10-26 18:19:21', value: 11.5 }, RowDataPacket { time: '2021-10-26 19:25:31', value: 10.5 }, RowDataPacket { time: '2021-10-26 19:55:46', value: 9.5 }, RowDataPacket { time: '2021-10-26 21:02:26', value: 8.5 }, RowDataPacket { time: '2021-10-26 22:19:11', value: 7.5 }, RowDataPacket { time: '2021-10-27 00:05:36', value: 6.5 }, RowDataPacket { time: '2021-10-27 01:58:31', value: 5.5 }, RowDataPacket { time: '2021-10-27 03:55:26', value: 6.5 }, RowDataPacket { time: '2021-10-27 09:02:36', value: 7.5 }, RowDataPacket { time: '2021-10-27 10:07:26', value: 8.5 }, RowDataPacket { time: '2021-10-27 10:57:11', value: 9.5 }, RowDataPacket { time: '2021-10-27 12:46:16', value: 10.5 }, RowDataPacket { time: '2021-10-27 13:26:01', value: 11.5 }, RowDataPacket { time: '2021-10-27 14:06:16', value: 12.5 }, RowDataPacket { time: '2021-10-27 17:45:26', value: 11.5 }, RowDataPacket { time: '2021-10-27 18:10:51', value: 10.5 }, RowDataPacket { time: '2021-10-27 18:44:56', value: 9.5 }, RowDataPacket { time: '2021-10-27 19:34:51', value: 8.5 }, RowDataPacket { time: '2021-10-27 20:41:41', value: 7.5 }, RowDataPacket { time: '2021-10-27 21:59:06', value: 6.5 }, RowDataPacket { time: '2021-10-27 23:46:06', value: 5.5 }, RowDataPacket { time: '2021-10-28 03:08:26', value: 6.5 }, RowDataPacket { time: '2021-10-28 08:57:51', value: 7.5 }, RowDataPacket { time: '2021-10-28 09:55:56', value: 8.5 }, RowDataPacket { time: '2021-10-28 11:24:46', value: 9.5 }, RowDataPacket { time: '2021-10-28 11:49:16', value: 10.5 }, RowDataPacket { time: '2021-10-28 12:22:16', value: 11.5 }, RowDataPacket { time: '2021-10-28 12:39:01', value: 12.5 }, RowDataPacket { time: '2021-10-28 12:53:31', value: 13.5 }, RowDataPacket { time: '2021-10-28 13:32:41', value: 12.5 }, RowDataPacket { time: '2021-10-28 17:15:01', value: 11.5 }, RowDataPacket { time: '2021-10-28 17:47:31', value: 10.5 }, RowDataPacket { time: '2021-10-28 18:13:06', value: 9.5 }, RowDataPacket { time: '2021-10-28 18:48:26', value: 8.5 }, RowDataPacket { time: '2021-10-28 19:51:26', value: 7.5 }, RowDataPacket { time: '2021-10-28 21:05:36', value: 6.5 }, RowDataPacket { time: '2021-10-28 22:35:01', value: 5.5 }, RowDataPacket { time: '2021-10-29 00:01:22', value: 6.5 }, RowDataPacket { time: '2021-10-29 09:49:33', value: 7.5 }, RowDataPacket { time: '2021-10-29 12:34:13', value: 8.5 }, RowDataPacket { time: '2021-10-29 13:25:33', value: 9.5 }, RowDataPacket { time: '2021-10-29 14:11:53', value: 10.5 }, RowDataPacket { time: '2021-10-29 15:03:43', value: 11.5 }, RowDataPacket { time: '2021-10-29 16:38:23', value: 10.5 }, RowDataPacket { time: '2021-10-29 17:27:03', value: 9.5 }, RowDataPacket { time: '2021-10-29 18:27:23', value: 8.5 }, RowDataPacket { time: '2021-10-29 21:14:39', value: 7.5 }, RowDataPacket { time: '2021-10-30 04:30:19', value: 6.5 }, RowDataPacket { time: '2021-10-30 12:13:09', value: 7.5 }, RowDataPacket { time: '2021-10-30 14:33:55', value: 8.5 }, RowDataPacket { time: '2021-10-30 16:09:17', value: 9.5 }, RowDataPacket { time: '2021-10-30 23:46:00', value: 8.5 }, RowDataPacket { time: '2021-10-31 08:52:25', value: 9.5 }, RowDataPacket { time: '2021-10-31 09:21:30', value: 10.5 }, RowDataPacket { time: '2021-10-31 10:24:30', value: 11.5 }, RowDataPacket { time: '2021-10-31 10:34:35', value: 12.5 }, RowDataPacket { time: '2021-10-31 10:44:00', value: 13.5 }, RowDataPacket { time: '2021-10-31 10:59:55', value: 14.5 }, RowDataPacket { time: '2021-10-31 11:35:10', value: 15.5 }, RowDataPacket { time: '2021-10-31 13:26:20', value: 16.5 }, RowDataPacket { time: '2021-10-31 15:58:55', value: 15.5 }, RowDataPacket { time: '2021-10-31 16:40:00', value: 14.5 }, ... 131 more items ] Max Min per Day [ RowDataPacket { 'DATE(time)': '2021-03-17', 'min(value)': 4.9, 'max(value)': 4.9 }, RowDataPacket { 'DATE(time)': '2021-03-19', 'min(value)': 3.3, 'max(value)': 3.3 }, RowDataPacket { 'DATE(time)': '2021-10-24', 'min(value)': 4.5, 'max(value)': 14.1 }, RowDataPacket { 'DATE(time)': '2021-10-25', 'min(value)': 6.5, 'max(value)': 14.5 }, RowDataPacket { 'DATE(time)': '2021-10-26', 'min(value)': 5.5, 'max(value)': 14.5 }, RowDataPacket { 'DATE(time)': '2021-10-27', 'min(value)': 5.5, 'max(value)': 12.5 }, RowDataPacket { 'DATE(time)': '2021-10-28', 'min(value)': 5.5, 'max(value)': 13.5 }, RowDataPacket { 'DATE(time)': '2021-10-29', 'min(value)': 6.5, 'max(value)': 11.5 }, RowDataPacket { 'DATE(time)': '2021-10-30', 'min(value)': 6.5, 'max(value)': 9.5 }, RowDataPacket { 'DATE(time)': '2021-10-31', 'min(value)': 8.5, 'max(value)': 16.5 }, RowDataPacket { 'DATE(time)': '2021-11-01', 'min(value)': 7.5, 'max(value)': 10.5 }, RowDataPacket { 'DATE(time)': '2021-11-02', 'min(value)': 4.5, 'max(value)': 9.5 }, RowDataPacket { 'DATE(time)': '2021-11-03', 'min(value)': 5.5, 'max(value)': 10.5 }, RowDataPacket { 'DATE(time)': '2021-11-04', 'min(value)': 4.5, 'max(value)': 8.5 }, RowDataPacket { 'DATE(time)': '2021-11-05', 'min(value)': 2.8, 'max(value)': 10.8 }, RowDataPacket { 'DATE(time)': '2021-11-06', 'min(value)': 1.7, 'max(value)': 10.8 }, RowDataPacket { 'DATE(time)': '2021-11-07', 'min(value)': 2.7, 'max(value)': 11.8 }, RowDataPacket { 'DATE(time)': '2021-11-08', 'min(value)': 2.8, 'max(value)': 12.8 }, RowDataPacket { 'DATE(time)': '2021-11-09', 'min(value)': 1.7, 'max(value)': 8.8 }, RowDataPacket { 'DATE(time)': '2021-11-10', 'min(value)': 2.8, 'max(value)': 8.8 } ]

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mysqljs/mysql/issues/2532#issuecomment-965645033, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABUNXQSRBSOHV5QWVIYWAYDULK6B3ANCNFSM5HYS33AQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

dougwilson commented 3 years ago

Hi @tjakober ok, I see what you mean. Unfortunately I am unable to reproduce your issue and so not sure. This module just conveys what the MySQL server sends back, so it is unclear why you would get only part of the records back that you are expecting.

My only guess is that only part of your records are actually committed. If you close down this HeidiSQL program, open it back again and run only the select statements does that still return all results? If so, does running the Node.js program again now yield the same results as HeidiSQL?

dougwilson commented 2 years ago

Closing due no unable to reproduce with information provided. You are always welcome to open a pull request with a fix.