MySQL (mariaDB) FLOAT is mapped onto string

Posts   
 
    
braidiano
User
Posts: 40
Joined: 18-Nov-2006
# Posted on: 10-Dec-2019 12:57:40   

Hi,

designer version: 5.6 (5.6.1) RTM (21-ott-2019) database: 5.5.60-MariaDB

i have the following field:

duration FLOAT UNSIGNED DEFAULT NULL,

i think there is a bug in the designer, because it map the file as string (please see the attachment)

can you check please?

Attachments
Filename File size Added on Approval
designer.png 41,245 10-Dec-2019 12:57.49 Approved
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 10-Dec-2019 15:42:53   

We don't test against mariadb but mysql db, but we see we have support for 'Float' but not 'unsigned float'.

As 'unsigned' is deprecated in mysql 8.x for float, is it a problem to remove the 'unsigned' attribute for this type in your db? If it is, we'll try to add a hotfix for this.

(the types come back from the db in the meta data as strings, hence our driver doesn't find the float and falls back to varchar)

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 10-Dec-2019 15:56:37   

Looks like a 5 minute fix, stay tuned

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 10-Dec-2019 16:25:37   

Please download 5.6.2 hotfix from the website. It supports unsigned float/double/decimal now. Hope this fixes your issue (you have to sync with the database again to make it assign the right types to the table fields)

Frans Bouma | Lead developer LLBLGen Pro
braidiano
User
Posts: 40
Joined: 18-Nov-2006
# Posted on: 12-Dec-2019 15:40:46   

It works, thanks !!!