[zanata-bugs] [Bug 1048293] TECH DEBT: support mysql/mariadb 5.6 database for Zanata

[bugzilla at redhat.com]

https://bugzilla.redhat.com/show_bug.cgi?id=1048293

Sean Flanigan <sflaniga at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |sflaniga at redhat.com
            Summary|Zanata can't change         |TECH DEBT: support
                   |database schema at startup  |mysql/mariadb 5.6 database
                   |                            |for Zanata



--- Comment #2 from Sean Flanigan <sflaniga at redhat.com> ---
You mean MySQL, not PostgreSQL, right?  Unfortunately, Zanata doesn't yet
support  MySQL 5.6, let alone PostgreSQL.

It seems that changing a column to be autoincrement violates foreign key
constraints starting with MySQL 5.6, so we'll need to modify changeset
db/changelogs/db.changelog-1.5.xml::8::aeng at redhat.com to drop the constraint
and recreate it.  There could be quite a few other changes required too.

By the way, Dmitry, it looks like your databases are using latin1 for 'Db
characterset'.  All of our testing is with UTF-8 databases, so you may have
trouble storing non-ASCII text in Zanata (even non-ASCII Latin-1 text).

-- 
You are receiving this mail because:
You are on the CC list for the bug.
Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=fw4ASewgmN&a=cc_unsubscribe