query prepare with sql math

[GuL]

Here is something really strange:
if I change:

query.prepare("SELECT :a / :b");

query.prepare("SELECT :a / :b");

To copy to clipboard, switch view to plain text mode 

to

query.prepare("SELECT (:a / :b)*1");

query.prepare("SELECT (:a / :b)*1");

To copy to clipboard, switch view to plain text mode 

I get the result.
Maybe a QT bug?

Renan

[jacek]

Indeed it behaves strange. Could you prepare a minimal compilable example?

[GuL]

I have uploaded a simple compilable example, as jacek asked.

Renan

I have uploaded it again.

[spirit]

I can't download testemysql2.cpp

[GuL]

I have uploaded it again.

Renan

[spirit]

looks like bug in Qt.
this code works, you can use it

...
query.prepare(QString("select %1/%2").arg(ui.lineEdit->text()).arg(ui.lineEdit_2->text()));
...

...
query.prepare(QString("select %1/%2").arg(ui.lineEdit->text()).arg(ui.lineEdit_2->text()));
...

To copy to clipboard, switch view to plain text mode 

[GuL]

Thanks again spirit.

I will wait one or two days to report these to trolltech. Maybe someone knows why this is happening.

I'm using QT 4.3.4 open source Linux Ubuntu 8.04. I don't if this happens with QT 4.4.1.

Renan

[spirit]

I've tested on Qt 4.4.1, the result is the same.

[jacek]

I've minimized it a bit further (see attachment) and it appears that for Qt 4.4.1 on Linux I get the "No results." message, which means that the database doesn't return any data. Of course it works for * operator.

I've also found a workaround:

query.addBindValue( 4.0 );
query.addBindValue( 2.0 );

query.addBindValue( 4.0 );
query.addBindValue( 2.0 );

To copy to clipboard, switch view to plain text mode