View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2214 [Database Workbench v6] General minor have not tried 2024-04-10 15:36 2024-04-11 10:14
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Refreshing meta data info from database can cause Access Violation in specific situation
Description: Refreshing from database with opened Trigger editor and modified trigger causes AV on continuation
Tags:
Steps To Reproduce: 1. open database
2. expand Triggers node
3. open trigger
4. modify trigger code, do not save
5. use Refresh From Database in DB Navigator, ignore warning about lost changes
6. try to close Trigger Editor > Access Violation
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2197 [Database Workbench v6] Firebird Module feature have not tried 2024-01-30 09:55 2024-04-02 15:46
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Support for Firebird 5
Description: https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html

- MERGE or UPDATE OR INSERT: ORDER BY clause https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-dml-merge-plan-order
- MERGE: WHEN NOT MATCHED BY SOURCE clause https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-dml-matched-by-source
- PSQL: subroutines can access variables & parameters created in outer routine https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-psql-subroutine-param-access
- partial indices (WHERE <where_clause>) https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-ddl-partial-indices
- new non-reserved keywords: LOCKED - OPTIMIZE - QUARTER - TARGET - TIMEZONE_NAME - UNICODE_CHAR - UNICODE_VAL
- 2 new functions UNICODE_CHAR & UNICODE_VAL https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-dml-unicode-funcs
- new system catalogs: RDB$KEYWORDS - MON$COMPILED_STATEMENTS
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2212 [Database Workbench v6] PostgreSQL Module block have not tried 2024-03-25 13:30 2024-04-02 11:52
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Error while loading Stored Procedures/Functions with specific defaults for parameters
Description: Error while loading Stored Procedures/Functions with specific defaults for parameters
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2211 [Database Workbench v6] General minor have not tried 2024-03-21 13:03 2024-03-21 13:35
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Possible access violation on using filter in DB Navigator
Description: - select "Management & Maintenance" node, then enter filter text
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2210 [Database Workbench v6] General feature have not tried 2024-03-21 11:16 2024-03-21 11:16
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to Search in SQL Statement History in SQL Editor
Description: Ability to Search in SQL Statement History in SQL Editor.

Can be 'whole word' search or any occurence of text.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2198 [Database Workbench v6] MySQL Module feature have not tried 2024-01-30 09:57 2024-03-11 14:06
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: MyQL 8.3 support
Description: https://dev.mysql.com/doc/relnotes/mysql/8.3/en/news-8-3-0.html
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2196 [Database Workbench v6] PostgreSQL Module feature have not tried 2024-01-30 09:55 2024-03-11 11:03
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Support for PostgreSQL 16.0 & 16.1 & 16.2
Description: https://www.postgresql.org/docs/release/

https://www.postgresql.org/docs/release/16.0/
- Allow subqueries in the FROM clause to omit aliases
- Add SQL/JSON constructors new functions JSON_ARRAY(), JSON_ARRAYAGG(), JSON_OBJECT(), and JSON_OBJECTAGG()
- Add SQL/JSON object checks https://www.postgresql.org/docs/16/functions-json.html#FUNCTIONS-SQLJSON-MISC
- Add functions to add, subtract, and generate timestamptz values in a specified time zone functions are date_add(), date_subtract(), and generate_series() https://www.postgresql.org/docs/16/functions-datetime.html#FUNCTIONS-DATETIME-TABLE
- Add server variable SYSTEM_USER
- Add functions array_sample() and array_shuffle() https://www.postgresql.org/docs/16/functions-array.html#ARRAY-FUNCTIONS-TABLE
- Add aggregate function ANY_VALUE() https://www.postgresql.org/docs/16/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
- Add function random_normal() https://www.postgresql.org/docs/16/functions-math.html#FUNCTIONS-MATH-RANDOM-TABLE
- Add error function erf() and its complement erfc() https://www.postgresql.org/docs/16/functions-math.html#FUNCTIONS-MATH-FUNC-TABLE
- Add XMLSERIALIZE() https://www.postgresql.org/docs/16/datatype-xml.html#DATATYPE-XML-CREATING

https://www.postgresql.org/docs/release/16.1/
- // nothing special

https://www.postgresql.org/docs/release/16.2/
- // nothing special
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1882 [Database Workbench v6] Visual Query Builder feature have not tried 2021-06-04 12:42 2024-03-06 14:26
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Ability to start Visual Query Builder without opening SQL or object editors
Description: Ability to start Visual Query Builder without opening SQL or object editors
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
353 [Database Workbench v6] General feature have not tried 2012-05-21 09:13 2024-03-06 13:06
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Ability to "paste" images directly in the BLOB Editor
Description: Ability to "paste" images directly in the BLOB Editor
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
513 [Database Workbench v6] Data Import & Export tweak always 2013-01-18 13:19 2024-03-05 14:50
Reporter: Steve Platform: Windows  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Remember setting for "Date & Time is in windows format" option
Description: This option is checked for export but unchecked for import. There is no user preference setting for this and it doesn't remember last used value.

It would be nice to have a user preference and for this, and for it to remember last selected value.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2067 [Database Workbench v6] Visual Query Builder minor have not tried 2022-10-17 10:33 2024-03-05 13:15
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: ORDER BY 1, 2, 3 is changed to names, even when this isn't possible
Description: ORDER BY 1, 2, 3 is changed to names, even when this isn't possible. This will fail on sub-queries, for example.
Tags:
Steps To Reproduce:
Additional Information: Bug was reported to Active Query Builder and fixed in the new release.
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2208 [Database Workbench v6] Firebird Module minor have not tried 2024-03-04 12:25 2024-03-04 12:30
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: SQL Editor: "invalid database handle" when switching to statistics page without executing statement first
Description: SQL Editor: "invalid database handle" when switching to statistics page without executing statement first
Tags:
Steps To Reproduce: 1. open Firebird database
2. open SQL Editor
3. switch to Statistics page
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2207 [Database Workbench v6] MySQL Module major have not tried 2024-03-04 11:40 2024-03-04 11:41
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: MariaDB 10.2 and up: meta data fetch for table columns is wrong, possible column copies
Description: MariaDB 10.2 and up: meta data fetch for table columns is wrong, column copies if you have multiple databases with the same table names.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2201 [Database Workbench v6] General tweak have not tried 2024-02-14 10:30 2024-02-29 14:32
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Ability to have multi-line text items in data grids
Description: Ability to have multi-line text items in data grids
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2202 [Database Workbench v6] General tweak have not tried 2024-02-14 12:38 2024-02-26 10:14
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Executing stored procedure should automatically select previous parameter values from history
Description: Executing stored procedure should automatically select previous parameter values instead of having the user select it by hand
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2206 [Database Workbench v6] Visual Query Builder tweak have not tried 2024-02-26 09:59 2024-02-26 10:00
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Update to latest version of Active Query Builder component
Description: Update to latest version of Active Query Builder component
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2203 [Database Workbench v6] Data Pump & Compare tweak have not tried 2024-02-14 12:39 2024-02-26 09:58
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Don't expand all nodes when loading a project from file
Description: Don't expand all nodes when loading a project from file
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2204 [Database Workbench v6] Data Pump & Compare tweak have not tried 2024-02-14 12:39 2024-02-20 15:49
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add option to "expand all"
Description: Add option to "expand all"
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2205 [Database Workbench v6] Installer tweak have not tried 2024-02-20 15:22 2024-02-20 15:22
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: v6_next  
    Target Version:  
Summary: Included newer version of GNU Unifont and add Proggy-font
Description: Included newer version of GNU Unifont and add Proggy-font
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2195 [Database Workbench v6] General tweak have not tried 2024-01-23 09:04 2024-01-23 09:04
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Catalog possibly shows data on "project" tab for non-project sessions
Description: Open a session with a Navigator Project
Open a session without (eg ADO/ODBC, or SQLite without the module licensed)

Catalog will continu to display project data when switching to project-less database session.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2192 [Database Workbench v5] PostgreSQL Module major always 2024-01-05 22:04 2024-01-05 22:04
Reporter: Wolfgang Lemmermeyer Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 6.3.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Access Violation during delete in SQL-Table
Description: If I try to delete a data row in a table a access violation accures.
Tags:
Steps To Reproduce: Connect to Database
open Table
open Data-Tab
Select data row in Table
click on "-" to delete the selected row
results in an access violation

Access violation at address 0000000017928617 in module 'dbw6c_pgsql.dll'. Read of address 0000000000000010
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2186 [Database Workbench v6] Diagramming feature have not tried 2023-12-29 15:00 2023-12-29 15:00
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Changed to conceptual
Description: My favorite approach is the conceptual diagram.

Is there a way to define

autoinc settings
constraint options for update/delete (restrict, cascade, set null)
in the conceptual model?

 

In my opinion, an autoinc key or the cascading of record deletions on the child tables are decisions in the context of the database concept
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2179 [Database Workbench v6] ADO/ODBC Explorer feature have not tried 2023-10-24 15:31 2023-10-24 15:31
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Store all ADO connectstrings used to a file and use the list where possible
Description: eg: ADO/ODBC Explorer, DataPump
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2177 [Database Workbench v6] General tweak have not tried 2023-10-20 08:56 2023-10-24 11:10
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Sorting & filtering in Connected User/Statemens/etc activity windows
Description: Sorting & filter in Connected User/Statemens/etc activity windows, eg search or filter by Workstation IP/OS User/Process
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2172 [Database Workbench v6] General major always 2023-10-17 10:36 2023-10-23 09:37
Reporter: Adrian Gerlan Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version: 6.3.0  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Application crashes after connection(s) lost
Description: I work many times during the day without finishing. As such, I leave the application open overnight to continue the 2nd day.
If the database server to which I am connected, or the connection to it, stop for a period of time, when I come back to work, the application crashes.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000599)
Martijn Tonies   
2023-10-17 11:58   
Adrian,

Can you check to see if this helps: at the right side of the top left drop down box (that holds database connections), there's a button "reconnect all". Can you click this before you start working in the application again?
(0000600)
Adrian Gerlan   
2023-10-23 09:37   
Hello Marijn,

I tried the solution proposed by you but it didn't work.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2164 [Database Workbench v6] General feature N/A 2023-09-28 09:41 2023-09-28 09:41
Reporter: henkjan wouterse Platform:  
Assigned To: OS:  
Priority: none OS Version:  
Status: new Product Version: 6.3.0  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Option to open folder explorer where database is stored
Description: In the popup menu of right click button .
Extend the options with option to open file explorer where database is stored.

This option only showing. when database is stored on local storage device.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2159 [Database Workbench v6] Visual Query Builder major always 2023-09-06 08:13 2023-09-23 12:55
Reporter: Pål Lillejord Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version: 6.3.0  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Visual query builder fail boolean field/values
Description: Fail with error message when open, both with boolean in select and in where clause
Tags:
Steps To Reproduce: Write
      select * from SEC$USERS where SEC$ADMIN
if try to open VQB it state error:
  Invalid SELECT statement.
   Unexpected token "EOF" at line 1, pos 41
same
select RDB$PROCEDURE_NAME , RDB$PROCEDURE_OUTPUTS = 0 as proc from RDB$PROCEDURES
  Invalid SELECT statement.
 Unexpected token "=" at line 1, pos 52
Additional Information:
Attached Files:
Notes
(0000590)
Martijn Tonies   
2023-09-07 09:54   
What DBMS is this, Firebird or InterBase?
(0000593)
Pål Lillejord   
2023-09-23 12:55   
this is Firebird


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2138 [Database Workbench v5] General major unable to reproduce 2023-05-19 21:48 2023-05-19 21:48
Reporter: Trent Workman Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 5.6.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Table Editor Header Missing
Description: The Header in Table Editor that contains the dropdown with the table name, along with the save modification buttons has gone missing.
I have searched settings and tried moving the mouse along the border to see if it's docked somewhere, but I can't find it.

This happened once before and I uninstalled/reinstalled and it was fine for a while. It is missing again now and I'm not sure what's causing it. Uninstall/Reinstall is not a sustainable solution.
Tags: table editor
Steps To Reproduce: I can't reproduce what made it go missing.
Additional Information:
Attached Files: missing header.PNG (18,427 bytes) 2023-05-19 21:48
https://tracker.upscene.com/file_download.php?file_id=82&type=bug
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2133 [Database Workbench v6] PostgreSQL Module feature have not tried 2023-03-30 10:19 2023-03-30 10:19
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Make modification of existing CHECK constraint easier
Description: PostgreSQL does not include DDL to modify an existing check constraint. You have to remove it and add a new one.

In the Domain Editor, make this transparent > modify a constraint, in the background, rename the old constraint, add the new and once succeeded, drop the old renamed constraint.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2129 [Advanced Data Generator] General feature have not tried 2023-03-27 09:08 2023-03-27 09:08
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Ability to update/delete existing data
Description: Ability to update/delete existing data
Tags:
Steps To Reproduce: I was wondering if I would be able to use the Advanced Data Generator to test change data capture.

To do this, I would need to be able to generate random data, then import that random data from where it was generated into a data warehouse. After replicating the generated data from where it was generated into a data warehouse, I need for the generated data to have a sample of the original records that meet each of the following scenarios:
1. records remain unchanged
2. records get deleted
3. records get updated (same primary key value has different values in some fields than it did originally)
4. records get added

If the data generator can produce a sample of data, then an action can be taken programmatically to update that dataset so there are records that meet those different criteria that I have listed above, this would be a useful solution for my use case.
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2126 [Advanced Data Generator] MySQL Edition minor have not tried 2023-03-20 09:36 2023-03-20 09:36
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: TIMESTAMP is recognized as 'date only', DATETIME works fine
Description: TIMESTAMP is recognized as 'date only'
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2125 [Advanced Data Generator] MySQL Edition minor have not tried 2023-03-20 09:11 2023-03-20 09:11
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Cannot use databases with a space in the name
Description: After registration, fails to load settings/connect
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2123 [Database Workbench v6] General feature have not tried 2023-02-27 11:40 2023-02-27 11:40
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Tool: ability to generate DSA/RSA keys
Description: Tool: ability to generate DSA/RSA keys
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2110 [Database Workbench v6] Diagramming feature have not tried 2022-12-28 09:51 2022-12-28 09:51
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Support for multiple schemas
Description: Support for multiple schemas. Support both when creating and reverse engineering.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2091 [Database Workbench v6] General feature have not tried 2022-11-07 08:53 2022-11-07 08:53
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to modify the pre-defined "defaults" in the Table Editor
Description: Ability to modify the pre-defined "defaults" in the Table Editor
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2089 [Database Workbench v6] MySQL Module feature have not tried 2022-11-03 09:54 2022-11-03 09:54
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Database Backup/Restore feature or wrapper for mysqldump
Description: Database Backup/Restore feature or wrapper for mysqldump
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2087 [Database Workbench v6] Oracle Module feature have not tried 2022-11-02 15:14 2022-11-02 15:14
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Full support for Constraints on Materialized Views
Description: Full support for Constraints on Materialized Views
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2052 [Database Workbench v5] MySQL Module minor have not tried 2022-09-16 11:47 2022-10-24 11:16
Reporter: Svein Erling Tysvær Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: feedback Product Version: 5.7.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Error, though still deleted
Description: When trying a select before a delete in the SQL Editor against a MariaDb database, then commenting out the select and putting the delete on a line below the select, Database Workbench gives an error message saying that it was surprised no rows were returned. The rows are deleted and autocommitted without any information about this.

It surprised me since I'm used to being told how many rows are deleted and have the option to rollback or commit.

Without the commented select line things works as expected.
Tags:
Steps To Reproduce: Just try running something like

-- select a.*
delete a
from a
join b on a.b_id = b.id
where b.name = 'Thomas Steinmaurer'

in the SQL Editor against a MySQL or MariaDb database
Additional Information:
Attached Files:
Notes
(0000579)
Martijn Tonies   
2022-10-24 11:15   
(Last edited: 2022-10-24 11:16)
Hello Svein,

If you select the first line and use ctrl+shift+M, it will use the multi-line comment, then it should work.

It has to do with faulty statement type detection.

That said, version 5 won't get any more updates, I'll create another issue for this in the DBW 6 section.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2061 [Database Workbench v6] Visual Query Builder feature have not tried 2022-10-10 12:17 2022-10-10 12:17
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Make SQL formatting settings easily available while in the Visual Query Builder
Description: Make SQL formatting settings easily available while in the Visual Query Builder
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1220 [Database Workbench v6] General feature N/A 2015-05-06 20:52 2022-08-11 12:11
Reporter: Luis Madaleno Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version: 5.0.10  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Usability improvement: make the "Extract DDL..." and similar options, always open a new script editor window.
Description: The "Extract DDL..." and similar options, always open in one script editor window.
Either it creates one if none exists, or appends to one that is already active.

If we want to open the DDL of several objects at the same time, to make changes in bulk this doesn't work.

Many times I have to edit several views at the same time to add some fields to all those views.
In my actual DB manager tool, I can open all the views I want in a script editor at the same time and then just copy and paste code between them.
After all the changes are done, I just save those changes in a row.

Simple and fast.

Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
486 [Database Workbench v6] SQL & Parameter Insight minor always 2012-11-06 11:25 2022-08-04 13:25
Reporter: Doychin Bondzhev Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: SQL Insight does not recognize sub-selects as left operand in expressions
Description: I discovered one more problem with SQL insight last night

it does not work for this case:

select *
from some_table
where (select count(*) from other_table) <> 0

It fails to list table names in the sub-select. Also it does not work for
expressions that will follow the sub-select but it works for expressions before that sub-select.
Tags:
Steps To Reproduce: Open some database. In my case I use Firebird 2.1

Open Singl SQL Editor

and write some select that will look like the one in the description

Try to invoke SQL Insight in the sub-select. Also try to invoke it after the sub-select. It will fail both times. It will only work before that sub-select
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2032 [Database Workbench v6] Oracle Module feature have not tried 2022-07-19 12:43 2022-07-19 12:43
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Support connecting with SSL
Description: Support connecting with SSL
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1926 [FB TraceManager] General feature have not tried 2021-10-17 10:22 2022-05-01 11:12
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Improved Firebird 4.0 support
Description: - Support for 63 characters long identifiers in MON$ Tables
- Support for wire crypted connections
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2018 [Database Workbench v6] Data Import & Export feature have not tried 2022-04-12 08:59 2022-04-12 08:59
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to import from XLS files
Description: Ability to import from XLS files.

Different tabs could be different tables, optional header row, map columns to table columns.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2014 [Database Workbench v6] Team Server feature have not tried 2022-03-30 13:47 2022-03-30 13:47
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to mark specific revisions with a version label and retrieve all recorded SQL since a version
Description: Ability to mark specific revisions with a version label and retrieve all recorded SQL since a version
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2005 [Database Workbench v6] Firebird Module minor have not tried 2022-03-18 12:37 2022-03-18 12:37
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Modifying both DEFAULT and datatype of a column, can fail due to order of DDL statements
Description: Modifying both DEFAULT and datatype of a column, can fail due to order of DDL statements.

eg, changing to Boolean and default to false. Type should go first?
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2002 [Database Workbench v6] General feature have not tried 2022-03-17 13:19 2022-03-17 13:19
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to 'un register' multiple databases
Description: Would be great to have ability to un-register multiple databases in one hit

e.g. multi-select in the server pane all the databases I want
un-register, right click, "unregister selected"
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1998 [Database Workbench v6] Team Server tweak have not tried 2022-03-09 17:29 2022-03-09 17:29
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add refresh database list for servers without server side database repository
Description: >>>>No auto refresh or manually - teamserver connection. After creating

>>>>new DB restart is needed for other users.

>>>Servers with a set of server side databases have a "refresh"

>>>option on the "Databases" node. If it's a server without such a server side maintained list, they yes, these will be picked up when you restart Database Workbench.

>>>

>>>You would like a 'refresh list' functionality on these too?
>>>Will not show up on my teammates DBW6 – unless he restarts the application.

>>>A “refresh database list” would be nice �
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1996 [Database Workbench v6] General feature have not tried 2022-03-08 09:33 2022-03-08 09:33
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to easier add objects to workspace folder
Description: - context menu on objects "add to workspace", list folders in submenu?
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1994 [Database Workbench v6] Data Pump & Compare feature have not tried 2022-03-04 09:49 2022-03-04 09:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to print summary of data compare results
Description: Ability to print (summary of) data compare results
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
624 [Database Workbench v6] Diagramming feature have not tried 2013-05-02 10:11 2022-01-26 10:47
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to create use case diagrams
Description: Ability to create use case diagrams
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
451 [Database Workbench v6] SQL & Parameter Insight feature N/A 2012-10-01 08:57 2022-01-26 10:47
Reporter: Doychin Bondzhev Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Option to enable/disable sql syntaxis hylighting in SQL Editor and max file size to automatically disable
Description: There should be an option to generally enable/disable syntax highlighting.

Also it could be very handy to have an option to specify max file size for which by default highlighting is enabled. If SQL file is larger then this size highlighting to disable automatically. From there you can enable it for this file specifically.

This I suspect will make it much easier to work with large SQL files like MySql backups.

Good place to put these options as check box for example on the SQL Editor tool bar. Also if these options are going to increase maybe a drop down menu similar to one we have in Single SQL toolbar.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000143)
Martijn Tonies   
2012-10-30 10:53   
Hmm, it seems slowness is more an issue of very very wide lines than of the number of lines.

Can you confirm?
(0000149)
Doychin Bondzhev   
2012-11-06 11:20   
I just suspected the problem comes from sql code analysis done by sql editor to properly highlight it.

The real problem could be in the fact that SQL editor needs lots of time to scroll each line but again this could be caused by the code analysis.

Just try to load big SQL file with lots of inserts and you will notice that when you try to scroll it does not really scroll but instead just moves the scroll bar position but screen is not repainted.

My real problem comes more from the fact that it takes ages to run script that is more then just a few hundred lines long. For scripts that represent database backups(MySQL) it could take ages to run and in most of the case it freezes at some point or is getting really slow.

In this case the real problem could be in the fact that you log each statement in the execution log and these controls are not very fast when they contain lots of lines ;-(

So if you can check where the actual bottleneck is this could pinpoint the real source of the problem which can be something else not the syntax highlight.
(0000150)
Martijn Tonies   
2012-11-06 11:25   
You can easily try yourself if it's the highlighting - open an editor without a connection: no highlighting.

With regard to script running, the output has a maximum number of lines, see Preferences, Editors, SQL/Script Editor.
(0000151)
Doychin Bondzhev   
2012-11-06 11:27   
OK but it is not only the output ;-)

It is the SQL editor him self that eats lots of CPU while executing SQL lines.

I think better is to look at issue 450. This will be much better to have and will avoid all the problems when running large SQL scripts from SQL Editor.
(0000152)
Doychin Bondzhev   
2012-11-06 11:28   
Actually Scroll is really really fast when I load my test file in SQL Editor ;-) without highlighting.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
848 [Database Workbench v6] Diagramming feature have not tried 2014-03-12 09:07 2022-01-26 10:46
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to merge conceptual diagrams from file
Description: Ability to merge conceptual diagrams from file
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1700 [Database Workbench v6] Firebird Module major have not tried 2019-09-04 15:53 2022-01-26 10:46
Reporter: Jacek Laskowski Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.6.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Problem with debugging Firebird 3 stored procedure with fetching exception SQLSTATE into variable
Description: I try debug SP with

WHEN ANY DO...

statement inside which I want to capture error codes:


    DDL = 'some wrong DDL code';
    EXECUTE STATEMENT DDL;
    WHEN ANY DO
    BEGIN
      ERROR_GDSCODE = GDSCODE;
      ERROR_SQLCODE = SQLCODE;
      ERROR_SQLSTATE = SQLSTATE; <--- on this line exception occurs
    END
Tags:
Steps To Reproduce:
Additional Information: see screenshot for details
Attached Files: vps_2019.09.04_03.png (71,464 bytes) 2019-09-04 15:53
https://tracker.upscene.com/file_download.php?file_id=64&type=bug
Notes
(0000500)
Jacek Laskowski   
2019-09-05 13:09   
in the latest version 5.6.6 (I bought an update yesterday) the exception is gone, but the SQLSTATE value is not get/read
(0000501)
Jacek Laskowski   
2019-09-05 13:29   
Next problem. When I use in SP this statement:

WHEN GDSCODE no_dup DO

then SP is compiled but debugging is not possible, because DBW raise error: "Preprocessor errors found - cannot debug procedure"


the problem is 'GDSCODE no_dup', although this is the allowed FB syntax:

https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-psql-handleexceptions.html


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1968 [Database Workbench v6] PostgreSQL Module feature have not tried 2022-01-20 14:35 2022-01-26 10:46
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Create SUID procedures functionality
Description: Create SUID procedures functionality
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
882 [Database Workbench v6] General feature always 2014-04-10 20:26 2022-01-19 10:03
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version: 4.4.5  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Quick 'database restore' without having to create a project
Description: I find the quick backup possibility when right-clicking a registered
database and the context-menu Administration & Maintenance | Backup ...
very useful.

Would it make sense to add something similar for Restore? E.g. a new
context-menu item for the Databases root node in the DBN for a
registered Firebird server?

This would allow me to restore a database without the need to create a backup project first.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1697 [Database Workbench v6] General tweak have not tried 2019-08-08 15:55 2022-01-12 13:35
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: (Optionally) Always show table/view before index/constraint/trigger and sort accordingly
Description: Currently, this depends on the DBMS, eg MSSQL has no separate namespace for indices, so tables are included in index name.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1640 [Database Workbench v6] MySQL Module feature N/A 2018-09-17 11:12 2022-01-12 13:35
Reporter: Svein Erling Tysvær Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 5.4.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Finding indices that are identical to or subsets of other indices
Description: I think (though could be wrong) the below query finds indices that are subsets of or identical to other indices for tables in a database. Don't know if this is something anyone would appreciate being available in DBW?

WITH TMP(TABLE_NAME, INDEX_NAME) AS
( SELECT DISTINCT TABLE_NAME, INDEX_NAME
  FROM information_schema.statistics )
SELECT A.TABLE_NAME, A.INDEX_NAME,
       IF( EXISTS( SELECT *
              FROM information_schema.statistics B2
              WHERE B.TABLE_NAME = B2.TABLE_NAME
                AND B.INDEX_NAME = B2.INDEX_NAME
                AND NOT EXISTS( SELECT *
                                FROM information_schema.statistics A2
                                WHERE B2.TABLE_NAME = A2.TABLE_NAME
                                  AND B2.COLUMN_NAME = A2.COLUMN_NAME
                                  AND B2.SEQ_IN_INDEX = A2.SEQ_IN_INDEX
                                  AND A.INDEX_NAME = A2.INDEX_NAME ) ), 'is a subset of', 'is identical to' ) HowItRelates,
       B.INDEX_NAME
FROM TMP A
JOIN TMP B ON A.TABLE_NAME = B.TABLE_NAME
          AND A.INDEX_NAME <> B.INDEX_NAME
WHERE NOT EXISTS( SELECT *
                  FROM information_schema.statistics A1
                  WHERE A.TABLE_NAME = A1.TABLE_NAME
                    AND A.INDEX_NAME = A1.INDEX_NAME
                    AND NOT EXISTS( SELECT *
                                    FROM information_schema.statistics B1
                                    WHERE A1.TABLE_NAME = B1.TABLE_NAME
                                      AND A1.COLUMN_NAME = B1.COLUMN_NAME
                                      AND A1.SEQ_IN_INDEX = B1.SEQ_IN_INDEX
                                      AND B.INDEX_NAME = B1.INDEX_NAME ) )
  AND ( EXISTS( SELECT *
                FROM information_schema.statistics B2
                WHERE B.TABLE_NAME = B2.TABLE_NAME
                  AND B.INDEX_NAME = B2.INDEX_NAME
                  AND NOT EXISTS( SELECT *
                                  FROM information_schema.statistics A2
                                  WHERE B2.TABLE_NAME = A2.TABLE_NAME
                                    AND B2.COLUMN_NAME = A2.COLUMN_NAME
                                    AND B2.SEQ_IN_INDEX = A2.SEQ_IN_INDEX
                                    AND A.INDEX_NAME = A2.INDEX_NAME ) )
     OR A.INDEX_NAME < B.INDEX_NAME )
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
868 [Database Workbench v6] Diagramming feature have not tried 2014-04-03 18:55 2022-01-12 13:21
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to auto-route lines and switch line types
Description: Ability to auto-route lines, so called "side line"
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
804 [Database Workbench v6] Firebird Module feature have not tried 2014-02-11 16:09 2022-01-12 13:21
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Full Plan Analysis for statements in Stored Procedure/Function
Description: Full Plan Analysis for statements in Stored Procedure/Function
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
761 [Database Workbench v6] General feature N/A 2013-12-02 11:50 2022-01-12 13:20
Reporter: Svein Erling Tysvær Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add CREATE TABLE from query to SQL Editor
Description: Sometimes I write queries that produce a result set that I want to store as a table in either the same or a different database. Currently, I then have to manually write the field name, type and length of every field. It would be great if it was possible to create (the skeleton of) a table based on the output of such a query, i.e. the same as 'Duplicate...' that you get when right-clicking on a table (except the source being a query rather than a table).
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
4 [Database Workbench v6] Firebird Module feature always 2011-04-28 15:57 2022-01-12 13:19
Reporter: sqldba Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to alter a domain when it used in a constraint/column
Description: Database Workbench/Firebird does not have the ability to modify domains if it is used in a constraint. You cannot switch the underlying datatype nor change the length of the datatype. This defeats the whole purpose of using a domain.

In a production system, this would mean dropping all the constraints, modifying a new domain, and manually creating all the constraints which is very tedious.

No other database tool vendor for Firebird provides this feature (which is a very requested feature) and if Database Workbench implements this feature, it would be great.

Example:
CREATE DOMAIN test_domain VARCHAR(25);
CREATE TABLE test_table
(
   test_column test_domain NOT NULL PRIMARY KEY
);

ALTER DOMAIN test_domain VARCHAR(26); <-- Firebird throws error that the update was not successful because the domain is used in a constraint (primary key)
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000001)
sqldba   
2011-04-28 15:58   
Basically, instead of manually dropping the constraints, modifying the domain etc.....Database Workbench should automate the process.
(0000034)
Martijn Tonies   
2011-11-02 10:54   
Non-domained columns in tables also suffer from this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
330 [Database Workbench v6] ADO/ODBC Explorer feature always 2012-04-24 08:37 2022-01-12 13:19
Reporter: Johann Sijpkes Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add metadata printing for ODBC and ADO data sources
Description: The menu items are disabled and I cannot access the table editor or print meta data.
Tags:
Steps To Reproduce: Right click on a table in ODBC explorer in the treeview:
Main entries disabled like "Edit Table " , "Extract DLL" and "Print"
Additional Information:
Attached Files:
Notes
(0000146)
Martijn Tonies   
2012-11-05 11:31   
Edit Table and Extract DDL will be disabled, because it's impossible to create DB-system specific DDL for any ODBC/ADO source.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
430 [Database Workbench v6] General feature always 2012-08-20 09:50 2022-01-12 13:19
Reporter: Milan Tomes Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Automatic SQL review before saving object in editors, ability to cancel saving
Description: - add (parametrized) ability to review SQL generated from changes made eg. in table editor before it will be run to be able to copy and cancel it.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000125)
Martijn Tonies   
2012-08-20 09:57   
metadata changes can be checked on the "DDL" tab on Editors. Is that what you're looking for?

Please add a new entry for the MySQL-related request.
(0000127)
Milan Tomes   
2012-08-20 10:17   
I'm looking for a window with generated DDL command just between times when I hit Ctrl+S and time when this command is processed with option to confirm or cancel this SQL.

Entry added.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
368 [Database Workbench v6] Diagramming feature have not tried 2012-06-01 08:23 2022-01-12 13:19
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to do some free-form drawing in a diagram, including use-case etc
Description: Ability to do some free-form drawing in a diagram, including use-case etc
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
367 [Database Workbench v6] Diagramming feature have not tried 2012-06-01 08:23 2022-01-12 13:19
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to create diagram-groups
Description: That have multiple diagram types in it
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
862 [Database Workbench v6] General feature N/A 2014-04-01 12:25 2022-01-12 13:18
Reporter: Doychin Bondzhev Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 4.4.5  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Execute single SQL Script to multiple database connections
Description: There are situations where we have multiple instances of same database schema and when we need to make changes to that schema we need to connect to each instance and run the SQL script.

It will be great if we can write our Script in a dialog and then select the connections against which the script will be run. Then hit the Run button and after some time all databases are updated.

This could be very useful when you have 10 or more instances of database that you want to upgrade.
Tags:
Steps To Reproduce: From the tools menu -> Run Script on multiple databases.

A dialog is shown where you enter the script. On the next page you provide some options like : parallel execution, ignore on error, stop on error, transaction options and anything else. Options for parallel execution - number of threads to use.

After starting the process DBW will connect to each database and will run the script.

At the end it will report the status for each connection.
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
696 [Database Workbench v6] Printing feature have not tried 2013-08-05 09:25 2022-01-12 13:18
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add table of contents to metadata printing
Description: Add table of contents to metadata printing
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
492 [Database Workbench v6] Oracle Module feature have not tried 2012-12-17 15:13 2022-01-12 13:18
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Dump import/export functionality
Description: Dump import/export functionality
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
490 [Database Workbench v6] General feature N/A 2012-11-22 15:47 2022-01-12 13:18
Reporter: Andreas Vorbeck Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: code formatter for SQL editor
Description: code formatter for SQL- and StoredProcedure-Editor.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
416 [Database Workbench v6] General tweak have not tried 2012-08-01 08:44 2022-01-12 13:18
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add a "cancel changes" button to the object editors
Description: Add a "cancel changes" button to the object editors
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
246 [Database Workbench v6] Firebird Module feature always 2012-01-30 09:47 2022-01-12 13:18
Reporter: Thomas Steinmaurer Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Support for page buffers and no garbage collection DPB options
Description: There are two interesting database parameter blocks in the Firebird client api available, which would be useful to have it supported by DBW:

1) Temporary cache buffer: While there is a page buffers value stored on
the header page of a Firebird database, which defines RAM usage for the
page cache, the Firebird client API allows to specifiy a temporary page
buffers value at connect time, temporarily overriding the persistent
page buffers value for this particular connection/session. I'm using
that sometimes with Ivan's "fsql" command-line utility and find that
handy, if I could use DBW in this scenarios as well.

The DPB is called: isc_dpb_num_buffers

2) Omit garbage collection: Another database connection level API option
is to omit garbage collection. Especially useful for Classic and
SuperClassic server, where the cooperative GC can slow down statements,
as they are directly responsible for removing garbage. I would find it
useful if I can run statements in particular scenarios without GC
involved, especially during development to measure pure execution time
without GC etc.

The DPB is called: isc_dpb_no_garbage_collect

If you add support for that in DBW, I guess it would make sense in the
database registration dialog and in the Connect As dialog.

Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1034 [Database Workbench v6] Data Import & Export feature have not tried 2014-09-19 08:47 2022-01-12 13:14
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Command line export tool that can be executed non-interactively
Description: Command line export tool that can be executed non-interactively
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1033 [Database Workbench v6] Data Import & Export feature have not tried 2014-09-19 08:46 2022-01-12 13:14
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to save "export profiles" to file in order to re-use export settings
Description: Ability to save "export profiles" to file in order to re-use export settings
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1024 [Database Workbench v6] General feature have not tried 2014-09-10 14:17 2022-01-12 13:14
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to save query parameter values for re-use or have them stored automatically
Description: Ability to save query parameter values or have them stored automatically
Tags:
Steps To Reproduce:
Additional Information: >Is there an option to store entered parameters in the SQL or
>Script editor? Actual entered parameters are shown in the
>parameter history and we can reuse it as long as DBWorkbench
>is not closed. But it would be nice to store/load the
>parameter history or a single item of it into/from a local
>file to use entered parameters after a restart of DBWorkbench.
>Some of our statements containes up to 100 parameters. We
>would be happy to have not reentered all of them each time we
>restart DB Workbench.
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1008 [Database Workbench v6] Oracle Module feature have not tried 2014-09-03 12:52 2022-01-12 13:14
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Support for partitioning
Description: Support for partitioning
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1001 [Database Workbench v6] Firebird Module feature N/A 2014-08-28 13:55 2022-01-12 13:14
Reporter: Doychin Bondzhev Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 4.4.7  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add ability to debug execute block statements
Description: Right now I need to created stored procedure that will contain the body of the statement in order to debug it.

There are cases where I don't need stored procedure to run some one time complex statement and I don't want to pollute database with temp procedures.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
983 [Database Workbench v6] General feature have not tried 2014-08-04 09:35 2022-01-12 13:14
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Have a "special copy to PHP" feature, like with Delphi/ASP/C++
Description: Have a "special copy to PHP" feature, like with Delphi/ASP/C++
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000297)
Martijn Tonies   
2014-08-05 15:02   
Problem:

PHP has a ' at the start of the string at the first line, but not at the next lines.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
982 [Database Workbench v6] MySQL Module feature have not tried 2014-08-01 15:25 2022-01-12 13:14
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to create a client side back up (like mysqldump)
Description: Ability to create a client side back up (like mysqldump)
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
904 [Database Workbench v6] General feature have not tried 2014-05-01 14:50 2022-01-12 13:14
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: View "list of objects" with extra info when an object editor has no object selected
Description: View "list of objects" with extra info when an object editor has no object selected.

eg, when clicking the object Folder.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
900 [Database Workbench v6] Licensing feature have not tried 2014-04-30 12:37 2022-01-12 13:14
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Have "temporary licenses" that work for a specified period of time
Description: Have "temporary licenses" that work for a specified period of time
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
867 [Database Workbench v6] Firebird Module feature N/A 2014-04-03 08:45 2022-01-12 13:14
Reporter: macma Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 4.4.5  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Firebird Events Monitor
Description: Any change to add firebird events monitor (watcher) with function to sent events also. It's function that is missing in WB, so I have to switch to another tool like http://www.mitec.cz/ibq.html.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
433 [Database Workbench v6] SQL & Parameter Insight minor always 2012-08-21 13:23 2022-01-12 13:14
Reporter: Doychin Bondzhev Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: MySQL does not support this syntax join (subquery) as sq(f1, f2...) on sq.f1 = some_filed
Description: This query works for mysql but does not allow sql insight to see fields from tt2:
select * from t1 join (select f1, f2 from t2) tt2 on t1.f1 = tt2.f2

Now this query works for sql insight but fails on mysql:
select * from t1 join (select f1, f2 from t2) tt2(f1, f2) on t1.f1 = tt2.f2

This format is supported from firebird so there are no problems with such queries.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
193 [Database Workbench v6] Data Import & Export minor always 2011-11-21 16:44 2022-01-12 13:14
Reporter: Doychin Bondzhev Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: When exporting data from SQL export to CSV uses some predefined format instead of using the one specified in program settings
Description: When I select date/time field from a table and I specify format for that field it is properly displayed in the result grid.
If I try to export that data to CSV file and tell the export to not use Windows Default format it uses another third format.

I specify yyyy-mm-dd hh:nn:ss and in the CSV file I get mm/dd/yyyy hh:nn:ss
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1613 [Database Workbench v6] Diagramming feature always 2018-06-20 11:04 2022-01-12 13:12
Reporter: Stephen Lappin Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 5.4.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to generate schema update DDL script
Description: Include a feature to compare a physical data model to a database schema, and generate to scheme update DDL.

The comparison should accommodate data type synonyms. For example, where:
- DB Data Type = Tinyint(1), PDM Data Type = Boolean - should not generate update DDL
- DB Date Type = BigInt(20), PDM Data Type = BigInt - should not generate update DDL
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1611 [Database Workbench v6] Diagramming feature always 2018-06-12 17:05 2022-01-12 13:12
Reporter: Stephen Lappin Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 5.4.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Optional setting to use CREATE OR REPLACE is generated DDL
Description: Have a setting such that CREATE OR REPLACE clauses are used in generated DDL, instead of

CREATE Object.... ;

or (for modified objects)

DROP Object...;
CREATE Object....;

For example, CREATE OR REPLACE TRIGGER ......
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1610 [Database Workbench v6] Meta Data Compare & Migration feature have not tried 2018-06-11 11:07 2022-01-12 13:12
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Command line version to execute compare profiles and reporting
Description: Command line version to execute compare profiles and reporting.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1607 [Database Workbench v6] Data Import & Export feature N/A 2018-06-05 21:51 2022-01-12 13:12
Reporter: Dan03802466 Platform: ALL  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.4.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Provide UPDATE in import from CSV instead just INSERT
Description: SOmetimes you want to make a Quick update, which is now not as easy, when you have Data in a table.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1489 [Database Workbench v6] Data Import & Export minor always 2017-04-13 12:17 2022-01-12 13:12
Reporter: Jeroen Pluimers Platform: Any  
Assigned To: OS: Any  
Priority: normal OS Version: Any  
Status: new Product Version: 5.2.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Please allow "transposed" export
Description: Especially for small result sets, it can be very convenient to have an export in "Transposed" form.

Transposed means the output is mirrored across the main diagonal: https://en.wikipedia.org/wiki/Transpose

In that case, the "column" headers become "row" headers and the "rows" of data become "columns" of data.

Example:

select * from rdb$database

Normal export:

RDB$DESCRIPTION,RDB$RELATION_ID,RDB$SECURITY_CLASS,RDB$CHARACTER_SET_NAME
,194,,"NONE"

Transpoded export:

RDB$DESCRIPTION,
RDB$RELATION_ID,194
RDB$SECURITY_CLASS,
RDB$CHARACTER_SET_NAME,"NONE"
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1458 [Database Workbench v6] Data Import & Export tweak always 2016-11-29 08:57 2022-01-12 13:12
Reporter: Michiel Spoor Platform:  
Assigned To: OS:  
Priority: low OS Version:  
Status: acknowledged Product Version: 5.2.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Extra option in export wizard 'UPDATE OR INSERT INTO'
Description: When externally adjusting/updating a table, you cannot first empty table to execute the table-fill-script which has only INSERT INTO.
Being able to creating a fill-script with
    UPDATE OR INSERT INTO
would be nice in that case (granted that there is a primairy key defined)
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1446 [Database Workbench v6] Data Pump & Compare feature have not tried 2016-11-07 13:35 2022-01-12 13:12
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to view errors after executing change script
Description: Ability to view errors after executing change script
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1335 [Database Workbench v6] Data Import & Export feature have not tried 2016-02-04 17:10 2022-01-12 13:12
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add default options to Preferences
Description: Add default options to Preferences.

eg:
- CSV file encoding
and others
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000411)
Doug Chamberlin   
2017-03-14 15:40   
Even more useful would be to group data import/export choices into named sets and allow user to specify a saved set of choices to be used. This would streamline the import/export processing.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1269 [Database Workbench v6] Firebird Module minor always 2015-08-04 11:17 2022-01-12 13:12
Reporter: Kim Sandell Platform: win10  
Assigned To: OS: win10  
Priority: low OS Version: win10  
Status: acknowledged Product Version: 5.1.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Duplicating a TABLE - the new table that is edited does not have trigger names changed
Description: The AutoIncrement trigger name and generator name inside does not have the new tables name, and causes a "Trigger already exists" error when saving the duplicated table.
Tags:
Steps To Reproduce: Steps:
1) Create a table
2) Add one ID field, as BigInt NOT NULL PRIMARY KEY, and autocreate trigger
3) Save

4) Duplicate this table (right click -> duplicate)
5) Enter new name
6) OK
7) Save new table (this will fail)
Additional Information:
Attached Files:
Notes
(0000383)
Kim Sandell   
2015-08-04 11:21   
Workaround is to DUPLICATE table with

Actions:
 (*) Just Duplicate Object

This will only create the table and fields, but omits the AutoIncrement trigger.

Then open the table and right-click ID column and add the Autoincrement.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1187 [Database Workbench v6] Meta Data Compare & Migration feature have not tried 2015-03-13 09:14 2022-01-12 13:12
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to include privileges during compare
Description: Ability to include privileges during compare
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1101 [Database Workbench v6] Data Import & Export feature have not tried 2014-10-26 15:35 2022-01-12 13:12
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Support JSON import/export
Description: Support JSON import/export

http://en.wikipedia.org/wiki/JSON
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
701 [Database Workbench v6] Meta Data Compare & Migration major always 2013-08-13 20:52 2022-01-12 13:12
Reporter: Carlos Tre Platform:  
Assigned To: Martijn Tonies OS:  
Priority: urgent OS Version:  
Status: assigned Product Version: 4.4.0  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: sync script fails to run
Description: Invalid statements, missing keywords, and fails to make adjustments both before and after synchronizing changes in domains, that's as far as I could get.
Tags:
Steps To Reproduce: create master and target databases from metadata sql scripts attached and execute database compare tool.
Additional Information: Also in the attached zip file two sync scripts Fail_Sync.sql and Work_Sync.sql, so you can compare and see the differences.
Attached Files: DBW.zip (152,513 bytes) 2013-08-13 20:52
https://tracker.upscene.com/file_download.php?file_id=20&type=bug
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1835 [Database Workbench v6] Data Import & Export feature always 2020-12-02 21:44 2022-01-12 13:09
Reporter: dragon Platform: MySQL  
Assigned To: OS: Windows 10  
Priority: normal OS Version: 10.0.19041.630  
Status: new Product Version: 5.7.8  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add ability to export with INSERT IGNORE INTO
Description: When you export data to SQL file, you are given the option to use SQL INSERT. However, it would be really nice if you were also given an option to use SQL INSERT IGNORE.
Tags:
Steps To Reproduce: N/A
Additional Information: N/A
Attached Files: insert.png (9,847 bytes) 2020-12-02 21:44
https://tracker.upscene.com/file_download.php?file_id=73&type=bug
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1218 [Database Workbench v6] General feature have not tried 2015-04-30 17:05 2022-01-12 11:54
Reporter: udi Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.0.10  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Enable Multi-Select object in the Object TreeView
Description: Enable multi-Select tables, Views , Stored-Procedure, Triggers....
from the DB's TreeView , than right-click to pop-up menu with options:
Drop , Set Inactive , Set Active,Export DDL etc".

Relative to the multi-Select objects (If you select x tables, you can do Drop or Empty. ).

You can't mutli-select diff objects (e.g: UDF & Domains). Only from the same object.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1153 [Database Workbench v6] Firebird Module minor have not tried 2015-01-24 09:19 2022-01-12 11:54
Reporter: Wolfgang Rohdewald Platform: Firebird 2.1, I86 32, Virtualbox  
Assigned To: Martijn Tonies OS: Windows  
Priority: low OS Version: Windows 7 Pro  
Status: acknowledged Product Version: 5.0.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: code folding problem with if then else if then else
Description: This is DBW 5.0.8 but I cannot select it in the Product Version.

The following code only folds correctly if I first compress the last part, then the middle part, then the first part. Otherwise I get into a situation where I cannot compress a branch. See attached screenshot.

I guess the solution is to compress all branches when compressing the first one.
Tags:
Steps To Reproduce:
Additional Information: begin
  if (1=0) then begin
     -- the first branch
  end else if (2=3) then begin
      -- the second branch
  end else begin
      -- the else branch
  end
end
System Description
Attached Files: steeg6.png (82,905 bytes) 2015-01-24 09:19
https://tracker.upscene.com/file_download.php?file_id=32&type=bug
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1495 [Database Workbench v6] Diagramming feature have not tried 2017-05-10 14:21 2022-01-12 11:52
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to add description to all Attributes/Columns
Description: Ability to add description to all Attributes/Columns
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1494 [Database Workbench v6] Diagramming feature have not tried 2017-05-10 14:21 2022-01-12 11:52
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to copy/paste Entities/Tables
Description: Ability to copy/paste Entities/Tables
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1479 [Database Workbench v6] General tweak always 2017-03-07 09:22 2022-01-12 11:52
Reporter: Arno Brinkman Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 5.2.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Allow SQL Catalog items to be ordered by drag and drop and sorted by menu
Description: - Would be nice if SQL Catalog items could be drag/dropped within a GROUP to the right position.

- Also sorting inside a group with a mouse-click would be nice.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1449 [Database Workbench v6] Diagramming minor have not tried 2016-11-15 12:33 2022-01-12 11:52
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Issue with generators not created for auto-inc triggers in InterBase & Firebird
Description: Issue with generators not created for auto-inc triggers in InterBase & Firebird
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1363 [Database Workbench v6] Meta Data Compare & Migration minor always 2016-04-20 07:55 2022-01-12 11:52
Reporter: Jeroen Pluimers Platform: Firebird  
Assigned To: OS: any  
Priority: normal OS Version: any  
Status: new Product Version: 5.1.12  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Schema Compare gives wrong SQL script for changes missing
Description: Source Tables:

CREATE TABLE MONITORINGEVENT
(
  ID INTEGER NOT NULL,
  SERVERID INTEGER NOT NULL,
  DATETIME TIMESTAMP NOT NULL,
  STATUSID INTEGER NOT NULL,
  CLASS CHAR( 4) NOT NULL COLLATE NONE,
  CUSTOMDATA VARCHAR( 40) NOT NULL COLLATE NONE,
  TICKCOUNT INTEGER,
  ISUNIQUE VARCHAR( 1) COLLATE NONE,
 CONSTRAINT PK_MONITORINGEVENT PRIMARY KEY (ID, SERVERID)
);

CREATE TABLE MONITORINGSTATUS
(
  ID INTEGER NOT NULL,
  SERVERID INTEGER NOT NULL,
  CLASSDESCRIPTION VARCHAR( 25) NOT NULL COLLATE NONE,
  STATUSLEVEL INTEGER NOT NULL,
  SENSORID INTEGER,
  SENSORSTRING VARCHAR( 100) COLLATE NONE,
  LOCATIONID INTEGER,
  LOCATIONSTRING VARCHAR( 100) COLLATE NONE,
  ENDPOINTID INTEGER,
  ENDPOINTSTRING VARCHAR( 100) COLLATE NONE,
  HQSTRING VARCHAR( 250) COLLATE NONE,
  STARTDATE TIMESTAMP,
  RESOLVEDATE TIMESTAMP,
  LASTUPDATE TIMESTAMP,
  URGENTDATE TIMESTAMP,
  NORMALDATE TIMESTAMP,
  LOWDATE TIMESTAMP,
  LOG BLOB SUB_TYPE 1 SEGMENT SIZE 4096,
  TICKCOUNT INTEGER,
  MONITORINGSTATE INTEGER,
  MONITORINGSTATEUNTIL TIMESTAMP,
 CONSTRAINT PK_MONITORINGSTATUS PRIMARY KEY (ID, SERVERID)
);


Destination Tables:

CREATE TABLE MONITORINGEVENT
(
  ID INTEGER NOT NULL,
  SERVERID INTEGER NOT NULL,
  DATETIME TIMESTAMP NOT NULL,
  STATUSID INTEGER NOT NULL,
  CLASS CHAR( 4) NOT NULL COLLATE NONE,
  CUSTOMDATA VARCHAR( 40) NOT NULL COLLATE NONE,
  TICKCOUNT INTEGER,
  ISUNIQUE VARCHAR( 1) COLLATE NONE,
 CONSTRAINT PK_MONITORINGEVENT PRIMARY KEY (ID)
);

CREATE TABLE MONITORINGSTATUS
(
  ID INTEGER NOT NULL,
  SERVERID INTEGER NOT NULL,
  CLASSDESCRIPTION VARCHAR( 25) NOT NULL COLLATE NONE,
  STATUSLEVEL INTEGER NOT NULL,
  SENSORID INTEGER,
  SENSORSTRING VARCHAR( 100) COLLATE NONE,
  LOCATIONID INTEGER,
  LOCATIONSTRING VARCHAR( 100) COLLATE NONE,
  ENDPOINTID INTEGER,
  ENDPOINTSTRING VARCHAR( 100) COLLATE NONE,
  HQSTRING VARCHAR( 250) COLLATE NONE,
  STARTDATE TIMESTAMP,
  RESOLVEDATE TIMESTAMP,
  LASTUPDATE TIMESTAMP,
  URGENTDATE TIMESTAMP,
  NORMALDATE TIMESTAMP,
  LOWDATE TIMESTAMP,
  LOG BLOB SUB_TYPE 1 SEGMENT SIZE 4096,
  TICKCOUNT INTEGER,
  MONITORINGSTATE INTEGER,
  MONITORINGSTATEUNTIL TIMESTAMP,
 CONSTRAINT PK_MONITORINGSTATUS PRIMARY KEY (ID)
);

Source constraint missing in destination:

ALTER TABLE MONITORINGEVENT ADD CONSTRAINT FK_MONITORINGEVENT_STATUS
  FOREIGN KEY (STATUSID, SERVERID) REFERENCES MONITORINGSTATUS
  (ID, SERVERID)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION
;


Update script:

ALTER TABLE MONITORINGEVENT ADD CONSTRAINT FK_MONITORINGEVENT_STATUS
  FOREIGN KEY (STATUSID, SERVERID) REFERENCES MONITORINGSTATUS
  (ID, SERVERID)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION
;

Fails probably caused by http://tracker.upscene.com/view.php?id=1362

---------------------------
Error
---------------------------
Script Error:

unsuccessful metadata update
could not find UNIQUE or PRIMARY KEY constraint in table MONITORINGSTATUS with specified columns

---------------------------
Abort Ignore
---------------------------
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1362 [Database Workbench v6] Meta Data Compare & Migration minor always 2016-04-20 07:51 2022-01-12 11:52
Reporter: Jeroen Pluimers Platform: Firebird  
Assigned To: Martijn Tonies OS: Any  
Priority: normal OS Version: Any  
Status: acknowledged Product Version: 5.1.12  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Schema Compare gives wrong SQL script for changes in CONSTRAINT ... PRIMARY KEY (...)
Description: Firebird schema compare of
source

CREATE TABLE MONITORINGEVENT
(
  ID INTEGER NOT NULL,
  SERVERID INTEGER NOT NULL,
  DATETIME TIMESTAMP NOT NULL,
  STATUSID INTEGER NOT NULL,
  CLASS CHAR( 4) NOT NULL COLLATE NONE,
  CUSTOMDATA VARCHAR( 40) NOT NULL COLLATE NONE,
  TICKCOUNT INTEGER,
  ISUNIQUE VARCHAR( 1) COLLATE NONE,
 CONSTRAINT PK_MONITORINGEVENT PRIMARY KEY (ID, SERVERID)
);

and destination

CREATE TABLE MONITORINGEVENT
(
  ID INTEGER NOT NULL,
  SERVERID INTEGER NOT NULL,
  DATETIME TIMESTAMP NOT NULL,
  STATUSID INTEGER NOT NULL,
  CLASS CHAR( 4) NOT NULL COLLATE NONE,
  CUSTOMDATA VARCHAR( 40) NOT NULL COLLATE NONE,
  TICKCOUNT INTEGER,
  ISUNIQUE VARCHAR( 1) COLLATE NONE,
 CONSTRAINT PK_MONITORINGEVENT PRIMARY KEY (ID)
);

gives wrong script:

ALTER TABLE MONITORINGEVENT
  ALTER SERVERID POSITION 2
;

It should create a script to alter the constraint (or drop-recreate it)

Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1348 [Database Workbench v6] Data Import & Export minor always 2016-03-30 09:01 2022-01-12 11:52
Reporter: Jeroen Pluimers Platform: Windows  
Assigned To: Martijn Tonies OS: Windows  
Priority: normal OS Version: Any  
Status: confirmed Product Version: 5.1.12  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Show hint/warning for CSV/XLS(X) when exporting too many rows and columns
Description: Excel has these limitations: Worksheet size 1,048,576 rows by 16,384 columns.

When exporting more than that many rows or columns, show a warning for XLS/XLSX and a hint when exporting CSV.

Reason: Excel will barf when opening bigger files and complain they are "broken" and suggests "repair" without telling the actual cause.
Tags:
Steps To Reproduce: Create a result set that has more than 1,048,576 rows or 16,384 columns.

Export that to XLS/XLSX/CSV.

Open these files in Excel.
Additional Information:
Attached Files:
Notes
(0000447)
Martijn Tonies   
2018-01-17 12:35   
Another limit: 255 char column width.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1342 [Database Workbench v6] Firebird Module feature N/A 2016-03-15 16:53 2022-01-12 11:52
Reporter: Doychin Bondzhev Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.10  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add support for gfix -list, -rollback and -commit as administrative tasks for Firebird
Description: action in the menu to list limbo transactions
- a table or list that shows transactions will be great.

From there you can select individual or all transactions and run commit or rollback.
Tags:
Steps To Reproduce:
Additional Information: Look at gfix help
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1309 [Database Workbench v6] General feature have not tried 2015-10-29 11:00 2022-01-12 11:52
Reporter: remconijenhuis Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add option to search for String inside all records of all tables of database
Description: I have a MS QSL database with a lot of tables (Microsoft dynamics database, so this means a lot of tables).
I want to be able to find a string inside the records of all these tables.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1304 [Database Workbench v6] Meta Data Compare & Migration minor always 2015-10-21 20:46 2022-01-12 11:52
Reporter: Arno Brinkman Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Stored procedure dependency not taken into account while migrating from IB to IB/FB
Description: When creating a migrate script from InterBase (dialect 1) to InterBase/Firebird the stored procedures are not added in the right order so the script will run successfully.
 
Tags:
Steps To Reproduce: - Create Firebird or InterBase database

- Run next DDL:


SET TERM ^^ ;

CREATE PROCEDURE SP_B (
  I_ID Integer)
 returns (
  ID Integer) AS
BEGIN
  ID = I_ID * I_ID;
  SUSPEND;
END ^^

CREATE PROCEDURE SP_A (
  I_ID Integer)
 returns (
  ID Integer) AS
BEGIN
  FOR
    SELECT sp.ID FROM SP_B(:I_ID) sp
  INTO
    ID
  DO
    SUSPEND;
END ^^

SET TERM ; ^^


- Call migrator wizards and output script will use alphabetic order
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1294 [Database Workbench v6] Diagramming feature N/A 2015-10-08 14:04 2022-01-12 11:52
Reporter: Arno Brinkman Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Scale value request by page setup
Description: Many times we have a lot of objects and lines on a Diagram, but we don't want to print them on too many pages.
Thus the ability to enter a scaling paramter by the "page setup" would be great, so that we can adjust it in that way that everything fits on 1 page.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1293 [Database Workbench v6] Diagramming feature N/A 2015-10-08 13:59 2022-01-12 11:52
Reporter: Arno Brinkman Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Moving complete FK-line
Description: Ability to move the whole FK-line and not only the separate points.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1291 [Database Workbench v6] Diagramming feature N/A 2015-10-08 13:46 2022-01-12 11:52
Reporter: Arno Brinkman Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Invisible grid size configurable
Description: When moving drawing objects they snap to grid-points, would be nice if the size of the gris-points (snap-points?) would be configurable.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
226 [Database Workbench v6] Diagramming feature N/A 2012-01-18 11:41 2022-01-12 11:52
Reporter: stuartclennett Platform:  
Assigned To: OS: Win  
Priority: normal OS Version: 7  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to reverse PDG into CDG
Description: My main development tool for a database is the CDG file. It allows creation of any physical diagram.

Thus being able to "reverse engineer" from a physical into a conceptual would be of great assistance after having reverse engineered from a database into a physical diagram.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1631 [Database Workbench v6] InterBase Module feature have not tried 2018-07-31 13:15 2022-01-12 11:50
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Collect statistics for executing a stored procedure
Description: Collect statistics for executing a stored procedure, just like with statistics in SQL Editor.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1630 [Database Workbench v6] Firebird Module feature have not tried 2018-07-31 13:15 2022-01-12 11:50
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Collect statistics for executing a stored procedure
Description: Collect statistics for executing a stored procedure, just like with statistics in SQL Editor.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1645 [Database Workbench v6] General feature have not tried 2018-10-05 15:50 2022-01-12 11:39
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to group databases into labelled groups instead of folders
Description: In the Enterprise Manager, under the 'Databases' node of each server, have the ability to group by labels in which a database can have multiple labels.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1955 [Database Workbench v6] General minor have not tried 2022-01-11 09:57 2022-01-11 09:57
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Windows taskbar button for the application doesn't move to 2nd monitor
Description: Windows taskbar button for the application doesn't move to 2nd monitor
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1951 [Database Workbench v6] Firebird Module feature have not tried 2022-01-10 10:13 2022-01-10 10:13
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add DDL privileges to Role and Database User Editor
Description: Add DDL privileges to Role and Database User Editor
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1930 [Database Workbench v6] General minor have not tried 2021-11-09 11:48 2021-11-09 11:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Specific workspace problem after refreshing/connecting
Description: "already has a NavProjectID" error raised after specific sequence of events.
Tags:
Steps To Reproduce: 1. connect to database on a server with a server side repository of databases
2. select 'refresh database list' on the server node
3. connect to a database already connected to
4. error raised

> not always reproducable ...
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1927 [Database Workbench v5] MySQL Module minor always 2021-10-22 14:37 2021-10-26 11:37
Reporter: Svein Erling Tysvær Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: feedback Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Importing what was just exported fails
Description: To transfer between two MariaDB databases I tried to use DBW to export as tab-separated file from one database, then import the file to the other and whilst the export worked flawlessly, two issues came up during import:

1) My computer uses the date format dd.mm.yyyy and dates where reported to be incorrectly formatted (the export stores as dd.mm.yyyy, I think the import expects yyyy-mm-dd)
2) Fields defined as Bit gave an error message about field to long when importing
Tags:
Steps To Reproduce:
Additional Information: I am on DBW 5.7.6 and don't know whether newer versions work better. The first of these issues I avoided by writing a tiny program that reformats the dates, whereas the second can be avoided by not using Bit as field type. Just thought you might want to know about these issues so that you can choose whether or not to fix them.
Attached Files:
Notes
(0000558)
Martijn Tonies   
2021-10-26 11:37   
What export format are you using?


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1783 [Database Workbench v6] General feature have not tried 2020-05-07 11:30 2021-09-13 13:52
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to automatically run SQL statements after connecting to a database
Description: eg, setting the timeout for interactive connections on MySQL.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1914 [FB TraceManager] General feature always 2021-09-13 09:10 2021-09-13 09:20
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: After 3.7.0  
    Target Version:  
Summary: Increase max trace events in Trial Edition
Description: Make TRIAL edition more useful by increasing the limit for parsed trace events
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1599 [Database Workbench v6] General tweak have not tried 2018-04-26 13:40 2021-08-05 14:21
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add button in SQL Editor to clear SQL without asking for save
Description: Add button in SQL Editor to clear SQL without asking for save
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1910 [Database Workbench v6] Firebird Module feature have not tried 2021-08-04 13:05 2021-08-04 13:05
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Database config viewer for Firebird 4
Description: - database config settings viewer? ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-config-table )
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
959 [Database Workbench v6] Oracle Module feature have not tried 2014-07-09 14:46 2021-07-14 09:18
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to easily grant roles to routines
Description: - grant Roles to Routines ( http://docs.oracle.com/cd/E16655_01/network.121/e17607/dr_ir.htm#DBSEG983 )
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1886 [Database Workbench v6] General feature have not tried 2021-06-09 12:50 2021-06-09 12:50
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Additional syntax highlighting settings
Description: - highlight system data types
- highlight table, view, stored routine names
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
23 [Database Workbench v6] General feature N/A 2011-05-20 05:09 2021-06-08 14:12
Reporter: Bob Taylor Platform: Windows  
Assigned To: OS: Vista  
Priority: normal OS Version: SP2  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add a "Single Record" mode to the Data Viewer
Description: It would be nice if the Date Viewer (the Data tab within the Table Editor dialog) has a button that would toggle between multiple record view (where the columns go from left to right) and single record view (where the columns go from top to bottom). Currently, the Data Viewer only supports the multiple record view.
Tags:
Steps To Reproduce:
Additional Information:
System Description
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
263 [Database Workbench v6] Oracle Module feature have not tried 2012-02-16 10:27 2021-06-08 14:09
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Create Trigger Debugger for Oracle
Description: Create Trigger Debugger for Oracle
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
899 [Database Workbench v6] General feature have not tried 2014-04-29 22:33 2021-06-08 14:09
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to extract procedures, triggers, functions and view statements for re-compiling
Description: Ability to extract procedures, triggers, functions and view statements for re-compiling
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
943 [Database Workbench v6] Oracle Module feature have not tried 2014-06-10 16:30 2021-06-08 14:09
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Create a "sensitive data Wizard"
Description: - "sensitive data" Wizard ( http://docs.oracle.com/cd/E16655_01/network.121/e17607/tsdp.htm#DBSEG862 )
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
990 [Database Workbench v6] General tweak have not tried 2014-08-11 16:54 2021-06-08 14:07
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to select object/project from Edit To-Do Item window (for new to-do list items)
Description: Ability to select object/project from Edit To-Do Item window.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1382 [Database Workbench v6] SQL & Parameter Insight minor always 2016-05-17 18:02 2021-06-08 14:06
Reporter: Jeroen Pluimers Platform: Any  
Assigned To: Martijn Tonies OS: Any  
Priority: normal OS Version: Any  
Status: acknowledged Product Version: 5.1.12  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: SQL code completion doesn't work in “SQL Script” editor
Description: SQL code completion doesn't work in “SQL Script” editor

Please make it work (:
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1480 [Database Workbench v6] Data Import & Export feature N/A 2017-03-14 22:25 2021-06-08 14:06
Reporter: Doug Chamberlin Platform: All  
Assigned To: Martijn Tonies OS: All  
Priority: normal OS Version: All  
Status: acknowledged Product Version: 5.2.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Make import from CSV text file easier
Description: This request is to add the ability for DBWB to import a CSV file by only selecting the file. It assumes the file contains field names in first row. The resulting table will have a name based on the file name being imported and all fields will be varchar. (Or, if DBWB wants to analyze the data it can set more appropriate field types.) NULL values are always allowed in all fields to avoid errors if a row has missing data. No primary key is defined - that can come later.

The idea is to get the data into the RDBMS as easily as possible without a lot of work by the user.

Current export operation is almost as easy as needed. Employing a stored set of configuration choices, and only asking the user for the name of the stored set, would be a big plus in making this operation even easier than it already is.
Tags:
Steps To Reproduce:
Additional Information: DBWB covers the traditional database circumstances very well. However, a new scenario has emerged as prevalent - ad hoc data processing. This is characterized by fast, efficient movement of data between systems for one-time analysis. Usually CSV text files are employed and extremely efficient operations are critical, sometimes at the expense of "proper" data handling. For example, importing a table into all varchar fields is preferred over accurately defined field types if the operation can be done automatically.

This request enables DBWB to service this new type of DB usage.
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1456 [Database Workbench v6] Diagramming feature have not tried 2016-11-28 15:27 2021-06-08 14:04
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to link a "note" object to a specific item
Description: Ability to link a "note" object to a specific item
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1431 [Database Workbench v6] General feature have not tried 2016-09-14 17:50 2021-06-08 14:04
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Make "search in database" quickly available from within code editors
Description: There already is a context menu option for it, but make "search in database" quickly available from within code editors, perhaps as a panel.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1457 [Database Workbench v6] Microsoft SQL Server Module minor have not tried 2016-11-28 15:53 2021-06-08 14:02
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Missing Types report
Description: Missing Types report, there's no Types report available.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1434 [Database Workbench v6] Meta Data Compare & Migration feature have not tried 2016-09-16 13:21 2021-06-08 14:01
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to keep Serial from PostgreSQL to SQL Server and convert NEXTVAL default
Description: Ability to keep Serial from PostgreSQL to SQL Server and convert NEXTVAL default
Tags:
Steps To Reproduce:
Additional Information: I see that you convert the SERIAL data type in IDENTITY but I think it should be maintained as SERIAL now that MS SQL Server has that type of column.

Example (SQL Server migrate script):

--
-- PostgreSQL original table
--
CREATE TABLE public.avvocati (
  cd_avvocato SERIAL,
  ds_avvocato VARCHAR(50) NOT NULL,
  ...
  CONSTRAINT avvocati_pkey PRIMARY KEY(cd_avvocato)
);

--
-- migrated to SQL Server table
--
CREATE TABLE dbo.avvocati (
    cd_avvocato BigInt IDENTITY NOT NULL, ** this should be SERIAL **
    ds_avvocato VarChar(50) NOT NULL,
    ...
    CONSTRAINT PK_avvocati PRIMARY KEY CLUSTERED (cd_avvocato)
)
GO

ALTER TABLE dbo.avvocati
  ADD CONSTRAINT DF_avvocati_cd_avvocato DEFAULT nextval('avvocati_cd_avvocato_seq'::regclass) FOR cd_avvocato
GO

--

The default value (example)

ALTER TABLE dbo.aliquote_iva ADD CONSTRAINT DF_aliquote_iva_aiv_codice DEFAULT nextval('g_tabelle'::regclass) FOR aiv_codice

should be translate with

ALTER TABLE dbo.aliquote_iva ADD CONSTRAINT DF_aliquote_iva_aiv_codice DEFAULT NEXT VALUE FOR dbo.g_tabelle FOR aiv_codice

because "nextval('g_tabelle'::regclass)" is a PostgreSQL only implementation.
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1609 [Database Workbench v6] Meta Data Compare & Migration feature have not tried 2018-06-11 11:06 2021-06-08 14:00
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to print/save Database Compare results
Description: Ability to print/save Database Compare results
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1632 [Database Workbench v6] General feature have not tried 2018-08-13 08:39 2021-06-08 13:59
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to edit values for multiple parameters and variables while debugging procedure, same dialog as when starting debugger
Description: Ability to edit values for multiple parameters and variables while debugging procedure, same dialog as when starting debugger
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1765 [Database Workbench v6] General feature always 2020-03-10 12:05 2021-06-08 13:34
Reporter: Svein Erling Tysvær Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Feature request: Being able to see field type of output fields in SQL Editor
Description: I had a query (simplified):

SELECT MyDate
FROM MyTable
UNION
SELECT '01.01.2020'
FROM RDB$DATABASE

(the local shortdate format is dd.mm.yyyy)

and noticed this query returned varying formats, e.g.

2019-02-12
01.01.2020

It was my fault and very simple to fix:

SELECT MyDate
FROM MyTable
UNION
SELECT CAST( '01.01.2020' AS DATE )
FROM RDB$DATABASE

but it also made me desire to be able to see the format of output fields (so that I could have noticed that the output field was (probably) (VAR)CHAR and not DATE before executing the query).
Tags:
Steps To Reproduce:
Additional Information: Ideally, I would like to be able to see the fields as they would have been in a CREATE TABLE statement (obviously without any table name since output datasets aren't named).
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1885 [Database Workbench v6] General feature have not tried 2021-06-08 11:02 2021-06-08 11:02
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Easily copy column names to clipboard
Description: - context menu in DB Navigator
- context menu in Table Editors
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1879 [Database Workbench v6] Installer feature have not tried 2021-05-15 12:55 2021-05-15 12:55
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to install for all users or current user
Description: Ability to install for all users or current user.

For Pro and Enterprise.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1878 [Database Workbench v6] PostgreSQL Module tweak have not tried 2021-05-12 13:29 2021-05-12 13:29
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Minor improvements
Description: - COLLATE support for table columns
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1865 [FB TraceManager] General minor have not tried 2021-03-14 10:56 2021-03-14 11:01
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: After 3.7.0  
    Target Version:  
Summary: Grid - Export to CSV - Remove carriage return (CR) to not break import in e.g. Excel
Description: n.a.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1860 [FB TraceManager] Hotspots Analysis minor always 2021-02-27 18:39 2021-02-27 18:42
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: resolved Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: After 3.7.0  
    Target Version:  
Summary: Loaded visual column definition isn't applied to the underlaying grid correctly
Description: n.a.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1848 [Database Workbench v6] Oracle Module feature have not tried 2021-02-05 09:08 2021-02-05 09:08
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add functionality for LOB storage clause/parameters
Description: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_7002.htm#i2218765
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1849 [Database Workbench v6] Firebird Module feature have not tried 2021-02-05 09:08 2021-02-05 09:08
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add functionality to recalculate constraint based indices
Description: Add functionality to recalculate constraint based indices
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1667 [Database Workbench v6] Diagramming feature have not tried 2019-01-17 12:17 2020-10-22 09:37
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to add script sections to physical diagram, reverse engineering should include 'collect script' option for sequences etc
Description: Ability to add script sections to physical diagram

- multiple sections of script, for creation of procedures and other non-table related objects
- during reverse engineering, add ability to collect script for additional database objects
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1664 [Database Workbench v6] Diagramming feature have not tried 2019-01-09 14:24 2020-10-22 09:37
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: New Table/entity sub-model features
Description: - Ability to expand sub-model in treeview to list tables in the sub model
- Allow to filter by a table name and see the sub-models, in which it has been used
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1661 [Database Workbench v6] Diagramming feature have not tried 2019-01-09 14:19 2020-10-22 09:37
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to modify object rectangles and display scrollbar
Description: Ability to modify object rectangles and display scrollbar

Tags:
Steps To Reproduce:
Additional Information: "we have some really large tables - for example table Client - and we used to reduce their rectangle in CaseStudio
I understand that the column high-lighting that you implemented when clicking on a foreign key (FK) constraint link may not work any more, either a scrollbar could come to the rescue or the column is not shown in the cropped area of the table rectangle"
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1662 [Database Workbench v6] Diagramming tweak have not tried 2019-01-09 14:22 2020-10-20 10:58
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Small diagram improvements
Description: - order sub-models by name instead of creation order in treeview/model pages (except for 'Main')
- ability to modify background (canvas) color
- ability to modify FK column format
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1666 [Database Workbench v6] Diagramming feature have not tried 2019-01-17 12:16 2020-10-20 10:58
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: In physical diagrams, ability to view tables by pk-and-fk-columns and ability to set this per object
Description: - In physical diagrams, ability to view tables by pk-and-fk-columns
- set per object ('diagram setting', 'full', ('ids & fks'), 'ids', 'title')
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1663 [Database Workbench v6] Diagramming feature have not tried 2019-01-09 14:23 2020-10-20 10:57
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Default colors for tables/entities in Diagram Settings and/or application Preferences
Description: - have a set of default colors for tables/entities in the Diagram settings and/or application Preferences
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1805 [Database Workbench v6] MySQL Module feature have not tried 2020-08-26 13:45 2020-10-15 13:26
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Display query statistics (MySQL 5.6 and up)
Description: Display query statistics (MySQL 5.6 and up)
Tags:
Steps To Reproduce:
Additional Information: https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profiling.html
Attached Files:
Notes
(0000546)
Martijn Tonies   
2020-10-15 13:26   
Issue: prepared statements that are executed, are not profiled with statistics.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
321 [Database Workbench v6] Meta Data Compare & Migration minor always 2012-04-13 15:29 2020-09-09 14:06
Reporter: Eduardo A Salgado Platform: Intel x86 32 bit  
Assigned To: OS: Windows  
Priority: normal OS Version: 7 Pro  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to create an update script with each statement on its own
Description: Have a suggestion for your fine product.

When doing database compare, the program suggests an update script. Excellent.

My suggestion is to make that script more verbose so it is more likely to run without exceptions.

For example:
{code}
ALTER TABLE CICLIENTADVERTISER
  ADD EQUIVCODE VARCHAR( 10) COLLATE NONE
,
  ALTER TRAFFICID TYPE VarChar(38)
  , ALTER CFCODE1 TYPE VarChar(38)
  , ALTER CFCODE2 TYPE VarChar(38)
;
{/code}

May not run because the TrafficID, for example, is contained in a stored procedure. So, if one ignores, the ADD does not "take" nor the other ALTER. Or one may have to ABORT the entire script.

So I suggest you make it more verbose like:
{code}
ALTER TABLE CICLIENTADVERTISER ADD EQUIVCODE VARCHAR( 10) COLLATE NONE;
ALTER TABLE CICLIENTADVERTISER ALTER TRAFFICID TYPE VarChar(38);
ALTER TABLE CICLIENTADVERTISER ALTER CFCODE1 TYPE VarChar(38);
ALTER TABLE CICLIENTADVERTISER ALTER CFCODE2 TYPE VarChar(38);
{/code}

So, one can take note of which statement to "ignore" and then go back and work with that/those few.

In some cases there may be several ADD together with some ALTER and it slows down the process.

Just a suggestion.

Thanks for listening.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000082)
Patrick Moloney   
2012-05-02 20:53   
This might make it easier to identify what the dependency is.
I'm not sure how much that will help, but perhaps a small help.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
252 [Database Workbench v6] Meta Data Compare & Migration feature always 2012-02-02 13:06 2020-09-09 14:05
Reporter: harriv Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Make possible setting default values for Database compare options
Description: I need to always remember turn “Ignore current value” for generators off for not messing up with data.. (generator value is part of data, not schema).
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
852 [Database Workbench v6] Meta Data Compare & Migration major always 2014-03-23 09:52 2020-09-09 14:05
Reporter: Martin Kerkhoff Platform: Desktop win64  
Assigned To: Martijn Tonies OS: windows 7  
Priority: normal OS Version: 7 64bit  
Status: acknowledged Product Version: 4.4.5  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: error when syncing nesteted procs
Description: When sysncing 2 firebird Databases which contains stored procs the following problem/ bug exists:
in the source database stored Proc DOSOMETHING1 uses a stored proc DOSOMETHING2. in the sync Script the creation of DOSOMETHING2 appears after the creation of DOSOMETHING1 which result in an error "procedure DOSOMETHING2 unknown". in this case the creation order of procedures is sigificant for working correct in running the sync script.
Tags:
Steps To Reproduce: ceate Proc 2
create proc1 wich uses proc2
try to sync
-> voila!
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1748 [Advanced Data Generator] General feature have not tried 2019-12-18 09:58 2019-12-18 09:58
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Ability to create 'a-b rows per master' on a weighed basis
Description: For example,

ORDER
ORDERLINES

There should be 1-20 orderlines per order, but mostly 1 orderline and 5-8 orderlines.

Possible, enter 1-to-20 and have a slider to give more weight to certain values.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1744 [Advanced Data Generator] General feature have not tried 2019-12-05 09:46 2019-12-05 09:46
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Ability to create projects without database connection
Description: eg, to generate JSON/YAML data, without a database as the structure definition.

1. 'create new project'
2. 'create item'
3. 'create field on item', set settings
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
429 [Database Workbench v6] SQL & Parameter Insight feature always 2012-08-20 09:45 2019-12-03 08:49
Reporter: Milan Tomes Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Automatic metadata refresh
Description: - implement feature about automatic metadata refresh when DDL command was triggered in SQL editor.
- add "Refresh cached Metadata info from database" into table editor toolbar.
- fix error when I use function refresh metadata from DB - table editor looses table selection
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
425 [Database Workbench v6] General block have not tried 2012-08-17 10:25 2019-12-03 08:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Failure to reconnect after hibernation wake-up
Description: Failure to reconnect after hibernation wake-up
Tags:
Steps To Reproduce: > - fix problem with reconnection after hibernation. When I was connected
> to MySQL database application will raise some exceptions (first of all
> is connected to Nexus DB and thats funny, because I don't use it, but
> this one is repairable using reconnect all command, but the next one
> "Internal program error in TDBW_Session.GetConnection(0)" is raised
> everytime I open connection combo box in SQL editor and I don't know ho
> to repair it without restarting the application)
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
813 [Database Workbench v6] General tweak have not tried 2014-02-14 12:33 2019-12-03 08:49
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Template for "quick browse" SQL, so users can customize it
Description: Template for "quick browse" SQL, so users can customize it
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
265 [Database Workbench v6] Microsoft SQL Server Module feature N/A 2012-02-21 11:51 2019-12-03 08:49
Reporter: Magne Rekdal Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to see multiple recordsets returned from stored procedures
Description: MS SQL Supports multiple recordsets returned from a stored procedure, and I would like to see this supported in DBW as well.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
873 [Database Workbench v6] General feature have not tried 2014-04-07 10:14 2019-12-03 08:48
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to include Backup/Restore projects when exporting user registration data
Description: Ability to include Backup/Restore projects when exporting user registration data
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1727 [Advanced Data Generator] General feature have not tried 2019-11-20 14:28 2019-11-20 14:51
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Ability to map a lookup column to an external file
Description: this can be useful when you want to match, for example, product descriptions to image blobs.


Desc - ImgID
CD Player - 12904.jpg
Radio - 12211.jpg

Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1707 [Hopper] Firebird minor have not tried 2019-09-10 13:55 2019-09-11 14:28
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Firebird 3 SQLSTATE in WHEN clause fails to compile
Description: See
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-psql-whensqlstate.html

And ability to use SQLSTATE in WHEN .. DO clause to process it:

    when sqlstate '22006'
    do begin
         error_sqlstate = sqlstate;
       end
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1685 [IB LogManager] IBLMPump crash always 2019-04-17 18:14 2019-04-17 18:14
Reporter: Plutarco Gonzalez Platform: any  
Assigned To: OS: any  
Priority: high OS Version: any  
Status: new Product Version: 2.12.5  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: IBLMPump SQL error code = -204
Description: Remote database was created using sql script from IBLogManager application, we have tested coneccion using IBExpert and everything seems fine.

We are runnign IBLPump in source machine using:
IBLMPump -i iblmpump.ini -v iblmpump.log -s

and we got the following error in DOS console:
Exception EIB_ISCError in module IBLMPump.exe at 00100C5C.
ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
Tags:
Steps To Reproduce: Source database
Windows 10 / Firebird v2.5
IBLogManager Installed and working properly

We have tested with 2 different remote databases once time
Ubuntu 16.04
Firebird v2.5

Windows 7 PRO
Firebird v2.5
Additional Information: We have checked iblmpump.log but we couldn’t fing anything about this error.

======= iblmpump.log
IBLMPump V2.12.5.45 - IBLM Log Data Pump Utility
Registered to: Grupo Aduanal Galvan SC
-1 User License-
© 2004-2013 by Upscene Productions
All rights reserved.
------------------------------------------------------------
08/04/2019 11:41:34 a.m.: Read 'C:\Users\dbsp\Downloads\IBLMPump\iblmpump_gag.ini' ...
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1628 [Advanced Data Generator] Pro Edition feature have not tried 2018-07-20 11:09 2018-07-20 11:11
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Support Stored Procedures in all ADO and ODBC connections
Description: Support Stored Procedures in all ADO and ODBC connections
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1625 [Database Workbench v5] Diagramming minor always 2018-07-06 10:30 2018-07-06 10:30
Reporter: Stephen Lappin Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 5.4.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Default collation drop-down is empty
Description: In Table properties (MySQL) Options tab, the Default Collation drop-down only offers [default] as an option.

Would expect to be offered the same list as offered in Model Option dialogue.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files: 2018-07-05_15h03_07.png (67,018 bytes) 2018-07-06 10:30
https://tracker.upscene.com/file_download.php?file_id=61&type=bug
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1540 [Database Workbench v5] General minor always 2017-10-23 14:02 2018-06-29 09:28
Reporter: Michiel Spoor Platform: Windows  
Assigned To: Martijn Tonies OS: Windows  
Priority: normal OS Version: 10  
Status: feedback Product Version: 5.3.0  
Product Build: Resolution: reopened  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Please check position of main form on startup (multi monitor support)
Description: I work on a laptop with a regularly changing multimonitor configuration. Day 1 I have tree monitors alongside, and day 2 I could work on a spot with one monitor above, one under.
It seems that DBW saves it last known position on the desktop and repositions on new startup to that exact spot. Neat and usefull, no argument.
BUT... and this is one BIG but for me..... (you feel it coming).... It would be greatly appreciated if you could first check whether that position is still 'in view' of the current monitor setup.

More than once I've found myself looking for the application after the splash screen (which does show on an active monitor), being unable to find it.
Yes, I know of a cumbersome workaround to get it back in focus (rightclicking the taskbar icon, selecting 'move', use cursors, and then mouse), but even that is not always working.

So, there it is :-)
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000434)
Martijn Tonies   
2017-10-23 14:33   
Actually, there IS a check to see if it's still 'in view'.

Can you give steps to reproduce?

Are you using any specific multi-monitor software (like UltraMon)?
(0000435)
Michiel Spoor   
2017-10-23 14:59   
(Last edited: 2017-10-23 15:00)
I'm not using any special multi-monitor software.

Okay, when I muck around with my Windows monitor setup on this specific workspot I see your point, Thumbs up!
 
So either it has to do with a difference at my second location (where I work with the HDMI port of my laptop, instead of via my USB3 extender), or there is something different in play.
I will check more thoroughly the coming days!

(0000437)
Michiel Spoor   
2017-10-30 15:55   
(Last edited: 2017-11-03 08:51)
Okay, hoping it is any help to you, here is some additional info:

Working at place A:
 three monitors setup:
     2 - 3 - 1
 2 and 3 on a USB3-docking-thing, 1 is the laptopscreen itself
   2 = 1920 x 1080
   3 = 1280 x 1024
   1 = 1920 x 1080
 
Working at place B
 two monitor setup:
     1 - 2
   1 = 1920 x 1080 (laptop main screen)
   2 = Laptop HDMI connector (1280 x 1024)

After using DBW at place B on the 2-nd monitor, when coming to place A, I cannot get to the main-form any more.
When I change my monitor-setup in Windows to a 1 - 2 - 3 setup, I can see it again, and move it to another monitor and switch back to 2 - 3 - 1 config.

(0000438)
Michiel Spoor   
2017-11-03 08:50   
One additional piece of information which might have something to do with it:
In setup A, I have defined external monitor 2 as primairy display (hoofdbeeldscherm). In setup B the primairy monitor is 1.
(0000460)
Martijn Tonies   
2018-04-25 09:54   
Michiel, when you switch from B to A, where does DBW end up? As in: when you move it using cursors, what side does it come from?
(0000463)
Michiel Spoor   
2018-04-30 12:12   
I am unsure where it came from (had to select move from the icon on the taskbar, and then use keyboard and mouse moves to make it visible on monitor again).
If I had to point any direction, I think it came from the far right.
It's been a while since I worked in the setup switch though.
I do understand it's all an extreme cornercase, so I won't blow you up if you can't find the source of this one ;-)
(0000468)
Michiel Spoor   
2018-06-29 09:28   
Hi, I've found a way to reproduce the problem I face when switching between laptop work-places, by manipulating the Windows primairy monitor setting:

Starting with a Windows 10 config of three monitors (possibly works with 2 as well):

- I start with the following monitor setup
     [monitor 2] [monitor 3] [monitor 1]
  where monitor 1 is Windows 'primairy' / 'Hoofdbeeldscherm'
- Now start DBW5 and put it on monitor 2 (the left-most)
- Close DBW5 while on monitor 2
- Now make monitor 2 the primairy / hoofdbeeldscherm in Windows
---> now start DBW5 and see that it is not showing on any monitor...


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1620 [Database Workbench v5] Diagramming minor sometimes 2018-06-27 11:14 2018-06-27 11:14
Reporter: Stephen Lappin Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version: 5.4.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Check Model should report FK data type discrepancies
Description: On running Check Model, validation messages are generated when col for FK is not defined.

I would expect it also to report FKs where there is a discrepancy in column data types.

E.g.
Integer vs BigInt
BigInt UNSIGNED vs BigInt

Currently, such discrepancies only come to light when you execute the generated DDL, and MariaDB/MySQL halts with an error
Tags:
Steps To Reproduce: Created table_a with PK (id BigInt UNSIGNED NOT NULL AUTO_INCREMENT).
Created table_b with a column (table_a_id BigInt NOT NULL)
Create FK fk_table_b_table_a FOREIGN KEY (table_a_id )
  REFERENCES table_a (id)
Execute Check Model - no validation errors reported
Generate DDL
Run DDL - errors creating FK.
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1557 [Hopper] MySQL feature have not tried 2018-01-03 10:23 2018-01-03 10:23
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Support for MySQL Azure
Description: Support for MySQL Azure
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1502 [Database Workbench v5] General feature N/A 2017-05-28 11:52 2017-05-30 14:30
Reporter: Kim Sandell Platform: Any  
Assigned To: Martijn Tonies OS: Any  
Priority: normal OS Version: Any  
Status: acknowledged Product Version: 5.3.0  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add support for CockroachDb (CRDB)
Description: Add support for CockroachDb (CRDB). This is the new distributed database from CockroachLabs.com that will hopefully change the way we use databases.

Based on PostgreSql wire protocol.
Tags:
Steps To Reproduce: n/a
Additional Information: www.cockroachlabs.com
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1466 [Database Workbench v5] Firebird Module major always 2017-01-25 23:41 2017-01-26 09:03
Reporter: Chris Platform: Windows  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: can not get output from firebird execute block of code
Description:
When trying to execute code against the server from the SQL Script tab of a Query window there is no place to get the place to get results from the execute block of code.
Tags:
Steps To Reproduce:
connect to a firebird database.
goto Script tab
execute script that should give output
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1411 [Database Workbench v5] MySQL Module minor have not tried 2016-08-30 18:44 2016-08-30 18:45
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Error with foreign key pointing to unique index instead of to constraint
Description: Error with foreign key pointing to unique index instead of to constraint
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1409 [Database Workbench v5] Sybase SQL Anywhere Module feature have not tried 2016-08-30 12:46 2016-08-30 12:52
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Support encryption in connections
Description: See
17: http://dcx.sap.com/index.html#sqla170/en/html/81408d9a6ce2101493b9c3bd4a39e77e.html
16: http://dcx.sybase.com/index.html#sa160/en/dbadmin/encryption.html
12: http://dcx.sybase.com/index.html#1201/en/dbadmin/encryption.html
11: http://dcx.sybase.com/index.html#1101/en/dbadmin_en11/encryption.html
10: http://dcx.sybase.com/index.html#1001/en/dbdaen10/da-encryption.html
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1350 [Database Workbench v5] General feature always 2016-04-04 13:52 2016-04-05 13:03
Reporter: Volker Becker-Huberti Platform: Windows  
Assigned To: OS: 7  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.12  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Option to suppress linefeeds in strings to display more text in grid cells
Description: DBW5 does show only the first line of text in the cells when a text contains linefeeds. To open the blob editor every time is pretty circuitous and doesn't give a good overview as for example DBW3 gave. An option to suppress linefeeds is pretty desirable.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1290 [Database Workbench v5] Diagramming feature N/A 2015-10-08 13:43 2015-10-08 15:40
Reporter: Arno Brinkman Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.1.4  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Possibility to move all drawing objects in very tiny steps
Description: The possibility to move "objects/lines/points of lines" in very small steps up and down to finetune the diagram visually.

SHIFT-key:

Now when holding the CTRL-key i can move the object with the cursor-keys, would be nice when holding "CTRL-key + SHIFT-key" the object would move in tiny steps and not the "snap" distance.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1282 [Database Workbench v5] Firebird Module major always 2015-09-28 09:33 2015-09-28 10:18
Reporter: Michał Ziemski Platform: x86_64  
Assigned To: Martijn Tonies OS: Win  
Priority: normal OS Version: 10  
Status: feedback Product Version: 5.1.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Exeption from "execute statement" swallowed in selectable "execute block"
Description: When using an "EXECUTE STATEMENT" that throws in an "EXECUTE BLOCK" procedure
the exception is not reported and the execution stops without any feedback.
Tags:
Steps To Reproduce: Example:

execute block returns (id int)
as begin
 execute statement 'dasdasda';
 suspend;
end

should show the exception
Additional Information:
Attached Files:
Notes
(0000388)
Martijn Tonies   
2015-09-28 10:18   
In the Script Editor?


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1259 [IB LogManager] IBLMPump crash always 2015-07-10 15:36 2015-07-10 15:47
Reporter: Vitalij Platform:  
Assigned To: OS: Windows  
Priority: high OS Version: 7  
Status: new Product Version: 2.12.5  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Background pumping killing disks
Description: When using IBLMPump in background pumping mode, abnormal amount of IO operations are generated on disks where transaction log database is located.
When normally we have about 50 I/O operations per second (IOPS) on the disks with IBLMPump running there is around 30 000 I/O operations per seconds on the disks. As a result replication crashes.
Is there a way to tweak application so it won't kill disks?
Tags:
Steps To Reproduce: config:

[Source]
Path=ra.fdb
Charset=UNICODE_FSS
Username=sysadm
Password=xxx
Dialect=3
IBLM_MetadataTable=IBLM$METADATA
LogCurrentGeneratorValues=1
LogCurrentGeneratorValuesEachRun=1
UseEncryptedPassword=1

[Destination]
Path=a-log.fdb
Charset=UNICODE_FSS
Username=sysadm
Password=xxx
Dialect=3
IBLM_MetadataTable=IBLM$METADATA
UseEncryptedPassword=1
CommitInterval=100

[General]
SMTP_Host=smtp.iblogmanager.com
SMTP_Port=25
SMTP_UseAuthentication=0
SMTP_Username=XXX
SMTP_Password=yyy
SMTP_UseEncryptedPassword=0
EmailFrom_Name=IBLMPump Utility
EmailTo_Address=
EmailCc_Address=
EmailBcc_Address=

command: iblmpump.exe -i iblmpump.ini -b -v
Additional Information: IBLMPump is running on Windows 7.
Transaction log database is located on a server running CentOS.
Attached Files:
Notes
(0000382)
Vitalij   
2015-07-10 15:47   
In the same time when IBLMPump is running all free amount of disk space is getting used. As a result DB is crashing.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1228 [Database Workbench v5] Meta Data Compare & Migration minor have not tried 2015-05-19 11:10 2015-05-19 11:10
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Sybase Anywhere module leaks primary key objects when migrating
Description: Sybase Anywhere module leaks primary key objects when migrating.

- object is added to table, but not to list of PKs, not free-ed
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1208 [Database Workbench v5] Firebird Module major sometimes 2015-04-07 15:15 2015-04-08 10:04
Reporter: Michał Ziemski Platform:  
Assigned To: Martijn Tonies OS: Windows  
Priority: normal OS Version: 7  
Status: acknowledged Product Version: 5.0.10  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Editing records in the results pane unreliable
Description: Sometimes the changes made in place in the results pane are not saved.

If there are not enough data to performe the update (no RDB$DB_KEY or primary/unique key in results) the editing should be disabled
If the update fails (row_count in update <> 1) there should be a warning
If there are updates not yet send when commiting a transactions a warning sould be issued.

"Post edited data" should have its own keyboard shortcut.
Right now one has to mouse-navigate to this tiny icon to get data sent.

Right now updates tend to fail silently severely breaking the flow of work.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1193 [Hopper] General tweak have not tried 2015-03-18 17:10 2015-03-18 17:11
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Store and restore workspace layout
Description: Store and restore workspace layout
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1178 [Database Workbench v5] Firebird Module tweak always 2015-02-26 11:05 2015-02-26 11:42
Reporter: Wolfgang Rohdewald Platform: Firebird 2.5, I86 32, Virtualbox  
Assigned To: OS: Windows  
Priority: normal OS Version: Windows 7 Pro  
Status: acknowledged Product Version: 5.0.10  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Add select-statements to assignments to plan analysis
Description: It ignores statements like

x=(select whatever from whereever);
Tags:
Steps To Reproduce:
Additional Information:
System Description
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1179 [Database Workbench v5] Firebird Module minor always 2015-02-26 11:11 2015-02-26 11:40
Reporter: Wolfgang Rohdewald Platform: Firebird 2.5, I86 32, Virtualbox  
Assigned To: OS: Windows  
Priority: normal OS Version: Windows 7 Pro  
Status: acknowledged Product Version: 5.0.10  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: plan analysis on SP does not auto-refresh
Description: after editing the SP, the plan analysis is not updated. Not even after invalidating the schema cache. I have to close the SP editor and reopen it.

I believe this is also true for other things like dependency analysis.
Tags:
Steps To Reproduce:
Additional Information:
System Description
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1157 [Database Workbench v5] Diagramming minor always 2015-01-29 11:59 2015-01-29 12:03
Reporter: Kim Sandell Platform: Windows  
Assigned To: OS: Windows  
Priority: low OS Version: 8.1  
Status: acknowledged Product Version: 5.0.8  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: DBW custom dialogs open on primary monitor even if DBW is on the secondary monitor
Description: DBW custom dialogs open on primary monitor even if DBW is on the secondary monitor.
Tags:
Steps To Reproduce: 1. Move DBW to secondary monitor
2. Edit a table
3. Access "Column Specials" for a column (opens on the primary monitor)
Additional Information: I think Delphi forms have a POSITION property, that should be set to "poOwnerFormCenter" propery..
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1144 [Database Workbench v5] Firebird Module minor always 2015-01-17 19:30 2015-01-19 11:37
Reporter: Wolfgang Rohdewald Platform: I86 32, Virtualbox  
Assigned To: Martijn Tonies OS: Windows  
Priority: normal OS Version: Windows 7 Pro  
Status: feedback Product Version: 5.0.6  
Product Build: Resolution: reopened  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: refresh list of tables or list of table columns does not see newly added or removed fields
Description: make dbw connect to a data base, show a table editor

use an external tool to add or remove fields to/from the table shown

right mouse click on the list of tables or on the list of columns: the field list does not change, neither in the left hand navigator nor in the table editor.

using firebird 2.1
Tags:
Steps To Reproduce:
Additional Information:
System Description
Attached Files:
Notes
(0000333)
Martijn Tonies   
2015-01-19 09:30   
Unless you use "fresh from database", in the toolbar of the Navigator, changes won't be seen. This is "as designed".
(0000338)
Wolfgang Rohdewald   
2015-01-19 11:34   
But then what does "refresh list" in the context menus for tables and for fields do? I cannot find that in the online help.

Adding a field to a table in the table editor directly updates the field list in the navigator, so that cannot be it.
(0000339)
Martijn Tonies   
2015-01-19 11:37   
The "refresh list" - currently - is only when tables/procedures/etc are either added or dropped (completely, not a "child object" like a column).


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1136 [Database Workbench v5] General minor sometimes 2015-01-09 08:03 2015-01-13 12:35
Reporter: Sandy Ganz Platform: Windows  
Assigned To: Martijn Tonies OS: Windows 7  
Priority: normal OS Version: Windows 7  
Status: acknowledged Product Version: 5.0.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Can't close DBWB on connection disconnect due to time out
Description: I had a SSH connection to a remote MySQL server (a VM on my same machine)for most of the day, at some point I shut down the VM and left DBWB open.

Then when trying to close DBWB it asks if I'm sure I want to quit, and after click on 'YES' it does nothing. Only way to close it is to kill it in the task manager
Tags:
Steps To Reproduce: Connect to a mysql database.
Have a table open in the data browser view
some how lose connection to the server the db is on (in my case I shut down the VM with it).
try to exit DBWB
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1133 [Database Workbench v5] General feature always 2015-01-02 09:51 2015-01-13 12:33
Reporter: Wolfgang Rohdewald Platform: I86 32, Virtualbox  
Assigned To: Martijn Tonies OS: Windows  
Priority: normal OS Version: Windows 7 Pro  
Status: acknowledged Product Version: 5.0.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: save/restore workspace layout
Description: Whenever I debug a stored procedure, the first thing I do is rearranging all windows like "Call Stack" etc such that the window for the source code gets the maximum vertical size.

It would be nice if dbw would let me save/restore layouts. One for editing source code, one for debugging etc.
Tags:
Steps To Reproduce:
Additional Information:
System Description
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1126 [Database Workbench v5] Meta Data Compare & Migration major always 2014-12-29 10:46 2014-12-29 10:59
Reporter: Wolfgang Rohdewald Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.0.6  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: generated DDL does not handle circular references in computed fields
Description: I have two tables referencing each other with computed fields.
Extracting DDL for the database generates a script which cannot create a new empty database. IMHO It should first create only dummy definitions for all computed fields and alter them after all tables have been created. Just like it does with procedures.
Tags:
Steps To Reproduce:
Additional Information: This is what DBWorkbench generates:

CREATE TABLE A
(
   ID BIGINT NOT NULL,
   CB COMPUTED BY ((select id from b where id=b.id))
);
CREATE TABLE B
(
   ID BIGINT NOT NULL,
   CA COMPUTED BY ((select id from a where id=a.id))
);
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1047 [Database Workbench v5] Meta Data Compare & Migration minor always 2014-09-28 14:47 2014-12-29 10:36
Reporter: Doychin Bondzhev Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.0.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Script to crete SP after compare is not properly ordered
Description: Now stored procedures are alphabetically ordered in the script. Instead they must be ordered based on the dependency.

Also when 2 procedures depend on each other an empty body must be created first for one of the procedures and then altered to contain the actual body after it's dependency is satisfied.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000326)
Martijn Tonies   
2014-12-29 10:36   
Another example:
The generated sql script first alters a stored procedure A such
that it references new stored procedure B. But it only creates B
later on, so executing the script will fail.

Could you change script creation such that new stored procedures
are created before existing stored procedures are changed?

After having done that manually, I got the next problem:
stored procedure B now has a different list of input parameters.
But the script tries to alter stored procedure A calling B before
altering stored procedure B. So this still fails.
(0000327)
Martijn Tonies   
2014-12-29 10:36   
Fix:

1) alter both procedures so that there's no implementation
2) alter both procedures to hold the new parameters
3) alter both procedures with source code and new calling sequences


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1093 [ADS LogManager] ADS LogManager feature always 2014-10-17 15:12 2014-10-17 15:27
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: resolved Product Version: 3.0.0  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: After 3.0.0  
    Target Version: After 3.0.0  
Summary: Update deployed Advantage client engine to 10.10.0.51
Description: n.a.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1083 [ADS LogManager] ADS LogManager feature always 2014-10-13 18:03 2014-10-13 19:46
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: resolved Product Version: 3.0.0  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: After 3.0.0  
    Target Version: After 3.0.0  
Summary: Don't insert a log record into operation log table when there was no column value change detected and column log
Description: n.a.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1082 [Database Workbench v5] Sybase SQL Anywhere Module feature have not tried 2014-10-13 12:37 2014-10-13 12:37
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Make the spatial data types available in the database object editors
Description: Make the spatial data types available in the database object editors
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1066 [Database Workbench v5] Oracle Module major unable to reproduce 2014-10-06 10:15 2014-10-06 10:15
Reporter: Kim Sandell Platform: Any  
Assigned To: OS: Any  
Priority: normal OS Version: Any  
Status: acknowledged Product Version: 5.0.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: DBW should read & use the Date & Time format settings from the Oracle session
Description: When an Oracle session connects the session params should be read and used, especially for Dates & Times. The output now shows what the local settings are and SQL statements expect the date & time to be in Oracle session format (often different from local settings) making writing statements confusing, and exporting INSERT statements unusable.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1058 [Database Workbench v5] Firebird Module minor always 2014-09-30 17:51 2014-10-01 10:27
Reporter: Christiaan ten Klooster Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.0.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Closing DBWB after idle timeout results in multiple errors
Description: When i close workbench and i have a connection to a FB database that has timed out due to inactivity i get the following messages:

1. Unable to write data to connection (timeout...)
2. Unable to close SQL editor: the editor is in use
3. various BPL exceptions

If i click [X] to close DBWB the fourth time it finally closes...
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000309)
Christiaan ten Klooster   
2014-09-30 17:54   
step 4 is incorrect.. you have to close dbwb using the task manager.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1036 [Database Workbench v5] Firebird Module minor always 2014-09-24 12:09 2014-09-24 12:15
Reporter: Christiaan ten Klooster Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 5.0.2  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Firebird server drops connection for remote connections on idle timeout
Description: When connected to a remote database the default setting for firebird server idle timeout is approx. 60 somewhat seconds. the disconnect is not registered by DBWB and it therefore tries to send the command which will result, after a timeout, in a "Unable to complete network request to host xxxxx: Error writing data to the connection"

After pressing the "Reconnect button" in the enterprise manager you can resume your work.

Since i don't want to change the default idle timeout (for example when using firebird for webservices) i'd like to see an firebird specific preference which will keep the connection alive by some sort of activity in a specified interval. (perhaps a prepare of "select * from rdb$database" is enough?)
Tags:
Steps To Reproduce: Just wait for a minute and perform a query :)
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1014 [Database Workbench v5] Sybase SQL Anywhere Module minor have not tried 2014-09-08 10:55 2014-09-08 10:55
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: new Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: UNSIGNED INT in result set is used as signed int32, causing overflows
Description: UNSIGNED INT in result set is used as signed int32, causing overflows
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
1007 [Database Workbench v5] NexusDB Module feature have not tried 2014-09-01 12:00 2014-09-03 12:54
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Include an embedded server for server-less NexusDB table access
Description: Having an embedded server could be useful for those who don't use a full server for NexusDB development.
Tags:
Steps To Reproduce:
Additional Information: @Eivind[NDD]
in your app, instead of the TnxTransport/TnxRemoteServerEngine, you hook up a TnxServerEngine and TnxSqlEngine, and put the database folder into TnxDatabase.AliasPath. the rest stays prety much the same
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
930 [Hopper] Firebird feature N/A 2014-06-04 09:16 2014-06-04 09:42
Reporter: Svein Erling Tysvær Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version: 1.5.0  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Support for EXECUTE BLOCK
Description: I sometimes write EXECUTE BLOCK statements before deciding whether or not I should turn them into a stored procedure or not (I am careful about adding DDL on production databases, whereas I consider execute block statements that doesn't insert/update/delete pretty harmless). It would be nice if Hopper could support EXECUTE BLOCK as well as triggers/stored procedures.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
896 [Database Workbench v5] Sybase SQL Anywhere Module feature have not tried 2014-04-28 19:27 2014-05-08 08:38
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to use alternative SQL Anywhere JDBC driver during debugging (not jConnect)
Description: Ability to use alternative SQL Anywhere JDBC driver during debugging (not jConnect)
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
897 [Database Workbench v5] Sybase SQL Anywhere Module feature have not tried 2014-04-29 16:05 2014-04-29 16:05
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to view database fragmentation and page usage
Description: Ability to view database fragmentation and page usage
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
262 [Database Workbench v5] Sybase SQL Anywhere Module feature have not tried 2012-02-16 10:16 2014-04-29 15:57
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Create a Trigger Debugger for Sybase SQL Anywhere
Description: Trigger Debugger for Sybase SQL Anywhere
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
893 [Database Workbench v5] Sybase SQL Anywhere Module feature have not tried 2014-04-28 09:28 2014-04-28 09:29
Reporter: Martijn Tonies Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to view and edit database properties
Description: Ability to view and edit database properties
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
838 [IB LogManager] IBLMRedo_cmd block sometimes 2014-03-01 20:17 2014-03-01 20:29
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: resolved Product Version: 2.12.5  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: After 2.12.5  
    Target Version: After 2.12.5  
Summary: Redo may fail with time/timestamp column data
Description: n.a.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
332 [Database Workbench v5] General minor N/A 2012-04-24 08:49 2013-12-18 09:04
Reporter: Johann Sijpkes Platform:  
Assigned To: Martijn Tonies OS:  
Priority: normal OS Version:  
Status: assigned Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Portable version of DBWB
Description: Being a roadwarrior I need to connect to customer's databases all the time. Often I can get access to the network, however, I am not allowed (nor do I want to ) install new software on their systems.
Would very much like DBWB to have a portable mode where it is installed on a USB stick and where it can run from the stick. (This could be a secured device).
Currently I find myself installing DBWB on client machines because I need to do DB compares, and then uninstalling it afterwards.
Moving the databases to my laptop is not an option.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
Notes
(0000245)
Martijn Tonies   
2013-10-11 15:42   
Hello Johann,

Besides installing this software on their machines, are you not allowed to connect your laptop to the network in order to connect to their databases?
(0000246)
Johann Sijpkes   
2013-10-11 18:15   
No.. Normal procedures are that we cannot connect to the network. In some occassions I can connect to internet, but that is always in a DMZ. So an ideal solution would be an install free system on a USB key.
There are software protection schemes like Aladdin (I believe) that allow you to connect software to the USB key. That would protect your interest.
Cheers,
Johann


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
707 [Hopper] General feature have not tried 2013-08-21 13:03 2013-09-10 10:06
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Visually display in code window where an error/warning is raised
Description: Visually display code window where an error/warning is raised.

Currently, the Messages pane show it, but it would be more clear if it also showed something in the code window.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
682 [Hopper] General tweak have not tried 2013-07-24 09:49 2013-07-24 09:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Replace some of the current dialogs with DSA dialogs
Description: Replace some of the current dialogs with DSA dialogs
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
670 [Hopper] General feature have not tried 2013-07-22 15:45 2013-07-22 15:45
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Ability to restart execution on a routine in the call stack
Description: Ability to restart execution on a routine in the call stack.

This would avoid having to go through lots of routines to reach a certain point and re-investigate it's logic.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
664 [Hopper] General feature have not tried 2013-07-19 15:56 2013-07-19 15:56
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Ability to detect data type differences when passing variables/parameters to others routines
Description: Ability to detect data type differences when passing variables/parameters to others routines
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
647 [Advanced Data Generator] General feature have not tried 2013-05-30 10:22 2013-05-30 10:23
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Add-on: Demo Runner
Description:  It would be useful to be able to compile a project so it could be run from a cmd line without the UI. This could then be distributed with a demo system to create a trial database. for example we could populate our data from the run-date so the diary showed events planned for the future.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
503 [Database Workbench v5] General feature have not tried 2013-01-09 10:28 2013-05-01 14:24
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
Summary: Ability to use connected database as project store instead of local config saving
Description: Ability to use connected database as project store instead of local config saving
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
553 [Advanced Data Generator] General feature have not tried 2013-02-19 11:00 2013-02-19 13:15
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Ability to create lookup templates
Description: Ability to create lookup templates, used in projects
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
552 [Advanced Data Generator] General feature have not tried 2013-02-19 11:00 2013-02-19 13:15
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Ability to create project-based lookups
Description: Ability to create project-based lookups
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
472 [Hopper] MySQL feature have not tried 2012-10-09 13:31 2012-10-09 13:31
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Support for DDL statements
Description: Support for DDL statements
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
346 [Hopper] General feature have not tried 2012-05-10 13:49 2012-05-10 13:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Query Plan analysis
Description: Query Plan analysis
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
345 [Hopper] General feature have not tried 2012-05-10 13:48 2012-05-10 13:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Ability to run from USB drive, without installer
Description: Ability to run from USB drive, without installer
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
344 [Hopper] General feature have not tried 2012-05-10 13:48 2012-05-10 13:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Ability to "trace into" triggers when executing DML in stored routines
Description: Ability to "trace into" triggers when executing DML in stored routines
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
343 [Hopper] General feature have not tried 2012-05-10 13:47 2012-05-10 13:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Ability to edit the stored routine
Description: Ability to edit the stored routine
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
342 [Hopper] General feature have not tried 2012-05-10 13:47 2012-05-10 13:49
Reporter: Martijn Tonies Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS Version:
Summary: Ability to search the database for stored code
Description: Ability to search the database for stored code
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
300 [ADS LogManager] ADS LogManager feature always 2012-03-19 09:24 2012-03-19 09:28
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: resolved Product Version: 3.0.0  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: After 3.0.0  
    Target Version: After 3.0.0  
Summary: Additional index on operation log table (columns: TABLE_NAME, OPERATION)
Description: n.a.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
293 [ADS LogManager] ADS LogManager major always 2012-03-14 09:59 2012-03-19 09:28
Reporter: Thomas Steinmaurer Platform:  
Assigned To: Thomas Steinmaurer OS:  
Priority: normal OS Version:  
Status: resolved Product Version: 3.0.0  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: After 3.0.0  
    Target Version: After 3.0.0  
Summary: Logging UPDATE with Unicode data fails
Description: n.a.
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.


View Issue Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
205 [Advanced Data Generator] General feature N/A 2011-12-28 12:55 2012-01-02 10:27
Reporter: Michael Platform:  
Assigned To: OS:  
Priority: normal OS Version:  
Status: acknowledged Product Version:  
Product Build: Resolution: open  
Projection: none      
ETA: none Fixed in Version:  
    Target Version:  
DBMS & Version:
Summary: Add scripting feature to ADG
Description: Hi,

ADG already gives us the possibility to use macros to control the creation of certain field values.

It would be a nice addition if you could add scripting to ADG, e.g. based
on RemObjects PascalScript, Windows Scripting, JavaScript or one one of the various other components available to have a better control about the value generation.

Would be fine if those scripts are available globally if it makes sense for different projects. Loading or saving source code would be fine, too. A syntax highlighting editor would be perfect and round up this new feature.

Thanks,
Michael
Tags:
Steps To Reproduce:
Additional Information:
Attached Files:
There are no notes attached to this issue.