Details
Description
When trying to insert a row into a view using the DEFAULT keyword, the server exits with signal 11:
stack_bottom = 0x7ff658047e30 thread_stack 0x48000
|
/usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7ff658a8608b]
|
/usr/sbin/mysqld(handle_fatal_signal+0x422)[0x7ff658639902]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0xf880)[0x7ff657caa880]
|
/usr/sbin/mysqld(_ZN18Item_default_value4walkEM4ItemFbPhEbS1_+0x36)[0x7ff65865ca56]
|
/usr/sbin/mysqld(_Z24check_view_single_updateR4ListI4ItemEPS1_P10TABLE_LISTPyb+0x94)[0x7ff6584c6614]
|
/usr/sbin/mysqld(+0x3ecc6c)[0x7ff6584c6c6c]
|
/usr/sbin/mysqld(_Z20mysql_prepare_insertP3THDP10TABLE_LISTP5TABLER4ListI4ItemEPS7_S8_S8_15enum_duplicatesPPS6_bbb+0x2cb)[0x7ff6584c865b]
|
/usr/sbin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x1c8)[0x7ff6584c9158]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3281)[0x7ff6584e0961]
|
/usr/sbin/mysqld(+0x409cba)[0x7ff6584e3cba]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x14f8)[0x7ff6584e5298]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x47b)[0x7ff6585a76fb]
|
/usr/sbin/mysqld(handle_one_connection+0x47)[0x7ff6585a77d7]
|
/usr/sbin/mysqld(+0x6d2ab0)[0x7ff6587acab0]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8062)[0x7ff657ca3062]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7ff656322a3d]
|
# Table: |
CREATE TABLE `temp` ( |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`test` tinyint(3) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`id`) |
);
|
|
# View: |
CREATE VIEW `temp_view` AS ( |
select `temp`.`id` AS `id`, `temp`.`test` AS `test` from `temp`); |
|
# Insert stmt: |
INSERT INTO `temp_view` SET `test` = DEFAULT; |