Details
Bug
Open
Major
Description
Changes a friend of mine made for the openfire 3.6.0a upgrade scripts to work from 3.4.5
/opt/openfire/resources/database/upgrade/14/openfire_mysql.sql
— had to change jiveRoster:jid varchar(1024) to varchar(255)
— Syntax error (at openfire-v3.5.0-1)
had to change "ALTER COLUMN jid" to "CHANGE COLUMN jid"
.../19/openfire_mysql.sql
— had to change jiveRoster:jid varchar(1024) to varchar(255)
JIDs size is bigger than 255 based on the XMPP spec. The 255 limit exists in old MySQL versions. However in practice most JIDs will not be that big. So the question here is: do we want to be XMPP compliant and support bigger JIDs or do we want to support old versions of MySQL?