Softpedia >Windows >Internet >Servers >Database Utils >SQLeoVQB >  Changelog

SQLeoVQB Changelog

What's new in SQLeoVQB 2017.09 RC 1

Sep 18, 2017
  • Update pivottable.js to version 2.14.0
  • Update csvjdbc driver to 1.0.32

New in SQLeoVQB 2017.03 RC 1 (Mar 22, 2017)

  • SQLeoPivotDiff
  • Designer: filter with OR condition is changed in AND
  • Designer: enable "remove" on right click on table
  • Designer: reverse query with ON condition with values is wrong
  • create Aliases for SQL queries
  • see sql/aliases.sql

New in SQLeoVQB 2016.10 RC 1 (Oct 27, 2016)

  • command editor: current connexion should be emptyed after disconnect
  • automated SQLparser testing
  • SQL History: add a Copy an open in editor
  • Designer: removing a table should remove all related columns
  • Content Window: SQLexception: Statement was canceled or the session timed out
  • Content Window: add AutoSavepoint in Populate filter with values
  • SQL history: format SQL from query designer before to save
  • Query builder: reverse "where a.x >= b.y" is wrong

New in SQLeoVQB 2016.09 RC 1 (Sep 30, 2016)

  • Export Pivot: set fetchsize to 1000
  • Content window: jump doesn't work
  • Query Builder: changing table alias is not applyed to condition ...
  • Updated Translations for French, Serbian and Spanish

New in SQLeoVQB 2016.08 RC 1 (Aug 29, 2016)

  • New russian translation (by Vladimir Solovyov)
  • Add Cancel query for "count records" and "export"
  • Better translation for Content Window
  • Designer: reverse query returns nothing

New in SQLeoVQB 2016.07 RC 1 (Jul 12, 2016)

  • Content Window: Prevent error "OutOfMemoryError: Java heap space" when opening a big MySQL table

New in SQLeoVQB 2016.05 RC 1 (Jun 29, 2016)

  • Main Icon bar: not refreshed when closing windows
  • Data comparer: "Only different values" is wrong with NULL values on H2
  • rg.postgresql.util.PSQLException: ERROR: schema "dbms_output" does not exist
  • Cancel query doesn’t work

New in SQLeoVQB 2016.04 RC 1 (Apr 28, 2016)

  • Preferences: values > 999 are ignored
  • Data comparer: empty error message box displayed
  • Metadata explorer: search is Upper case, ko with lower case object names
  • Command editor: support dbms_output with PostgreSQL /​ orafce
  • Command editor: /​* text */​ in front of query prevent result from being displayed
  • Improved German translation

New in SQLeoVQB 2016.03 RC 1 (Mar 5, 2016)

  • Data comparer: set background color according to connection
  • Content Window: add Column Alias suppport in Populate filter with values
  • Data comparer: allow million lines comparison
  • Menu: all windows are not reachable using right and left arrows

New in SQLeoVQB 2016.02 RC 1 (Feb 17, 2016)

  • All windows: background color per datasource set
  • Background color in soft grey for READ ONLY connections
  • Content Window: filters prepopulated with data values
  • SQLeo Start up GUI does nothing
  • Preferences: auto-commit set to off by default
  • Content window: count records fails on query with ORDER BY (monetDB)
  • command editor, data comparer: set fetch size to 1000 for performances

New in SQLeoVQB 2016.01 RC 1 (Jan 20, 2016)

  • Auto-Savepoint: activate/​disable in preferences
  • command editor: Commit/​Rollback buttons KO out of initial connection
  • create READ ONLY connections

New in SQLeoVQB 2015.10 RC 1 (Jan 9, 2016)

  • Better MAC OS integration:
  • use sqleo-start-MacOS.txt to start SQLeo on OSX
  • New portuguese brasilian translation (by Eder Jorge)
  • Content Window: java.lang.ArrayIndexOutOfBoundsException with Update or delete
  • Query builder /​ Command editor: avoid PostgreSQL ERROR: current transaction is aborted
  • All Statements use Auto SavePoints
  • rem: Also works with MonetDB
  • Command editor: support for PostgreSQL Anonymous block DO $$
  • Data Comparer: performance problem with Oracle

New in SQLeoVQB 2015.10 RC 1 (Nov 7, 2015)

  • 320 data comparer: use H2 as working datasource for big datasets
  • 319 data comparer: display aggregate text in resulting columns
  • 317 command editor: set output default format
  • 316 command editor: let user choose output file extension
  • 315 command editor: set a message in text log when data sent to grid
  • 277 SQLeo display available shortcuts
  • 255 Data comparer: save working datasource

New in SQLeoVQB 2015.09 RC 1 (Nov 7, 2015)

  • 314 command editor: limit rows is broken
  • 312 command editor: permit to switch between TEXT Window an GRID
  • 311 command editor: add CLEAR command
  • 306 command editor: add INPUT command
  • 309 data comparer: check that connexions are set before to start
  • 282 Query Builder: add Warning message when trying to run many SQL
  • 313 Grid content /​ output: resultset is not closed at end of query
  • 278 copy and open in editor: choose file extension in preferences
  • 183 copy and open in editor: line feed are lost

New in SQLeoVQB 2015.08 RC 1 (Nov 7, 2015)

  • 310 new portuguese translation (by Bruce Hyatt)
  • 307 Improved Italian translation (by Sinhuè Angelo Rossi)
  • 286 command editor: support for OUTPUT and choose DATASOURCE in script

New in SQLeoVQB 2015.07 RC 1 (Aug 13, 2015)

  • CHANGES:
  • data comparer broken with Oracle
  • test with (automatic) translation in Arabic, Chinese, Hindi, Russian
  • Improved German translation (by Philipp Blaszczyk)
  • Print Version name in link when new version found
  • Give possibility to translate Metadata Explorer (translation available in French only)

New in SQLeoVQB 2015.06 RC 1 (Jun 29, 2015)

  • Query builder: adding csvjdbc table without schema
  • Preferences: selected langage in combo is only modifieable by user
  • Command script to use SQLeo as a portable app
  • Input boxes, labels, panels width/​height are not resized with increased Font size
  • Resize icons in metadata tree and query builder tree
  • set FONT_SIZE_PERCENTAGE default to 110 and ICON_SIZE_PERCENTAGE to 160
  • query builder where filter should be synchronized after use of grid filter

New in SQLeoVQB 2015.05 RC 1 (Jun 18, 2015)

  • Better translation for Data Comparer
  • History: npe when trying to delete a record
  • Command Editor: support for SHOW syntax with MySQL
  • Improve display on High resolution monitors
  • Command Editor: multiple inserts returns only one status line
  • Query Builder: add "sync columns with select" for group

New in SQLeoVQB 2015.04 RC 1 (Apr 18, 2015)

  • Content window: deleted row should be colored in RED before being applyed to db
  • Serbian translation
  • Query Builder: Add (database independent) group_concat syntax
  • command editor : format sql selected
  • sqleo query result shows oracle blob objects as null
  • Transform complex UPDATE in SELECT (for testing)
  • Query Builder: Add (database independent) pivot syntax
  • Content window: Update in grid with 2 varchar fields as update criterias fails
  • command editor: display latest connection in connections list (if set in preferences)
  • command editor: CTRL ENTER should select previous or current statement not all (Fix)
  • Query Builder: reverse "case when ..." is wrong (Fix)
  • Content window: can't update or delete on NULL column
  • refresh of screen CONTENT/​PREVIEW after action
  • message: no update criteria defined! when inserting

New in SQLeoVQB 2015.03 RC 1 (Apr 1, 2015)

  • Command Editor: keep user resized windows (after execution)
  • Data comparer: add diff status for each line
  • minimun csvjdbc-1.0-23.jar driver version (found in /lib directory) is needed
  • Data comparer: add user alias for source and target
  • command Editor: remember column sizes in datagrid after refres
  • command Editor: F5 for refreshing datagrid content
  • command Editor: CTRL ENTER should select previous or current statement not all
  • all statements should be separated with semicolons ;
  • SQLeo should not parse sql when loading sql file at first time

New in SQLeoVQB 2015.02 RC 1 (Mar 25, 2015)

  • Command Dditor - store gridoutput preference, display latest connection in connections list
  • Sending query result to pivottable.html
  • Command Editor/​ Data comparer: display current opened file name in title

New in SQLeoVQB 2015.01 RC 1 (Feb 11, 2015)

  • SQL history: data is sorted by day name not by timestamp
  • Command editor: Display Query duration (in text mode)
  • Data comparer:
  • save configuration in xml format,
  • load configaration in xml format,
  • limit Source and Target queries to 100 rows in Public edition
  • File recent queries: choose to open file in Query Builder OR Command Editor OR Data comparer

New in SQLeoVQB 2014.12 RC 1 (Dec 8, 2014)

  • Firebird: show content fails with GDS Exception 335544569
  • Jdbc driver needs to be re-created for users of previous releases
  • command editor: trim blanks before SELECT to go in datagrid
  • command editor: not always showing bottom of text area
  • compare table data (pivot table)

New in SQLeoVQB 2014.11 RC 1 (Oct 27, 2014)

  • command editor: display query result in data grid format
  • Export /​ Import data should be permitted for csv files
  • set FONT_SIZE_PERCENTAGE default to 110
  • support for Oracle db link syntax
  • Bigger icons for high resolution screens (and others)
  • query builder: add export to csv in syntax window
  • Query Builder: add support for UNION ALL

New in SQLeoVQB 2014.10 RC 1 (Oct 3, 2014)

  • 224 Syntax: join type is not highlighted
  • 223 Designer: force background color to white for all L&F
  • 220 Syntax: display corresponding pairs of parenthesis in same color
  • 203 Query builder: wrong filter icons
  • 34 SQL history view and log sql queries in a file

New in SQLeoVQB 2014.09 RC 1 (Oct 3, 2014)

  • 221 limit font size increase to 200
  • 218 MySQL ready ( with mariaDB jdbc driver included)
  • 214 Sign saved images
  • 210 Query syntax: /* comments */ should be colored in green
  • 76 Query builder: save table position and pack as a comment in SQL

New in SQLeoVQB 2014.08 RC 1 (Sep 19, 2014)

  • Fix command editor fails in executing queries which are multi-line.
  • New Translations of the Menus/Query Builder/Preferences in GERMAN, POLISH and SPANISH

New in SQLeoVQB 2014.06 RC 1 (May 28, 2014)

  • change donation link from paypal to a web page with all instructions
  • Font size percentage modification for high resolution screens font size should not be more than 130% yet
  • Query builder: adding a join between two subqueries not working
  • Query Builder: adding/changing Alias for Subquery not possible
  • Reverse query: repetitiv message "table or alias not found"

New in SQLeoVQB 2014.05 RC 1 (May 16, 2014)

  • Reverse query: display missing columns for where conditions
  • Reverse query: fails with function on ANSI join field
  • Reverse query: values in ON conditions generates error

New in SQLeoVQB 2014.04 RC 1 (May 16, 2014)

  • Query builder: support multi schemas for MySQL --> try the modified MariaDB jdbc driver available in lib directory
  • Query Builder: derived table syntax is not tab formated --> improved subqueries formatting
  • Reverse query: display missing columns for joins:
  • graph is dislayed in red when table or column not found
  • permits to reverse any SQL query without being connected
  • Command editor result - Add option for find dialog to search
  • Reverse query: column alias without AS not recognized for functions

New in SQLeoVQB 2014.03 RC 1 (May 16, 2014)

  • Sql scripts: add queries on MySQL information_schema
  • designer syntax: find / replace is slow and consume too much memory
  • Import: is wrong with UTF-8 files
  • Add reconnect option in metadataexplorer
  • change donation currency $ --> €
  • Data grid: open cell in text editor
  • query builder: error during add expression on standard table
  • export table data to file transform non ANSI chars to ?
  • For Export/import in UTF-8 use command line java -Dfile.encoding=UTF-8 -jar SQLeoVQB.jar as described in sqleo-start.txt

New in SQLeoVQB 2013.08 RC 2 (Oct 25, 2013)

  • Bug Fixes included for:
  • 135 Reverse query: fails with subqueries WITH CTE format
  • 130 Auto-complete with table aliases
  • 90 Reverse query: add support for EXTRACT(year from date)
  • New ticket added:
  • 140 unmappable character for encoding UTF8

New in SQLeoVQB 2013.08 RC 1 (Aug 22, 2013)

  • 129 Command editor connections dropdown has duplicates when socket read timeout occurs.
  • 128 Add a preference to disable asking "ask before exit" everytime.
  • 110 Auto-complete(intelli-sense) SQL in editor works with connected user schema objects, or db objects if db doesn't support schema (MySQL, Firebird) supported syntax is (lowercase) in command editor and query builder (syntax tab) select table.col from table where table.col

New in SQLeoVQB 2013.07 RC 1 (Jul 23, 2013)

  • Query Builder: don't take table alias to csv file when saving join
  • Java Web Start compatibility
  • Reverse query: raise warning when table not found
  • Reverse query: where a != b is wrong
  • Reverse query: select count(distinct x) is wrong

New in SQLeoVQB 2013.06 RC 1 (Jun 5, 2013)

  • Note: Saving to XLQ format will be removed and replaced by:
  • Query builder: keep table position, sort and pack information as a comment in SQL

New in SQLeoVQB 2013.05 RC 1 (Jun 3, 2013)

  • Improve Entity-relation Graph display
  • In graph designer "arrange entities" has been renamed to "arrange grid".
  • "arrange spring" added to permit entities arrangement based on a spring/magnetic layout model.

New in SQLeoVQB 2013.04 RC 1 (Apr 24, 2013)

  • Reverse SQL syntax problems, support added for:
  • JOIN , LEFT JOIN, RIGHT JOIN, FULL JOIN, CROSS JOIN
  • Query Builder: Highlight columns with where conditions using a flag or color
  • Query Builder: reuse same Content window on successive executions
  • Reverse query: graph for nested derived queries is wrong
  • Designer: display the direction of the join in graph

New in SQLeoVQB 2013.02 RC 3 (Mar 25, 2013)

  • Content window: propose "reverse syntax"
  • Content window: display rowcount when known
  • Fix when checking for new version available on server

New in SQLeoVQB 2013.02 RC 2 (Mar 9, 2013)

  • Content window: refresh (F5) when all rows are fetched returns blank screen
  • Improve SQLeo to check for new version available on server and Add donate shortcut

New in SQLeoVQB 2013.02 RC 1 (Feb 23, 2013)

  • Query Builder: Table name is not displayed in graph when table alias is used
  • change property file .sqleo to xml clear text Two files are now used for configuration: .sqleo.xml .sqleo.metaview Don't forget to save them on a regular basis
  • Content window: add filter value show null
  • Query Builder: reverse SQL, add Oracle join type (+) support Warning message when transforming a(+) join to INNER join
  • Query builder: do not auto alias fields in (derived table) subqueries
  • Content / preview window: add row count on content window
  • Query builder: reverse SQL, add derived tables subqueries support support for CTE (Common Table expression) added to ANSI and SQL92 style Not finished yet (joins with Drived tables are not drawned in grap)
  • Query builder: reverse SQL, remove -- comments
  • Query builder still broken after reconnect
  • Query Builder: check for PK when saving join to file
  • Propose Definition from query designer right click
  • Query Builder: reverse SQL syntax for table ALIAS in joins is case sensitivity
  • Query Builder: reverse SQL for WHERE (NOT) EXISTS to be added
  • Content Window: "sort by" doesn't override initial order by from syntax
  • Query builder: reverse SQL, support OVER( PARTITION ... ORDER BY ...)

New in SQLeoVQB 2012.07 Beta 4 (Oct 20, 2012)

  • Oracle: performance problem when adding tables to graph ask for ojdbc14_10.2.0.5.jar (not bundled with SQLeo)
  • Query Builder: reverse "sum(c) col_alias" is wrong
  • SQLeo application confirm dialog before exit
  • Preview windows: NPE at com.sqleo.environment.ctrl.content.ContentView.sort
  • Content Window: key down going up to grid (when having next n rows to fetch) 86 Query Builder : fix reverse SQL for table and columns with # char
  • Query Builder : fix reverse SQL for "cast (x as ...) as Z"
  • SQLeo application GUI enhancements

New in SQLeoVQB 2012.07 Beta 3 (Sep 20, 2012)

  • Exception: ResultSet.isAfterLast() unsupported at org.relique.jdbc.csv.CsvResultSet.isAfterLast
  • Exception: oracle.jdbc.driver.OracleResultSetImpl.isClosed()Z

New in SQLeoVQB 2012.07 Beta 2 (Sep 18, 2012)

  • Content window should fetch only first rows
  • Content/Preview: remove left scrolling bar
  • Preferences: defaults modification
  • Content: exporting modified field from grid is wrong
  • use csvjdbc version 1.0-11 (bundled with SQLeo)
  • Command editor: Increase column display size for DATES and

New in SQLeoVQB 2012.07 Beta 1 (Aug 3, 2012)

  • After saving / restoring from xlq tables locations change
  • Save joins from query builder to CSV
  • Command Editor: ask to save on exit
  • Propose Content from query designer rigth click
  • "Undo CTRL-Z/ Redo CTRL-Y" text on command editor/ syntax editor

New in SQLeoVQB 2012.03 Beta 4 (Jul 18, 2012)

  • NullPointerException at com.sqleo.environment.Preferences.getBoolean
  • Add CsvJdbc in the (default) driver list
  • Metadata explorer: java.sqj.SQLException: l' URL oracle indiquée n'est pas valide
  • Query Builder: reverse SQL group by t1.a||t2.b is wrong
  • Add Apache Derby Embedded in the (default) driver list
  • Definition > Indices runs analyze on Oracle to display Indexes

New in SQLeoVQB 2012.03 Beta 2 (Jun 27, 2012)

  • JRE 1.6
  • resizable windows
  • send objects from metadata explorer to query builder
  • explicit commit-rollback mode
  • added table is not displayed
  • removed table from graph remains in SQL text
  • Add firebird in the (default) driver list
  • Support for natural join (workarround)
  • Oracle: performance problem when adding tables to graph (workarround)
  • storing joins informations in a csv flat file

New in SQLeoVQB 2012.03 Beta 1 (Apr 23, 2012)

  • Group by Alias (from sqleonardo opened bugs)
  • reverse SQL for mixed aliased and non-aliased columns (from sqleonardo opened bugs)
  • Query, syntax windows execution
  • switch between Content windows
  • java.lang.StringIndexOutOfBoundsException: String index out of range: -20 33 Definition window: add constraints definition (workarround)
  • Metadata explorer: propose to add to DEFINITION windows
  • Raise exception when Join definition file is not found
  • keep least recently used queries list 2012.03Beta accepted
  • query builder: group or order by expression with alias is wrong