Hi, I guess you mean a version without the MVStore? Could you append ";MV_STORE=FALSE" to the database URL?
Regards, Thomas On Wed, Dec 10, 2014 at 11:07 AM, <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > Hi, > > Is there a way to obtain an updated 1.3.176 version containing this fix > with help of the svn-repository? > > Kind regards > > Christoff Schmitz > > F I N A R I S > Financial Software Partner GmbH > Sömmerringstrasse 23 > 60322 Frankfurt am Main > > Fon: +49 (0)69 / 254 98 - 24 > Mobile: +49 (0)176 / 206 34 186 > Fax: +49 (0)69 / 254 98 - 50 > eMail: mailto:[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');> > www: http://www.finaris.de und http://www.rapidrep.com > > > > From: Thomas Mueller <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> > To: "[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>" < > [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> > Date: 10.12.2014 07:50 > Subject: Re: [h2] Wrong results using the BETWEEN operator (H2 > 1.3.176) > Sent by: [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');> > ------------------------------ > > > > Hi, > > I found the problem, it is relatively easy to fix. Views and derived > tables with equality and range conditions on the same columns don't > currently work properly. The fix and new test case is now committed. It > also makes the code a bit more readable, which is good :-) > > Regards, > Thomas > > > > On Tuesday, December 9, 2014, Thomas Mueller < > *[email protected]* > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > Hi, > > I couldn't find analyze the problem yet, but I found a simpler case: > > This results in 0 rows (should be 1): > > select x from (select x from (select 1 as x) > where x > 0 and x < 2) where x = 1; > > select x from (select x from (select x from system_range(1, 9)) > where x > 2 and x < 4) where x = 3; > > This works: > > select x from (select x from (select 1 as x) > where x > 0 and x < 2) where x > 0; > > select x from (select x from dual > where x > 0 and x < 2) where x = 1; > > I think this is related to parameters in view. The explain plan for the > queries is quite strange. > > Regards, > Thomas > > > On Friday, December 5, 2014, Noel Grandin <*[email protected]*> wrote: > Hmmm, this does not seem to be a BETWEEN issue, since it also fails with > ZEILE_RELATIV >=16 AND ZEILE_RELATIV <= 18 > > On 2014-12-03 05:21 PM, [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');> wrote: > Hi, > > The following statement returns 0 rows as result, obviously, the result > should be one row containing the value 17: > > *SELECT > *ZEILE_RELATIV* > FROM > **( > **SELECT > *ZEILE_RELATIV > *FROM > **( > **SELECT **16 **AS *ZEILE_RELATIV > *UNION ALL > SELECT **17 **AS *ZEILE_RELATIV > *UNION ALL > SELECT **18 **AS *ZEILE_RELATIV > *UNION ALL > SELECT **19 **AS *ZEILE_RELATIV > *) > **WHERE > *ZEILE_RELATIV *BETWEEN **16 **AND **18 > **) ** > WHERE > *ZEILE_RELATIV *= **17* > > The same query using an equivalent IN clause works as expected (1 record > as result): > > *SELECT > *ZEILE_RELATIV* > FROM > **( > **SELECT > *ZEILE_RELATIV > *FROM > **( > **SELECT **16 **AS *ZEILE_RELATIV > *UNION ALL > SELECT **17 **AS *ZEILE_RELATIV > *UNION ALL > SELECT **18 **AS *ZEILE_RELATIV > *UNION ALL > SELECT **19 **AS *ZEILE_RELATIV > *) > **WHERE > *ZEILE_RELATIV *IN **(**16*,*17*,*18**) > ) ** > WHERE > *ZEILE_RELATIV *= **17* > > > > Kind regards > > Christoff Schmitz > > F I N A R I S > Financial Software Partner GmbH > Sömmerringstrasse 23 > 60322 Frankfurt am Main > > Fon: +49 (0)69 / 254 98 - 24 > Mobile: +49 (0)176 / 206 34 186 > Fax: +49 (0)69 / 254 98 - 50 > eMail: mailto:[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');> > www: *http://www.finaris.de* <http://www.finaris.de/> < > *http://www.finaris.de/* <http://www.finaris.de/>>und > *http://www.rapidrep.com* <http://www.rapidrep.com/> < > *http://www.rapidrep.com/* <http://www.rapidrep.com/>> > > > ================================================================================================================ > Disclaimer > The information contained in this e - mail and any attachments ( together > the "message") is intended for the addressee > only and > may contain confidential and/or privileged information. If you have > received the message by mistake please delete it and > notify > the sender and do not copy or distribute it or disclose its contents to > anyone. > > FINARIS Financial Software Partner GmbH, Sömmerringstr. 23, 60322 > Frankfurt/Main, Germany > Registered at Frankfurt/Main, HRB 52873, Managing Directors: Dipl. Inf. > Hermann Friebel, Dipl. Ing. Kai Bächle, Dipl. > Inf. Werner Märkl > > ================================================================================================================ > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to > [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > <mailto:[email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > >. > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');> < > mailto:[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>>. > Visit this group at *http://groups.google.com/group/h2-database* > <http://groups.google.com/group/h2-database>. > For more options, visit *https://groups.google.com/d/optout* > <https://groups.google.com/d/optout>. > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at *http://groups.google.com/group/h2-database* > <http://groups.google.com/group/h2-database>. > For more options, visit *https://groups.google.com/d/optout* > <https://groups.google.com/d/optout>. > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to *[email protected]* > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to *[email protected]* > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at *http://groups.google.com/group/h2-database* > <http://groups.google.com/group/h2-database>. > For more options, visit *https://groups.google.com/d/optout* > <https://groups.google.com/d/optout>. > > > > ================================================================================================================ > Disclaimer > The information contained in this e - mail and any attachments ( together > the "message") is intended for the addressee only and > may contain confidential and/or privileged information. If you have > received the message by mistake please delete it and notify > the sender and do not copy or distribute it or disclose its contents to > anyone. > > FINARIS Financial Software Partner GmbH, Sömmerringstr. 23, 60322 > Frankfurt/Main, Germany > Registered at Frankfurt/Main, HRB 52873, Managing Directors: Dipl. Inf. > Hermann Friebel, Dipl. Ing. Kai Bächle, Dipl. Inf. Werner Märkl > > ================================================================================================================ > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
