Activity

From 10/30/2012 to 11/28/2012

11/29/2012

11:25 PM Feature #1582: add conversion and runtime support for sequences: Some additional code review comments for the 1123a drop:
* How is CustomSequence to be used? AFAIK, Progress sequ... Eric Faulhaber
10:40 PM Feature #1911: add runtime support for sequences: If we need transaction processing separate from the current (application-defined) database transaction, it sounds lik... Eric Faulhaber
10:30 PM Feature #1580: upgrade Hibernate to latest level: When those first warnings appear in the log, is it just the messages themselves, or is there any associated stack tra... Eric Faulhaber

11/28/2012

03:33 PM Feature #1580: upgrade Hibernate to latest level: I looked at the original log carefully and now we have reproduction:
V-C-select RFQ-Enter (RFQ server should be runn... Stanislav Lomany
10:26 AM Feature #1580: upgrade Hibernate to latest level: Stas, my conclusion about this being a threading issue was based on some cursory Internet research. Please dig into ... Eric Faulhaber
06:09 AM Feature #1580: upgrade Hibernate to latest level: Stanislav,
From the org.hibernate.Session javadoc (http://docs.jboss.org/hibernate/orm/4.1/javadocs/org/hibernate/Se... Constantin Asofiei
05:54 AM Feature #1580: upgrade Hibernate to latest level: A session CAN be closed in another thread:... Stanislav Lomany
11:06 AM Feature #1911: add runtime support for sequences: An issue related to PSQL, but not only:
On a finite, non cycling sequences, calling @nextVal@ will return an error... Ovidiu Maxiniuc
04:18 AM Feature #1583 (Review): add conversion and runtime support for the INSERT language statement: Ovidiu Maxiniuc
04:18 AM Feature #1583 (WIP): add conversion and runtime support for the INSERT language statement: Ovidiu Maxiniuc
04:15 AM Feature #1583: add conversion and runtime support for the INSERT language statement: I first tested if the sequence of CREATE/UPDATE has the same effect like @INSERT@. My fear was that if user skips the... Ovidiu Maxiniuc

11/27/2012

06:32 PM Feature #1580: upgrade Hibernate to latest level: Eric Faulhaber wrote:
> ... Although I haven't looked at the latest Hibernate source, I suspect Hibernate is using a... Eric Faulhaber
06:21 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Please explain your SQLFunction idea more fully. It is intriguing.
I think this is a relatively new feature in Hi... Eric Faulhaber
06:03 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: How to proceed with this task?.. Vadim Nebogatov
04:57 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: One more option is providing a custom comparing functions (org.hibernate.dialect.function.SQLFunction) registered wit... Vadim Nebogatov

11/26/2012

06:22 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: I agreed absolutely. But it seems there is no choice if you want to fix this issue on the HQL level.
My draft idea ... Vadim Nebogatov
12:05 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Vadim Nebogatov wrote:
> > I don't remember this being a supported operator in HQL.
> What operator did you mean? H... Eric Faulhaber
12:59 PM Feature #1666: add support for mixed-direction indexes: I use PostgreSQL 9.1 (not the latest available version but what I have installed) to test this issue. Also I have a p... Ovidiu Maxiniuc
12:26 PM Feature #1926: create an en_GB@p2j_basic locale definition: Model this after locale/en_US@p2j_basic, customizing LC_CTYPE and LC_COLLATE sections. Use en_GB as a basis instead ... Eric Faulhaber
12:22 PM Feature #1926 (Hold): create an en_GB@p2j_basic locale definition: Eric Faulhaber

11/25/2012

04:56 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Yes, you are correct, I did not notice that issue concerns NHibernate, but all others I wrote about Hibernate.
CA... Vadim Nebogatov
02:04 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Vadim Nebogatov wrote:
> IS [NOT] DISTINCT FROM predicate is not supported with Hibernate and it seems they even do ... Eric Faulhaber
12:25 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: IS [NOT] DISTINCT FROM predicate is not supported with Hibernate and it seems they even do not plan to support it:
... Vadim Nebogatov

11/24/2012

05:00 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Vadim Nebogatov wrote:
> What about limitations for SQL statement length which some databases have? Resulting SQL st... Eric Faulhaber
03:30 PM Feature #1911 (WIP): add runtime support for sequences: Eric Faulhaber
03:25 PM Feature #1666: add support for mixed-direction indexes: Highest priority sub-tasks of this issue should be:
# to fix the creation of indexes during the data import proces... Eric Faulhaber

11/23/2012

06:01 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Yes, I understand this. Converted code will be not affected in this case, HQLAst and parameter list changes should be... Vadim Nebogatov
05:53 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: I'll let Eric comment on all the other good information and questions you have posed.
The only thing I want to mak... Greg Shah
05:34 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: What about limitations for SQL statement length which some databases have? Resulting SQL statement could be very heavy. Vadim Nebogatov
05:15 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: I have found out that not only inequality should be replaced but equality also work incorrectly in some cases.
Very ... Vadim Nebogatov
01:26 PM Feature #1582 (WIP): add conversion and runtime support for sequences: I have reviewed the progress.g changes. They are fine. My only request is for you to please change the ending copyr... Greg Shah
12:04 PM Feature #1582: add conversion and runtime support for sequences: My answers/comments to your questions:
* There is no separate ddl file generated for sequences. Only the xml that ge... Ovidiu Maxiniuc
01:03 AM Feature #1582: add conversion and runtime support for sequences: I have done only a very high-level review of the update so far, and it looks like you've addressed all the necessary ... Eric Faulhaber
08:32 AM Feature #1580: upgrade Hibernate to latest level: I don't like putting a Hibernate-specific hack into our more generic implementation.
Let's back up a bit. In what... Greg Shah

11/22/2012

03:04 PM Feature #1580: upgrade Hibernate to latest level: Eric, at 3 I'm not saying that is not feasible; as only Conversation threads can create hibernate Sessions, at a firs... Constantin Asofiei
01:16 PM Feature #1580: upgrade Hibernate to latest level: Regarding points 1 & 2 in the previous post: currently, there is no creation of Hibernate Session objects on anythin... Eric Faulhaber
11:42 AM Feature #1580: upgrade Hibernate to latest level: Thoughts about context cleanup:
# If the we decide to clean the Hibernate session on the Conversion thread, then we ... Constantin Asofiei
11:02 AM Feature #1580: upgrade Hibernate to latest level: The Hibernate Session objects are created on the conversation thread (for that matter, all persistence runtime code o... Eric Faulhaber
09:52 AM Feature #1580: upgrade Hibernate to latest level: I don't think it is as simple as you suggest. By its nature, all contexts are accessed from multiple threads. At a ... Greg Shah
12:56 AM Feature #1580: upgrade Hibernate to latest level: Regarding the error...... Eric Faulhaber
12:35 AM Feature #1580: upgrade Hibernate to latest level: Eric Faulhaber wrote:
> How common was the
>
> [...]
>
> error in the regression server log? This looks a lot... Stanislav Lomany
12:28 AM Feature #1580: upgrade Hibernate to latest level: How common was the... Eric Faulhaber
11:01 AM Feature #1582: add conversion and runtime support for sequences: Uploaded update patch that covers both conversion and runtime sub-tasks (1910 and 1911). Ovidiu Maxiniuc
09:17 AM Feature #1583: add conversion and runtime support for the INSERT language statement: Yes, I agree completely. So far we have almost never seen this statement used in practice. It is an interesting com... Greg Shah
12:17 AM Feature #1583: add conversion and runtime support for the INSERT language statement: Greg,
There are only 4 uses of this statement across both projects (all in the server project), and they are all o... Eric Faulhaber
06:17 AM Feature #1911: add runtime support for sequences: I discovered a way to access the current value in PostgreSQL without calling @CURRVAL@ which fails if it's called bef... Ovidiu Maxiniuc
12:21 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Yes, I agree, let's put it in the HQLPreprocessor. Eric Faulhaber

11/21/2012

12:58 PM Feature #1580: upgrade Hibernate to latest level: Modification of LogicalUserType completely solves the problem (unless regression testing will show a surprise). Other... Stanislav Lomany
12:11 PM Feature #1580: upgrade Hibernate to latest level: Stanislav Lomany wrote:
> 4. Possible work around: use quotes for boolean literals: 'true' and 'false'
> 5. I don't... Eric Faulhaber
10:23 AM Feature #1580: upgrade Hibernate to latest level: About boolean literals:
1. The bug/feature is related only to the fields of the P2J LogicalUserType (and any other c... Stanislav Lomany
09:48 AM Feature #1911: add runtime support for sequences: Here are the result about MS SQL server. I used the free 2012 EXPRESS version with SP1, but I believe that there are ... Ovidiu Maxiniuc

11/20/2012

11:20 AM Feature #1911: add runtime support for sequences: 1. There is no problem for Progress/OE having a simple code like:... Ovidiu Maxiniuc
10:53 AM Feature #1911: add runtime support for sequences: Please also research sequences in MS SQL Server, which we have to support for this project. Eric Faulhaber
10:38 AM Feature #1911: add runtime support for sequences: Ovidiu Maxiniuc wrote:
> [...]
>
> *PostgreSQL*
> * offers full support for sequences (min and max values, varia... Eric Faulhaber
08:21 AM Feature #1911: add runtime support for sequences: I have done some investigations and here is what I found out:
The Hibernate @Dialect@ base class defines the followi... Ovidiu Maxiniuc
07:52 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: This should not be exploded into the code. It should be hidden in the HQL preprocessor.
There is even a good reas... Greg Shah

11/19/2012

05:45 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: In common case 4GL inequality expression in WHERE clause
exp1!=exp2
should be replaced with
(exp1 is null and e... Vadim Nebogatov
09:41 AM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Vadim Nebogatov wrote:
> Problem found. In common case is that not enough to change
>
> expr1 != expr2
>
> to
... Eric Faulhaber
05:39 PM Feature #1910: add schema conversion support for sequences: So far the discussion has centered around the conversion of business logic references to sequences, but the highest p... Eric Faulhaber
01:33 PM Feature #1910: add schema conversion support for sequences: From progress.g:... Greg Shah
11:43 AM Feature #1910: add schema conversion support for sequences: The key point here is that the assignment style statements should already be working without duplicating the assignme... Greg Shah
11:40 AM Feature #1910: add schema conversion support for sequences: ... Greg Shah
10:54 AM Feature #1910: add schema conversion support for sequences: I can now confirm that the statements also need "EQUALS! expr" at the end. Indeed, the syntax is stupid, but the antl... Ovidiu Maxiniuc
10:53 AM Feature #1910: add schema conversion support for sequences: What do you mean?
At this moment, the P2J work just fine, .p file is correctly converted.
Keeping @sequence_funcs@ ... Ovidiu Maxiniuc
10:14 AM Feature #1910: add schema conversion support for sequences: OK, that explains things. When I added support for those, I had no way to test if the unquoted names could be used i... Greg Shah
10:02 AM Feature #1910: add schema conversion support for sequences: As far as I can see, they are already there:... Ovidiu Maxiniuc
09:54 AM Feature #1910: add schema conversion support for sequences: We have not yet written the backing class for the 64-bit integer. It will be called int64 when it is written. But t... Greg Shah
09:48 AM Feature #1910: add schema conversion support for sequences: The answer for 2nd question for now:
I am positive that DYNAMIC- forms require exactly 2 character parameters. This ... Ovidiu Maxiniuc
09:27 AM Feature #1910: add schema conversion support for sequences: Questions:... Greg Shah
02:04 AM Feature #1910: add schema conversion support for sequences: I created the new @com.goldencode.p2j.util.Sequence@ class with the appropriate methods declarations.
However, the P... Ovidiu Maxiniuc
09:38 AM Feature #1580: upgrade Hibernate to latest level: Have you removed all the old versions of the Hibernate jar and its dependencies from the project and from the p2j.mf ... Eric Faulhaber
05:09 AM Feature #1580: upgrade Hibernate to latest level: I have some troubles with Hibernate. I have the small project to deal with different versions of Hibernate and while ... Stanislav Lomany

11/18/2012

05:42 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: We can only use constructs that can be expressed in HQL and which are supported across all major databases (e.g., Ora... Eric Faulhaber

11/17/2012

04:26 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Variant with changes in QUERY_SUBST is investigated. It is also possible solution but not very easy because QUERY_SU... Vadim Nebogatov

11/16/2012

05:40 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Problem found. In common case is that not enough to change
expr1 != expr2
to
expr1 is null and expr2 is not ... Vadim Nebogatov
11:57 AM Feature #1910: add schema conversion support for sequences: Please show the changes you have had to make. I am especially interested in the progress.g changes, but show everyth... Greg Shah
11:35 AM Feature #1910 (WIP): add schema conversion support for sequences: Ovidiu Maxiniuc
07:45 AM Feature #1580: upgrade Hibernate to latest level: Stanislav Lomany wrote:
> Interesting thing about boolean literals issue is that it presents in the latest Hibernate... Eric Faulhaber
07:12 AM Feature #1580: upgrade Hibernate to latest level: Boolean literals can be fixed by the following changes in org.hibernate.hql.internal.ast.tree.BooleanLiteralNode:
<p... Stanislav Lomany

11/15/2012

06:04 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses: Based on idea above, new rule and function "replaceInequalityNode" are added. Function seems is not optimal, I think... Vadim Nebogatov
05:09 PM Feature #1580: upgrade Hibernate to latest level: So, what are your thoughts about how we address these 3 errors?
Also, thoughts on the deprecated, positional param... Eric Faulhaber
03:10 PM Feature #1580: upgrade Hibernate to latest level: Interesting thing about boolean literals issue is that it presents in the latest Hibernate release (at first I though... Stanislav Lomany
07:09 AM Feature #1580: upgrade Hibernate to latest level: As far as I've analyzed the regression testing log (it is 500M), there are three types of errors:
1. Boolean literal... Stanislav Lomany
09:50 AM Feature #1582: add conversion and runtime support for sequences: Ovidiu Maxiniuc wrote:
> ... I believe P2J implementation will focus on OE10.x at the moment so the P2J implementati... Eric Faulhaber
07:53 AM Feature #1582: add conversion and runtime support for sequences: Seems like the OpenEdge version installed on windev01 is only at version 10.2 and does not support the new extra para... Ovidiu Maxiniuc
05:26 AM Feature #1582: add conversion and runtime support for sequences: At first attempt to read about and prepare the dynamic forms testcases I could not find them in Progress Reference do... Ovidiu Maxiniuc

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

« Previous

Also available in: Atom

Project

General

Profile

FWD » Core Development » Database

Activity

Activity

11/29/2012

11/28/2012

11/27/2012

11/26/2012

11/25/2012

11/24/2012

11/23/2012

11/22/2012

11/21/2012

11/20/2012

11/19/2012

11/18/2012

11/17/2012

11/16/2012

11/15/2012

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