2:08 a.m.
I've already sent this, but got no answer. Please take a look at it.
Take a look at the hibernate mysql tests:
http://cruisecontrol.jboss.com/cc/buildresults/hibernate-mysql-testsuite
There are much failings.
As the testsuite was continually failing because of a mysql bug that is
fixed in 4.1.18 I think it's worth installing newer version.
Could you suggest which version will best suite your needs (4.1.latest,
5.0.latest)?
btw. hibernate can be tested against innodb and myisam. Currently it is
tested only against innodb. Is this ok?
Thanks,
Aleksandar Kostadinov
4:03 a.m.
On Wed, 29 Nov 2006 10:10:46 +0100, Darryl Miles
<darryl-mailinglists(a)netbauds.net> wrote:
Aleksandar Kostadinov wrote:
> As the testsuite was continually failing because of a mysql bug that is
> fixed in 4.1.18 I think it's worth installing newer version.
Have you got a reference to this bug ?
yes, knowing what that bug is would be beneficial.
And regarding the version then Mysql 4.whateveristhelateststable sounds
like the best match.
Mysql 5 is still in beta, correct ?
With respect to isam and innodb I would say that innodb is the important
one
since isam doesn't have proper tx isolation nor foreign key constraints and
as such is not really something we want to encourage.
--
--
Max Rydahl Andersen
callto://max.rydahl.andersen
Hibernate
max(a)hibernate.org
http://hibernate.org
JBoss a division of Red Hat
max.andersen(a)jboss.com
4:58 a.m.
Max Rydahl Andersen wrote:
On Wed, 29 Nov 2006 10:10:46 +0100, Darryl Miles
<darryl-mailinglists(a)netbauds.net> wrote:
> Aleksandar Kostadinov wrote:
>> As the testsuite was continually failing because of a mysql bug that is
>> fixed in 4.1.18 I think it's worth installing newer version.
>
> Have you got a reference to this bug ?
yes, knowing what that bug is would be beneficial.
And regarding the version then Mysql 4.whateveristhelateststable sounds
like the best match.
Mysql 5 is still in beta, correct ?
No. 5.0 went GA I guess 3rd Nov 2005.
http://www.mysql.com/news-and-events/on-demand-webinars/mysql5.0-ga-2005-...
But since we're in overlap period a Mysql 4.1.x server and 5.0.x server
should still be considered mainstream (by me anyway).
With respect to isam and innodb I would say that innodb is the
important
one
since isam doesn't have proper tx isolation nor foreign key constraints and
as such is not really something we want to encourage.
Agreed. But I think the point he was making was that the same SQL
server can be used to test both configurations and dialects. The cost
of creating a new configuration and running a test isn't much extra as
you already have the server setup.
Even if such tests were done much less frequently, like once a week.
While concentrating efforts on whatever version is the latest GA with
all the major players.
I'd have thought having access to a working SQL server from each vendor
in each supported version series must be a useful resource just to have
anyway. If you want pointers on installing/dual homing your test box
with multiple MySQL servers drop me a mail.
Darryl
5:15 a.m.
>>> As the testsuite was continually failing because of a
mysql bug that
>>> is
>>> fixed in 4.1.18 I think it's worth installing newer version.
>>
>> Have you got a reference to this bug ?
> yes, knowing what that bug is would be beneficial.
> And regarding the version then Mysql 4.whateveristhelateststable
> sounds like the best match.
no bug ref still ? :)
> Mysql 5 is still in beta, correct ?
No. 5.0 went GA I guess 3rd Nov 2005.
ah - not so long ago then ;)
I'd have thought having access to a working SQL server from each
vendor
in each supported version series must be a useful resource just to have
anyway. If you want pointers on installing/dual homing your test box
with multiple MySQL servers drop me a mail.
I got too many different db installations to count on my box so i got it
covered ;)
--
--
Max Rydahl Andersen
callto://max.rydahl.andersen
Hibernate
max(a)hibernate.org
http://hibernate.org
JBoss a division of Red Hat
max.andersen(a)jboss.com
5:38 a.m.
Max Rydahl Andersen wrote:
>>>> As the testsuite was continually failing because of a mysql bug
>>>> that is
>>>> fixed in 4.1.18 I think it's worth installing newer version.
>>>
>>>
>>> Have you got a reference to this bug ?
>>
>> yes, knowing what that bug is would be beneficial.
>> And regarding the version then Mysql 4.whateveristhelateststable
>> sounds like the best match.
>
no bug ref still ? :)
There will not be ;) Sorry I've sent a note to Darryl and not to the list.
I've lost the ref. I don't have even the error message now so it will be
very hard to find it again. The bug is that there get tables created
which cannot be dropped because of some temporary files incorrectly
created. It is not a problem for now, but could appear in the future
breaking any consequent tests. And this is why I think we need a newer
version."
>> Mysql 5 is still in beta, correct ?
>
>
> No. 5.0 went GA I guess 3rd Nov 2005.
ah - not so long ago then ;)
> I'd have thought having access to a working SQL server from each
> vendor in each supported version series must be a useful resource
> just to have anyway. If you want pointers on installing/dual homing
> your test box with multiple MySQL servers drop me a mail.
I got too many different db installations to count on my box so i got
it covered ;)
So which version do you guys prefer and is the fail rate for the mysql
tests normal?
5:03 a.m.
On 11/29/06, Max Rydahl Andersen <max.andersen(a)jboss.com> wrote:
....
And regarding the version then Mysql 4.whateveristhelateststable sounds
like the best match.
Mysql 5 is still in beta, correct ?
MySQL 5.0 has been released for some time now (October 2005
-http://www.theserverside.com/news/thread.tss?thread_id=37248 ),
currently at 5.0.27. MySQL 5.1 is still in beta
Donnchadh
With respect to isam and innodb I would say that innodb is the
important
one
since isam doesn't have proper tx isolation nor foreign key constraints and
as such is not really something we want to encourage.
6599
days inactive
6599
days old
6 comments
4 participants
participants (4)
-
Aleksandar Kostadinov -
Darryl Miles -
Donnchadh Ó Donnabháin -
Max Rydahl Andersen