Skip to content

Instantly share code, notes, and snippets.

@milano
milano / gist:11240759
Last active August 29, 2015 14:00
mroongaのストレージモードとラッパーモードでint default nullの挙動が違う

ストレージモード

mysql> show create table storage;
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                                                                           |
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| storage | CREATE TABLE `storage` (
  `id` int(10) unsigned NOT NULL,
  `test` int(11) DEFAULT NULL,

PRIMARY KEY (id)

@milano
milano / gist:11240352
Last active August 29, 2015 14:00
mroongaのストレージモードにおいてUNIQUEインデックスでDuplicateエラーが発生する
# uname -a
Linux **** 3.10.34-37.137.amzn1.x86_64 #1 SMP Tue Mar 25 01:00:47 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

# mysql --version
mysql  Ver 14.14 Distrib 5.5.36, for Linux (x86_64) using readline 5.1

# groonga --version
groonga 4.0.1 [linux-gnu,x86_64,utf8,match-escalation-threshold=0,nfkc,mecab,zlib,lzo,epoll]

mysql> show variables like '%mroonga%';