[Info-Ingres] Fwd: PARTITION - LIST

#1

Thx John !

---------- Forwarded message ----------
From: Jean-Pierre Zuate, La Fage Conseil <jean-pierre.zuate (AT) lafageconseil (DOT) fr

Quote:

Date: 2009/4/3

Subject: Re: [Info-Ingres] PARTITION - LIST
To: John Dennis <John.Dennis (AT) ingres (DOT) com>

Hi John,
That it ! Thank's a lot.

My doc do not have those extra parenthesis.

Thank again

Regards,
Jean-Pierre

2009/4/3 John Dennis <John.Dennis (AT) ingres (DOT) com>

Jean-Pierre,

Quote:

Are you sure that you pasted this from the SQL manual? The 9.2 SQL
Reference Guide I am looking at has some extra parentheses. Try this:

CREATE TABLE table1 (
i INTEGER NOT NULL WITH DEFAULT,
str VARCHAR(10) NOT NULL WITH DEFAULT
) WITH PARTITION = (LIST ON i,str
PARTITION p1 VALUES ((1,'one'))
WITH LOCATION=(ii_database),
PARTITION p2 VALUES ((2,'two'),(3,'three'))
WITH LOCATION=(loc1, loc2),
PARTITION p3 VALUES (DEFAULT));

Note there is an extra set of parentheses around the (1,'one'). You are
also missing the closing parenthesis after the (DEFAULT),

John

------------------------------
*From:* info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:
info-ingres-bounces (AT) kettleriver...ting (DOT) com] *On Behalf Of *Jean-Pierre
Zuate, La Fage Conseil
*Sent:* Friday, 3 April 2009 11:27 AM
*To:* Ingres and related product discussion forum
*Subject:* [Info-Ingres] PARTITION - LIST

Hi all,

Where I'am wrong when I cust and paste this example from the SQL doc :
CREATE TABLE table1 (
i INTEGER NOT NULL WITH DEFAULT,
str VARCHAR(10) NOT NULL WITH DEFAULT
) WITH PARTITION = (LIST ON i,str
PARTITION p1 VALUES (1,'one')
WITH LOCATION=(ii_database),
PARTITION p2 VALUES ((2,'two'),(3,'three'))
WITH LOCATION=(loc1, loc2),
PARTITION p3 VALUES DEFAULT);

it give me the following error :

[CREATE - 0 row(s), 0.125 secs] [Error Code: 6457, SQL State: 42000]
CREATE TABLE: Wrong number of value components in partitioning constant.
Expected 2 components, saw 1; error near '1'.
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time:
0.125/0.000 sec [0 successful, 0 warnings, 1 errors]

Version is : II 9.2.0 (int.w32/109)

Thx
--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jean-pierre.zuate (AT) lafageconseil (DOT) fr
http://lafageconseil.fr/

--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jean-pierre.zuate (AT) lafageconseil (DOT) fr
http://lafageconseil.fr/

--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jean-pierre.zuate (AT) lafageconseil (DOT) fr
http://lafageconseil.fr/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[Info-Ingres] Fwd: PARTITION - LIST

comp.databases.ingres comp.databases.ingres

[Info-Ingres] Fwd: PARTITION - LIST - 04-02-2009 , 07:57 PM