環境

Mysql: 8.0.13

テーブルのマスキングをしたかった

name
山田

↓こうしたい

name
山XX

空文字と文字列が共存するカラムに正規表現置換を行った。


UPDATE table
SET
  name = REGEXP_REPLACE(name, '^(.{1})(.*)', '$1XX');

エラーでMysqlが落ちた。

mysql     | terminate called after throwing an instance of 'std::out_of_range'
mysql     |   what():  basic_string::at: __n (which is 0) >= this->size() (which is 0)
mysql     | 05:46:54 UTC - mysqld got signal 6 ;
mysql     | This could be because you hit a bug. It is also possible that this binary
mysql     | or one of the libraries it was linked against is corrupt, improperly built,
mysql     | or misconfigured. This error can also be caused by malfunctioning hardware.
mysql     | Attempting to collect some information that could help diagnose the problem.
mysql     | As this is a crash and something is definitely wrong, the information
mysql     | collection process might fail.
mysql     | 
mysql     | key_buffer_size=8388608
mysql     | read_buffer_size=131072
mysql     | max_used_connections=1
mysql     | max_threads=151
mysql     | thread_count=2
mysql     | connection_count=1
mysql     | It is possible that mysqld could use up to 
mysql     | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67846 K  bytes of memory
mysql     | Hope that's ok; if not, decrease some variables in the equation.
mysql     | 
mysql     | Thread pointer: 0x7fe424000b50
mysql     | Attempting backtrace. You can use the following information to find out
mysql     | where mysqld died. If you see no messages after this, something went
mysql     | terribly wrong...
mysql     | stack_bottom = 7fe47c13cdc0 thread_stack 0x46000
mysql     | /usr/sbin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x2e) [0x55a417fadade]
mysql     | /usr/sbin/mysqld(handle_fatal_signal+0x4c1) [0x55a41721f171]
mysql     | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0) [0x7fe491b420c0]
mysql     | /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf) [0x7fe48fdd7fff]
mysql     | /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fe48fdd942a]
mysql     | /usr/lib/x86_64-linux-gnu/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x15d) [0x7fe4906f00ad]
mysql     | /usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8f066) [0x7fe4906ee066]
mysql     | /usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8f0b1) [0x7fe4906ee0b1]
mysql     | /usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0x8f2c9) [0x7fe4906ee2c9]
mysql     | /usr/lib/x86_64-linux-gnu/libstdc++.so.6(std::__throw_out_of_range_fmt(char const*, ...)+0xf5) [0x7fe490716b85]
mysql     | /usr/sbin/mysqld(+0x107c6ed) [0x55a41747d6ed]
mysql     | /usr/sbin/mysqld(regexp::Regexp_engine::AppendTail()+0x15) [0x55a41747dab5]
mysql     | /usr/sbin/mysqld(regexp::Regexp_engine::Replace(std::__cxx11::basic_string<char16_t, std::char_traits<char16_t>, std::allocator<char16_t> > const&, int, int)+0x11d) [0x55a41747dc4d]
mysql     | /usr/sbin/mysqld(regexp::Regexp_facade::Replace(Item*, Item*, long, int, String*)+0xbe) [0x55a41747e99e]
mysql     | /usr/sbin/mysqld(Item_func_regexp_replace::val_str(String*)+0xd2) [0x55a4173c9c62]
mysql     | /usr/sbin/mysqld(Item::save_in_field_inner(Field*, bool)+0x7e) [0x55a41733db8e]
mysql     | /usr/sbin/mysqld(Item::save_in_field(Field*, bool)+0x44) [0x55a417355e34]
mysql     | /usr/sbin/mysqld(fill_record(THD*, TABLE*, List<Item>&, List<Item>&, MY_BITMAP*, MY_BITMAP*)+0xe1) [0x55a4170aa221]
mysql     | /usr/sbin/mysqld(fill_record_n_invoke_before_triggers(THD*, COPY_INFO*, List<Item>&, List<Item>&, TABLE*, enum_trigger_event_type, int)+0x1fd) [0x55a4170aa53d]
mysql     | /usr/sbin/mysqld(Sql_cmd_update::update_single_table(THD*)+0x1498) [0x55a4171c39b8]
mysql     | /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x2d2) [0x55a41715daf2]
mysql     | /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x2531) [0x55a41710df41]
mysql     | /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x3e0) [0x55a417111b80]
mysql     | /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2d13) [0x55a417114cc3]

mysql     | /usr/sbin/mysqld(do_command(THD*)+0x180) [0x55a4171157d0]
mysql     | /usr/sbin/mysqld(+0xe113e8) [0x55a4172123e8]
mysql     | /usr/sbin/mysqld(+0x204da2f) [0x55a41844ea2f]
mysql     | /lib/x86_64-linux-gnu/libpthread.so.0(+0x7494) [0x7fe491b38494]
mysql     | /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7fe48fe8dacf]
mysql     | 
mysql     | Trying to get some variables.
mysql     | Some pointers may be invalid and cause the dump to abort.
mysql     | Query (7fe42400b4f8): /* ApplicationName=DataGrip 2018.2.4 */ update request set     request_user_position_name = regexp_replace(request_user_position_name, '^(.{1})(.*)', '$1XXXXXX')
mysql     | Connection ID (thread ID): 8
mysql     | Status: NOT_KILLED
mysql     | 
mysql     | The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
mysql     | information that should help you find out what is causing the crash.

これでエラー回避

UPDATE table
SET
  name = CASE WHEN name REGEXP '^(.{1})(.*)'
    THEN REGEXP_REPLACE(name, '^(.{1})(.*)', '$1XX') END;