Activity
From 01/28/2021 to 02/26/2021
02/26/2021
- 05:42 PM Bug #4994 (WIP): NPE in AdaptiveQuery when loading null data for an outer join
- In case of OUTER JOIN tables when there is no matching record, @data[i]@ is @null@. Rewriting the problematic line as...
- 02:47 PM Support #4550: eliminate the need to place the p2jspi.jar in the JVM extension directory
- It is good to know that the bug is just a configuration issue. At a minimum we need to improve our documentation. F...
- 02:28 PM Support #4550: eliminate the need to place the p2jspi.jar in the JVM extension directory
- Greg Shah wrote:
> If I understand correctly, the @p2jspi.jar @ is hard coded to the equivalent of the 4GL 8859-1.
... - 07:53 AM Support #4550: eliminate the need to place the p2jspi.jar in the JVM extension directory
- We also need to consider that the effective codepage for H2 temp-tables must be something that can be overridden. In...
- 07:49 AM Feature #4722: data import should be able to run with only the converted application jar file (an...
- > Both of these dependencies could be specified as parameters to a new command line program
I don't understand why... - 02:11 AM Bug #5056: Temp-tables and unique indexes
- Can this issue be closed?
02/25/2021
- 03:07 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> A separate thought: what if we remove the @distinct@ keyword? Unless I'm reading the plan wr... - 03:03 PM Feature #1587: implement full support for word indexes
- I'm trying to figure out whether there is a way to express these search conditions without the hash joins (and someti...
- 02:45 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Thank you.
>
> Are these two statements functionally equivalent?
>
> 1)
>
> [...]
... - 02:37 PM Feature #1587: implement full support for word indexes
- As I re-read that last post, I'm not sure my where clause makes sense in that second query...rethinking...
- 02:35 PM Feature #1587: implement full support for word indexes
- Thank you.
Are these two statements functionally equivalent?
1)... - 02:06 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> What is the SQL for the expression @"s0 | s1"@?
>
> For @"(s0 | s1) & s5*"@?
>
> (LE: ... - 01:59 PM Feature #1587: implement full support for word indexes
- What is the SQL for the expression @"s0 | s1"@?
For @"(s0 | s1) & s5*"@?
(LE: fixed syntax error in original post) - 01:53 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Igor, can't the first form of the SQL be simplified as follows?
> In other words, why is th... - 01:39 PM Feature #1587: implement full support for word indexes
- Igor, can't the first form of the SQL be simplified as follows?
From:... - 11:02 AM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Yes, I was looking at the sort part of the plan, but you are right that the parts below do l... - 11:01 AM Feature #1587: implement full support for word indexes
- Yes, I was looking at the sort part of the plan, but you are right that the parts below do look somewhat faster. Plea...
- 10:54 AM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > At this moment I'm looking how to change SQL re-writing usin... - 10:43 AM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> At this moment I'm looking how to change SQL re-writing using @WITH@ clause (see #1587-36... - 10:30 AM Feature #1587: implement full support for word indexes
- I've added two things to the word tables support.
# The re-writing of the SQL queries with @CONTAINS@ re-writing can... - 04:27 AM Feature #1587: implement full support for word indexes
- With a logically equivalent but different re-written SQL statement using @WITH@ clause:...
- 03:46 AM Feature #1587: implement full support for word indexes
- Adding index on the 'word' field in the word tables helps. The times are (see #1587-357)
|expr |records|e... - 03:09 AM Feature #1587: implement full support for word indexes
- Word tables' tests to @sftp://xfer.goldencode.com/opt/testcases/@ revision 1008.
Tests (including Java project for g... - 02:07 AM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Igor, is this test code (including the code which generates the test data) checked in?
No... - 02:04 AM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Igor, while the improvement over the UDF approach is considerable in some cases, the new app... - 01:21 PM Bug #5056 (Test): Temp-tables and unique indexes
- Patch committed as 3821c/12065.
- 09:25 PM Bug #5056: Temp-tables and unique indexes
- Eric Faulhaber wrote:
> Ovidiu, please test whether the attached patch resolves your original issue(s). It gets both... - 09:42 AM Feature #5165: disallow usage of an incompatible database instance
- We can also validate the schema specified at the permament DMOs with the database tables/indexes.
- 05:48 AM Feature #5165: disallow usage of an incompatible database instance
- In OE, the database metaschema has CRC values stored for each table, index and schema trigger. When compiling 4GL to...
- 05:08 AM Feature #5165 (New): disallow usage of an incompatible database instance
02/24/2021
- 06:35 PM Feature #1587: implement full support for word indexes
- Igor, is this test code (including the code which generates the test data) checked in?
- 05:22 PM Feature #1587: implement full support for word indexes
- Igor, while the improvement over the UDF approach is considerable in some cases, the new approach is still not as per...
- 02:33 PM Feature #1587: implement full support for word indexes
- For the performance testing, I've used a modified approach described at #1587-340. Instead of generated "word" as all...
02/23/2021
- 06:34 PM Bug #5056: Temp-tables and unique indexes
- Similar to the patch proposed in #4884-15, I have fixed the cases identified above. The three main xfer testcases are...
- 07:43 PM Bug #5056: Temp-tables and unique indexes
- I found the cause for the 'regression' of your patch. It is probably not a single thing, but a couple of issues which...
02/20/2021
- 11:26 AM Feature #1587: implement full support for word indexes
- Finished with word tables support for denormalized extent fields. Tested with a large customer app. and with test app...
- 07:46 PM Bug #5056: Temp-tables and unique indexes
- I used your patch to run the xfer tests and things have changed. It is not perfect, but I cannot tell exactly why.
...
02/19/2021
- 11:31 AM Feature #1587: implement full support for word indexes
- Added word tables' support for custom extents (conversion and database import).
Committed to 3821c/12031 - 10:48 AM Feature #4397 (Closed): add database attrs, methods and options
- Ovidiu has recently confirmed that testing passed for the features in this task.
02/18/2021
- 06:27 PM Bug #5056: Temp-tables and unique indexes
- Eric,
I looked deeper into the server's log (there are a lot of @java.lang.IllegalStateException: Empty scopes in Un... - 06:19 PM Bug #5056: Temp-tables and unique indexes
- Eric,
I am sorry to inform you that the patch is not making the testsets behave better. In fact, the test stops much... - 05:10 PM Bug #5056: Temp-tables and unique indexes
- Ovidiu, please test whether the attached patch resolves your original issue(s). It gets both of the test cases you pr...
- 05:00 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Please don't. If we were starting from scratch, we could consider it, but the changes you sh... - 04:44 PM Feature #1587: implement full support for word indexes
- Please don't. If we were starting from scratch, we could consider it, but the changes you should be making to DDL gen...
- 04:15 PM Feature #1587: implement full support for word indexes
- As I can see at this moment FWD has a dependency on Apache Velocity. Can I use it for DDL generation? This will make ...
- 03:44 PM Feature #1587: implement full support for word indexes
- I've resolved the issues described in #1587-349, implemented the generation of the word tables with indices/constrain...
- 03:13 PM Feature #4022: upgrade to a newer PostgreSQL release
- > * Did the package come out of the standard Ubuntu repos? Or did you have to add a PPA to the system?
Ubuntu.
... - 01:55 PM Feature #4022: upgrade to a newer PostgreSQL release
- >> Were you able to leverage the pre-built PL/Java binaries?
>
> I installed PL/Java package using apt, along with ...
02/17/2021
- 04:02 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Igor Skornyakov wrote:
> > I've noticed two things regarding custom extends.
> > # If the ... - 03:58 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> I've noticed two things regarding custom extends.
> # If the number of the @<extent-field@... - 02:57 PM Feature #1587: implement full support for word indexes
- I've noticed two things regarding custom extends.
# If the number of the @<extent-field@ subnodes on the .hints file...
02/16/2021
- 01:57 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> No problem. The annotation for the @wiext@ index looks correct to me as is.
Well, formally ... - 01:50 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> I'm talking about @name = "fextFirst", legacy = "f-ext"@. The word table name was also ba... - 01:21 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> I'm having trouble understanding the question. Please provide an example.
I mean the follow... - 01:10 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> I've noticed that for word index with customized extent fields the value of the @name@ attr... - 01:05 PM Feature #1587: implement full support for word indexes
- I've noticed that for word index with customized extent fields the value of the @name@ attribute of the @IndexCompone...
02/12/2021
- 01:11 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> There are two aspects of performance we need to understand and measure from this testing:
>... - 12:44 PM Feature #1587: implement full support for word indexes
- There are two aspects of performance we need to understand and measure from this testing:
* read (upon which the c... - 11:01 AM Feature #1587: implement full support for word indexes
- Here is the suggested structure of the test table for performance testing of the new @CONTAINS@ support:
The test ta...
02/10/2021
- 03:28 AM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> I understand we need to correct the sort behavior for queries which use word indices, but I ... - 01:39 AM Feature #1587: implement full support for word indexes
- Ovidiu Maxiniuc wrote:
> Igor Skornyakov wrote:
> > I have problems with removing @CONTAINS@ field from the @genera...
02/09/2021
- 03:27 PM Feature #1587: implement full support for word indexes
- Suppressed using word index field for sorting.
Committed to 3821c revision 12004. - 01:29 PM Feature #1587: implement full support for word indexes
- Ovidiu Maxiniuc wrote:
> The @sort@ parameter is computed in @annotations/index_selection.rules@. Look for the @orde... - 01:18 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> I have problems with removing @CONTAINS@ field from the @generated@ 'sort' parameter of the...
02/08/2021
- 04:51 PM Feature #1587: implement full support for word indexes
- Added runtime uppercasing of the CONTAINS UDF arguments (for temp-tables).
Committed to 3821c/11999. - 03:06 PM Feature #1587: implement full support for word indexes
- I have problems with removing @CONTAINS@ field from the @generated@ 'sort' parameter of the @AdaptiveQuery.initialize...
- 03:00 PM Feature #1587: implement full support for word indexes
- Uppercasing the @CONTAINS@ arguments at conversion time removed in #3821/11998.
- 09:26 AM Feature #1587: implement full support for word indexes
- Added a subtask to #1587-327 which I've forgot to mention (Implement CONTAINS support for denormalized extent fields).
- 04:28 PM Feature #5130: improve management of p2jpl.jar in deployment scripts
- Eric Faulhaber wrote:
> Why do we use the most current @p2jpl.jar@ version from @${deploy.home.abs}/lib/@ only in th... - 03:49 PM Feature #5130: improve management of p2jpl.jar in deployment scripts
- Does anyone know why we have this in the "template" @build_db.xml@ (not really a template, but it tends to get copied...
02/05/2021
- 12:06 PM Feature #1587: implement full support for word indexes
- This isn't about the word tables. I have to determine whether a word index comes into play with DMO validation and fl...
- 12:00 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> One additional item, which I'll take as my responsibility, is to test how a word index plays... - 11:30 AM Feature #1587: implement full support for word indexes
- One additional item, which I'll take as my responsibility, is to test how a word index plays into validation/flushing...
- 03:32 AM Feature #1587: implement full support for word indexes
- Remaining work for the word indices support:
# Fix regressions introduced by word tables' support (if found).
# Rem...
02/04/2021
- 04:09 PM Feature #1587: implement full support for word indexes
- Word tables' scripts are idempotent now (can be run multiple times). This allows applying changes in constraints/indi...
- 01:14 PM Feature #1587: implement full support for word indexes
- 'Word indices are not supported' warning is suppressed in 3821c/11990
- 03:19 PM Feature #5130: improve management of p2jpl.jar in deployment scripts
- Greg Shah wrote:
> Add a version UDF that is customized at build time similar to how we version FWD.
This alrea... - 01:09 PM Feature #5130: improve management of p2jpl.jar in deployment scripts
- Clever!
- 01:05 PM Feature #5130: improve management of p2jpl.jar in deployment scripts
- I use the following "quick and dirty" approach based on @direnv@ utility in the situations when additional steps are ...
- 12:51 PM Feature #5130: improve management of p2jpl.jar in deployment scripts
- Our current devops scripting is implemented outside of FWD. We use Apache @ant@ to script a range of conversion proj...
- 12:40 PM Feature #5130 (Rejected): improve management of p2jpl.jar in deployment scripts
02/02/2021
- 06:59 AM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> I've just realized that the trick with uppercasing at the database side required additional...
02/01/2021
- 03:32 PM Feature #1587: implement full support for word indexes
- I've just realized that the trick with uppercasing at the database side required additional precautions. The PK/uniqu...
- 09:22 AM Feature #4307 (Closed): DMO conversion changes
- Branch 4011e was merged to trunk rev 11348.
- 09:21 AM Feature #4020 (Rejected): reduce work Hibernate does flushing session
- This task is moot with the removal of Hibernate in trunk rev 11348.
- 09:18 AM Feature #4016 (Closed): replace portions of Hibernate which are non-performant
- Hibernate was removed as of trunk rev 11348.
01/29/2021
- 04:47 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> You are referring to the "search-expression" portion of the CONTAINS operation, correct? Are... - 04:41 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> The only thing from the planned ones, for now, is removing the @CONTAINS@ operator expres... - 04:05 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > Can I continue using 1587b or should create a new branch fro... - 04:02 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> Can I continue using 1587b or should create a new branch from 3821c?
You should not us... - 03:41 PM Feature #1587: implement full support for word indexes
- Branch 1587b was merged into 3821c revision 11969.
Can I continue using 1587b or should create a new branch from 3... - 03:31 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Have you tested the import with the customer application which previously was failing with t... - 03:31 PM Feature #1587: implement full support for word indexes
- Branch 1587b was rebased to 3821c rev. 11968
Pushed up to revision 11993.
The only thing from the planned ones... - 03:03 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> 1. Removed warning 1688 at runtime
> 2. Added support for word index on extent field (Post... - 02:54 PM Feature #1587: implement full support for word indexes
- 1. Removed warning 1688 at runtime
2. Added support for word index on extent field (PostgreSQL and H2, permanent tab... - 08:52 AM Bug #5121: Converted temp table should be using the legacy name instead of the converted name in ...
- Saw this message logged: @Unable to locate shared temp-table or work-table definition for table <converted tablename>...
- 08:51 AM Bug #5121 (New): Converted temp table should be using the legacy name instead of the converted na...
- 07:02 AM Feature #3958 (Review): BUFFER-COPY optimization
- Added the @setActiveBuffer@ and @resetActiveBuffer@ with 3821c/rev. 11966. Beside those changes, I added @BaseRecord....
- 07:41 PM Feature #4397: add database attrs, methods and options
- Eric Faulhaber wrote:
> Code review 4397a/11958:
> @RecordBuffer.setCurrentRecord@ being non-private is still a pro... - 07:11 PM Feature #4397: add database attrs, methods and options
- Code review 4397a/11991:
Continuing the discussion from #5056-14, I'm still convinced the @BufferImpl.validate()@ ... - 07:12 PM Feature #3574: finish implementation of temp-table XML support
- Ovidiu Maxiniuc wrote:
> I re-did the rebase and re-commit earlier so you might want to review these changes too).
...
01/28/2021
- 05:11 PM Feature #3574: finish implementation of temp-table XML support
- That is exactly what I feel in regard to @TableMapper@, too. It only have the advantage of being decoupled, but acces...
- 04:34 PM Feature #3574: finish implementation of temp-table XML support
- I really don't like the @TableMapper@ construct at all. I tried to rationalize its internals at one point long ago, w...
- 04:24 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Is the import change (to uppercase in the database) safe across all dialects we currently su... - 04:18 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> This will require a simple change in the import. But, to make the word table work correct... - 04:11 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > Well, if changes in the conversion are allowed I can impleme... - 04:03 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> Well, if changes in the conversion are allowed I can implement a workaround for import by... - 03:56 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > I understand your point. However, the initial idea was not t... - 03:34 PM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> I understand your point. However, the initial idea was not to change the conversion at al... - 02:03 PM Feature #1587: implement full support for word indexes
- Eric Faulhaber wrote:
> We should not be adjusting for conversion errors at runtime. If something is incorrectly add... - 01:57 PM Feature #1587: implement full support for word indexes
- We should not be adjusting for conversion errors at runtime. If something is incorrectly added by conversion, we shou...
- 01:25 PM Feature #1587: implement full support for word indexes
- I understand that the incorrect @ORDER BY@ component is added at the @PreselectQuery.assembleHQL()@ method. The @Sort...
- 10:00 AM Feature #1587: implement full support for word indexes
- Igor Skornyakov wrote:
> There are two things that can cause a problem:
> # temp-tables with word index for an exte... - 09:35 AM Feature #1587: implement full support for word indexes
- Greg Shah wrote:
> > uppercasing with LATIN1 database (#5082). This is a real problem with at least one large custom... - 09:24 AM Feature #1587: implement full support for word indexes
- > uppercasing with LATIN1 database (#5082). This is a real problem with at least one large customer app.
Does 1587... - 09:10 AM Feature #1587: implement full support for word indexes
- Greg Shah wrote:
> Is 1587b safe for merge into 3821c? Does it work properly for the large customer application whi... - 09:01 AM Feature #1587: implement full support for word indexes
- Is 1587b safe for merge into 3821c? Does it work properly for the large customer application which you tested? We a...
- 01:39 PM Feature #4397: add database attrs, methods and options
- Code review 4397a/11958:
@RecordBuffer.setCurrentRecord@ being non-private is still a problem. See comments in #43...
Also available in: Atom