#3556 Chart grouping incorrect

3.5.0
works-for-me
nobody
None
5
2013-06-11
2012-04-10
Anonymous
No

If i wannt to show a graph of an given SQL response the grouping seems to be incorrect.

Discussion

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-04-10

    Response Graph SQL 1

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2012-04-10

    If I want to show a graph of a given SQL response the grouping seems to be incorrect.
    Example SQL
    SELECT 2, 'Value1', 'Class1'
    UNION ALL SELECT 2, 'Value2', 'Class1'
    UNION ALL SELECT 2, 'Value3', 'Class1'
    UNION ALL SELECT 2, 'Value4', 'Class1'
    UNION ALL SELECT 3, 'Value2', 'Class2'
    UNION ALL SELECT 3, 'Value3', 'Class2'
    UNION ALL SELECT 3, 'Value4', 'Class2'
    UNION ALL SELECT 4, 'Value1', 'Class3'
    UNION ALL SELECT 4, 'Value2', 'Class3'
    UNION ALL SELECT 4, 'Value3', 'Class3'
    UNION ALL SELECT 4, 'Value4', 'Class3'
    shows 3 lines grouped by values.
    (image 1 “sql1.png” attached)

    If I delete one line (group order) in cLass 2 (first entry)
    “UNION ALL SELECT 3, 'Value1', 'Class2'”
    and resubmit the sql
    SELECT 2, 'Value1', 'Class1'
    UNION ALL SELECT 2, 'Value2', 'Class1'
    UNION ALL SELECT 2, 'Value3', 'Class1'
    UNION ALL SELECT 2, 'Value4', 'Class1'
    UNION ALL SELECT 3, 'Value3', 'Class2'
    UNION ALL SELECT 3, 'Value4', 'Class2'
    UNION ALL SELECT 4, 'Value1', 'Class3'
    UNION ALL SELECT 4, 'Value2', 'Class3'
    UNION ALL SELECT 4, 'Value3', 'Class3'
    UNION ALL SELECT 4, 'Value4', 'Class3'
    The response were misinterpret in the result graph.
    Value 1 of class 2 is missing but the graph illustrates that value 4 of class 2 is missing.
    (i could not atach “sql2.png” because the is no upload available)

     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • status: open --> works-for-me
     
  • Michal Čihař

    Michal Čihař - 2013-06-11

    Can not reproduce with current code and the chart engine has been meanwhile rewritten.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks