Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-59140

Stack overflow during query compilation

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown
    • Analytics Sprint 31, Analytics Sprint 32

    Description

      The following query causes Stack overflow error

       

      drop dataverse test if exists;
      create dataverse test;
      use test;
       
       
      create dataset collection0 primary key (id:int);
      create dataset collection1 primary key (id:int);
      create dataset collection2 primary key (id:int);
       
       
      SELECT DISTINCT T1.*,
              (SELECT H.u
                         FROM collection1 H
                        WHERE H.y_id = T1.x_id
                          AND H.a IN [12, 66, 67, 13, 26]
                          AND H.to_u = 'aaaaa'
                          AND H.b in
                              (SELECT value MAX(L.b)
                                 FROM collection1 L
                                WHERE L.y_id = T1.x_id
                                  AND L.a IN [12, 66, 67, 13, 26]
                                  AND L.to_u = 'aaaaa')
                                  ) AS sub_query1,
              (SELECT H.u
                         FROM collection1 H
                        WHERE  H.y_id = T1.x_id
                          AND H.a IN [12, 66, 67, 13]
                          AND H.posi IN ['a','b']
                          AND H.b in
                              (SELECT value MAX(L.b)
                                 FROM collection1 L
                                WHERE L.y_id = T1.x_id
                                  AND L.posi IN ['a','b'])
                                        ) AS sub_query2
      FROM (SELECT T0.x_id
              FROM collection0 T0
      ) T1;

       

       

       

      11:27:12.757 [HttpExecutor(port:19001)-0] WARN  org.apache.hyracks.http.server.AbstractServlet - Unhandled throwable
      java.lang.StackOverflowError: null
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarTypeFullList(PropagatingTypeEnvironment.java:108) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarTypeFullList(PropagatingTypeEnvironment.java:108) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarTypeFullList(PropagatingTypeEnvironment.java:108) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarTypeFullList(PropagatingTypeEnvironment.java:108) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?]
          at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?] 

       

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            umang.agrawal Umang
            peeyush.gupta Peeyush Gupta
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty