FWD » Core Development » Database

11/29/2021

12:27 PM Support #4701: try to improve H2 transaction commit performance

FYI, H2 version 2.0.202 was released November 25, 2021. I noticed these two items which are relevant to us in the cha... Eric Faulhaber

11/09/2021

12:14 PM Bug #5802: a date temp-table field gets assigned to incorrect date

If @LocalDate@ handled historical dates properly, then we would certainly need to consider moving to it. Without tha... Greg Shah

11/06/2021

10:34 PM Bug #5802: a date temp-table field gets assigned to incorrect date

I did some small scale tests/investigations. The @LocalDate@ might be the utility @date@ needs. There are methods for... Ovidiu Maxiniuc

11/05/2021

01:34 PM Bug #5802: a date temp-table field gets assigned to incorrect date

I believe it may be possible that we are doing some over-calculations with the @date@. From my experience with this B... Ovidiu Maxiniuc

01:33 PM Bug #5802: a date temp-table field gets assigned to incorrect date

Greg Shah wrote:
> At the time I wrote this code, the use of @Date@ with the day, month, year was already deprecated... Constantin Asofiei

01:21 PM Bug #5802: a date temp-table field gets assigned to incorrect date

> But a potential problem may be: when working with pure dates, maybe FWD should not depend on/use the time part at a... Greg Shah

01:17 PM Bug #5802: a date temp-table field gets assigned to incorrect date

Ovidiu Maxiniuc wrote:
> Same Java version here.
> Greg, please try with @ABL_11_NOV_1900 = 2430137@ (05/21/1941).
... Greg Shah

12:48 PM Bug #5802: a date temp-table field gets assigned to incorrect date

Constantin Asofiei wrote:
> Ovidiu: I don't think this is specific on a user's machine (as long as @TimeZone.getDefa... Ovidiu Maxiniuc

12:47 PM Bug #5802: a date temp-table field gets assigned to incorrect date

Constantin Asofiei wrote:
> Ovidiu, is this only with this specific @1900-11-11@ date? Can you run all dates from 1... Ovidiu Maxiniuc

12:46 PM Bug #5802: a date temp-table field gets assigned to incorrect date

Greg, what does @TimeZone.getDefault();@ show for you?
Ovidiu: I don't think this is specific on a user's machine ... Constantin Asofiei

12:41 PM Bug #5802: a date temp-table field gets assigned to incorrect date

Same Java version here.
Greg, please try with @ABL_11_NOV_1900 = 2430137@ (05/21/1941). Ovidiu Maxiniuc

12:36 PM Bug #5802: a date temp-table field gets assigned to incorrect date

If I'm using @TimeZone.getTimeZone("Europe/Bucharest")@, the program shows:... Constantin Asofiei

12:24 PM Bug #5802: a date temp-table field gets assigned to incorrect date

I don't see the issue on my system:... Greg Shah

12:20 PM Bug #5802: a date temp-table field gets assigned to incorrect date

Ovidiu, is this only with this specific @1900-11-11@ date? Can you run all dates from 1900 to 2030 in a loop, a log ... Constantin Asofiei

12:13 PM Bug #5802: a date temp-table field gets assigned to incorrect date

I used Constantin's test case. I added traces (@System.out.format()@) in @date.neutralMillisToCalendar(long millis, T... Ovidiu Maxiniuc

11/04/2021

11:09 AM Bug #5802: a date temp-table field gets assigned to incorrect date

Do you have a simple Java recreate for this? I assume we can recreate this with simple Java code with a @main()@ tha... Greg Shah

08:05 PM Bug #5802: a date temp-table field gets assigned to incorrect date

I continued investigations on this issue. The problem seems to be at the moment when the timezone of the @GregorianCa... Ovidiu Maxiniuc

11/03/2021

09:10 AM Bug #5802: a date temp-table field gets assigned to incorrect date

> It seems like the first setup is somewhat incorrect. Since the default timezone is unlikely to change, only the ve... Greg Shah

09:03 PM Bug #5802: a date temp-table field gets assigned to incorrect date

I did a bit of investigations. Here is the stack downstream from @_setDate@:... Ovidiu Maxiniuc

11/02/2021

07:42 PM Bug #5799 (Feedback): write-xml doesn't serialize the prods:id attributes and the deleted fields ...

As you noted, there were two issues here:
* WRITE-XML was not serializing the @prods:id@ and @prods:rowState@ attrib... Ovidiu Maxiniuc

11:13 AM Bug #5799: write-xml doesn't serialize the prods:id attributes and the deleted fields for before-...

This program:... Constantin Asofiei

11:11 AM Bug #5799 (Feedback): write-xml doesn't serialize the prods:id attributes and the deleted fields ...

Constantin Asofiei

07:03 PM Bug #5801 (Feedback): write-xml is not using XML-NODE-NAME for the temp-table

The issue was fixed and revision in 13126. Ovidiu Maxiniuc

11:24 AM Bug #5801: write-xml is not using XML-NODE-NAME for the temp-table

This test:... Constantin Asofiei

11:23 AM Bug #5801 (Feedback): write-xml is not using XML-NODE-NAME for the temp-table

Constantin Asofiei

12:11 PM Bug #5800: Conversion issue with CAN-FIND

Eric Faulhaber wrote:
> The conversion has gone quite wrong. I don't think we've come across a case before which com... Igor Skornyakov

11:57 AM Bug #5800: Conversion issue with CAN-FIND

The conversion has gone quite wrong. I don't think we've come across a case before which compares the results of two ... Eric Faulhaber

11:14 AM Bug #5800: Conversion issue with CAN-FIND

The conversion of the following program... Igor Skornyakov

11:13 AM Bug #5800 (New): Conversion issue with CAN-FIND

Igor Skornyakov

11:45 AM Bug #5802: a date temp-table field gets assigned to incorrect date

This test will assign @tt1.f1@ to @1900-11-10@, only on the first iteration. I saw this when working with #3310 SOAP... Constantin Asofiei

11:43 AM Bug #5802 (New): a date temp-table field gets assigned to incorrect date

Constantin Asofiei