Project

General

Profile

Actions

Bug #2091

closed

Dbo query SELECT SUM(...) bug

Added by Saif Rehman over 10 years ago. Updated over 10 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Michael Vilsker
Target version:
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

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 #1

Updated by Saif Rehman over 10 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 #2

Updated by Koen Deforche over 10 years ago

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

Updated by Koen Deforche over 10 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 #4

Updated by Michael Vilsker over 10 years ago

  • Status changed from InProgress to Resolved
Actions #5

Updated by Koen Deforche over 10 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF