FWD » Core Development » Database

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

04/14/2016

04:56 AM Bug #3065: runtime conversion datatype checks

In the static conversion P2J assumes that the input 4GL code is always correct. When it comes to dynamic conversions ... Ovidiu Maxiniuc

04:42 AM Bug #3065 (New): runtime conversion datatype checks

Ovidiu Maxiniuc

04/12/2016

09:00 AM Bug #2937: improved sequence support in H2

I am removing this issue from M11. The existing sequence support works fine with H2 1.4, this is just a matter of cha... Eric Faulhaber

06:56 AM Bug #2937: improved sequence support in H2

I edited the wrong task, sorry. Greg Shah

06:55 AM Bug #2937: improved sequence support in H2

Wrong task was edited. Greg Shah

04/09/2016

11:09 AM Bug #2955: Update records participating in a scrolling adaptive query.

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

08:51 PM Bug #2955: Update records participating in a scrolling adaptive query.

The update was implemented in 2564f and committed into the trunk as bzr revision 10999.
We may want to re-visit this... Stanislav Lomany

04/01/2016

11:44 AM Feature #3047: JDBC jar deployment

*From email*
---
On 04/01/2016 10:14 AM, Paul wrote:
> Hi,
>
> I considered raising a redmine issue, but thi... Eric Faulhaber

11:40 AM Feature #3047 (New): JDBC jar deployment

Eric Faulhaber

09:20 AM Bug #3032: running ETF fails because some postgresql server process gets killed

Actually, no, not exactly. The identity pool method remained the default, @JDBC@. But the things are related. That th... Ovidiu Maxiniuc

09:03 AM Bug #3032: running ETF fails because some postgresql server process gets killed

Was your trick to do the following in directory.xml? ... Paul E

08:58 AM Bug #3032: running ETF fails because some postgresql server process gets killed

I am still using PostgreSQL 9.2 Server.
I used the debugger and investigated the issue. As seen in postgresql log ... Ovidiu Maxiniuc

08:24 AM Bug #3032: running ETF fails because some postgresql server process gets killed

Ovidiu - what is your DB version?
This looks like the IdentityPool scan problem I saw back when I upgraded to Post... Paul E