Activity

From 11/10/2020 to 12/09/2020

12/09/2020

06:39 PM Bug #5030 (WIP): xfer dataset test issues: I have another issue. In @dataset/dynamic/methods/copy_dataset.p@ we have:... Ovidiu Maxiniuc
06:09 PM Bug #5030: xfer dataset test issues: Marian Edu wrote:
> Well, nothing is perfect... in practice no one it doing that though so I wouldn't make it such a... Ovidiu Maxiniuc
03:48 AM Bug #5030: xfer dataset test issues: Ovidiu Maxiniuc wrote:
> Here is one example I used for observing the @REPOSITION@ attribute:
> [...]
>
> This w... Marian Edu
07:40 PM Bug #5030: xfer dataset test issues: Marian Edu wrote:
> The @AUTO-DELETE@ attribute only has a role when a dynamic dataset is deleted, nothing to do wit... Ovidiu Maxiniuc
07:37 PM Bug #5030: xfer dataset test issues: Here is one example I used for observing the @REPOSITION@ attribute:... Ovidiu Maxiniuc
03:24 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> What about the Java annotation in the DMO interface? My point is, I just want one name store... Igor Skornyakov
03:21 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > Please do make the change. Even if we don't simplify the logic m... Eric Faulhaber
03:05 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> Please do make the change. Even if we don't simplify the logic much, we want to keep the con... Igor Skornyakov
03:01 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> If I understand correctly, you need to map the DMOs (@DmoMeta@ most likely) using SQL names... Igor Skornyakov
02:59 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> At this moment I do not use the _least-common-denominator approach for the names_, but it c... Eric Faulhaber
02:56 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> I thought we use the _least-common-denominator approach for the names_ (see Eric's entry #1... Igor Skornyakov
02:41 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> Well, I think I've found a 'right' place to add information about word table names (there c... Ovidiu Maxiniuc
02:32 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> I see the following problem with this approach. I understand that @NameConverterWorker@ is ... Ovidiu Maxiniuc
02:20 PM Feature #1587: implement full support for word indexes: Well, I think I've found a 'right' place to add information about word table names (there can be different names for ... Igor Skornyakov
05:29 AM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> Yes, the information is mainly correct. I would look back one step, looking for the @name.c... Igor Skornyakov
04:15 AM Feature #3958: BUFFER-COPY optimization: Added a new signature for each @DmoMeta@ - see #4055-80, #4055-81. The first one I will refer to as "quick signature"... Adrian Lungu

12/08/2020

05:10 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> Yes, the information is mainly correct. I would look back one step, looking for the @name.c... Igor Skornyakov
05:01 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> Ovidiu: please reality check my statements and file references above, in case my recollectio... Ovidiu Maxiniuc
04:58 AM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> OK, I think this is the place the Java annotations are actually written into the Java AST wh... Igor Skornyakov
02:44 AM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > See the @createCompileUnit@ TRPL function in @rules/schema/dmo_c... Eric Faulhaber
02:35 AM Bug #5030: xfer dataset test issues: Ovidiu Maxiniuc wrote:
> A second issue is related to recently added @AUTO-DELETE@ attribute. I am see why is an aut... Marian Edu
02:17 AM Bug #5030: xfer dataset test issues: Ovidiu Maxiniuc wrote:
> A first question is about the dataset relations. Normally, there can be at most @n - 1@ ins... Marian Edu
07:42 PM Feature #4397: add database attrs, methods and options: I encountered two more issues which were probably added with 4011 and slipped unnoticed until now.
* the first is ... Ovidiu Maxiniuc

12/07/2020

05:21 PM Bug #5030: xfer dataset test issues: A second issue is related to recently added @AUTO-DELETE@ attribute. I am see why is an auto-delete dynamic buffer no... Ovidiu Maxiniuc
04:40 PM Bug #5030: xfer dataset test issues: A first question is about the dataset relations. Normally, there can be at most @n - 1@ instances of them, but if som... Ovidiu Maxiniuc
04:23 PM Bug #5030: xfer dataset test issues: I have started recently to run the testsets stored on xref repository in order to fine-tune the dataset-related attri... Ovidiu Maxiniuc
04:00 PM Bug #5030 (WIP): xfer dataset test issues: Ovidiu Maxiniuc
04:58 PM Bug #5013 (Test): Collision of java names with SQL keywords: Greg Shah
03:35 PM Bug #5013: Collision of java names with SQL keywords: This issue should be fixed in r11866/4397a (11/26/20). Ovidiu Maxiniuc
02:35 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> See the @createCompileUnit@ TRPL function in @rules/schema/dmo_common.rules@ for examples of... Igor Skornyakov
02:33 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> The problem is that at this moment I do not understand how to add annotation from the @DDLG... Eric Faulhaber
01:49 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> Ovidiu, please look at @dmo_common.rules@. Based on Igor's change, it looks like we were omi... Ovidiu Maxiniuc
02:42 AM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> For things like this, we usually compute the value at schema conversion time and write it as... Igor Skornyakov
11:36 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> I've re-worked the code to address Eric's comments (#1587-128).
> There is a problem with ... Eric Faulhaber

12/06/2020

03:38 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> I've re-worked the code to address Eric's comments (#1587-128).
Committed to 1587b revisio... Igor Skornyakov
03:37 PM Feature #1587: implement full support for word indexes: I've re-worked the code to address Eric's comments (#1587-128).
There is a problem with renaming word tables - we n... Igor Skornyakov
02:58 AM Feature #1587: implement full support for word indexes: Sorry, I forgot to add. At this moment for the dialects other than PostgreSQL the @CONTIANS@ UDF will be still used. Igor Skornyakov
02:51 AM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> * I am a bit confused by the @words@ UDF. It is added as a PL/Java function in @Functions@ a... Igor Skornyakov

12/05/2020

05:26 PM Feature #1587: implement full support for word indexes: Overall, 1587b seems to be nice addition to the project! This is not a full code review, but I do have a few concerns... Eric Faulhaber

12/04/2020

02:20 PM Feature #1665 (Closed): automate import process: This issue has been superseded by #4723. Eric Faulhaber
02:17 PM Feature #1664: data import improvements: Note that as of FWD trunk rev 11348, Hibernate is no longer used. As such, the Hibernate-specific issues noted above ... Eric Faulhaber
02:09 PM Feature #4722: data import should be able to run with only the converted application jar file (an...: IIRC, the @data/namespace@ dependency was just for access to the application's generated @*.p2o@ XML file, which alre... Eric Faulhaber

12/03/2020

04:29 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> Maybe it makes sense to add an import option to control when to create these indexes?
Why... Ovidiu Maxiniuc
04:20 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> True. Since this worked well with Hibernate I kept it with new proprietary solution. Also, ... Igor Skornyakov
03:59 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> The reason we create the primary keys and the foreign keys before import is primarily histor... Ovidiu Maxiniuc
03:49 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> Yes, and all unique indices as well. Non-unique indices are created after the import of a ta... Igor Skornyakov
03:46 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> BTW: If I understand correctly, we create primary keys and foreign key indexes (for extent ... Eric Faulhaber
03:14 PM Feature #1587: implement full support for word indexes: BTW: If I understand correctly, we create primary keys and foreign key indexes (for extent tables) before the import.... Igor Skornyakov
03:09 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> Other than working out the name length issue discussed in the previous posting, are there an... Igor Skornyakov
02:20 PM Feature #1587: implement full support for word indexes: Igor, I'm beginning to look over 1587b/11847.
Other than working out the name length issue discussed in the previo... Eric Faulhaber
08:14 AM Feature #1587: implement full support for word indexes: Greg Shah wrote:
> My point is that we should not require manual intervention in order to convert something that jus... Igor Skornyakov
08:05 AM Feature #1587: implement full support for word indexes: My point is that we should not require manual intervention in order to convert something that just happens to exceed ... Greg Shah
07:56 AM Feature #1587: implement full support for word indexes: Greg Shah wrote:
> > Please note that the generated objects' renaming via hints is not yet implemented. Working on i... Igor Skornyakov
07:50 AM Feature #1587: implement full support for word indexes: > Please note that the generated objects' renaming via hints is not yet implemented. Working on it now. We really nee... Greg Shah
07:36 AM Feature #1587: implement full support for word indexes: Finished generation of the database objects for the word indexes' support for the PostgreSQL dialect.
Committed to 1... Igor Skornyakov
03:03 PM Bug #4173: BUFFER-COPY/BUFFER-COMPARE compares table fields by name rather than data type and order: This seems related to your current work. It may make sense to implement any changes needed to resolve this task alon... Greg Shah
11:40 AM Feature #4055: optimize temp-table output parameter copying: I committed the changes proposed in #4055-82 regarding append mode support as 3821c/rev. 11851. These were build over... Adrian Lungu

11/30/2020

04:15 PM Feature #4397: add database attrs, methods and options: I encountered the following issue with conversion. It is not mandatory related to datasets but I encountered it while... Ovidiu Maxiniuc
08:03 AM Feature #1587: implement full support for word indexes: Here is another point to consider.
We must avoid adding extra files to the deployment requirements for the FWD ser... Greg Shah

11/27/2020

05:37 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> Are there real cases of the converted names exceeding the PostgreSQL-imposed limits, or do l... Igor Skornyakov
04:53 PM Feature #1587: implement full support for word indexes: Are there real cases of the converted names exceeding the PostgreSQL-imposed limits, or do limits also exist in the 4... Eric Faulhaber
03:47 PM Feature #1587: implement full support for word indexes: As we discussed before (#1587-65) we may have to use hints for the names of the database objects associated with word... Igor Skornyakov
03:10 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> I see another problem with this. Because of the *synchronized* block in the @Persistence.Co... Igor Skornyakov
11:32 AM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> Review of 1587b/r11844.
>
> General note: I like the amount of effort put in obtaining t... Igor Skornyakov
09:46 AM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> Review of 1587b/r11844.
>
> General note: I like the amount of effort put in obtaining t... Igor Skornyakov
09:40 AM Feature #1587: implement full support for word indexes: Review of 1587b/r11844.
General note: I like the amount of effort put in obtaining the conjunctive form of the fin... Ovidiu Maxiniuc
11:45 AM Feature #4055: optimize temp-table output parameter copying: I am planning to tackle the @append@ mode for @copy-temp-table@ with fast-copy. Right now, the fast-copy implementati... Adrian Lungu

11/26/2020

02:18 PM Feature #1587: implement full support for word indexes: Branch 1587b was rebased to 3821c revision 11839.
Committed revision 11844.
Igor Skornyakov
02:07 PM Feature #1587: implement full support for word indexes: I've implemented the fix that doesn't allow re-use of cached but re-written queries. This fixes the issue with the qu... Igor Skornyakov
01:25 PM Feature #1587: implement full support for word indexes: Well, the re-written query parameters are overridden in the @Persistence.getQuery()@. The query is retrieved from the... Igor Skornyakov
12:29 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> At first look the queries look OK to me, nice work!
>
> The queries will try to fetch ro... Igor Skornyakov
12:20 PM Feature #1587: implement full support for word indexes: At first look the queries look OK to me, nice work!
The queries will try to fetch rows incrementally, in increasin... Ovidiu Maxiniuc
10:08 AM Feature #1587: implement full support for word indexes: One more example.
Consider the 4GL program:... Igor Skornyakov
08:46 AM Feature #1587: implement full support for word indexes: In addition to the previous note. Without @CONTAINS@ re-writing the PostgreSQL log looks like the following:... Igor Skornyakov
08:17 AM Feature #1587: implement full support for word indexes: I've finished the @CONTAINS@ UDF call re-writing as per Ovidiu's advice.
Committed to 1587b revision 11835.
However... Igor Skornyakov
12:26 PM Feature #4055: optimize temp-table output parameter copying: I committed some changes for signature building and matching to 3821c/rev. 11839:
* *Enhanced unique constraints c... Adrian Lungu

11/25/2020

08:24 AM Feature #1587: implement full support for word indexes: Greg Shah wrote:
> I understand. But we are optimizing performance here and we will spend extra development time an... Igor Skornyakov
08:18 AM Feature #1587: implement full support for word indexes: I understand. But we are optimizing performance here and we will spend extra development time and make conversion le... Greg Shah
07:12 AM Feature #1587: implement full support for word indexes: Greg Shah wrote:
> > Well, since we decided do not to touch conversion at this moment
>
> I think you've already ... Igor Skornyakov
07:01 AM Feature #1587: implement full support for word indexes: > Well, since we decided do not to touch conversion at this moment
I think you've already resolved this. But I wa... Greg Shah
06:21 AM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> Igor,
> if you work at AST level, you do not need to parse the full SQL query as it is al... Igor Skornyakov
06:13 AM Feature #1587: implement full support for word indexes: Igor,
if you work at AST level, you do not need to parse the full SQL query as it is already represented as a tree.... Ovidiu Maxiniuc
02:20 AM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> The way @containsQuery@ extracts the @tblName@ does not seem sound to me. The @"__impl"@ mi... Igor Skornyakov
07:14 AM Feature #3958 (WIP): BUFFER-COPY optimization: Adrian Lungu
07:11 AM Feature #4055: optimize temp-table output parameter copying: I committed the current implementation of DMO signature to 3821c/rev. 11835, as I reached a stable implementation, wh... Adrian Lungu

11/24/2020

06:17 PM Feature #1587: implement full support for word indexes: The way @containsQuery@ extracts the @tblName@ does not seem sound to me. The @"__impl"@ might not be part of the @tb... Ovidiu Maxiniuc
05:54 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> Indeed, intercepting the @contains@ function with regular expressions is not the best solut... Igor Skornyakov
04:29 PM Feature #1587: implement full support for word indexes: Greg Shah wrote:
> I see. Yes, that is weird. Do you get the same result with @some_other_word_index_field contain... Igor Skornyakov
04:18 PM Feature #1587: implement full support for word indexes: I see. Yes, that is weird. Do you get the same result with @some_other_word_index_field contains if1@? In other wor... Greg Shah
04:00 PM Feature #1587: implement full support for word indexes: Greg Shah wrote:
> This is the documented limitation in the 4GL. @CONTAINS@ can only search word indexes. It canno... Igor Skornyakov
03:57 PM Feature #1587: implement full support for word indexes: > In addition, if I use a field name as the CONTAINS argument, 4GL reports a syntax error, although a little bit stra... Greg Shah
03:49 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> Probably this is possible but I do not think it is justified. If the function node is repla... Igor Skornyakov
03:22 PM Feature #1587: implement full support for word indexes: Igor, I did a quick review of 1587b/11834.
Igor Skornyakov wrote:
> Implemented SQL re-write for @CONTAINS@. Acco... Ovidiu Maxiniuc
02:11 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> It may also be helpful to review the specific diffs in:
>
> * rev 10173: this added the i... Igor Skornyakov
02:09 PM Feature #1587: implement full support for word indexes: It may also be helpful to review the specific diffs in:
* rev 10173: this added the initial conversion infrastruct... Eric Faulhaber
01:50 PM Feature #1587: implement full support for word indexes: Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > At this moment I do not understand the details of the @CONTA... Igor Skornyakov
01:39 PM Feature #1587: implement full support for word indexes: Igor Skornyakov wrote:
> At this moment I do not understand the details of the @CONTAINS@ operator conversion. Whe... Eric Faulhaber
10:27 AM Feature #1587: implement full support for word indexes: Implemented SQL re-write for @CONTAINS@. According to Ovidiu, this is done not in the right place, but it should work... Igor Skornyakov
05:39 AM Feature #4055: optimize temp-table output parameter copying: Eric Faulhaber wrote:
> Agreed. Note that for temp-tables, the MANDATORY attribute can be dropped from the signature... Adrian Lungu

11/23/2020

03:41 PM Feature #4055: optimize temp-table output parameter copying: Adrian Lungu wrote:
> These are the first steps in introducing the DMO structure signature according to #4011-774. I... Eric Faulhaber
01:19 PM Feature #4055: optimize temp-table output parameter copying: These are the first steps in introducing the DMO structure signature according to #4011-774. I posted a diff containi... Adrian Lungu
03:12 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> No, it is probably OK, too. My idea was keep FqlToSql converter cleaner (only to do convers... Igor Skornyakov
03:01 PM Feature #1587: implement full support for word indexes: No, it is probably OK, too. My idea was keep FqlToSql converter cleaner (only to do conversion, not enhancements of c... Ovidiu Maxiniuc
02:41 PM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> (continued, I pressed Submit instead of Preview)
> If this is done at this stage, you real... Igor Skornyakov
02:31 PM Feature #1587: implement full support for word indexes: (continued, I pressed Submit instead of Preview)
If this is done at this stage, you really do not care about the suf... Ovidiu Maxiniuc
02:25 PM Feature #1587: implement full support for word indexes: I think the best moment to intercept the @contain@ function and replace it with a subtree is in @HQLPreprocessor@. At... Ovidiu Maxiniuc
02:04 PM Feature #1587: implement full support for word indexes: From the mails:
Igor:
> BTW: what is the rule for generating the aliases? I would like to avoid parsing the FROM cl... Igor Skornyakov
10:51 AM Bug #5013 (WIP): Collision of java names with SQL keywords: I have fixed the issue by filtering through @NameConverter.resolvePossibleKeywordConflict()@ the result of @P2OAccess... Ovidiu Maxiniuc

11/22/2020

05:11 AM Feature #1587: implement full support for word indexes: Well, the last section of #1587-71 regarding SQL re-writing is wrong, It works only for some simple queries and does ... Igor Skornyakov

11/21/2020

03:19 PM Feature #1587: implement full support for word indexes: Bases on the Ovidiu's example (#1587-60) I've created a test with Postgres database.
* The 4GL table definition is:
... Igor Skornyakov
02:51 PM Feature #1587: implement full support for word indexes: Created @words@ Java UDFs for splitting a string into an array of (different) words. Committed to 1587b rev. 11833 Igor Skornyakov
09:49 AM Feature #4055: optimize temp-table output parameter copying: Eric Faulhaber wrote:
> Revision 10743 is quite old and I'm not sure to what that comment refers.
After #2134, th... Adrian Lungu

11/20/2020

05:22 PM Bug #5013: Collision of java names with SQL keywords: I encountered the following issue.
There is a (database) table named @order@. The conversion correctly identifies ... Ovidiu Maxiniuc
05:16 PM Bug #5013 (Test): Collision of java names with SQL keywords: Ovidiu Maxiniuc
03:59 PM Feature #4397: add database attrs, methods and options: Eric Faulhaber wrote:
> Ovidiu, based on the previous discussion in this task's history, my understanding is that th... Ovidiu Maxiniuc
12:23 PM Feature #4397: add database attrs, methods and options: Some more comments/questions on 4397a:
* Are there any performance implications to the @PropertyDefinition@ change... Eric Faulhaber
10:49 AM Feature #4397: add database attrs, methods and options: Ovidiu, based on the previous discussion in this task's history, my understanding is that the work is functionally co... Eric Faulhaber
01:51 PM Feature #1587: implement full support for word indexes: Committed changes from #1587-67 to 1587b rev.11832. Igor Skornyakov
12:59 PM Feature #1587: implement full support for word indexes: As per Eric's request created a task branch 1587b from 3821c rev. 11831. Igor Skornyakov
12:59 PM Feature #4055: optimize temp-table output parameter copying: Adrian Lungu wrote:
> Never mind, according to trunk/rev. 10743:
> [...]
> I guess this answers the questions arou... Eric Faulhaber
12:45 PM Feature #4055: optimize temp-table output parameter copying: Never mind, according to trunk/rev. 10743:... Adrian Lungu
12:38 PM Feature #4055: optimize temp-table output parameter copying: I might misunderstood. Only persistent tables can be de-normalized through schema hints individually. For temporary t... Adrian Lungu
12:28 PM Feature #4055: optimize temp-table output parameter copying: If I understand correctly, the de-normalization feature in #2134 adds the extent fields (eventually with custom names... Adrian Lungu
09:28 AM Feature #4055: optimize temp-table output parameter copying: Adrian, have you tested to ensure all of your recent changes around extent field copying work with both normalized (d... Eric Faulhaber
08:32 AM Feature #5003: Enhance performance of H2 sequences: The "method representation" has been introduced in 3821c/rev 11824 (@TemporaryBuffer@) and in 3821c/rev 11830 (@P2JH2... Adrian Lungu
08:25 AM Feature #4996: Integrate hash indexes in H2 temp-tables: I tried out changing tree indexed primary keys to hash indexed primary keys (recid). The modification doesn't change ... Adrian Lungu

11/18/2020

12:38 PM Feature #4055: optimize temp-table output parameter copying: Committed as 3821c/rev. 11824. the modifications partially described in #4055-64. This also contains the #5003-2 opti... Adrian Lungu

11/17/2020

06:39 AM Feature #5003: Enhance performance of H2 sequences: The @Sequence.DEFAULT_CACHE_SIZE@ optimization was committed in fwd-h2/rev. 4. On a singular testcase (one million @n... Adrian Lungu
04:25 AM Feature #4055: optimize temp-table output parameter copying: Eric Faulhaber wrote:
> I do think we should be consistent with H2's conventions, however, in case we decide to ask ... Adrian Lungu

11/16/2020

05:20 PM Feature #4055: optimize temp-table output parameter copying: Greg Shah wrote:
> Is this safe to push to our testing environments?
I have not done exhaustive testing, but I ha... Eric Faulhaber
05:18 PM Feature #4055: optimize temp-table output parameter copying: Code review @fwd-h2@ revions 4 & 5:
The changes seem functionally ok to me, though admittedly, I am less familiar ... Eric Faulhaber
05:50 AM Feature #4055: optimize temp-table output parameter copying: Is this safe to push to our testing environments? Greg Shah
03:13 AM Feature #4055: optimize temp-table output parameter copying: I was trying to optimize a basic temp-table copy testcase (simple copy with @INSERT INTO SELECT FROM@). I detected a ... Adrian Lungu
05:33 AM Feature #1587: implement full support for word indexes: Implemented conversion of the logical expression accepted by CONTAINS operator to the @Reverse Polish Notation@ (RPN)... Igor Skornyakov

11/14/2020

06:19 AM Feature #3574 (Review): finish implementation of temp-table XML support: From Ovidiu:
> I am now committing a stable revision (r11811) with all issues in #3574 fixed. Of course there migh... Greg Shah

11/13/2020

04:01 AM Feature #4996: Integrate hash indexes in H2 temp-tables: Not really. H2 prefers a more "general use" index for the primary key - a tree index. This is because it prefers fast... Adrian Lungu

11/12/2020

02:51 PM Feature #4996: Integrate hash indexes in H2 temp-tables: Adrian Lungu wrote:
> As Ovidiu mentioned, for now hash indexes can help in "find-by-rowid" queries, as we can add... Eric Faulhaber
02:24 PM Feature #4996: Integrate hash indexes in H2 temp-tables: Could a view be useful here? I know much depends on how the H2 implements views and how the query optimizer handles ... Greg Shah
12:42 PM Feature #4996: Integrate hash indexes in H2 temp-tables: Adrian Lungu wrote in #4996-1:
> * The hash index works with only one field according to the @NonUniqueHashIndex@ im... Ovidiu Maxiniuc
04:24 AM Feature #4996: Integrate hash indexes in H2 temp-tables: #4996-4 is quite on spot. I may add that H2 allows hash indexes for fields which are not unique, but the queried reco... Adrian Lungu
09:05 PM Feature #4996: Integrate hash indexes in H2 temp-tables: IMHO, we can not benefit much from the hash indexes. The way I understand the H2 documentation (@H2 Performance@ / @I... Ovidiu Maxiniuc

11/11/2020

05:19 PM Feature #4996: Integrate hash indexes in H2 temp-tables: Sorry, I re-read your post and it seems I had misread your conclusion on my first pass. Nevertheless, I expect we wou... Eric Faulhaber
03:01 PM Feature #4996: Integrate hash indexes in H2 temp-tables: Adrian Lungu wrote:
> In H2, if the where clause contains a @_multiplex@ equality, than this index with have a ver... Eric Faulhaber

11/10/2020

07:10 AM Feature #5003: Enhance performance of H2 sequences: There is a @Sequence.DEFAULT_CACHE_SIZE@ which defaults on 32. This refers to how often the sequence is flushed (and ... Adrian Lungu
07:08 AM Feature #5003 (WIP): Enhance performance of H2 sequences: Adrian Lungu
06:49 AM Feature #3574 (WIP): finish implementation of temp-table XML support: From Ovidiu:
> Here are the remaining known issues:
>
> * At this moment I am trying to find a solution for the ... Greg Shah
06:47 AM Feature #4397 (Test): add database attrs, methods and options: Greg Shah
02:48 AM Feature #1587: implement full support for word indexes: Ovidiu Maxiniuc wrote:
> I did a quick research and it looks like the H2 does not have any limitations related to ma... Igor Skornyakov

« Previous

Also available in: Atom

Project

General

Profile

FWD » Core Development » Database

Activity

Activity

12/09/2020

12/08/2020

12/07/2020

12/06/2020

12/05/2020

12/04/2020

12/03/2020

11/30/2020

11/27/2020

11/26/2020

11/25/2020

11/24/2020

11/23/2020

11/22/2020

11/21/2020

11/20/2020

11/18/2020

11/17/2020

11/16/2020

11/14/2020

11/13/2020

11/12/2020

11/11/2020

11/10/2020