Activity

From 10/15/2012 to 11/13/2012

11/13/2012

12:03 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: I put aside all above and started with a fresh new idea. Please correct me if I'm wrong.
P2J is informed about cha... Ovidiu Maxiniuc
11:40 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: This is an interesting idea, but it is pretty intrusive in the DMOs. Let's go with your first approach, limiting the... Eric Faulhaber
10:11 AM Feature #1580: upgrade Hibernate to latest level: It seems like using JPA-style positional parameters (?1, ?2, ?3, ...) would be much easier than changing conversion o... Eric Faulhaber
08:37 AM Feature #1580: upgrade Hibernate to latest level: Log file is full of this kind of warnings:... Stanislav Lomany

11/12/2012

11:54 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: Indeed, the @snapshot@ seems to be used for a similar reason, but I see it's only used for undo-s, it only stores ses... Ovidiu Maxiniuc
10:46 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: Please review the use of the @snapshot@ instance variable in @RecordBuffer@. Can this variable (i.e., when it is a d... Eric Faulhaber
09:25 AM Feature #1911: add runtime support for sequences: See parent issue for requirements.
Runtime implementations of the statement/functions should leverage dialect infr... Eric Faulhaber
09:21 AM Feature #1910 (New): add schema conversion support for sequences: See parent issue for description of what must be converted.
The statements in the schema export (.df) file must be... Eric Faulhaber

11/11/2012

03:09 PM Feature #1580: upgrade Hibernate to latest level: In order to get rid of the "(org.hibernate.internal.util.xml.DTDEntityResolver:WARN) HHH000223: Recognized obsolete h... Stanislav Lomany
02:54 PM Feature #1580: upgrade Hibernate to latest level: In order to enable EhCache, the following entry should be added to the directory:... Stanislav Lomany

11/09/2012

06:07 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: One more, pure database field test:
def temp-table tt
field f1 as logical
field f2 as logical.
create tt... Vadim Nebogatov
11:51 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: A small problem regarding the implementation:
I could not find in the hibernate documentation a way to detect if a r... Ovidiu Maxiniuc
11:22 AM Feature #1919: update HQLPreprocessor and calling code to better handle WHERE TRUE and WHERE FALS...: Runtime where clause optimizations can roll up a where clause such that the result passed to Hibernate is simply WHER... Eric Faulhaber
10:55 AM Feature #1919 (New): update HQLPreprocessor and calling code to better handle WHERE TRUE and WHER...: Eric Faulhaber
10:53 AM Feature #1580: upgrade Hibernate to latest level: Stanislav Lomany wrote:
> WHERE TRUE or WHERE FALSE are results of P2J runtime query optimization. I agree that we s... Eric Faulhaber
10:22 AM Feature #1580: upgrade Hibernate to latest level: > Under what circumstances do we need to support WHERE TRUE and WHERE FALSE? Is this something we should optimize du... Stanislav Lomany
09:56 AM Feature #1580: upgrade Hibernate to latest level: Stanislav Lomany wrote:
> I found that HQL parser doesn't support WHERE TRUE or WHERE FALSE where clause. I've appli... Eric Faulhaber
09:50 AM Feature #1580: upgrade Hibernate to latest level: If we didn't already have this workaround for a similar case, I would say let's fix it in Hibernate, but since we are... Eric Faulhaber
08:37 AM Feature #1580: upgrade Hibernate to latest level: Class cast exception bug exists in Hibernate bug tracker: https://hibernate.onjira.com/browse/HHH-4700 , not fixed ye... Stanislav Lomany
10:40 AM Feature #1601 (Closed): implement NUMERIC type in relational database schemas: I'm not sure to what this issue refers. Some time back, we added precision and scale information to the DDL for NUME... Eric Faulhaber
08:48 AM Bug #1913: default locking in a BROWSE widget: .df file attached.
.d file is irrelevant.
Ovidiu Maxiniuc

11/08/2012

05:41 PM Bug #1913: default locking in a BROWSE widget: Please attach your test database's *.df file (and *.d file(s), if any), so that the worker of this issue can run the ... Eric Faulhaber
09:46 AM Bug #1913: default locking in a BROWSE widget: It appears that I have uncovered a bug in how we deal with default locking in a BROWSE widgets.
In order to test CUR... Ovidiu Maxiniuc
09:36 AM Bug #1913 (New): default locking in a BROWSE widget: Ovidiu Maxiniuc
02:07 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Please go ahead with optimizing these cases (e.g. true is null can be replaced with false). Greg Shah
02:02 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Concerning special cases
true is null
true is not null
false is null
false is not null
nul... Vadim Nebogatov
01:43 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: I agree that this file looks good. So it passes code review.
BUT:
1. There are more issues to resolve before ... Greg Shah
01:25 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Attached variant seems ready to commit (when CVS is unlocked) Vadim Nebogatov
09:37 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Feedback on the normalize_expressions.rules changes:
1. You have removed the first line of the file, which should ... Greg Shah
08:43 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: It would be better to test for and avoid emitting things like:
* true is null
* true is not null
* false is null
* fa... Eric Faulhaber
12:09 PM Bug #1914: database conversion requires Internet connectivity: While converting a project without being connected to the Internet, I hit an exception when the JVM tried to resolve ... Eric Faulhaber
11:33 AM Bug #1914 (Closed): database conversion requires Internet connectivity: Eric Faulhaber
10:22 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: I am using a very simple database (one table with a few records) that I created manually which is somehow similar to ... Ovidiu Maxiniuc
01:15 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: It appears you have uncovered a bug in how we deal with default locking in a BROWSE. BTW, what database are you usin... Eric Faulhaber
07:30 AM Feature #1580: upgrade Hibernate to latest level: 9. Changes into ImportWorker:
Into ImportWorker.Library.initialize:... Stanislav Lomany

11/07/2012

05:15 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Changed normalize_expressions.rules is attached (Test6 problems). Vadim Nebogatov
11:42 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Small correction:
A!=B
should be generated as
(A is null and B is not null) or (A is not null and (B is nu... Vadim Nebogatov
12:02 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: However, I was unable to run the converted code from my previous note. When moving from a field to another, the clien... Ovidiu Maxiniuc
10:53 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: To test two buffers within the same session I wrote the following test.
It FINDs the first record, then enables a B... Ovidiu Maxiniuc
07:31 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: With respect to the documentation update, please also update the "master" table of all supported built-in functions i... Eric Faulhaber
07:15 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: Nevermind on @ChangeBroker@; I forgot that is just about changes across buffers in the same session, not across sess... Eric Faulhaber
07:32 PM Feature #1595: add conversion and runtime support for DBPARAM() built-in function: With respect to the documentation update, please also update the "master" table of all supported built-in functions i... Eric Faulhaber

11/06/2012

06:15 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: I would expect that this is not a very common case, so my inclination is to fix it in the conversion and leave the mo... Eric Faulhaber
06:03 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: I don't know. I guess that is for you and Vadim to discuss further. Greg Shah
05:42 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Greg Shah wrote:
> Eric: should this change go into the HQLPreprocessor instead of the conversion? The resulting co... Eric Faulhaber
05:19 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Eric: should this change go into the HQLPreprocessor instead of the conversion? The resulting code seems very messy. Greg Shah
04:42 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Problems are with Test8 are related with the following "where" clauses used in AdaptiveQuery constructor:
tt.ff !=f... Vadim Nebogatov
07:25 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: All Test6 problems are fixed, Test8 problems are not fixed yet. Vadim Nebogatov
06:12 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: Ovidiu Maxiniuc wrote:
> *Later edit:*
> Just saw that the refresh is called a few lines below. My problem was/is t... Eric Faulhaber
11:10 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: When implementing as described above I got into the following issue:
B has committed the changes to db (I can see thi... Ovidiu Maxiniuc
07:52 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: Here are my 2 test files:... Ovidiu Maxiniuc
11:20 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: Please update the Conversion Reference (builtin_database_functions_methods_attributes.odt chapter) to reflect the imp... Eric Faulhaber
10:51 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: Ovidiu Maxiniuc wrote:
> To implement this we need to analyze the data requested from db when the FIND is called.
>... Eric Faulhaber
02:10 PM Feature #1580: upgrade Hibernate to latest level: I've build Hibernate. Although I haven't found any mentions about this, it turned out that Hibernate 4 requires Java ... Stanislav Lomany
07:50 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Don't forget that there is also the "master" table of all supported built-in functions in the "Functions" section of ... Greg Shah
11:19 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Please update the Conversion Reference (builtin_database_functions_methods_attributes.odt chapter) to reflect the imp... Eric Faulhaber
11:28 PM Feature #1910 (Hold): add schema conversion support for sequences: Eric Faulhaber
11:23 PM Feature #1910 (Closed): add schema conversion support for sequences: Eric Faulhaber
11:24 PM Feature #1911 (Closed): add runtime support for sequences: Eric Faulhaber
11:20 PM Feature #1595: add conversion and runtime support for DBPARAM() built-in function: Please update the Conversion Reference (builtin_database_functions_methods_attributes.odt chapter) to reflect the imp... Eric Faulhaber

11/05/2012

12:16 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: To implement this we need to analyze the data requested from db when the FIND is called.
I see that the @RandomAcc... Ovidiu Maxiniuc
10:23 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Do the proposed changes fully eliminate all differences? Greg Shah
05:21 AM Feature #1580: upgrade Hibernate to latest level: I've applied old Hibernate patches, still cannot compile it, but .g files were converted so I used them: WHERE TRUE /... Stanislav Lomany

11/02/2012

04:53 PM Feature #1580: upgrade Hibernate to latest level: I found that HQL parser doesn't support WHERE TRUE or WHERE FALSE where clause. I've applied the old Hibernate patche... Stanislav Lomany
04:49 PM Feature #1580: upgrade Hibernate to latest level: 1. In many places Hibernate Session.connection() is used, usually in order to create and execute a statement, but thi... Stanislav Lomany
12:43 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Comparison results (see attached screenshot)
Vadim Nebogatov

11/01/2012

07:20 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: P2J results for updated test case:
test1-1
test1-4
test1-8
test1-11
test1-14
test1-16
test1-18
test1-20
te... Vadim Nebogatov
04:15 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: 4GL results for updated test case:
test1-1
test1-4
test1-8
test1-11
test1-14
test1-16
test1-18
test1-20
te... Vadim Nebogatov
04:14 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Updated test case:
def temp-table tt
field num as int
field f as logical.
create tt. tt.num = 1. tt... Vadim Nebogatov
04:13 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: (not ?) - syntax is incorrect Vadim Nebogatov
05:14 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: I should have mentioned this too:
7. Make sure you post your updated version of the testcase code (the 4GL) here.
... Greg Shah
05:12 AM Bug #18 (WIP): issues with ne/equal and true/false conversion in WHERE clauses: Questions/requests/comments:
0. I think you mean Progress 4GL, not Postgres 4GL. <g>
1. Please modify the testc... Greg Shah
10:30 AM Feature #1595 (Review): add conversion and runtime support for DBPARAM() built-in function: Ovidiu Maxiniuc
10:29 AM Feature #1595 (WIP): add conversion and runtime support for DBPARAM() built-in function: Implemented as specified although I am a little uncertain about some parameters. Ovidiu Maxiniuc

10/31/2012

06:57 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Reason is found: expressions
(l <> true) and (NOT l)
(l <> false) and ( l)
are not equivalent in Postgres 4GL in ... Vadim Nebogatov
05:04 PM Feature #1890: upgrade to the latest stable PLJava and ensure that it is available on all target ...: Both 32-bit and 64-bit must be supported. Linux, Solaris and Windows all must be supported. Greg Shah
05:03 PM Feature #1890 (Closed): upgrade to the latest stable PLJava and ensure that it is available on al...: Greg Shah
12:45 PM Feature #1879: push lock manager back into database: Currently, the default lock manager resides in memory within the P2J application server. All code which needs to com... Eric Faulhaber
12:41 PM Feature #1879 (New): push lock manager back into database: Eric Faulhaber
09:54 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Uploaded update patch with modifications we discussed yesterday.
The most important change is that special code is... Ovidiu Maxiniuc

10/30/2012

03:36 PM Support #1854 (New): update the DB portions of the Conversion Reference: Greg Shah
03:27 PM Feature #1851: database performance/scalability tuning: This is a parent issue to which to add more granular tasks regarding performance and scalability tuning of the P2J pe... Eric Faulhaber
03:21 PM Feature #1851 (New): database performance/scalability tuning: Eric Faulhaber
01:57 PM Feature #1840: create a simple tool (and docs) to provide creation/import of databases at client ...: Some design questions:
1. What customization/configuration features need to be provided?
2. Do any of these custo... Greg Shah
01:54 PM Feature #1840 (New): create a simple tool (and docs) to provide creation/import of databases at c...: Greg Shah
12:37 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Ovidiu Maxiniuc wrote:
> * yes, OE displays @[yes]@ when running the following code: @display to-rowid("dksajdhk") =... Eric Faulhaber
12:29 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: * yes, OE displays @[yes]@ when running the following code: @display to-rowid("dksajdhk") = ?.@
* ok, I change the c... Ovidiu Maxiniuc
12:11 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Feedback from code review (1030a):
* Please confirm that in the event of a failure in converting a rowid string to... Eric Faulhaber
08:49 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: My mistake too, I took your affirmation about hexdigits for granted.
I fixed the other issues and added more testcas... Ovidiu Maxiniuc
12:12 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: I started the investigation with two separate users A and B (see the attached CC_research_X files).
However, A never... Ovidiu Maxiniuc

10/29/2012

04:54 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Place to be corrected is found. It is the rule
type == prog.equals or type == prog.not_eq) and (ancestor(prog.expres... Vadim Nebogatov
01:18 PM Feature #1580: upgrade Hibernate to latest level: The following compilation problems have been found:
1. org.hibernate.Session.connection function doesn't exist any m... Stanislav Lomany
10:08 AM Bug #1308: dirty share - related abend: This fix (svl_upd20101214a.zip) looks correct to me. The idea was to fail quickly with an IllegalArgumentException d... Eric Faulhaber
06:25 AM Bug #1308 (WIP): dirty share - related abend: Greg Shah

10/27/2012

05:23 PM Bug #1308: dirty share - related abend: The update (svl_upd20101214a) wasn't applied because it causes errors in Majic (I cannot provide concrete examples).
... Stanislav Lomany

10/26/2012

01:49 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Where are the test cases you wrote for the wider rowid strings? I didn't see that aspect of your research reflected ... Eric Faulhaber
01:44 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Feedback from code review:
* Sorry, I was mistaken with respect to the format I originally specified for the rowid st... Eric Faulhaber
11:01 AM Feature #1593 (Review): add conversion and runtime support for TO-ROWID() built-in function: Attached update file with changes from last notes and mail from Eric. Ovidiu Maxiniuc
12:23 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: OK, good research. A few more complications to throw into the mix before we can know the best way to implement...
... Eric Faulhaber
10:18 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: I spent some time doing investigations on this issue:
* I created an index on an existing field
* I added a new un-... Ovidiu Maxiniuc

10/25/2012

12:41 PM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: > I observed that when testing for changed, OE in fact re-read the record (don't know yet if entire record or only af... Eric Faulhaber
03:46 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function: To emulate the OpenEdge behavior in P2J runtime I run a few tests. The test cases are a little tricky as they imply h... Ovidiu Maxiniuc
12:04 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Ovidiu Maxiniuc wrote:
> Should we use 0, -1 or other negative number as a special case of P2J code?
-1. Eric Faulhaber
05:10 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: @ErrorManager.recordOrThrowError()@ methods require a number or a @NumberedException@. I understand that this is in f... Ovidiu Maxiniuc
05:35 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Added
OUTPUT TO VALUE("Z:\vadimtest").
to output test results to file.
Tested on the customer's 4GL environmen... Vadim Nebogatov

10/24/2012

02:52 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Ovidiu Maxiniuc wrote:
> You are right, the cutting is caused by default print format, in fact I could not find a li... Eric Faulhaber
03:19 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: You are right, the cutting is caused by default print format, in fact I could not find a limit for the size of this t... Ovidiu Maxiniuc

10/23/2012

01:57 PM Feature #1580 (WIP): upgrade Hibernate to latest level: Eric Faulhaber
01:43 PM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Ovidiu Maxiniuc wrote:
> Bullet 4 is datailed in my next note (4).
> @0x1000000@ is invalid just because the number o... Eric Faulhaber
10:34 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Bullet 4 is datailed in my next note (4).
@0x1000000@ is invalid just because the number of digits is odd. However, ... Ovidiu Maxiniuc
10:07 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: Ovidiu Maxiniuc wrote:
> After some investigation on the OpenEdge installation on windev01 I observed that string re... Eric Faulhaber
08:20 AM Feature #1593 (WIP): add conversion and runtime support for TO-ROWID() built-in function: In addition to previous constraints:
* strings representation must have even length. @0x012@, @0xabcde@ are invalid.
... Ovidiu Maxiniuc
05:29 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function: After some investigation on the OpenEdge installation on windev01 I observed that string representation of @ROWID@s:
... Ovidiu Maxiniuc
10:37 AM Feature #1594 (WIP): add conversion and runtime support for CURRENT-CHANGED() built-in function: Ovidiu Maxiniuc

Also available in: Atom

Project

General

Profile

FWD » Core Development » Database

Activity

Activity

11/13/2012

11/12/2012

11/11/2012

11/09/2012

11/08/2012

11/07/2012

11/06/2012

11/05/2012

11/02/2012

11/01/2012

10/31/2012

10/30/2012

10/29/2012

10/27/2012

10/26/2012

10/25/2012

10/24/2012

10/23/2012

10/22/2012

10/21/2012

10/19/2012

10/17/2012