Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Bugs & Issues> MySQL (mariaDB) FLOAT is mapped onto string
 

Pages: 1
Bugs & Issues
MySQL (mariaDB) FLOAT is mapped onto string
Page:1/1 

  Print all messages in this thread  
Poster Message
braidiano
User



Location:
Braidi, IT
Joined on:
18-Nov-2006 20:47:42
Posted:
40 posts
# Posted on: 10-Dec-2019 12:57:40. Goto attachments  
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?
Davide  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37797 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37797 posts
# Posted on: 10-Dec-2019 15:56:37.  
Looks like a 5 minute fix, stay tuned
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37797 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
braidiano
User



Location:
Braidi, IT
Joined on:
18-Nov-2006 20:47:42
Posted:
40 posts
# Posted on: 12-Dec-2019 15:40:46.  
It works, thanks !!!
Davide  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.