ENUM is broken in MariaDB
No One
Actions

Authored By

	PleaseStand
	Nov 20 2015, 7:02 AM

Size

1 KB

Referenced Files

None

Subscribers

None

ENUM is broken in MariaDB
View Options

	MariaDB [enwiki_subset]> select cl_type, cl_sortkey, cl_from from categorylinks where cl_to = 'A.F.C._Emley' order by cl_type, cl_sortkey, cl_from\G
	************************* 1. row *************************
	cl_type: page
	cl_sortkey:
	A.F.C. EMLEY
	cl_from: 5664196
	************************* 2. row *************************
	cl_type: subcat
	cl_sortkey: PLAYERS
	A.F.C. EMLEY PLAYERS
	cl_from: 18585943
	************************* 3. row *************************
	cl_type: file
	cl_sortkey: AFCEMLEY.PNG
	cl_from: 19575733
	3 rows in set (0.00 sec)

	MariaDB [enwiki_subset]> select cl_type, cl_sortkey, cl_from from categorylinks where cl_to = 'A.F.C._Emley' order by cl_type, cl_sortkey, cl_from limit 1\G
	************************* 1. row *************************
	cl_type: page
	cl_sortkey:
	A.F.C. EMLEY
	cl_from: 5664196
	1 row in set (0.00 sec)

	MariaDB [enwiki_subset]> select cl_type, cl_sortkey, cl_from from categorylinks where cl_to = 'A.F.C._Emley' and cl_type > 'page' order by cl_type, cl_sortkey, cl_from limit 1\G
	************************* 1. row *************************
	cl_type: subcat
	cl_sortkey: PLAYERS
	A.F.C. EMLEY PLAYERS
	cl_from: 18585943
	1 row in set (0.00 sec)

	MariaDB [enwiki_subset]> select cl_type, cl_sortkey, cl_from from categorylinks where cl_to = 'A.F.C._Emley' and cl_type > 'subcat' order by cl_type, cl_sortkey, cl_from limit 1\G
	Empty set (0.00 sec)

	MariaDB [enwiki_subset]> select cl_type, cl_sortkey, cl_from from categorylinks where cl_to = 'A.F.C._Emley' and cl_type > 'file' order by cl_type, cl_sortkey, cl_from\G
	************************* 1. row *************************
	cl_type: page
	cl_sortkey:
	A.F.C. EMLEY
	cl_from: 5664196
	************************* 2. row *************************
	cl_type: subcat
	cl_sortkey: PLAYERS
	A.F.C. EMLEY PLAYERS
	cl_from: 18585943
	2 rows in set (0.00 sec)

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 2988894
Default Alt Text: ENUM is broken in MariaDB (1 KB)

ENUM is broken in MariaDBNo OneActions

ENUM is broken in MariaDBView Options

File Metadata

Event Timeline

ENUM is broken in MariaDB
No One
Actions

ENUM is broken in MariaDB
View Options