[digikam] [Bug 374302] MYSQL : all Images with Geoinfo seem to be at (0°, 0°)

[Lukas Winkler]

https://bugs.kde.org/show_bug.cgi?id=374302

--- Comment #22 from Lukas Winkler <kde at lw1.at> ---
I just checked it: I am using MariaDB 10.1.23 on Debian Stretch.

MariaDB [digikamtest]> SELECT * FROM ImagePositions;
+---------+-----------------+--------------------+-----------------+--------------------+----------+-------------+------+------+----------+-------------+
| imageid | latitude        | latitudeNumber     | longitude       |
longitudeNumber    | altitude | orientation | tilt | roll | accuracy |
description |
+---------+-----------------+--------------------+-----------------+--------------------+----------+-------------+------+------+----------+-------------+
|       1 | 48,25.23788333N | 48.420631388888886 | 15,37.13064167E |
15.618844027777778 |      249 |        NULL | NULL | NULL |     NULL | NULL    
   |
+---------+-----------------+--------------------+-----------------+--------------------+----------+-------------+------+------+----------+-------------+
1 row in set (0.00 sec)

MariaDB [digikamtest]> describe ImagePositions;
+-----------------+----------+------+-----+---------+-------+
| Field           | Type     | Null | Key | Default | Extra |
+-----------------+----------+------+-----+---------+-------+
| imageid         | int(11)  | NO   | PRI | NULL    |       |
| latitude        | longtext | YES  |     | NULL    |       |
| latitudeNumber  | double   | YES  |     | NULL    |       |
| longitude       | longtext | YES  |     | NULL    |       |
| longitudeNumber | double   | YES  |     | NULL    |       |
| altitude        | double   | YES  |     | NULL    |       |
| orientation     | double   | YES  |     | NULL    |       |
| tilt            | double   | YES  |     | NULL    |       |
| roll            | double   | YES  |     | NULL    |       |
| accuracy        | double   | YES  |     | NULL    |       |
| description     | longtext | YES  |     | NULL    |       |
+-----------------+----------+------+-----+---------+-------+
11 rows in set (0.00 sec)

-- 
You are receiving this mail because:
You are the assignee for the bug.