FWD » Core Development » Database

05/27/2016

12:15 AM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Code review 2421a/11039:
The code looks good to me. Please regression test. Eric Faulhaber

05/26/2016

02:22 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Please review task branch 2421a revision 11039. Stanislav Lomany

02:07 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Rebased task branch 2421a from P2J trunk revision 11035. Stanislav Lomany

05/24/2016

03:53 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Stanislav Lomany wrote:
> Should I fix this as the part of this task?
Yes, please do. Eric Faulhaber

03:41 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Eric, there is the conversion issue for validation messages. Testcase:... Stanislav Lomany

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

Stanislav Lomany wrote:
> Eric, for the case: am I right that @DELETE-RESULT-LIST-ENTRY@ and @{FIRST|LAST}[-OF]@ can... Eric Faulhaber

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

The task branch 2275a was committed to trunk as revision 11034 and then archived. Notification was sent to team.
The... Ovidiu Maxiniuc

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

Code review 2275a/11038:
The changes look fine. None of this code is used in the normal regression test environmen... Eric Faulhaber

05/23/2016

02:40 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Eric, for the case: am I right that @DELETE-RESULT-LIST-ENTRY@ and @{FIRST|LAST}[-OF]@ cannot be used on the same que... Stanislav Lomany

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

Thanks, Eric.
The golden idea was to save the (default) parameters, too, in with 1st level cache, so we could 'rehyd... Ovidiu Maxiniuc

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

The key to my suggested approach working is that the second scenario above cannot be appreciably slower than the curr... Eric Faulhaber

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

I've been thinking about the same problem with the 2-level cache, but I came to a different conclusion. The first lev... Eric Faulhaber

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

Eric,
I am working on double cache solution. I encountered the following issue which I sensed but was not able to de... Ovidiu Maxiniuc

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

Ovidiu, please note that one of the changes in task branch 3109a (now P2J trunk 11032) was to increase the DQH cache ... Eric Faulhaber

05/20/2016

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

Eric Faulhaber wrote:
> Ovidiu Maxiniuc wrote:
> > I am not happy with the 'manufactured' variable names. Maybe we ... Ovidiu Maxiniuc

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

[ECF: moved this entry to #3081-3] Ovidiu Maxiniuc

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

Ovidiu Maxiniuc wrote:
> I am not happy with the 'manufactured' variable names. Maybe we should discuss about this t... Eric Faulhaber

05/19/2016

03:26 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

I don't foresee an issue from the proposed change. Eric Faulhaber

02:43 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Yes, it is. Stanislav Lomany

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

Stanislav Lomany wrote:
> Let me know if you foresee any problems with that.
@PreselectQuery@ was not originally me... Eric Faulhaber

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

Eric, please consider the case when an inner record of a compound query is updated AND corresponding inner sub-query ... Stanislav Lomany

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

Ovidiu Maxiniuc wrote:
> I need to check the operator and the opposite operand and convert the variable type/value. ... Eric Faulhaber

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

Eric Faulhaber wrote:
> Ovidiu Maxiniuc wrote:
> > To fix this we could add casting or automatically convert the in... Ovidiu Maxiniuc

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

Ovidiu Maxiniuc wrote:
> To fix this we could add casting or automatically convert the injected variable to required... Eric Faulhaber

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

Eric,
I found the errors logged in @/var/log/postgresql/postgresql-9.2-p2j_enUS.log@. I don't think hibernate is abl... Ovidiu Maxiniuc

05/18/2016

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

After more research on testcase from note 16 that causes some failures:
* I tried to isolate the testcase with TEMP-... Ovidiu Maxiniuc

05/17/2016

03:55 PM Feature #2421: Implement DELETE-RESULT-LIST-ENTRY for PresortCompoundQuery

Created task branch 2421a from P2J trunk revision 11031. Stanislav Lomany

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

Encountered an issue with new processing. The queries like ... Ovidiu Maxiniuc

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

Eric Faulhaber wrote:
> Ovidiu, can you please help me understand how the @variable_definitions.rules@ changes (both... Ovidiu Maxiniuc

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

Ovidiu, can you please help me understand how the @variable_definitions.rules@ changes (both annotations and conversi... Eric Faulhaber

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