Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1388555
  2. Activity log

Activity log for bug #1388555

Date Who What changed Old value New value Message
2014-11-02 13:01:39 Elena Stepanova bug added bug
2014-11-02 13:08:02 Elena Stepanova summary SET STATEMENT character_set_client has no effect SET STATEMENT character_set_client, character_set_connection have no effect
2014-11-02 13:08:46 Elena Stepanova description MySQL [test]> set names utf8; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) MySQL [test]> set statement character_set_client = latin5 for select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) # Compare with: MySQL [test]> set character_set_client = latin5; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +----------+ | фи | +----------+ | фи | +----------+ 1 row in set (0.00 sec) MySQL [test]> set names utf8; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) MySQL [test]> set statement character_set_client = latin5 for select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) # Compare with: MySQL [test]> set character_set_client = latin5; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +----------+ | фи | +----------+ | фи | +----------+ 1 row in set (0.00 sec) #--------------------------------------------------------------- MySQL [test]> set names utf8; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.01 sec) MySQL [test]> set statement CHARACTER_SET_CONNECTION = latin5 for select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) # Compare with: MySQL [test]> set character_set_connection = latin5; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +----+ | ?? | +----+ | ?? | +----+ 1 row in set (0.00 sec)
2014-11-02 13:24:04 Elena Stepanova summary SET STATEMENT character_set_client, character_set_connection have no effect SET STATEMENT character_set_client, character_set_connection, character_set_filesystem have no effect
2014-11-02 13:24:52 Elena Stepanova description MySQL [test]> set names utf8; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) MySQL [test]> set statement character_set_client = latin5 for select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) # Compare with: MySQL [test]> set character_set_client = latin5; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +----------+ | фи | +----------+ | фи | +----------+ 1 row in set (0.00 sec) #--------------------------------------------------------------- MySQL [test]> set names utf8; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.01 sec) MySQL [test]> set statement CHARACTER_SET_CONNECTION = latin5 for select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) # Compare with: MySQL [test]> set character_set_connection = latin5; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +----+ | ?? | +----+ | ?? | +----+ 1 row in set (0.00 sec) MySQL [test]> set names utf8; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) MySQL [test]> set statement character_set_client = latin5 for select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) # Compare with: MySQL [test]> set character_set_client = latin5; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +----------+ | фи | +----------+ | фи | +----------+ 1 row in set (0.00 sec) #--------------------------------------------------------------- MySQL [test]> set names utf8; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.01 sec) MySQL [test]> set statement CHARACTER_SET_CONNECTION = latin5 for select 'фи'; +------+ | фи | +------+ | фи | +------+ 1 row in set (0.00 sec) # Compare with: MySQL [test]> set character_set_connection = latin5; Query OK, 0 rows affected (0.00 sec) MySQL [test]> select 'фи'; +----+ | ?? | +----+ | ?? | +----+ 1 row in set (0.00 sec) #--------------------------------------------------------------- MySQL [test]> set names utf8; Query OK, 0 rows affected (0.00 sec) MySQL [test]> system touch 'файл'; MySQL [test]> create table tmp (i int); Query OK, 0 rows affected (0.64 sec) MySQL [test]> set statement CHARACTER_SET_FILESYSTEM = latin5 for load data local infile 'файл' into table tmp; Query OK, 0 rows affected (0.00 sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 # Compare with: MySQL [test]> set character_set_filesystem = latin5; Query OK, 0 rows affected (0.00 sec) MySQL [test]> load data local infile 'файл' into table tmp; ERROR 2 (HY000): File '????' not found (Errcode: 2)
2014-11-02 13:28:18 Valerii Kravchuk percona-server: status New Confirmed
2014-11-02 13:28:32 Valerii Kravchuk nominated for series percona-server/5.6
2014-11-02 13:28:32 Valerii Kravchuk bug task added percona-server/5.6
2014-11-03 04:41:19 Laurynas Biveinis tags set-statement
2014-11-03 04:41:24 Laurynas Biveinis percona-server/5.6: importance Undecided Medium
2014-11-03 04:41:26 Laurynas Biveinis percona-server/5.6: status Confirmed Triaged
2016-03-25 14:34:07 Laurynas Biveinis nominated for series percona-server/5.7
2016-03-25 14:34:07 Laurynas Biveinis bug task added percona-server/5.7