QSqlQuery different value() type

Xardas · wrote on 31 Mar 2016, 13:36

Checked again, on 5_5_1 has no problem.
first table: QVariant(uint, 1);
second table: QVariant(uint, 1);

any ideas, what is the problem?

SGaist · wrote on 31 Mar 2016, 18:51

One unrelated note, you're not using QSqlDatabase correctly. There's no need to use new on it.

What OS and MySQL version are you using ?

Xardas · wrote on 1 Apr 2016, 08:09

OS: Windows 10
Mysql: 5.7.11

SGaist · 2 Apr 2016, 08:42

Did you only change Qt version or also MySQL ?

Did you rebuild the MySQL plugin ?

Xardas · S SGaist 1 Apr 2016, 20:21

Did you only change Qt version or also MySQL ?

only Qt version

Did you rebuild the MySQL plugin ?

Yes

SGaist · wrote on 2 Apr 2016, 21:38

What size are both tables ?

Xardas · wrote on 3 Apr 2016, 08:55

first: 16KiB
second: 16KiB

SGaist · wrote on 3 Apr 2016, 14:04

I meant number of rows of each tables.

Xardas · wrote on 3 Apr 2016, 14:10

first table 129
second 3

SGaist · wrote on 3 Apr 2016, 17:36

The plugin hasn't changed anything related to that between 5.5 and 5.6 so I wonder if it's a change in QVariant.

By the way, why do you need that information ? You should be able to just convert to int without any problem.