FWD » Core Development » Database

05/16/2016

02:08 PM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables

Created task branch 2275a from trunk 11030. Last revision is 11031. The update is based on the algorithm described in... Ovidiu Maxiniuc

05/14/2016

01:26 PM Bug #3026 (Closed): BUFFER-DELETE() method does not account for table-level delete validation

Eric Faulhaber

12:54 PM Bug #3026 (Review): BUFFER-DELETE() method does not account for table-level delete validation

Сommitted into the trunk as bzr revision 11029. Stanislav Lomany

12:04 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Rebased task branch 3026a from P2J trunk revision 11028. Stanislav Lomany

05/13/2016

11:43 AM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

The ETF testing had some trouble for other reasons, but enough of the testing did well that I'm comfortable with this... Eric Faulhaber

10:05 AM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables

The summary/statistics can be found at #2488-34 and 35. I don't recall the exact target. I can reactivate the log and... Ovidiu Maxiniuc

09:33 AM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables

Ovidiu Maxiniuc wrote:
> Eric Faulhaber wrote:
> > How do we deal with the buffer(s) in this new cache? It is possi... Eric Faulhaber

04:41 AM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables

Eric Faulhaber wrote:
> How do we deal with the buffer(s) in this new cache? It is possible to specify various buffe... Ovidiu Maxiniuc

05/12/2016

02:24 PM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables

This looks good so far.
How do we deal with the buffer(s) in this new cache? It is possible to specify various buf... Eric Faulhaber

12:54 PM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables

We are using now the dynamic conversion mostly for the HQL that are hardcoded at conversion time.
To correctly handl... Ovidiu Maxiniuc

05/11/2016

02:43 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Rebased task branch 3026a from P2J trunk revision 11025. Stanislav Lomany

01:50 AM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Code review 3026a/11026:
Very nice! Please regression test. Eric Faulhaber

11:53 PM Feature #2275 (WIP): cache of runtime-converted, dynamic queries and temp-tables

Eric Faulhaber

05/10/2016

10:46 AM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

You are correct, with @-p@ key this message is in the message area in both ChUI and GUI.
Rebased task branch 3026a... Stanislav Lomany

05/09/2016

04:48 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

> "Table <table name> is defined with schema delete validation..." error is displayed as a message box in GUI and in ... Greg Shah

05/05/2016

06:04 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Stanislav Lomany wrote:
> Eric, the "Table <table name> is defined with schema delete validation..." error is displa... Eric Faulhaber

09:14 AM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Eric, the "Table <table name> is defined with schema delete validation..." error is displayed as a message box in GUI... Stanislav Lomany

05/04/2016

12:23 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

I know of no way to define schema table-level validation for a temp-table. I would have guessed the only way would be... Eric Faulhaber

09:04 AM Bug #2222: WRITE event triggered too early

Paul Eames wrote:
> Thanks for the update Ovidiu.
>
> The thing here that interests me most is that you have thes... Ovidiu Maxiniuc

08:29 AM Bug #2222: WRITE event triggered too early

Thanks for the update Ovidiu.
The thing here that interests me most is that you have these tests that you run agai... Paul E

08:02 AM Bug #2222: WRITE event triggered too early

Yes, the cause for this issue is fixed now. The WRITE triggers are fired at the right moment up to step 13 of the tes... Ovidiu Maxiniuc

05/03/2016

06:09 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

I was wondering if delete validation can be applied to a temp-table. All I found is @VALIDATE@ option for @DEFINE TEM... Stanislav Lomany

10:15 AM Bug #2222: WRITE event triggered too early

Paul Eames wrote:
> > The original problems have long since been resolved
>
> Does this mean that the behavioural... Eric Faulhaber

05:17 AM Bug #2222: WRITE event triggered too early

I'd appreciate an update on this if that's ok?
See note 26. Paul E

05/02/2016

07:15 AM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Created task branch 3026a from P2J trunk revision 11019. Stanislav Lomany

04/29/2016

06:32 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

OK, this plan sounds good. Eric Faulhaber

05:16 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

OK, for testing we can use queries with complex sorting:... Stanislav Lomany

01:34 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

There are actually a few dozen instances of @PresortCompoundQuery@ in the statically converted code of the current pr... Eric Faulhaber

11:23 AM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Eric, BREAK BY applies only to cycles. IIRC we can convert to presort compound queries some other rare types of queri... Stanislav Lomany

10:19 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Stanislav Lomany wrote:
> @PresortCompoundQuery@ is a compound query with 1. support for break groups / accumulation... Eric Faulhaber

04:20 PM Feature #2692: table-level VALEXP/VALMSG support

Greg Shah wrote:
> * I recall that validation expressions be copied in from the schema more than once (if there are ... Eric Faulhaber

03:57 PM Feature #2692: table-level VALEXP/VALMSG support

Greg Shah wrote:
> There are some things I would like to clarify. Please correct anything I get wrong here.
>
> ... Eric Faulhaber

08:15 AM Feature #2692: table-level VALEXP/VALMSG support

Questions:
* I recall that validation expressions be copied in from the schema more than once (if there are multip... Greg Shah

08:11 AM Feature #2692: table-level VALEXP/VALMSG support

There are some things I would like to clarify. Please correct anything I get wrong here.
1. It is not just @ENABL... Greg Shah

12:54 AM Feature #2692 (Closed): table-level VALEXP/VALMSG support

The essence of adding this feature was to move all the table-level validation expression parsing from the @SchemaLoad... Eric Faulhaber

01:17 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Agreed. Eric Faulhaber

01:13 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

The button in 4GL Data Dictinonary interface which calls validation editor is called "Validation..." so let's call it... Stanislav Lomany

12:44 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Stanislav Lomany wrote:
> > I think the best place for this is in the corresponding DMO, as a Java annotation.
>
... Eric Faulhaber

10:38 AM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

> I think the best place for this is in the corresponding DMO, as a Java annotation.
Should we extend @LegacyTable... Stanislav Lomany

11:11 PM Bug #3026: BUFFER-DELETE() method does not account for table-level delete validation

Stanislav Lomany wrote:
> Eric, could you please clear something for me?
>
> 1. How do I define a schema delete v... Eric Faulhaber

08:15 AM Feature #2619 (Closed): misc database features needed for a GUI app

Greg Shah

04/28/2016

05:39 PM Bug #3026 (WIP): BUFFER-DELETE() method does not account for table-level delete validation

Eric, could you please clear something for me?
1. How do I define a schema delete validation - is that a correct d... Stanislav Lomany

10:02 AM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

@PresortCompoundQuery@ is a compound query with 1. support for break groups / accumulation 2. presorted up front; so ... Stanislav Lomany

04/27/2016

12:30 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

What is your estimate of the effort to replace the implementation vs. making DELETE-RESULT-LIST-ENTRY work with the c... Eric Faulhaber

10:29 AM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Cursor holds common iteration/reposition/row deletion/etc code and, considering this, synchronization between these t... Stanislav Lomany

10:08 AM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

They are different APIs. I needed the API of a @Results@ object. Why is it better to store results in @DynamicQuery.c... Eric Faulhaber

09:55 AM Feature #2421 (WIP): Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Eric, first of all, why do we need @PresortCompoundQuery.sorted@? Isn't it better so store results in @DynamicQuery.c... Stanislav Lomany

04/25/2016

02:16 PM Bug #2955: Update records participating in a scrolling adaptive query.

Eric Faulhaber wrote:
> Stanislav Lomany wrote:
> > We may want to re-visit this task after optimized queries will ... Eric Faulhaber

04/22/2016

08:50 AM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables

This are quite similar to my thought from #2488-34. There are some statistics and an implementation sketch in there, ... Ovidiu Maxiniuc

03:05 AM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables

In addition to the buffers improvement, I bet a lot of predicates differ only in the constant values which are inline... Eric Faulhaber

04/21/2016

01:38 PM Feature #2275 (New): cache of runtime-converted, dynamic queries and temp-tables

Eric Faulhaber

01:36 PM Feature #3010: retrieve new primary keys from database in batch

Having done more profiling since I entered this issue, I think the primary use comes from the metadata @LockTableUpda... Eric Faulhaber

04/19/2016

11:31 AM Bug #2482: conversion of FIND does not honor NO-LOCK when specified early

Paul Eames wrote:
> Was this in our code?
Not that I'm aware of. Eric Faulhaber

04/18/2016

08:02 AM Bug #2482: conversion of FIND does not honor NO-LOCK when specified early

Was this in our code? Paul E

05:17 AM Feature #2541: replace the JDBC metadata calls at server startup with DMO annotations

I like this idea. Paul E