On Tue, Jan 29, 2008 at 12:18:51PM -0800, sateesh wrote:
The Syntax only works in the default schema.
If i try to alter a table in a user created schema then it's throwing the same Error "Table Doesn't exists" !!!
Here is my Test Case..
[CODE]
create table tmp.collection_info( test_col varchar(100));
ALTER TABLE "tmp"."COLLECTION_INFO" ADD COLUMN test_col1 varchar(256);
ALTER TABLE tmp.COLLECTION_INFO ADD COLUMN test_col2 varchar(256);
ALTER TABLE "tmp"."collection_info" ADD COLUMN test_col3 varchar(256);
ALTER TABLE tmp.collection_info ADD COLUMN test_col4 varchar(256);
[/CODE]
Indeed you found a bug. The schema name wasn't used correctly. Fix is available in cvs head as we have plans for a release real soon. Added your example as an test case. The first of these alters (correctly) fails as double quoted identifiers are case sensetive. Niels
Regards Sateesh -- View this message in context: http://www.nabble.com/ALTER-TABLE-doesn%27t-work-in-MonetDB-%21%21-tp1516802... Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl