yoku0825’s gists

yoku0825 / yoku0825.gpg.pub

Created October 15, 2013 03:43

gpg公開鍵。

	-----BEGIN PGP PUBLIC KEY BLOCK-----
	Version: GnuPG v2.0.22 (MingW32)

	mQENBFJXVuYBCADRmuVsKCFLne4VcP9EPSMHfs1VEOeecJglw9LDnYv7ArtDKCrC
	mDu6tfqq2tBH5nEfy6BvGDgouge3Au3l0ikak5N18WB9/rfMyUAKL/6JR6yR21IS
	ZFU5wKYSYyvIwEKjljV1w0+a0VcWSk4iMjnmXkZ1UKNKEfLqGHWV/ZiXXi33ohlc
	yDV981r0QmRf03ahnrPmR1LrtSPqCUuikgIX9FjNgfBzYdKK39QxAKjCQk5kXR0t
	v/9B2i/eXT3k+9Hsb3Fu5anI0UUUmN7De+Qsr9omhkhPp7q6fJnvW+QtoXEeQQXY
	jNYWqZ5mDU0SjE0gXm9FzYJeBGy09W6am5CRABEBAAG0HXlva3UwODI1IDx5b2t1
	MDgyNUBnbWFpbC5jb20+iQE5BBMBAgAjBQJSV1bmAhsDBwsJCAcDAgEGFQgCCQoL

yoku0825 / mysql_upgrade.patch

Last active December 25, 2015 16:09

MySQL Bugs #70624 mysql_upgrade with --skip-write-binlog doesn't workのパッチ

	*** client/mysql_upgrade.c.org 2013-09-10 04:23:26.000000000 +0900
	--- client/mysql_upgrade.c 2013-10-18 11:23:45.550804050 +0900
	***************
	* 44,49 **
	--- 44,50 ----

	static DYNAMIC_STRING ds_args;
	static DYNAMIC_STRING conn_args;
	+ static char mysql_arg[FN_REFLEN];

yoku0825 / gist:7655818

Created November 26, 2013 09:48

yoku0825 / mysql-5.6.15_mysqlbinlog.patch

Created December 26, 2013 10:28

Add --secure-auth parameter like mysql command-line client.

	*** client/mysqlbinlog.cc.org 2013-11-18 03:02:54.000000000 +0900
	--- client/mysqlbinlog.cc 2013-12-26 19:27:05.618812123 +0900
	***************
	* 158,163 **
	--- 158,164 ----
	Checkable_rwlock *global_sid_lock= NULL;
	Gtid_set *gtid_set_included= NULL;
	Gtid_set *gtid_set_excluded= NULL;
	+ my_bool opt_secure_auth= FALSE;

yoku0825 / gist:8432956

Created January 15, 2014 08:57

mysql-5.6.15/sql/sql_yacc.yy

	*** sql/sql_yacc.yy.orig 2013-11-18 03:02:54.000000000 +0900
	--- sql/sql_yacc.yy 2014-01-15 17:55:29.909809584 +0900
	***************
	* 1855,1861 **
	opt_precision opt_ignore opt_column opt_restrict
	grant revoke set lock unlock string_list field_options field_option
	field_opt_list opt_binary ascii unicode table_lock_list table_lock
	! ref_list opt_match_clause opt_on_update_delete use
	opt_delete_options opt_delete_option varchar nchar nvarchar
	opt_outer table_list table_name table_alias_ref_list table_alias_ref

yoku0825 / gist:8433252

Created January 15, 2014 09:27

	$ diff -c client/mysql.cc.orig client/mysql.cc
	*** client/mysql.cc.orig 2014-01-15 18:25:45.547811486 +0900
	--- client/mysql.cc 2014-01-15 18:25:58.343812348 +0900
	***************
	* 354,360 **
	#endif
	{ "tee", 'T', com_tee, 1,
	"Set outfile [to_outfile]. Append everything into given outfile." },
	! { "use", 'u', com_use, 1,
	"Use another database. Takes database name as argument." },

yoku0825 / display

Created January 28, 2014 04:59

yoku0825 / backtrace

Created February 3, 2014 10:24

	(gdb) bt full
	#0 mrn_set_geometry (this=<value optimized out>, field=<value optimized out>, buf=0x7f945c8356c0) at ha_mroonga.cpp:1187
	error = 0
	buffer = {
	<my_aligned_storage<24ul, 8ul>> = {
	{
	data = "3\000\000\000\002\000\000\000\b\b\001H\224\177\000\000\360U\203\\\224\177\000",
	align = {<No data fields>}
	}
	}, <No data fields>}

yoku0825 / gist:8797956

Created February 4, 2014 04:01

	make[2]: ディレクトリ `/home/yoku0825/git/mroonga/udf' に入ります
	depbase=`echo mrn_udf_snippet.lo \| sed 's\|[^/]*$\|.deps/&\|;s\|\.lo$\|\|'`;\
	/bin/sh ../libtool --tag=CXX --mode=compile g++ -DHAVE_CONFIG_H -I. -I.. -I/home/yoku0825/mysql-5.6.15/include -I/home/yoku0825/mysql-5.6.15/sql -I/home/yoku0825/mysql-5.6.15/include -I/home/yoku0825/mysql-5.6.15/regex -I/home/yoku0825/mysql-5.6.15 -I/usr/mysql/5.6.15/include -I/usr/groonga/3.1.2.2014.01.30/include/groonga -I.. -I../lib -g -O2 -Wall -Wextra -Wno-unused-parameter -Wno-strict-aliasing -Wno-deprecated -fno-implicit-templates -fno-exceptions -fno-rtti -felide-constructors -MT mrn_udf_snippet.lo -MD -MP -MF $depbase.Tpo -c -o mrn_udf_snippet.lo mrn_udf_snippet.cpp &&\
	mv -f $depbase.Tpo $depbase.Plo
	libtool: compile: g++ -DHAVE_CONFIG_H -I. -I.. -I/home/yoku0825/mysql-5.6.15/include -I/home/yoku0825/mysql-5.6.15/sql -I/home/yoku0825/mysql-5.6.15/include -I/home/yoku0825/mysql-5.6.15/regex -I/home/yoku0825/mysql-5.6.15 -I/usr/mysql/5.6.15/include -I/

yoku0825 / gist:8821138

Last active August 29, 2015 13:56

	mysql> DROP DATABASE IF EXISTS mroonga;
	Query OK, 0 rows affected (0.02 sec)

	mysql> CREATE DATABASE mroonga;
	Query OK, 1 row affected (0.00 sec)

	mysql> use mroonga;
	Database changed

	mysql> CREATE TABLE mroonga.norm_auto (num int unsigned not null, val varchar(32) not null, PRIMARY KEY(num), FULLTEXT KEY(val) Comment 'normalizer "NormalizerAuto"') Engine= mroonga;

yoku0825 yoku0825