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: 38110
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)

Otis avatar
Otis
LLBLGen Pro Team
Posts: 38110
Joined: 17-Aug-2003
# Posted on: 10-Dec-2019 15:56:37   

Looks like a 5 minute fix, stay tuned

Otis avatar
Otis
LLBLGen Pro Team
Posts: 38110
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)

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

It works, thanks !!!