Page MenuHomePhabricator
Paste P2336

ENUM is broken in MySQL / MariaDB
ActivePublic

Authored by PleaseStand on Nov 20 2015, 7:02 AM.
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