[jira] Created: (ESPER-409) Order-by clause not applied when pattern delivers multiple result row for single incoming event

Order-by clause not applied when pattern delivers multiple result row for single incoming event
-----------------------------------------------------------------------------------------------

                 Key: ESPER-409
                 URL: http://jira.codehaus.org/browse/ESPER-409
             Project: Esper
          Issue Type: Bug
          Components: Core
    Affects Versions: 3.2
            Reporter: Thomas Bernhardt
            Priority: Minor


Example statement:
select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc

Sending A1, A2, B1 should deliver strings A2, A1 but delivers strings A1, A2.

test method:
        epService.getEPAdministrator().getConfiguration().addEventType("SupportBean", SupportBean.class);
        SupportUpdateListener listener = new SupportUpdateListener();
        String stmtText = "select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc";
        EPStatement stmtOne = epService.getEPAdministrator().createEPL(stmtText);
        stmtOne.addListener(listener);

        epService.getEPRuntime().sendEvent(new SupportBean("A1", 1));
        epService.getEPRuntime().sendEvent(new SupportBean("A2", 2));
        epService.getEPRuntime().sendEvent(new SupportBean("B", 3));

        EventBean[] received = listener.getNewDataListFlattened();
        assertEquals(2, received.length);
        ArrayAssertionUtil.assertPropsPerRow(received, "a.string".split(","), new Object [][] {{"A2"}, {"A1"}});


--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

     [ http://jira.codehaus.org/browse/ESPER-409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Bernhardt updated ESPER-409:
-----------------------------------

    Summary: Order-by clause not applied when pattern delivers multiple result rows for single incoming event  (was: Order-by clause not applied when pattern delivers multiple result row for single incoming event)

> Order-by clause not applied when pattern delivers multiple result rows for single incoming event
> ------------------------------------------------------------------------------------------------
>
>                 Key: ESPER-409
>                 URL: http://jira.codehaus.org/browse/ESPER-409
>             Project: Esper
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 3.2
>            Reporter: Thomas Bernhardt
>            Priority: Minor
>
> Example statement:
> select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc
> Sending A1, A2, B1 should deliver strings A2, A1 but delivers strings A1, A2.
> test method:
>         epService.getEPAdministrator().getConfiguration().addEventType("SupportBean", SupportBean.class);
>         SupportUpdateListener listener = new SupportUpdateListener();
>         String stmtText = "select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc";
>         EPStatement stmtOne = epService.getEPAdministrator().createEPL(stmtText);
>         stmtOne.addListener(listener);
>         epService.getEPRuntime().sendEvent(new SupportBean("A1", 1));
>         epService.getEPRuntime().sendEvent(new SupportBean("A2", 2));
>         epService.getEPRuntime().sendEvent(new SupportBean("B", 3));
>         EventBean[] received = listener.getNewDataListFlattened();
>         assertEquals(2, received.length);
>         ArrayAssertionUtil.assertPropsPerRow(received, "a.string".split(","), new Object [][] {{"A2"}, {"A1"}});

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

     [ http://jira.codehaus.org/browse/ESPER-409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Bernhardt updated ESPER-409:
-----------------------------------

    Attachment: esper-3.2.0-JIRA409.jar

We have issued a cumulative service pack (esper-3.2.0-JIRA409.jar) release as attached. Please use in front of the Esper jar file and make sure to remove prior issued patch files.
 
The patch is cumulative and also includes fixes to:

ESPER-398  Escape syntax for quote and double quote not working
ESPER-396 Unbound stream and aggregating/grouping by unlimited key (i.e. timestamp) configurable state drop

> Order-by clause not applied when pattern delivers multiple result rows for single incoming event
> ------------------------------------------------------------------------------------------------
>
>                 Key: ESPER-409
>                 URL: http://jira.codehaus.org/browse/ESPER-409
>             Project: Esper
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 3.2
>            Reporter: Thomas Bernhardt
>            Priority: Minor
>         Attachments: esper-3.2.0-JIRA409.jar
>
>
> Example statement:
> select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc
> Sending A1, A2, B1 should deliver strings A2, A1 but delivers strings A1, A2.
> test method:
>         epService.getEPAdministrator().getConfiguration().addEventType("SupportBean", SupportBean.class);
>         SupportUpdateListener listener = new SupportUpdateListener();
>         String stmtText = "select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc";
>         EPStatement stmtOne = epService.getEPAdministrator().createEPL(stmtText);
>         stmtOne.addListener(listener);
>         epService.getEPRuntime().sendEvent(new SupportBean("A1", 1));
>         epService.getEPRuntime().sendEvent(new SupportBean("A2", 2));
>         epService.getEPRuntime().sendEvent(new SupportBean("B", 3));
>         EventBean[] received = listener.getNewDataListFlattened();
>         assertEquals(2, received.length);
>         ArrayAssertionUtil.assertPropsPerRow(received, "a.string".split(","), new Object [][] {{"A2"}, {"A1"}});

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://jira.codehaus.org/browse/ESPER-409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=195829#action_195829 ]

Thomas Bernhardt edited comment on ESPER-409 at 10/24/09 10:40 AM:
-------------------------------------------------------------------

We have issued a cumulative service pack (esper-3.2.0-JIRA409.jar) release as attached. Please use in front of the Esper jar file and make sure to remove prior issued patch files.
 
The patch is cumulative and also includes fixes to:

ESPER-398  Escape syntax for quote and double quote not working
ESPER-396 Unbound stream and aggregating/grouping by unlimited key (i.e. timestamp) configurable state drop

Make sure to review the JIRA issues above for compatibility questions.


      was (Author: bernhardttom):
    We have issued a cumulative service pack (esper-3.2.0-JIRA409.jar) release as attached. Please use in front of the Esper jar file and make sure to remove prior issued patch files.
 
The patch is cumulative and also includes fixes to:

ESPER-398  Escape syntax for quote and double quote not working
ESPER-396 Unbound stream and aggregating/grouping by unlimited key (i.e. timestamp) configurable state drop


 

> Order-by clause not applied when pattern delivers multiple result rows for single incoming event
> ------------------------------------------------------------------------------------------------
>
>                 Key: ESPER-409
>                 URL: http://jira.codehaus.org/browse/ESPER-409
>             Project: Esper
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 3.2
>            Reporter: Thomas Bernhardt
>            Priority: Minor
>         Attachments: esper-3.2.0-JIRA409.jar
>
>
> Example statement:
> select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc
> Sending A1, A2, B1 should deliver strings A2, A1 but delivers strings A1, A2.
> test method:
>         epService.getEPAdministrator().getConfiguration().addEventType("SupportBean", SupportBean.class);
>         SupportUpdateListener listener = new SupportUpdateListener();
>         String stmtText = "select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc";
>         EPStatement stmtOne = epService.getEPAdministrator().createEPL(stmtText);
>         stmtOne.addListener(listener);
>         epService.getEPRuntime().sendEvent(new SupportBean("A1", 1));
>         epService.getEPRuntime().sendEvent(new SupportBean("A2", 2));
>         epService.getEPRuntime().sendEvent(new SupportBean("B", 3));
>         EventBean[] received = listener.getNewDataListFlattened();
>         assertEquals(2, received.length);
>         ArrayAssertionUtil.assertPropsPerRow(received, "a.string".split(","), new Object [][] {{"A2"}, {"A1"}});

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

    [ http://jira.codehaus.org/browse/ESPER-409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=195829#action_195829 ]

Thomas Bernhardt edited comment on ESPER-409 at 10/24/09 10:40 AM:
-------------------------------------------------------------------

We have issued a cumulative service pack (esper-3.2.0-JIRA409.jar) release as attached. Please use in front of the Esper jar file and make sure to remove prior issued patch files.
 
The patch is cumulative and also includes fixes to:

ESPER-398  Escape syntax for quote and double quote not working
ESPER-396 Unbound stream and aggregating/grouping by unlimited key (i.e. timestamp) configurable state drop

Make sure to review the JIRA issues above.


      was (Author: bernhardttom):
    We have issued a cumulative service pack (esper-3.2.0-JIRA409.jar) release as attached. Please use in front of the Esper jar file and make sure to remove prior issued patch files.
 
The patch is cumulative and also includes fixes to:

ESPER-398  Escape syntax for quote and double quote not working
ESPER-396 Unbound stream and aggregating/grouping by unlimited key (i.e. timestamp) configurable state drop

Make sure to review the JIRA issues above for compatibility questions.

 

> Order-by clause not applied when pattern delivers multiple result rows for single incoming event
> ------------------------------------------------------------------------------------------------
>
>                 Key: ESPER-409
>                 URL: http://jira.codehaus.org/browse/ESPER-409
>             Project: Esper
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 3.2
>            Reporter: Thomas Bernhardt
>            Priority: Minor
>         Attachments: esper-3.2.0-JIRA409.jar
>
>
> Example statement:
> select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc
> Sending A1, A2, B1 should deliver strings A2, A1 but delivers strings A1, A2.
> test method:
>         epService.getEPAdministrator().getConfiguration().addEventType("SupportBean", SupportBean.class);
>         SupportUpdateListener listener = new SupportUpdateListener();
>         String stmtText = "select a.string from pattern [every a=SupportBean(string like 'A%') -> b=SupportBean(string like 'B%')] order by a.string desc";
>         EPStatement stmtOne = epService.getEPAdministrator().createEPL(stmtText);
>         stmtOne.addListener(listener);
>         epService.getEPRuntime().sendEvent(new SupportBean("A1", 1));
>         epService.getEPRuntime().sendEvent(new SupportBean("A2", 2));
>         epService.getEPRuntime().sendEvent(new SupportBean("B", 3));
>         EventBean[] received = listener.getNewDataListFlattened();
>         assertEquals(2, received.length);
>         ArrayAssertionUtil.assertPropsPerRow(received, "a.string".split(","), new Object [][] {{"A2"}, {"A1"}});

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email