Forum

Kognitio Console issues, advice, etc.
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

What features are new in Kognitio Console?

by MikeAtkinson » Wed Jun 05, 2013 9:02 am

What features have been added in Kognitio Console versions?

What bugs have been fixed?
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 70902s130116

by MikeAtkinson » Wed Jun 05, 2013 9:13 am

New Feaures
    1. Improved speed of opening metadata tree columns when a table/view has lots of columns.
    2. Add a version of the “report locks” macro reportlock2.xml, which shows Queued Time and Grant Time. This is only available on v8 preview releases.
    3. Added a “Privileges” tab to the Connector, Plugin, Queue, Schema, User, Group and Script Environments object views. This shows what privileges are granted for the object.
    4. Added a “User Privileges” tab to the User Object View, this shows all the privileges (including inherited) that a user has.
    5. Changed the SQL which is given for Ctrl-F5 so that it works for non-privileged users on v8 preview releases.
    6. The default config options have been changed so that “update metadata periodically” is no longer ticked and “Save window state” is now ticked.
    7. The Sessions Object View has been improved to show “Duration” and “Work RAM” for the sessions.
    8. For scripts show the rows buffered and whether the buffer limit was reached on the “results” tab.
    9. Add an action to the script queries in the history pane to turn the query into an ad-hoc query.
    10. Add Load tool which runs the Loader. This should be faster for loading in csv files from windows than the old Import tool.
    11. Add disk status and deskew/replacker/ACI status to the Dashboard.
    12. Add Clone User Dialog. This is like a mixture of clone group and new user in that it creates a new user with password, schema and security class, but it also adds it to the cloned user’s group and copies all its privileges as well.
    13. Add Unload tool which runs the Unloader.
    14. Upgraded Clone Group to clone privileges for features added for v8 (connectors, script environment, external scripts).
    15. Show query execution status in Info tab as a query is run by reading ipe_mysessions, ipe_locks, etc. every 10 seconds. This enables the user to see that long running queries are blocked.
    16. Added std Lua library. 6 modules added:
      • std.base - useful functions
      • std.class - object orientated classes
      • std.list - cons type lists
      • std.strbuf - string buffer, for performance
      • std.string - useful string functions
      • std.table - useful table functions and the Table class
    17. Detect when a legacy ODBC driver is being used with a modern database by the “ Invalid Handle” error message and give an informative message to the user.
    18. Use new Slab Overview (ctrl-F4) and “Disk Use by table for current schema” (ctrl-F5) if connected to a version 7.2.1 WX2 and the default definitions have not been changed.
    19. Added MacroLineEdit which allows editing text within a macro.
    20. Added <metadata> element to macros. This uses XPath to obtain a DataItem which may then be used to set the data of a widget. For example a combo box of all system tables:
      <widget id="combo" type="combobox"><metadata path="/system/schemas/*/*[starts-with(@name, 'IPE')]"/></widget>
    21. In macros allow all widgets to get their data from DataItems.
    22. Added new report Transactions Between Two Dates macro.
    23. Altered macros to display Kognitio logo, which helps distinguish the macros we supply to any user created macros (which may have the same name and overwrite Kognitio macros).
    24. When a macro is made dockable and the dockable pane is closed the macro is not stopped and may be viewed again. Add a config option to stop and destroy the macro.
    25. All Macro widgets may now have menu items.
    26. SQL scripts run from macros now show their statements and indicate when failed.
    27. Macro labels may now take the full range of common elements as child elements.
    28. Legacy ODBC drivers are no longer included, they are no longer relevant to our customers and have caused confusion on occasion.
    29. Added <timenow>, <datenow> and <currentuser> macro elements to add those values to the evaluated text for macro elements.
    30. Macros may now specify which tables/view they require (<requiredtableaccess table=”…”/>), if those tables are not visible to a user then the macro is not enabled.
      Note
      Some Macro elements and attributes have had name changes which makes previous macros incompatible. All installed macros are updated, but user created macros may need to be changed.
Bug Fixes
    1. Locks report incorrectly shows “awaiting compiler”
    2. In the User Object View not all inherited privileges were being shown.
    3. If “On Server Error” is set to “stop” and an error is encountered then running the kog script again causes a crash.
    4. In the Connector Object View the source combo box lies about what sources are available.
    5. Saving a script moves the current line marker (yellow arrow).
    6. Various obscure crashes have been fixed.
    7. Break out of an infinite loop trying to redisplay a table that cannot be displayed.
    8. In the problem query analyser “ipe_query_queues” needs to be qualified with “sys” so that it works for non-sys users.
    9. Fix Kog script $var’ – the ‘ was not being recognised as terminating the variable.
    10. Fix require for a Kog script so that it is parsed with Kognitio Extensions (e.g. naked SQL) turned on.
    11. Fixed crash bug when cloning a group.
    12. Fixed various failures when trying to clone a group.
    13. Crash in Kog scripts with an unterminated ‘(‘ at the end of the script. E.g. print(something(1)
    14. Crash on clicking on group when groups hierarchy contains loops.
    15. Handle spaces in connection server and user names.
    16. Fixed crash bug in the Dependencies tab of the Table and View object views.
    17. Fixed various minor problems with User Object View (case 10368)
    18. Fixed crash bug in DataItem::transferChildren (case 10383).
    19. Set the $totaltime script variable for non-select SQL statements.
    20. When ad-hoc query results are discarded, update the results tab to say “Results (discarded)”
    21. Fixed switching between different script types.
    22. For Kog scripts when doing an execute selection or execute from highlight the correct lines.
Kog script
    1. Added –s option similar to other command line tools:
      kogscript -s "{SERVER=172.30.21.1;UID=SYS;PWD=<...>;DRIVER=Kognitio WX2}"
      -e"sqldebug=3;select current_date;"

      Note that unlike the other command line tools DRIVER needs to be added for SERVER connections.
    2. Kogscript now connects from command line parameters (-s “{}” or -s,-u,-p ) for Kog scripts and –e command line scripts as well as for old style SQL scripts.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 70904s130311-2

by MikeAtkinson » Wed Jun 05, 2013 9:21 am

New Features
    1. Syntax colour Lua /Kog script built in functions
    2. Change the messages pane so that repeated messages just increment a count on the message title. The last 5 messages are search for a repeat.
    3. Add update checking. This looks at http://updates.kognitiocloud.com/updateinfo.xml and uses this to see whether a new Console or Kognitio Analytics Platform is available but only:
      • when connected
      • the database has no license (i.e. Free version).
      • The user is “sys”
      • The configuration option “Enable check for update” is enabled.
    4. Tokenise Lua long bracket strings. These have the format [==[ string ]==], where any number of == may be present including none.
    5. Set the script_G. _VERSION variable to “Kog Script 1.0 (Lua 5.2)” for kog scripts and “Lua 5.2” for Lua scripts.
    6. Make F3 mean “find next” so that even after the find dialog has been dismissed, the next matching text might be found by pressing F3.
    7. Add Wizard and Wizard page macro elements.
    8. Make check table access optional (uses “Use explain to only enable valid options” config option) and improve its speed. Don’t do checks if user is “sys” which is assumed to be able to access any table.
    9. Improve the performance significantly in many areas by using QHash instead of QMap and by avoiding unnecessary copy constructors.
    10. Add more loader functionality: min-year, record-type (and record-width, record-terminal-char) and ignore-checksums.
    11. Show Lua script variables as a tree. Script variables that are tables may be opened up to show the table contents. Changed and new variables are shown in red.
    12. Show Lua script variables as a tree, this allows the contents of tables to be seen.
    13. Syntax highlight Lua long comments, –[[ inside comment ]] , correctly.
    14. Compute RAM usage for Horizontally and Vertically fragmented tables.
    15. Delay running macros on object view tabs until the tab is selected – this means that several object views show much quicker.
Bug Fixes
    1. Correctly clone user and group privileges on views
    2. Fix crash when cloning users and groups which have privileges on dropped views.
    3. Avoid crash when outdenting with the cursor at the end of the text
    4. Only monitor query status if the user has ipe_locks access, this avoids unwanted messages.
    5. Set the Lua system to run Kog script correctly before the script has been stored (hence the file extension is not known).
    6. When trying to do a reconnect clear various caches (especially the cache of prepared statements) as they belong to the previous connection.
    7. Process macro nodes in the correct order, this was giving subtle macro bugs as nodes were not being processed in the order they occurred in the *.xml file.
    8. Giving Schema wide and system wide “all” privilege to a user, was generating incorrect SQL.
      When “load column data on connection” was not set the queries returned results that were never used and Console performed more work than necessary.
    9. When objects were double clicked in the metadata tree, dockable macros for that object were being loaded and run, but not displayed. We do not want to run these dockable macros on double clicks on the metadata tree objects.
    10. Fixed crash bug in QueriedItem::update()
    11. Fixed kog script line numbering for multiline SQL statements, now single step moves the right number of lines.
    12. In ColumnSelectDialog set the “random” checkbox to unchecked. Random is rarely used in create view image.
    13. Correct use of prepared statements for ExternalTableItem and FragmentationItem.
    14. Fixed crash in ScriptVariablesView.
    15. Console needs to halt query status update on Lua error and when a query completes.
    16. Add missing “at now” for query in InfoTabWidget constructor.
      Add missing schema from query using ipe_all_param – so it now run for non-“sys” users.
      Fixed crash in TabWidget::itemUpdateComplete.
Kog script
    1. Allow only the connection parameters (-s, -u, -p) on the command line.
    2. Allow SSH authenticated connections
    3. Allow SERVER based connections (i.e. not using a DSN)
    4. Change the working directory to the directory of the supplied script file. This means that paths are now relative to that for finding imported SQL scripts and it is one of the paths for finding Kog and Lua scripts.
    5. Change error_mode global variable so that it encodes additional information on rollback, failure state, etc.
    6. Implement sqldebug=2 and sqldebug=3 logging modes. They show execution times and query results respectively.
    7. Kog scripts did not handle upper case keywords starting statements correctly.
    8. Allow Kog scripts to have C style comments /* */
    9. Add “whenever” keyword to Kog scripts, but only the form “whenever sqlerror” is supported.
    10. Fixed compiler warning, which would have caused errors in rare cases.
    11. Fixed an “Inconsistent stack” warning when sqldebug=1.
    12. Allow script variables to be terminated by , \t, \n and \r
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 70905s130606

by MikeAtkinson » Wed Jun 05, 2013 11:54 am

New Features
    1. Addition of Entity Diagrams
      • Entity Diagrams are now on System, Schema, Table and View object tabs
      • Entity Diagrams allow full range of actions on tables and views, including creating and dropping images.
      • Entity Diagram allow references to be created by dragging.
      • GraphViz used to lay out the diagrams (if not available a default grid layout is used), when an item is moved, that position is remembered and restored the next time the diagram is displayed.
    2. Syntax highlight table_id() and schema_id() functions
    3. Track the default schema for syntax highlighting, this means that tables are not highlighted when they need a schema prefix (which isn’t present) to be accessed.
    4. Syntax highlight name and type keywords correctly, they are often used as column names and in those cases should not be highlighted as keywords.
    5. SQL errors have been moved to their own tab and error detail and action to be taken have been added.
    6. Initially expand the “Keys” tab of the table and view object views.
    7. Add number formatting delegate for columns, this allows Oracle style SQL format strings to be used.
    8. Add general formatting delegate for columns, this uses a modified C style format string.
    9. Add recreate invalidated view action.
    10. Hoover table/view comments so that they are available immediately for Entity Diagrams and the table and view object views.
    11. Syntax highlight many more SQL functions and better determination of whether SQL keywords (e.g. DATE) should be coloured as a function or as a keyword).
    12. Improve the drop table/view dialog to better handle dropping mixtures of table and views
    13. Add an external data browser tool
    14. Added multi-user/single-user install option for Windows
    15. Updated ctrl-F5 query, this update only occurs if the ctrl-F5 text has not been edited in configure.
    16. Changed plugin activate and plugin deactivate to use C code rather than macros, this allows the activation status of the plugin to be shown after a change (now green = active, gray=inactive).
    17. Don’t show help button if context sensitive help is unavailable.
    18. Added Ctrl-C copy for all trees and lists within Console.
    19. Added single/multi-user option during install, this does not work reliably.
    20. Added execute and uncompressed keywords for syntax highlighting.
    21. Improve monitoring of long running queries, they now should stop reliably when the query completes.
    22. Only reset SQL script variables when a script is run from the start.
    23. Add New External Data Source wizard
    24. Move creating a connection for scripts to a background thread.
    25. Add Boolean Conversion and Percentage encode character options to Loader tool.
Bug Fixes
    1. Several more crashes have been fixed (including case 10562)
    2. Syntax highlight recreate correctly
    3. A wrong URL was used in the update checker.
    4. Fix multiple problems in table column editing.
    5. The port of the last connection was not saved, to be used the next time a connection is created.
    6. Toolbars may be shown multiple times in the view menu
    7. Fixed crash when row counts are needed and fast row count cannot be used.
    8. Fixed syntax highlighting of Lua long strings within C style comments.
    9. Fix handling of single line “here” strings
    10. Checking script environment access did not use the “sys” schema qualified table name.
    11. Fix many potential crashes which may occur if the server is disconnected by the user while things are being done in the background.
    12. Resetting Kog scripts was not reliable, leading to subsequent runs of a script to fail.
    13. Setting connectors inactive/active did not change their active status within Console.
    14. Loader record type was not set correctly
    15. Show the correct row count on completion of ad-hoc queries in the Results tab.
Kog script
    1. Handle non-ASCII characters in Lua SQL.
    2. Fixed a parse error in some Kog scripts.
    3. Add recreate keyword to Kog scripts.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 70905s130618

by MikeAtkinson » Wed Jun 19, 2013 2:23 pm

New Features
None

Bug Fixes
    1. Improve performance on connection/disconnection
      1. Destroy metadata in a background thread, make the destruction much quicker. This stops the UI blocking when disconnecting.
      2. Destroy SQLProcessorJob results in a background thread.
      3. Improve metadata acquisition performance by a factor of 2. Also reduce memory usage by about 40% if “Load column data on connection” config option set.
      4. Remove blocks on the UI while metadata acquisition is occurring, functions that require access to the database will still block but for shorter times.
      5. Perform some queries in parallel with the processing of the previous query when doing metadata acquisition.
    2. Only show external data sources item in metadata if the user has the privileges to see them.
    3. Fixed crash when disconnecting while metadata acquisition is still occurring.
    4. Show the correct database that a query has run on in the Query History.
    5. The results are missing (not shown) for the first script query if the “Automatically resize results to fit” config option is set.
    6. Some data in Table/View object views is not being displayed or does not react to changes in the underlying data. This includes the Nullable, Default, Charset and Comment data in the Columns tab.
    7. When entering a comment in the Connector, Table, View and External Script object views the ' character is not handled correctly. Replace by the two characters ' ' in the SQL which sets the comment.
    8. The RAM Usage Monitor refreshes too much. Change the default to 30 seconds and allow the user to alter the refresh time to 2,10,30,60 and 300 seconds.
    9. Added extra NULL pointer checking.
    10. The CTRL+R and CTRL+W (execute from and execute to actions) do not update correctly when a script is stopped.
    11. The connect dialog ODBC configuration button (“…”) doesn’t work for some users.
    12. The “Select statement text after run” config option is not respected in all cases.
    13. Not all changes to tables and views are detected on a metadata tree refresh, so they don’t get propagated to the rest of the UI.
    14. Change the hotkey for the Diagram menu from CTRL+D to CTRL+I as CTRL+D is used for the Disconnect menu option.
Kog Script
    1. Fixed crash when no command line parameters are given.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 70905s130724

by MikeAtkinson » Thu Aug 01, 2013 9:42 am

New Features
    1. Make the script error selectable as a unit, ready for copy&paste.
    2. Support NVarChar with its own icon.
    3. Hide import and export for v8, show then in tools->deprecated.
    4. Make script object views dockable.
    5. Show the table, view, schema, user, etc. name in the object view first tab.
    6. Dragging a schema or security class onto a User object view changes the defaults for that user.
    7. Dragging a user onto a Security Class object view adds that user to the security class.
    8. Update queue object view on queue changes; reload information when the queue 1st tab is viewed.
    9. Update security class object view on security class changes; reload information when the 1st tab is viewed.
    10. Add compressed, partitioned and sorted images to the ColumnSelectDialog; use these when creating table and view images.
    11. Update the current object view if the metadata object it is viewing is changed.
    12. Start time of query added to results Info tab.
    13. When connected to multiple servers, switching between servers disconnects the old one and connects to the new one. Add a configuration option to remain connected to old server after switching.
    14. When making a connection fails, redisplay the connection dialog with the same values (except password is blank).
    15. After a communication link failure (loss of TCP) try to reconnect for metadata.
    16. Improve setting of default extension for script saves when (un)setting the Kognitio Scripting “Enable” and “Use Kognitio Scripting by default” configuration options.
    17. While a Kog Script is paused disable editing of the script. Unlike SQL scripts, Kog scripts are compiled into Lua bytecode, it is not possible to edit a Kog script and continue running that script as the underlying bytecode will have changed.
    18. When showing a ScriptEnvironment object view, update the item’s metadata so the object view reflects the database.
    19. When displaying the Session object view update it with the latest info from the database.
    20. Improved initial connection performance for pre-v8 systems.
    21. After cloning a user, update the groups the user is a member of.
    22. Add “Find Entity” to the Entity Diagram pop-up menu.
    23. Enable Kog Scripting by default for new Console users.
    24. Add the ability to execute ad-hoc queries in their own session. This actually creates two new sessions, one which may be used to monitor the running query.
    25. If Alter Table fails then retry after giving the user the option to create or drop images.
    26. Update Entity Diagrams if other parts of Console detect items have been updated, created or deleted.
    27. Show partitioned views.
    28. Show compressed images in the metadata by using a different icon and changing the tooltip
    29. Show the “partition image by” columns in the table/view object view Info tab.
    30. If a script or ad-hoc query gives a ET010F error get extra information from SYS.IPE_CONV_ERROR
Bug Fixes
    1. Fixed some valgrind warnings.
    2. Fixed crash starting external data browser if the user does not have permissions on sys.ipe_external_data_sources.
    3. Decimal columns show the wrong scale and position in Entity Diagrams.
    4. If only unique groups are defined, the first unique group is shown as the primary key in the Keys tab.
    5. The primary key elements are not individually quoted when setting them by the Entity Diagram alter table dialog.
    6. Don’t show the “add foreign key” button which is not implemented yet.
    7. Make “clone script” the default when altering a running script, this avoids the user carelessly aborting a running script.
    8. The External Data Browser wizard has the connector hardwired to “hdfscon”.
    9. Change the default format string from “%0c\\n” to “%-0c\\n” for the Create External Table wizard so that quoted lines are handled correctly.
    10. Allow comma in Create External Table wizard fmt_field_separator field.
    11. Display the file location when doing a “view file”.
    12. When the loader or unloader dialogs error they should show the dialog again after giving a warning dialog, not close it.
    13. Handle varbinary and nvarchar in RAM Usage computation.
    14. Don’t show “Editing keys disabled when table not empty” if the table is empty.
    15. If “Automatically resize results to fit” configuration option is set, then clicking on an item in the Query History pane does not show the resultset in the “Results” tab.
    16. If “Monitor long running queries” configuration option set then aborting a query does not change the status in the info tab to “aborted”.
    17. Highlights in the SQL Script pane are not visible after a configuration change.
    18. “Open query in new window” problems – missing query text in editor, query results not visible.
    19. Reset col<n> and col<n>Str script variables before next query is run. This avoids leaving stale values in those variables. For Kog script _G.Col<n> variables are set to nil and hence removed.
    20. Delay “explain select * from sys.ipe_fragmenting_preds” until whenipe_fragmenting_preds is visible is first needed.
    21. Don’t show incorrect data in the Kog script statement “Info” tab when it is loaded from the Query History.
    22. Continuing debug from a Break in Kog scripts misses stopping at a second Break.
    23. Fix a crash which occurs if a script is closed while it is stopped (hit a breakpint, single stepped, paused).
    24. Made the viewupdatestatics.xml macro obsolete. It added a menu item “Update statistics” to views, whether or not they had images. Views which have images already have an “Update statistics” item which runs in the Console C++ code.
    25. Indent and outdent also changed the previous line above.
    26. For “Play From” and “Play Selected” the correct Kog script lines were not being highlighted.
    27. The “paste” pop-up menu item was not enabled when a script is first created.
    28. When a user is added to a group the privileges for that group are not shown in the “User Privileges” tab.
    29. Allow granting “create external script” to the system.
    30. Script environments were not being updated for users other than “SYS”.
    31. After creating a table image update the metadata so it is consistent.
    32. Numerous Bug fixes to Entity Diagrams:
      1. Fixed several crashes
      2. Cancelling the “New Table” dialog should remove the table from the diagram
      3. When editing an entity diagram the wait cursor does not go away when switching to another tab.
      4. For the Edit Table dialog when adding or removing columns , clicking on “alter table” causes all columns to disappear.
      5. Fix various issues with menu, toolbars and shortcuts.
      6. Improve the New View dialog.
      7. Improve the New External Script dialog
      8. Restore arrow labels on tables or views being unhidden
      9. Remember table, schema and comment positions on being hidden, restore when unhidden.
      10. Multiple entity diagram toolbars were shown in the view menu.
      11. Views were not removed from entity diagrams when they were dropped.
    33. Distinguish between 7.9.4 and 7.9.5 as the columns available in several system tables differ between them.
    34. If the user cannot access SYS.IPE_FTABLE indicate that the disk distribution data is not available.
    35. When deleting metadata (i.e. when disconnecting from server), there is an occasional crash.
    36. Make finding and use of the ODBC driver consistent.
    37. A renamed table does not show up in the metadata even after a metadata refresh.
    38. The tooltip for macro charts has an incorrectly set scale.
    39. System object view top tables piechart for users who are not sys, was accessing tables in the wrong schema.
    40. Use the old version of CTRL-F6 for 7.2.1
    41. If a Kog Script is not running only allow single stepping when cursor positioned on the first line.
    42. Fix problems in creating and writing to the loader tool error log file.
    43. WxApplication may be used after it is freed or before construction.
    44. ‘Resize to Fit’ for some copy enabled tables causes a crash.
    45. Don’t kick off hoovering after getting licence information.
    46. The sessions column in CTRL-F5 has only 7 digits, it may be up to 10 digits long.
Kog script/SQL Script
    1. Allow SQL Script assignment to have spaces round the =
    2. In SQL Scripts quotes round variable strings are not included when the variable is used.
    3. Kog script crash when $variable undefined.
    4. Remove double free in KogScript command line tool
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 70905s130906

by MikeAtkinson » Mon Sep 09, 2013 1:14 pm

New Features
    1. If we get an ET010F error for script of ad-hoc queries, automatically get the error from SYS.IPE_CONV_ERROR for the tno given in the error string, and display in the Error tab.
    2. Improve the query Info tab layout
    3. In the Open Script dialog improve selection of the script extension
    4. When kog scripts do a require if the required file is another kog script then load it into a Script view.
    5. Minor improvements to many dialogs.
    6. Improved Debug and Single step support for Kog Scripts (including into required files).
    7. Better selection of default extension when saving scripts.
    8. Show the compressed RAM size (for compressed images) in the Table Object View “RAM Usage” tab.
    9. Added a “Partitions” tab for images with partitions under the Table Object View “RAM/DISK” tab.
    10. Added a clear button for the error “Messages” pane.
    11. Added a binary to ASCII column format delegate. This is particularly useful for the IPE_CONV_ERROR RECORD field which is in binary but usually encodes an ASCII string.
    12. Added a “Drop Queue” menu option for Queue object in the metadata tree, only for version 8 of the Kognitio Analytics Platform.
    13. Added a simple query results diff for from a mixture of Ad-hoc or script queries. Select two results from the Query History pane then the pop-up menu option “Compare Results”. Query diffs are not shown if either of the queries error and thus do not produce a resultset to differ.
    14. Added intellisense for schema contents. This may be turned off by a configuration option. This automatically puts " quotes round table names that need them (containing spaces, mixed case) or when the schema has " quotes round it. For this to work the metadata tree must be expanded.
    15. When trying to display a table, view or script object from an out-of-date metadata tree, tell the user if the object has been dropped.
    16. When cloning a group provide an option to copy members of the original group which have had their database access revoked.
    17. Improved various dialogs in minor ways.
    18. Make setting the schema default at the start of a script configurable.
    19. Improved system top tables to show RAM usage as well as Disk usage, and to show the disk usage for dropped tables.
    20. Added schema top tables for Disk and RAM usage.
    21. Improved syntax highlighting of function names used as column names (e.g. table_id) and “left”.
Bug Fixes
    1. Crash when the MainWindow constructor called when the application has been destroyed.
    2. Crash when doing a “Resize to Fit” on many UI tables.
    3. Don’t start metadata acquisition when getting licence information.
    4. Sessions in CTRL-F5 has only 7 digits, sessions are int so may have up to 10 digits.
    5. When displaying a table with lots of columns (> ~30) Kog scripts crash.
    6. Hide Kog script variables after running if the “hide variables when no longer debugging a script” configuration option is set.
    7. Don’t start metadata acquisition when doing query monitoring.
    8. Kog script abort flag not cleared, so that script cannot be run again without copying to a new Script view.
    9. Temp tables now found when created using ad-hoc queries.
    10. The OK button should be the default on various dialogs.
    11. The “Information” macro fails to work correctly.
    12. Cache column widths correctly, this makes a difference when “Automatically resize results to fit” configuration option is set or “Format Column” is set to other than the default.
    13. Updating the ScriptEnv metadata incorrect.
    14. Use case insensitive search on windows when finding loaded scripts based on their names.
    15. User privs on objects missing if after connecting to a system a User Object View is opened and then the object is clicked on.
    16. Vertically fragmented images handled incorrectly so they are not always shown with dark blue text.
    17. When shown in the Table object view vertically fragmented images do not have “Show data in RAM”, “Get columns not in RAM” options on their Content tab.
    18. The Row Count for RAM-Only tables is always zero when shown in the Table Object View.
    19. Don’t show a “Disk Distribution” tab for RAM-Only tables.
    20. Use numeric sorting for numeric columns in various tables.
    21. Sometimes row contents disappeared after sorting.
    22. Don’t show “Save As …” for Ad-Hoc queries.
    23. Don’t disable single step after it has reached the end of a SQL script.
    24. Allow insertion of tab characters before the start of a sequence of non-space characters.
    25. Some SQL statements within Kog scripts may not be parsed, leading to perfectly good scripts not running.
    26. Lua variables are sometimes displayed incorrectly.
    27. Abort Kog scripts correctly and show the abort status in the Query History
    28. Fixed crash when doing a “Discard Results” for an ad-hoc query.
    29. Fixed memory leak when showing the “Keys” tab for the Table object view.
    30. Fixed crash when single stepping Kog script loops.
    31. Don’t try and drop RAM only table images (when several tables including some RAM only tables are selected). Instead warn the user. Also indicate in the metadata tooltip for a table that it is RAM only.
    32. Fixed Crash when clicking abort immediately after starting a script.
Kog script/SQL Script
    1. Parse ($variable) within Kog script SQL statements correctly.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 70905s131004

by MikeAtkinson » Tue Oct 08, 2013 3:31 pm

New Features
    1. When double click on a script in the file explorer to load it into Console, Console also needs to be made the active window.
    2. Show a different “Stop script / Abort query” icon when a script is paused.
    3. Add extra information to the Windows registry during installation.
    4. When DnD a column which contains spaces add quotes round the column name.
    5. Show the Script Environment used in the External Script object view.
    6. Add a Scripts tab to the Script Environment object view to show which scripts use the Script Environment.
    7. Greatly increase speed of drawing entity diagrams ( >1000x for 8500 entities in a schema entity diagram)
Bug Fixes
    1. Regression: Grant table privileges macro action fails to run.
    2. Regression: When showing an ad-hoc query in the SQL view the “Open Script …” dialog fails to be shown.
    3. Regression: QuickViz has stopped working
    4. Regression: <space><dot> causes a crash
    5. Occasional crash when executing a script.
    6. When deciding what text to drop use the DnD drop position not the current cursor position
    7. RAM only table says it is not in RAM when viewing the contents or row count.
    8. Fix various minor problems in acquisition of metadata (none visible in the Console UI).
    9. Fix crash when switching between databases while scripts are still running.
    10. Lock-up when doing a “back” (e.g. ALT+LEFT) action from running ad-hoc query (until the query completes).
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 70905s131012

by MikeAtkinson » Tue Oct 15, 2013 7:29 am

New Features
    1. Add the table/view/extscript ID to the Info tab in the object views.
    2. When outputting a log message ensure the log pane is visible, raise it and show the correct message tab.
Bug Fixes
    1. Set the “id” property for sys.ipe_allschema, set the “schemaId” property for the sys schema
Kog script/SQL Script
    1. Update SQL script lines with $ variables each time they are executed.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100s131114

by MikeAtkinson » Fri Nov 15, 2013 2:43 pm

New Features
    1. Added metadata cache. This stores schemas, tables, views, external scripts and the data necessary to draw entity diagrams for one day. It is also invalidated on Console update to a newer version. There is a new “cache metadata on pc” configuration option in the metadata tab to turn it on. For heavily loaded systems combination that works well is cache on, “Load schema on connection” off. There is now a few seconds pause while the metadata is read immediately after connection. When a schema is opened queries still run in the background to synch the metadata with the schema contents in the database.
    2. Show the status text in the status bar for longer.
    3. In SQL Scripts when including another SQL script copy the script variables for use by the included script. When the included script completes copy the non-automatic variables back into the parent script.
    4. The table/view image creating dialog now has the ability to partition images by expressions of columns as well as just by the column.
    5. Add extra information to the External Script Object view for Overall Threads, Threads per Node, Partition Strategy, Partition By and Order By clauses (Overall Threads, Threads per Node of these are not shown if they are left at default values).
    6. Remember previous installation location, and use that as the default for new installations.
Bug Fixes
    1. In the SQLScript Info tab the first row time showed the time to get metadata for the resultset.
    2. Avoid crashes when drawing charts by initialising some variables to defaults.
    3. Get the column data correctly for Kognitio 7.1.2
    4. Don’t show “ExtScripts” for Kognitio pre 8.1.0 when “Group tables and views in metadata tree” is ticked.
    5. Crash when checking for updates from unpatched Kognitio 8.1.0
    6. In entity diagrams the same table or view might be shown twice.
    7. “Compare Results” menu option was not being shown for ad-hoc queries.
    8. When using prepared queries update external scripts for the first schema opened.
    9. Fixed occasional crash when running SQL scripts.
    10. Make the “Recreate invalidated views” menu option work in all cases.
    11. Fixed race condition when closing a connection to databases with metadata being updated on them.
Kog script/SQL Script
    1. In SQL Scripts when including another SQL script copy the script variables for use by the included script. When the included script completes copy the non-automatic variables back into the parent script.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100s131214

by MikeAtkinson » Tue Dec 17, 2013 2:02 pm

New Features
    1. Updated metadata periodically configuration options are now hidden as they are no longer useful. If set wrongly they can cause Console to seem slow and place undue load on the database.
    2. Entity diagrams improved by making the pane show more of the diagram.
    3. Put the row count into the table info tab.
    4. Added hidden option for SQL job logging – this is a debugging feature.
    5. Made more of the database accesses asynchronous, the only synchronous accesses remaining are during connection.
    6. Improve gathering metadata for External Scripts.
    7. Reset sessions to <current> on closing the last session.
    8. Sort user privileges to make it easier to find the privileges for particular objects.
    9. Add a find function to the metadata tree.
    10. Add a toggle comment action that works on SQL statements; (Ctrl+-) or pop-up menu Statement->Toggle comment.
    11. Add ability to save tables in JSON format (new option to the Save Table dialog).
    12. Add action (Ctrl+G) to execute statement under the cursor.
    13. Enable script editing while a selection from script is running; the script selection is shown with a grey background. A new configuration option “Edit script while running” turns on editing while a script is running.
    14. Check that the metadata session is connected every 10 mins and if not try and reconnect, if the reconnect fails, indicate this to the user.
    15. Show the results tab in magenta if the results limit was hit, to give an extra warning to the user that not all results have been returned.
    16. Console only installer added, unlike the full installer this does not need Admin privileges.
    17. Added a “Remove user from group” action to the pop-up menu of a user within a group in the metadata tree.
Bug Fixes
    1. Sessions: <any> should not be changed to the current session after a script is run.
    2. Only Show Help configuration option when help is enabled.
    3. Fix std.string.caps() Lua function.
    4. Open WCB files in unloader in binary mode.
    5. Security class members should not show groups.
    6. Correctly tokenise SQL Statements within Kog scripts
    7. Groups not updated correctly when users are removed from them.
    8. Removed some ‘;’ at the end of statements, version 6.1.8 does not like them. Added “at now” to the end of a few internal “select” missing them and also to “explain select” statements. This might be the cause of various Console hangs when connected to heavily used databases.
    9. Fixed Crash in KogScript “execute to cursor”.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100s140114

by MikeAtkinson » Thu Jan 16, 2014 9:28 am

This is mainly a bug fix release.

New Features
    1. In the Load tool show in the log file the rows that errored.
    2. Syntax highlight “tablesample”, “repeatable” and “Bernoulli” keywords.
Bug Fixes
    1. Fixed occasional crash when double-clicking on a SQL file (in the Windows file browser) with Console running. Instead of loading the SQL file Console would indicate it had crashed, but still continue running.
    2. Unwanted debug output produced in Linux Console.
    3. Fixed crash in Linux console due to not destroying a QWaitCondition correctly when destroying SQLProcessor (on closing a connection).
    4. For Kog scripts the terminating semi-colon for statements caused an extra empty statement to be created (regression in s131214).
    5. “Results to Excel” for a table with >= 26 columns would add an extra N/A column.
    6. “Execute statement” action not enabled correctly, so that CTRL+G does not always work.
    7. Edits to SQL scripts not always recognised when “Edit script while running” configuration option set. This caused the statement at it was before the edit to be executed with CTRL+T.
    8. Fixed two regressions when running against 6.1.8 databases (“Error updating Tables Fragmenting Preds”, “Error updating Columns”).
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100s140313

by MikeAtkinson » Fri Mar 14, 2014 5:01 pm

New Features
    1. Added ability to alter script environments
    2. Show external script RAM required in the object view info tab
    3. After double-clicking on a User, initially shown that user’s privileges.
    4. Store changed script variables for later display when stepping through the Query History
    5. Distinguish between empty, dictionary and array type tables in the Kog script Script Variables pane.
    6. Dragging a metadata item over a tab brings the pane for that tab to the fore.
    7. Indicate when scripts have been changed by changing the tab text colour to dark blue as well as adding a “*” at the end.
    8. When a SQL error is generated don’t automatically switch to the “Log” pane.
    9. Added configuration options for not showing “Log”, “Messages” and “Query History” panes until requested by the user.
    10. After a table has been added to an entity diagram (using “Add Table”), automatically bring up the table editor for that table.
    11. Change the layout for SQL script views and Ad-hoc queries so that they are more screen space efficient.
    12. Add new Privilege domains and allow them to be used to set a user’s privilege using the new SQL syntax.
    13. Updated the default Ctrl+F5 query which fixes a ‘Insufficient string space for operation’ issue.
    14. Enable and expand Privileges which correspond to the User Object View privileges object, so for instance if privileges for a user are being displayed then the User privileges in the metadata tree are expanded and all other privileges are greyed out and contracted.
    15. Added an Open Connections report macro which shows all the open connections to a Kognitio database together with totals.
    16. Added a Sessions Summary tab to the Sessions object view.
    17. Added shortcut editor to configuration, now shortcuts and icons for actions may be altered.
    18. Added toolbar editor to configuration, now the main toolbar may have actions added and removed and their positions changed.
    19. Altered configuration to move some options into more logical places now that we can significantly configure the UI.
    20. Added Information tab to System object view.
    21. Allow the character set to be set in the exporter tool.
    22. For Pure views don’t show metadata tree pop-up menu options to create or invalidate image.
    23. Remember loader and unloader state.
    24. If no schemas are known about when the “Table Select” dialog is shown update the schemas from the database.
    25. Added a configuration option to set the text for export of “(null)” numbers , fix table saver for JSON output of “(null)” values.
    26. Updated clone user with new privilege options (many available only post 8.1.0) and new post 8.1.0 syntax.
    27. Updated clone group with new privilege options (many available only post 8.1.0) and new post 8.1.0 syntax.
    28. Add setting of Column privileges to the User object view.
    29. Clone user/group now clones Column privileges as well.
    30. Update the loader error log file name to reflect the loaded file name, unless the loader error log file name has been changed by the user.
    31. Separate out configuration option for selecting Ad-Hoc Queries after running them from selecting Script queries after running. It is not possible to select script queries after running them if the “Edit script while running” option is set.
    32. Added “approx” and “approximate” as SQL keywords for highlighting.
    33. Added a new action “Stop then Execute Statement”, this aborts the current statement (if running) and stops the script, then runs the statement under the cursor. Assigned the shortcut Ctrl+J. This action is only enabled if it is a SQL script and “Edit script while running” is set or the script is stopped.
    34. Added a new “Close and Save” action which is added to the File menu. This saves the current script (if necessary) and then closes its editor.
    35. Added “invalidate” as a KogScript keyword to start a SQL statement.
    36. Open minimised Console when SQL file is double-clicked on.
Bug Fixes
    1. Long external scripts where causing RS0111 and RS000E errors in various places.
    2. Regression in s140114, some menu items are greyed out
    3. If we have “Edit script while running” selected still scroll the script to current statement, just don’t move the cursor there.
    4. The Query History for Kog scripts was not showing the initial token for the statement.
    5. Fixed rare crash when disconnecting while still getting metadata, a NULL return from getSchema() was being dereferenced.
    6. Ignore pseudo-changes to scripts (e.g. highlighting) when determining if the script has changed.
    7. Dragging an external script from the metadata tree to the SQL editor should prepend the schema name.
    8. Fixed crash when a session has been closed.
    9. For Kog scripts only show original query text in the query history, don’t use the translated naked SQL.
    10. Correctly handle the “end” token in Kog scripts.
    11. Fix crashes and other problems in Entity Diagrams.
    12. Fix regressions in Entity Diagrams caused by s140114 release.
    13. Fix regression where the highlighted (executing) line for “Execute From Cursor” for SQL scripts was highlighting the wrong line.
    14. Fixed regression in pop-up menu for certain UI tables.
    15. Fixed a couple a crashes that only show up in debug builds against Qt 5.2.1
    16. Only show tables in the Table Selector dialog for Loader.
    17. Update macro validity as access to tables they use become known.
    18. Fix regression in s131012 build (and builds since), where the SQL script variables were being reset before doing a “Execute From Cursor”, “Execute Selection” or “Execute Statement”.
    19. DECIMALS parameter not restored for loader on Load Settings.
    20. When syntax highlighting tokens that are keywords or function names should not be highlighted as such if part of a qualified name.
    21. Scroll the script to follow the executing line when “Edit script while running” configuration option is set until the user manually places the cursor.
    22. Single quoted strings in Kog script naked SQL $ expressions do not work.
    23. “References” privilege on tables cannot be set.
    24. Setting the schema wide table all privilege generates incorrect SQL
    25. Setting the system wide all table privileges does not work.
    26. Error highlights were not being always redrawn correctly.
    27. Fixed various problems with cursor movement when executing statements (ctrl-G) and running from cursor (ctrl-R).
    28. Kog scripts would not allow a execute statement (ctrl-G) after a previous execute statement.
    29. Table and view tooltips were not being updated when their images were dropped outside of Console.
    30. Fixed crash when database connection closed while script running.
    31. Fixed crash when database connection closed while Ad-Hoc query running.
    32. Load and Unload were leaving files open.
    33. User B privileges on user A where shown as user privileges on user B in the “User Privileges” tab of the User object view.
Kog script/SQL Script
    1. Add sqloutput variable, when set to a file path output the query results to that file.
    2. Fixed crash due to unitialised variable.
    3. When multiple queries are executed on one line (e.g. for the –e option) create a new script results for each query.
    4. Fixed crash when executing “kogscript –v” (with no other options)
    5. Partially implement ‘set blanklineterm x;’ for SQL scripts – this no longer causes an error, but does not change the number of blank lines used to terminate a SQL statement from the default of 0.
    6. Removed unnecessary debug output when running SQL scripts.
Installation
    1. Added new command line options to install components separately:
      /c Console
      /o ODBC driver
      /l Command Line tools
      These options are only available singularly (not in combination) so “/c /o” is invalid. Use like:

      Code: Select all

      > wx2clients-32-80100s140305.exe /c /S
      for silent Console installation.
      InstallationConsole only installer no longer asks for Admin privileges, but Windows may still bring up a dialog “Do you want the following program from an unknown publisher to make changes to this computer?”
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100s140605

by MikeAtkinson » Tue Jun 10, 2014 10:22 am

New Features
    1. Add rename queue menu option to Queue metadata items.
    2. Added a slabs diagram to show which slabs are allocated to schemas and which tables in those schemas are allocated to slabs different than those schema slabs.
    3. In the Group object view show users and groups that are members of that group. Allow members to be added (by drag and drop) and removed (by delete key) from the group.
    4. Updated Lua to version 5.2.3, a bug fix release.
    5. Dragging a table or view from one schema to another brings up a dialog asking if the table/view should be moved.
    6. Auto-save a backup “.sav” file when scripts are changed. After a crash or other unusual termination, if there is a “.sav” file present when a script is loaded bring up a dialog asking if that should be loaded instead.
    7. Add a profiler to the loader and external data browser tools so that client files may be profiled and tables created from those profiles.
    8. Allow dragging tables, views and schemas between databases, options are given to change the table name, change the connector and to either create an external table or create a table and copy the source table into it.
    9. Annotate metadata and UI classes so that they may be accessed from UML.
    10. Speed up display of tables with many rows which contain char or varchar columns of short strings not containing new lines.
    11. Save which SQL script views were open on application close, restore them on next start.
    12. Added UI to enable setting more profiler parameters
    13. Show command line options for wxloader
    14. Show command line options for wxunloader
    15. If user is assigned to a queue which is paused or there are no compiler/interpreters available then Console hangs when making a connection. After 30 seconds detect this, break out of the hang, show an error and allow the user to make a new connection (perhaps using a different user ID).
    16. Show the console version in crash reports even if there is no connection to the Analytics Platform.
    17. Show presence of vararg (…) input columns in the external script object view.
    18. Drag and drop of external script from the metadata tree to an editor now inserts “external script <script name>”.
    19. Removed link to Kognitio blog from the About dialog and added link to Kognitio forums.
    20. Added options to configure to control save and restore of scripts.
    21. Improve usability of dropping multiple tables or views.
Bug Fixes
    1. Wrong block termination character used – this caused ‘Q’ to be seen as the start of a block when toggling comments.
    2. Clear of the Messages pane does not work correctly and can lead to subsequent crashes.
    3. The default charset for columns that are not of character type should be left blank.
    4. Timestamp default values should be shown as date + time.
    5. Cannot create or drop queues with mixed case or which contain spaces.
    6. Fixed crash bug in KogScript, when a script is rerun after an abort then it may crash.
    7. Greatly improved speed of display of tables with lots of columns.
    8. Results of a query sometimes not shown.
    9. The Save Table menu option for query results is sometimes disabled when it should be enabled.
    10. Regression in s140114, when opening the Loader or Unloader dialogs from the metadata tree menu for tables or views the selected table is not automatically entered in the dialog.
    11. Regression in previous release: external scripts could be mistakenly accessed in Kognitio 7.2.1 when they were only introduced in 8.0.0.
    12. Obtaining privileges from Kognitio 7.2.1 databases could fail
    13. The prepared query for finding views in Kognitio 7.2.1 contained an error.
    14. Restoring dock widgets would sometimes fail.
    15. Fixed crash bug in displaying RAM usage
    16. Updating slab usage was inconsistent, not all uses obtained the latest information
    17. When a queue has a mixed case name some operations on it (e.g. add a user) do not work.
    18. During dragging if the object being dragged is deleted by another thread then Console crashes.
    19. If the database is closed while loader or unloader are running then Console crashes
    20. After the database has been disconnect ensure that it is not used
    21. Put a handler for Qt exceptions around the main app.exec() and try and restart app.exec() on exception in an attempt to stop rare Qt bugs crashing Console.
    22. Lists of DataItems should use smart pointers so that if the DataItem is deleted while the list is being used those deleted items can be ignored.
    23. In Kog script new lines immediately after a $ variable do not generate correct Lua code.
    24. Kog script get the line number wrong when $ variables are used (seen as highlighting the wrong lines when running a script, and single stepping showing the wrong line)
    25. Kog script are parsed twice when they only need to be parsed once.
    26. When the Options tab is shown Query results are sometimes shown as well.
    27. Case 13176: crash in toolbar editor
    28. More use of QPointer to set pointers to NULL when the object they are referencing is deleted, this should fix many potential crashes.
    29. Fixed crash on disconnect, which also occurs occasionally if the password is wrong when making a connection.
    30. The add users to queue macro should quote the queue name.
    31. Give panes and dialogs a parent, this stops them being displayed orphaned during Console start-up if Qt context switches (e.g. when loading a script).
    32. The schema top tables macro was being replaced by the system top table macro in the 64 bit Console installer.
    33. Cached external scripts do not syntax highlight.
    34. Use the alter table syntax when setting the primary key so that the table does not need to be recreated.
    35. The disk distribution row count can overflow.
    36. Unlock ProcessorJob objects when job is complete.
    37. Give EntityDiagram an object name.
    38. Don’t try and add some objects to the entity diagram twice.
    39. Fixed hang in macros
    40. Fixed crash in SQLExecutor which could occur if Console times out making a connection which then succeeds.
    41. Add sanity checking to External Data Browser and Loader so that they warn if create table has no table name or there are no columns selected.
    42. Fixed crash in External Data Browser when clicking on the pop-up menu “create table” option when the file has not yet been profiled.
    43. Fixed lockup when disconnecting from a database.
    44. Syntax highlight Lua long strings correctly “([[long string]])” was incorrect but “( [[long string]])” gave the correct syntax highlighting.
    45. The results tab after running a query sometimes was blank.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100s140628

by MikeAtkinson » Tue Jul 01, 2014 10:12 am

New Features
    1. Warn the user when the SQLProcessor queue becomes long, which normally occurs when the user does a long running operation via a menu option and then does multiple clicks on the metadata tree or an object view. Most queries that are known to take a long time are run in their own session and do not block the SQLProcessor queue.
    2. Warn the user if the GUI is blocked, this should not now occur except if the database queue the user is making metadata queries on is paused.
    3. In entity diagrams show the schema for tables which are in different schema to the primary view or table.
    4. Removed all where the GUI is blocked by SQL queries.
    5. Improved the job log to show user queries. To enable edit the configuration file to set <joblog>true</joblog>. Then the job log file is then stored in <userhome>/.wxconsole/joblog_<number>.log
    6. Add a tooltip to the Results tab showing the number of seconds the query took.
Bug Fixes
    1. Table comments not being shown in the Table Object View.
    2. It the column name needs quoting, then setting the column comment does not work.
    3. Reduce the number of places where Console waits for a query to complete, blocking the UI.
    4. Editing of the Primary Key and Unique Group in the Table Object View “Keys” tab can fail in various ways.
    5. Fixed crash in ErrorWidget::getErrorPosition()
    6. Some tables in Entity Diagrams are not expandable (these tend to be tables in a different schema).
    7. Using the Tab key to indent did not always work.
    8. Update queues data when the queues item is expanded in the metadata tree.
    9. Don’t show Work RAM in the Sessions object view in scientific notation.
    10. Added more DataItemTree locking in order to try stop occasional crashes as reported in Case 13457
    11. If a script has been recreated so might its script environment, so query for script environments as well.
    12. In the script view stay on the Results tab even when no results have been retrieved, unless the user specifically selects another tab.
    13. Don’t try and close the statement when doing a prepare, the ODBC driver will fail the close as no cursor has been created.
    14. Case 13193 – set the enabled status of execute selected and other actions when the selection and run state of a script changes. As the buttons for these actions can now be added to the toolbar by toolbar configuration setting the enable status when the script pop-up menu is shown is not enough.
    15. Case 13470 – scripts fail with link failure after a disconnect due to network problems, even if the reconnect button is used.
    16. Fixed statement indent so that it does not indent the next line as well and does not leave text selected. Also fixed statement outdent.
    17. Show correct start time for queries.
    18. Switching between multiple servers did not handle disconnects/reconnects correctly.
    19. Crash in LauncherHelper::newConnection(), this is called when a .kog or .sql file is clicked on in an explorer window.
    20. In Kog scripts “select * from $a.$b;” does not parse correctly as ‘.’ does not terminate a variable name.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100s140828

by MikeAtkinson » Thu Aug 28, 2014 3:41 pm

This release fixes lots of relatively minor bugs and introduces more new features, especially those to do with slab management, loading files and external data sources.

Under the hood a major refactoring took place to improve modularity and get ready for QML based macros.

New Features
    1. Refactored Kognitio Console into a base layer, generic database layer, Kognitio database layer, scripting and macros/charts.
    2. The create text for Table and View object views in the Create Text tab can now be resized.
    3. Add a configuration option to show tab when only a single script is loaded.
    4. Show loader/unloader menu options by default now that 8.1.0 is the common server version.
    5. One-click loading – drag a *.csv file to the loader dialog. Click on the “Create and load” or “Append” and “Reload” buttons that appear.
    6. Add “alter script env …” command to the Script Environment object view.
    7. Add rename group menu option (ALTER GROUP x ALTER NAME TO y)
    8. Add rename user menu option (ALTER USER x ALTER NAME TO y)
    9. Add close other scripts menu option on tab of the current script.
    10. Update default CTRL-F3 to show the node as well as the MPID
    11. Change the Disk Distribution for system, schema and table object views to show the node as the top level item, MPID as the 2nd level item and slabs as the 3rd level items. Show subtotals of rows and blocks for nodes and MPIDs.
    12. Order crash reports so latest is shown first.
    13. Syntax highlight SQL exec statement
    14. Show RAM usage by views in Top Tables macro
    15. Add Python syntax highlighting:

      Code: Select all

      S'Python( 
      #python code here
      )Python'
      	PYTHON and python also accepted.
      
    16. Add R Syntax highlighting:

      Code: Select all

      S'R( 
      #R code here
      )R'
      
    17. Made adding users easier by opening the new user in the a User object view and expanding the Groups in the metadata tree, groups can then be dragged and dropped to the new user.
    18. Added configuration for “here” string background colour (light grey by default).
    19. Reenabled configuration of drop table options.
    20. When dragging a mixture of tables and columns format the drop to be more useful.
    21. Added check of tables against other databases – connect to more than one database, pop-up option when table(s) selected in the metadata tree.
    22. Improved slabs diagram to show 20 largest tables as well, colours of slabs for schemas and tables show how full the slab is. Pop-up menu for a table has options to change the table slabs, either immediately or later, if the ‘later’ option is chosen then the results of the change(s) may be seen.
    23. Improve the External Data Browser to show progress of profiling.
    24. Added Slab Migration Status pane which shows the status of slab setting and migration, which may take a long time.
    25. Use a ComboBox containing all the valid character sets for the Loader charset selection.
Bug Fixes
    1. When scrolling through query history show the results for the currently selected query.
    2. Clicking on an SQL (or Kog) file in the window file browser does not maximise Console after loading the file.
    3. A macro may sometimes be set valid even when it isn’t.
    4. Importer and Exporter data should be initialised to defaults to avoid showing incorrect values when an import or export fail before the first progress callback.
    5. Cannot change column types from Integer to bigint, smallint or tinyint when editing a table.
    6. Don’t load scripts that are already loaded, instead switch to that script’s tab.
    7. Crash in SQLProcessor when no current query.
    8. Only switch to the results tab if the user has not set the tab by clicking on a tab.
    9. Crash when discarding ad-hoc query results
    10. Avoid error message on aborting sessions.
    11. Crash due to action not being set correctly when a second database is opened.
    12. Enable the “Create table” button in the loader tool based on whether there is a filename present, not whether there is a log filename present.
    13. Running too many long queries at once give a “not connected” error.
    14. Escape quotes for loader/unloader table name when producing command line text.
    15. When doing a “Selected Queries to Script (in order executed)” don’t include unexecuted queries.
    16. Fixed crash when disconnecting from Kognitio.
    17. Fixed crash when creating a new script from entity diagrams
    18. Correctly enable various features that depend on Kognitio changes since the first release of 8.1.0
    19. Keep the Save button tooltip consistent with the current script being edited.
    20. When opening Console with a double-click on a script file make that script the current script editor tab (rather than any other restored scripts).
    21. Don’t mess with highlighting formats when doing a search and replace.
    22. IPE_PROCESS and IPE_NODEINFO need to be qualified in a couple of queries otherwise those queries only work for user SYS.
    23. If comments within a Kog script SQL statement contain a ‘ or “ then the Lua does not parse.
    24. Make it clear within configuration that plugin function syntax highlighting colour is also for other SQL functions.
    25. Close the configuration file if reading it errors. This allows the file to be moved and recreated with default values.
    26. Kog script parsing of $(exp) expressions within SQL statements needed a space between the $ and (.
    27. Sometimes the script session can become out of sync with the selected session.
    28. Regression: Data browsing sample data not working – broken in last two Kognitio Console releases.
    29. Crash in UserObjectView::deleteSelected()
    30. Cope with \t or \\t as column selector in external data browser.
    31. When the schema or security class for a user cannot be determined (e.g. because they are not visible to the current user) show “[unknown]” in the User Object View.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100s141015

by MikeAtkinson » Thu Oct 16, 2014 2:14 pm

This is mainly a bug fix release, but includes some minor extra features.

New Features
    1. Diagnose, Picture and Explain of script SQL statements before they are run. This allows debugging of SQL statements embedded in scripts that are not valid stand-alone.
    2. Improved Ctrl-F7 definition.
    3. Add format attributes for External Data Browser external table creation.
    4. Save the last opened file when Browsing local (client PC) data in the External Data Browser. Remember local data browser column widths.
    5. Detect when connectors have been dropped (and possibly recreated) when showing the external data sources. If they have add a menu option to recreate the external data source with either the recreated connector or a new one.
    6. Write out the Windows minidump for a crash as well as the wxc.debug frash report file. Improve 64 bit crash reports. Show crash reports in numeric order.
    7. Better pretty printing of SQL – pop-up menu item statement -> reformat selection/statement.
    8. Improved performance when editing large files (>10,000 lines)
    9. Faster find next.
    10. Long-running query execution improved and added configuration of number of concurrent long-running queries.
    11. Show the running status of script queries on the Info tab.
    12. Show image RAM size in table or view Object Views, keep image size and number of rows in synch with changes to the table or view via the metadata tree.
    13. Ctrl-F9 now contains a query to find the current server connections, and Ctrl-F10 the query history. Any user changes to these shortcuts are not overwritten.
Bug Fixes
    1. The User Object View can show an incorrect schema or security class for a user if there are sufficient privileges to read that user’s actual default schema or security class.
    2. Various changes to improve crash resistance of aborting scripts.
    3. A message box showing a Paused Queue is shown when the actual problem is that Console cannot connect to the server.
    4. Fixed various crashes in Data Profiler.
    5. Hide the Slab Migration pane when not in use.
    6. Regression: Importer and Exporter where accidentally disabled.
    7. Regression: removing privileges no longer works and giving grant privileges causes crashes.
    8. Exporter shows byte count for wcb files.
    9. Very long running sessions caused an overflow in the SQL query which gets Session metadata.
    10. Grouping is a SQL Keyword, syntax highlight it as such.
    11. The metadata cache does not work with numeric IP addresses for the connection.
    12. The drop view dialog option for cascade was not being remembered in configuration.
    13. Fixed shortcut editing when shortcut includes more than one of Ctrl, Alt and Shift.
    14. Fixed various minor issues when connected to a legacy version 7.1.2 database
      1. Some metadata queries have a ‘;’ at the end of them which doesn’t compile
      2. Slabs diagram query does not compile
      3. Disk distribution query does not compile
      4. Change use of IPE_ALLCOLUMN to SYS.IPE_COLUMN to allow non-SYS users to run various metadata queries
    15. Uninitialized variable in the entity diagram for systems can lead to crashes.
    16. The “external script (schema-wide)” privilege class is shown for schemas in the User Object View when connected to pre-version 8 systems which do not have those privileges.
    17. Use a QThreadPool for background queries, the previous method of creating threads very occasionally went wrong and left extra sessions running.
    18. Show the User Privileges in the User Object View even if the user is not SYS. Indicate if the current user cannot access particular classes of object (e.g. connectors) and so cannot tell if the user being shown in the User Object View has those privileges.
    19. Use IPE_EXTERNAL_CONNECTOR (not IPE_ALLEXTERNAL_CONNECTOR) when finding the data sources for a user.
    20. Update scripts within a schema correctly when using prepared metadata queries.
    21. Fix data profiling for creating tables from external data or local files
    22. Update DECIMAL and NUMERIC columns when table editing if the scale is changed.
    23. Invalid SQL was being generated for Script Object View column queries.
    24. Fixed various memory leaks, a particularly bad one was during the use of the external data browser to look at Hadoop directories.
    25. Inserting Items in various lists used a O(n2) algorithm, fixing this makes displaying large numbers of schemas or tables/views in a schema much faster.
    26. When creating a table in the external data browser use the type from data profiling to set the scale and precision columns.
    27. In Entity Diagrams tables in a different schema where being redrawn incorrectly.
    28. When a script is running if the user switches to another script to edit that don’t switch back to the running script (configuration option added to keep the old behaviour).
    29. When obtaining a row count for a table that is not in RAM and does not allow fast row counts use a background thread to avoid holding up other metadata queries.
    30. Column type icon is not set correctly when restoring from the metadata cache.
    31. Improve performance a bit by using takeAt() rather than at() followed by removeAt().
    32. In the System Object View the table in the Information tab should fill the view.
    33. Statements in Query History sometimes have a ‘s’ appended to them.
    34. The RAM Usage alignment calculation does not use a query that orders by seq number so sometimes produces wrong (and negative) results.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100con141028

by MikeAtkinson » Wed Oct 29, 2014 1:14 pm

This is a bug fix release.


Bug Fixes
    1. Missing slots in SQLScriptView – this should have no visible effect.
    2. Crash in Console when emitting the nowConnected signal if the database connection fails.
    3. Better adapt Console to the tables a user can see, in particular the SQL queries to acquire data in the RAM/Disk tab of table object views can fail because the system tables they access are not visible to the user.
    4. Locks are not released on various SQL errors when acquiring metadata.
    5. Copy and Paste of dependency tree should not include table IDs – added a configuration option to either both show the table IDs and copy and paste them or do neither.
    6. Don’t look for ‘$’ in zero length Kog script tokens (e.g. END_OF_LINE) .
    7. When disconnecting from a Kognitio database cache the metadata (if the ‘Cache metadata on PC’ option is set).
    8. When disconnecting metadata is cached and then deleted on a background thread after a short delay to allow various other background tasks to complete. Mark the metadata with isDeletingMetadata when the background task is created, not when it is run – this stops other operations being attempted on a metadata tree which is just about to be deleted.
    9. Show the cause of ET010F errors (External script execution problems) in the Console log as well as the error tab.
    10. Regression: disconnecting after running an ad-hoc query leaves the connection that ad-hoc queries are run open.
    11. Fix a potential deadlock in DataItemTree which might in very rare circumstances lock up Console when opening a metadata tree node.
    12. No longer use a counting semaphore to control the number of long running queries that can be executed in parallel, instead rely on the size of the thread pool to set the limit.
    13. A double delete of External Data Browser table model caused a crash when setting the ‘First line is:’ in the Create Table dialog.
    14. Performance: Improve the performance of get all the column metadata by not sending unnecessary signals.
    15. Performance: Improve discarding results from the Query History so that it runs much faster.
    16. Better adapt Console to the tables a user can see, in particular detect when they cannot see the sys.ipe_slabs table and disable table, schema and system slab display and setting.
    17. Performance: Deleting query results and other DataItems is performed on a background thread, but used an inefficient algorithm. For very large result sets (e.g. all the columns for 32,000 tables), this background delete was taking excessively long times, on a 4 core processor this was not too much of a problem, but on 2 core and especially single core processors this caused very slow responses which gave the appearance of Console locking up.
    18. Fixed various double deletes.
    19. Fixed spelling mistake “Kognition”.
    20. Skipping records did not work for the Loader create table dialog.
    21. Ensure the Loader Progress dialog is initialised before each load, showing “initialising” as the status and the file size.
    22. After a crash Console should only reload saved scripts that have been changed.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100con141113

by MikeAtkinson » Fri Nov 14, 2014 1:51 pm

This is mainly a bug fix release, but contains a few minor features requested by users.


New Features
    1. Show SQL and query state for jobs in Queue object view.
    2. Add the number of RAM stores to the System object view Info tab.
    3. Use Ctrl+Tab to move to next tab, Ctrl+Shift+Tab to move to previous tab.
    4. Case 14182: Add “comment” as a SQL keyword that may start Lua naked SQL.
    5. Add a “Delete ALL Reports” to the Console Crash Report dialog.
Bug Fixes
    1. Crash in Loader if aborting load.
    2. Cannot set Table (connector-wide) privilege named Drop table/view.
    3. CreateQueueData object may be used after it is deleted.
    4. If the object selected to show the user privileges for (in the User object view) is destroyed then a crash may result.
    5. After the ConnectDialog is destroyed it may still be used by callbacks resulting in a crash.
    6. One path through the code used incorrect SQL to set the current session to use the NONQUEUED queue for queries that are expected to take a long time.
    7. Potentially memory may be accessed after it has been deleted in Loader/Unloader.
    8. Regression: RAM Usage tab of the Table object view does not display the RAM usage data.
    9. If the system has all slabs and tables left as default then the Slabs Diagram does not show any slabs allocated.
    10. Potential crash when the User object view shows data for a user that the current user does not have privileges to access.
    11. The ProblemTest data for Identify Problem Queries tool was being deleted erroneously and then used.
Client Tools
    1. Fix error message template of CI5042
    2. If wxloader table existence check gives a syntax error, report it.
    3. Get the kogscript.exe command line tool working for 64 bit releases.
    4. Value of SQL_TXM_ISOLATION initialised to wrong value.
    5. wxwcbzip: if qwcb file has no suffix, decompressed file is named file..wcb
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100con150115

by MikeAtkinson » Wed Jan 21, 2015 3:27 pm

THIS PATCH WITHDRAWN, AS A REGRESSION WAS FOUND. WE ARE CURRENTLY WORKING ON A FIX.

This is mainly a bug fix release, but contains a few minor features requested by users.


New Features
    1. Case 14109 - Drag and Drop for copy of table(s) between schemas.
    2. In the loader tool when loading into a different schema than the user’s default, keep that schema when the file to load is changed.
    3. Improve the Pretty Printer to break long lists, add configuration option for desired line length.
    4. Add a configuration option so to pasting SQL onto a script or ad-hoc query editor will reformat the text using the Pretty Printer before it is inserted.
    5. Show the current time and date in the log file after running a query.
    6. Improve log output for SQL scripts when statements don’t return results.
    7. Make the plugin functions table sortable, by default sort on the name.
    8. Abort fetching table/view contents when moving off the contents tab.
    9. Display partial table/view contents as they become available.
    10. Abort fetching table key data when moving off the key tab.
    11. When renaming a script any .sav file for that script is now removed.
    12. Use a better (faster) query when obtaining the data for the table object view Keys tab.
    13. Temp Tables are shown in schemas more reliably, previously they were only shown when a complete refresh of the metadata was performed.
Bug Fixes
    1. The current SQL job may be used after it is destroyed when handling the waitingTooLong timeout.
    2. Trim off leading and trailing spaces off the configuration ignore error string.
    3. Many minor memory leaks fixed
    4. Two potential double deletes fixed.
    5. Load Progress dialog was not being hidden
    6. Crash when retrying modify table with cascade due to the ColumnsTabWidget being deleted while queries are still in progress.
    7. The ColumnsTabWidget may use a table after it has been destroyed
    8. Undefined action being added to the table create dialog file browser widget pop-up menu.
    9. In the User Object view the current object showing its privileges may be used after being destroyed.
    10. Only one instance of the database actions should be created.
    11. Queues Info widget is not being updated correctly.
    12. Two conflicting layouts are set for the Security Class widget.
    13. Ensure that processing the results of metadata queries does not try and update objects that have been deleted.
    14. Update image, fragmentation and partition status when a table or view is displayed in an object view – the wrong data could lead to finding the row count of a view not in RAM.
    15. Don’t display slabs tab for RAM ONLY tables.
    16. RAM Only virtual tables (e.g. SYS.IPE_FTABLE) are shown as “no image” in the Table Object View Info tab, instead show them as “virtual table”.
    17. Crash after a connect timeout (due to network problems, etc.).
    18. Crash when updating row count
    19. Crash when dismissing “table created” dialog.
    20. Removing views from metadata does not work correctly.
    21. Don’t hold up other metadata queries when doing gathering all schema contents (e.g. when configuration options “Load schemas on connection”, “load column data on connection” set).
    22. Crash on Console exit due to invalid SQLStatementResultsProxyModel being used.
    23. Only bring up the disconnect dialog if the connection check fails for the current connection.
    24. Fixed crash when dropping a table using the right click menu on a metadata table.
    25. Fixed regression introduced in the s140815-2 release which caused “Make Dockable” for object views to stop working.
Client Tools
    1. WXODBCEXEC: recognise SQL_WLONGVARCHAR as a string type
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100con150320

by MikeAtkinson » Tue Mar 24, 2015 4:51 pm

This fixes many problems and has many new features.


New Features
    1. Better Pretty Printing of SQL statements – capitalisation and exception list.
    2. Change case as you type using the Pretty Printing settings.
    3. Improve gathering of table, view, temp table and column metadata when opening a schema or opening the tables, temp tables and views items in a schema. This should be a faster, sometimes much faster and more accurate in what is updated.
    4. Update the image horizontal and vertical fragmentation state when a schema is opened.
    5. When doing an “Update server explorer” or “Refresh server explorer” remove dropped tables and views.
    6. The Temp Table object view should only display the info tab as queries for the other tabs do not work for Temp Tables.
    7. Add “Explain Table” to metadata tree pop-up menu for tables.
    8. Double clicking on the Tables, Views, Temp Tables and ExtScripts items in the metadata tree now updates their contents.
    9. When obtaining metadata on connection gather column metadata a schema at a time. This reduces Console peak memory usage and updates the column data for those schemas it has processed quicker.
    10. Add option to only hoover columns for schemas that have not had their metadata cached. This means that column metadata on connection is only once for each schema and then placed in the metadata cache, new tables/views will not have columns in the cache until the column data is obtained by expanding on the table/view in the metadata tree or viewing the Columns tab of the table/view object view.
    11. Better Pretty Printing of SQL statements – when “preserve whitespace within lines” is not set then remove excess whitespace. When it is set spaces should not be inserted around ‘.’
    12. Handle quoted table names when creating the pop-up menu explain table item.
    13. Tables/views with images that are both horizontally and vertically fragmented are now shown with their names in steel blue in the metadata tree.
    14. Provide extra information to non-SYS users in the System Object View info tab if they have access to the relevant system tables.
    15. Syntax highlight in the table colour both quoted and unquoted tables (+ quoted/unquoted schema prefix) in table format.
    16. Improved restoration of connection after “Communication link failure” or “Connection not open” errors.
    17. Improved the dependencies query to make it a bit more efficient and be run as a long metadata query.
    18. Improved query to obtain all tables, views and their columns in a schema which is performed when some entity diagrams are displayed. Now two queries are one for the tables and views and the other for the columns, this reduces the amount of data returned by 50%.
    19. Performance improvement when showing Contents tab partial results.
    20. Improve query performance by using SQLBindCol.
    21. Automatic reconnection for the session scripts run on after connection lost or session aborted.
    22. Switching to the Info tab for table/view object views now updates the values of row count, view image size and invalidated view status.
    23. Add “Comment contains” to the metadata search dialog.
    24. Show sample of pretty printed SQL in the Configuration dialog when choosing pretty printing options.
Bug Fixes
    1. Regression in 80100con150115 release caused tables and views to be occasionally shown in the metadata tree with a date as a name and columns to have odd names as well.
    2. Gathering metadata for schemas used a query that would not compile.
    3. Metadata may be deleted in the ~Database() destructor when it has not been allocated.
    4. When updating metadata remove temp tables is they are no longer allocated, either because they have been dropped or because the transaction they were allocated in has completed.
    5. Don’t gather column metadata if the “Load Schemas on Connection” option is not selected.
    6. When gathering metadata find the plugin functions last so as not to hold up gathering tables and views.
    7. Throttle gathering comment metadata so as not to load them twice in quick succession.
    8. View image partition and encoding may not be updated correctly.
    9. Quote column names when creating partitioned images.
    10. Don’t restore empty scripts after a crash.
    11. Set picture dock title to "Picture and Explain SQL", "Diagnose SQL" or "Explain Table" as appropriate.
    12. Regression: Picture and Explain no longer showing Picture.
    13. Rename user not available on Kognitio 8.1.0 systems.
    14. Check for access to various tables before using them, this avoids messages being emitted for metadata queries that are bound to fail.
    15. Improve metadata handling for fragmented images.
    16. While obtaining metadata for a schema, do not issue further SQL queries to obtain the tables, views or external scripts; they just slow things down as the metadata that these queries obtain will have been obtained by the schema metadata query.
    17. Long metadata queries may use a wrong SQLExecutor which is connected to another database if the “Allow connection to multiple servers” configuration option is set.
    18. Crash wihile dragging due to DataItem being deleted under the drag.
    19. Crash when closing Console in SQLView::statementDstroyed().
    20. Crash when closing Console in QMenu::hovered() - only seemed to occur for 64 Console for some users.
    21. If “Load schemas on connection” config option is not set and a schema is expanded in the metadata tree soon after connection the schema is not updated when it should be.
    22. Case 14909: in naked SQL $ident does not work correctly if the ident contains ‘_’
    23. Crash when showing Query History pop-up menu due to results data being deleted under it.
    24. Fixed crash in Table Diff if there are more than 100 rows and the first 100 rows are the same.
    25. Don’t show “Save errors to IPE_LOAD_ERRORS” checkbox in the Loader dialog.
    26. Fixed crashes in the External Data Browser which may occur when switching databases.
    27. Fixed crashes in the External Data Browser which may occur when creating table from the profile of local data.
    28. Fixed crash in External Data Browser when showing context menu for Hadoop
    29. Fixed crash in Table Object View Keys tab after setting the Primary Key.
    30. Fixed null pointer crash in Slabs Diagram caused by data not being available when the diagram is shown.
    31. Incorrect SQL was being used to find the in-ram status of tables after certain system operations. The tables were shown as having images and were given the wrong icon.
    32. The in-ram status of columns was also wrong in similar circumstances and column names were coloured blue.
    33. When “cache metadata on PC” and “Load schemas on connection” are not set, the horizontal and vertical fragmentation status of tables is not set correctly.
    34. Dashboard did not read the image RAM and temporary table RAM when running against Kognitio 8.1.1 due to the table ID ranges being changed.
    35. CTRL-F7 used the wrong ID range for image and temp tables.
    36. Multiple “Entity Diagram” entries may occur in the view-> toolbars menu.
    37. Don’t show “Edit view” or “Edit external script for entity diagram pop-up menu as they are not implemented.
    38. Fix crash in SQLProcessorQuery::run()
    39. Crash in Entity Diagram when altering/editing a table with Keys still being acquired.
    40. When table editing remember the charset when switching from a CHAR/VARCHAR so it can be replaced if switching back again.
    41. When Table editing don’t show charset for NCAHR and NVARCHAR.
    42. Crash when saving Entity Diagrams if schema is deleted during save.
    43. Fixed a crash while connecting to a database immediately after disconnecting from another one.
    44. Fixed a crash when connecting to a Kognitio database with bad system tables.
    45. Info tab does not handle invalidated views correctly, this causes the magenta text indicating invalidated view to be changed to blue in the metadata tree.
    46. Avoid unnecessary database connections when running a long query, reuse the previous session if it is valid.
    47. Avoid setting current_session queue_num parameter to 0 then dropping it again.
    48. Fix crash when ensure connection is called while/after the database object is deleted (as we have just disconnected) .
    49. Script query monitoring was not always working, due to case differences.
    50. Fixed some spelling mistakes.
    51. Parse two character operators (like “>=”) as a single operator so that they can be pretty printed correctly.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100con150513

by MikeAtkinson » Tue May 26, 2015 5:02 pm

This is a bug fix release.


Bug Fixes
    1. Case 14600: improved Query Pretty Printing
    2. Refresh the metadata after reconnecting to ensure the correct view of the tables and views after a newsys, etc.
    3. It is possible to read off the end of an array when finding the text under the cursor.
    4. Drag and drop of columns should quote them when they are not all upper case.
    5. Don’t store result data when history_mode is set to “none”.
    6. Crash in SQLProcessor::run() when checkAliveReceiver is deleted in a different thread.
    7. Don’t do context sensitive help processing as context sensitive help is not available in this Console version.
    8. Double delete of NewExternalTableDialog
    9. Kog Script while statements were not working.
    10. Content tab of Table and View object views may show incorrect content.
    11. "set schema" should obey the script “Change case of SQL Keywords as you type” rules.
    12. Improve bracket matching to handle comments and quotes within comments.
    13. Removed link to LinkedIn as Kognitio does not use LinkedIn at present.
    14. Copy changed column variables into main script when executing a statement (CTRL+G).
    15. Case 14661: when sessions are re-established after being dropped retry long running queries.
    16. Dragging of table+columns from the metadata tree should insert the columns in their natural order.
    17. Indicate when Console is still collecting data while showing dependencies.
    18. “disconnect;” does not work for Kog scripts.
    19. Case 14671: avoid RS0103 errors when performing session queries by doing string processing in Console.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100con150618

by MikeAtkinson » Tue Jun 23, 2015 4:13 pm

This is a bug fix release.


Bug Fixes to Console
    1. Use “UTF-8” as the codec for saving/restoring QTextStream
    2. When doing a kog script require “module” look in the base script directory for the module, as well as all the standard locations.
    3. Infinite recursion looking for script variables in _G leads to an out-of-memory.
    4. Using SqlBindCol() can lead to an out-of-memory when the table has LOTs of columns, use the slower SQLGetData() instead in that circumstance.
    5. Show a warning dialog if file used by loader does not exist.
    6. Crash when ColumnsTabWidget::alterTableClicked() called a second time.
    7. Kog scripts may lock up if doing a single step after breaking a paused script.
    8. Typing ‘.’ into a script may result in nothing inserted.
    9. Stop/Abort on last statement in Kog script does not remove the yellow arrow.
    10. Handle latest database error messages
    11. Sort Contents tab columns according to column type
    12. Save table not enabled for Contents tab pop-up menu
    13. Don’t allow empty config file to be written
    14. Update column in-ram status correctly (handle null in query).
Bug Fixes to Client Tools and ODBC Driver
    1. ODBC: Expand out the subcontext for embedded errors
    2. SUBMIT: make command history work with $f queries
    3. wxsessionagent should hide password from process list
    4. Wxsubmit crash after large number of queries
    5. Double free in wximport error handling
    6. SUBMIT: if printcomments is 0, don't strip comments from inside here-strings
    7. Don't prompt for password if the username was wrong
    8. ODBC: new AM0052 error should have SQLSTATE 28000
    9. wxwcb2csv doesn't recognise NCHAR and NVARCHAR columns
    10. Tidy up wxaddkey help
    11. Last two digits of WX2 error code can sometimes be wrong
    12. SQLDriverConnect() shouldn't disallow a blank UID field
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80100con150626

by MikeAtkinson » Mon Jun 29, 2015 1:46 pm

This is a bug fix release.


New Features
    1. Add the “New Table …” action to the “Tables” item in the metadata tree.
Bug Fixes
    1. Empty help pane can be shown via the View->Panes menu.
    2. Loader may forget Charset setting.
    3. Regression: Configuration file not created if one does not already exist.
    4. Crash in UserWidget::setFromUser() when creating a new user after a clean install.
    5. Crash when dropping schema and entity diagram open for a table in that schema.
    6. Crash when dropping schema and entity diagram open for that schema.
    7. Reject cloning user if default schema for that user has been dropped.
    8. When creating a new user the Groups item is opened in the metadata tree, it should be the Users item which is opened.
    9. The “alter group x alter name y” SQL syntax is not available in 8.1.0, so only enable the “Rename Group” action for 8.1.1
    10. Vertical fragmentation not set correctly for tables which were vertically fragmented then have their image dropped.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80101s151029

by MikeAtkinson » Tue Nov 03, 2015 1:40 pm

A major release

This release has enhancements, there are new tools and views, enhancements to KogScript and the added ability to script Console itself. There are also many bug fixes and performance improvements over the previous release.


New Features
    1. Add a RAM Usage tab for View object views.
    2. Add a Performance Troubleshooting Wizard
    3. Performance: place metadata queries on multiple sessions (configuration control of number of sessions to use). Default to 1.
    4. Add a Job Monitor tool, which shows the state of all queries (queued, executing, complete) .
    5. Add a Data Audit tool.
    6. Show the number of queued and executing queries on the status line.
    7. Update Lua to version 5.3.1, major features:
      1. integers (64-bit by default)
      2. official support for 32-bit numbers
      3. bitwise operators
      4. basic utf-8 support
      5. functions for packing and unpacking values
    8. KogScript improvements
      1. Added firstRow global which is set from the first row of a query.
      2. Altered the table returned in t = select … ; so that each row contains a string representation of the column indexed by column number and the Lua data type indexed by column name. DATE and TIME columns are converted into Lua dictionaries with the appropriate fields (“year”, “month”, “day”, “hour”, “min” and “sec”).
      3. Added QtLua to allow access of the Console metadata and UI elements from Lua.
      4. Switching of scripts to run in the GUI thread by the kog.runOnGuiThread() call.
      5. KogScripts may now be run from XML Macros.
      6. KogScripts now have Lua Lanes (version 3.9.7) enabled for multithreaded scripts.
    9. Tooltips for tables with known columns in SQL Editor
    10. Detection of new installations and upgrades
    11. Command line execution of wxconsole has:
      1. -s, -u, -p : used to set the system, user and password
      2. -wait : causes console to wait until it has completed gathering metadata
      3. -currentdir <path> : sets the current working directory to path
      4. -donotsaveviews : do not save views on exit or perform views still running checks
      5. -configuration default : set console configuration to its default values
      6. -configuration <path>=<value> : set configuration option given by path to value
      7. -runscript <script> : run the given script
      8. -runfile <path> : run the file
    12. Examples Tool – show various examples of kog script techniques
    13. Testing via scripts
      1. Added command line option to allow immediate execution of Kog script statements.
      2. Added command line option to wait for metadata before running kog script
      3. Added command line option to reset configuration to default
      4. Added command line option to set individual configuration options
      5. Add signature function to QtLua so that function signatures may be checked
      6. Emit gatheredMetadata after schemas have been updated
      7. Added tests for function signatures of many Console classes made available to Kog scripts via QtLua.
    14. Show SQL and query state for jobs in Queue object view.
    15. Add the number of RAM stores to the System object view Info tab.
    16. Use Ctrl+Tab to move to next tab, Ctrl+Shift+Tab to move to previous tab.
    17. Case 14182: Add “comment” as a SQL keyword that may start Lua naked SQL.
    18. Add a “Delete ALL Reports” to the Console Crash Report dialog.
    19. Numerous performance enhancements, including:
      1. reduce number of memory allocations
      2. computing Dependencies for a large numbers of complex independent views is slow.
      3. Optimisation of getting metadata results data
      4. Reduced amount of metadata that is accessed multiple times by different queries.
      5. Use SQLBindCol() to reduce the number of SQL driver calls.
    20. Store the connections string, not individual dsn, username, etc. strings as this simplifies the code in a number of places.
    21. Give sessions traffic light colours depending on their command_running state.
    22. Add a new Ctrl-F7 query which uses the new wx_view_image_type(), etc. functions if they are available.
    23. Add the ability to set a password if the old password has expired when connecting.
    24. Improve restoration of scripts after a crash so that duplicates are not opened twice and that scripts restored from their backups are show as “Restored after crash”.
    25. Added history for search and replace.
    26. User defined shortcuts (Qt 5 only as this depends on QML).
    27. Macros may now have shortcuts assigned to them.
    28. Editable “User Defined” menu for customisation.
    29. Show the queue for the user in User object views.
    30. Filter the metadata tree to just show (wildcard) matching elements.
    31. Make plugin functions sortable within the Plugin object view.
    32. Added 32 bit icons which are used when the icons are shown at greater than 16x16 pixels.
    33. Added configuration of the number of days that metadata is cached.
    34. Improve gathering of metadata for columns so that schemas where the tables/views already have column metadata are skipped.
    35. When doing subsequent Keys and references queries gather data for only new tables.
    36. Improved gathering of comment metadata.
    37. Improved configuration dialog layout.
    38. Added configuration option to ask when disconnecting.
    39. Improved the Table Saver.
    40. Improved R and Python editor tokenisation.
    41. Added configuration of Linux UI style (Default, Plastique, Cleanlooks, CDE, Motif).
    42. Added configuration option to save changed scripts before running them.
    43. Allow loader and unloader to be called with configuration parameters from Kog scripts.
    44. Added configuration option to ask before disconnecting from database.
    45. Added configuration option to only free sessions when script editor is closed.
    46. Use 8pt font on status bar to ensure all status is visible on small screens or when a large default font size is chosen
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80101s151106

by MikeAtkinson » Thu Nov 12, 2015 2:11 pm

This is a bug fix release.



Bug Fixes
    1. “disconnect disconnect” errors are shown when switching between databases.
    2. Added hidden configuration option to not show “disconnect disconnect” errors, not shown by default.
    3. Right click on SQL View enables Play & other actions without checking session combo interlock.
    4. Crash in Delegates::getValue() reading past the end of a string if the general format for resultset column formatting contains a single ‘%’.
    5. Race condition when deleting the SQLProcessor objects may cause crash.
    6. Don’t restore pretty print example script after a crash.
    7. Linux warning: QPixmap: It is not safe to use pixmaps outside the GUI thread.
    8. Forget about SQL script sessions when switching between databases in the system tab, to force use of the correct session for the script.
    9. Add hidden configuration option to forget sessions when switching between database.
    10. In SQLScriptView:: checkSession() always get the session for the database shown by the session combo.
    11. When changing the database shown in the session combo forget about any previous session used to execute the script.
    12. Keep a backup of the configuration file and use it if the configuration file is corrupt.
    13. Crash when closing connection.
    14. Fix warning about QObject::killTimer: Timers cannot be stopped from another thread
    15. Fixed some uninitialized variables.
Tool bug fixes
    1. Fix wxjsonprofile bug when determining decimal prec/scale
    2. Make wxjsonprofile autodetect and special-case GeoJSON
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80101s160111

by MikeAtkinson » Thu Jan 14, 2016 10:04 am

This is a mainly bug fix release.

New Features
    1. Toolbar enhancements:
      1. Add a new large icon for Console on Mac.
      2. 64x64 icons
      3. New simplified toolbar.
      4. Edit new toolbar within toolbars configuration and switch between old and new toolbar styles.
    2. Implement find/replace in all open scripts.
    3. Change the Open Script dialog to allow multiple scripts to be opened.
    4. Save wxloader and wxunloader command lines in the "Save Settings" file.
    5. New panes layout & merge messages into logs (disabled in Windows and Linux releases, enabled in Mac release)
      1. Add a query history tab to the ad-hoc query panes.

Bug Fixes
    1. “disconnect disconnect” errors are shown when switching between databases.
    2. Added hidden configuration option to not show “disconnect disconnect” errors, not shown by default.
    3. Right click on SQL View enables Play & other actions without checking session combo interlock.
    4. Crash in Delegates::getValue() reading past the end of a string if the general format for resultset column formatting contains a single ‘%’.
    5. Race condition when deleting the SQLProcessor objects may cause crash.
    6. Don’t restore pretty print example script after a crash.
    7. Linux warning: QPixmap: It is not safe to use pixmaps outside the GUI thread.
    8. Forget about SQL script sessions when switching between databases in the system tab, to force use of the correct session for the script.
    9. Add hidden configuration option to forget sessions when switching between database.
    10. In SQLScriptView:: checkSession() always get the session for the database shown by the session combo.
    11. When changing the database shown in the session combo forget about any previous session used to execute the script.
    12. Keep a backup of the configuration file and use it if the configuration file is corrupt.
    13. Crash when closing connection.
    14. Fix warning about QObject::killTimer: Timers cannot be stopped from another thread.
    15. Fixed some uninitialized variables.
    16. Add asserts to check that QPixmap use is on the GUI Thread (disabled in release builds)
    17. SQL scripts highlight the wrong lines when doing execute selection.
    18. Don't pause on Kog script SQL errors if we have set the error combo to continue.
    19. Move cursor to correct position when going to error in subscript.
    20. Format the row count better in the table/view object view.
    21. In Kog scripts ‘set’ is not being recognised as a SQL token.
    22. With the new SQL view layout the results pane background is not set.
    23. Detect missing ';' at the end of a CONNECT statement and give appropriate error.
    24. Enable configuration panes for Memory Manager, etc. depending on whether the tool is enabled.
    25. Improvements in change case as you type and show help under cursor.
    26. Missing '-' in console command line parser for "donotsaveviews".
    27. DnD of .kog and .lua files, drop onto tab widgets open file in SQL Script view.
    28. Use set of common functions for data locations.
    29. Pointer to text column messed up when dragging table to SQL editor.
    30. Cannot run ad-hoc query again after disconnecting from server and reconnecting.
    31. New Python script should be alt+F5 (alt+F4 already used).
    32. Add reference dialog does not cope with lower case foreign key names.
    33. When adding a reference mark the dependencies and keys and references items stale.
    34. Modified scripts save before close, do not then close the script like they should.
    35. Microsoft VC++
      1. Q_DECLARE_METATYPE() causes compiler errors on MS VC++
      2. Use QLatin1String() to avoid compiler errors on MS VC++
      3. Other miscellaneous changes to get Console compiling with MS VC++
      4. Changes to get libraries Console uses compiling with MS VC++
    36. Crash when getting tooltip for database that is being deleted.
    37. Crash in KognitioUsers:updateJob() when disconnecting from database.
    38. Disable asserts in release versions.
    39. Enable/disable Save, SaveAs and Close actions depending on whether there is anything to save
    40. Fix potential crashes in SQLFormatter when formatting invalid SQL.
    41. Script variables does not display r.rows[1].A_DATE as a table.
    42. On Windows if the help file directory does not exist create it and its contents.
    43. We should point to Lua 5.3 documentation in console help.
    44. Tighten up detected of console updates.
    45. Fragmentation status detected incorrectly for a RAM only table.
    46. Show columns of system tables as being in RAM.
    47. Update groups when a group tab is opened.
    48. Update privileges on an object after the privileges have been changed not before.
    49. Save the number of rows affected/retrieved in the job log.
    50. Crash during shutdown then trying to uncover a SQLScript view.
    51. External scripts are not updated when schema is updated.
    52. Altering group to add user creates incorrect SQL query
    53. In loader remember table created by "Create Table ...".
    54. In loader remember last directory used to find data.
    55. RS0111 error in sessions object view due to SQL substring() function not available for utf8.
    56. Use canonical file path for open scripts in config file.
    57. Regression: Column defaults are no longer shown .
    58. Add option to load Lua required modules into Console editor.
    59. Add configuration to set default “Trace Kog script lines”.
    60. Executing the wrong ad-hoc query when query for disconnected database changed.
    61. Show Console version in crash info.
    62. Change copyright date to 2016.
    63. Fix typos and naive delimiting in external data browser.
    64. Improve loader error logging.
    65. Attempt to ensure subsequent commands after LOCK SYSTEM use the same connection.
    66. Before doing a lua_close() ensure that the scriptEngine callbacks cannot be called.

Tool Changes
    1. Fix wxjsonprofile bug when determining decimal prec/scale.
    2. Make wxjsonprofile autodetect and special-case GeoJSON.
    3. Wxsubmit: when removing – comment, don’t remove newline.
    4. Implement new –dsaqt option in wximport
    5. Use correct size for sockaddr_un's sun_path
    6. Wxunloader should give Windows style newlines on Windows.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80101s160427

by MikeAtkinson » Tue May 10, 2016 1:02 pm

This contains many bug fixes and various new features. It should be significantly faster and use less memory due to various performance improvements.

New Features
    1. Macros:
      1. Allow Kog scripts in macros to return table data.
      2. Check for tables in schema sys when short circuiting macro known table checks for “SYS”.
      3. When adding a new user macro show it in the view (sub-)menu (no console restart required).
      4. Add delayed execution of Macro Kog scripts and execute Kog scripts from parent widget if there is one.
      5. More macro changes to allow passing of parameters to scripts.
      6. Only enable (macro) view menus when there are sub-menu items under them that are visible.
      7. Add reversed=”true” attribute to macro chart <update …> tag.
      8. Improve Meter macro to show current and max values.
      9. Improve Kog Script execution within Macros
      10. More improvements to Dashboard macro and Meter display.
      11. Switch "oldest" to "newest" in some XML macros.
      12. Call user privileges XML macro "Direct User Privileges" in the user object view.
      13. Add ability to pause ram usage monitor macro.
      14. typo in user privileges macro.
    2. MSVC compiled Console
      1. Make Console compile under MSVC compiler
      2. Compile MSVC release versions with debug information included in executable
      3. Don't run connection on ConnectOnThread for the MSVC compiler
      4. Add NSIS installer creator files for MSVC builds
      5. Get Loader working with MSVC compiler
    3. Kog Scripts:
      1. Add a sleep function to Kog scripts
    4. Add SQL script "set output excel" and Kog script setOutputResultsTo("excel")
    5. External Data Browser:
      1. Add JSON profiling to the External Data Browser
      2. Add ability to load JSON files to console Loader tool
      3. Profile server side JSON files from External Data Browser
      4. Improvements for expanding remote directories
    6. Console integrated tools:
      1. Allow enable/disable of various tools without requiring a Console restart
      2. Rejig "Tools" menu to add "Admin Tools" and "Wizards"
      3. Improvements to configuration for tools
      4. Implement "Errors required to log" in Loader tool
    7. SQL syntax highlighting improvements:
      1. “brief diagnose” should format “brief” as a SQL keyword.
      2. "first" or "last" after "fetch" should be formatted as SQL keywords.
    8. Show total number of sessions connected in Sessions Object View
    9. Add an “abort sessions for all other users” menu option to the Sessions item in the metadata tree.
    10. Add a "play repeatedly" action for Ad-hoc queries to repeat the SQL every N seconds.
    11. Case 11658: Make External Scripting Errors visible in error message/ error logging table. Get script errors from ipe_script_debug for current query.
    12. Improve graphical representation of Schemas within Entity Diagrams.
    13. Write "debug" log messages to the file C:/temp/console_debug.log
    14. Improve crash report info, get working on 64 bit builds.
    15. Use standard paths for app data and cache on MAC OSX
    16. Create a MAC OSX installer app for Console
Bug Fixes
    1. Before doing a lua_close() ensure that the scriptEngine callbacks cannot be called.
    2. Update Console tests:
      1. For new wizards.
      2. Update console tests to include findWidget(QString).
    3. For Mac ODBC define USE64 so that it is built as a 64-bit platform and uses 64 bits for SQLLEN.
    4. More improvements for the ODBC driver on Mac.
    5. Crash dropping a view image if the view is deleted under it.
    6. Schema name not always quoted (e.g. for Camel case schemas).
    7. Performance:
      1. Use QLatin1String() and yet more wrapping of strings with tr() and QStringLiteral().
      2. Improve performance of metadata restoration from cache.
      3. Metadata stored twice for each column.
      4. Improve performance of scripts by using std::vector to hold data not std::map.
      5. No need to disconnect signals from children just before the children are destroyed.
      6. More performance improvements for queries in scripts that return lots of rows.
      7. Improve TableModel performance.
      8. Reduce default maxRows to 1000
    8. Attempt to fix crash in SQLQueryDestruction.
    9. Export to Excel:
      1. Don’t forget Excel workbook if it is temporarily not writeable.
      2. Add SQL script “set output excel” and Kog script setOutputResultsTo(“excel”).
      3. local scriptView = kog.scriptView(); scriptView:setOutputResultsTo("excel")
      4. Improve output to Excel cell formats.
    10. Memory Leaks:
      1. Fix memory leak due to not freeing connection handles.
      2. Fix memory leak by deleting infoTabWidget in SQLCommonView destructor
      3. Fix memory leak by deleting qtLuaConsole in SQLScriptView destructor
    11. Consistent use of canonical file path, and file paths within findSQLScriptViewNamed().
    12. Help:
      1. Help “close tab” action causes crash with only one open help document.
      2. Better format for scripting help and add example for os.date().
      3. Improvements in formatting for the scripting document.
    13. “set schema” altered to “SET schema” even if change text as you type is not enabled.
    14. Kog Scripts:
      1. Allow breakpoints on kog script lines before “end” statements.
      2. Do not allow placement of Kog script break on an “end” statement as it is not executable.
      3. Do not allow placement of Kog script break on an “else” statement as it is not executable.
      4. Switch back to main script when finished stepping through required kog scripts.
      5. Debug (Ctrl+D) after hitting a breakpoint does not run kog scripts in RUNNING_DEBUG mode.
      6. Don’t show rows data in info tab for Kog script Lua lines.
      7. When selecting a Lua line in the history a spurious window is opened.
      8. Debugging Kog script required statements does not always work.
      9. Fix crash in KogRunner if runningView is set but thisView==NULL
      10. When running selection try adding a ';' if the original Kog script fails
    15. Crashes:
    16. Crash when require "script" from an "Untitled" Kog script.
    17. Crash in ImplWxScript::setRowTable() due to NULL luaState
    18. Crash when trying to get objectAreaStackedWidget widget when it doesn't have any.
    19. Crash when trying to save entity diagram from table/view that has been dropped.
    20. Crash when Discard Query and Results, then run ad-hoc query for that Discarded Query.
    21. Crash after discarding script results, the script is run again.
    22. Crash when double clicking on script file which has a .sav file available
    23. Crash in JobMonitor when ending a Job (probably deleted on another thread).
    24. Crash when finding external script in metadata when IPE_EXTERNAL_SCRIPT access granted to user after connection.
    25. Crash on shutdown due to double delete of qtLuaConsole.
    26. Fix crash in User Object View.
    27. Crash destroying closing metadata.
    28. Crash when dropping a table due to incorrect static_cast.
    29. Crash when displaying View Object View and the view has been dropped.
    30. Crash when dropping user while User Object View for that user is visible.
    31. Crash when after view and displaying Direct User Privileges macro in User Object View.
    32. Crash when displaying Table Object View compressed data maps when table has been dropped.
    33. Crash when doing a getRowCount for Table/View Object View and the table/view has been dropped.
    34. Cancel "save changes" dialog closes the script view tab
    35. “Row limit was hit” string visibly truncated.
    36. Ask for “default”, “restrict”, “cascade” or “invalidate” when dropping multiple tables or views.
    37. When doing a “Save As” use the script name as the default.
    38. Better format for scripting help.
    39. System "Disk Distribution" tab not being updated if system clicked on immediately after connection.
    40. "CTRL+C" copy does not work for CopyEnabledTableViews.
    41. Certain failures give incomplete error message "Error Can't"
    42. "Close other scripts and queries" action no longer enabled on script tabs
    43. Handle SQL_NO_DATA_ERROR in SQLExecutor.
    44. Case 18281: Console does not like missing spaces in SQL IF statements.
    45. Improve null handling in KognitioDatabaseView::displayDataItem()
    46. Close All Other Scripts and Views should only close scripts and views.
    47. Buffer overrun in KognitioSQLExecutor::getMetadata()
    48. Create Table dialog misses off last column in CVS display
    49. Case 18280: Only open a single disconnect from server dialog.
    50. Various GUI tables are editable when they shouldn't be.
    51. Case 18623: SecClassObjectView is too strict in validating data to enable "Save Changes" button.
    52. Very occasionally view names are empty in metadata tree.
    53. Clicking on item in Help Index pane does not go to that help item.
    54. Make clear when "Edit script while running" can be done.
    55. “Save As” suggestion may end erroneously with " *.sql".
    56. Turn off debug output for "macro", "qmlmacro" and "WebKitDebug" for release builds.
    57. Convert long to wstring correctly.
    58. Fix TinyXPath to work correctly with c++
    59. Set mode transaction does not work for ad-hoc queries.
    60. Only do updateItemWhenStale() for ext scripts when updating entity diagram.
    61. Fix deadlock in SQLProcessorJob destructor.
    62. Handle errors from QFile::open() consistently.
    63. Sort on Sessions Object View "Connect Time" column not working.
    64. Spreadsheet Model does not handle aboutToAppendChild() signal correctly.
    65. Tooltip for a table in the SQLScriptView sometimes shows SCHEMA"."TABLE
    66. Show columns of IN RAM tables in blue (meaning they are in RAM).
    67. Unloader should not show --table for a query wxunloader command.
    68. Cancelling the Close All Other Scripts dialog closes those dialogs.
    69. "Save Script As" dialog does not show which script is to be saved.
    70. Find Dialog should not change the case of the text to find if "Match case" set.
    71. Entity diagram path is missing directory separator at end.
    72. Diagram entities incorrectly made visible when clicking on the thumbnail view.
    73. In Entity Diagrams all columns may be shown for limited size table entities which overflows past end of table.
    74. History and Info tabs may sometimes be blank.
    75. Don't keep restoring scripts after crash on subsequent restarts after the first.
    76. Save As should not include the " *" for files that have been changed.
    77. "Use the default query row limit" checkbox not restored.
    78. Only alter Play/Debug/SingleStep/Pause/Abort button state if SQLScript is the current widget.
    79. Login restrict dialog does not reflect changed state of login restrictions.
    80. Stop "Failed to read entity file" error message.
    81. "Create image text:-" as a table comment makes the "Create Text" tab display the wrong image text
ODBC
    1. Create an ODBC Installer for Mac OS X
    2. Make ODBC driver store rows in almost-WCB
    3. Make AM send back WCB to ODBC driver (for Kognitio 8.2 and above)
    4. Make a TINYINT take up 1 byte, improve ODBC code.
    5. Make ODBC ask for WCB results by default (for Kognitio 8.2 and above)
    6. Add server-side autocommit capability to AM and ODBC
    7. Fix LENPTR() where record size not multiple of SQLLEN
    8. Fix TINYINT result values stomping on other data
    9. Allow list of default server ports to be specified
    10. Fix ODBC cursor-preserving result-caching feature
    11. Fix ODBC zero-padding of intervals
    12. Fix varchar bug when number of columns is multiple of 32
Tools
    1. Fix wxjsonprofile and wxjson2csv for Windows
    2. Fix wxjsonprofile bug related to empty arrays
    3. Export with long create text errors
    4. Add mode to connector layer for fetching raw file contents
Documentation
    1. Document how to use syntax highlighting for Rython and R
    2. Make clear when "Edit script while running" can be done.
    3. Better format for scripting help
    4. Add example to os.date() help
    5. Clarify package path usage in scripting documentation
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80101s160608

by MikeAtkinson » Mon Jun 13, 2016 9:09 am

This is mainly a bug fix release.


New Features
    1. Check for Updates tool - this allows users to see whether there are new versions of Console or the Kognitio Analytical Platform and to download the new version or patch. Turn on using Console "General" "Miscellaneous" configuration, you may also need to set the proxy to use.
    2. Add kog.writeTable(config, csv) Lua function.
    3. “Use a module to hold a table transpose function, write result to database” example
Bug Fixes
    1. Typo in user privileges macro.
    2. Login restrict dialog does not reflect changed state of login restrictions.
    3. Stop “Failed to read entity file” error message.
    4. “Create image test:-” as a table comment makes the “Create Text” tab display the wrong image text.
    5. Column editing in Table Object View does not handle defaults and charset correctly.
    6. Case 19132: Don’t include QtHelp in the Console build as we don’t use it (needed for Mac OS X only, we pushed a Mac release out to fix this).
    7. Fix various problems with tracing required kog scripts.
    8. Use actual filename of a required kog/lua script to determine if it is a Kog script.
    9. Always update slabs displayed in the Table Object View after they have been changed.
    10. Add data/time formatting explanation into Loader and Unloader tools Time/Date tab.
    11. Get current info for table/view before finding the number of rows in the Table/View objects views (because otherwise it may do a count(*) on a table only on disk.
    12. Change “Restored after crash” to “Restored script” because unsaved scripts are restored when a second Console instance is opened.
    13. Case 19172: greyed out “OK” when creating table via Console.
    14. Error updating row count for a temporary table .
    15. Delete Report failed to remove a crash report from the display.
    16. Don’t show comment about Console in dialog when downloading Kognitio.
    17. Case 19237: If we don’t allocate a statement handle, then don’t store query data against that handle.
    18. Regression: != <= and >= do not work in SQL script if statements.
    19. Allow CTRL+C copy when selecting table column headers.
    20. Uninitialised variables when trying to load file which doesn’t exist.
    21. Cloning user shows password in “Actions” tab.
    22. User passwords may be visible in Console Query Monitor.
    23. Run version check whenever “Check for updates …” action performed.
    24. Don’t start a download while another is still in progress.
    25. When double clicking on the current version set Download as the default action.
Tool and ODBC Driver Bug Fixes
    1. For the KogScript tool when CTRL+6 or closing the terminal abort the current query and close the ODBC connection.
    2. Regression: kogscript command line tool crashes on execution of second SQL statement.
    3. Remove unnecessary "rollback failed" warning from wxloader
    4. ODBC: Fix SQL_ATTR_CONNECTION_DEAD connection attribute
Documentation
    1. Improve Console Kog scripting documentation.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80101s160712

by MikeAtkinson » Wed Jul 13, 2016 2:42 pm

New Features
    1. Use WebEngine for Qt 5.6 and above (OSX version of Console)
    2. Memory Manager tool
    3. RAM Access tool
    4. Networking Manager tool
    5. Getting Started wizard
Enhancements
    1. Update to Lua 5.3.3 – a bugfix release.
    2. Version Check: sometimes downloads 32bit version when 64 bit version installed.
    3. Update Console Help home: for Hadoop, Qt 5.3.3 and Console training.
    4. Add a SILENT flag to unloader and loader config when running under Kog scripts, so that the neither progress dialog or any other dialog/output are shown to the user.
    5. Ignore spaces around the = in unloader and loader configuration strings.
    6. Allow unloader query string to be surrounded by " quotes.
    7. In the VersionCheck tool indicate current ODBC driver by green arrow (if it is different from Console version).
    8. Add (hidden) option to open web pages directly into Console webviewer.
    9. Improve Check Tables tool to allow checking of tables, views and schemas dragged from the metadata tree.
Bug Fixes
    1. Version Check: sometimes downloads 32 bit version when 64 bit version installed
    2. Assign result of addMSecs() in MemoryManager
    3. Add qHash(ValueBase &lv) to QtLua to avoid compile error.
    4. Fix various potential issues the OSX compiler found.
    5. Get rid of some compiler warnings.
    6. Chain running .dmg on Mac OSX when Download then Update selected.
    7. Show wizards in menus according to their enable state.
    8. Fix crash when getting diagram menu and the database has been disconnected.
    9. Work around bug in Qt (QTBUG-49954) reported as QTBUG_53898.
    10. Regression: privileges in metadata tree do not display their icons.
    11. Fix crashes in Loader, Unloader, Importer and Exporter tools which may occur when database has been closed.
    12. Don't crash unloader when called from a script and not connected to a database.
    13. Unload using a query should handle "select" case insensitively.
    14. Don't call insertAction() with null action(s).
    15. Crash in Linux Console due to uninitialised action.
    16. Fix crash in SQLScriptView::executeCurrentStatment() due to no executable tokens.
    17. Syntax highlighting does not always reflect changes in configured font/size.
    18. Don't use metadata while it is being deleted.
    19. When switching between servers queries may be left as queued in the Job Monitor.
    20. Version Check: for Qt 4.7 builds show release notes in browser.
    21. If JSON file fails to sample with “fmt_json 1” try “raw 1” instead – this copes with long lines
    22. Dropping and recreating an external script whilst external script object is select from system pane goes into infinite loop.
    23. Don’t show warning about no suitable script environments unless experimental shell data browsing is enabled.
    24. Actions re applied to the current script in the DatabaseView rather than to a script in its own dock which caused the action.
    25. Loader: after loading from Console memory, next load should not default to $$MEMORY$$
    26. Fix crash in SQL Processor
    27. Row count item uses count(*) from tables not in RAM.
    28. Row Count/Image Size not updated in Table Object View when table in metadata tree has image dropped or created.

ODBC
    1. fix unterminated-string interval wrong result bug.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80101s160908

by MikeAtkinson » Tue Sep 13, 2016 12:14 pm

New Features
    1. Update toolbar – shows when updates or registration is possible.
    2. Gather and Post/Email Kognitio statistics.
    3. Allow users to register with Kognitio.
    4. Allow users to participate in Console beta test program.
    5. Add Users Object View (double-click on Users in metadata tree) to show RAM usage for each user.
    6. Add User RAM Usage tab to UserObjectView
Enhancements
    1. Add context menu and clear function for script variables in Qt Lua Console.
    2. External Data Browser:
      1. Make the first column of local browser fixed while the others are scrollable.
      2. Make the first column of external browser (e.g. Hadoop) fixed while the others are scrollable.
      3. Change order of columns for Hadoop to show the most important ones first.
    3. Store information about database access in configuration.
    4. Add option to email crash Console reports to Kognitio.
    5. Only allow some upgrades and installations to licenced, supported or Hadoop systems and/or to registered users.
    6. Update window title to show when Kognitio is running on Hadoop.
    7. Add “describe” as a new initial SQL keyword.
    8. Data Audit:
      1. Case 19753: saving data audits never enabled
      2. Add Save Audit to Excel
      3. Add Save Audit to File as JSON, CSV or HTML
      4. Add loading and saving data audit specification (tables to audit, etc.)
      5. Add table name to the top right of data audit table tab.
      6. When saving to Excel set the sheet name to the table name.
    9. Check Tables:
      1. Add Save Audit to Excel
      2. Add Save Audit to File as JSON, CSV or HTML
    10. Add a “Try to reconnect after “Communications link failure”” Configuration option (on by default).
    11. Improve frig to make Check Tables tool work with pre 8.2.0 Kognitio
    12. Added new ItemDelegate for URLs in result tables, clicking on them shows them in your configured web browser
    13. Performance: Further optimisations in performing SQL queries within scripts.
    14. Upgrade to use Qt 5.7 (64 bit Console).
    15. Don’t collect statistics for pre-8.1 systems.
    16. Only send new crash reports to Kognitio.
    17. Send register requests to register@kognitio.com
    18. In JobMonitor if there are selected queries then only copy those queries with CTRL+C
    19. Improve JobMonitor with a clear contents button.
    20. Add busy indicator to SessionsObjectView
    21. Add busy indicator to DataAudit
    22. Add busy indicator to CheckTables
    23. Performance:
      1. Add a priority to SQLProccessorJob, set long running queries as low priority.
      2. Don’t do row count twice in TableObjectView.
      3. Comments are hoovered too frequently.
      4. Cancel DataAudit jobs when data audit tool closed.
      5. When switching to a new ObjectView cancel jobs for the current object view.
    24. Alter Security Class object view so that individual fields may be changed.
    25. Add a cancel button to Data Audit.
    26. Use separate queues for high, medium and low priority SQL jobs
Bug Fixes
    1. SQL Scripts: CTRL+L of a selection may execute past the end of the selection.
    2. Remove password from query history when statement complete.
    3. “Initialising script” overwrites statement test in Kog Script history.
    4. Data Audit tool does not recognise columns correctly unless “Load column data on connection” configuration is set.
    5. Some system-wide and schema-wide privileges only available in 8.1.1 and later are shown for 8.1.0 Kognitio databases
    6. Dropping and recreating an external data source may cause a crash.
    7. Patch level truncated to 9 characters in SystemObjectView.
    8. Regression: “Connect to more than one concurrently” unticked does not work (i.e. it does not disconnect when moving from one Kognitio system to another).
    9. Data Audit tool puts Top N Values in wrong place in audit table.
    10. Replaced some inefficient code.
    11. Wrong length used in SQLHighlighter::handleSpecialFunctions().
    12. Incorrect query used in Query Analyzer, temp tables have IDs above 200,000,000.
    13. Avoid a Qt error of sending event to an object owned by a different thread when doing a setProperty().
    14. Replace of multiple spaces generates unexpected extra instances of the replacement string.
    15. Use job->deleteLater() rather than delete job, and consistently use e-accept() for events.
    16. The option to turn off Version Checks should really turn them off.
    17. Connector Object View too large – use a scroll area.
    18. Fix an undefined pointer error found by clang static analysis.
    19. “Status” tab widget for Scripts is sometimes blank.
    20. Don’t execute next line (if it is a SQL Statement) when aborting paused Kog script.
    21. Avoid a potential NULL pointer error in Table Object View “Keys” tab.
    22. Don’t repeatedly run query in SystemObjectView when distribution cannot be initially obtained.
    23. console SQL query (calculating number of distinct commands) is wrong for 64bit ODBC and is also returing: DS000D: Record too large (64 bit console only in s160825)
    24. Painting outside viewport problem for charts with Qt 5.7
    25. Case 19939: Multiple unloads in the script may go wrong.
    26. Don’t send statistics multiple times for the same database.
    27. Crash in unloader due to not running unloader_init() before calling handle_error()
    28. External Data Browser does not work with existing HDFS External Data Sources
    29. Determine 64/32 bit better (so that Mac builds do not say 32 bit)
    30. Change built exe from console.exe to wxconsole.exe (this matches up wxconsole.exe and wxconsole.pdb so that crash reports show file and line numbers)
    31. Don't send stats multiple times for the same database (fix it properly this time)
    32. Ad-hoc queries sometimes not run when disconnect then connect to the same database

ODBC
    1. ODBC: fix wrong result when fetching DECIMAL as DOUBLE
    2. ODBC: fix wrong result converting decimal to numeric struct
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80101s161006

by MikeAtkinson » Wed Oct 19, 2016 4:00 pm

Enhancements
    1. Improve Check Tables Against Other Databases so that the hashes module need not be created by the user.
    2. Show the distribution in the Table/View object view.
    3. Improve Version Check tool to handle release without patch and location URL for web page which is not a download.
    4. Use the MSVC version of kogscript.exe for 64 bit MSVC builds
Bug Fixes
    1. Don't gather statistics if use does not have access to necessary system tables.
    2. SYS.IPE_ALL_PARAM used in queries when user doe snot have access to it.
    3. Case 20034: Nullability is wrong in Table Object View columns tab.
    4. Crash when destroying Connector Object View
    5. Crashes in external data browser
    6. Clear “Extra Info” for each new script error
    7. Show SQL query errors in job monitor
    8. Regression: can no longer create security classes without Console crashing
    9. Fix the Kog Table Manipulation example
    10. Switch back to original SQLScriptView when ending a script
    11. Don’t disable the Stop button when Kog script is RUNNING_DEBUG
    12. Regression: Object Views are no longer removed when object removed from metadata.
    13. Robustness:
      1. Use QPointer for all QueriedItems that may be deleted by cancelling jobs.
      2. Check pointers for NULL before QPointer wrapped objects are used.
      3. Use Q_ASSERT to do many more checks when running debug builds
      4. Add further defensive programming checks in various places
    14. Wrong test for invalid ExtScript in ScriptTabWidget
    15. Crash when aborting Kog script on a Lua line.
    16. Don’t try and set syntax colouring for a zero length token
    17. Enable Stop and Pause buttons while required Kog script is running Lua lines
    18. Fix crash in SQLScriptView::updateScriptResultsForKog()
    19. In one of the paths through Version Check tool enabling the download location is reversed.
    20. Networking Manager tool links item is not updated correctly
    21. QML QuickView dialog not shown for new Qt web implementation
    22. Turn QML QuickViz off until it works again
    23. Abstract out QMessageBox calls so that we can work around bug in Qt.
    24. Change copyright date on various files.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s161101

by MikeAtkinson » Thu Nov 03, 2016 2:24 pm

This release fixes several regressions, a number of bugs and adds a few enhancements. Scripts now update the metadata tree in limited circumstances, in future this feature will be extended.

New Features
    1. Update metadata tree when script creates or drops table/view or user/group.
Enhancements
    1. Improve All Work Saver.
    2. Updated on-line help with latest documentation changes.
    3. Add debug for scripts (output by setting hidden configuration option options/experimental/debug true).
    4. External Data Browser: improve expansion of directory tree nodes.
Bug Fixes
    1. Better detection of when connection is lost to the database.
    2. Regression: Check Tables tool fails for tables or schema, but not for queries.
    3. Crash in Performance Wizard.
    4. Regression: table object view not removed when table dropped.
    5. Regression: All Work Saver no longer saves rows.
    6. Data Audit tool does not handle mixed case column names correctly.
    7. Update Check does not handle download errors well.
    8. If results status is RS_ERRORED don't set it to RS_COMPLETE.
    9. Don't delete KogRunner while Lua is executing.
    10. Regression: Data Audit does not accept drops Summary and Audit tabs in 32 bit builds.
    11. Regression: activate/deactivate plugin not available from plugin popup menu on 64 bit Qt 5.7 builds.
    12. Regression: QuickViz has stopped working.
    13. Regression: column editing no longer works.
    14. Crash in Info tab when clicking on view with no image in Dependencies tab.
    15. “Initialising Script” being wrongly overwritten by first statement when starting Kog script for the first time.
    16. While paused the abort button should stop the script, but not close the ODBC session.
    17. Fix external data browser to work with the predefined DHFS External Data Source.
    18. Don’t delete KogRunner while Lua is executing.
    19. External Data Browser is updating the tree twice for the same path.
    20. Don’t free Kog Script ODBC session unless we really have to.
    21. Spurious extra ODBC session created by Kog Scripts in some circumstances.
    22. Improve Kog Script execution setting of version variables.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s170123

by MikeAtkinson » Wed Jan 25, 2017 9:57 am

This release of Kognitio Console has many new features, enhancements to existing features and bug fixes.

New Features
    1. Lua File System (lfs) module for functions: attributes (file info), chdir, currentdir, dir (directory iterator), link (not windows), lock, mkdir, rmdir, symlinkattributes, setmode, touch, unlock, lock_dir.
    2. SQL now allowed in Lua expression contexts.
Enhancements
    1. 1. Use Visual C++ 2015 to compile 64 bit windows Console.
    2. Use SQL statement callbacks from Lua, rather than using line callbacks and parsing the statement to see if it is SQL.
    3. Handle UTF8 (non-LATIN1) characters on Console side for Kog Scripts.
    4. When setting history_mode="sql" don't do callbacks from Lua to Console for Lua lines.
    5. Read up to 1,000,000 rows when “Max rows:” set to -1.
    6. Update to use Qt 5.7.1 for 64 bit Windows and OS X builds.
    7. Improve WebEngineViewer with support for Qt 5.7.x QWebEngine.
    8. Add a Drop and Reconnect action.
    9. Add the error string to the Lua table returned by SQL queries if the query errors.
    10. Allow breakpoints and single stepping through Kog scripts even when Kog Script tracing is turned off.
    11. Use a Lua table with year, month, day, hour, min, sec fields for timestamp values.
    12. Add metatable to format print the table returned by SQL query.
    13. Add metatable to format print rows element of Lua table returned by SQL query.
    14. Add a hidden option to turn on overall macro debugging by the <debugmacro> element in configuration file. You can also enable individual macro debugging by setting debug=“true” in the wx2macro element of the macro itself.
    15. Allow users to participate in Console beta program through configuration dialog.
    16. Add a max_rows Lua global variable (setting this alters the max number of rows returned by a query).
    17. Add a quiet mode to kogscript command line tool (enable with –q)
    18. Add a os.getenvs() Lua function, which returns a table of key, value pairs of environment variables.
Bug Fixes
    1. When running a kogscript the diagnose, picture and explain results are not shown correctly when looking back through query history.
    2. Fix JSON parser so it can be told when input has ended.
    3. Make JSON parser error on arithmetic overflow.
    4. Push correct path in Kognitio extension to Lua searchpath() function.
    5. Fix potential uninitialized variable in JobMonitor::end() function.
    6. Lua does not look for Kog scripts within the current directory on Linux.
    7. Improve cleanup after running Kog Script.
    8. Use QPointer references to Loader and Unloader dialogs to avoid double delete.
    9. Show script variables after Kog script is complete.
    10. Add Lua hook to before we close a Lua context; use it to delete the kog script state object.
    11. Write correct query metadata strings using %lld for 64 bit values.
    12. Reset Lua every time we start from the script start.
    13. Improve kog script variables recursive detection.
    14. Avoid buffer overrun in Lua redirect_fwrite().
    15. Memory used after it is freed in Lu all_required() KogScript enhancement.
    16. Don’t eat single newlines in stdout redirection.
    17. Ensure that ScriptResults knows the script name even when not connected to a database.
    18. Cope with rare “offset <n>” in SQL error, before real error offset.
    19. Use a high priority for SessionQueueProcessor threads.
    20. Turn Setting Started Wizard on by default for new users.
    21. Improve access o Configuration data to get rid of Dr Memory detected potential problems.
    22. Fix various other Dr Memory detected potential problems.
    23. Separate out code running on GUI thread better; call it via the event mechanism from non-GUI threads.
    24. Loading scripts from recent files menu does not work for Linux.
    25. Case 20417: creating a menu with a parent window then adding that menu to another menu may cause a crash in Qt 5.
    26. Session Queue Processor is started unnecessarily when it is created.
    27. Output error message when connection attempt fails.
    28. Query Monitor may monitor the wrong connection.
    29. Fixed some memory leaks.
    30. Improve display of script variables that have changed.
    31. Crash is displaying QueryAnalyzer error.
    32. Turn experimental query builder off for 64 bit MSVC builds as it stops pretty printing working.
    33. Update Console copyright to 2017 and help home page.
    34. Kog script syntax colouring fails for x( (...) ).
    35. Deleting data items may cause holes in their parent's children array, which then cause problems with subsequent inserts (may cause a crash).
    36. Fix some build system warnings (delete of void * pointers).
    37. XML Macros should not be disabled by default for new users of the MSVC 64 bit Console.
    38. Data Audit does not work well with tables/views without images.
    39. Crash in loader due to referencing through deleted dlg qpointer.
Tools
    1. Allow kogscript.exe to run pure Lua scripts (i.e. no KogScript enhancements).
    2. For kogscript.exe, if there is not script and it is run in interactive mode then set sqldebug=3 so that SQL results are output by default.
Documentation
    1. Kog Scripting Guide – add Lua File System module documentation.
    2. Kog Scripting Guide – tidy up XHTML.
    3. Kog Scripting Guide – SQL in Lua expression contexts.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s170215

by MikeAtkinson » Mon Feb 20, 2017 8:54 am

This is a bugfix release, with a few minor enhancements.

Minor features and enhancements
    1. Allow KogScript.exe to run in interactive mode when only -i option set
    2. Add ability to reset loader and unloader tool settings
    3. Show error within the loader dialog box if loader create table fails.
    4. Add a Reset Lua action
    5. Improve unicode (utf8) within Kog script
Bug Fixes
    1. Kogscript sql table __print does not work correctly
    2. SQL in Lua expression statements does not always compile
    3. Add error string to Lua results table for the case where sql_results is NULL
    4. Improve luaB_sql() to remove unnecessary code
    5. Case 21032: Crash when deleting the query history for ad-hoc queries while a query is still running.
    6. Case 21032: Crash in DataItemTree when item has been destroyed, but tree node not yet removed.
    7. Case 21032: Crash in KognitioSchemas::updateComments().
    8. Crash when DataItem in a DataItemTree is deleted from another thread.
    9. ShowScriptDebug run for non-script errors in Kognitio 8.2.
    10. Regression: Loader & Unloader do not remain visible to allow another load/unload.
    11. In Loader tool "first line:" combo is only used for create table.
    12. Console does not handle '\0' within CHAR() columns.
    13. Turn off QML macros in the bugfix (master) branch as they do not work correctly yet.
    14. Crash when DataItem in a DataItemTree is deleted from another thread.
    15. Console Loader tool can crash while trying to display errors.
    16. Update start record in loader depending on the state of the first line combo box.
    17. Cannot change character set in create table statement on load form.
    18. Various Loader tool create table dialog errors in generating correct SQL.
    19. Regression: cannot browse history after a script has been changed.
    20. Only reset lua when script run from the start.
    21. Regression: keys editing in Table view no longer enabled by "Edit Keys".
    22. Crash when user dropped and recreated outside Console.
    23. SQL query wrong for "Queued Jobs" tab in QueueObjectView.
    24. Crash in ScriptVariableView with recursive variables starting with '_'.
    25. Crash in Database::createSession() if sqlExecutor has been deleted.
    26. In DataProfiler if file does not end with ".json" then don't try alternative JSON profiling technique.
    27. Updated ODBC driver
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s170313

by MikeAtkinson » Thu Mar 16, 2017 10:23 am

Minor features and enhancements
    1. Add a "Rows Processed:" field to the Load Progress dialog
    2. Use SQLCancel and SQLEndTran to abort any query on a connection before disconnecting session.
    3. Use SQLCancel to abort a query, only fall back on trying the previous method "update SYS.IPE_CURSESSIONS set ABORT=1 where SESSION=<sessionid>" if the SQLCancel fails.


Bug Fixes
    1. Crash in SQLScriptView::getContinuation() due to a null pointer.
    2. Syntax highlight Lua operators before a '(' correctly.
    3. Avoid a throw/catch in getLuaVariables(), which may be slow.
    4. Get rid of some more memory leaks found by valgrind, especially some leaks in the RAM Access Manager.
    5. restoreSceneFlags() failing for RAM Access, Memory Manager and Networking Manager tools.
    6. View submenu for RAM Access, Memory Manager and Networking Manager shows no items.
    7. System Version does not update when svr is upgraded and connection auto reconnects.
    8. When automatically emailing crash reports to Kognitio, place the "Reported to Kognitio" string at the beginning of the report.
    9. Loader "rows loaded" actually shows the rows processed, need to subtract the start record.
    10. Crash in SQLQueueProcessor::run() due to database being deleted while a query is in progress.
    11. Save Memory Manager and RAM Access Tool scene before elements are removed.
    12. Work arround Qt bug that means that Metadata query results with a lot of rows are not being deleted.
    13. When scripts are closed they fail to abort the currently running query.
    14. Do not close script while it is in the middle of executing a query, wait for the script to be aborted.
    15. Avoid a potential null pointer error.
    16. Do abort on worker thread so that it does not lock up the GUI.
    17. When doing an abort update the buttons to disallow another abort action.
    18. Crash in ConnectAgainOnGui if database has been closed.
    19. Console hangs on closing a database if query still running, do the closing session part of closing a database on a background worker thread.
    20. Fixed a few compiler warnings.
    21. In response to Kognitio server reachability problems, Console may try and show a ConnectDialog that has been deleted.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s170322

by MikeAtkinson » Thu Mar 23, 2017 1:32 pm

This is a bugfix release.

Minor features and enhancements
    1. Add debug_rows so that the number of rows shown with sqldebug can be varied.


Bug Fixes
    1. Fragmentation not used correctly within Console, which shows up as occasional incorrect tooltips.
    2. Crash when reconnecting to database that has been restarted.
    3. Regression: Console web access does not work for Qt 5.7.1
    4. Bug in QtLuaQObjectWrapper due to missing {} around a series of statements .
    5. Crash when expanding Script Variables tree when more than 2 levels deep.
    6. Spurious '\0' at end of some char columns on Linux.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s170413

by MikeAtkinson » Wed Apr 19, 2017 5:12 pm

This is a bugfix release of Console. Several bugs to do with aborting queries and scripts have been fixed.


Minor Features
    1. Added a recent activity log to crash reports to provide some context for the stack trace.
    2. Use ComboBox to set user's queue in the User Object View.
Bug Fixes
    1. After aborting, the current sqlResults should be updated.
    2. Improve query running to handle when results are removed better.
    3. Add mutex to stop LuaState being deleted while statement is being aborted.
    4. Using the wrong LuaState may cause the wrong KogScriptState to be deleted (so it might be deleted twice).
    5. Use QPointer for extScript in ExScriptColumnsItem and ExtScriptColumnItem to detect when it has been deleted elsewhere while a query to obtain these is still in progress.
    6. Unlocking a lock in a script abort path that wasn’t locked causes an assert.
    7. Avoid some potential issues in KogRunner::kogCallback() by defensive programming.
    8. Owner of ext scripts incorrectly always shown as “SYS”
    9. Crash in unloader when completing an unload after aborting a previous unload.
    10. Cope with ScriptResultsModel results variable being NULL.
    11. The statementMap is not being cleared when running SQL scripts.
    12. Fix crash in Linda Communications example.
    13. Show *.kog, *.lua and *.sql files by default when opening a script file.
    14. Check for NULL in Macro onClicked() slot.
    15. Improve detection of 8.2 systems.
    16. DataAudit keeps listening for a row count changed event (which happens when table displayed in Object View).
    17. DataAudit keeps listening for a columns item changed event (which happens when table displayed in Object View).
    18. User Object View "save changes" button still enabled after a save.
    19. Show queue id in the Queue Object View.
    20. Regression: User RAM Usage no longer works.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s170522

by MikeAtkinson » Tue May 23, 2017 2:33 pm

This is a bugfix release of Console. Several bugs to do with aborting queries and scripts have been fixed.

Features
    1. Run metadata queries unqueued in Kognitio 8.2.
    2. Colour views chocolate in the metadata tree if all dependencies are in RAM.
    3. Colour depend on and dependencies in View Object View Dependencies tab.
    4. Improve Check Query to look at expected rows, cost and in-ram status of tables/views in query.
    5. Colour views chocolate if view does not touch disk or external table.
    6. Allow parallel load when copying table between systems.
Bug Fixes
    1. Avoid potential for crashes when connecting/connected to restarted Kognitio systems
    2. Crash in QueueUserListWidget::contextMenuEvent().
    3. Ensure that the statementMap cannot contain invalid statements for line numbers.
    4. Attempt to fix occasional crash when getting ODBC errors - seems to be invalid handle.
    5. If the query is a picture, explain or diagnose, don't do the picture before execution, etc.
    6. Crash in ImplWxScript::doDebugHook() during Console shutdown.
    7. Crash: Drop user's default schema while viewing User Object View, make change and then save changes.
    8. Crash: Drop user's security class while viewing User Object View, make change and then save changes.
    9. Crash: viewing a User Object View from another user which does not have privileges to view queues.
    10. WORKSPACE_SIZE and INSERTBUF_SIZE removed from ipe_allram_access.
    11. Dropping table images does not reset some internal state.
    12. Add in a short delay before schema update after detecting script "create table ...", etc.
    13. ; within comment within sql statement causes kog script parsing to go wrong.
    14. Various problems with characters within comments with sql statements within kog scripts.
    15. Don't show the System Monitor Tool in the Panes menu if its UI has been disabled.
    16. Remove Web from View -> Panes menu.
    17. If the script has changed always get the new first statement.
    18. Crash after discard results of most recent “execute statement” command.
    19. Don’t show the System Monitor Tool in the Panes menu if its UI has been disabled.
    20. Don’t restore from .sav files if they are empty.
    21. Send Console bugs to console-bugs AT kognitio.com
    22. Don’t change to kog script after we have decided to start running as an SQL script.
    23. External scripts not inserted in correct schema in metadata tree.
    24. External scripts no removed from metadata tree when removed from database in all cases.
    25. View dependency on external scripts not queried correctly.
    26. Avoid adding domains twice into the metadata tree.
    27. Improve: External scripts no removed from metadata tree when removed from database in all cases.
    28. Update Console configuration backup whenever console is run.
    29. Disable invalid script options.
    30. Minor bug in dependency processing.
    31. Crash when "Check Tables ..." with no connected database.
    32. Allow parallel load when copying table between systems.
    33. Fix some potential null pointer exceptions.
    34. ActivityLog sometimes crashes.
    35. Prevent lock-ups of the UI due to SQLProcessor being locked (e.g. waiting for a server restart).
    36. Crash if invalid database in Systems pane.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s170619

by MikeAtkinson » Thu Jun 22, 2017 12:55 pm

This is a bugfix release of Console. Several crash bugs have been fixed.

Minor Enhancements
    1. Update to use Qt 5.9
    2. When only a single row of results, set columns as attributes in the Lua table.
    3. Change script variables (script debug) to use CTRL+C for copy.
Bug Fixes
    1. Regression: Content for views is obtained even when they are not in RAM
    2. Various Clang static code analysis bugs:
      1. Uninitialised variables may be used in ImplWxSession::getMetadata if connection errors while executing this function.
      2. potential to dereference a null pointer in ImplWxScript::setResultsForLua if the luaState member variable is null.
      3. potential to dereference a null pointer in ImplWxScript::kogtoken if ls parameter is NULL.
      4. In onStarted in wxc_connectdialog.cpp various possibilities of dereferencing a NULL pointer.
      5. Potential to dereference two NULL pointers in CreateDimensionTable::schemaUpdated.
      6. Action not always checked for null in DatabaseActions::getActions.
      7. potential to dereference a NULL pointer in Profiler::sample_statistics.
      8. metadata not checked for NULL in FileDataItem::update.
      9. potential to dereference a NULL pointer in HelpButton::focusChanged
      10. Coding error && used when it should have been || in 9 places in wxc_kognitiometadata.cpp, these could potentially cause crashes if various functions were called while the metadata was freed.
      11. Potential to dereference a null schema variable in KognitioTables::removeTable.
      12. Potential to dereference a NULL view variable in MainWindow::showProblemQueriesOnGui() and MainWindow::openWebViewerOnGui().
      13. Dereference of a NULL db variable if MainWindow::disconnectFromServerOnGui() is called when not connected to a database.
      14. Potential to dereference a NULL SQLExecutor in Metadata::getProcessorForDataItem() if not connected to a database.
      15. QueueObjectView::aboutToShowMenu() can dereference a NULL variable due to == being used instead of !=
      16. In ErrorWidget::setError() errorTextEdit could potentially be dereferenced when NULL.
      17. In TableDiffModel::data() rowItem may be dereferenced when NULL.
      18. In TableDiffView::hirschberg() two delete should actually be delete[].
      19. In wxc_tableview.cpp there are three places where createTextItem may be dereferenced when NULL.
      20. There are also ~60 potential memory leaks that have been fixed.
      21. There are also various other minor deficiencies fixed.
    3. Fixed Crash when getting Table tooltip.
    4. Fixed some warnings when running the External Data Browser.
    5. currentRun and currentGroup may be destroyed twice.
    6. Use better fonts for Linux (on first install).
    7. Add OK button to new installation dialog.
    8. Don’t set the WindowStaysOnTop hint for the getting started wizard, to avoid locking up the UI.
    9. Fix typo in getting started wizard.
    10. Improve layout of Configuration panes.
    11. Various minor code improvements
    12. Crash after viewing System Object View “Distribution” tab.
    13. Small improvement to script error messages.
    14. Activity log may contain very long lines, which causes the debug files to be huge.
    15. Make many std::wstring and std::string parameters const.
    16. Lua sql() function shows query complete when SQL error occurs if it is the last function executed.
    17. Crash in ImplWxScript::executeServerStatement() due to invalid statement.
    18. Add a C macro to ensure that we really don’t delete widgets with a parent widget. (This should fix the crashes that Andy Wood is seeing).
    19. Crash in SQLProcessorQuery::run() due to null job.
    20. Console messages updated to include those new to 8.2 (64 bit Windows only)
    21. Crash with EntityDiagram Schema “Expand” menu option.
    22. After a schema has been dropped there is a small window when the schema for a table may be NULL.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s170913

by MikeAtkinson » Mon Sep 18, 2017 2:41 pm

This is a bugfix release release of Console. Several crash bugs have been fixed. Many other bugs in editing and running KogScripts have been fixed.

Bug Fixes
    1. Potential for DatabaseView::currentDatabase() to return NULL.
    2. Update to use Qt 5.9.0
    3. Horizontally fragmented table uses count(*) which is slow.
    4. Show rows in RAM in the Table Object View "Info" tab.
    5. RAM Usage tab computation wrong for horizontally fragmented tables.
    6. Crash when destroying cloned SQLProcessorJob.
    7. DataItem::crunch() goes off the end of the array.
    8. Regression: Question dialogs no longer use 'Y' and 'N' shortcuts for the "Yes" and "No" buttons.
    9. Underline keyboard shortcuts QProxyStyle hint.
    10. Fix failing console tests.
    11. Crash in isMacroValid() due to NULL macro.
    12. Crash in AllWorkSaver due to uninitialised variable.
    13. Crash when stopping spinner movie when deleting TabWidget.
    14. “drop table if exists …” does not show “if” as a keyword.
    15. Don’t show debug output in Log pane by default (it’s a hidden configuration option)
    16. Crash in SQLProcessorQuery::run()
    17. EnsureConnectionSqlCallbackJob not handled correctly leaving “select 1” in queued queries.
    18. Use correct type for all SQL row counts.
    19. Improve getting group metadata associated with group ID.
    20. Copy&paste into Address: of connection diealog can leave new line in address:port string.
    21. Lua multiline strings with = in their terminator (e.g. [=[ a string ]=] ) do not syntax highlight correctly.
    22. Lua multiline comments with = in their terminator (e.g. --[=[ a comment ]=] ) do not syntax highlight correctly.
    23. Improve consistency of obtaining database session name.
    24. Improve cancelling of jobs.
    25. redirect_fprintf() with NULL stream causes crash when double-clicking on Kog script in Windows explorer.
    26. Improve kogscript.exe error message when cannot connect to server.
    27. Run Schema::update() only when all drop views/tables are complete.
    28. Allow "cont" from ScriptVariables view prompt when doing a debug.debug().
    29. Crash if external script deleted from metadata but not from extScriptsById
    30. External scripts not being updated when a schema in the metadata tree is expanded.
    31. EditingKog Scripts
      1. Only show blocking GUI thread warning if blocked for more than 1 second.
      2. Lua parser does not handle "here" strings correctly when they contain ]].
      3. Crash in ImplWxScript::isEndOfSuperString()
      4. Lua Parser does not handle "here" strings correctly within SQL statements.
      5. Values in "Session:" combo in Script Options tab may be invalid.
      6. Only re-parse the script if it has changed since the last time it was set.
      7. Clicking on Lua statements in history shows following comments as well.
      8. Kog Script '/' does not parse if not followed by a space.
      9. KogScript syntax highlighting '%' is not recognised as a symbol.
    32. Running Kog Scripts
      1. Add script variable "WCSerrorMessage" to hold the error message - set to "OK" on no error.
      2. Crash in executeServerStatement due to null luaState.
      3. Crash in KogRunner::wakeLua().
      4. Reset nextStatement when running a KogScript.
      5. The Lua state was not updated with the currently executing script file when moving into and out of modules, this caused the strange behaviour seen when executing a function in a module and Console seemed to be executing a completely different line.
      6. Inconsistent use of nextStatement (and the statement expanded text in QString and std:wstring formats) caused the odd anomaly.
      7. Writing to the kogSource variable within the lua callback function is asynchronous with the UI, causing the UI to use the wrong source file.
      8. Only use a single KogRunner object to hold the state of the script execution, previously new KogRunner objects were chained when a new module was seen, but this was just unneeded complication that does not work well.
      9. Update the running status for the base view from the running view and then set the old running view’s status to NOT_RUNNING when returning from a required module.
      10. Update the WxResults and ScriptResults immediately after the next statement is set.
      11. Callback from Lua before a require is executed so that a script with unsaved changes may be saved before loading the script into Lua.
      12. Add “required script” as first item in history list when running a required module.
      13. Add in the next “Run N” into the history list for required modules.
      14. Start new KogRunner when executing a script as a top level script after previously executing it as a required module.
      15. Consistently store the script results within the Lua state.
      16. Crash when handling a QShowEvent while a script is being deleted.
      17. After an entry in the history is complete, then stop the timer which caused periodic updates of its state.
      18. Single Step after a breakpoint within required module does not work.
      19. Single Step yellow arrow gets left behind when switching between required modules.
      20. Kog Script $var$ in SQL does not recognise var as a Lua variable.
      21. Kog Scripts may get the line number wrong when parsing complex SQL with $ variables.
      22. If exception in KogRunner occurs then about running script.
      23. History for Lua statements shows following comments.
      24. Various bugs in Kog Script UI execution, especially when going into modules.
      25. After resetting Lua state ensure local references are updated.
      26. Only wake Lua at end of doKogQueueEvent()
      27. Missing single step arrow when stepping backwards in file.
      28. Crash in AbortOnThread while exiting.
      29. Don't get new SessionProcessor unless necessary. (causes a new session to be created each time a script is run).
    33. Performance
      1. Process dependencies a bit at a time to avoid blocking the GUI thread.
      2. Improve performance of obtaining dependences to avoid blocking GUI thread (work around Qt 4.7 bug).
      3. Showing “All User/Group Privileges” in system object view can block the GUI for extended periods.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s171128

by MikeAtkinson » Wed Nov 29, 2017 9:37 am

This is a bugfix release candidate of Console. A several crash bugs have been fixed, and many other issues to do with running KogScript

New Features
    1. Show when it is unknown whether view has all dependencies in RAM by colouring the text grey.
    2. Show where KogScript module is required from in module’s history
    3. Show full path of module in info for require statement.
    4. Improve switching between windows style and menu style toolbars.
Bug Fixes
    1. Crash in setVariable() due to using wrong luaState
    2. Reset values in variables[] when doing resetColVariables with valid luaState
    3. When switching views ensure that the new runningView has current kogRunner
    4. Esc key does not work on Find / Replace dialog
    5. Connector Object View not updated when shown
    6. Fix warning: suggest parentheses around ‘&&’ within ‘||’
    7. Improve connection timeout
    8. Update ScriptRun text when ending script
    9. Improve resizing of resultset columns/rows
    10. When single stepping and running try to keep entire statement visible
    11. Close luaState when switching to SQL script.
    12. Typo "adim" when resetting password in Open Database Connection dialog.
    13. Don't show ram used in Problem Queries tool when transaction (crtrans) is -1
    14. SQL_NEED_DATA is not an error, but treat it as such when running KogScripts.
    15. Session combo switching from <current> when it shouldn't.
    16. Only close luaState if the script has one, SQL scripts don't.
    17. Show Servers dock on database connection after a reset window state.
    18. Console metadata queries should not end in a ;
    19. Update bugfix branch to use Qt 5.9.1 and MSVC 2017
    20. $ variables are not being substituted in the history for execute selection.
    21. When resetting script state if it is a Lua/Kog script but has no Lua state then create one.
    22. Case 21649: $variable followed by newline does not parse.
    23. Case 21649: SQL Script not replacing $ variables for Execute Statement or Execute Selection .
    24. Regression: $variable$variable does not parse.
    25. $variable$variable does not parse for SQL Scripts.
    26. $variable$variable$variable does not parse for KogScripts.
    27. Case 21649: $(variable) followed by newline does not parse.
    28. Run kog script, drop database, run script, connect database, run script fails to pick up new script.
    29. Regression: crash with required script.
    30. Regression: trace only for first time required script runs.
    31. Regression: running kogscript in debug with required module crashes.
    32. Regression: KogScript not always single stepping into functions in required modules.
    33. Caller and callee required scripts should share a single QtLua::Console.
    34. Kogscripts should not create a script view for a non-existent required module.
    35. Try harder to remove temporary save files, and warn if they cannot be remove.
    36. Take the default font and font size from the UI font.
    37. KogScript running line highlight does not stay on line the whole time the SQL statement is executing.
    38. KogScript running line highlight does not stay on line the whole time the SQL statement is executing.
    39. show query times during long running queries and adds modules execution times to the base view.
    40. Add "(Paused At)" status in history, to show statement kog script is on while paused.
    41. Restored scripts are not lost on Console exit.
    42. KogScript run selection, pause, then run does not show script executing on correct lines.
    43. Don't create unnecessary Lua states.
    44. In-RAM status for views may be wrong if a dependency has not been loaded into the metadata tree.
    45. In-RAM status for views is not always updated when schema is expanded.
    46. Clean up statement handle after cancel, abort and when disconnecting.
    47. Change install order to try and avoid installer warning.
    48. Script hangs if ctrl+R used to run a script that has not been executed before.
    49. Occasional crash when calling a module the second time with a Lua parse error in it.
    50. Various library fixes:
      1. Improve SSL library.
      2. Improve shared library suffix guessing.
      3. Feature to extract values form load filename components.
      4. Support custom ways of saying “null” in a partition value.
      5. String to coldef improvement.
    51. $ variable not shown correctly when paused at single step.
    52. Crash in getErrors() after a SQL_STILL_EXECUTING error.
    53. Make doubly sure that ODBC handles have been allocated before using them.
    54. Crash if session queue handler is null.
    55. Don't mix up source files when single stepping kog scripts.
    56. Use SQL_MAX_MESSAGE_LENGTH for messages from the ODBC driver (longer messages).
    57. Missing ability to set max_rows missing for kogscript.exe
    58. Improve highlighting of kogscript executing line.
    59. Regression: shell() command has stopped working for KogScripts within Console.
    60. When closing Lua State clear other Kog Script views which have the same old Lua State.
    61. Regression: for KogScript when not Load Required Scripts, second SQL query causes script to abort
    62. Calling module causes lines in history to be wrong.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s180109

by MikeAtkinson » Mon Jan 15, 2018 8:49 am

New Features
    1. Allow selection from list of Script Environments for R and Python script editors.
    2. Various performance improvements:
      1. Avoid string copies in metadata queries.
      2. Improve performance of getting columns for results data.
    3. Context sensitive help now defaults to Kognitio 8.2.0
    4. Save log files with .log extension by default and show save file name in log tab.
Bug Fixes
    1. Add crash handler to QApplication::notify() as this existed the application without writing crash report.
    2. Views can have no dependencies and still be in RAM.
    3. Crash when destroying script with query still running.
    4. Python and R are not parsed correctly.
    5. Crash in Console when script results are destroyed while they are being displayed
    6. Regression: setting breakpoints broken if script not already run.
    7. Crash when displaying results.
    8. Invalidated views should not be coloured chocolate (all dependencies in RAM).
    9. Regression: SQL Script include has stopped working.
    10. Updated copyright to 2018.
    11. Fixed some compiler warnings.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s180327

by MikeAtkinson » Wed Apr 04, 2018 10:17 am

Bug Fixes
    1. Update Console messages for Kognitio 8.2.0
    2. Update Max OS-X build and release files.
    3. Improve SQL Script “shell” command.
    4. Slab Usage macro query wrong .
    5. Allow $(var) in SQL Queries.
    6. Refresh syntax colouring when changing to another script.
    7. wxunloader -N mustn't quote empty strings unless asked to.
    8. Fix change to wxunloader man page.
    9. Don't save a crash restore file for a script that has been restored.
    10. Ensure limit of open sessions to a database is respected.
    11. Update to use Qt 5.9.4
    12. Fix crash in ImplWxResults::getConstData()
    13. Remove backup save file for scripts that are closed without saving.
    14. Restoring metadata from cache has a bug in it which leads to the data in the wrong fields.
    15. Change CTRL-F5 to use 10 digits for session id
    16. Fix crash caused by change to use Qt 5.9.4
    17. Recalculate column sizes for contents tab after sort.
    18. Problems when recommissioning systems.
    19. Kog Scripts don’t run until edited (me).
    20. Dealing with special characters (UTF16) in Kogscript e.g. €
    21. $ at end of a string is not parsed correctly e.g. '$' or 'abc$', it is being interpreted as the start of a $ variable when it clearly cannot be.
    22. Object not deleted (just removed from UI) when database closed. (Multiple Diagram menus )
    23. Remove backup save file for scripts that are closed after saving.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s180411

by MikeAtkinson » Thu Apr 12, 2018 12:00 pm

Bug Fixes
    1. If Restored script is unedited when Console is closed still give an option to save it.
    2. Ask for "drop view" config option not initialised for new installation.
    3. Add option to always show "Systems" pane when connected.
    4. Resize Configuration tree panel depending on contents.
    5. Take note of combo box and any current extension when doing a save as ...
    6. Warn user when drop view or drop table actions fail.
    7. View can be coloured blue (has image) without image property being set for that view.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80200s180412

by MikeAtkinson » Thu Apr 12, 2018 12:01 pm

Major Features
  • KogScript
    1. Full Unicode within KogScripts, including variable names, strings and within SQL statements.
    2. New range syntax extension to Lua language
    3. Range module
    4. SQL module
    5. CSV module
    6. XSI module
    7. DataFrame module
    8. DateTime module
    9. Lanes QtLua Wrapper module
  • Git integration
    1. Stage (add), unstage current file
    2. Commit
    3. Fetch, pull and push for remote repository.
    4. Open git gui and gitk tools
  • Projects
    1. Create project
    2. Open project
  • Other
    1. Handle Ram Groups (Kognitio 8.2 feature) within Console.
    2. Improve Script Debug.
    3. Update to Lua 5.3.4 - a bugfix release.
    4. Add a find in table function for both table views and table widgets.
    5. Add coloured tabs to Console, so that it is possible to see ownership of tabs when connected to more than one Kognitio Analytical Platform.
    6. Add checking for script files changed outside Console and give option to load those instead.
    7. Logical view of Ram Stores for Memory Manager to complement existing Physical view.
    8. New 64 bit Linux console now built with Qt 5.9.3
    9. Built in ODBC configuration for Linux and Mac.
Minor Features
    1. Updated UI:
      1. Added Data and Admin menu-bar menus
      2. Moved items between menus
      3. Reduced icons on toolbar.
      4. Remove History pane, add historyTree to Logs pane.
      5. Added more tooltips for configuration.
    2. New user experience:
      1. Removed Logs and Query History from default layout.
      2. Added History to default layout (on left)
        1. Removed Contents, Index, Search and Open Docs panes from History
        2. “Show help for text under cursor” and “Show help buttons on dialogs” now enabled by default.
      3. Show Help pane by default.
    3. Added “Reset Kognitio Console configuration” to General options.
    4. Improvements to on-line documentation
    5. Update to use Qt 5.9.3 for Windows, Mac and Linux (all 64 bits), Windows 32 bit still uses Qt 4.7
    6. Syntax highlighting of external KogScript within S'kog( ... )kog'.
    7. Rename Script Variables to Script Debug to better reflect its purpose.
    8. Use CTRL+ALT+C to create a html version of a script and put it in the system clipboard.
    9. Add tooltip to MemoryManager showing node infor (cpu, bios, os, etc.).
    10. Handle Principal Name (kerberos support) in User Object View.
    11. Added Recently Used Objects list to Systems pane.
    12. Improve Slabs Diagram with Reclaim/Repack information.
    13. Enable check for updates by default for new Console users.
    14. Console qDebug() output now piped to Debug log (a UI to control this will be added soon).
    15. Update icons to new Kognitio logo.
    16. Added “Trace required scripts here”, which puts all trace lines from required scripts in the base script history.
    17. View dependencies not updated after running script statements.
    18. Save changes to script files, restore changes when restarting Console as a single edit.
    19. Update to latest Lua Lanes.
    20. Remember splitter positions for Sessions and Script views.
    21. Refactored KogRunner
    22. Allow $fn() in KogScripts
    23. Added low server overhead mode (and configuration option).
    24. Dependencies:
      1. Add tabs to Connector, Script Environment and External Script object views to show dependencies.
      2. Show connector that external table depends on within dependencies tab.
      3. Show connectors, external scripts and script environments that views depend on within dependencies tab.
      4. Show script environment that external scripts depend on within dependency tab.
    25. Improve activity log by adding when objects are destroyed and some activity counts.
    26. Performance improvement by using better containers, about 10% faster running queries and many metadata operations, about 5% smaller.
    27. Help:
      1. Update Help for 8.2
      2. Improve Help for Dialogs (especially Configuration) and Tools documents.
      3. Context sensitive help now defaults to Kognitio 8.2.0
      4. Improve context sensitive help for some SQL statements.
    28. Save log files with .log extension by default and show save file name in log tab.
    29. Update server messages for Kognitio 8.2.1
The following bug fixes are not in the latest 80199s180109 release.

Bug Fixes
    1. Handle recursive variable _index._index in script debug
    2. Crash in setVariable() due to using wrong luaState.
    3. Reset values in variables[] when doing resetColVariables with valid luaState.
    4. When switching views ensure that the new runningView has current kogRunner.
    5. Esc key does not work on Find / Replace dialog.
    6. Connector Object View not updated when shown.
    7. Fix warning: suggest parentheses around ‘&&’ within ‘||’.
    8. ScriptDebugItem SQL incorrect.
    9. Improve connection timeout.
    10. Don't override restored state for Slab Migration pane when "Don't show slab migration pane" configured false.
    11. Update ScriptRun text when ending script.
    12. Ensure NULL parent before deleting.
    13. Refactor to use new WxScript::ScriptType.
    14. Improve resizing of resultset columns/rows.
    15. When single stepping and running try to keep entire statement visible.
    16. Close luaState when switching to SQL script.
    17. Typo "adim" in Connection dialog.
    18. Don't show ram used in Problem Queries tool when transaction (crtrans) is -1.
    19. SQL_NEED_DATA is not an error, but treat it as such when running KogScripts.
    20. Session combo switching from <current> when it shouldn't.
    21. Only close luaState if the script has one, SQL scripts don't.
    22. Console metadata queries should not end in a ;
    23. Free database ODBC handle when closing database.
    24. Running KogScript query when disconnected, then connect to database, still gives disconnected error.
    25. Remove Don't show the Messages/Query History Pane config, as they are no longer panes.
    26. Crash running KogScript due to invalid luaState.
    27. Regression: KogScript.exe now crashes.
    28. Crash if runningView->currentStatementLastExecutableToken is not set.
    29. Show elapsed time for query in script run total time.
    30. Substitute $variables in History for SQL expressions in KogScripts.
    31. Occasional spurious character at end of execute selection.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80200s180416

by MikeAtkinson » Mon Apr 16, 2018 5:16 pm

This version from the feature branch fixes a regression and a few minor issues.

Bug Fixes
    1. Regression: ad-hoc queries were locking up and not completing.
    2. Improve “contract” icon.
    3. Improve expansion of the results pane, especially for ad-hoc queries.
    4. Add a configuration option in “SQL” of “Expand results pan when executing query” (default false)
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s180524 (bugfix)

by MikeAtkinson » Tue May 29, 2018 9:33 am

This release is from the bugfix branch and fixes five problems with the legacy stable (bugfix) version.

Bug Fixes
    1. Fix race condition when disconnecting while statements still executing
    2. Get “ET010F” info from IPE_CONV_ERROR
    3. Syntax colour LISTAGG function
    4. Initial save of file does not work if "Copy previous file on save to name with ~ on the end" config option set.
    5. os.exit() fails due to incorrect index into Lua stack to detect usage within Console, leading to crashes in kogscript standalone
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Console Version 80199s180531 (Bugfix)

by MikeAtkinson » Thu May 31, 2018 6:58 pm

This release is from the bugfix branch and fixes a regression with the previous version of the legacy stable (bugfix) version.

Bug Fixes
    1. "Get “ET010F” info from IPE_CONV_ERROR" caused regression
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Console Version 80199s180711 (bugfix)

by MikeAtkinson » Wed Aug 29, 2018 3:07 pm

Bug Fixes
    1. Dollar expressions limited to about 100 in KogScript SQL statements.
    2. Fix occasional crash which is shown up when running against Qt 5.11.0
New Feaure
    1. Display DISK ONLY tables within the metadata tree.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Console Version 80200s180711 (feature release update)

by MikeAtkinson » Wed Aug 29, 2018 3:07 pm

New Feaure
    1. Display DISK ONLY tables within the metadata tree.
Bug Fixes
    1. Fix race condition when disconnecting while statements still executing
    2. Uninitialised variables in KognitioDependenciesItem
    3. Get “ET010F” info from IPE_CONV_ERROR
    4. Syntax colour LISTAGG function
    5. Initial save of file does not work if "Copy previous file on save to name with ~ on the end" config option set.
    6. Case 21892: os.exit() fails due to incorrect index into Lua stack to detect usage within Console
    7. Dollar expressions limited to about 100 in KogScript SQL statements.
    8. Fix occasional crash which is shown up when running against Qt 5.11.0
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Console Version 80200s180815 (feature release update)

by MikeAtkinson » Wed Aug 29, 2018 3:08 pm

New Feaure
    1. Fully contract results pane to a button
Bug Fixes
    1. Fix potential null pointer error.
    2. In KogScript seconds within expanded timestamp structure should be doubles.
    3. Don’t try and find find help for empty table name.
    4. Arrays with one element are not expanded in the Script Debug tree.
    5. Case 21933: Queues used for more than 99 days causes RS0088 error in Console queues.
    6. Column comments with new lines in them are not shown as an empty string if they start with a new line.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80199s190510 (Legacy Bugfix)

by MikeAtkinson » Fri May 24, 2019 11:35 am

Bug Fixes
  1. Update to use Qt 5.12.2 (this pulls in various bug fixes in this long term support Qt).
  2. Case 21933: queues used for more than 99 days causes RS0088 error in Console queries.
  3. Column comments with new lines in them are not shown as an empty string if they start with a new line.
  4. Fix kogscript.exe banner.
  5. sqlProc may be NULL in QueriedItem::abortItem().
  6. When opening a SQL script, set textChangedSinceLastRun so that it will be parsed before trying to run it.
  7. When returning from an included script copy updated script variables back into the parent script context.
  8. Aborting/cancelling jobs while SQLProcessor is exiting may lead to crash
  9. Add various fixes from trunk for Database, SQLProcessor and SQLExecutor:
    1. Fully lock access to KogntioSQLExecutor - this is the main fix for this issue
    2. Crash while trying to log into a server that had not finished booting. - a similar crash to this issue
    3. Improve performance of metadata queries. - avoid some unnecessary std::wstring copies
    4. Don't try and obtain SQL errors from invalid handle. - fixes crash seen in other branches.
    5. Free database ODBC handle when closing database. - fixes memory leak which may cause poor performance when physical memory is low.
    6. Tidy up SQLProcessor/SQLExecutor. - fixes various potential crashes
    7. Crash in SQLProcessor::setSingleConnectionMode(). - fixes potential crash
    8. Handle Kognitio stop start while connected - a similar crash to this issue
    9. Fix crash caused by using QCoreApplication::instance()->thread(). - crash when built against latest Qt.
    10. When application is shutting down don't move objects to its thread. - Console shutdown crash
    11. Crash when deleting a TableModel child and the model is already empty. - crash when built against latest Qt.
    12. Improve performance by using QVector and QHash. - just in SQLProcessor and SQLExecutor
    13. Change conntect() to connectToServer() and disconnect() to disconnectDatabase() to avoid confusion with Qt connect and disconnect. - needed for Qt Creator debugging for recent Qt versions.
  10. Update Console copyright to 2019.
  11. query history shows garbled query when "Execute from cursor" selected.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80200s190510 (Bugfix Release)

by MikeAtkinson » Fri May 24, 2019 11:49 am

New Feaures
    1. Improve Version Check tool.
    2. Update to use Qt 5.12.2 (this pulls in various bug fixes in this long term support Qt).
    3. Show when KogScript is continuing.
Bug Fixes
    1. Crash while trying to log into a server that had not finished booting.
    2. sqlProc may be NULL in QueriedItem::abortItem().
    3. "Go To Error" button not enabled when error offset is available.
    4. If save fails then don't set the editor to unchanged.
    5. Missing break in case statement in MainWindow::actionTriggered().
    6. Crash/Hang when doing a drop schema.
    7. HTML escape statements when displaying in log pane.
    8. Fix crash in Script Error Widget.
    9. Possibly fix crash when creating a subscript.
    10. Crash in ErrorWidget::showScriptDebug().
    11. Don't query IPE_SCRIPT_DEBUG on data conversion errors.
    12. Querying IPE_CONV_ERROR may take a long time.
    13. If a statement already has an error don't set it to Complete in query history.
    14. Don't allow Git Integration when switched off in configuration.
    15. Add in code to detect missing or out-of-date dbghelp.dll when creating crash reports.
    16. When PrettyPrinting DECIMAL(x,y) don't line split at comma.
    17. Error message incorrect: goto <label> is followed by optional ';' (not ':').
    18. Arithmetic overflow in Console's CTRL+F4 query (previous CTRL+F4 was not updated).
    19. Stringify asserts that fail for Console activity log.
    20. When a queried item is cancelled insert a warning (not an error) into the messages log.
    21. Crash when doing a "lock system" with "reduce overhead on Kognitio server" config option set.
    22. Only remove col<n>[str] variables when executing the next SQL statement.
    23. Regression: update to Lua 5.3.5 broke aborting KogScripts.
    24. Saving script chooses wrong default based on its type.
    25. Don't allow changing the script type while the script is paused.
    26. Query History shows garbled query when "Execute from cursor" selected.
    27. SQL Script commands that are not SQL statements cause abort.
    28. Regression: Existing SQL results not used when evaluating whether to continue SQL Script.
    29. When opening a SQL script, set textChangedSinceLastRun so that it will be parsed before trying to run it.
    30. When returning from an included script copy updated script variables back into the parent script context.
    31. Highlight all lines in KogScript SQL statement when it is selected in Query History.
    32. PMA full alert should take into account query temp table usage.
    33. Crash when deleting a TableModel child and the model is already empty.
    34. PACKED_MSG_32_64 macro should only be defined for GCC Linux.
    35. Aborting/cancelling jobs while SQLProcessor is exiting may lead to crash.
    36. Crash after removing ScriptResult that was still in use.
    37. The wrong lines are highlighted when subscript is executed.
    38. Fix crash in ScriptDebugView due to null scriptView.
    39. Add "Close" button to the "About" dialog.
    40. Update Console copyright to 2019.
    41. For Kogscript while single stepping/paused “Execute To Cursor” and “Execute From Cursor” menu options are enabled.
    42. Single step Kogscript then stop/abort, then “Execute Selection” -> crash.
    43. Kogscript “Execute”, followed by “Execute To Cursor” does not stop at cursor.
    44. Query history shows garbled query when "Execute from cursor" selected.
Reply with quote Top
Contributor
Offline
Posts: 183
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Version 80203s190510 (Release)

by MikeAtkinson » Fri May 24, 2019 11:50 am

New Feaure
    1. Improve Version Check tool.
    2. Improve Query Analyser with breakable and uncommitted info. (8.2.3)
    3. Use 64 bit version of ssleay32.dll and libeay32.dll so that https can be used.
    4. Phone Home support in Console. (8.2.2)
    5. Add ability to show diagnose json for statements when running a script (8.2.3)
    6. Add Imaging Queues support to Console. (8.2.3)
    7. Add hoovering of IMAGE_GENERATION_NUM to Console, display on Table and View Object Views. (8.2.3)
    8. Add Copy All Info to Copy All Formatted.
    9. Update to use Qt 5.12.2
    10. KogScript $ variables in SQL can now have array indexes (e.g $z[1] )
    11. When copy&paste from a table view into a SQL editor add /* */ comment around text.
    12. Use IPE_KEYWORDS to determine SQL keywords used by database for syntax highlighting.
    13. Make various hard coded keyboard shortcut actions for script editors configurable.
    14. Improve query builder to handle ‘in’ and ‘lile’ correctly.
    15. Add in code to detect missing or out-of-date dbghelp.dll when creating crash reports.
    16. Add Go To Line dialog.
    17. Use sphinx built help and use web for 8.2.3 help.
    18. Syntax highlight SQL data types.
    19. Another try at fixing the wrong script window size.
    20. Alternate sets of syntax colours.
    21. Loader improvements.
    22. Add config option to expand dollar variables in query history.
    23. Show when KogScript is continuing.
Bug Fixes
    1. External Data Browser can crash if results data item deleted before it is complete.
    2. Avoid crash in using SQLParser results.
    3. gotDbPatchLevel not initialised leading to patch level not being obtained from server.
    4. Console configuration item "Reduce overhead on Kognitio servers" does not update config correctly.
    5. Diagnose widget for KogScript diagnose option not displayed.
    6. Improve addition of sqlEdit to script view. (Kim)
    7. Regression: SQL script no longer displays SQL script variables for debugging.
    8. Single step in Kog Scripts should halt on next SQL statement if "Trace Kog Script lines" not set.
    9. Only remove col<n>[str] variables when executing the next SQL statement.
    10. Crash when doing a “lock system” with “reduced overhead on Kognitio Server” configuration option set.
    11. Fix various regressions in running KogScript
    12. When a queried item is cancelled insert a warning (not an error) into the messages.
    13. Qt Creator warnings:
      1. Fix various warnings from Clang compiler in scriptengmock.
      2. Remove lots of warnings from QtCreator about 0 begin used as NULL (use nullptr instead).
      3. Remove lots of warnings from QtCreator about old style casts.
      4. Remove lots of warnings from QtCreator about signed/unsigned conversions and reduction in precision.
      5. Add various asserts to check that expected conditions actually hold true.
      6. Use typedef types POSITION_IN_TEXT, LINE_NUMBER and COLUMN_NUMBER, with the special value of static_cast<size_t>(-1) meaning INVALID_POSITION or INVALID_LINE.
      7. Use dynamic_cast<type>() followed by if statement in a few places to ensure QObjects are really the type expected.
      8. Add checks for NULL pointers in a few places.
      9. Fix reductions in accuracy or potential overflows due to the casts.
      10. A couple of missing break statements in case statements and various fallthroughs not annotated.
      11. Use of || when it should have been | to or together flag values.
      12. Use of , instead of ; to end a statement in one place.
      13. Comparision of LINE_NUMBER variable with >= 0 when it should have been != INVALID_LINE
      14. Fix warnings from Clang compiler (correct fixes).
    14. Kognitio Node Item may have empty manufacturer, product, serial number, etc.
    15. Add virtual destructors to classes with pure virtual functions.
    16. Crash when creating a subscript. (Kim)
    17. Arithmetic overflow in Console's CTRL+F4 query. (Kim)
    18. Arithmetic overflow in Console's CTRL+F4 query (previous CTRL+F4 was not updated)
    19. Stringify asserts that fail for Console activity log
    20. sqlProc may be NULL in QueriedItem::abortItem()
    21. PERFORMANCE REGRESSION: updating a view which has no image to still have no image is slow.
    22. PERFORMANCE REGRESSION: no need to emit itemChanged(view) when updating the view dependencies.
    23. Error message incorrect: goto <label> is followed by optional ';' (not ':')
    24. When PrettyPrinting DECIMAL(x,y) don't line split at comma.
    25. Improve extraction of substring from SQL Script.
    26. Debug for Scripts was not always being shown on an external scripting error.
    27. Handle paste from Excel as a special case as it encloses the string with a " and replaces " with "".
    28. gputils no longer compiles for Console on Linux.
    29. Update Console copyright to 2019.
    30. Fix warning about using the wrong type in swprintf().
    31. If a statement already has an error don't set it to Complete in query history.
    32. Add 8.2.0 help files on Mac OS-X.
    33. Views can be unloaded, so set view name when opening the Unloader dialog.
    34. Improve format of Script Error pane.
    35. If the script debug info is not available in 2 seconds then abort query and show push button on script Error pane.
    36. Use function to convert from int position to POSITION_IN_TEXT (which ensures invalid positions are correctly handled).
    37. Define Q_GENERAL_ASSERT() outside KOGNITIO_CONSOLE so it can be used in helpfile generator.
    38. Don't query IPE_SCRIPT_DEBUG on data conversion errors.
    39. Improve helpfile generator to use Sphinx generated QHelp files.
    40. Querying IPE_CONV_ERROR may take a long time.
    41. Use the ScriptResults to remember whether extra info has been obtained for a failed script query.
    42. History tree does not show correct statement when executing a selection or query under cursor.
    43. Remember results of IPE_SCRIPT_DEBUG in ScriptResults for a statement.
    44. Only reinitialise Lua when running script from start.
    45. Ensure script view is always set for ErrorWidget.
    46. Selecting a query in the Query History highlights wrong query, etc.
    47. Crash in ErrorWidget::showScriptDebug().
    48. Statement preceded by a comment has that comment prepended to the statement in the Query History.
    49. Improve query builder.
    50. Fix crash in Script Error Widget.
    51. Fix occasional missing script error pane.
    52. Possibly fix crash when creating a subscript.
    53. Put the user's help files into ~/.wxconsole/help on Linux
    54. Update user’s help files and index when doing a Console update or new installation.
    55. Setting the default help collection now re-indexes the collection.
    56. Put the user's help files into ~/.wxconsole/help on Linux.
    57. Enable setting the default help collection on IMac.
    58. Drag and drop from history highlights the wrong line in the script editor.
    59. Execute statement puts the wrong statement text into query history.
    60. HTML escape statements when displaying in log pane.
    61. After single step of SQL script wrong line highlighted.
    62. Top toolbar is black on Mac OS-X.
    63. Crash/Hang when doing a drop schema.
    64. Check QT_VERSION when deciding whether to reset window state on update.
    65. Missing break in case statement in MainWindow::actionTriggered().
    66. “Log” dock not inserted as a dock widget if the window state could not be restored.
    67. Add an extra ';' at the end of Kog Scripts, so that the last SQL statement does not have to end with a ';'
    68. If save fails then don't set the editor to unchanged.
    69. Regression: update to Lua 5.3.5 broke aborting Kog Scripts.
    70. Saving script chooses wrong default based on its type.
    71. image_generation_num not obtained in all table metadata queries.
    72. Don't allow changing the script type while the script is paused.
    73. Query history shows garbled query when "Execute from cursor" selected for SQL Scripts.
    74. Don't block the UI when aborting a SQL Script.
    75. Regression: SQL Script commands that are not SQL statements cause abort.
    76. Regression: Existing SQL results not used when evaluating whether to continue SQL Script.
    77. When opening a SQL script, set textChangedSinceLastRun so that it will be parsed before trying to run it.
    78. When returning from an included script copy updated script variables back into the parent script context.
    79. Highlight all lines in KogScript SQL statement when it is selected in Query History.
    80. PMA full alert should take into account query temp table usage.
    81. Crash when deleting a TableModel child and the model is already empty.
    82. PACKED_MSG_32_64 macro should only be defined for GCC Linux.
    83. Aborting/cancelling jobs while SQLProcessor is exiting may lead to crash.
    84. Crash after removing ScriptResult that was still in use.
    85. The wrong lines are highlighted when subscript is executed.
    86. Fix crash in ScriptDebugView due to null scriptView.
    87. Crash after removing ScriptResult that was still in use.
    88. Add "Close" button to the "About" dialog.
    89. For Kogscript while single stepping/paused “Execute To Cursor” and “Execute From Cursor” menu options are enabled.
    90. Single step Kogscript then stop/abort, then “Execute Selection” -> crash.
    91. Kogscript “Execute”, followed by “Execute To Cursor” does not stop at cursor.
    92. For Kogscripts executing a selection that has a Lua statement (without a training ‘;’) as the last line causes that line to be wrong in the history.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron