Code: Select all
| 90 | NULL | 1 | (UPDATE recorded SET deletepending = 1,.*duplicate = 0 WHERE chanid = .* AND starttime = ')(.*)Z' | CASELESS | \1\2' | NULL | NULL |
Moderator: Forum Moderators
Code: Select all
| 90 | NULL | 1 | (UPDATE recorded SET deletepending = 1,.*duplicate = 0 WHERE chanid = .* AND starttime = ')(.*)Z' | CASELESS | \1\2' | NULL | NULL |
Code: Select all
{
"client": "192.158.202.150:41406",
"digest": "0xA2622C7EB2F1DB5D",
"duration_us": 524,
"endtime": "2023-04-17 09:29:59.437214",
"endtime_timestamp_us": 1681694999437214,
"event": "COM_QUERY",
"hostgroup_id": 0,
"query": "UPDATE record SET last_delete = '2023-04-17T01:29:59Z', avg_delay = (avg_delay * 3 + 157) / 4 WHERE recordid = 4847",
"rows_affected": 1,
"rows_sent": 0,
"server": "database:3306",
"starttime": "2023-04-17 09:29:59.436690",
"starttime_timestamp_us": 1681694999436690,
"thread_id": 267,
}
Code: Select all
SET GLOBAL general_log = 'ON';
SET GLOBAL log_output = 'table';
Code: Select all
MariaDB [mythtv_32]> set @@session.sql_mode='';
Query OK, 0 rows affected (0.000 sec)
MariaDB [mythtv_32]> \W
Show warnings enabled.
MariaDB [mythtv_32]> CREATE TABLE testtable (recordedid int unsigned AUTO_INCREMENT, chanid int unsigned, starttime datetime, filesize int unsigned, PRIMARY KEY (recordedid), UNIQUE(chanid, starttime));
Query OK, 0 rows affected (0.027 sec)
MariaDB [mythtv_32]> INSERT INTO testtable (chanid, starttime, filesize) VALUES ('123', '2023-01-01T00:00:00Z', '9999');
Query OK, 1 row affected, 1 warning (0.005 sec)
Warning (Code 1265): Data truncated for column 'starttime' at row 1
MariaDB [mythtv_32]> SELECT * FROM testtable WHERE chanid = 123 AND starttime = '2023-01-01T00:00:00Z';
+------------+--------+---------------------+----------+
| recordedid | chanid | starttime | filesize |
+------------+--------+---------------------+----------+
| 1 | 123 | 2023-01-01 00:00:00 | 9999 |
+------------+--------+---------------------+----------+
1 row in set, 1 warning (0.000 sec)
Warning (Code 1292): Truncated incorrect datetime value: '2023-01-01T00:00:00Z'
MariaDB [mythtv_32]> UPDATE testtable SET filesize = 8888 WHERE chanid = 123 AND starttime = '2023-01-01T00:00:00Z';
Query OK, 0 rows affected (0.000 sec)
MariaDB [mythtv_32]> UPDATE testtable SET filesize = 8888 WHERE chanid = 123 AND starttime = CAST('2023-01-01T00:00:00Z' AS datetime);
Query OK, 1 row affected, 2 warnings (0.008 sec)
Rows matched: 1 Changed: 1 Warnings: 2
Warning (Code 1292): Truncated incorrect datetime value: '2023-01-01T00:00:00Z'
Warning (Code 1292): Truncated incorrect datetime value: '2023-01-01T00:00:00Z'
MariaDB [mythtv_32]> SELECT * FROM testtable WHERE chanid = 123 AND starttime = '2023-01-01T00:00:00Z';
+------------+--------+---------------------+----------+
| recordedid | chanid | starttime | filesize |
+------------+--------+---------------------+----------+
| 1 | 123 | 2023-01-01 00:00:00 | 8888 |
+------------+--------+---------------------+----------+
1 row in set, 1 warning (0.000 sec)
Warning (Code 1292): Truncated incorrect datetime value: '2023-01-01T00:00:00Z'