Open Teradata Viewer Changelog

What's new in Open Teradata Viewer 0.30b

Jul 3, 2019
  • Added CSV syntax highlighting. Alternating columns are colored differently to
  • easily distinguish them when viewing as plain text.
  • Upgraded rsyntaxtextarea library 3.0.2 -> 3.0.3
  • Upgraded Teradata JDBC driver 16.20.00.10 -> 16.20.00.12
  • Upgraded jsqlparser library 1.3 -> 2.0
  • Upgraded poi library 4.0.1 -> 4.1.0

New in Open Teradata Viewer 0.30a (Feb 19, 2019)

  • Upgraded rsyntaxtextarea library 3.0.1 -> 3.0.2

New in Open Teradata Viewer 0.29c (Jan 29, 2019)

  • Added Lua syntax highlighting.
  • Upgraded rsyntaxtextarea library 2.6.1 -> 3.0.1
  • RSyntaxTextArea now compiles against Java 8.
  • "Copy as RTF" action changed to "Copy as Styled Text", and now copies as either HTML or RTF, depending on the drop target. Now more compatible with Microsoft Word, Outlook and other applications.
  • Simple YAML code folding, based on indentation.
  • Fixed a few minor bugs.
  • Upgraded languagesupport library 2.6.0 -> 3.0.0
  • RSTALanguageSupport: This release brings the minimum required JRE to Java 8.
  • Upgraded spellchecker library 2.6.0 -> 3.0.0
  • SpellChecker: This release brings the minimum required JRE to Java 8.
  • Upgraded rstaui library 2.6.1 -> 3.0.0
  • RSTAUI: This release brings the minimum required JRE to Java 8.
  • Upgraded autocomplete library 2.6.1 -> 3.0.0
  • AutoComplete: This release bumps the minimum required JRE to Java 8 and makes minor changes to support RSyntaxTextArea 3.0.1.
  • Upgraded jsqlparser library 1.3 -> 1.4

New in Open Teradata Viewer 0.29b (Dec 20, 2018)

  • Added the "Calculate the SHA1 Checksum of a file" action and the suited menu voice.
  • Added the "Calculate the SHA1 Checksum of the selected text" action and the suited menu voice.
  • Added unit tests for the "Calculate the SHA1 Checksum of the selected text" functionality.
  • Upgraded Teradata JDBC driver 16.20.00.06 -> 16.20.00.10
  • Upgraded joda-time library 2.9.9 -> 2.10.1
  • Upgraded poi library 4.0.0 -> 4.0.1
  • Upgraded rhino library 1.7.9 -> 1.7.10

New in Open Teradata Viewer 0.29a (Oct 22, 2018)

  • Fixed the "Insert" action to add a new record to an empty table.

New in Open Teradata Viewer 0.28c (Oct 22, 2018)

  • Added the "Calculate the MD5 Checksum" action and the suited menu voice.
  • Added the detector of the name of the columns of the ORACLE tables. The preferred keystroke to bind the action "SELECT * FROM .." is still Ctrl+S (Cmd+S on Mac). This functionality can be used only when connected to an ORACLE database.

New in Open Teradata Viewer 0.28b (Oct 22, 2018)

  • The preferred keystroke to bind the action To upper case is Ctrl+Shift+U (Cmd+Shift+U on Mac).
  • The preferred keystroke to bind the action To lower case is Ctrl+Shift+L (Cmd+Shift+L on Mac).
  • TextArea.font uses the monospaced Font.
  • Upgraded itext library 5.5.12 -> 5.5.13

New in Open Teradata Viewer 0.28a (Oct 22, 2018)

  • Changed the default Font size of the Swing components.
  • The preferred keystroke to bind the action Comment is Ctrl+7 (Cmd+7 on Mac).
  • The preferred keystroke to bind the action Uncomment is Ctrl+Shift+7 (Cmd+Shift+7 on Mac).
  • The preferred keystroke to bind the action Invert case is Ctrl+Shift+I (Cmd+Shift+I on Mac).
  • Upgraded jsqlparser library 1.2 -> 1.3

New in Open Teradata Viewer 0.27c (Oct 22, 2018)

  • Fixed the "Edit" action to edit the selected record of the result set.
  • Changed the Font of the comments used by the default style of the text editor.

New in Open Teradata Viewer 0.27b (Oct 22, 2018)

  • Changed the style of the text editor programmatically.
  • Upgraded Teradata JDBC driver 16.20.00.06 -> 16.20.00.08
  • Upgraded poi library 3.17 -> 4.0.0

New in Open Teradata Viewer 0.27a (May 16, 2018)

  • Fixed an issue with the macros menu: folders are ignored.
  • Upgraded jsqlparser library 1.1 -> 1.2

New in Open Teradata Viewer 0.26c (May 8, 2018)

  • The "Look and Feel" menu is scrollable.
  • The "View As (Highlighting File Type)" sub-menu is scrollable.
  • The "Macros" menu is scrollable.

New in Open Teradata Viewer 0.25c (May 3, 2018)

  • Added the macro support and the suited menu voices. You can write the macros in JavaScript and Groovy.
  • The user manual has been updated with the added capabilities.

New in Open Teradata Viewer 0.25b (Mar 26, 2018)

  • Added the "Pretty print (XML only - with line breaks)" action and the suited menu voice.
  • Added unit tests for the "Pretty print (XML only - with line breaks)" functionality.
  • Tabs are emulated by spaces initially.
  • Upgraded Teradata JDBC driver 16.20.00.04 -> 16.20.00.06

New in Open Teradata Viewer 0.25a (Feb 26, 2018)

  • Fixed a bug of the UI: if the user interrupts the execution of the SQL
  • statement by clicking the Cancel command button, the client can execute another SQL
  • statement.
  • Upgraded Teradata JDBC driver 16.10.00.03 -> 16.20.00.04
  • Upgraded itext library 5.5.11 -> 5.5.12
  • Upgraded joda-time library 2.4 -> 2.9.9
  • Upgraded poi library 3.16 -> 3.17

New in Open Teradata Viewer 0.24b (Oct 7, 2015)

  • Added less syntax highlighting and code folding.
  • Improved default key bindings on OS X.
  • Adds removed TextArea constructors.
  • Added unit tests for CSS syntax highlighting.
  • SyntaxTextArea.setBackground(null) throw NPE.
  • setBackground() does not work on ErrorStrip.
  • ErrorStrip marked occurrences on line 0 have top 2 pixels cut off.
  • Fixed error marker displacement in TaskTagParser.
  • Added support for highlighting JSON keys as IToken.VARIABLE.
  • Fix: macro name is lost at saving to file.
  • Cleaned up warnings in previously generated JSONTokenMaker source file.
  • Added 'mark occurrences' of variables in less files.
  • Fixed broken unit test of the text editor.
  • Fixed infinite loop in HtmlFoldParser.
  • Fix: accidentally forgot code folding for .jshintrc files.
  • Removed some compiler warnings.
  • Removed System.out.println from HTML fold parser.
  • Fixes an occasional sorting bug when there were many completions representing functions or methods. FunctionCompletions with the same name should compare based on number of arguments as well.
  • Added code completions for standard Less functions.
  • Don't print IOExceptions to the application console.
  • Fixed a minor issue.
  • Improved interval expression syntax of the SQL parser.
  • Added support of hex values (0xabc54, x'abc567') to the SQL parser.
  • Added support of system parameters (e.g. @@SPID) to the SQL parser.
  • Added support of signed parameters to the SQL parser.
  • Added support for SELECT SKIP FIRST ... to the SQL parser.
  • Completely rewritten S_IDENTIFIER rule of the SQL parser to accept hopefully all possible UTF-8 letters without specifying some additional rules.
  • Allow Server within multipart names of the SQL parser to act as database link.
  • Added support for row constructors in conditions to the SQL parser.
  • Some refactorings for TablesNamesFinder to improve usability of the SQL parser.
  • Established JJTree nodes for columns and tables (look at SelectASTTest) for first usages of the SQL parser.
  • Added support for MySQL GROUP_CONCAT to the SQL parser.
  • Upgraded itext library 5.5.6 -> 5.5.7
  • Upgraded Teradata JDBC driver 15.10.00.05 -> 15.10.00.09

New in Open Teradata Viewer 0.24a (Jun 27, 2015)

  • Added MXML syntax highlighting and code folding.
  • Added unit tests.
  • Added unit tests for Ruby.
  • Added unit tests for D, Dart and Groovy.
  • Fixed some doclint errors.
  • JavaScript: jshint support now allows scanning parent directory tree for .jshintrc.
  • Global types such as 'Math' were not recognized.
  • Added a message to stdout when java.net.URI is selected in code completion window.
  • Java: Fixed most compiler warnings.
  • Fixed Java 8 signatures parsing.
  • Added bootstrap support.
  • Added support for Java 8 invoke dynamic constants.
  • CSS: Added completions for font-related and other miscellaneous properties.

New in Open Teradata Viewer 0.23c (May 29, 2015)

  • Added Ruby syntax highlighting.
  • Added Scala syntax highlighting.
  • Added support for ORACLE, DB2, MySQL, SQLite, HSQLDB, H2, Derby, SQL Server and other databases.
  • The scrollbar was not displayed, the tooltip was huge and flowed on the other screen, if the user uses two monitors and a long HTML text is entered in the text editor.
  • Removed printing to stdout in TextAreaBase.
  • Removed accidentally added printf for debugging purposes.
  • Added unit tests for OTVDocument and SyntaxDocument.
  • Added unit test for Gutter.
  • FileLocation.create(String) creates URLFileLocations if appropriate; passing a parameter of the form "ftp://[email protected]/path/file.java returned an (incorrect) FileFileLocation, not a URLFileLocation.
  • Improved support for non-opaque editors. Now the rendering engine of the editor paints bracket matching, line highlights etc.., even if the editor is not opaque.
  • Formatting changes to translucent SyntaxTextAreas.
  • Added unit tests for Theme class and fixed a couple of bugs in it.
  • DumbCompleteWordAction didn't allow digits in word names.
  • Added unit tests.
  • Added unit tests for SyntaxTextArea and DocumentRange.
  • .jshintrc files need their own highlighting since they allow EOL comments.
  • Added unit tests for JavaScript, PHP and plain text scanners.
  • Code folding was not enabled with specific instantiation pattern.
  • Added unit tests for UnixShellTokenMaker.
  • Fixed all doclint errors and some doclint warnings for folks compiling with JDK 8. Only remaining warnings are from JFLex's skeleton file.
  • Added first support for user variables to the SQL parser.
  • Added support for within group expressions to the SQL parser, e.g. ORACLE's LISTAGG function.
  • Added support for inner with statements to the SQL parser.
  • Improved interval expression support of the SQL parser.
  • Added support for KEEP to the SQL parser.
  • Added support for ILIKE to the SQL parser.
  • Added support for LEFT/RIGHT as function names to the SQL parser.
  • Added support for UPDATE OF table to the SQL parser.
  • API changes due to grammar refactoring of the SQL parser.
  • Added first support for PostgreSQL arrays to the SQL parser. Some quoted identifier rules for SQL Server had to be changed in the SQL parser.
  • Added support for with recursive to the SQL parser.
  • Support for ORACLE's old join syntax has been improved in the SQL parser.
  • Added first support for numeric bind to the SQL parser.
  • Added support for keywords as column names in CREATE TABLE statements to the SQL parser.
  • Included a huge amount of ORACLE test SQLs. There is much room to improve support for the ORACLE special syntax.
  • Upgraded Teradata JDBC driver 15.00.00.20 -> 15.10.00.05
  • Upgraded itext library 5.5.4 -> 5.5.6
  • Upgraded looks library 2.6.0 -> 2.8.0
  • Upgraded poi library 3.10.1 -> 3.12
  • Upgraded rhino library 1.7R4 -> 1.7.6

New in Open Teradata Viewer 0.23b (Dec 16, 2014)

  • Added Lisp syntax highlighting and code folding.
  • This release fixes a performance problem when painting tokens with background colors specified on OS X; token background color painting was slow on OS X.
  • Minor improvements to dark theme.
  • Fixed the cursor problem after SyntaxTextArea.setMargin.
  • Line numbers, code folds and marked occurrences now update appropriately if an STA instance's document is switched out via setDocument\(\).
  • Tokens don't need to specify tags in their HTML representations if they are whitespace.
  • Added a LanguageSupport Demo to more easily test layered highlights.
  • Fixed exception in JavaOutlineTree.
  • Improving comment.
  • Fixed NPE in JavaScriptLanguageSupport tree.
  • Added support for collections to the SQL parser.
  • Upgraded itext library 5.5.3 -> 5.5.4

New in Open Teradata Viewer 0.23a (Nov 26, 2014)

  • Added x86 assembly syntax highlighting.
  • Added C++ syntax highlighting and code folding.
  • Added C# syntax highlighting.
  • Added D syntax highlighting.
  • Added Dart syntax highlighting.
  • Added JSON syntax highlighting and code folding.
  • Added Visual Basic syntax highlighting.
  • Added Windows batch syntax highlighting.
  • Fixed an issue with the SQL editor: non-layered highlights for selection caused an extra character to be painted as in 'selected' region.
  • Added language-specific word selection/navigation.
  • Better keyboard navigation on OS X.
  • Allow ITokenMaker implementation from external .jar.
  • C and C++ should treat '\e' as a valid escape sequence.
  • JavaScript highlighting doesn't automatically close multi-line comments.
  • Disallow font being set to size == 0.
  • Clipboard History popup via Ctrl+Shift+V (Cmd+Shift+V on Mac).
  • Moving selectAndPossiblyCenter\(\) to a public static method in SyntaxUtilities so others can consume.
  • Current line highlight not set if STA not yet visible.
  • Minor documentation update.
  • Use STA.markOccurencesColor in ErrorStrip instead of hardcoded value.
  • Added the ability to programmatically change the parser delay.
  • 'Matched bracket' highlight not updated if displayed when increasing or decreasing font size.
  • Silent exceptions when using left and right arrow keys in empty document with code folding.
  • Fixed off-by-one errors in ErrorStrip.
  • Ensure 'go to member' window's tree has at least a very small top empty border, to keep things looking nice.
  • Going to text via 'Go to member' popup should call selectAndPossiblyCenter\(\).
  • Stack trace in JavaScriptOutlineTree.
  • JS: Removing a few compiler warnings.
  • XML: Very basic code completion for XML.
  • XML simple code completion should not suggest attributes already specified for an element.
  • Added simple support for EXECUTE to the SQL parser.
  • Improved support for select into clause of the SQL parser.
  • Improved support for insert table using with clause of the SQL parser.
  • Added support for "limit 0" and "limit null" clause to the SQL parser.
  • Window functions of the SQL parser now allow simple expressions for partition by.
  • Added support for create table as select syntax to the SQL parser.
  • Added first simple support of JSON syntax to the SQL parser.
  • Added support for returning for insert statements to the SQL parser.
  • Added support for multitable update statements to the SQL parser.
  • Added partial support for OFFSET ... FETCH ... to the SQL parser.
  • Added first support for *FOR UPDATE* to the SQL parser.
  • Added support for ANY - array syntax to the SQL parser.
  • Introduced additional parameters for create table statements (deparser extended) in the SQL parser.
  • Upgraded Teradata JDBC driver 15.00.00.15 -> 15.00.00.20
  • Upgraded poi library 3.10 -> 3.10.1
  • Upgraded itext library 5.5.1 -> 5.5.3
  • Upgraded joda-time library 2.3 -> 2.4

New in Open Teradata Viewer 0.22c (Jul 1, 2014)

  • Improvements to PHP syntax highlighting.
  • In HTML and XML, "mark occurrences" should match tag names even when the caret is in an attribute, not just when it is in the tag name itself.
  • Java syntax highlighting updated for other Java 8 classes, interfaces, and enums.
  • SQL: Matching opening/closing parens are now highlighted.
  • Improvements to CSS code completion.
  • Improvements to PHP code completion. Documentation for many functions is now included.
  • JavaScriptOutlineTree now understands basic JavaScript OO paradigms much better.
  • This release brings minor performance improvements to the spell checker.
  • Added support for some keyword object names to the SQL parser.
  • Added support for named primary keys to create table statements of the SQL parser.
  • Added adapter classes for visitor interfaces to the SQL parser to simplify visitor usage.
  • Added pivot support for subqueries to the SQL parser.
  • Added Character Set support to the SQL parser.
  • Added lax test utils to the SQL parser.
  • Added some Teradata test SQLs to the SQL parser.
  • Improved COUNT(ALL expr) support of the SQL parser.
  • Fixed "!=" support to not give "" while deparsing with the SQL parser.
  • Fixed toString() for window elements of the SQL parser.
  • Fixed several bugs.
  • Upgraded itext library 5.5.0 -> 5.5.1

New in Open Teradata Viewer 0.22b (May 6, 2014)

  • Added the Python syntax highlighting.
  • Added the NSIS syntax highlighting.
  • Added the UNIX shell scripting language syntax highlighting.
  • Added the Perl syntax highlighting.
  • Added the Groovy syntax highlighting.
  • Upgraded Teradata JDBC driver 14.10.00.26 -> 15.00.00.15

New in Open Teradata Viewer 0.22a (Apr 4, 2014)

  • Added the HTML syntax highlighting.
  • Added the PHP syntax highlighting.
  • Added the JSP syntax highlighting.

New in Open Teradata Viewer 0.21c (Mar 15, 2014)

  • Added the XML syntax highlighting.
  • Added the CSS syntax highlighting.
  • Whether or not curly braces denote code blocks is now handled on a language-index level, not per ITokenMaker.
  • Java syntax highlighting updated for Java 8 classes, interfaces and enums.
  • The SearchEngine class now automatically selects the next match after a Replace operation.
  • The JavaScript language support can now use JSHint for its squiggle underlining of errors and warnings. A .jshintrc file can be specified to override the default JSHint behavior.
  • Fixed several bugs.
  • Upgraded forms library 1.7.2 -> 1.8.0
  • Upgraded looks library 2.5.3 -> 2.6.0

New in Open Teradata Viewer 0.21b (Feb 28, 2014)

  • Added first multi-statements or script support to the SQL parser.
  • Added backported window option from fork to analytic expression of the SQL parser.
  • Added NULLS FIRST and NULLS LAST to order by clause of the SQL parser.
  • Improved parsing of top clause of the SQL parser.
  • Improved support for multi-part names of the SQL parser.
  • Improved support for signed expressions of the SQL parser. The sign is stored in the parse tree.
  • Added CCSqlParserUtil.parseExpression to the SQL parser to parse a simple expression. Now you can build expressions from a String like "a+b".
  • Improved SelectUtils of the SQL parser to build simple select statements.
  • Upgraded Teradata JDBC driver 14.10.00.17 -> 14.10.00.26
  • Upgraded poi library 3.9 -> 3.10
  • Upgraded itext library 5.4.5 -> 5.5.0

New in Open Teradata Viewer 0.21a (Jan 25, 2014)

  • Started a simple utility class for the SQL parser, SelectUtils, to collect basic select modification tools:
  • addExpression adds a new expression to the select list;
  • addJoin adds a new join to the select.
  • Added support for optional " AS " for aliases to the SQL parser.
  • Added first support for ALTER TABLE statements to the SQL parser.
  • Added support for Teradata regular expression match operators to the SQL parser.

New in Open Teradata Viewer 0.2c (Dec 27, 2013)

  • Added the C syntax highlighting.
  • Fixed an issue with the Graphic Viewer ports.

New in Open Teradata Viewer 0.2b (Dec 23, 2013)

  • Added the JavaScript syntax highlighting.
  • The user manual has been updated with the added capabilities.

New in Open Teradata Viewer 0.2a (Dec 13, 2013)

  • Added the Java syntax highlighting.
  • Added the Outline view.
  • Added the "Go to member" popup dialog. The preferred keystroke to bind this action to is Ctrl+Shift+O (Cmd+Shift+O on Mac).
  • Added the "TABS EMULATED BY SPACES" command to the "Edit" menu.
  • The print margin is visible.
  • Upgraded itext library 5.0.1 -> 5.4.5
  • Upgraded forms library 1.0.7 -> 1.7.2
  • Upgraded joda-time library 1.6.2 -> 2.3
  • Upgraded looks library 2.2.1 -> 2.5.3
  • Upgraded poi library 3.6 -> 3.9

New in Open Teradata Viewer 0.19c (Nov 28, 2013)

  • Added the "VIEW AS (SYNTAX HIGHLIGHTING)" command to the "View" menu.
  • Added the "TOGGLE SPELL CHECKING" command to the "Edit" menu.
  • Added the "FIND.." command to the "Search" menu.
  • Added the "REPLACE.." command to the "Search" menu.
  • Added the capability to open the URLs typed in the comments of the script.
  • Added the error strip to the right of the SQL editor.

New in Open Teradata Viewer 0.19b (Nov 19, 2013)

  • Improvements in Clojure syntax highlighting.
  • Fixed exception in certain scenarios when word wrap and code folding were both enabled.
  • Fixed rendering bug when visible whitespace was enabled.
  • TextScrollPane now allows JLayer/JXLayer as its view.
  • The translucent Find dialog has been replaced by the Find search bar.
  • Added the "SHOW REPLACE SEARCH BAR" command to the "Edit" menu.
  • Other minor bugs fixed.

New in Open Teradata Viewer 0.19a (Nov 1, 2013)

  • Added first support for Teradata hierarchical queries to the SQL parser.

New in Open Teradata Viewer 0.18c (Oct 8, 2013)

  • Added support for Teradata truncate function to the SQL parser.
  • Added support for Teradata type character varying to the SQL parser.

New in Open Teradata Viewer 0.18b (Sep 27, 2013)

  • Painting performance improvements.
  • Pretty major API changes; "Token" changed from a class to an interface ("IToken"), etc.. This allowed for more aggressive caching of syntax highlighting information and thus better performance.
  • Improvements to Clojure syntax highlighting.
  • Miscellaneous small bug fixes and changes.

New in Open Teradata Viewer 0.18a (Sep 9, 2013)

  • Added regexp (REGEXP) operator to the SQL parser.
  • Added support for SELECT without FROM (e.g. "SELECT 1+2") to the SQL parser.
  • Moved parser from using StringBuffer to using StringBuilder.
  • Added support for CAST expression to the SQL parser.
  • Added support for modulo (a % b) to the SQL parser.
  • Added support for brackets quotation to the SQL parser.
  • Added support for NOT expr IS (expr IS NOT was already supported) to the SQL parser.
  • Added support for Teradata (+) Join Syntax to the SQL parser.
  • Added alias visitor to the SQL parser.
  • Added connect visitor to the SQL parser.
  • TableNamesFinder included in source of SQL parser.
  • Added proper support for sets (union, intersect) to the SQL parser.
  • Added support for extract(year from datetime-expr) to the SQL parser.
  • Start implementation of analytical expressions in the SQL parser.
  • Expansionpoint for additional letters included in the SQL parser.
  • The user manual has been updated with the added capabilities.

New in Open Teradata Viewer 0.17c (Jul 23, 2013)

  • Added the Sankey nodes to the tool palette of the Graphic Viewer.
  • The inspector of the Graphic Viewer is automatically displayed by selecting a component.

New in Open Teradata Viewer 0.17b (May 24, 2013)

  • Various code editor fixes and performance improvements.

New in Open Teradata Viewer 0.17a (May 18, 2013)

  • setBracketMatchingEnabled(boolean) now checks for brackets "to the right" of the caret if one is not found "to the left."
  • Added API to create custom hyperlinks in SyntaxTextArea.
  • Added "mark occurrences" support for XML. Currently just highlights the tag name at the current caret position and its match.
  • Fixed issue when auto-inserting spaces for tabs.
  • Major refactoring of rendering code.
  • "Traditional" selection rendering is now supported; that is, selected text can now be rendered as syntax highlighted tokens with a "selection" background (as it was previously), or as text as a single color with the "selection" background (as standard text components do). See SyntaxTextArea.setUseSelectedTextColor(boolean).
  • Fixed performance issue in FoldingAwareIconRowHeader when it paints "active regions."
  • Added some new token types to better differentiate markup tokens from "regular" language tokens. This allows for better syntax highlighting.
  • Upgraded Teradata JDBC driver 14.00.00.30 -> 14.10.00.17

New in Open Teradata Viewer 0.16c (Feb 5, 2013)

  • Fixed an issue with SQLTokenMaker: the ZEROIFNULL keyword has been categorized as a function.
  • Upgraded Teradata JDBC driver 14.00.00.21 -> 14.00.00.30

New in Open Teradata Viewer 0.16b (Jan 23, 2013)

  • Make auto-complete related windows use Substance rendering when a Substance Look and Feel is installed.
  • The default transaction mode for new database connections is set to ANSI, in order to avoid inadvertent data truncations.

New in Open Teradata Viewer 0.16a (Jan 10, 2013)

  • Added the "BIGINT", "CONTAINS", "LDIFF", "MEETS", "PERIOD", "PRECEDES", "P_INTERSECT", "P_NORMALIZE", "RDIFF", "SUCCEEDS" and "UDT" keywords to the Teradata reserved words.
  • Fixed an issue with SQLTokenMaker.

New in Open Teradata Viewer 0.15c (Jan 3, 2013)

  • Added the auto-completion functionality.
  • Added the "FANCY CELL RENDERING" command to the "View" menu.
  • Added the "SHOW DESCRIPTION WINDOW" command to the "View" menu.
  • Added the "FUNCTION PARAMETER ASSISTANCE" command to the "View" menu.

New in Open Teradata Viewer 0.15b (Dec 19, 2012)

  • Fixed an issue with CloseMarkupTagAction on non-QWERTY keyboards.

New in Open Teradata Viewer 0.15a (Dec 3, 2012)

  • Fixed the grid color of the results table on Windows XP / Vista, when using the Windows Look and Feel.

New in Open Teradata Viewer 0.14c (Nov 26, 2012)

  • Allow tool tips to be specified for icons in IconRowHeader.
  • Fixed an issue with CompleteMarkupTagAction and ToggleLineCommentAction conflicting with each other only on *nix (Windows and OS X didn't have this issue).
  • Allow for non-ConfigurableCarets to be set via setCaret(), to allow for Swing's "composed text" changes (hidden in private API).
  • Fixed possible NPE in XmlTreeCellUI for environments where desktop AA hints cannot be determined.
  • Added the "TOGGLE CURRENT FOLD" command to the "Edit" menu and to the contextual menu of the SQL editor.
  • Added the "COLLAPSE ALL COMMENT FOLDS" command to the "Edit" menu and to the contextual menu of the SQL editor.
  • Added the "COLLAPSE ALL FOLDS" command to the "Edit" menu and to the contextual menu of the SQL editor.
  • Added the "EXPAND ALL FOLDS" command to the "Edit" menu and to the contextual menu of the SQL editor.
  • The user manual has been updated with the added capabilities.
  • Added the "ACCESS" keyword to the Teradata reserved words.

New in Open Teradata Viewer 0.14b (Nov 9, 2012)

  • Added a translucent effect to the Find dialog (active only when supported by the installed LaF).

New in Open Teradata Viewer 0.14a (Nov 8, 2012)

  • Added the "SAVE AS WEB PAGE" option to the "SAVE FILE" command of the "File" menu.
  • Fixed errors due to the maximum limit of responses exceeded.

New in Open Teradata Viewer 0.13c (Oct 25, 2012)

  • Added the "PRINT PREVIEW" command to the "File" menu.
  • Upgraded Teradata JDBC driver 14.00.00.14 -> 14.00.00.21

New in Open Teradata Viewer 0.13b (Sep 12, 2012)

  • Fixed font rendering for Asian languages.
  • Added the "TO UPPER CASE" command to the "Edit" menu.
  • Added the "TO LOWER CASE" command to the "Edit" menu.
  • Added the "PAINT MATCHED BRACKET PAIR" command to the "Edit" menu.

New in Open Teradata Viewer 0.13a (Sep 7, 2012)

  • Changed default font to Consolas on Windows Vista and 7.
  • Decreased memory usage required for regex find and replace operations.
  • Improved performance of Mark Occurrences, especially when there are lots and lots of marked occurrences.
  • Added a property so that, when bracket matching is enabled, you can choose to have both brackets highlighted instead of just the "opposite" one.
  • Fixed misaligned icons in row header when code folding is enabled.
  • Fixed bug: FoldManager incorrectly auto-expanded deeply-nested folds for some edits that did not affect those folds.
  • Fixed bug: wrong initial width of line number margin when calling Gutter#setLineNumberingStartIndex(int).
  • GoToMemberWindow: Fixed occasional NPE.
  • Fixed bug in TextEditorPane: clear undo stack and dirty state when "loading" a new file. TextEditorPane: Now automatically scrolls to top of file on load().
  • Fixed bug: NPE in DumbCompleteWordAction in some circumstances (whitespace at beginning of file).
  • TokenMakerFactory now allows user-defined TokenMakers to be loaded via different ClassLoaders.
  • Added the "INVERT CASE" command to the "Edit" menu.
  • Added the compatibility with the Substance Look And Feels (Insubstantial 7.1).

New in Open Teradata Viewer 0.12c (May 28, 2012)

  • Added the "COPY AS RTF" command to the "Edit" menu.
  • Added the status text to the initial Splash Screen.
  • Upgraded Teradata JDBC driver 14.00.00.13 -> 14.00.00.14

New in Open Teradata Viewer 0.12b (May 28, 2012)

  • Added the "INCREASE FONT SIZES" command to the "Edit" menu.
  • Added the "DECREASE FONT SIZES" command to the "Edit" menu.

New in Open Teradata Viewer 0.12a (May 28, 2012)

  • Added the "DATE/TIME" command to the "Edit" menu.
  • Added the "INCREASE INDENTATION" command to the "Edit" menu.
  • Added the "DECREASE INDENTATION" command to the "Edit" menu.

New in Open Teradata Viewer 0.11c (May 25, 2012)

  • Added the possibility to install the 3rd Party Look And Feels defined in the file "open_teradata_viewer_lookandfeels.xml"; this file is located in the user home directory.

New in Open Teradata Viewer 0.11b (May 18, 2012)

  • Fixed issue with TextScrollPane.
  • Fixed bug in CurlyFoldParser.
  • The query editor now has anti-aliasing enabled by default.

New in Open Teradata Viewer 0.11a (May 18, 2012)

  • Added the animate bracket matching, current line highlight, bookmarks, word wrap, themes for the SQL editor, ... Navigate the "Edit" and the "Look & Feel" menus to see all the added features.
  • Fixed too large initial screen width on multiple monitors.
  • Fixed a bug related to the search capability: after repeating some text searches, if the user focused the editor after having found an occurrence of the searched text, the visible portion of the SQL code wasn't the expected one.

New in Open Teradata Viewer 0.10c (Mar 19, 2012)

  • Fixed the text retrieval of the DDL scripts.
  • The "SHOW OBJECT" commands have been grouped.
  • Upgraded 14.00.00.12 -> 14.00.00.13

New in Open Teradata Viewer 0.10b (Mar 1, 2012)

  • Added the "SHOW MACRO" command to the "Schema Browser" menu.
  • Added the "SHOW TABLE" command to the "Schema Browser" menu.
  • Fixed a bug related to the "SHOW VIEW" command: the text was truncated to 12500 characters.

New in Open Teradata Viewer 0.10a (Feb 20, 2012)

  • Fixed semicolons being cut off at the end of PL/SQL blocks.
  • Fixed the control acting on the length of the name of Teradata objects.
  • Upgraded Teradata JDBC driver 14.00.00.01 -> 14.00.00.12

New in Open Teradata Viewer 0.09c (Oct 18, 2011)

  • Fixed cropped menu items in Windows 7.
  • Guaranteed compatibility with Java 7.
  • Fixed occasional inability to open very large SQL files.

New in Open Teradata Viewer 0.09b (Sep 28, 2011)

  • BUG0003 fixed.
  • Upgraded Teradata JDBC driver 13.10.00.18 -> 14.00.00.01

New in Open Teradata Viewer 0.09a (Sep 21, 2011)

  • Some actions have been grouped.
  • Fixed a bug related to the LOB IMPORT and LOB PASTE operations.

New in Open Teradata Viewer 0.08c (Sep 21, 2011)

  • Added the EXPLAIN REQUEST command; the corresponding command button has been installed on the "Schema Browser" menu.
  • Fixed a bug related to the lack of JAR files in the plugins directory; despite the absence of JAR files (JDBC driver included) in the plugins directory, you can run the application.

New in Open Teradata Viewer 0.08b (Sep 21, 2011)

  • Added the COMMIT command; the corresponding command button has been installed on the tool bar and on the "Connection" menu.
  • Added the ROLLBACK command; the corresponding command button has been installed on the tool bar and on the "Connection" menu.

New in Open Teradata Viewer 0.08a (Sep 20, 2011)

  • Added the "Copy" command button to the tool bar.
  • Added the "Cut" command button to the tool bar.
  • Added the "Paste" command button to the tool bar.
  • Fixed a bug relative to the edit actions. These actions were generated by the default editor kit, therefore when they were invoked, they acted on the focused text editor. Now these operations act solely on the query area.

New in Open Teradata Viewer 0.07c (Sep 16, 2011)

  • BUG0001 fixed.

New in Open Teradata Viewer 0.07b (Aug 31, 2011)

  • Added the capability to manage multiple plugins.

New in Open Teradata Viewer 0.07a (Aug 18, 2011)

  • The proxy password is encrypted.
  • Upgraded Teradata JDBC driver 13.00.00.06 -> 13.10.00.18
  • BUG0002 fixed.

New in Open Teradata Viewer 0.05a (Jul 23, 2011)

  • Added an animated assistant that is shown while a process is running.
  • The "SHOW RECORD" command can be perfomed only if a record has been selected.
  • Updated the "EDIT CONNECTION" dialog screenshot in the user manual.