[MonetDB-users] "ERROR = !Connection terminated" for some SQL queries

24 Feb 2012

      Hi,

the following query results in a "Connection terminated error":

    SELECT 
      count(*)
    FROM
      (
        SELECT DISTINCT
          node1.id AS id1, node2.id AS id2, node1.toplevel_corpus
        FROM
          node AS node1, rank AS rank1, component AS component1,
          node AS node2, rank AS rank2, component AS component2
        WHERE
          component1.id = component2.id AND
          component1.name IS NULL AND
          component1.type = 'd' AND
          component2.name IS NULL AND
          component2.type = 'd' AND
          rank1.component_ref = component1.id AND
          rank1.node_ref = node1.id AND
          rank1.pre = rank2.parent AND
          rank2.component_ref = component2.id AND
          rank2.node_ref = node2.id
      ) AS solutions;

The full error message is:

    MAPI  = annis@moos.local:50000
    ACTION= read_line
    QUERY = SELECT 
              count(*)
            FROM
              (
                SELECT DISTINCT
                  node1.id AS id1, node2.id AS id2, node1.toplevel_corpus
                FROM
                  node AS node1, rank AS rank1, component AS component1,
                  node AS node2, rank AS rank2, component AS component2
                WHERE
                  component1.id = component2.id AND
                  component1.name IS NULL AND
                  component1.type = 'd' AND
                  component2.name IS NULL AND
                  component2.type = 'd' AND
                  rank1.component_ref = component1.id AND
                  rank1.node_ref = node1.id AND
                  rank1.pre = rank2.parent AND
                  rank2.component_ref = component2.id AND
                  rank2.node_ref = node2.id
              ) AS solutions;
    ERROR = !Connection terminated

I can get it to run if I remove the following line:

                  component1.id = component2.id AND

or if I remove the following 4 lines:

                  component1.name IS NULL AND
                  component1.type = 'd' AND
                  component2.name IS NULL AND
                  component2.type = 'd' AND

However, if I include all constraints on component, the error appears.

Let me know, if you need more information.

Cheers,
Viktor

[MonetDB-users] "ERROR = !Connection terminated" for some SQL queries

Viktor Rosenfeld