Activity
From 10/04/2012 to 11/02/2012
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...
- 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...
- 12:43 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses
- Comparison results (see attached screenshot)
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... - 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... - 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... - 04:13 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses
- (not ?) - syntax is incorrect
- 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.
... - 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... - 10:30 AM Feature #1595 (Review): add conversion and runtime support for DBPARAM() built-in function
- 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.
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 ... - 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.
- 05:03 PM Feature #1890 (Closed): upgrade to the latest stable PLJava and ensure that it is available on al...
- 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...
- 12:41 PM Feature #1879 (New): push lock manager back into database
- 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...
10/30/2012
- 03:36 PM Support #1854 (New): update the DB portions of the Conversion Reference
- 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...
- 03:21 PM Feature #1851 (New): database performance/scalability tuning
- 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... - 01:54 PM Feature #1840 (New): create a simple tool (and docs) to provide creation/import of databases at c...
- 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") =... - 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... - 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... - 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... - 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...
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... - 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... - 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...
- 06:25 AM Bug #1308 (WIP): dirty share - related abend
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).
...
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 ...
- 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... - 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.
- 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...
... - 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-...
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...
- 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...
- 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. - 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...
- 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...
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... - 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...
10/23/2012
- 01:57 PM Feature #1580 (WIP): upgrade Hibernate to latest level
- 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... - 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, ... - 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... - 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.
... - 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:
... - 10:37 AM Feature #1594 (WIP): add conversion and runtime support for CURRENT-CHANGED() built-in function
10/22/2012
- 01:00 AM Feature #1669: add support for additional database methods
- Need customer report results to make a list of needed methods.
- 12:59 AM Feature #1669 (Closed): add support for additional database methods
- 12:59 AM Feature #1668: add support for additional (non-dynamic) database attributes
- Need customer report results to make a list of needed attributes.
- 12:58 AM Feature #1668 (Closed): add support for additional (non-dynamic) database attributes
- 12:55 AM Feature #1667: improve support for "FOR EACH FIRST" and similar cases
- Currently, instances of looping queries like FOR EACH...FIRST... are converted to CompoundQuery. This works logicall...
- 12:50 AM Feature #1667 (New): improve support for "FOR EACH FIRST" and similar cases
- 12:49 AM Feature #1666: add support for mixed-direction indexes
- First version of P2J was built on an older version of PostgreSQL, which did not support indexes with multiple columns...
- 12:43 AM Feature #1666 (Closed): add support for mixed-direction indexes
- 12:42 AM Feature #1665: automate import process
- Today the data import process is well documented, but it contains many manual steps and is thus error prone. This pr...
- 12:38 AM Feature #1665 (Closed): automate import process
- 12:37 AM Feature #1664: data import improvements
- * performance improvement: re-architect threading to distribute work in a more granular way (preserve prioritization...
- 12:33 AM Feature #1664 (New): data import improvements
- 12:31 AM Feature #1663 (Closed): test/debug case-sensitive field support
- 12:30 AM Feature #1662: runtime support for table parameters
- Needs research: is it just a handle or is there some special DB processing needed at the transition point?
- 12:30 AM Feature #1662 (Closed): runtime support for table parameters
- 12:26 AM Feature #1661: support case-sensitive fields in indexes
- This will require changes to:
* the DDL index generation code (don't emit UPPER function in CREATE INDEX statement);
... - 12:21 AM Feature #1661 (Closed): support case-sensitive fields in indexes
- 12:20 AM Feature #1660: add conversion and runtime support for OF keyword use in a CAN-FIND
- Actually not sure if this currently is supported or not (most likely not). Need some test cases to determine the lim...
- 12:16 AM Feature #1660 (Closed): add conversion and runtime support for OF keyword use in a CAN-FIND
- 12:14 AM Feature #1659: add support for field exclusion/inclusion lists in queries
- This feature supports a performance optimization in which -- for read-only usage of a table -- the query's results on...
- 12:09 AM Feature #1659 (New): add support for field exclusion/inclusion lists in queries
- 12:08 AM Feature #1658: improve database trigger support
- * runtime support for TRIGGER PROCEDURE (DELETE, WRITE, CREATE), DISABLE TRIGGERS, ON FIND OF table;
* need report c... - 12:06 AM Feature #1658 (Closed): improve database trigger support
10/21/2012
- 06:13 PM Feature #1657: add Oracle support
- This task will require:
* using Oracle's Java support to run our Java UDFs inside the server process;
* creating ... - 06:11 PM Feature #1657: add Oracle support
- This task is on hold until a customer requires it.
- 06:11 PM Feature #1657 (Hold): add Oracle support
- 06:09 PM Feature #1656: add Microsoft SQL Server support
- We need to be able to run Java UDFs inside the database server process. This task will require:
* building an infra... - 05:51 PM Feature #1656 (Closed): add Microsoft SQL Server support
- 05:49 PM Feature #1655: add conversion and runtime support for certain dynamic database attributes and met...
- Need to run customer reports to generate exact list of methods and attributes required.
- 05:44 PM Feature #1655 (Closed): add conversion and runtime support for certain dynamic database attribute...
- 05:42 PM Feature #1654: add conversion and runtime support for dynamic buffer creation and cleanup
- This feature will require dynamic (runtime) conversion of the CREATE BUFFER statement.
- 05:42 PM Feature #1654 (Closed): add conversion and runtime support for dynamic buffer creation and cleanup
- 05:41 PM Feature #1653: add conversion and runtime support for dynamically prepared queries
- This feature will require dynamic (runtime) conversion of the CREATE QUERY statement.
- 05:26 PM Feature #1653 (Closed): add conversion and runtime support for dynamically prepared queries
- 05:40 PM Feature #1652: add conversion and runtime support for dynamically prepared temp-tables
- This feature will require (at minimum) dynamically:
* converting the statement at runtime into some representation o... - 05:23 PM Feature #1652 (Closed): add conversion and runtime support for dynamically prepared temp-tables
- 05:24 PM Feature #1651: add support for dynamic database features
- Requires binary TRPL as a pre-requisite, since conversion will have to occur at runtime, on the fly.
- 05:22 PM Feature #1651 (Closed): add support for dynamic database features
10/19/2012
- 08:18 AM Feature #1602 (Closed): support BigDecimal in PLJAVA indexOf() implementation
- 08:17 AM Feature #1601 (Closed): implement NUMERIC type in relational database schemas
10/17/2012
- 01:03 AM Feature #1595: add conversion and runtime support for DBPARAM() built-in function
- Conversion support will be added in builtin_functions.rules. Should map to a new static method in @ConnectionManager...
- 12:54 AM Feature #1595 (Closed): add conversion and runtime support for DBPARAM() built-in function
- 12:53 AM Feature #1594: add conversion and runtime support for CURRENT-CHANGED() built-in function
- Will require conversion support in builtin_functions.rules and runtime support in RecordBuffer. Possibly will requir...
- 12:47 AM Feature #1594 (Closed): add conversion and runtime support for CURRENT-CHANGED() built-in function
- 12:45 AM Feature #1593: add conversion and runtime support for TO-ROWID() built-in function
- Both @TO-ROWID(rowid-string)@ and the inverse/complementary use of @STRING(ROWID(record))@ must be supported.
The ... - 12:01 AM Feature #1593 (Closed): add conversion and runtime support for TO-ROWID() built-in function
- 12:00 AM Feature #1592 (Closed): implement additional database built-in functions
10/12/2012
- 11:48 PM Feature #1588: add conversion and runtime support for embedded SQL
- The following use cases need to be supported:
* @SELECT COUNT(*) INTO var FROM table WHERE ...@
* @SELECT SUM(field... - 11:46 PM Feature #1588 (Closed): add conversion and runtime support for embedded SQL
- 11:40 PM Feature #1587: implement full support for word indexes
- A "true" implementation of word indexes will be necessary if (when) the quick and dirty implementation using LIKE is ...
- 11:35 PM Feature #1587 (Closed): implement full support for word indexes
- 11:33 PM Feature #1586 (Closed): add quick and dirty support for word indexes using LIKE operator
- 11:32 PM Feature #1585 (Closed): add conversion and runtime support for word indexes
- 11:19 PM Feature #1583 (Closed): add conversion and runtime support for the INSERT language statement
- 11:14 PM Feature #1582: add conversion and runtime support for sequences
- The following schema properties (with the noted settings) must be supported by schema conversion:
* initial value of... - 11:00 PM Feature #1582 (Closed): add conversion and runtime support for sequences
10/11/2012
- 12:27 PM Feature #1581: add conversion and runtime support for certain metadata constructs
- Metadata tables and fields are used in Progress 4GL like regular table and field references, however, they do not map...
- 12:16 PM Feature #1581 (Closed): add conversion and runtime support for certain metadata constructs
- 11:14 AM Feature #1580: upgrade Hibernate to latest level
- P2J currently is at a woefully old level of Hibernate (3.0.5), which is holding back customer development. We need t...
- 10:54 AM Feature #1580 (Closed): upgrade Hibernate to latest level
Also available in: Atom