Activity
From 03/26/2014 to 04/24/2014
04/24/2014
- 02:35 PM Feature #2220: dynamic query methods which require implementation
- >I guess you are referring to OPEN QUERY FOR ... cases (as opposed to OPEN QUERY PRESELECT ...),
By preselect queri... - 08:25 AM Feature #2220: dynamic query methods which require implementation
- Right. I thought we are talking about only about queries which can be used in OPEN QUERY and forgot that P2JQuery has...
- 08:22 AM Feature #2220: dynamic query methods which require implementation
- Stanislav Lomany wrote:
> >Are there any concrete implementations of P2JQuery for which this parameter will not appl... - 06:53 AM Feature #2220: dynamic query methods which require implementation
- >Are there any concrete implementations of P2JQuery for which this parameter will not apply (i.e., with which indexIn...
04/23/2014
- 06:56 PM Feature #2220: dynamic query methods which require implementation
- Yes, I see. The conversion seems correct, but the sort clause is lossy in this case, with respect to the selected ind...
- 06:28 PM Feature #2220: dynamic query methods which require implementation
- > I would like to avoid passing additional information into the constructor for the index in use, because we essentia...
- 03:59 PM Feature #2220: dynamic query methods which require implementation
- Stanislav Lomany wrote:
> About @deleteResultListEntry@ - it can be applied to
> 1. queries with preselected resul... - 03:32 PM Feature #2220: dynamic query methods which require implementation
- Stanislav Lomany wrote:
> @createResultListEntry@ doesn't present in the customer project. Should I implement it?
N... - 03:09 PM Feature #2220: dynamic query methods which require implementation
- Stanislav Lomany wrote:
> Eric, some issues about @indexInformation@:
> 3. For static queries I see three ways of s... - 02:48 PM Feature #2220: dynamic query methods which require implementation
- About @deleteResultListEntry@ - it can be applied to
1. queries with preselected result set
2. scrolling queries o... - 02:50 PM Feature #2281: enhance schema name conversion to support literal replacements
- I have attached update vmn_upd20140423a.zip and examples of hints and conversion results vmn_upd20140423b.zip. The co...
- 01:21 PM Feature #1661: support case-sensitive fields in indexes
- Ovidiu Maxiniuc wrote:
> I observed that some code is duplicated (TempTableHelper:516-527 and P2JH2Dialect:795-805).... - 01:00 PM Feature #1661: support case-sensitive fields in indexes
- Eric Faulhaber wrote:
> * Why was the change to schema/fixups.xml needed? Does the @kw_case_sen@ token appear anywhe...
04/22/2014
- 03:58 PM Feature #2281: enhance schema name conversion to support literal replacements
- Vadim Nebogatov wrote:
> Remaining issue is escaping schema name. It is not used in DDL, so I try to understand now ... - 03:49 PM Feature #2281: enhance schema name conversion to support literal replacements
- I have attached first results: update vmn_upd20140422a.zip contains example of new hints and corresponding DDL files....
- 11:05 AM Feature #2290: enhance SchemaDictionary to store context-local information for dynamic queries
- Currently, a new @SchemaDictionary@ instance is created for each context (see @SchemaDicitonary.localInstance@, which...
- 10:53 AM Feature #2290 (New): enhance SchemaDictionary to store context-local information for dynamic queries
- 07:57 AM Bug #2219: problematic dynamic query test cases
- Stanislav Lomany wrote:
> > The problem here is that a dynamic resource can survive a procedure ran persistent - ple... - 07:20 AM Bug #2219: problematic dynamic query test cases
- > The problem here is that a dynamic resource can survive a procedure ran persistent - please test what happens if yo...
- 02:50 AM Bug #2219: problematic dynamic query test cases
- Stanislav Lomany wrote:
> The issue is caused by an unclosed implicit transaction opened by a query. It doesn't caus...
04/21/2014
- 04:06 PM Feature #2281: enhance schema name conversion to support literal replacements
- Processed formats: @"%s_timestamp"@, @"%s_offset"@, @"alter table %s alter column %s %s as %s;"@
Actually only tw... - 03:35 AM Feature #2281: enhance schema name conversion to support literal replacements
- Some more changes implemented: ...
- 01:37 PM Bug #18: issues with ne/equal and true/false conversion in WHERE clauses
- The non-WHERE clause related conversion errors are being managed in #2288. The scope of this task is now just the WHE...
- 12:07 PM Bug #2219: problematic dynamic query test cases
- The issue is caused by an unclosed implicit transaction opened by a query. It doesn't cause an error for static queri...
04/20/2014
- 12:21 PM Feature #1661: support case-sensitive fields in indexes
- Eric Faulhaber wrote:
> * DynamicQueryHelper: why have you added back the @WorkArea.permSchemasLoaded@ flag? Perhaps... - 10:17 AM Feature #2281: enhance schema name conversion to support literal replacements
- Eric, no problems, it is not an issue already.
It seems approach with using Hybernate's backticks is good and I a...
04/19/2014
- 02:46 PM Feature #2281: enhance schema name conversion to support literal replacements
- Vadim Nebogatov wrote:
> The question concerning using @escape@ attribute.
>
> Should it be done on the level of... - 09:24 PM Feature #2281: enhance schema name conversion to support literal replacements
- The reason for this feature is that some customers (as for the current project) want to use names where case is relev...
- 02:43 PM Bug #2285 (Closed): Regression when converting the server sources: null annotation
- 09:51 AM Bug #2285: Regression when converting the server sources: null annotation
- Update vmn_upd20140416a.zip committed to bzr rev.10512 and distributed.
- 10:19 PM Bug #2285: Regression when converting the server sources: null annotation
- With this fix, the NullPointerException (the 1st problem in note 1 above) no longer occurs. I don't see the other pro...
- 02:32 PM Feature #2258 (Closed): retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime suppor...
- 01:38 PM Feature #2220: dynamic query methods which require implementation
- Guys, about @deleteResultListEntry@ - how it should be implemented? My idea is to make query-specific list of recids ...
04/18/2014
- 07:21 PM Feature #2281: enhance schema name conversion to support literal replacements
- I am trying to implement @escape@ support using Hybernate's backticks @`@ for columns with escape hint. In this case ...
- 06:15 PM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Update vmn_upd20140409a.zip passed regression and distributed. Bzr revision is 10511.
- 05:52 PM Feature #1661: support case-sensitive fields in indexes
- Code review 20140416b:
Nice functional update (and a lot of code cleanup as well). Some issues/questions:
* Why... - 01:26 PM Feature #1661: support case-sensitive fields in indexes
- I believe the current update passed the test. The only issues were:
* ctrlc_01_session5: Expected '' (0x0000 at rela... - 04:23 PM Bug #2285: Regression when converting the server sources: null annotation
- Code review 20140416a:
The changes look OK to me. Please do a regular conversion regression test.
I will run a ... - 11:48 AM Feature #2220: dynamic query methods which require implementation
- Constantin, yes, for static query it for some reason requires explicit fields specifications while works fine for dyn...
- 11:21 AM Feature #2220: dynamic query methods which require implementation
- Stanislav, if I'm putting your example into a @OPEN QUERY@ case, the code can not compile in 4GL - it says that @f2@ ...
- 09:15 AM Feature #2220 (WIP): dynamic query methods which require implementation
- Eric, some issues about @indexInformation@:
1. There may be some differences in index selection rules with 4GL, e.g....
04/17/2014
- 05:22 PM Feature #1661: support case-sensitive fields in indexes
- The update almost passed the full-regression testing, 3 tests failed:
* ctrlc_11_session1/3/4: because some semaphor...
04/16/2014
- 02:35 PM Bug #2285: Regression when converting the server sources: null annotation
- Attached @vmn_upd20140416a.zip@ fixes first exception. It is possible some more errors also will be fixed. Attached @...
- 03:26 AM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Regression 20140415_154604 completed. 3 tests failed:
1. tc_job_002 FAILED failure in step 40: 'Unexpected EOF in ...
04/14/2014
- 03:18 PM Bug #2285 (WIP): Regression when converting the server sources: null annotation
- -------- Original Message --------
Subject: regression when converting the server sources
Date: Mon, 14 Apr 2014 ... - 03:17 PM Bug #2285 (Closed): Regression when converting the server sources: null annotation
04/13/2014
- 05:22 PM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- tc_job_clock_002 test fails each time because of timeout error:
failure in step 20: 'timeout before the specific s... - 02:49 PM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Since tc_job_clock_002 has failed each time, have you checked the server.log to see if there is a real regression? Ha...
- 01:47 PM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Regression 20140413_095429 completed. 6 tests failed, including
tc_job_002
tc_job_clock_002
Will start regre... - 02:40 PM Feature #2281: enhance schema name conversion to support literal replacements
- The question concerning using @escape@ attribute.
Should it be done on the level of overriding normalizer.normalize...
04/12/2014
- 08:47 PM Feature #2282 (Hold): make number of pattern engine instances per conversion profile configurable
- Currently, we create one pattern engine instance per conversion profile (e.g., schema/p2o, annotations/annotations, e...
- 08:25 PM Feature #2282 (Hold): make number of pattern engine instances per conversion profile configurable
- 08:23 PM Feature #2276 (Closed): create a work queue of PatternEngine instances for runtime conversion tasks
- The attached update has passed regression testing and is committed to bzr rev. 10510.
04/11/2014
- 05:09 PM Feature #1661: support case-sensitive fields in indexes
- Intermediary update, not fully tested.
Changes:
Added case-sensitive attribute in @P2JField@.
Added @caseSensitive... - 02:43 PM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Regression 20140411_102011 completed. 3 tests failed:
1. tc_job_002 FAILED failure in step 40: 'Unexpected EOF in ... - 02:25 PM Feature #2148: enhance prototype to compile p2jpl.jar file with IKVMC into .NET assembly and load...
- Using the attached om_upd20140314a.zip, almost all methods and functions have full support for MSSQL (the fully imple...
04/10/2014
- 03:26 PM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Regression 20140410_105536 completed. 3 tests failed:
1. tc_job_002 FAILED failure in step 40: 'Unexpected EOF in ... - 12:50 AM Feature #2258 (Test): retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support ...
- 12:46 AM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Code review 20140409a:
The update looks good. Please regression test. - 02:51 PM Feature #2281: enhance schema name conversion to support literal replacements
- Yes and yes.
- 01:41 PM Feature #2281: enhance schema name conversion to support literal replacements
- The question concerning fields with extent.
Would be possible using denormalization hints along with literal replac... - 10:55 AM Feature #2281 (WIP): enhance schema name conversion to support literal replacements
- 12:39 AM Feature #2281: enhance schema name conversion to support literal replacements
- We need to enhance the schema hint syntax to allow the name conversion algorithms to be bypassed entirely, such that ...
- 12:14 AM Feature #2281 (Closed): enhance schema name conversion to support literal replacements
04/09/2014
- 05:48 PM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- I have attached update vmn_upd20140409a.zip and tests used vmn_upd20140409b.zip for review.
- 05:23 PM Bug #2280: Error with FIND-FIRST() method
- Test case:...
- 05:02 PM Bug #2280 (Closed): Error with FIND-FIRST() method
- 04:42 PM Feature #1661: support case-sensitive fields in indexes
- There is as chance that the proposed solution might not be implemented because at some points the indexes are dropped...
04/08/2014
- 03:58 PM Feature #1661: support case-sensitive fields in indexes
- Eric Faulhaber wrote:
> What do you propose to correct this? You can modify the dialect API as needed.
To fix this is... - 02:18 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Reuploaded the update after merging with latest bzr revision (10506).
- 06:27 AM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Fixed with replacement in @database_access.rules@:...
04/07/2014
- 03:50 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Added update for review.
The implementation allows specifying @sql-size@ attribute for all datatypes. However, only ... - 02:15 PM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- One more not related bug found with compare with BINARY both for statement (method works properly):...
04/05/2014
- 12:28 PM Feature #2276: create a work queue of PatternEngine instances for runtime conversion tasks
- Missed a few files, so I'm re-uploading this update.
- 12:21 PM Feature #2276: create a work queue of PatternEngine instances for runtime conversion tasks
- Interim update. I am uploading it as a safety backup, but it still needs a lot of work and cleanup.
- 08:33 AM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- Please include the fix with your update for this issue.
- 06:42 AM Feature #2258: retrofit BUFFER-COPY and BUFFER-COMPARE language statement runtime support to use ...
- During testing I have found one bug not related directly with issue.
RecordBuffer, line 4032:...
04/04/2014
- 04:31 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- For the hint syntax, we generally follow the rule of thumb that if there can be only one value, the information is st...
- 04:25 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- I started adding hint support for table fields. I added parsing and processing in TableHints.java, p2o.xml, hibernate...
- 04:08 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Based on your findings of the longer index limit on their development systems, we have asked the customer to confirm ...
- 04:01 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- My previous test cases were too complicated.
Thanks to Greg's suggestion, I used the other condition guards for the... - 11:09 AM Feature #2276: create a work queue of PatternEngine instances for runtime conversion tasks
- Constantin, I implemented it this way because I was trying to mimic how we use the pattern engine during static conve...
- 05:13 AM Feature #2276: create a work queue of PatternEngine instances for runtime conversion tasks
- Eric,
> running the global init-rules once per PatternEngine instance
I'm a little concerned about this, as it will... - 11:48 PM Feature #2276 (WIP): create a work queue of PatternEngine instances for runtime conversion tasks
- To prove that this idea has merit, I've hacked up the dynamic conversion code and made some changes to @PatternEngine...
- 09:52 AM Feature #2134 (Closed): configurable denormalization of extent fields into individual fields in s...
04/03/2014
- 06:30 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- > This looks like a fatal error, I was not able to catch it with no-error clause added to assign statement, and also ...
- 03:26 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- h3. Write test cases which violate the Progress index size limit to determine error conditions we need to handle.
... - 10:31 AM Feature #2134: configurable denormalization of extent fields into individual fields in schema con...
- h2. Configurable denormalization of extent fields into individual fields
Two types of field denormalization are supp...
04/02/2014
- 05:50 PM Feature #2231 (Closed): LockType error processing
- 05:49 PM Feature #2231: LockType error processing
- Committed to bzr rev. 10503.
- 04:22 PM Feature #2231: LockType error processing
- Yes, please commit and distribute the update.
- 01:41 PM Feature #2231: LockType error processing
- Second regression 20140402_084955 is completed with 2 FAILED tests:
1. tc_job_002 FAILED failure in step 40: failu... - 03:32 AM Feature #2231: LockType error processing
- Regression 20140401_172003 completed with 4 FAILED tests:
1. tc_job_002 FAILED failure in step 40: 'Unexpected EOF i... - 03:30 PM Feature #2273 (WIP): address remaining limitations of SQL Server needed to support legacy 4GL beh...
- h3. Research the options we have in terms of unlimited length text data (including participation of these data types ...
- 01:28 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Some good news out of today's meeting with the customer: they have not taken advantage of the newer, 1972 byte index ...
- 01:11 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Yes, that is the idea. The computed column (the hashing result) would fit into SQL restriction and the @INCLUDE@ woul...
- 12:43 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- What do you think about using embedded @HashBytes()@ function like http://www.brentozar.com/archive/2013/05/indexing-...
- 11:08 AM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Eric Faulhaber wrote:
> Constantin, can you elaborate how this might work? How would we engage the external indexes ... - 09:57 AM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Constantin, can you elaborate how this might work? How would we engage the external indexes to perform a query, for i...
04/01/2014
- 04:27 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Eric, considering that we already have a locking mechanism above the physical DB layer and this requires that the DB ...
- 04:00 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Indeed, this is a non-trivial issue. Here are some of my thoughts:
+1st approach+ (user filtering of the input):
...
03/31/2014
- 05:21 PM Feature #2231: LockType error processing
- The update looks good. Please regression test.
- 12:06 PM Feature #2231: LockType error processing
- Attached update vmn_upd20140331a.zip.
Passed cases:...
03/30/2014
- 04:11 PM Feature #2276: create a work queue of PatternEngine instances for runtime conversion tasks
- Today, we instantiate multiple @PatternEngine@ instances to perform the various stages of runtime conversion tasks fo...
- 04:00 PM Feature #2276 (Closed): create a work queue of PatternEngine instances for runtime conversion tasks
- 04:06 PM Feature #2231: LockType error processing
- I have selected the second option suggested in note 1.
FIND- and GET- methods tested with wrong lock and nowait v... - 03:57 PM Feature #2275: cache of runtime-converted, dynamic queries and temp-tables
- As I'm writing this, it's becoming clear that the query cache and temp-table cache probably need to implemented toget...
- 03:43 PM Feature #2275 (Closed): cache of runtime-converted, dynamic queries and temp-tables
- 03:38 PM Feature #2274: improve performance of new database features
- In doing some basic profiling of the slow code, it is apparent the most egregious performance problems are with the a...
- 02:45 PM Feature #2274: improve performance of new database features
- Early testing of customer code which makes heavy use of some of the newly developed database features (particularly t...
- 02:34 PM Feature #2274 (Closed): improve performance of new database features
- 03:08 PM Feature #2134 (WIP): configurable denormalization of extent fields into individual fields in sche...
- In order to call this task complete, we need some documentation on how the new feature is used. Please add a history ...
- 02:56 PM Feature #2207 (WIP): Remaining issues for dynamic buffers and dynamic tables
- 02:52 PM Feature #2235 (Closed): fix deployment issues related to dynamic database conversion resources
- 07:23 AM Feature #2235 (Review): fix deployment issues related to dynamic database conversion resources
- svl_upd20140329a.zip was committed to bzr rev 10501.
03/29/2014
- 06:55 PM Feature #2235: fix deployment issues related to dynamic database conversion resources
- Just for the case I've changed file separator to \ and run my usual testcase - works OK, so most likely it really doe...
- 06:06 PM Feature #2235: fix deployment issues related to dynamic database conversion resources
- Stanislav Lomany wrote:
> About @p2j.cfg.xml.{platform_identifier}@: I'm just curious - at what point we are referen... - 06:00 PM Feature #2235: fix deployment issues related to dynamic database conversion resources
- Code review 20140329a:
Looks good and fixes the issue. Please run conversion regression only and commit if it passes. - 05:12 PM Feature #2235: fix deployment issues related to dynamic database conversion resources
- About @registry.xml@: @Configuration@ class keeps absolute paths to configuration files, so if we want to load additi...
- 04:09 PM Feature #2235 (WIP): fix deployment issues related to dynamic database conversion resources
- Fix for review for issue in note 28.
- 11:43 PM Feature #2235: fix deployment issues related to dynamic database conversion resources
- I tried to run with this update applied and I found a regression. In @DynamicQueryHelper.loadPermanentSchemas@, you r...
- 06:53 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Some more thoughts on the challenges of the computed columns approach...
* If done instead of the hard-coded length ... - 06:35 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Perhaps a more general-purpose approach is to use computed columns in indexes in the place of converted @character@ f...
- 04:57 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- One possible approach is to provide additional inputs into the conversion process to properly limit the maximum lengt...
- 04:55 PM Feature #2273: address remaining limitations of SQL Server needed to support legacy 4GL behavior
- Please review the entire history log of #2141. While in the end we were able to generate DDL for a SQL Server schema,...
- 04:03 PM Feature #2273 (Closed): address remaining limitations of SQL Server needed to support legacy 4GL ...
- 10:21 AM Feature #2134: configurable denormalization of extent fields into individual fields in schema con...
- Attached update is passed regression and distributed.
03/28/2014
- 07:24 PM Feature #2134: configurable denormalization of extent fields into individual fields in schema con...
- tc_job_002 is expected to fail in step 40. The other two failing tests each passed in one of your runs, so you can co...
- 06:29 PM Feature #2134: configurable denormalization of extent fields into individual fields in schema con...
- Next regression completed. Again 2 tests failed. Second test is another one but with the same error:...
- 06:32 AM Feature #2134: configurable denormalization of extent fields into individual fields in schema con...
- I have attached vmn_upd20140328a.zip after some fixes during regression. Latest regression results: 2 tests failed.
... - 04:12 PM Feature #2235: fix deployment issues related to dynamic database conversion resources
- One thing I just realized will be an issue: it is possible to run the static conversion of a project on one platform ...
- 09:27 AM Feature #2235: fix deployment issues related to dynamic database conversion resources
- Please don't remove archives unless they have been uploaded mistakenly (and have a proper replacement). For example,...
- 07:00 AM Feature #2235: fix deployment issues related to dynamic database conversion resources
- Committed to bzr rev 10498.
- 12:37 PM Feature #2143 (Closed): prototype IKVM solution for Java UDFs compiled to CIL assemblies and load...
03/27/2014
- 04:22 PM Bug #2222: WRITE event triggered too early
- It seems that I have implemented wrong the new write to database event.
My initial approach and the fix for it was a... - 03:42 AM Feature #2134: configurable denormalization of extent fields into individual fields in schema con...
- I have attached latest source code changes vmn_upd20140327a.zip after some fixes during regression. Regression starte...
Also available in: Atom