Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of bpendleton.derby@gmail.com
 designates 209.85.210.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=iOHz+C5tOi8dvRgeJehgXOk++S7M8l38HOCL/7hvYHl4BK+9DG+Yb5kk9YNAP0auw7
         F3FFbIzAVutDvjmf/ZWRViUnfMhfIMgpmJwr4BGfys8Dl6wq3E4WfrZWmXv965Mzre5J
         czu73oXRVgljh1hHoSNXN9IPdyTOotCcAvp0Y=
Message-ID: <4C694B04.7060700@gmail.com>
Date: Mon, 16 Aug 2010 07:28:20 -0700
From: Bryan Pendleton <bpendleton.derby@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
 rv:1.9.1.11) Gecko/20100713 Thunderbird/3.0.6
MIME-Version: 1.0
To: derby-dev@db.apache.org
Subject: Re: Error using XPLAIN
References: <AANLkTikeEVX_-wz6k4hfjNvdgybtffC+h8OhwA9zEq2=@mail.gmail.com>
In-Reply-To: <AANLkTikeEVX_-wz6k4hfjNvdgybtffC+h8OhwA9zEq2=@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> driver?  If not, the thread names of threads in the networks server are
> too long to fit into the XPLAIN schema
> SYSXPLAIN_STATEMENTS(XPLAIN_THREAD_ID).  Along that same vein, the
> TRANSACTION_ID column looks similarly too small to my eye (CHAR 32).  I
> use Bitronix JTA and from my memory the xid are at least 64 characters.

Thanks Brett! I think this is currently logged as DERBY-4772

https://issues.apache.org/jira/browse/DERBY-4772

It would be helpful if you could attach your findings to that problem in Jira.

Perhaps you want to have a go at fixing it? As Kristian notes, we could either
make the column lengths longer, or we could truncate the values to fit when
capturing query plan data.

thanks,

bryan