Fatal InnoDB error or assertion `!is_v' failure upon multi-update with indexed virtual column

EXPLAIN UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d);

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	SIMPLE	t1	index	NULL	d	6	NULL	455	Using index

1	SIMPLE	t2	ref	t,d	t	4	func	1	Using where

EXPLAIN UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d);

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	SIMPLE	t1	index	NULL	d	6	NULL	547	Using index

1	SIMPLE	t2	ref|filter	t,d	t|d	4|6	func	2 (83%)	Using where; Using rowid filter

--source include/have_innodb.inc

SET GLOBAL innodb_stats_persistent= 0;

CREATE TABLE t (

  pk INTEGER AUTO_INCREMENT,

  d DATETIME DEFAULT '2000-01-01 00:00:00',

  t TIME AS (TIME(d)) VIRTUAL,

  f1 TIME,

  f2 DATETIME DEFAULT '2000-01-01 00:00:00',

  f3 VARCHAR(1) DEFAULT 'x',

  f4 VARCHAR(1) DEFAULT 'x',

  PRIMARY KEY (pk),

  KEY (t),

  KEY (d)

) ENGINE=InnoDB;

INSERT INTO t (d) VALUES

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-03-26 00:00:00'),

  ('1900-05-19 19:48:19'),('1901-05-02 00:00:00'),('1901-12-12 23:05:43'),

  ('1902-05-31 00:00:00'),('1902-06-17 00:00:00'),('1902-11-06 08:31:01'),

  ('1903-06-11 00:00:00'),('1904-01-16 09:00:30'),('1904-02-24 08:17:28'),

  ('1904-04-03 00:00:00'),('1905-01-17 00:00:00'),('1905-05-23 04:59:29'),

  ('1905-09-22 21:52:15'),('1905-12-06 13:11:49'),('1906-02-27 10:51:18'),

  ('1906-06-08 20:01:15'),('1907-02-09 23:08:14'),('1907-04-03 08:33:28'),

  ('1907-11-23 19:00:13'),('1908-09-03 03:19:29'),('1908-10-03 20:54:11'),

  ('1908-12-22 09:47:25'),('1909-04-10 10:29:16'),('1911-03-11 00:00:00'),

  ('1911-06-30 00:00:00'),('1911-08-07 01:32:56'),('1912-03-08 00:00:00'),

  ('1912-03-10 00:00:00'),('1912-03-13 11:40:19'),('1912-11-12 20:10:13'),

  ('1913-01-10 00:00:00'),('1913-09-15 18:43:53'),('1913-10-10 00:00:00'),

  ('1913-10-11 00:00:00'),('1914-01-18 17:52:52'),('1915-07-10 23:29:43'),

  ('1915-09-05 00:00:00'),('1915-09-25 14:42:14'),('1916-04-17 00:00:00'),

  ('1916-11-02 23:33:35'),('1917-04-22 13:14:41'),('1917-05-12 00:00:00'),

  ('1917-05-23 16:50:52'),('1917-06-24 12:14:19'),('1917-09-17 07:37:32'),

  ('1918-01-04 18:27:31'),('1918-05-02 12:55:51'),('1918-05-18 00:00:00'),

  ('1918-08-05 21:51:15'),('1918-09-12 19:27:33'),('1919-02-18 22:26:53'),

  ('1919-07-24 00:54:48'),('1919-09-07 22:41:09'),('1919-10-04 16:12:01'),

  ('1919-12-06 04:40:47'),('1920-01-28 00:00:00'),('1920-05-07 14:45:18'),

  ('1920-06-07 16:44:53'),('1921-02-15 11:55:05'),('1921-04-16 00:00:00'),

  ('1921-07-06 00:00:00'),('1922-04-13 00:00:00'),('1922-11-25 13:15:40'),

  ('1922-12-10 00:00:00'),('1923-02-01 00:00:00'),('1923-04-07 00:00:00'),

  ('1923-08-12 08:57:05'),('1923-10-22 00:00:00'),('1924-03-09 00:00:00'),

  ('1924-07-01 14:53:14'),('1924-07-04 23:45:21'),('1924-07-28 07:16:47'),

  ('1924-12-02 11:49:57'),('1925-09-09 00:00:00'),('1925-11-06 00:00:00'),

  ('1926-05-04 00:00:00'),('1926-06-21 06:38:24'),('1926-09-26 07:03:33'),

  ('1926-10-24 00:00:00'),('1926-11-17 03:12:56'),('1926-12-01 10:37:11'),

  ('1926-12-26 01:06:29'),('1927-08-25 00:00:00'),('1927-08-25 01:00:09'),

  ('1928-02-29 01:21:11'),('1928-03-08 00:00:00'),('1928-05-07 08:14:46'),

  ('1928-06-11 02:30:03'),('1928-09-04 03:56:02'),('1928-09-14 00:10:49'),

  ('1929-11-23 23:11:52'),('1929-12-10 00:00:00'),('1930-05-01 00:00:00'),

  ('1930-05-07 00:25:07'),('1931-04-26 00:00:00'),('1931-06-05 23:04:47'),

  ('1931-07-08 23:24:45'),('1932-10-08 00:00:00'),('1932-10-22 00:00:00'),

  ('1933-08-27 23:05:40'),('1933-10-21 05:28:44'),('1934-07-09 00:00:00'),

  ('1934-09-27 10:53:33'),('1935-04-01 00:00:00'),('1935-05-08 09:40:03'),

  ('1935-10-24 20:43:43'),('1935-11-18 11:22:59'),('1936-05-10 00:00:00'),

  ('1936-09-03 00:00:00'),('1937-02-16 06:36:19'),('1937-03-16 00:00:00'),

  ('1937-05-16 20:05:38'),('1937-09-12 00:00:00'),('1939-01-03 00:00:00'),

  ('1940-09-18 00:00:00'),('1940-10-26 00:00:00'),('1941-02-08 05:23:51'),

  ('1941-04-18 00:00:00'),('1941-07-01 00:00:00'),('1941-08-21 00:00:00'),

  ('1941-12-17 13:48:07'),('1942-09-17 15:03:18'),('1942-11-28 20:49:30'),

  ('1943-01-18 00:18:15'),('1943-05-20 00:00:00'),('1943-06-01 00:00:00'),

  ('1943-12-16 11:48:11'),('1943-12-31 12:45:58'),('1944-01-15 06:43:50'),

  ('1944-03-19 00:00:00'),('1944-03-23 00:00:00'),('1944-05-19 00:00:00'),

  ('1944-06-13 09:26:18'),('1944-07-19 11:52:08'),('1944-08-11 00:00:00'),

  ('1944-10-27 00:00:00'),('1945-01-17 17:55:51'),('1945-02-23 20:54:46'),

  ('1945-03-04 07:58:13'),('1945-05-07 00:00:00'),('1945-06-12 00:00:00'),

  ('1945-07-14 09:47:28'),('1945-10-24 19:31:58'),('1945-11-03 00:00:00'),

  ('1945-11-26 20:13:02'),('1945-12-24 00:00:00'),('1946-10-06 00:00:00'),

  ('1946-10-23 00:00:00'),('1946-11-19 03:11:21'),('1947-01-02 05:04:16'),

  ('1947-09-23 23:57:34'),('1947-11-30 00:50:13'),('1948-03-05 18:11:03'),

  ('1948-03-09 02:33:13'),('1948-04-10 00:24:59'),('1948-06-01 08:51:57'),

  ('1948-07-27 16:11:03'),('1948-10-29 05:29:57'),('1949-06-13 00:38:11'),

  ('1949-10-14 01:50:48'),('1950-02-12 00:00:00'),('1950-02-21 22:38:06'),

  ('1950-03-26 07:56:02'),('1951-01-31 13:12:27'),('1951-04-17 13:35:33'),

  ('1951-08-17 11:51:53'),('1951-12-31 00:00:00'),('1952-05-25 06:22:51'),

  ('1953-05-02 14:26:04'),('1953-06-19 19:35:42'),('1953-07-02 18:01:07'),

  ('1953-11-01 14:27:14'),('1954-01-05 02:40:21'),('1954-05-01 05:52:08'),

  ('1954-06-05 15:11:12'),('1955-01-12 00:00:00'),('1955-02-03 19:51:41'),

  ('1955-02-27 15:38:21'),('1955-05-25 00:00:00'),('1955-08-22 19:47:38'),

  ('1955-08-30 08:38:26'),('1955-12-15 22:02:31'),('1956-08-17 00:00:00'),

  ('1956-09-17 06:58:08'),('1956-10-02 00:00:00'),('1957-05-15 05:05:17'),

  ('1958-11-01 10:11:48'),('1959-03-31 00:00:00'),('1959-11-02 23:28:29'),

  ('1960-01-26 21:57:36'),('1960-10-31 00:00:00'),('1960-11-18 11:19:40'),

  ('1961-03-22 01:28:24'),('1961-07-11 03:48:39'),('1962-11-08 00:00:00'),

  ('1963-02-27 12:25:30'),('1963-04-11 00:44:21'),('1963-06-26 03:25:23'),

  ('1963-07-26 16:14:47'),('1963-08-14 08:09:23'),('1963-10-28 15:24:24'),

  ('1964-01-11 21:08:21'),('1964-05-26 05:12:28'),('1965-03-18 22:49:37'),

  ('1966-03-26 18:42:55'),('1966-09-11 22:46:33'),('1967-01-21 00:00:21'),

  ('1967-02-28 02:47:14'),('1967-06-09 13:27:40'),('1967-06-29 00:49:17'),

  ('1967-09-29 00:00:00'),('1967-12-14 06:37:06'),('1968-02-04 11:27:22'),

  ('1968-03-15 21:33:37'),('1968-08-31 18:53:30'),('1968-09-04 00:00:00'),

  ('1968-09-11 00:00:00'),('1968-11-07 02:40:13'),('1968-11-28 01:29:10'),

  ('1969-01-31 00:00:00'),('1969-05-04 09:11:55'),('1969-10-28 19:10:25'),

  ('1970-01-02 00:00:00'),('1970-06-09 05:45:57'),('1970-07-17 10:13:47'),

  ('1970-12-21 16:08:41'),('1971-02-03 00:00:00'),('1971-10-03 00:00:00'),

  ('1971-12-30 17:44:34'),('1972-03-12 04:03:57'),('1972-08-27 00:00:00'),

  ('1972-09-13 13:44:08'),('1972-11-26 00:00:00'),('1973-05-28 00:00:00'),

  ('1974-03-30 00:00:00'),('1974-05-23 19:28:42'),('1974-08-03 07:58:03'),

  ('1975-09-20 04:00:22'),('1975-11-03 16:41:33'),('1975-12-20 00:00:00'),

  ('1976-01-07 00:55:02'),('1976-05-14 11:04:05'),('1976-08-04 15:11:46'),

  ('1976-08-18 17:11:29'),('1977-03-03 19:45:25'),('1977-09-11 22:10:22'),

  ('1977-12-13 06:18:33'),('1979-05-05 16:04:17'),('1979-06-02 22:22:32'),

  ('1979-12-08 00:00:00'),('1980-02-03 09:54:52'),('1980-05-30 02:23:29'),

  ('1980-07-14 17:19:17'),('1980-12-15 00:00:00'),('1981-04-13 19:17:48'),

  ('1981-11-21 16:22:17'),('1982-04-06 04:42:04'),('1982-11-24 12:17:25'),

  ('1983-12-04 16:23:48'),('1984-04-26 00:00:00'),('1984-07-30 00:00:00'),

  ('1985-01-02 00:00:00'),('1985-07-23 05:12:22'),('1985-10-04 14:56:23'),

  ('1985-12-02 17:47:43'),('1986-03-01 00:00:00'),('1986-08-30 03:27:04'),

  ('1987-01-16 14:09:52'),('1987-02-03 03:55:02'),('1987-03-03 12:04:10'),

  ('1987-09-21 11:28:54'),('1988-04-24 20:59:14'),('1988-06-13 18:25:07'),

  ('1988-07-04 00:00:00'),('1988-07-23 10:09:14'),('1988-08-26 09:41:22'),

  ('1989-07-25 05:19:18'),('1990-07-13 00:00:00'),('1990-07-22 16:52:29'),

  ('1990-08-22 22:40:34'),('1991-01-09 00:00:00'),('1991-02-25 02:06:00'),

  ('1991-04-26 00:00:00'),('1991-10-20 12:57:55'),('1991-11-15 12:18:40'),

  ('1992-06-15 03:23:28'),('1992-08-22 11:08:44'),('1992-12-06 23:07:49'),

  ('1992-12-23 10:48:27'),('1993-07-18 18:05:03'),('1993-08-28 12:46:25'),

  ('1994-06-01 18:17:38'),('1994-08-25 14:39:37'),('1994-12-02 00:00:00'),

  ('1995-04-21 04:09:34'),('1995-06-28 21:26:52'),('1995-07-11 03:04:35'),

  ('1995-09-24 00:00:00'),('1996-06-27 02:43:39'),('1997-10-05 09:25:29'),

  ('1997-10-16 01:24:59'),('1999-01-16 00:00:00'),('1999-05-28 06:52:34'),

  ('1999-08-11 12:35:50'),('2000-04-30 00:00:00'),('2000-11-04 12:40:42'),

  ('2001-01-29 07:51:53'),('2001-09-05 11:22:16'),('2002-02-01 19:34:03'),

  ('2003-02-18 00:00:00'),('2003-03-06 00:00:00'),('2003-05-22 00:00:00'),

  ('2004-02-19 00:00:00'),('2004-05-12 00:00:00'),('2004-09-10 00:00:00'),

  ('2005-02-04 21:34:25'),('2005-03-08 14:48:55'),('2005-03-28 09:35:18'),

  ('2005-06-17 10:29:21'),('2005-08-06 07:43:46'),('2006-01-03 11:02:29'),

  ('2006-03-11 00:42:35'),('2006-03-25 13:55:48'),('2006-10-25 23:18:04'),

  ('2007-07-10 21:14:32'),('2007-09-26 15:45:08'),('2007-11-28 19:07:20'),

  ('2008-06-04 08:48:59'),('2008-07-18 00:00:00'),('2008-08-14 03:00:01'),

  ('2008-11-28 05:02:23'),('2008-11-29 16:07:13'),('2010-09-09 11:08:48'),

  ('2011-01-17 12:47:26'),('2011-03-25 06:25:51'),('2011-05-06 03:38:56'),

  ('2012-02-06 14:45:33'),('2012-05-01 00:46:29'),('2012-05-23 13:56:45'),

  ('2012-09-17 15:14:54'),('2012-12-12 21:21:34'),('2013-04-16 00:00:00'),

  ('2014-03-10 05:07:51'),('2014-05-09 23:13:07'),('2014-07-24 06:41:03'),

  ('2014-07-27 05:13:13'),('2015-05-05 05:31:40'),('2016-05-18 14:44:12'),

  ('2016-09-29 00:00:00'),('2017-01-27 00:00:00'),('2017-05-03 01:50:33'),

  ('2017-06-09 00:53:25'),('2017-09-12 04:34:06'),('2018-02-01 07:14:12'),

  ('2018-03-22 22:16:24'),('2018-04-20 08:19:24'),('2018-07-25 19:32:34'),

  ('2018-08-09 00:00:00'),('2019-03-23 00:00:00'),('2019-12-18 15:04:21'),

  ('2020-04-09 15:54:29'),('2020-09-13 15:05:56'),('2021-04-21 08:07:20'),

  ('2021-05-04 10:09:48'),('2021-06-18 00:00:00'),('2021-09-06 00:00:00'),

  ('2022-10-24 00:00:00'),('2022-11-24 02:54:09'),('2023-04-07 16:59:25'),

  ('2023-11-26 00:00:00'),('2024-04-01 11:20:53'),('2024-04-19 00:00:00'),

  ('2024-09-16 05:45:31'),('2024-10-15 02:07:05'),('2024-11-05 00:00:00'),

  ('2024-12-27 02:53:35'),('2025-02-04 00:00:00'),('2025-05-05 12:19:13'),

  ('2025-08-20 00:00:00'),('2025-09-25 01:09:50'),('2027-03-02 10:18:54'),

  ('2028-08-20 00:00:00'),('2028-11-18 16:08:10'),('2029-01-20 11:11:25'),

  ('2029-11-06 00:00:00'),('2030-06-11 10:48:40'),('2030-08-24 01:16:16'),

  ('2031-03-08 20:50:33'),('2031-04-25 21:26:00'),('2032-05-31 14:26:32'),

  ('2032-07-28 04:02:35'),('2033-04-30 03:04:26'),('2033-06-16 15:07:21'),

  ('2033-08-11 10:08:08'),('2033-09-21 07:18:35'),('2034-01-25 13:32:44'),

  ('2034-01-30 15:30:45'),('2034-08-26 19:59:15'),('2034-12-01 23:39:50'),

  ('2034-12-25 00:00:00'),('2035-04-12 07:50:46'),('2035-04-25 15:36:36'),

  ('2035-05-25 20:29:49'),('2035-06-06 20:59:57'),('2035-07-15 20:11:20'),

  ('2035-08-02 09:53:16'),('2035-08-03 00:00:00'),('2035-12-08 00:00:00'),

  ('2036-03-13 10:35:23'),('2036-03-25 16:31:32'),('2036-09-06 12:50:17'),

  ('2036-10-07 02:50:31'),('2037-05-26 00:00:00'),('2037-11-21 05:17:58'),

  ('2038-02-11 07:16:04'),('2038-04-08 00:16:00'),('2038-05-26 01:10:18'),

  ('2038-11-17 09:13:06'),('2039-03-10 11:41:13'),('2039-11-08 10:08:53');

UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d);

# Cleanup

DROP TABLE t;

SET GLOBAL innodb_stats_persistent= DEFAULT;

2023-04-30  2:52:32 36 [ERROR] [FATAL] InnoDB: Clustered record field for column 6 not found table n_user_defined 1 index n_user_defined 6 InnoDB table `test`.`t` field name NULL MySQL table t field name DB_ROW_ID n_fields 6 query UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)

230430  2:52:32 [ERROR] mysqld got signal 6 ;

#2  <signal handler called>

#3  __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at ./nptl/pthread_kill.c:44

#4  0x00007f4a3f2a9d2f in __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78

#5  0x00007f4a3f25aef2 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26

#6  0x00007f4a3f245472 in __GI_abort () at ./stdlib/abort.c:79

#7  0x000055cf561ced91 in ib::fatal::~fatal (this=this@entry=0x7f4a305a6400, __in_chrg=<optimized out>) at /data/src/11.1/storage/innobase/ut/ut0ut.cc:527

#8  0x000055cf561aff10 in build_template_field (prebuilt=<optimized out>, clust_index=clust_index@entry=0x7f49ac033fd0, index=index@entry=0x7f49ac033fd0, table=<optimized out>, field=field@entry=0x7f49acb22ce0, i=i@entry=6, v_no=<optimized out>) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7137

#9  0x000055cf567f974d in ha_innobase::build_template (this=this@entry=0x7f49acb224d0, whole_row=<optimized out>, whole_row@entry=false) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7521

#10 0x000055cf567fa280 in ha_innobase::change_active_index (this=0x7f49acb224d0, keynr=<optimized out>) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:9171

#11 0x000055cf56391168 in handler::ha_index_init (sorted=<optimized out>, idx=1, this=0x7f49acb224d0) at /data/src/11.1/sql/handler.h:3409

#12 join_read_always_key (tab=0x7f49acb0e0f0) at /data/src/11.1/sql/sql_select.cc:23811

#13 0x000055cf5637b1e1 in sub_select (join=0x7f49ac012ec0, join_tab=0x7f49acb0e0f0, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23036

#14 0x000055cf56369e41 in evaluate_join_record (join=join@entry=0x7f49ac012ec0, join_tab=join_tab@entry=0x7f49acb0dcf0, error=<optimized out>) at /data/src/11.1/sql/sql_select.cc:23272

#15 0x000055cf5637b1fd in sub_select (join=0x7f49ac012ec0, join_tab=0x7f49acb0dcf0, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23039

#16 0x000055cf563a8d5d in do_select (procedure=<optimized out>, join=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:22571

#17 JOIN::exec_inner (this=this@entry=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:4899

#18 0x000055cf563a91ee in JOIN::exec (this=this@entry=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:4676

#19 0x000055cf563a9316 in Sql_cmd_dml::execute_inner (this=this@entry=0x7f49ac0124e8, thd=thd@entry=0x7f49ac000c68) at /data/src/11.1/sql/sql_select.cc:32615

#20 0x000055cf56406b01 in Sql_cmd_update::execute_inner (this=0x7f49ac0124e8, thd=0x7f49ac000c68) at /data/src/11.1/sql/sql_update.cc:3062

#21 0x000055cf563686cd in Sql_cmd_dml::execute (this=0x7f49ac0124e8, thd=0x7f49ac000c68) at /data/src/11.1/sql/sql_select.cc:32552

#22 0x000055cf563323d6 in mysql_execute_command (thd=thd@entry=0x7f49ac000c68, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/src/11.1/sql/sql_parse.cc:4393

#23 0x000055cf56335ff5 in mysql_parse (thd=0x7f49ac000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/src/11.1/sql/sql_parse.cc:7760

#24 0x000055cf563382d5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f49ac000c68, packet=packet@entry=0x7f49ac1031d9 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", packet_length=packet_length@entry=88, blocking=blocking@entry=true) at /data/src/11.1/sql/sql_parse.cc:1989

#25 0x000055cf563395d7 in do_command (thd=0x7f49ac000c68, blocking=blocking@entry=true) at /data/src/11.1/sql/sql_parse.cc:1405

#26 0x000055cf564498e7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55cf5a22cf88, put_in_cache=put_in_cache@entry=true) at /data/src/11.1/sql/sql_connect.cc:1416

#27 0x000055cf56449c7d in handle_one_connection (arg=arg@entry=0x55cf5a22cf88) at /data/src/11.1/sql/sql_connect.cc:1318

#28 0x000055cf56759ad7 in pfs_spawn_thread (arg=0x55cf5a1e0608) at /data/src/11.1/storage/perfschema/pfs.cc:2201

#29 0x00007f4a3f2a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#30 0x00007f4a3f3285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

mariadbd: /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7400: void ha_innobase::build_template(bool): Assertion `!is_v' failed.

230430  2:57:32 [ERROR] mysqld got signal 6 ;

#9  0x00007fdbdc453df2 in __GI___assert_fail (assertion=0x55a20fb36440 "!is_v", file=0x55a20fb2a8c0 "/data/src/11.1/storage/innobase/handler/ha_innodb.cc", line=7400, function=0x55a20fb363e0 "void ha_innobase::build_template(bool)") at ./assert/assert.c:101

#10 0x000055a20e3611f9 in ha_innobase::build_template (this=0x61d0004844b8, whole_row=true) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7400

#11 0x000055a20e36d352 in ha_innobase::change_active_index (this=0x61d0004844b8, keynr=1) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:9171

#12 0x000055a20e36a2dc in ha_innobase::index_init (this=0x61d0004844b8, keynr=1) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:8744

#13 0x000055a20cdac9f5 in handler::ha_index_init (this=0x61d0004844b8, idx=1, sorted=false) at /data/src/11.1/sql/handler.h:3409

#14 0x000055a20d25fd3a in join_read_always_key (tab=0x62900086d680) at /data/src/11.1/sql/sql_select.cc:23811

#15 0x000055a20d25a637 in sub_select (join=0x62900010b810, join_tab=0x62900086d680, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23036

#16 0x000055a20d25bf77 in evaluate_join_record (join=0x62900010b810, join_tab=0x62900086d280, error=0) at /data/src/11.1/sql/sql_select.cc:23272

#17 0x000055a20d25a7f3 in sub_select (join=0x62900010b810, join_tab=0x62900086d280, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23039

#18 0x000055a20d2585b9 in do_select (join=0x62900010b810, procedure=0x0) at /data/src/11.1/sql/sql_select.cc:22571

#19 0x000055a20d1da6df in JOIN::exec_inner (this=0x62900010b810) at /data/src/11.1/sql/sql_select.cc:4899

#20 0x000055a20d1d7a62 in JOIN::exec (this=0x62900010b810) at /data/src/11.1/sql/sql_select.cc:4676

#21 0x000055a20d29f962 in Sql_cmd_dml::execute_inner (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_select.cc:32615

#22 0x000055a20d44edf7 in Sql_cmd_update::execute_inner (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_update.cc:3062

#23 0x000055a20d29f44e in Sql_cmd_dml::execute (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_select.cc:32552

#24 0x000055a20d0c7ead in mysql_execute_command (thd=0x62b00017a218, is_called_from_prepared_stmt=false) at /data/src/11.1/sql/sql_parse.cc:4393

#25 0x000055a20d0df33a in mysql_parse (thd=0x62b00017a218, rawbuf=0x629000109238 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", length=88, parser_state=0x7fdbc47daa20) at /data/src/11.1/sql/sql_parse.cc:7760

#26 0x000055a20d0b7ab1 in dispatch_command (command=COM_QUERY, thd=0x62b00017a218, packet=0x6290008c0219 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", packet_length=88, blocking=true) at /data/src/11.1/sql/sql_parse.cc:1892

#27 0x000055a20d0b47ef in do_command (thd=0x62b00017a218, blocking=true) at /data/src/11.1/sql/sql_parse.cc:1405

#28 0x000055a20d56c6e2 in do_handle_one_connection (connect=0x60800005c8b8, put_in_cache=true) at /data/src/11.1/sql/sql_connect.cc:1416

#29 0x000055a20d56c0a3 in handle_one_connection (arg=0x608000003a38) at /data/src/11.1/sql/sql_connect.cc:1318

#30 0x000055a20e165870 in pfs_spawn_thread (arg=0x617000008218) at /data/src/11.1/storage/perfschema/pfs.cc:2201

#31 0x00007fdbdc4a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#32 0x00007fdbdc5285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81