Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Fixed
- 
    1.0.5
- 
    None
Description
Found a strange behavior with float values.
| import mariadb | 
| import locale | 
|  | 
| conn = {'host': '192.168.1.2', 'user': 'test', 'password': 'test'} | 
|  | 
| db = mariadb.connect(**conn) | 
| qr = db.cursor() | 
|  | 
| latitude = -24.971077771106 | 
| longitude = -53.95170397719726 | 
|  | 
| qr.execute('set @lat=?, @lng=?', (latitude, longitude)) | 
|  | 
| qr.execute('select @lat, @lng') | 
| lat, lng = qr.fetchone() | 
| print(lat, lng) | 
| # Here, returns what's expected: -24.971077771106 -53.95170397719726 | 
|  | 
| locale.setlocale(locale.LC_ALL, 'pt_BR.utf8') | 
|  | 
| qr.execute('select @lat, @lng') | 
| lat2, lng2 = qr.fetchone() | 
| print(lat2, lng2) | 
| # But here, returns: -24.0 -53.0 |