Project

General

Profile

Actions
Copy link

Bug #2091

closed

Dbo query SELECT SUM(...) bug

Added by Saif Rehman over 11 years ago. Updated about 11 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Michael Vilsker
Target version:
3.3.1
Start date:
08/07/2013
Due date:
% Done:

0%

Estimated time:

Description

Hi,

I found a bug with Wt Dbo that when a query selects a SUM (col) it sets weird values in boost::tuple<...> which is the result type of the query. I have only tried this with SUM and no other SQL functions.

The test case file is attached. The first query fetches normal data and the second query fetches weird data into the tuple.

Files

Download all files
DboTestSaif.C (4.41 KB) DboTestSaif.C Saif Rehman, 08/07/2013 04:06 AM
DboTestSaif.C (4.42 KB) DboTestSaif.C Saif Rehman, 08/26/2013 12:36 PM
Actions
Copy link
 #1

Updated by Saif Rehman over 11 years ago

Fixed a mistake in test file.

Another thing is that the problem does not occur in SQLite but in MySQL

Please modify my test case to connect to MySQL

Actions
Copy link
 #2

Updated by Koen Deforche over 11 years ago

  • Status changed from New to InProgress
  • Assignee set to Koen Deforche
  • Target version set to 3.3.1
Actions
Copy link
 #3

Updated by Koen Deforche over 11 years ago

  • Assignee changed from Koen Deforche to Michael Vilsker

Michael:

Can you see what's going on, is this a problem in the MySQL backend?

Perhaps it has to do with the '*' appearing as a multiplication?

Saif:

What version of Boost are you using (we use a different query handling strategy for older vs newer versions of boost, which may be relevant).

Actions
Copy link
 #4

Updated by Michael Vilsker over 11 years ago

  • Status changed from InProgress to Resolved
Actions
Copy link
 #5

Updated by Koen Deforche about 11 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF