ENUM is broken in MySQL / MariaDB
ActivePublic
Actions

Authored by PleaseStand on Nov 20 2015, 7:02 AM.

Project Tags

None

Referenced Files

	F2979234: ENUM is broken in MariaDB
	Feb 24 2016, 5:27 AM

Subscribers

None

	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)

Event Timeline

PleaseStand changed the title of this paste from untitled to ENUM is broken in MariaDB.Nov 20 2015, 7:02 AM

PleaseStand edited the content of this paste. (Show Details)

PleaseStand changed the title of this paste from ENUM is broken in MariaDB to ENUM is broken in MySQL / MariaDB.Nov 20 2015, 7:05 AM

PleaseStand mentioned this in T119173: RFC: Discourage use of MySQL's ENUM type.Nov 20 2015, 7:37 AM

ENUM is broken in MySQL / MariaDBActivePublicActions

Event Timeline

ENUM is broken in MySQL / MariaDB
ActivePublic
Actions