Project

General

Profile

Actions

Bug #1128

closed

Bugged tuple query

Added by Saif Rehman almost 13 years ago. Updated over 12 years ago.

Status:
Closed
Priority:
High
Assignee:
Target version:
Start date:
01/10/2012
Due date:
% Done:

0%

Estimated time:

Description

Hello,

I found out a bug when we fetch results using a joined query and boost.tuple. Although results from the backend are correct but the Dbo::collection shows weird results. When I iterated though 13 items, the results were not unique and the results were duplicates.

Example:

Expected Result Keys:

DosPuzzle

LogDebugLevel

LogErrorLevel

LogInfoLevel

LogSecureLevel

LogWarnLevel

Actual Result Keys:

LogDebugLevel

DosPuzzle

DosPuzzle

LogDebugLevel

LogDebugLevel

LogDebugLevel

LogDebugLevel

Source Code

The source code is in my forked repository of Wt in github.

https://github.com/SaiFi0102/wt/tree/Saif, the branch is "Saif"

Starting from file https://github.com/SaiFi0102/wt/blob/Saif/src/MM/Main.cpp, line 68

Config = new Configurations;

try
{
       //Config->Uninstall();
       Config->Install();
       Config->FetchAll();
}

Config->Install(): Inserts test data to the database(sqlite3(":memory:"))

Config->FetchAll(): Queries and fetches data using the joined queries and prints the key "Name" of each to std::cerr

Please check this.

Thank you.


Files

DboTest.C (33.2 KB) DboTest.C Saif Rehman, 01/13/2012 07:58 AM
Actions #1

Updated by Saif Rehman almost 13 years ago

Attached test case file in DboTest.C

Actions #2

Updated by Koen Deforche almost 13 years ago

  • Status changed from New to Resolved
  • Assignee set to Koen Deforche
Actions #3

Updated by Koen Deforche over 12 years ago

  • Status changed from Resolved to Closed
  • Target version changed from 3.2.0 to 3.2.1
Actions

Also available in: Atom PDF