Bugs item #1685357, was opened at 2007-03-21 17:45 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=1685357&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: Documentation Group: Website Status: Open Resolution: None Priority: 5 Private: No Submitted By: Tobias Scholl (schollt) Assigned to: Sjoerd Mullender (sjoerd) Summary: Limitations of Decimal(P,S), Numeric(P,S) Initial Comment: If you specify a DECIMAL(P,S) or a NUMERIC(P,S) column in MonetDB, the following must hold (if understood correctly in MonetDB-SQL/sql/src/server/sql_parser.mx): * 0 < P(recision) + S(cale) <= 18 * P > S Therefore you get an error message when you try to create a table like the following: monetdb-> create table tab1 ( col1 decimal(20,0) not null ); Error: decimal(0,20) isn't supported in: "create table tab1 ( col1 decimal(20,0)" syntax error, unexpected NOT in: "not" Adding the limitation in the SQL reference on the data types (http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Data-Types.html) would help users to specify datatypes correctly. While giving the query context in the error message is very useful changing "decimal(20,0)" into "decimal(0,20)" is not. Users have no clue why the order of P and S has changed. The following versions Error: decimal(20,0) isn't supported in: "create table tab1 ( col1 decimal(20,0) not null );" See SQL-Reference for supported data types. or Error: decimal(20,0) isn't supported in: "create table tab1 ( col1 decimal(20,0) not null );" because P=20 + S=0 > 18. can be created from the context information during parsing and would give users hints how to proceed. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1685357&group_id=56967 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
