GetSchema("Columns") isn't complete

inTrance · Post by **inTrance** » Sat 11 Nov 2006 12:38

Hello!

We use GetSchema("Columns") to retrieve table details. But there is at least one important flag missing: The decimal count of a double/decimal/float like "double (7,3)"

Is there any other possibility to get this information without using selfmade-SQL-Scripts? And do you want to add this flag to the schema?

Regards,

Sven Kolber

Alexey · Post by **Alexey** » Mon 13 Nov 2006 08:30

You mean precision and scale? These data is retrived as well.

inTrance · Post by **inTrance** » Tue 14 Nov 2006 16:09

Unfortunately not in my case. I have the following field in a table on a MySQL 5.0 server:

Code: Select all

spesen      double(20,10)  (NULL)           NO              13.9000000000

This field fills Precision with 20 and Scale with 0...

Alexey · Post by **Alexey** » Wed 15 Nov 2006 11:48

Please provide me with your table definition.

inTrance · Post by **inTrance** » Wed 15 Nov 2006 15:12

Here is an other example on a 5.0 server:

Table definition

Code: Select all

CREATE TABLE `products` (                          
            `ProductID` int(11) NOT NULL auto_increment,     
            `ProductName` varchar(40) NOT NULL,              
            `SupplierID` varchar(20) default NULL,           
            `CategoryID` decimal(12,3) default '0.000',     // <------- 
            `QuantityPerUnit` smallint(6) default '0',       
            `UnitPrice` smallint(6) default '0',             
            `UnitsInStock` smallint(6) default '0',          
            `UnitsOnOrder` tinyint(4) NOT NULL default '0',  
            PRIMARY KEY  (`ProductID`)                       
          ) ENGINE=MyISAM DEFAULT CHARSET=utf8

The result of MySQLDirect is:

Precision: 12
Scale: 0 (should be 3)

Regards[/b]

Alexey · Post by **Alexey** » Wed 15 Nov 2006 16:30

I cannot reproduce the error. Schema is rettrived correctly. What are the full versions of MySQL Server and MySQLDirect .NET?

inTrance · Post by **inTrance** » Wed 15 Nov 2006 16:43

Alexey wrote:I cannot reproduce the error. Schema is rettrived correctly. What is the full versions of MySQL Server and MySQLDirect .NET?

Latest MySQLDirect version (.14)
Windows MySQL Server: 5.0.15

Alexey · Post by **Alexey** » Wed 15 Nov 2006 17:27

We are investigating this problem with your particular version.
You will be notified on results as soon as possible.

inTrance · Post by **inTrance** » Mon 27 Nov 2006 18:00

Alexey wrote:We are investigating this problem with your particular version.
You will be notified on results as soon as possible.

Do you have some results?

Regards

Alexey · Post by **Alexey** » Tue 28 Nov 2006 07:49

We have fixed this for you. Look forward to the next build.