SqlDbx Forum

SqlDbx

You are not logged in.

#1 2011-03-24 18:04:30

Roman
Guest

couple of bugs with mysql

Great program guys, unfortunately I dont have the kind of cash to buy it atm, but I like it a lot.
Anyway, I found a couple of bugs on my version (2.4.6) when working with MySQL (5.x) and havnt seen a fix in the change-log so I thought Id post what I found.

1. scripting table create. The script seems to skip regular, non-unique indexes. eg:

One of these scripts is from SqlDbx, the other from a different utility. The script generated by SqlDbx is missing the index
Rollover_History_IND2.

CREATE TABLE rollover_history
    (
    aKey             INT NOT NULL auto_increment,
    RolloverID       VARCHAR (40) NOT NULL,
    DateDone         DATETIME NULL,
    MonthendDateUsed CHAR (8) NULL,
    Note             VARCHAR (255) NULL,
    PRIMARY KEY (aKey),
    CONSTRAINT Rollover_History_IND1 UNIQUE (RolloverID)
    );

CREATE TABLE `rollover_history` (
  `aKey` int(11) NOT NULL auto_increment,
  `RolloverID` varchar(40) NOT NULL default '',
  `DateDone` datetime default NULL,
  `MonthendDateUsed` char(8) default NULL,
  `Note` varchar(255) default NULL,
  PRIMARY KEY  (`aKey`),
  UNIQUE KEY `Rollover_History_IND1` (`RolloverID`),
  KEY `Rollover_History_IND2` (`DateDone`)
);

2. Im not sure if its a problem on my side, or a bug, but I cannot script or popup (alt+F1) a script for a MySQL Function. Im Not sure about procedures as I dont have any. When I try, I just get a little window with a big red "X" in it.

Cheers
Roman

#2 2011-03-24 18:05:58

Roman
Guest

Re: couple of bugs with mysql

As for my last post, the version Im using is 3.4.6, not 2.4.6.

#3 2011-03-27 22:59:57

sqldbxhelp
Administrator

Re: couple of bugs with mysql

Couple of things. It looks to me that you connect through generic ODBC and not MySQL type of connection.
If you do use MySQL connection then you can check "Use SHOW CREATE... for Scripting" option in Servers->MySQL.
Not sure what is the issue with functions. What version of MySQL and MySQL ODBC driver you use?

Offline

Board footer

Powered by FluxBB