Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 85431 invoked from network); 11 Sep 2009 09:33:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 11 Sep 2009 09:33:51 -0000 Received: (qmail 73418 invoked by uid 500); 11 Sep 2009 09:33:51 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 73330 invoked by uid 500); 11 Sep 2009 09:33:49 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 73322 invoked by uid 99); 11 Sep 2009 09:33:49 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Sep 2009 09:33:49 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of george.dma@gmail.com designates 209.85.218.218 as permitted sender) Received: from [209.85.218.218] (HELO mail-bw0-f218.google.com) (209.85.218.218) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Sep 2009 09:33:41 +0000 Received: by bwz18 with SMTP id 18so732964bwz.7 for ; Fri, 11 Sep 2009 02:33:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:from:date:message-id :subject:to:content-type; bh=xrHJx0mky7sCgtlk0UT3FzL3m/ZCEUIcu8X/MJRMcoE=; b=f3W727SJ/9pOFSoy0mKDs3p8NL00yep5I4smQkj2KbrBJIN8hydr+A/Va4bs91acej pXlbP6Vwo6E7onCQ6YPF88lz90jjYtcCqLqeYLR78vfGG8UOfDFiBmZgkmcUjmRyLBhb 3z2xMVj17inY3QW2pCH8sp8N8dtn00gUaNnpA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; b=pJi5rt7r1WULGNAKDUsQEeWwwXXU3hiYXoApb9etD7MRzFxP5J6dqA8LakCegxNi7p Yzqo2PEFmGe4wFwJovyqw6S54IhLE+BqQCItxZf79jAazUCfH/e7FCQCcmRXiSw9w0i1 V4oT4zFrQZTP9cl4Prm4aKGN1huFkBQNCKxpI= MIME-Version: 1.0 Received: by 10.102.222.8 with SMTP id u8mr1313250mug.96.1252661600102; Fri, 11 Sep 2009 02:33:20 -0700 (PDT) From: George H Date: Fri, 11 Sep 2009 12:33:00 +0300 Message-ID: Subject: Inserts are out of order To: Derby Discussion Content-Type: multipart/alternative; boundary=0016364c7283b2aade04734a01c7 X-Virus-Checked: Checked by ClamAV on apache.org --0016364c7283b2aade04734a01c7 Content-Type: text/plain; charset=ISO-8859-1 Hi, I have a strange problem and I am not sure if this is a problem with Insert or select or maybe I am missing something here. Apache Derby EmbeddedDriver 10.5.3.0 - (802917) I have 3 tables and as I insert IDs into 1 table and do a select on it, I see the values in the same order I inserted them in. I do this for 2 tables. My third table is my relationship table which whose primary keys are the keys of both tables together. When I insert rows, I do not see them in the same order I inserted them in. Below I provide SQL statements that show this problem. I hope someone can guide me as to what is the problem and how to solve it. Many thanks in advance. CREATE TABLE POS.TEST_SECTIONS ( SECTION_ID CHAR(36) NOT NULL, SECTION_NAME VARCHAR(255) NOT NULL, PRIMARY KEY(SECTION_ID) ); CREATE TABLE POS.TEST_ITEMS ( ITEM_ID CHAR(36) NOT NULL, ITEM_NAME VARCHAR(255) NOT NULL, PRIMARY KEY(ITEM_ID) ); CREATE TABLE POS.SECTIONS_REL_ITEMS ( SECTION_ID CHAR(36) NOT NULL, ITEM_ID CHAR(36) NOT NULL, FOREIGN KEY(SECTION_ID) REFERENCES POS.TEST_SECTIONS(SECTION_ID), FOREIGN KEY(ITEM_ID) REFERENCES POS.TEST_ITEMS(ITEM_ID), PRIMARY KEY(SECTION_ID,ITEM_ID) ); INSERT INTO POS.TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('b6c0bdf8-68c8-4882-9723-878574fefb52','Section 1'); INSERT INTO POS.TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('4e956141-77ef-48d3-adc8-ae617f4352fb','Section 2'); INSERT INTO POS.TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('2100a63e-078c-41b0-9683-1e6ad88104c9','Section 3'); INSERT INTO POS.TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('76dfcf3b-7705-4933-84b6-bfee0f0f98d2','Section 4'); INSERT INTO POS.TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('90b94bce-4223-4f91-a917-7363672b5efd','Section 5'); INSERT INTO POS.TEST_ITEMS(ITEM_ID, ITEM_NAME) VALUES('0784c479-7cd6-4cef-a446-f7a3724321c4','Item 1'); INSERT INTO POS.TEST_ITEMS(ITEM_ID, ITEM_NAME) VALUES('04bc6246-02d3-43b8-81cd-399f52bc58d8','Item 2'); INSERT INTO POS.TEST_ITEMS(ITEM_ID, ITEM_NAME) VALUES('f481ba35-7f49-407a-aaed-fc6213ae1b90','Item 3'); INSERT INTO POS.TEST_ITEMS(ITEM_ID, ITEM_NAME) VALUES('9ee99832-c23a-41e6-bb85-e7f98035717c','Item 4'); INSERT INTO POS.TEST_ITEMS(ITEM_ID, ITEM_NAME) VALUES('4e233de6-4044-4f73-9450-29833549700f','Item 5'); INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES('b6c0bdf8-68c8-4882-9723-878574fefb52','0784c479-7cd6-4cef-a446-f7a3724321c4'); INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES('b6c0bdf8-68c8-4882-9723-878574fefb52','04bc6246-02d3-43b8-81cd-399f52bc58d8'); INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES('b6c0bdf8-68c8-4882-9723-878574fefb52','f481ba35-7f49-407a-aaed-fc6213ae1b90'); INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES('b6c0bdf8-68c8-4882-9723-878574fefb52','9ee99832-c23a-41e6-bb85-e7f98035717c'); INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES('b6c0bdf8-68c8-4882-9723-878574fefb52','4e233de6-4044-4f73-9450-29833549700f'); select * from POS.SECTIONS_REL_ITEMS; Result SECTION_ID ITEM_ID b6c0bdf8-68c8-4882-9723-878574fefb52 04bc6246-02d3-43b8-81cd-399f52bc58d8 b6c0bdf8-68c8-4882-9723-878574fefb52 0784c479-7cd6-4cef-a446-f7a3724321c4 b6c0bdf8-68c8-4882-9723-878574fefb52 4e233de6-4044-4f73-9450-29833549700f b6c0bdf8-68c8-4882-9723-878574fefb52 9ee99832-c23a-41e6-bb85-e7f98035717c b6c0bdf8-68c8-4882-9723-878574fefb52 f481ba35-7f49-407a-aaed-fc6213ae1b90 The Item IDs are out of order than how I inserted them in. -- George george.dma@gmail.com --0016364c7283b2aade04734a01c7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi, I have a strange problem and I am not sure if this is = a problem with Insert or select or maybe I am missing something here.
Apache Derby EmbeddedDriver
10.5.3.0 - (802917)

I have 3 tables= and as I insert IDs into 1 table and do a select on it, I see the values i= n the same order I inserted them in.
I do this for 2 tables. My third table is my relationship table which whose= primary keys are the keys of both tables together.

When I insert ro= ws, I do not see them in the same order I inserted them in. Below I provide= SQL statements that show this problem. I hope someone can guide me as to w= hat is the problem and how to solve it. Many thanks in advance.

CREATE TABLE POS.TEST_SECTIONS
(
=A0=A0=A0 SECTION_ID CHAR(36) NO= T NULL,
=A0=A0=A0 SECTION_NAME VARCHAR(255) NOT NULL,
=A0=A0=A0 PRIMA= RY KEY(SECTION_ID)=A0=A0=A0
);

CREATE TABLE POS.TEST_ITEMS
(<= br>=A0=A0=A0 ITEM_ID CHAR(36) NOT NULL,
=A0=A0=A0 ITEM_NAME VARCHAR(255) NOT NULL,
=A0=A0=A0 PRIMARY KEY(ITEM_ID= )
);

CREATE TABLE POS.SECTIONS_REL_ITEMS
(
=A0=A0=A0 SECTIO= N_ID CHAR(36) NOT NULL,
=A0=A0=A0 ITEM_ID CHAR(36) NOT NULL,=A0=A0=A0 =A0=A0=A0 FOREIGN KEY(SECTION_ID) REFERENCES POS.TEST_SECTIONS(SECTION_ID= ),=A0=A0=A0
=A0=A0=A0 FOREIGN KEY(ITEM_ID) REFERENCES POS.TEST_ITEMS(ITEM_ID),
=A0= =A0=A0 PRIMARY KEY(SECTION_ID,ITEM_ID)
);

INSERT INTO POS.TEST_SE= CTIONS(SECTION_ID, SECTION_NAME) VALUES('b6c0bdf8-68c8-4882-9723-878574= fefb52','Section 1');
INSERT INTO POS.TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('4e95614= 1-77ef-48d3-adc8-ae617f4352fb','Section 2');
INSERT INTO POS= .TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('2100a63e-078c-41b0-968= 3-1e6ad88104c9','Section 3');
INSERT INTO POS.TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('76dfcf3= b-7705-4933-84b6-bfee0f0f98d2','Section 4');
INSERT INTO POS= .TEST_SECTIONS(SECTION_ID, SECTION_NAME) VALUES('90b94bce-4223-4f91-a91= 7-7363672b5efd','Section 5');

INSERT INTO POS.TEST_ITEMS(ITEM_ID, ITEM_NAME) VALUES('0784c479-7cd= 6-4cef-a446-f7a3724321c4','Item 1');
INSERT INTO POS.TEST_IT= EMS(ITEM_ID, ITEM_NAME) VALUES('04bc6246-02d3-43b8-81cd-399f52bc58d8= 9;,'Item 2');
INSERT INTO POS.TEST_ITEMS(ITEM_ID, ITEM_NAME) VALUES('f481ba35-7f49-40= 7a-aaed-fc6213ae1b90','Item 3');
INSERT INTO POS.TEST_ITEMS(= ITEM_ID, ITEM_NAME) VALUES('9ee99832-c23a-41e6-bb85-e7f98035717c',&= #39;Item 4');
INSERT INTO POS.TEST_ITEMS(ITEM_ID, ITEM_NAME) VALUES('4e233de6-4044-4f= 73-9450-29833549700f','Item 5');

INSERT INTO POS.SECTION= S_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES('b6c0bdf8-68c8-4882-9723-878574f= efb52','0784c479-7cd6-4cef-a446-f7a3724321c4');
INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES('b6c0bdf8= -68c8-4882-9723-878574fefb52','04bc6246-02d3-43b8-81cd-399f52bc58d8= ');
INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES(&#= 39;b6c0bdf8-68c8-4882-9723-878574fefb52','f481ba35-7f49-407a-aaed-f= c6213ae1b90');
INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES('b6c0bdf8= -68c8-4882-9723-878574fefb52','9ee99832-c23a-41e6-bb85-e7f98035717c= ');
INSERT INTO POS.SECTIONS_REL_ITEMS(SECTION_ID,ITEM_ID) VALUES(&#= 39;b6c0bdf8-68c8-4882-9723-878574fefb52','4e233de6-4044-4f73-9450-2= 9833549700f');

select * from POS.SECTIONS_REL_ITEMS;

Result
SECTION_ID=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ITEM_ID
b6c0bdf8-68c8-4882= -9723-878574fefb52=A0=A0=A0 04bc6246-02d3-43b8-81cd-399f52bc58d8
b6c0bdf= 8-68c8-4882-9723-878574fefb52=A0=A0=A0 0784c479-7cd6-4cef-a446-f7a3724321c4=
b6c0bdf8-68c8-4882-9723-878574fefb52=A0=A0=A0 4e233de6-4044-4f73-9450-29833= 549700f
b6c0bdf8-68c8-4882-9723-878574fefb52=A0=A0=A0 9ee99832-c23a-41e6= -bb85-e7f98035717c
b6c0bdf8-68c8-4882-9723-878574fefb52=A0=A0=A0 f481ba3= 5-7f49-407a-aaed-fc6213ae1b90

The Item IDs are out of order than how I inserted them in.
--
George
george.dma@gma= il.com
--0016364c7283b2aade04734a01c7--