Differences

This shows you the differences between two versions of the page.

--- appendix:releasenotes [2011/04/22 16:40]
admin
+++ appendix:releasenotes [2012/10/26 14:46] (current)
@@ Line 8: / Line 8: @@
 For a list of fixes and enhancements for Omnidex 4.x series, click [[appendix:patches:v4x |here.]]
+===== 5.01.01L August 2011 =====
+  * Fixed a indexing issue on Quicktext (Keyworded) columns which occurred only when two parsed columns were grouped together, and the second column was empty.  This causes indexing problems and any customer using grouping should upgrade to 5.01.01L.
+===== 5.01.01K April 2011 =====
+  * Added a STRICT/RELAXED mode to the OdxJDBC Driver to allow connections to change from a read/write state to a read only state to work with certain tools such as JasperSoft.
 ===== 5.01.01J January 2011 =====
@@ Line 19: / Line 25: @@
 ===== 5.01.01H October 2010 =====
   * Internal licensing change for flat file licensing.
-  * Fixed an issue with the internal dbigetkeys optimizer and the indexing kernal.
+  * Fixed an issue with the internal dbigetkeys optimizer and the indexing kernel.
 ===== 5.01.01G September 2010 =====
@@ Line 43: / Line 49: @@
   * Fixes to OdxNet for multi-threaded concurrency.
   * Enhanced Explain Plans to show Grid information.
+  * Added Error number 89067 to the Omnidex Message file dealing with the indexing kernel licensing.
-===== 5.01.01D March 2010 =====
+The following is an example of the enhanced Explain Plans on a Grid.
+<code>
+----------------------------------- SUMMARY -----------------------------------
+Select        STATE,
+              count(*)
+  from        PROSPECTS
+  group by    STATE
+  with        opt=no_rollup;
+Version:      5.1 Build 1E  (Compiled Jul  2 2010  10:50:49)
+Optimization: GRID
+Warnings:     GRID_AGGREGATION
+------------------------------- GRID PERFORMANCE ------------------------------
+                                                   Elapsed seconds
+.0        1.6         3.1       4.7           6.2
+[localhost]
+ Controller               ---------------                                  +
+ NODE01                                 .................===>>
+ NODE02                                 .................===>>
+ NODE03                                                      ............==>
+Elapsed Time              Connect  Select  Fetch (Count)   Transfer  Total
+NODE01                    2.12     0.40    0.04 (1)           -      2.57
+NODE02                    2.14     0.39    0.03 (2)           -      2.56
+NODE03                    1.50     0.25    0.03 (6)           -      1.78
+Controller                                                           6.23
+---------------------------------- GRID NODES ---------------------------------
+  ---------------------------------- NODE01 ---------------------------------
+  Start/Stop:   13:41:38.223 to 13:41:38.629
+  Elapsed:      0.406
+  Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD, ASKQUAL, ASKORDERBY,
+                AGGREGATION, ASKLINK, ASKRETRIEVAL, STARSCHEMA, CACHED_VIEW,
+                MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL
+  Optimization: AGGREGATION
+  Details:
+  Aggregate PROSPECTS using STATE for GROUP(STATE), COUNT(*) on 1;
+  Return PROSPECTS.STATE, COUNT('*');
+  ---------------------------------- NODE02 ---------------------------------
+  Start/Stop:   13:41:38.238 to 13:41:38.629
+  Elapsed:      0.390
+  Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD, ASKQUAL, ASKORDERBY,
+                AGGREGATION, ASKLINK, ASKRETRIEVAL, STARSCHEMA, CACHED_VIEW,
+                MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL
+  Optimization: AGGREGATION
+  Details:
+  Aggregate PROSPECTS using STATE for GROUP(STATE), COUNT(*) on 1;
+  Return PROSPECTS.STATE, COUNT('*');
+  ---------------------------------- NODE03 ---------------------------------
+  Start/Stop:   13:41:40.160 to 13:41:40.410
+  Elapsed:      0.250
+  Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD, ASKQUAL, ASKORDERBY,
+                AGGREGATION, ASKLINK, ASKRETRIEVAL, STARSCHEMA, CACHED_VIEW,
+                MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL
+  Optimization: AGGREGATION
+  Details:
+  Aggregate PROSPECTS using STATE for GROUP(STATE), COUNT(*) on 1;
+  Return PROSPECTS.STATE, COUNT('*');
+------------------------------- GRID CONTROLLER -------------------------------
+Select        STATE,
+              cast(sum(NEWCOL1) as unsigned integer)
+  from        NODE_RESULTS
+  group by    STATE
+  with        OPTIMIZATION=no_rollup;
+Request Opt:  PRIKEY, MDKQUAL, NO_DISTINCT_KEYWD, ASKQUAL, ASKORDERBY,
+              AGGREGATION, ASKLINK, ASKRETRIEVAL, STARSCHEMA, CACHED_VIEW,
+              MDKLINK, HDC, REUSEQUAL, NO_ROLLUP, NO_UNRESTRICTEDQUAL
+Optimization: NONE
+Warnings:     UNOPTIMIZED_AGGREGATION, UNOPTIMIZED_SORT, SEQUENTIAL_SCAN
+Notes:        Optimized aggregations are not possible because no ASK index
+                contains all columns
+Details:
+Retrieve NODE_RESULTS sequentially;
+Pass to queue {1} [NODE_RESULTS.STATE, NODE_RESULTS.NEWCOL1];
+Sort {1} for GROUP BY [NODE_RESULTS.STATE ASC];
+Retrieve {1} sequentially;
+Return NODE_RESULTS.STATE, CAST(SUM(NODE_RESULTS.NEWCOL1) AS UNSIGNED
+   INTEGER);
+-------------------------------------------------------------------------------
+>
+</code>
+===== 5.01.01D July 2010 =====
   * Added Machine (System and User) Data Source creation and editing to the Omnidex ODBC Driver under Windows. You create/modify/delete System/User/File DSN using the standard “ODBC Data Source Administrator” program. Access this interface from Control Panel/Administrative Tools/Data Sources (ODBC).
   * Under Linux, you need to use odbcinst program if you use UnixODBC. Otherwise, you need to manually modify ODBC.INI file.
-===== 5.01.01C =====
+===== 5.01.01C June 2010 =====
   * Added a WITH LOG=<log directory> to log indexing information during the UPDATE INDEXES process.  Also added a dbinstal.log that shows the dbinstal execution for this UPDATE INDEXES.
-===== 5.01.01B =====
+===== 5.01.01B June 2010 =====
-===== 5.01.01A =====
+  * Minor bug fixes.
+===== 5.01.01A May 2010 =====
+  * Initial 5.01.01A release.
 ==== DDL Support ====

Back to top

appendix/releasenotes.1303490423.txt.gz · Last modified: 2012/10/26 14:40 (external edit)

Sitemap Recent Changes