Bugs item #1715553, was opened at 2007-05-09 11:11
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1715553&group_id=56967

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: Set default value.....

Initial Comment:
With this example:

create table t1(id int, name varchar(1024), age int );

alter table t1 alter id set DEFAULT RANK() OVER (PARTITION BY id, age ORDER BY 
id DESC);

I get:

[EMAIL PROTECTED] ~]$ mclient < example.sql
MAPI  = [EMAIL PROTECTED]:50000
QUERY = alter table t1 alter id set DEFAULT RANK() OVER (PARTITION BY id, age 
ORDER BY id DESC);
ERROR = !unknown table element (18034648)->token = DEFAULT
[ 1     ]

>From yesterday I learn that this kind of messages are not accepted.

Regards,
Romulo

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1715553&group_id=56967

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to