Upscene Tracker

2192

General

major

sometimes

2010-09-10 18:43

2010-09-10 19:26

scarleton

normal

feedback

none

4.0.3

open

"Not enough storage is available to process this command." when clicking on Data tab

I was working in DBW Pro. I opened one of our primary tables which have 39 columns and only two rows. I clicked on the Data table and got the error "Not enough storage is available to process this command." I had to click on the <Ok> button 3 times to make it go away. When I clicked on the Data tab again, it happened, but then I came to write this bug report, I went back and clicked on the Data tab to get the row count and it worked fine.

martijntonies

2010-09-10 18:56

What DBMS?

scarleton

2010-09-10 19:22

Interbase, when I bring up the version in IBConsole, it states WI-V7.5.1.162

martijntonies

2010-09-10 19:26

I have no idea why this would show up in DBW, Google reveals:
http://support.microsoft.com/kb/225782 [^]

2190

MS SQL Module

minor

always

2010-09-09 11:29

2010-09-09 12:14

edelcom

normal

closed

none

4.0.3

no change required

Add progress indication when executing a lot of update statements

I was executing +/- 7500 update statements from within an Sql script window.

These updates take a long time to run, but I have no way of knowing where in the update process the program currently is.

The status bar displays 'running...' , the run query button is disabled, the stop button is enabled, but since I can click the rest of the menu options, I have no way of knowing if the updates are still running or not.

Can you add a progress bar in these kind of scripts ?

Sample of the update statements:

update artikel set a_catcodes = 'aab;aag;abo;aaw;ack;ajv;afw' where a_datum = '2001.10.16' and a_tmp = 1959
update artikel set a_catcodes = ' ' where a_datum = '2001.10.16' and a_tmp = 1963
update artikel set a_catcodes = 'ass;alr;aau;amh;afy;afz;aal;atu;aab;ani;acb' where a_datum = '2001.10.16' and a_tmp = 1966

So nothing special here.

martijntonies

2010-09-09 11:32

The Script Editor has a small progress bar in the bottom statusbar, didn't this run for you?

edelcom

2010-09-09 11:45

I am doing the udpates now per 500 update statements.

You execute the script ... it says running ... no progress bar, after a while you see the update statements appearing in the output windows, still no progress bar, than after a short period, the output says 'Script processed ...' and you see the progress bar very quickly moving from 0% to 100%.

Is there some sort of post processing going on, which does not update the progress bar.

When I was executing the 7500 statements, the output windows was empty all time and no progress bar was visible. It's like the program is builing some internal list during which no screen update is taking place.

Anyway 500 lines is done fairly quickly, the 7500 upates I had to stop after 20 minutes ... and even that cancel took a long time.

martijntonies

2010-09-09 11:47

Hm, it could be the MS module and the script parsing: what about if you end each statement with a ";" character? If not, the complete script is sent to the server as a single statement (ADO & MS SQL allow this).

edelcom

2010-09-09 12:02

If you add the ';' character you see each line being processed in the output window, and now the progress bar is running.

Maybe you could add a warning when update or insert statements are found without a ';' ending character ?

martijntonies

2010-09-09 12:14

The parser is not that advanced. And it is allowed in MS SQL & ADO.

2191

General

feature

always

2010-09-09 12:07

edelcom

normal

new

none

4.0.3

open

Add a feature to export to text without the last column being padded (or the one column being padded).

I was creating update statements from a table in my database like '

select 'update artikel set a_catcodes = ''' + a_catcodes + ''' where a_datum = ''' + Convert( Varchar(25), a_datum , 102) + ''' and a_tmp = ' + Cast( a_tmp as varchar(10)) + ';' as UpdText from artikel where not a_catcodes is null

in order to run these updates another remote database.

I wanted to export these statements to clipboard (or a text file), but the program added trailing spaces behind each statement up to and including the longest value created in this way.

This made the output about 3 times longer than it should be.

I would like to add an option to trim the last column (only column in this case).

2168

Firebird Module

major

always

2010-08-04 12:57

2010-09-09 11:30

edelcom

normal

acknowledged

DbW 4.0.3 en 3.4.4

none

4.0.3

open

Opening table in FB1.5 in DBW4 gives 'arithmetic exception, numeric overflow, or string trunction' error, open it in DBW 3 is ok

I have a Firebird 1.5 database with several tables.

Opening two out of these tables in DBW 4.0.3 produces a 'arithmetic exception, numeric overflow, or string trunction' error.

Opening the same tables in the same database on the same server using DBW 3.4.4 works fine.

As far as I can see , no special data is present in the row which produce the error (I can select and display some rows upto a certain point (using select * from ...) , but as soon as a specific row is reached, DBW 4 throws the error.

The screen dump shown is from a previous pc where DBW 3 was still installed (version .4.4) and om which DBW 4.0.2 was installed also). This pc runs XP Pro.

The error remains in version 4.0.3 (installed on a new Windows 7 Prof pc).

edelcom

2010-08-27 12:16

Where you able to recreate this error in your development environment ? If so, any idea when it could be fixed ?

edelcom

2010-09-09 11:30

Do you receive the database I send by email ?

2189

General

minor

have not tried

2010-09-07 14:54

martijntonies

normal

acknowledged

none

4.0.3

open

Minor user interface errors

- "prompt for password"-functionality when connecting to a database shows the password in plain text

2188

Firebird Module

minor

always

2010-09-06 09:56

2010-09-06 10:21

edelcom

normal

feedback

none

open

Executing a concatenation with data from the trigger system table truncates the name on first '_' character

As per an answer for one of my questions on StackOverflow :
http://stackoverflow.com/questions/3599185/how-to-drop-all-triggers-in-a-firebird-1-5-database/3645346#3645346 [^]

I tried the following select in a Firebird 1.5 database:

select 'DROP TRIGGER ' || rdb$trigger_name || ';' from rdb$triggers
where (rdb$system_flag = 0 or rdb$system_flag is null)

The resultset was as follows :
CONCATENATION
---------------
DROP TRIGGER BI
DROP TRIGGER BI
DROP TRIGGER BI
...
DROP TRIGGER BI
DROP TRIGGER BI

Either the result is truncates at the third character (I have BIU_NAMED... and BI_NAMED... trigger names, or on the first '_' character, but the result is wrong. It might also be a Firebird fault (although a normal select from the same system table does produce a correct result).

martijntonies

2010-09-06 10:21

Seems to be caused by using Unicode in the connection charset (internally), not sure where this goes wrong.

As a workaround, connect using charset = NONE

2187

Firebird Module

minor

always

2010-08-29 14:07

2010-09-02 10:19

doychin

normal

acknowledged

none

4.0.3

open

Reordering fields on New table shoud not produce ALTER POSITION

When you create new table there is not need to append "alter fields position" in the SQL when you decide to change the order of the fields in the table.

1. Create new Table. While defining fields change the order of any of the fields.
2. Check modification SQL and you will see that there is alter position statement. This one is not needed at all since fields in Create Table are properly ordered.

2180

General

feature

always

2010-08-18 15:19

2010-08-27 14:23

edelcom

normal

acknowledged

4.0.3.5

none

4.0.3

open

Extend 'Copy special - Copy to Delphi' to surround each line with Sql.Add(' and ');

It would be cool if the 'Copy to Delphi' would give an option to add the Sql.Add(' and '); around each line, so that this could be pasted into the Delphi editor to be used in Query components.

martijntonies

2010-08-19 09:57

Do note that with "Custom" you can add these if you like.

edelcom

2010-08-27 12:13

Yes, but as far as I can tell, the values in this popup form are not saved, so you have to enter them again and again.

When testing this can occur a lot of times.

martijntonies

2010-08-27 12:16

What about the ability to create several custom entries (in the Preferences) that can be used from a sub-menu?

edelcom

2010-08-27 13:39

... ok and than save the last selected entry ?
Great :)

martijntonies

2010-08-27 13:58

And then use any of your "persistent custom" ones and have the "add-hoc" custom one keep the last settings.

edelcom

2010-08-27 14:23

2178

SQL Anywhere Module

minor

always

2010-08-16 00:58

2010-08-26 12:09

Bradley Bell

martijntonies

normal

feedback

none

4.0.3

open

Field name not found in TSybASAUniqueConstraint.GetColumns: ITEM

I run the following script:

CREATE TABLE DBA.MASTER_TLMC
(
    RID Integer NOT NULL DEFAULT autoincrement,
    ITEM NVarChar(50) NOT NULL,
    ATA SmallInt NOT NULL,
    ITYPE NVarChar(2) NOT NULL,
    POS NVarChar(25) NOT NULL,
    FREQ NVarChar(10) NOT NULL,
    UOM NVarChar(5) NOT NULL,
    ACTYPE NVarChar(10) NOT NULL,
    ACMODEL NVarChar(10) NOT NULL,
    REF NVarChar(50),
    CONSTRAINT PK_MASTER_TLMC_RI PRIMARY KEY (
      RID
    )
)
IN traxdata

ALTER TABLE DBA.MASTER_TLMC ADD CONSTRAINT U_MASTER_TLMC
  UNIQUE (ITEM, ATA, ITYPE, POS, FREQ, UOM, ACTYPE, ACMODEL)

CREATE INDEX I_MASTER_TLMC_ACMODEL_ACTYPE
ON DBA.MASTER_TLMC(ACMODEL, ACTYPE)
IN traxdata

After refreshing the screen information from the screen I try and select the unique constraint from above. It gives me the error shown in the summary above. If I pull up the DDL from the table it shows the following:

CREATE TABLE DBA.MASTER_TLMC
(
    RID Integer NOT NULL DEFAULT autoincrement,
    ITEM NVarChar(50) NOT NULL,
    ATA SmallInt NOT NULL,
    ITYPE NVarChar(2) NOT NULL,
    POS NVarChar(25) NOT NULL,
    FREQ NVarChar(10) NOT NULL,
    UOM NVarChar(5) NOT NULL,
    ACTYPE NVarChar(10) NOT NULL,
    ACMODEL NVarChar(10) NOT NULL,
    REF NVarChar(50),
    CONSTRAINT PK_MASTER_TLMC_RI PRIMARY KEY (
      RID
    )
)
IN traxdata
GO

ALTER TABLE DBA.MASTER_TLMC ADD CONSTRAINT U_MASTER_TLMC
  UNIQUE )
GO

CREATE INDEX I_MASTER_TLMC_ACMODEL_ACTYPE
ON DBA.MASTER_TLMC(ACMODEL, ACTYPE)
IN traxdata
GO

The Unique constraint information is gone. However, in the constraints tab I can see U_MASTER_TLMC except in the columns field there is ITEM followed by about 60 spaces followed by a comma and then ATA, followed by about 60 spaces... and so on and so forth. Looks like a little bug. Additionally, none of the columns show up under the Constrain Columns pick list.

martijntonies

2010-08-26 12:09

Hello Bradley,

I've been trying, but I cannot reproduce this problem.

Can you tell me more about this?

2164

General

minor

always

2010-07-19 14:13

2010-08-26 11:00

doychin

martijntonies

normal

resolved

none

4.0.2

fixed

Access violation when deleting focused row on single row resultset

When I try to delete a records from result grid that was selected by the following query results in AV.

select CASH_ROW_PROMO.*
from CASH_ROW_PROMO
join SRV_CONTRACTROW on ((CASH_ROW_PROMO.ROWFKID = SRV_CONTRACTROW.ID) AND CASH_ROW_PROMO.ROWFKEXP = SRV_CONTRACTROW.EXPIRING)
join CRM_CONTRACT on ((SRV_CONTRACTROW.CONTRACTFKID = CRM_CONTRACT.ID) AND SRV_CONTRACTROW.CONTRACTFKEXP = CRM_CONTRACT.EXPIRING)
where CRM_CONTRACT.CONTRACTNO = '4002000624'

In my case if this query produces 1 record and I select it in the grid and then try to delete it using delete button I get
Access violation at address 00521E0D in module 'DBW4.exe'. Read of address 00000000

If I have 2 records and I try to delete second record it works.

2176

General

major

always

2010-08-12 13:16

2010-08-26 10:54

heimey

normal

acknowledged

none

4.0.3

open

Not possible to insert a time in combined date & time fields within the Table Editor or SQL Editor

If I want to change a Table-entry of a Timestamp field within the table editor I'm only able to enter/change the date but not the time!

2173

Data Export/Import

minor

always

2010-08-05 08:44

2010-08-26 10:39

mivi71dk

normal

acknowledged

none

4.0.3

open

Data export should use number formatting settings like SQL Editor does

If I do a select I can in settings decide how numbers are presented.

i.e. #0.000

When I press "Export resultset" the results are not presented in that way.
Its just presented as is.

Ex.
Value: 12,78787878787
Resultset: 12,78
Export: 12,7878878787

2186

Firebird Module

feature

N/A

2010-08-26 09:00

doychin

normal

acknowledged

none

4.0.3

open

Add support for debugging execute block statements

Right now in order to debug execute block statement for firebird i have to write it into Stored procedure and then debug it.

2182

General

trivial

always

2010-08-25 02:12

2010-08-25 13:35

jeroenp

martijntonies

normal

resolved

none

4.0.3

fixed

text editor: search replace has two UI controls bound to &C

Alt-C is bound to both the "Case sensitive" checkbox and the "Cancel" button.

It would be wise if the Cancel buttons were only bound to the Esc key.

--jeroen

2185

Data Export/Import

major

have not tried

2010-08-25 13:31

2010-08-25 13:32

martijntonies

normal

resolved

none

4.0

fixed

Exported CSV data with date/time in Windows format can not be imported

2183

Data Export/Import

minor

have not tried

2010-08-25 11:16

2010-08-25 13:30

martijntonies

normal

resolved

none

4.0.3

fixed

Import of multi-line CSV data in a single column fails

Import of multi-line CSV data in a single column fails, see test file by Jack.

2181

Firebird Module

minor

always

2010-08-20 14:08

2010-08-25 09:51

normal

acknowledged

none

3.4.4

open

unsupported column type:0 error

Using Database Workbench v3.4.4.4Pro and firebird server v2.1.3 "unsupported column type:0" error is returned when a select query is run before a CTE query for example:

1. run "select * from x"
returns data from x

2. run "with y as (select * from z) select * from y"
returns "unsupported column type: 0" error

at this point I have to disconnect from database and connect back to the databse

3. run "with y as (select * from z) select * from y" again
and data is returned

This will happen if the sequence is ran from same SQL editor window or different pages from within that window. The error will also occur if I run cte query first (in which case data will be returned) then run palin select query (returns data) and run cte query again (error is returned)

However if queries are run from separate SQL editor windows the error doesn't occur.

The column type of tables plays no role in this.

2010-08-20 14:10

after the error occurs it is actually not necessary to disconnect from the database and connect back; closing the offending sql editor window is enough

2174

Diagramming

minor

always

2010-08-09 17:46

2010-08-18 12:06

Rich Ackerson

normal

acknowledged

none

4.0.3

open

Errors adding descriptions if MS_Description does not exist

I was testing the features of your diagrammer. I connected to a MSSQL session and dragged some existing tables onto a diagram. After visualizing the foreign keys, I double-clicked on some tables in the diagram to add descriptions. Without saving the diagram, I clicked on DBW's navigation tree and DBW asked if I wanted to save the changes I made in the diagram. I answered YES and received an error indicating "MS_Description does not exist".

I don't understand why DBW would report that MS_Description does not exist for my tables as they used to have extended properties defined. Perhaps I somehow deleted this property when I removed the extended property description for my table?

Either way, I know it is possible for an editor to re-add a missing MS_Description to a table because I was able to do just this using another SQL editor.

So whether my issue is a bug or "by-design", do you think it would be possible for DBW to be able to handle the re creation of MS_Description if/when necessary?

2179

General

minor

always

2010-08-18 12:04

2010-08-18 12:06

davesellers

normal

acknowledged

none

4.0.2

open

SQL Insight can interfere with text literals

Entering SQL: Select * from table where field = 'dave'

The problem is, when I get as far as:

Select * from table where field =

If there is even a very slight pause before I hit the ' key, what happens is the list of available fields pops up and the ' key selects the first in the list and I end up with:

Select * from table where field = somefieldname'dave'

My feeling is that the ' key should not select an item from the SQL Insight list of fields but should, instead, dismiss the list.

2167

General

tweak

always

2010-07-30 07:59

2010-08-01 11:12

doychin

normal

confirmed

none

4.0.3

open

Wrapped text for checkboxes

- Print Options: Press Ctrl+P while in Single SQL Editor.

2166

General

feature

N/A

2010-07-28 18:27

2010-08-01 11:11

scarleton

normal

acknowledged

none

3.4.4

open

new Copy Special for C# strings

In C# the when a string spans multiple lines, the quote is not needed at the end of the first line and the beginning of the next line. it looks like this:

string sqlStmt = @"SELECT *
FROM aTable
WHERE id > 10";

Currently I am using the Copy to C/C++ and it would be great to have a Copy to C#.

2165

Visual Query Builder

minor

always

2010-07-23 15:16

2010-07-23 15:22

plillejo

normal

acknowledged

none

4.0.3

open

Can not use Stored procedure with parameters

SELECT IW.F_CABLE_ID, e.TAG_NO
FROM
GET_IW(10051) IW
LEFT JOIN EQUIPMENT_TABLE e ON IW.OUT_EQ_ID = e.EQ_ID

2158

SQL Anywhere Module

minor

have not tried

2010-07-14 16:46

2010-07-20 13:34

martijntonies

normal

resolved

none

fixed

No OWNER drop down box for Materialized Views

2163

IBLMRedo_CommandLine

minor

always

2010-07-19 14:06

2010-07-20 08:33

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Support for empty string PKEYn_VALUE values

N.A.

2162

IBLMRedo_CommandLine

major

always

2010-07-19 13:53

2010-07-19 14:05

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Infinite loop when processing log records with no/empty primary key values (PKEYn, PKEYn_VALUE)

N.A.

2154

SQL Anywhere Module

minor

have not tried

2010-07-14 11:43

2010-07-19 11:41

martijntonies

normal

resolved

none

4.0

fixed

SQL Anywhere 11 Text Index based tables are listed as normal tables

SQL Anywhere 11 Text Index based tables are listed as normal tables, these shouldn't be listed

2160

SQL Anywhere Module

minor

have not tried

2010-07-15 18:14

2010-07-19 11:41

martijntonies

normal

resolved

none

4.0

fixed

Grant Manager fails on Materialized Views (SQL Anywhere 11)

2161

SQL Anywhere Module

minor

have not tried

2010-07-19 10:03

2010-07-19 10:04

martijntonies

normal

resolved

none

4.0

fixed

Grant Manager sometimes lists Stored Procedures twice

2159

ADO/ODBC Explorer

feature

always

2010-07-15 07:42

2010-07-15 13:55

LachlanG

normal

acknowledged

none

3.4.5

open

Make SQL Insight available for ODBC Explorer

There is no SQL Insight for ODBC databases.

2155

Firebird Module

minor

always

2010-07-14 13:07

2010-07-14 14:31

heimey

normal

acknowledged

none

4.0.3

open

Overlay Function unknown in Procedur editor

If I want to use the OVERLAY() function within a procedure there comes a message "Unknown command 'OVERLAY'."
If I use it within a normal SQL like this

SELECT
OVERLAY('00000' placing '1' from 1 for 1)
FROM
RDB$DATABAS

it works fine

heimey

2010-07-14 14:31

The same behavior occures with the LPAD() function.
If I find another one I will open a new track with a list of not supported functions

2157

Firebird Module

minor

always

2010-07-14 14:23

2010-07-14 14:26

heimey

normal

closed

none

4.0.3

fixed

LPAD Function unknown in Procedur editor

If I want to use the internal LPAD() function within a procedure there comes a message "Unknown command 'LPAD'."
If I use it within a normal SQL like this

SELECT
LPAD('1111',31,'0')
FROM
RDB$DATABASE

it works fine

martijntonies

2010-07-14 14:26

Can you group these with 0002155 ?

Make it "several Firebird 2.1 functions not supported" or something.

Thanks.

2156

Firebird Module

tweak

always

2010-07-14 13:49

2010-07-14 13:59

heimey

normal

acknowledged

none

4.0.3

open

Function Highlighting of some function is not implemented

Some firebird internal functions are not highlighted as known functions. For example Dateadd, Reverse, Overlay etc.

2030

Firebird Module

feature

have not tried

2010-03-24 10:12

2010-07-14 11:37

martijntonies

normal

assigned

none

open

Support Firebird 2.5 features

2153

SQL Anywhere Module

feature

have not tried

2010-07-13 16:12

2010-07-14 11:29

martijntonies

normal

assigned

none

open

Full SQL Anywhere 12 support

2144

General

block

always

2010-06-16 06:10

2010-07-13 17:13

mduncan47

martijntonies

normal

closed

none

4.0.2

fixed

Valid blob field name causes "fieldname_Indicator" is not a valid component name for some specific names

A common first field name in many Firebird tables I use is "MFK$GUID". When I try to go into data view I get the error "MFK$GUID_Indicator" is not a valid component name.

martijntonies

2010-06-16 08:28

What's its datatype?

mduncan47

2010-06-16 16:17

It is Char(16) OCTETS - Not Null

2143

MS SQL Module

minor

have not tried

2010-06-15 12:09

2010-07-13 17:13

martijntonies

normal

closed

none

4.0.2

fixed

Refresh List on Tables in MS SQL 2005 and up fails when there are new tables created by SQL

Refresh List on Tables in MS SQL 2005 and up fails

2142

General

minor

always

2010-06-15 11:17

2010-07-13 17:13

doychin

martijntonies

normal

closed

none

4.0.2

fixed

Prepare Query stays pressed in case of error in the query

When you try to prepare query that contains some errors a message about the error is displayed but prepare button stays pressed.

It should not stay pressed in case of error.

martijntonies

2010-06-16 14:27

it's behaviour wasn't affected though

2141

DataPump

minor

have not tried

2010-06-15 08:51

2010-07-13 17:13

martijntonies

normal

closed

none

4.0.2

fixed

Column sizing issue

There's an issue with resizing the columns of the tables/fields - some are fixed, other respond in a less-than-obvious manner.

2138

DataPump

block

always

2010-06-10 09:08

2010-07-13 17:13

martijntonies

normal

closed

none

4.0.2

fixed

Error: The requested properties cannot be supported on MS SQL Server connection

Error: The requested properties cannot be supported on MS SQL Server connection.

Connect to a SQL Server db and try transferring data from it to another destination.

2137

MySQL Module

minor

always

2010-06-09 15:00

2010-07-13 17:13

doychin

martijntonies

normal

closed

none

4.0.1

fixed

MySQL raises "#42000 Query was empty" on several occasions

- When I use Drop from DB Navigator I get error message #42000Query was empty

- when trying to open user manager from Enterprise Manager you get an error message "#42000 Query was empty"

2136

General

minor

always

2010-06-09 14:59

2010-07-13 17:13

doychin

martijntonies

normal

closed

none

4.0.2

fixed

Can't load no-bom UTF-8 encoded file in Script Editor, works fine in SQL Editor

The script is loaded as ANSI so UTF-8 encoded characters are not properly displayed in SQL Editor.

Probably an option to specify the encoding to use when loading SQL script will be good solution

2151

Data Export/Import

crash

have not tried

2010-07-08 15:05

2010-07-13 17:13

martijntonies

normal

closed

none

4.0.2

fixed

DWX Import fails with Access Violation in options screen

2148

Firebird Module

minor

always

2010-06-25 13:32

2010-07-13 17:13

heimey

martijntonies

normal

closed

none

4.0.3

fixed

EXTRACT(week from sometimestamp) produces error in psql

There seems to be a Problem with using the EXTRACT-Function within stored Procedures at a Firebird 2.1 Database.

If I use “woy=EXTRACT(WEEK FROM current_timestamp)” with woy declared as integer their comes an error message “Undeclared identifier: ‘WEEK’ ”

But in a normal SQL-Window this functions without problems:
“SELECT EXTRACT (week from current_timestamp) FROM RDB$DATABASE”

2147

MySQL Module

minor

have not tried

2010-06-23 09:18

2010-07-13 17:13

martijntonies

normal

closed

none

4.0.2

fixed

Missing images for buttons in Constraint Editor column lists

2145

General

feature

always

2010-06-22 09:17

2010-07-13 17:13

jeroenp

martijntonies

normal

closed

none

4.0.3

fixed

in "Search, Find in Database" add buttons for "all" and "none"

When searching for meta data, I usually want to search all or most categories.

Right now that takes some 6 mouse clicks (depending on the DBMS).

It would be nice if the buttons "All" and "None" were added.

2140

DataPump

minor

always

2010-06-14 05:56

2010-07-13 17:13

MariusTurnkey

martijntonies

normal

closed

none

4.0.2

fixed

DataPump to Firebird/InterBase works incorrectly when committing at intervals

When you make use of Datapump in 4.0.2 and you select that it will commit every lets say 1000 transactions, all the records you are pumping after the first commit only includes the first character of the data are you are porting.

If you select to only commit all as one transaction, all the data is ported correctly.

My source database is a MS SQL Server 2005 database, which I access through ODBC.

Have not tried to port from other ODBC or Native Databases.

martijntonies

2010-06-15 10:21

Does this happen with CHAR or NCHAR data? Can you get me sample table metadata for both databases?

MariusTurnkey

2010-06-16 05:22

Hi Martijn,

Its VARCHAR data in both cases (Source and Target)

Source Metadata (MS SQL Server)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COMMODITY](
    [IRN] [int] IDENTITY(1,1) NOT NULL,
    [COMCODE] [varchar](20) NOT NULL,
    [DESCRIPTION] [varchar](60) NULL,
    [GL_ACCOUNT] [varchar](10) NULL,
    [DEPTCODE] [varchar](10) NULL,
PRIMARY KEY CLUSTERED
(
    [IRN] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Target Metadata (Firebird 2.1.3)

Domains are in this form:
CREATE DOMAIN D_VC60 AS
VARCHAR(60)
COLLATE NONE;

CREATE TABLE COMMODITY
(
  IRN INTEGER NOT NULL,
  COMCODE D_VC20 ,
  DESCRIPTION D_VC60 ,
  GL_ACCOUNT D_VC10 ,
  DEPTCODE D_VC10 ,
CONSTRAINT PK_COMMODITY PRIMARY KEY (IRN)
);

SET TERM ^^ ;
CREATE TRIGGER COMMODITY_ID FOR COMMODITY ACTIVE BEFORE INSERT POSITION 0 AS
begin
  if ( (new.IRN is null) or (new.IRN = 0) )
  then new.IRN = gen_id(COMMODITY_GEN, 1);
end ^^
SET TERM ; ^^

martijntonies

2010-06-16 09:18

Before I started investigating this, I must say I had no idea why the "commit frequence" could cause the behaviour you're describing, and I still have no idea.

I cannot reproduce this behaviour in any way.

Make sure you use an ODBC driver that suits SQL Server 2005?

MariusTurnkey

2010-06-16 09:50

Hi,

I doubt that the ODBC driver can have anything to do with it, as it works 100% if you do not select the intermittent commit internal, and the commit interval has nothing to do with the MS SQL Server, but rather the Firebird Server, as far as I understand it.

I can consistently reproduce it on my development machine. If you want to you can take over the machine via TeamViewer and have a look if it will assist in finding the problem. If you are interested in this please make contact with me on my Gtalk account. mj.labuschagne at gmail dot com , and I will give you the access codes over there.

Regards
Marius

martijntonies

2010-06-16 09:54

Yes, the commit interval is related to the target database.

Yet, I fail to understand how this can influence how the data is being transferred. You can send the details of TeamViewer to m.tonies @ upscene.com

martijntonies

2010-06-16 12:31

Firebird database has NONE as the charset, this seems to be the cause.

2139

MySQL Module

minor

have not tried

2010-06-11 08:21

2010-07-13 17:13

martijntonies

normal

closed

none

4.0.1

fixed

Cannot execute a Stored Routine with NCHAR parameter

2050

InterBase Module

tweak

always

2010-04-07 09:26

2010-07-13 17:13

martijntonies

normal

closed

none

4.0

fixed

Make syntaxis check to recognize Stored procedure name when used in recursive algorithm

When you create new stored procedure and you want to use recursion you will use that procedure name in the code. In case you just wrote the procedure code and that procedure does not exists when you try to check it's syntax before creating it it will show error that there is no such procedure in the database.

In this case you can check that procedure name is same like the one that is checked and in that case this error message can be avoided.

2037

Firebird Module

tweak

always

2010-03-28 13:09

2010-07-13 17:13

doychin

martijntonies

normal

closed

none

4.0

fixed

Make syntaxis check to recognize Stored procedure name when used in recursive algorithm

1881

Firebird Module

feature

always

2009-10-03 12:54

2010-07-13 17:13

doychin

martijntonies

normal

closed

none

3.4.1

fixed

Stored procedure syntax check should recognize Merge syntax

Get some Merge sample and run it trough syntax check. It will display errors.

SP compiles without problems and executes properly

1872

General

minor

always

2009-09-22 23:38

2010-07-09 11:17

rdebay

normal

closed

none

3.4.1

won't fix

Open SQL editor locks resources

1. Open view editor
2. Execute query which uses the view, in SQL Editor
3. Unprepare query
4. Alter view

Step four will fail to drop the view. In order to alter the view, you must close the SQL Editor. Unpreparing the query doesn't release the hold on the view.

rdebay

2009-09-28 16:02

1. Prepare Query containing stored procedure (insert into...select from sp)
2. Continue Prepared Query
3. Drop stored procedure & table it references

This works as expected.

1. Run Query containing stored procedure
2. Drop stored procedure & table

This fails, as the table is in use. To drop the table you must then prepare the query, which will fail as the SP has been dropped. However, the table is now free and silently dropped.

martijntonies

2010-07-09 11:17

Apparently caused by metadata cache at the server side, cannot be fixed.

2040

Data Export/Import

major

always

2010-03-28 13:45

2010-07-09 10:52

doychin

martijntonies

normal

closed

none

3.4.3

unable to reproduce

DWX Export or Import is not working

I did an export of 2 tables to a dwx file. After that I tried to import this same file into another database.

Result was that one of the tables remained empty(original table contains lots of records)

The other table contained some garbage.

Use the DML from this report and create tables.

Then use the attached DWX file to import data.

CREATE TABLE TMP_STORAGE_ARTICLE
(
  ID INTEGER NOT NULL,
  EXPIRING NUMERIC( 18, 1) NOT NULL,
  CREATING NUMERIC( 18, 1),
  ACCOUNT INTEGER,
  GROUP_ID INTEGER,
  ENABLED INTEGER,
  RAZFASOVKA_TYPE INTEGER,
  RAZFASOVKA_QUANTITY INTEGER,
  NAME VARCHAR( 128) ,
  DESCRIPTION VARCHAR( 256) ,
  GROUPFKID INTEGER,
  GROUPFKEXP NUMERIC( 18, 1),
  RAZFASOVKA_BRUTO DOUBLE PRECISION,
  RAZFASOVKA_NETO DOUBLE PRECISION,
  FKID INTEGER,
  FKEXP NUMERIC( 18, 1),
  PARENT_ID INTEGER,
  QUANTITY DOUBLE PRECISION,
  FIRM_ID INTEGER,
  FIRM_FKID INTEGER,
  FIRM_FKEXP NUMERIC( 18, 1),
  CODE VARCHAR( 64) ,
  CLIENTFKID INTEGER,
  CLIENTID INTEGER,
  REQUIRES_PART_NUMBER INTEGER,
  WRAPPING_ID INTEGER,
  WRAPPINGFKID INTEGER,
  WRAPPINGFKEXP NUMERIC( 18, 1),
  MATERIAL INTEGER,
  QUANTITY_TYPE INTEGER,
  CLIENTFKEXP NUMERIC( 18, 0),
CONSTRAINT PK_TMP_STORAGE_ARTICLE PRIMARY KEY (ID, EXPIRING)
);

CREATE TABLE TMP_STORAGE_ARTICLE_GROUP
(
  ID INTEGER NOT NULL,
  EXPIRING NUMERIC( 18, 1) NOT NULL,
  ACCOUNT INTEGER,
  CREATING NUMERIC( 18, 1),
  DESCRIPTION VARCHAR( 256) ,
  NAME VARCHAR( 128) ,
  PARENTID INTEGER,
  FKID INTEGER,
  FKEXPDATE NUMERIC( 18, 1),
  ORDERID INTEGER,
  IDENTIFIER VARCHAR( 32) ,
  ISMATERIAL INTEGER,
CONSTRAINT PK_TMP_STORAGE_ARTICLE_GROU PRIMARY KEY (ID, EXPIRING)
);

charly_articles.zip (13 KB) 2010-03-28 13:45

martijntonies

2010-07-09 10:12

I can import the data just fine (Windows set to Bulgarian locale), but I'm not sure what it should look like, as I see all kind of unknown characters for me ;)

I've just fixed an error in DBW 4 though that made it impossible to import data, does this work for you in 3.4.4?

doychin

2010-07-09 10:43

In 3.4.4 only some records in TMP_STORAGE_ARTICLE_GROUP are imported. There is nothing in TMP_STORAGE_ARTICL.

I suspect that this could be an encoding problem in 3.4.4

martijntonies

2010-07-09 10:45

I cannot find anything wrong then, shall we ignore this and concentrate on v4?

doychin

2010-07-09 10:51

If I'm the only one that complaints about this issue you can ignore it. Just make sure Import/Export in 4 works properly ;-)

2150

General

feature

always

2010-07-06 06:45

2010-07-06 10:04

edelcom

normal

acknowledged

4.0.1.1

none

4.0.1

open

Extend 'Paste special' syntax to recognize string list syntax from Delphi's Evaluate/Modify form

When you inspect a string list (TQuery.Sql) from within Delphi, it shows its contents like :

'select k.naam, k.straat, k.PostCode + " " + p.Gemeente as Woonplaats,'#$D#$A'k.Email, k.Website, k.telefoonnr, k.faxnr from'#$D#$A'klanten k, postnrs p'#$D#$A'where k.PostCode = p.PostCode'#$D#$A'and k.PostCode_Uniek = p.PostCode_Uniek'#$D#$A'and k.Code = :Code'#$D#$A

It would be great if the paste special command would filter out these #$D#$A strings (replacing them by Cr/Lf) and would strip the single quotes

2149

Firebird Module

minor

always

2010-06-27 10:53

2010-07-05 15:30

doychin

normal

closed

none

4.0.2

duplicate

Trying to open Data tab for table RDB$FIELDS produces error message

Open connection to FB 2.1.2 database and try to open RDB$FIELDS table. Table structure is displayed but when you try to switch to Data tab to browse data an error message is displayed:
''RDB$MISSING_VALUE_Indicator'' is not a valid component name

doychin

2010-06-27 10:58

Same happens with following tables: RDB$TRIGGERS, RDB$TRANSACTIONS

Table RDB$SECURITY_CLASSES produces this message:
''RDB$ACL_Indicator'' is not a valid component name

Tables RDB$RELATION_FIELDS and RDB$PROCEDURE_PARAMETERS produce message:
''RDB$DEFAULT_VALUE_Indicator'' is not a valid component name

Table RDB$RELATIONS produces message:
''RDB$EXTERNAL_DESCRIPTION_Indicator'' is not a valid component name

Table RDB$PROCEDURES produces message:
''RDB$DEBUG_INFO_Indicator'' is not a valid component name

I suggest you test all system tables. Probably some other will produce similar error messages.

doychin

2010-06-27 10:59

Also when you try to browse any of the above tables from Single SQL using Select statement same error message is displayed on the bottom of the window.

martijntonies

2010-07-05 15:30

duplicate of 0002144

2146

General

feature

always

2010-06-22 10:32

2010-06-22 10:35

jeroenp

normal

acknowledged

none

open

Add 'synchronize' button

When editing a stored procedure, table, or other object, it is often handy to be able to select that particular object in the treeview for the current server.

It would be nice if a 'synchronize' button was added to all Object Editors that expands the treeview and select the object you are editing/viewing.

--jeroen

2054

Firebird Module

minor

have not tried

2010-04-07 15:41

2010-06-15 10:22

mspoor

normal

closed

none

4.0

unable to reproduce

Unexpected behaviour when running SQL script after 'unsuccessful metadata update object INDEX is in use'

In using SQL Script I came across the following strange behaviour:
once I have seen an 'unsuccessful metadata update object INDEX is in use' error while executing my script, the following happens:
- I choose 'Abort'
- Now I rerun (or run from any point) the script
- this seems to run fine until the first 'commit;' statement it runs into (I have a few scattered throughout my script), then it skips to the end of the script and says it has finished executing (no errors).
- However, it has not committed (in the popup dialog it has the commit/rollback options active) and trying to commit will reshow the 'unsuccessful metadata update object INDEX is in use' error.

I have seen this twice now. But I don't know how to force the initial 'unsuccessfull metadata update object INDEX is in use' error...

martijntonies

2010-04-07 15:47

Can I get a copy of the script and a database to run it? But even then, these can be hard to reproduce.

mspoor

2010-04-07 16:39

I'm afraid I cannot give a database. I will try to create an example script.

mspoor

2010-04-29 14:51

I cannot reproduce the INDEX is in use error here any more. The only way to check the signaled behaviour would be to 'force' an error in code, which ofcourse I cannot :-)

So you can close this item.

2129

General

minor

have not tried

2010-05-26 16:58

2010-06-14 08:52

martijntonies

normal

closed

none

4.0.1

fixed

Some text items not saved in UTF8 when they should

Some text items not saved in UTF8 when they should.

- InterBase DB statistics
- InterBase server log
- Firebird DB statistics
- Firebrid server log

2128

General

crash

have not tried

2010-05-25 13:14

2010-06-14 08:52

martijntonies

normal

closed

none

4.0

fixed

Possible access violation when closing after using ODBC connectivity

Possible access violation when closing after using ODBC connectivity, the access violation would occur in ntdll.dll

2126

Visual Query Builder

tweak

have not tried

2010-05-21 13:43

2010-06-14 08:52

martijntonies

normal

closed

none

fixed

Several usuability improvements

- list table & view column datatypes
- list stored routine parameter datatypes
- key columns in bold
- number of selected columns in header

2125

Visual Query Builder

minor

have not tried

2010-05-21 13:17

2010-06-14 08:52

martijntonies

normal

closed

none

4.0.1

fixed

Cancel button in Visual Query Builder aks for confirmation to accept query

Cancel button in Visual Query Builder aks for confirmation to accept query, on Cancel, it should just close.

2122

ADO/ODBC Explorer

minor

have not tried

2010-05-21 11:24

2010-06-14 08:52

martijntonies

normal

closed

none

4.0

fixed

Using "refresh list" on an ODBC datasource raises an Abstract Error

2119

ADO/ODBC Explorer

feature

have not tried

2010-05-21 10:34

2010-06-14 08:52

martijntonies

normal

closed

none

fixed

Support for ODBC 1.0 datasources

2118

Visual Query Builder

minor

have not tried

2010-05-20 13:41

2010-06-14 08:52

martijntonies

normal

closed

none

4.0

fixed

Builder does not spread out tables on canvas but puts them all in top left corner

When editing an existing query, builder does not spread out tables on canvas but puts them all in top left corner.

2113

General

minor

always

2010-05-20 09:19

2010-06-14 08:52

mivi71dk

martijntonies

normal

closed

none

4.0.1

fixed

Changes to Syntax Highlighting don't stick between sessions

If I change the settings in here to i.e. Twillight the Colors change to i.e. black background.

But this will only be so until I close the program.
Next time I start it its back to default (white background)

Running on Windows 7 64 bits

2112

ADO/ODBC Explorer

minor

have not tried

2010-05-19 15:17

2010-06-14 08:52

martijntonies

normal

closed

none

4.0.1

fixed

ODBC connection to SolidDB (ODBC 1.0) fails with "Field TABLE_SCHEM not found"

ODBC sometimes fails when fetching tables/views.

SolidDB 2.2

2110

ADO/ODBC Explorer

minor

have not tried

2010-05-18 12:54

2010-06-14 08:52

martijntonies

normal

closed

none

4.0.1

fixed

ODBC data sources sometimes fail when fetching tables/views

ODBC data sources sometimes fail when fetching tables/views.

- dbf sources for example

2106

Data Export/Import

tweak

always

2010-05-11 21:17

2010-06-14 08:52

Patrick_NY

martijntonies

normal

closed

none

3.4.3

fixed

Export Resultset file/folder selection should be more clear

If I run a simple Sql Select, then click the icon for Export Resultset, it appears to work but I see no output file.
This gets me every time.
The output is actually in the DBWB Program Directory with the DLLs and EXEs.
As I run through the Export dialog I type in a filename, and I see the directory in the other box, and it looks good. But, they are not connected.
That is the Edit box for "Folder".
I'm not sure why that is populated and the File box is not.
Maybe the Folder Edit box could be grayed out when folder is not selected.
Also, always a dangerous thing when user errors get written to the program folder.

martijntonies

2010-05-11 22:40

The dialog has two boxes, including two radiobuttons: you select either one of them. They are not connected by design.

For some exports, you can select a folder as the output cause it results in multiple files, for other types of export, you have to select an output file. If you enter a file specification without a folder, the application folder is used.

Where did you get the impression that these two boxes -should- be "connected"?

2105

General

tweak

have not tried

2010-05-11 11:28

2010-06-14 08:52

martijntonies

normal

closed

none

fixed

Faster sorting on header click of Data tab in Table/View Editor

Faster sorting on Data tab in Table/View Editor.

Currently, the result set gets cached on the client, server side sorting is possible.

2104

Oracle Module

minor

have not tried

2010-05-11 08:54

2010-06-14 08:52

martijntonies

normal

closed

none

4.0.1

fixed

Quick Browse or Data tab in Table Editor fails on Index-Organized tables

Quick Browse or Data tab in Table Editor fails on Index-Organized tables with message ORA-03115: unsupported network datatype or representation

2102

General

minor

have not tried

2010-05-10 10:34

2010-06-14 08:52

martijntonies

normal

closed

none

4.0.1

fixed

BLOB Editor for text inserts (unicode) BOM

2095

General

minor

have not tried

2010-05-03 09:23

2010-06-14 08:52

martijntonies

normal

closed

none

4.0.1

fixed

No images in status bar, like statement recorder doesn't flash red recording sign in status bar

Statement recorder doesn't flash red recording sign in status bar

Also message images.

2094

General

major

always

2010-04-29 14:49

2010-06-14 08:52

mspoor

martijntonies

normal

closed

none

4.0.1

fixed

select from table with BLOB view eats up LOT's of memory (compared to DBWB3)

When I do a simple
select * from table
I see a very big difference in memory usage in the DBWB4 version compared to the DBWB3 version. Such a difference that it in fact becomes unworkable. Selects I used to be able to do without any problem, I now cannot anymore because DBWB4 crashes due to out-of-memory...

Comparison:
Reported memory usage (Windows taskmanager)
:Tables WITH BLOB: DBWB3 DBWB4
----------------------------------------------------------------------
Table A (48.699 rows) 40MB 157MB
Table B (12.784 rows) 35MB 134MB
Table C (17.317 rows) 41MB grows to 1.9GB and crashes...

Table A & B contain a blob field with not so much data (a few textlines per blob). Table C contains JPG images, mostly <64KB per image.

When I select one standard field from table C, it works fine (17.317 rows retrieved), if I do a select with only the BLOB field, I see the same effect as above: memory grows to 1.9GB and crash....

2088

General

major

have not tried

2010-04-28 08:47

2010-06-14 08:52

martijntonies

normal

closed

none

4.0

fixed

Very slow response in SQL Editor, eg when editing data in larger resultsets

Very slow response while editing data in larger resultsets.

Open a resultset 100.000+ rows, edit a value, move away from the record: it takes quite a while to do that.

martijntonies

2010-05-11 12:26

Slowness now only occurs after sorting by a header click as this requires caching all rows to the client.

If you don't do this, editing is fast like it normally was, even for large resultsets.

2083

Visual Query Builder

major

always

2010-04-26 16:49

2010-06-14 08:52

scarleton

martijntonies

normal

closed

none

3.4.4

fixed

Invalid SELECT statement on inner joins within left join

I have a complex select statement, one where I am doing a left join to a group of things that are all inner joined together. Visual Query Builder is not able to handle it. I will put the select statement in the additional information and will email Martijn the database in which this select is used.

SELECT
  CAT.ITEMTEXT AS CATEGORY,
  QI.UDA_HOST_MAPPING_ID,
  (SELECT COUNT(QI2.UDA_QUESTIONITEM_ID) FROM UDA_QUESTIONITEM QI2 WHERE QI2.INSTANCE_ID = QI.INSTANCE_ID AND QI2.DATE_TIME_CREATED <= QI.DATE_TIME_CREATED) AS QI_VERSION_NUM,
  QI.ITEMTEXT AS QI_ITEMTEXT,
  QI.QUESTION AS QI_QUESTION,
  QI.ENDDATE AS QI_ENDDATE,
  T.TITLE AS TEMPLATE_TITLE,
  (SELECT COUNT(TC3.UDA_AT_COMPONENT_ID) FROM UDA_AT_COMPONENT TC3 WHERE TC3.INSTANCE_ID = TC.INSTANCE_ID AND TC3.DATE_TIME_CREATED <= TC.DATE_TIME_CREATED) AS TEMPLATE_VERSION_NUM,
  INT_IS_EQUAL(T.UDA_AT_TEMPLATE_ID, TC.INSTANCE_ID) INITIAL_VERSION,
  (SELECT COUNT(*) FROM ASR3_MDS_MAIN WHERE UDA_AT_TEMPLATE_ID = TC.UDA_AT_COMPONENT_ID) USAGE_CNT,
  T.STARTDATE AS TEMPLATE_STARTDATE,
  TC.ENDDATE AS TEMPLATE_ENDDATE
FROM
  UDA_QUESTIONITEM QI
  INNER JOIN UDA_CATEGORY CAT ON CAT.UDA_CATEGORY_ID = QI.UDA_CATEGORY_ID
  LEFT JOIN (
    UDA_AT_COMPONENT TC
      INNER JOIN UDA_AT_TEMPLATE T ON T.UDA_AT_TEMPLATE_ID = TC.UDA_AT_COMPONENT_ID AND TC.ENDDATE = (SELECT Max(TC2.ENDDATE) FROM UDA_AT_COMPONENT TC2 WHERE TC2.ENDDATE > 'now' AND T.UDA_AT_TEMPLATE_ID = TC2.UDA_AT_COMPONENT_ID)
      INNER JOIN UDA_AT_TEMPLATE_SECTION TS ON TS.UDA_AT_TEMPLATE_ID = T.UDA_AT_TEMPLATE_ID
      INNER JOIN UDA_AT_SECTION_QUESTION SQ ON SQ.UDA_AT_SECTION_ID = TS.UDA_AT_SECTION_ID
      INNER JOIN UDA_AT_QUESTION_BOX QB ON SQ.UDA_AT_QUESTION_BOX_ID = QB.UDA_AT_QUESTION_BOX_ID
  ) ON QB.UDA_QUESTIONITEM_ID = QI.UDA_QUESTIONITEM_ID
WHERE
  (
    QI.ENDDATE = (SELECT Max(Q.ENDDATE) FROM UDA_QUESTIONITEM Q WHERE Q.ENDDATE > 'now' AND Q.INSTANCE_ID = Q.INSTANCE_ID)
    OR
    TC.ENDDATE = (SELECT Max(TC4.ENDDATE) FROM UDA_AT_COMPONENT TC4 WHERE TC4.ENDDATE > 'now' AND TC4.UDA_AT_COMPONENT_ID = TC.UDA_AT_COMPONENT_ID)
  )

scarleton

2010-04-26 17:03

Here is the link to the DB, it is good through May 3rd:

https://www.yousendit.com/download/OHo1eFVlUzdsMHl4dnc9PQ [^]

martijntonies

2010-05-03 14:12

Confirmed, forwarded to the creators of this 3rd party control.

2070

General

tweak

have not tried

2010-04-21 08:39

2010-06-14 08:52

martijntonies

normal

closed

none

fixed

Add ability to specify file encoding when saving text files

Replace file open (where required) and save dialogs for text with dialogs that have an "Encoding" box, this allows people to manually select an encoding if no encoding indicator is available.

2134

Firebird Module

minor

always

2010-06-07 10:16

2010-06-14 08:52

doychin

martijntonies

normal

closed

none

4.0.1

fixed

Setting transaction isolation after opening SQL Editor doesn't appear to work

When you run a select and rerun that select many times with read commited the results reported by query should change in case there are other transactions running on that DB and making changes to data.

Instead ReadCommiited behaves like Snapshot isolation.

2132

Firebird Module

minor

have not tried

2010-05-27 16:31

2010-06-14 08:52

martijntonies

normal

closed

none

4.0

fixed

Problems with "local" connection in Firebird

2131

General

minor

have not tried

2010-05-27 15:10

2010-06-14 08:52

martijntonies

normal

closed

none

4.0

fixed

Object Templates are listed twice in Preferences

2130

General

feature

have not tried

2010-05-27 10:40

2010-06-14 08:52

martijntonies

normal

closed

none

fixed

Free Lite Editions for MySQL, InterBase and Firebird

2101

InterBase Module

minor

have not tried

2010-05-06 11:20

2010-06-14 08:52

martijntonies

normal

closed

none

4.0

fixed

Cannot connect to InterBase Desktop Edition

Cannot connect to InterBase Desktop Edition, raises a message about not being able to connect to (local).

iblocal.bmp (464 KB) 2010-05-06 11:20

2135

DataPump

major

have not tried

2010-06-08 11:17

2010-06-08 13:23

martijntonies

normal

closed

none

4.0.1

no change required

Out of range values on larger NUMERIC value when transferring from Firebird to SQL Server

2133

General

feature

N/A

2010-06-03 13:46

2010-06-07 10:42

MariusTurnkey

normal

acknowledged

none

4.0.2

open

Continuous save of SQL Pages

Hi,

Please add a feature where DBW continuously saves your SQL Pages to a work or log file. This will allow the user to retrieve SQL's created for a particular session.

My motivation for this is that I did not save my constructed queries which took me at least 5 hours to construct this morning and then Windows decided to give me a Blue Screen resulting in me loosing all my work for the morning.

Its not the fault of DBW, I know I should have saved it myself, but most developers do not do that while they are focusing on constructing solutions.

2127

General

tweak

have not tried

2010-05-25 08:20

2010-05-25 13:18

martijntonies

normal

confirmed

none

4.0.1

open

SQL Editor "autocommit" flag should be restored after (un)checking and re-opening Editor

2123

ADO/ODBC Explorer

minor

have not tried

2010-05-21 11:26

2010-05-21 15:04

martijntonies

normal

resolved

none

3.4.4

fixed

Using "refresh list" on an ODBC datasource raises an Abstract Error

2124

General

feature

N/A

2010-05-21 12:19

2010-05-21 12:46

mspoor

normal

acknowledged

none

3.4.4

open

Add popup menu item in Role object popup to jump to grant manager for that specific role

It would be ever so easy, if one could open the grant manager on a specific role right from the popup menu in treeview.

Role popup.JPG (17 KB) 2010-05-21 12:19

mspoor

2010-05-21 12:20

DBMS and version should read 'Firebird, but probably others too...'

2121

IBLMPump

feature

always

2010-05-21 11:18

2010-05-21 11:20

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Remove detailed processing debug output

N.A.

thomassteinmaurer

2010-05-21 11:19

A status line after each transaction commit is now printed.

2120

IBLMPump

feature

always

2010-05-21 11:17

2010-05-21 11:20

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Print throughput (records per second) in statistic

N.A.

2109

IBLMPump

feature

always

2010-05-18 09:24

2010-05-21 11:10

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Configurable commit interval for DML operations in destination database

N.A.

2117

IBLMRedo_CommandLine

feature

always

2010-05-20 11:01

2010-05-20 11:03

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Improve performance (throughput)

N.A.

2116

IB LogManager

feature

always

2010-05-20 10:58

2010-05-20 11:00

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Make storing the SQL trace in a redo project optionally

N.A.

2114

IBLMRedo_CommandLine

feature

always

2010-05-20 10:31

2010-05-20 10:58

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Make storing the SQL trace optionally

N.A.

2115

IBLMRedo_CommandLine

feature

always

2010-05-20 10:57

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Show statistic about skipped records

These are UPDATE/INSERT records without column log records.

2108

IBLMPump

minor

always

2010-05-18 09:21

2010-05-20 10:29

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

An error/exception doesn't get displayed, if the verbose switch (-v) is not used

An error/exception should always be printed, even if the -v switch is not used.

2107

IBLMRedo_CommandLine

minor

always

2010-05-18 09:21

2010-05-20 10:29

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

An error/exception doesn't get displayed, if the verbose switch (-v) is not used

An error/exception should always be printed, even if the -v switch is not used.

2111

General

major

always

2010-05-19 01:00

2010-05-19 10:54

1222tmiller

normal

feedback

none

4.0.1

open

Blob Editor when view a CLOB does not use regular fonts and you are unable to select and copy characters.

Blob Editor when view a CLOB does not use regular fonts and you are unable to select and copy characters. Using Oracle 11 local driver, Oracle 10g database.

I like the ideal of having fixed font as an option (like the Use Word-Wrap), but I would prefer the default font be the old font.

martijntonies

2010-05-19 10:54

I have no problems selecting or copying characters, can you clarify?

2103

Oracle Module

minor

have not tried

2010-05-11 08:54

2010-05-11 09:18

martijntonies

normal

resolved

none

3.4.4

fixed

Quick Browse or Data tab in Table Editor fails on Index-Organized tables

Quick Browse or Data tab in Table Editor fails on Index-Organized tables with message ORA-03115: unsupported network datatype or representation

2100

IB LogManager

feature

always

2010-05-06 09:39

2010-05-06 09:51

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Configurable commit interval for DML operations in redo project

N.A.

2097

IBLMRedo_CommandLine

feature

always

2010-05-06 00:03

2010-05-06 09:39

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Configurable commit interval for DML operations

N.A.

2099

IBLMRedo_CommandLine

minor

always

2010-05-06 00:07

2010-05-06 00:12

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Separate transactions for iterating through log data from distributed DML operations

Isolation level, read-only, 2PC etc.

2098

IBLMRedo_CommandLine

feature

always

2010-05-06 00:04

2010-05-06 00:12

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Calculate, display and store records/sec. throughput per redo cycle

N.A.

2096

IB LogManager

minor

always

2010-05-04 08:34

2010-05-04 10:18

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

IB LogManager turns FORCED WRITES automatically ON for the primary connected database

This setting should be left as is.

2057

Diagramming

feature

have not tried

2010-04-07 17:14

2010-05-03 15:18

daltoncalford

normal

feedback

none

open

White Board/Scratch Designer

Very often when specifying a database design, you are not sure of what you are doing until well into the design process.
With most E/R tools, you are required to fill out detailed information that you may not have yet decided upon.

For example, you may decide you need a surrogate key, but have not decided to use auto-incrementing numbers, generated UUIDs or even what domain/datatype will hold that generated value.

If you had the ability to enter a list of strings (each representing a column within the table design), then come back later in the design process to assign datatypes, you make the design process flow easier.

The biggest problem with large project design, is loosing the design due to the details (loosing the forest for the trees). To have the diagrammer's entity box have one more tab that is more free-form, would make the diagramming tool a very powerful development group design feature.

martijntonies

2010-05-03 14:18

Dalton,

When creating a conceptual diagram, the Entity Editor has a Notes box on the first tab and you can freely add attributes without datatypes.

Is this what you mean?

daltoncalford

2010-05-03 15:18

Not really,

From the standpoint of a design session, you may know you need some form of entity to hold a specific type of data.
You may even know some of the basic columns you will need in that entity, but that may change.

So, from a designers standpoint, you need to be able to drop an entity onto the diagram, give it a description, perhaps give it a name, and have a (Delphi Coder Hat coming on) Tstringlist that you populate with the idea of one column per line. No data/domain type, no description. No other tabs on the entity.

The whole diagram has a button on it called "realize" (or something like that) and it's first job would be to go through all the entities and put together a list of unique names, which in turn becomes the domain list.

Once the domain list is produced, a process goes through all the entities, and changes the scratch column list to a real column list with domains. The current system works from there.

This would allow for white board design of the underlying data structures without worrying about assigning/deciding upon datatypes until the overall structure is complete.

Just remember, the name, notes and column list are all different elements in the design process and any one of them may change at any time. Keeping them separate until a physical model is required is a very powerful tool.

It would also be interesting if you had certain types of entities that never would be realized in metadata - ie, diagram objects that represent Servers, Databases, Schema, Client Applications, Middle Tier objects etc. All of these things impact and must be designed for in the database, and there are no tools that currently aid the developer to do this.

Right now, I am using Agilian (http://www.visual-paradigm.com/product/ag/) [^] Sql Maestro and Morfik to coordinate my dev./design team.

We develope it in Agilian, redo all the work into SQL Maestro, and then code the front end with Morfik. It would be nice to replace Agilian and Sql Maestro with a single package that is customized for database design/firebird.

2093

General

minor

have not tried

2010-04-29 08:26

2010-04-29 18:18

martijntonies

normal

closed

none

4.0

fixed

SQL Editor doesn't say "all rows: <number>" when using Fetch All

SQL Editor doesn't say "all rows: <number>" when using Fetch All, it says: "rows fetched" despite fetching all rows.

2092

General

minor

have not tried

2010-04-29 08:25

2010-04-29 18:18

martijntonies

normal

closed

none

4.0.1

fixed

Delay with large resultset and running another query

Delay with large resultset and running another query, there's a noticeable delay if all rows are fetched and another query is run.

2084

Data Export/Import

minor

have not tried

2010-04-26 20:46

2010-04-29 18:18

martijntonies

normal

closed

none

4.0

fixed

Excel export truncates data & headers to single char

2082

SQL Anywhere Module

minor

always

2010-04-26 14:57

2010-04-29 18:18

martijntonies

normal

closed

none

4.0

fixed

When creating new database you can't specify in the Select file dialog non-existing file (also other dialogs)

Usually when you create new Database you have to specify non-existing file.

I use the select dialog to select the folder where my database will be stored. I also sometimes select existing file from that directory and change it's name. At this point i can't click Open because there is no such file an error message is displayed. Instead I have to select existing file and then change the file name in DBW dialog.

martijntonies

2010-04-26 15:00

Also in Backup/Restore options for database archive/file.

2081

General

minor

have not tried

2010-04-26 14:51

2010-04-29 18:18

martijntonies

normal

closed

none

4.0

fixed

Cannot specify non-existent file under "Log Files, Filename" on DB (Registration) options

2080

InterBase Module

minor

always

2010-04-26 14:47

2010-04-29 18:18

martijntonies

normal

closed

none

4.0

fixed

When creating new database you can't specify in the Select file dialog non-existing file.

martijntonies

2010-04-26 14:50

Also the case for Log Files log-filename on DB Reg Options

2075

MySQL Module

major

have not tried

2010-04-26 12:49

2010-04-29 18:18

martijntonies

normal

closed

none

4.0

fixed

Stored Function/Procedure sources aren't read correctly from the database

2074

Firebird Module

minor

always

2010-04-22 13:46

2010-04-29 18:18

doychin

martijntonies

normal

closed

none

4.0

fixed

When creating new database you can't specify in the Select file dialog non-existing file.

martijntonies

2010-04-26 14:50

Also the case for Log Files log-filename on DB Reg Options

2091

IBLMRedo_CommandLine

feature

always

2010-04-28 13:20

2010-04-28 13:29

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Delete processed operation log records if new option is set/used

N.A.

2090

IB LogManager

feature

always

2010-04-28 13:18

2010-04-28 13:29

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Option to delete processed records for a redo project

N.A.

2089

IBLMRedo_CommandLine

major

always

2010-04-28 13:13

2010-04-28 13:14

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Occasional "lock conflict on no wait transaction record from transaction <XYZ> is stuck in limbo" exceptions

N.A.

1714

General

feature

N/A

2009-03-31 19:03

2010-04-28 09:25

RADRuss

normal

acknowledged

none

3.3.0

open

Add support for PostGreSQL

Would like to see a PostGreSQL module for this tool.

scarleton

2009-11-09 15:42

make that two votes for the PostgreSQL module!

jsijpkes

2010-04-28 09:25

me too

2087

IB LogManager

feature

always

2010-04-27 11:56

2010-04-27 12:00

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

BLOB column logging without UDF for Firebird 2.0 and higher

Use the in 2.0 introduced IS DISTINCT FROM predicate for blob column data change detection.

2079

IB LogManager

feature

always

2010-04-26 13:21

2010-04-27 10:20

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Provide way to upgrade redo metadata with new table, generator ...

N.A.

2078

IBLMRedo_CommandLine

feature

always

2010-04-26 13:19

2010-04-27 10:20

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

More robust detection of unprocessed operation log records

Store processed OPERATIONLOG_IDs in a new table (e.g. IBLM$REDOPROCESSEDOLRECORDS) on a per-redo-cycle basis and detect unprocessed operation log records by joining IBLM$OPERATIONLOG.

2077

IB LogManager

feature

always

2010-04-26 13:15

2010-04-27 10:20

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Additional redo metadata for storing unprocessed operation log records

Needed by IBLMRedo_cmd

thomassteinmaurer

2010-04-26 13:20

Summary should be " ... storing *processed* operation log records"

2076

IB LogManager

minor

always

2010-04-26 13:05

2010-04-27 10:20

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

After dropping redo objects, cached metadata isn't updated properly

N.A.

2086

IBLMPump

major

always

2010-04-27 09:12

2010-04-27 09:24

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Execute pump only if no previous pump batch is still busy

N.A.

2085

IBLMRedo_CommandLine

major

always

2010-04-27 09:12

2010-04-27 09:24

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Execute redo only if no previous redo bactch is still busy

N.A.

2073

IBLMRedo_CommandLine

minor

always

2010-04-21 13:40

2010-04-27 09:24

thomassteinmaurer

normal

resolved

none

After 2.10.1

fixed

More understandable generator statistic output

N.A.

2072

IBLMRedo_CommandLine

minor

always

2010-04-21 13:39

2010-04-27 09:24

thomassteinmaurer

normal

resolved

none

After 2.10.1

fixed

"Complete" statistic value should not include generator operation log records

N.A.

2071

IBLMRedo_CommandLine

block

always

2010-04-21 13:37

2010-04-27 09:24

thomassteinmaurer

normal

resolved

none

After 2.10.1

fixed

Infinite loop when processing log records with RDB$ operation log records

N.A.

thomassteinmaurer

2010-04-21 13:38

Such records are generated by Database Triggers (ON CONNECT, ...)

1990

General

feature

have not tried

2010-01-27 13:51

2010-04-23 09:10

martijntonies

normal

acknowledged

none

open

Ability to back up all user data

martijntonies

2010-04-23 09:10

- SQL/Code Catalogs
- Code Templates
- Object Templates
- Name Templates

2031

Firebird Module

minor

have not tried

2010-03-25 08:20

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.3

fixed

Stored Procedure BLOB parameters don't include sub_type clause

2017

Diagramming

feature

have not tried

2010-03-12 09:21

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Diagramming improvements

- automatic sizing of the diagram canvas
- smooth text
- better labels

2008

Installer

feature

have not tried

2010-03-02 10:22

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Installer should raise warning when the application is running

2004

General

minor

have not tried

2010-02-25 09:30

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Context menu option "Edit Constraints" on Check/Unique/FK/PK Constraints doesn't work

Context menu "Edit Constraints" on Check/Unique/FK/PK Constraints doesn't work

2003

SQL Anywhere Module

minor

have not tried

2010-02-24 10:32

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.3

fixed

REFRESH MATERIALIZED VIEW statement fails to execute in SQL Editor

REFRESH MATERIALIZED VIEW statement fails to execute in SQL Editor, with a CURSOR error.

2002

SQL Anywhere Module

feature

have not tried

2010-02-24 10:04

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Show "Advanced Details" and more statistics in Plan Analysis

Show "Advanced Details" in Plan Analysis, also use a higher statistics level

2001

General

feature

have not tried

2010-02-23 13:57

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Query Plan Analysis improvements

- more items "on screen" due to compacter view
- same images in all modules
- improved view on Oracle plans (more compact, more info)
- improved view on MS SQL plans (more compact, more info readily available)
- more info available in tooltips on Sybase SQL Anywhere plan

1996

InterBase Module

minor

have not tried

2010-02-09 17:43

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Plan Analysis tab in Stored Procedure Editor stays empty

1995

General

feature

have not tried

2010-02-01 14:01

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Ability to specify default transaction isolation in Preferences and modify isolation in SQL Editor

Ability to specify default transaction isolation in Preferences and modify isolation in SQL Editor.

1992

MySQL Module

feature

have not tried

2010-01-28 11:32

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Storage engine selection improvements

DB should allow "Application default" or "Database default" as the selection.

App should allow "Database default" as the selection.

Table Editor should issue warning in case the default option isn't found for the database.

1983

General

feature

have not tried

2010-01-13 17:21

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

BLOB Editor: ability to copy/paste hexadecimal strings in the Hex Editor

Ability to copy/paste hexadecimal strings in the Hex Editor

1981

General

tweak

have not tried

2010-01-11 15:00

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Confirmation on dropping an object should be more secure

Ability to optionally have a more secure "drop object" dialog instead of a simple yes/no/cancel, also see 0001598

martijntonies

2010-01-28 15:37

Setting per application and db options setting

1979

ADO/ODBC Explorer

minor

have not tried

2010-01-07 13:33

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

BLOB columns not available in the BLOB Editor for ADO connections

BLOB columns not available in the BLOB Editor

1977

Visual Query Builder

minor

have not tried

2009-12-31 08:47

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Help Button doesn't work

1969

SQL Anywhere Module

minor

have not tried

2009-12-14 10:20

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Result parameters for Stored Procedures with a result set are not listed in the DB Navigator

Create a Stored Procedure that produces a result set, you create a list of RESULT parameters, but they are not listed in the DB Navigator.

1962

Oracle Module

tweak

have not tried

2009-12-08 15:45

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.2

fixed

Ability to modify a Type (header) if there are dependent objects

A Type (header) cannot be modified if there are dependent objects due to CREATE OR REPLACE ddl, by changing this to ALTER TYPE [name] REPLACE this is fixed.

1961

Oracle Module

tweak

have not tried

2009-12-08 10:53

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Package/Type "syntax check" should check both header and body

Package "syntax check" should check both header and body

1960

InterBase Module

minor

have not tried

2009-12-08 09:57

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.2

fixed

Clicking the header on "Avg. Length" on Index statistics in a Bulgarian Locale fails with conversion error

1959

Firebird Module

minor

have not tried

2009-12-08 09:57

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.2

fixed

Clicking the header on "Avg. Length" on Index statistics in a Bulgarian Locale fails with conversion error

1947

MS SQL Module

tweak

have not tried

2009-12-01 10:14

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Query in SQL Editor should not asks to commit/rollback transaction when no changes were made

Query in SQL Editor always asks to commit/rollback transaction even though no changes were made

1946

Firebird Module

minor

have not tried

2009-11-27 10:18

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Plan Analysis tab in Stored Procedure Editor stays empty

1945

InterBase Module

minor

always

2009-11-26 12:06

2010-04-22 10:03

jeroenp

martijntonies

normal

closed

none

3.4.3

fixed

IB: table identifiers longer than 31 characters will give errors when browsing the data

You get this error when you try to browse the data in the Table Edit for the table MEMO_WITH_DIACRITICS_UNICODE_FSS (32 character table name).

<<
Invalid KeyLinks entry: MEMO_WITH_DIACRITICS_UNICODE_FSS.RDB$DB_KEY
>>

Run this SQL script first:

<<
CREATE DOMAIN D_REFID AS
CHAR(36) CHARACTER SET ASCII
NOT NULL
COLLATE ASCII;

CREATE DOMAIN D_MEMOTEXT_UNICODE AS
BLOB SUB_TYPE 1 SEGMENT SIZE 100 CHARACTER SET UNICODE_FSS
;

CREATE TABLE MEMO_WITH_DIACRITICS_UNICODE_FSS
(
REFID D_REFID ,
INDICATIES D_MEMOTEXT_UNICODE
)
;
>>

1942

Data Export/Import

minor

always

2009-11-24 12:38

2010-04-22 10:03

jeroenp

martijntonies

normal

closed

none

3.4.3

fixed

Export wizard: tab order is not good when selecting the kind of export

When you start the Export wizard, and want to choose the kind of export, then the TAB order is not OK.

1938

General

minor

have not tried

2009-11-20 11:05

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Object names not searched when doing "case sensitive" database search

1937

General

feature

have not tried

2009-11-20 09:58

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Additional object types to search for Database Search

Additional items to search for Database Search

- Materialized View
- Indices
- Object Types (source)

1936

Test Data Generator

feature

have not tried

2009-11-18 12:51

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

An overview of which tables have errors and an easy way to view them instead of tabs at the bottom of message screen

An overview of which tables have errors and an easy way to view them.

When there's a lot of tables to be filled, it would be nice to have an "error report" in a list instead of the tabs at the bottom.

1935

Test Data Generator

feature

have not tried

2009-11-18 12:50

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Add a progress indicator that progresses for each table during data generation

1931

General

feature

have not tried

2009-11-13 12:14

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Full Unicode support

1930

General

minor

have not tried

2009-11-12 14:31

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Using the "comment" button can result in a "list index out of bounds" error

Using the "comment" button can result in a "list index out of bounds" error, this happens if the source editor isn't active/focused.

1926

General

tweak

have not tried

2009-11-12 12:09

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Rework the "Duplicate Object" dialog when duplicating a table

Rework the "Duplicate Object" dialog when duplicating a table.

It's not very clear when data can be copied and when child objects need to be edited. This needs improvement.

1915

SQL Anywhere Module

tweak

have not tried

2009-11-03 10:55

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

List Domains in Stored Function/Procedure parameter "datatype" drop down box

1905

DataPump

feature

have not tried

2009-10-28 14:54

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

An overview of which transfers have errors and an easy way to view them instead of tabs at the bottom of message screen

An overview of which transfers have errors and an easy way to view them.

When there's a lot of tables to be transferred, it would be nice to have an "error report" in a list instead of the tabs at the bottom.

1904

DataPump

feature

have not tried

2009-10-28 13:57

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Add a progress indicator that progresses for each table during transfer

Add some kind of progress indicator that progresses per table during transfer

1896

MySQL Module

minor

have not tried

2009-10-27 09:49

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.0

fixed

Server Status, page "Grouped" lists ssl_cache_hits multiple times

1891

MS SQL Module

minor

have not tried

2009-10-22 10:08

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.1

fixed

Cannot delete file specifications when creating a database, only add new ones

1878

General

tweak

have not tried

2009-09-29 12:03

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

When selecting a window from the "taskbar", it should restore when it's minimized

1877

General

minor

have not tried

2009-09-29 09:31

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.0

fixed

When an external Tool fails to start properly, there's no error and you don't know why it fails

When an external Tool fails to start properly, there's no error and you don't know why it fails.

1858

General

feature

N/A

2009-08-23 19:27

2010-04-22 10:03

doychin

martijntonies

normal

closed

none

3.4.1

fixed

When using parametrized statement keep in history not only parameter value but also its type

In SQL Editor when you have parametrized query and you click prepare button parameter grid is shown. There you can specify value but you can also specify value type.

later when I want to prepare again another statement I can use parameter values from history but I have to set parameter type every time I prepare this query.

1802

General

feature

always

2009-06-12 11:58

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Additional options for Search Database functionality (ignore comments, full-match/partial-match etc)

- option to not ignore source code comments
- option to include object description
- optional "full match" instead of current "partial match"

1779

Firebird Module

feature

always

2009-05-05 08:55

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Improved ARRAY support

Improved ARRAY support:

Improved support for array data type. At present all I see is “(ARRAY)” which does not help me
examine the data.

martijntonies

2009-11-30 17:23

single dimension array data is editable

1778

InterBase Module

feature

always

2009-05-05 08:55

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Improved ARRAY support

Improved ARRAY support:

Improved support for array data type. At present all I see is “(ARRAY)” which does not help me
examine the data.

martijntonies

2009-11-30 17:23

single dimension array data is editable

1667

DataPump

feature

always

2009-02-17 14:19

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Auto-map functionality on a per table basis, use the context menu

Create "link to table in target/source database" context menu items for tables, this would like a single table without the need to drag/drop.

1598

General

tweak

always

2008-11-25 15:27

2010-04-22 10:03

edelcom

martijntonies

normal

closed

none

3.3.0

fixed

Confirmation of 'Drop database?' question should be more secure

At the very least, the No button should be included as default button, but I would like to see it even more secure.
Dropping a database is such a big (non reversable) error: it could not be save enough.

dropdbconfirm.gif (6 KB) 2009-12-02 08:13

martijntonies

2009-12-02 08:14

See the attached dialog, the functionality is optional turned ON by default. If you turn OFF "secure db drop", you'll get the current behaviour.

1525

Oracle Module

feature

always

2008-10-16 09:24

2010-04-22 10:03

thomassteinmaurer

martijntonies

normal

closed

none

3.1.1

fixed

Alter/Create Package/Type with automatic syntax check

Using the Package Editor to implement a package and procedures. Currently, when altering/creating a package (CTRL+S) the package gets compiled without any hint that e.g. there are syntax errors. I guess it gets compiled, but as invalid object. To be honest, I don't like that.

If I want to make sure that my package has zero errors, I have to do a
syntax error check before altering the package. Any chance to get an
error message or hint that an error is in the package when doing a CTRL
+ S? Or is there already somewhere an option?

1519

General

feature

always

2008-10-09 13:31

2010-04-22 10:03

mspoor

martijntonies

normal

closed

none

3.1.1

fixed

Add possibility to order SQL data grids by clicking on column header

In many database viewers it is common (and very handy!) to be able to (re)sort the viewed data by clicking on the column headers.

Accepted standard behaviour for this is:
- one click on a previously unsorted column, resets all previous column sorts, and sorts that column ASCending.
- a click on a already sorted column switches the direction of the sort of that column:
ASC --> DESC
DESC --> ASC
- a click on a previously unsorted column while HOLDING the CTRL key, adds the column to an already existing sort (makes it the second, third, etc field on which it is sorted)

1432

General

tweak

always

2008-06-24 12:53

2010-04-22 10:03

Eyal

martijntonies

normal

closed

none

3.1.1

fixed

Smart and efficient "Automatic column resize"

(Assuming that "Automatic column resize" should work in the Data tab of the Table editor)

Two of the settings available under "Automatic column resize" require a scan of the entire table, in order to determine the optimal column widths. Depending on table size and communication overhead, a full table scan can be very expensive.

I suggest an alternative:

1. Use only the already fetched (visible) records.

2. Add an option to dynamically resize the columns as the user scrolls through the data (some users may find this useful, for others it may be distracting).

martijntonies

2008-11-07 15:31

Making this available "as you scroll" is pretty easy, I also looked at visible rows, but this seems harder for some reason (due to the grid control used).

What do you propose?

martijntonies

2009-12-03 09:35

The upcoming version uses your alternative (1)

1207

General

minor

always

2007-11-22 15:14

2010-04-22 10:03

martijntonies

normal

closed

none

3.0

fixed

ADO connection with BIGINT datatype cannot be browsed with a value of 9223372036854775807

BIGINT datatype cannot be browsed with a value of 9223372036854775807 (the maximum bigint value), the minimum value (-9223372036854775808) works fine.

martijntonies

2007-11-23 10:18

The problem seems slightly more complex:
http://qc.borland.com/wc/qcmain.aspx?d=8858 [^]

martijntonies

2008-11-24 16:45

Perhaps fixed in D2009?

1093

MySQL Module

minor

always

2007-10-08 11:29

2010-04-22 10:03

martijntonies

normal

closed

none

3.0

fixed

With a server-side (idle) timeout, DBWs connection gets dropped

With a server-side (idle) timeout, DBWs connection gets dropped, this causes SQL to be lost etc.

Can this be avoided by keeping the connection alive?

893

General

tweak

always

2007-03-28 16:02

2010-04-22 10:03

Set

martijntonies

normal

closed

none

2.8.8

fixed

Ability to work with the grant manager without using the mouse in the grid

To grant rights to a user one must use the mouse and click. Clicking selects the chosen priviledge and moves the cursor. I tried to use the arrow keys and press the space bar for (de-)selecting priviledges, but that did not work. Hence, I had to go back to clicking.

Just a minor quirk where Database Workbench doesn't do what I consider intuitive.

martijntonies

2007-03-28 16:51

Would a "spacebar" or "enter" be OK to toggle the state of a privilege?

757

General

feature

always

2006-11-29 15:34

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Integrate the BLOB Editor with the SQL Editor data grid page

For easier access to BLOB data, have the blob editor to the right side of the data grid. Planned for 3.5 or 4.0

2069

Diagramming

minor

have not tried

2010-04-19 11:36

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.4

fixed

New tables, not yet saved to file, have invalid PRIMARY KEY clause

New tables, not yet saved to file, have invalid PRIMARY KEY clause.

Create a table with PK column, extract DDL and there's an invalid PK clause.

2068

Diagramming

minor

have not tried

2010-04-19 11:31

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.4

fixed

Primary Key flag in columns cannot be reset once a table has been accepted in a PDM

Primary Key flag in columns cannot be reset once a table has been accepted in a PDM, whatever you do, the flag stays "on" when you switch to the DDL tab on the Table Editor

2059

InterBase Module

feature

N/A

2010-04-09 12:56

2010-04-22 10:03

martijntonies

normal

closed

none

4.0

fixed

Ability to specify client library to use when registering server

With multiple InterBase clients installed, the user should be able to pick one.

2058

Firebird Module

feature

N/A

2010-04-08 12:16

2010-04-22 10:03

mspoor

martijntonies

normal

closed

none

4.0

fixed

Ability to specify client library to use when registering server

DBW should be aware of the Firebird version of a server, so it can use the correct fbclient.dll (this is needed for displaying correct error messages and probably more)
Please expand server registration with version of firebird.

mspoor

2010-04-08 13:39

It would be more 'advanced' to let the user select the version of firebird though.

option 1: The DBW install could contain the fbclient.dll's of all known versions (renamed as 'fbclient155.dll or whatever). This way it would not be necessary to install all versions of firebird on the machine.

option 2: DBW server registration will also let you choose the fbclient.dll location/file, but pre-select the correct one based on selected firebird-version (the paths could be based on standard FB-install locations).

Awell, just my 2 cents, as long as multiple fbclient.dll's are possible...

2053

General

tweak

always

2010-04-07 15:13

2010-04-22 10:03

mspoor

martijntonies

normal

closed

none

4.0

fixed

When an error occurs in SQL Script execution, and user selects 'Abort' please select correct line in script

The current situation:
If a command in a SQL script returns an error, and the user selects 'Abort', the cursor is set at the bottom of the script, and one has to try to find the problematic instruction by scrolling in the log, and then searching the line in the script.

It would be ever so handy if the script editor (cursor) would be set on the corresponding statement (or the first line of it).

mspoor

2010-04-08 09:35

Maybe this one can be better noted as a bug, as it is thát irritating :-)

mspoor

2010-04-09 14:17

Does it help when I say 'please...' very nicely? This one will make my
'scripting life' so much easier... :-)

martijntonies

2010-04-09 14:54

Because you said Please ;)

2048

General

feature

have not tried

2010-03-31 09:40

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Ability to omit charset/collation when extracting DDL

2047

Schema Migrator

feature

have not tried

2010-03-31 09:40

2010-04-22 10:03

martijntonies

normal

closed

none

fixed

Ability to omit charset/collation when migrating objects

2032

InterBase Module

minor

have not tried

2010-03-25 08:21

2010-04-22 10:03

martijntonies

normal

closed

none

3.4.3

fixed

Stored Procedure BLOB parameters don't include sub_type clause

2067

IBLMRedo_CommandLine

feature

always

2010-04-15 09:39

2010-04-15 10:44

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Add command-line switch to write encrypted password for SMTP authentication into .ini file

N.A.

2066

IBLMPump

feature

always

2010-04-15 09:38

2010-04-15 10:44

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Add command-line switch to write encrypted password for SMTP authentication into .ini file

N.A.

2065

IBLMExport

feature

always

2010-04-15 09:38

2010-04-15 10:44

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Add command-line switch to write encrypted password for SMTP authentication into .ini file

N.A.

2064

IBLMRedo_CommandLine

feature

always

2010-04-15 09:37

2010-04-15 10:44

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Add SMTP authentication configuration parameters

User, Password, Password encryption etc.

2063

IBLMPump

feature

always

2010-04-15 09:37

2010-04-15 10:44

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Add SMTP authentication configuration parameters

User, Password, Password encryption etc.

2062

IBLMExport

feature

always

2010-04-15 09:37

2010-04-15 10:44

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Add SMTP authentication configuration parameters

User, Password, Password encryption etc.

2061

IB LogManager

minor

always

2010-04-14 10:25

2010-04-15 10:44

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Support for more reserved Firebird keywords

E.g.: ROWS, START won't be detected.

2060

IB LogManager

major

always

2010-04-14 09:48

2010-04-15 10:44

thomassteinmaurer

normal

resolved

none

2.10.1

fixed

Dropping a trigger with a name containing spaces fails

N.A.

2052

Firebird Module

minor

always

2010-04-07 14:04

2010-04-08 12:08

mspoor

normal

closed

none

3.4.4

no change required

Ugly error when trying to drop a view which does not exist

DROP VIEW SOMENAME;

will give a Dynamic SQL Error
Invalid command
unknown ISC error 336397207

In an SQL Script it will give even more technical babble:

Script error:
Dynamic SQL Error
SQL Error code = -607
Invalid command
unknown ISC error 336397207

Could there (in some way) be given a more user friendly message the specified view could not be dropped?

afbeelding.png (24 KB) 2010-04-07 15:16

martijntonies

2010-04-07 14:08

I get:
Dynamic SQL Error SQL error code = -607 Invalid command View UNKNOWN_VIEW does not exist

Sounds about right, these errors come straight from Firebird.

mspoor

2010-04-07 15:17

I don't get the 'View XXXX does not exist' message (see attached screenshot)

martijntonies

2010-04-07 15:44

Sounds like you have multiple "fbclient.dll" files or not the correct message file (fbmessage.msg) for your server version.

mspoor

2010-04-08 09:47

I've got multiple fbclient.dll files on my harddrive, that's for sure :-) But is that really the problem? They're not in C:\Windows\System32 or something... Only in the directories of different applications.

Let's see, there is one fbclient.dll in "C:\Program Files\Upscene Productions\Database Workbench 3 Pro", which is version 1.5.5, whilest my server is FB2.0.5...
Okay, I replaced the fbclient.dll in the DBW3 directory with a fbclient.dll of FB2.0.5 and now it returns the correct message for this server!

But how does DBW3 then choose a fbclient.dll to use when there are servers in the list with different versions of FB?
[In EMS you can specify the fbclient.dll to use in the Host-registration information]

martijntonies

2010-04-08 10:16

Database Workbench 3 uses the first fbclient is can find:
- program folder
- windows PATH variable

The components we use for Firebird access in DBW 3 do not allow to specify the fbclient on a per connection basis, this would be possible for DBW 4 though, if required.

mspoor

2010-04-08 12:05

Okay, that would be a good feature request then.
Do you want me to create a new ticket for that?

martijntonies

2010-04-08 12:07

Yes please do so.

2056

Diagramming

feature

have not tried

2010-04-07 16:49

2010-04-07 18:54

daltoncalford

normal

acknowledged

none

open

Diagram Layout/Formating Options

Introduce new options for the diagram, including landscape layout, border/margin properties, legend, diagram stamp etc.

The diagrams are used in design documentation, specification manuals etc., and having the ability to have the diagram fit into the existing document structures makes such a tool invaluable.

2055

Diagramming

feature

have not tried

2010-04-07 16:39

2010-04-07 18:52

daltoncalford

normal

acknowledged

none

open

New Symbols for Diagramming

The diagraming tool is nice, but needs some features to allow us to model/refactor databases fully.

For example, it would be nice to have symbols that represent the following

* Views
* Stored Procedures
* Triggers
* Schema
* User Roles

Also, to take the diagramming tool from the realm of an enhanced E/R diagram, it would be great if it also had symbols for the following

* Applications
* Forms
* Servers
* Databases
* External Files/Tables
* Client Connections

Most of these items could be represented with a simple rectangle that had a user defined icon in one corner, a name, a description and a place to hold free form text. The item would also have a single boolean property to state whether or not the free from text is to be exported raw to any ddl/dml extracts.

This sort of tool is invaluable in describing large complex system designs or refactoring existing designs.

Most of this functionality is available in other products such as Agilian from Visual Paradigm http://www.visual-paradigm.com [^]

martijntonies

2010-04-07 18:52

Do note that in a physical diagram, there is a "View" icon available.

2051

Firebird Module

minor

have not tried

2010-04-07 13:25

2010-04-07 14:23

mspoor

normal

closed

none

4.0

fixed

Unlogical error in restore dialog: Requires input and output filenames

Error: requires both input and output filenames when trying to restore a firebird database.
--> start restore dialog
--> enter database and SYSDBA info
--> manually enter the filename for the backupfile
--> click green 'start restore' button, and error appears.

My guess is that the filename edit box has not yet reported that a filename has been entered, because it has not received an 'on exit' event or something.

afbeelding.png (24 KB) 2010-04-07 13:25

martijntonies

2010-04-07 14:23

4.0 issues should be reported to support@upscene.com -- this has been fixed though ;)

1844

General

crash

sometimes

2009-08-11 17:25

2010-04-07 10:18

rdebay

normal

closed

none

3.4.0

unable to reproduce

Access violation when closing

Access violation at address 4003C5AC in module 'rtl70.bpl'. Write of address 0000000D

You can't close the application. If the popup appears, selecting either 'continue' or 'cancel' doesn't make a difference.

martijntonies

2009-08-11 17:28

No other issues -before- closing?

rdebay

2009-08-11 17:39

No other issues. This has happened with DBW since 2.0.

I can't upload a 2.22MB dump file. I get the error:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 2396886 bytes) in D:\Inetpub\misc.upscene.com\mantis\core\database_api.php on line 428

martijntonies

2009-08-11 18:34

Feel free to send me that file by e-mail at support @ upscene.com

martijntonies

2009-08-12 12:46

Hm, the dump doesn't help much.

Any more info?

- are you using the "statement recorder"-tool?
- are you closing DBW while it's still starting up/loading server?
- while connecting to a database?
- got any SQL (Editors) active?

rdebay

2009-08-12 17:59

No
No
No
Open, but not active

"If the popup appears, selecting either 'continue' or 'cancel' doesn't make a difference."

At this point, everything is closed except for the basic DBW application. I've read some other posts about problems closing Delphi 7, but no answers.
I don't think it's DBW, I think it's Delphi.

2009

Schema Compare

feature

N/A

2010-03-02 10:55

2010-04-07 09:30

jsijpkes

normal

acknowledged

none

3.4.3

open

Ability to use ODBC or ADO in database compare

I often have to compare access databases with a live MS SQL system. I would like to use the database comparer for this purpose, but it is not available. Also access-2-access comparisons are useful. The databases always contain end-user customizations in the form of added fields etc.
Currently I have to migrate the database to a supported platform (like firebird) and have to do the compare afterwards. Lots of work, lots of debris and in my view utterly unnecessary..
Please add the ability to compare ODBC sources, what is the point in hiding this functionality anyway if it is available in the datapump and migrator?

martijntonies

2010-04-07 09:30

One of the reasons to not have this yet, is that the Compare offers the ability of a "change script" to update the target database, obviously, doing a compare against ODBC/ADO would be read only.

2049

General

tweak

have not tried

2010-04-06 15:51

2010-04-06 15:54

mspoor

normal

acknowledged

none

3.4.4

open

Make import Data Wizard form resizeable in height

The Import Data Wizard is only resizeable in width. It would be nice if it could be resized in height as well.

2046

Oracle Module

block

have not tried

2010-03-31 08:53

2010-04-01 11:30

martijntonies

normal

closed

none

3.4.3

fixed

Assertion error in uORCLRelation, line 267

Assertion error in uORCLRelation, line 267.

This seems to be caused by certain XML related columns.

2045

Oracle Module

minor

have not tried

2010-03-30 16:12

2010-04-01 11:30

martijntonies

normal

closed

none

3.4.3

fixed

"Table or View not Found" error on opening table for editing or browsing metadata

"Table or View not Found" error on opening table for editing or browsing metadata.

Possibly caused by XML loading of columns (system view) not being accessible.

2035

Schema Migrator

major

always

2010-03-25 15:30

2010-04-01 11:30

rdebay

martijntonies

normal

closed

none

3.4.2

fixed

Migrator in Firebird truncates constraint names to 27 chars instead of 31

Object names are truncated to 27 characters.

Firebird allows up to 31 characters, so the names in the generated scripts were incorrect.

martijntonies

2010-03-29 11:44

If this is about constraints: these names should be 27 max chararacters long due to constraint ACL issues.

Can you clarify what objects you're talking about?

rdebay

2010-03-29 15:57

All objects were truncated, the one that drew our attention was a primary key name.
Regardless of what the length of an item "should" be, the script must reflect what exists.

martijntonies

2010-03-29 16:05

I'm not sure if I get this right --

Things were truncated how? When? Please be specific when reporting issues.

When migrating existing objects from one db to another? How did "all objects" become truncated? As far as I can see, only constraint names are trunctated during migration IF the name is longer than the maximum length of the allowed name, in the case of constraints, this is 27 characters.

rdebay

2010-03-29 18:23

Exported by migrator:
CREATE TABLE IMPORT_FEE_GRANTEE_DISC_STRUCT
(
  EXTERN_ID CHAR( 8) CHARACTER SET ISO8859_1 NOT NULL COLLATE ISO8859_1,
  PARENT_EXTERN_ID CHAR( 8) CHARACTER SET ISO8859_1 NOT NULL COLLATE ISO8859_1,
  GRANTEE D_KEY NOT NULL,
  BASE_CLAIMS INTEGER NOT NULL,
  DISCOUNT DECIMAL( 9, 2) NOT NULL,
  INCREMENTAL DECIMAL( 7, 5) NOT NULL,
  MODIFIED TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
CONSTRAINT PK_IMPORT_FEE_GRANTEE_DISC_ PRIMARY KEY (EXTERN_ID, MODIFIED)
);

From DDL tab for the source table:
CREATE TABLE IMPORT_FEE_GRANTEE_DISC_STRUCT
(
  EXTERN_ID CHAR( 8) NOT NULL COLLATE ISO8859_1,
  PARENT_EXTERN_ID CHAR( 8) NOT NULL COLLATE ISO8859_1,
  GRANTEE D_KEY NOT NULL,
  BASE_CLAIMS INTEGER NOT NULL,
  DISCOUNT DECIMAL( 9, 2) NOT NULL,
  INCREMENTAL DECIMAL( 7, 5) NOT NULL,
  MODIFIED TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
CONSTRAINT PK_IMPORT_FEE_GRANTEE_DISC_STR PRIMARY KEY (EXTERN_ID, MODIFIED)
);

The last three characters of the primary key name were removed.

martijntonies

2010-03-29 19:23

Right, thanks, that's quite different from "truncates object names" ;)

I'll take a look.

Either way, constraint names in Firebird should be 27 chars long at the most.

2033

Firebird Module

minor

have not tried

2010-03-25 13:04

2010-04-01 11:30

martijntonies

normal

closed

none

3.4.3

fixed

Setting a SP Parameter to the same datatype as a domain doesn't clear domain name

Setting a SP Parameter to the same datatype as a domain doesn't clear domain name.

1) create a procedure with a domain as the parameter type
2) save
3) modify the parameter to have the same datatype as the domain -> domain name is still used

2029

Firebird Module

minor

have not tried

2010-03-23 13:16

2010-04-01 11:30

martijntonies

normal

closed

none

3.4.3

fixed

Using a domain in SP parameter with a different charset can cause problem in DDL

Using a domain in SP parameter with a different charset can cause problem in DDL.

The charset is listed in the DDL, which is wrong, only the Collation should be listed.

See test db by Raymond, procedure PA_AJOUT_BD_DOMAINE.

2028

MS SQL Module

minor

have not tried

2010-03-22 12:34

2010-04-01 11:30

martijntonies

normal

closed

none

3.4.1

fixed

Enable/disable database trigger fai