Re: [hibernate-dev] MariaDB on CI

2015-07-27 Thread Steve Ebersole
Well the problem is that we have a few multi-catalog/schema tests: tests that specifically test referring to objects from multiple catalogs/schemas. And on top of that we have schema export tests that test being able to create catalogs and schemas. So we have a few options. We can pre-determine

Re: [hibernate-dev] MariaDB on CI

2015-07-26 Thread Sanne Grinovero
On 23 July 2015 at 17:41, Steve Ebersole wrote: > Another change is to make sure our test user has create/drop privileges on > all databases, and to be able to create/drop databases: > > grant create, drop on *.* to 'hibernate_orm_test'@'localhost'; > > We will need similar for the other databases

Re: [hibernate-dev] MariaDB on CI

2015-07-23 Thread Steve Ebersole
Another change is to make sure our test user has create/drop privileges on all databases, and to be able to create/drop databases: grant create, drop on *.* to 'hibernate_orm_test'@'localhost'; We will need similar for the other databases too. On Tue, Jul 21, 2015 at 6:02 PM Sanne Grinovero w

Re: [hibernate-dev] MariaDB on CI

2015-07-21 Thread Sanne Grinovero
On 20 July 2015 at 17:41, Steve Ebersole wrote: > Sanne for MariaDB (and MySQL if we ever add it) we need to add at least one > more setting: > > sql-mode="traditional" I've applied this change. --Sanne > > We could probably get away with less ANSI compliant mode, but after days > playing with

Re: [hibernate-dev] MariaDB on CI

2015-07-20 Thread Steve Ebersole
Sanne for MariaDB (and MySQL if we ever add it) we need to add at least one more setting: sql-mode="traditional" We could probably get away with less ANSI compliant mode, but after days playing with this I just want to cover my bases :) On Sat, Jul 18, 2015 at 3:37 PM Sanne Grinovero wrote: >

Re: [hibernate-dev] MariaDB on CI

2015-07-18 Thread Sanne Grinovero
Thanks, great suggestions! I've applied these and some more. The MariaDB configuration: - https://github.com/hibernate/ci.hibernate.org/blob/master/roles/mariadb-server/files/my.cnf The PosgreSQL configuration files: - https://github.com/hibernate/ci.hibernate.org/blob/master/roles/postgres-s

[hibernate-dev] MariaDB on CI

2015-07-17 Thread Steve Ebersole
[18:45] whoa.. [18:45] sannegrinovero: we definitely need this for mariadb on ci... [18:46] sync_binlog=0 innodb_flush_log_at_trx_commit=0 innodb_doublewrite=0 [18:46] tests were much faster These were suggested to me on the #mariadb list. I added them to my local /etc/my.cnf file and the tes