Thanks, for the sterling work you do as usual on H2. On Sep 2, 8:34 am, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > Hi, > > Thanks a lot for the great test case! There are a two bugs in H2: ... > > My results are now: > > Testing jdbc:h2:mem:test > ... > Initialization [125ms] > A. SELECT pk FROM t WHERE pk = ? [0ms] > B. SELECT pk FROM t WHERE pk IN (?, ?) [125ms] > C. SELECT pk FROM t WHERE pk = ? OR pk = ? [7688ms]
Nearly 8 seconds, is that right? > D. SELECT pk FROM t WHERE pk = ? AND pk = ? [31ms] > E. SELECT pk FROM t WHERE pk = ? AND pk > ? [0ms] > Total [7969ms] > Testing jdbc:mysql://localhost/test?user=sa&password=sa > ... > Initialization [2063ms] > A. SELECT pk FROM t WHERE pk = ? [171ms] > B. SELECT pk FROM t WHERE pk IN (?, ?) [141ms] > C. SELECT pk FROM t WHERE pk = ? OR pk = ? [156ms] > D. SELECT pk FROM t WHERE pk = ? AND pk = ? [125ms] > E. SELECT pk FROM t WHERE pk = ? AND pk > ? [141ms] > Total [2797ms] ... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---