[digiKam-users] Advanced search: selecting by aspect ratio

[Jürgen Blumenschein]

Hi all together,

First: great software !
I'm using 6.0.0 with ArchLinux on desktop and two notebooks with  
mariadb and sqlite.

For a long time I tried on sunday selecting by aspect ratio, which  
worked fine on my notebook with sqlite but not on the desktop with  
mariadb.
The console said that the query was wrong.
I found out, that there is difference in the sql dialects:
the absolute function in sqlite is "abs( number )" in lowercase letters
in mariadb it's "ABS( number )" in uppercase.
Could it be fixed please?

Jürgen



--
Jürgen Blumenschein, eMail: [hidden email]
Homepage: http://members.dokom.net/blumenschein
Am Quartus 17
D-44149 Dortmund
Tel.: [phone], Handy: [phone]
public key:  
http://members.dokom.net/blumenscheinJuergen_Blumenschein_(0xC9358EBB)_public_key.asc

[Gilles Caulier-4]

Hi,

Thanks for the feedback.

Please report this problem to KDE/digiKam bugzilla as a new entry.

Thanks in advance

Gilles Caulier

Le lun. 11 mars 2019 à 10:53, Jürgen Blumenschein <[hidden email]> a écrit :

Hi all together,

First: great software !
I'm using 6.0.0 with ArchLinux on desktop and two notebooks with 
mariadb and sqlite.

For a long time I tried on sunday selecting by aspect ratio, which 
worked fine on my notebook with sqlite but not on the desktop with 
mariadb.
The console said that the query was wrong.
I found out, that there is difference in the sql dialects:
the absolute function in sqlite is "abs( number )" in lowercase letters
in mariadb it's "ABS( number )" in uppercase.
Could it be fixed please?

Jürgen



--
Jürgen Blumenschein, eMail: [hidden email]
Homepage: http://members.dokom.net/blumenschein
Am Quartus 17
D-44149 Dortmund
Tel.: [phone], Handy: [phone]
public key: 
http://members.dokom.net/blumenscheinJuergen_Blumenschein_(0xC9358EBB)_public_key.asc

[meku]

SQL functions are not case sensitive in any of these platforms. Both "ABS( )" or "abs( )" will work in any query.

On Mon, 11 Mar 2019 at 20:54, Jürgen Blumenschein <[hidden email]> wrote:

Hi all together,

First: great software !
I'm using 6.0.0 with ArchLinux on desktop and two notebooks with 
mariadb and sqlite.

For a long time I tried on sunday selecting by aspect ratio, which 
worked fine on my notebook with sqlite but not on the desktop with 
mariadb.
The console said that the query was wrong.
I found out, that there is difference in the sql dialects:
the absolute function in sqlite is "abs( number )" in lowercase letters
in mariadb it's "ABS( number )" in uppercase.
Could it be fixed please?

Jürgen



--
Jürgen Blumenschein, eMail: [hidden email]
Homepage: http://members.dokom.net/blumenschein
Am Quartus 17
D-44149 Dortmund
Tel.: [phone], Handy: [phone]
public key: 
http://members.dokom.net/blumenscheinJuergen_Blumenschein_(0xC9358EBB)_public_key.asc