December 2015 - developers-list

MonetDB: reserved SQL keywords
by martin van dinther 14 Dec '15

14 Dec '15

Hi Hannes, FYI, we have a system table sys.keywords with all the reserved SQL keywords. The intention of this table is to have one place (in the server) with all the reserved SQL keywords, such that API implementations (ODBC, JDBC, PHP, Ruby, Python, R, etc) can query that table and construct the list or string. In the default branch I have implemented this already for jdbc/MonetDatabaseMetaData.java method getSQLKeywords(). This should reduce future maintenance of all the places where these reserved SQL keywords are hardcoded. The new keywords can simply be added/ in one place, the keywords table. It is filled in sql/scripts/51_sys_schema_extension.sql Regards, Martin van Dinther On 24-11-15 09:42, Hannes Muehleisen wrote: > Changeset: c0fb9a0d91e3 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c0fb9a0d91e3 > Modified Files: > clients/R/MonetDB.R/R/dbi.R > Branch: embedded > Log Message: > > R Connector: More naughty words > > > diffs (65 lines): > > diff --git a/clients/R/MonetDB.R/R/dbi.R b/clients/R/MonetDB.R/R/dbi.R > --- a/clients/R/MonetDB.R/R/dbi.R > +++ b/clients/R/MonetDB.R/R/dbi.R > @@ -391,24 +391,43 @@ setMethod("dbSendQuery", signature(conn= > invisible(new("MonetDBEmbeddedResult", env=env)) > }) > > - > -reserved_monetdb_keywords <- c(.SQL92Keywords, > -"ADMIN", "AFTER", "AGGREGATE", "ALWAYS", "ASYMMETRIC", "ATOMIC", > -"AUTO_INCREMENT", "BEFORE", "BEST", "BIGINT", "BIGSERIAL", "BINARY", > -"BLOB", "CALL", "CHAIN", "CLOB", "COMMITTED", "COPY", "CROSS", > -"CURRENT_ROLE", "CURRENT_TIME", "CURRENT_USER", "DELIMITERS", > -"DO", "EACH", "EFFORT", "ELSEIF", "ENCRYPTED", "EXCLUDE", "FOLLOWING", > -"FUNCTION", "GENERATED", "HUGEINT", "IF", "ILIKE", "LIMIT", "LOCALTIME", > -"LOCALTIMESTAMP", "LOCKED", "MERGE", "NATURAL", "NEW", "NOCYCLE", > -"NOMAXVALUE", "NOMINVALUE", "OFFSET", "OLD", "ON", "OTHERS", > -"OVER", "PARTITION", "PRECEDING", "RANGE", "RECORDS", "REFERENCING", > -"REMOTE", "RENAME", "REPEATABLE", "REPLICA", "RESTART", "RETURN", > -"RETURNS", "SAMPLE", "SAVEPOINT", "SEQUENCE", "SERIAL", "SERIALIZABLE", > -"SESSION_USER", "SIMPLE", "SPLIT_PART", "STDIN", "STDOUT", "STREAM", > -"SYMMETRIC", "TIES", "TINYINT", "TRIGGER", "UNBOUNDED", "UNCOMMITTED", > -"UNENCRYPTED", "WHILE", "XMLAGG", "XMLATTRIBUTES", "XMLCOMMENT", > -"XMLCONCAT", "XMLDOCUMENT", "XMLELEMENT", "XMLFOREST", "XMLNAMESPACES", > -"XMLPARSE", "XMLPI", "XMLQUERY", "XMLSCHEMA", "XMLTEXT", "XMLVALIDATE") > +# found from sql_scan.c and trial/error > +reserved_monetdb_keywords <- sort(unique(toupper(c(.SQL92Keywords, > +"ADD", "ADMIN", "AFTER", "AGGREGATE", "ALL", "ALTER", "ALWAYS", > +"AND", "ANY", "ASC", "ASYMMETRIC", "ATOMIC", "AUTO_INCREMENT", > +"BEFORE", "BEGIN", "BEST", "BETWEEN", "BIGINT", "BIGSERIAL", > +"BINARY", "BLOB", "BY", "CALL", "CASCADE", "CASE", "CAST", "CHAIN", > +"CHAR", "CHARACTER", "CHECK", "CLOB", "COALESCE", "COMMIT", "COMMITTED", > +"CONSTRAINT", "CONVERT", "COPY", "CORRESPONDING", "CREATE", "CROSS", > +"CURRENT", "CURRENT_DATE", "CURRENT_ROLE", "CURRENT_TIME", "CURRENT_TIMESTAMP", > +"CURRENT_USER", "DAY", "DEC", "DECIMAL", "DECLARE", "DEFAULT", > +"DELETE", "DELIMITERS", "DESC", "DO", "DOUBLE", "DROP", "EACH", > +"EFFORT", "ELSE", "ELSEIF", "ENCRYPTED", "END", "ESCAPE", "EVERY", > +"EXCEPT", "EXCLUDE", "EXISTS", "EXTERNAL", "EXTRACT", "FALSE", > +"FLOAT", "FOLLOWING", "FOR", "FOREIGN", "FROM", "FULL", "FUNCTION", > +"GENERATED", "GLOBAL", "GRANT", "GROUP", "HAVING", "HOUR", "HUGEINT", > +"IDENTITY", "IF", "ILIKE", "IN", "INDEX", "INNER", "INSERT", > +"INT", "INTEGER", "INTERSECT", "INTO", "IS", "ISOLATION", "JOIN", > +"LEFT", "LIKE", "LIMIT", "LOCAL", "LOCALTIME", "LOCALTIMESTAMP", > +"LOCKED", "MEDIUMINT", "MERGE", "MINUTE", "MONTH", "NATURAL", > +"NEW", "NEXT", "NOCYCLE", "NOMAXVALUE", "NOMINVALUE", "NOT", > +"NOW", "NULL", "NULLIF", "NUMERIC", "OF", "OFFSET", "OLD", "ON", > +"ONLY", "OPTION", "OR", "ORDER", "OTHERS", "OUTER", "OVER", "PARTIAL", > +"PARTITION", "POSITION", "PRECEDING", "PRESERVE", "PRIMARY", > +"PRIVILEGES", "PROCEDURE", "PUBLIC", "RANGE", "READ", "REAL", > +"RECORDS", "REFERENCES", "REFERENCING", "REMOTE", "RENAME", "REPEATABLE", > +"REPLICA", "RESTART", "RESTRICT", "RETURN", "RETURNS", "REVOKE", > +"RIGHT", "ROLLBACK", "ROWS", "SAMPLE", "SAVEPOINT", "SECOND", > +"SELECT", "SEQUENCE", "SERIAL", "SERIALIZABLE", "SESSION_USER", > +"SET", "SIMPLE", "SMALLINT", "SOME", "SPLIT_PART", "STDIN", "STDOUT", > +"STORAGE", "STREAM", "STRING", "SUBSTRING", "SYMMETRIC", "THEN", > +"TIES", "TINYINT", "TO", "TRANSACTION", "TRIGGER", "TRUE", "UNBOUNDED", > +"UNCOMMITTED", "UNENCRYPTED", "UNION", "UNIQUE", "UPDATE", "USER", > +"USING", "VALUES", "VARCHAR", "VARYING", "VIEW", "WHEN", "WHERE", > +"WHILE", "WITH", "WORK", "WRITE", "XMLAGG", "XMLATTRIBUTES", > +"XMLCOMMENT", "XMLCONCAT", "XMLDOCUMENT", "XMLELEMENT", "XMLFOREST", > +"XMLNAMESPACES", "XMLPARSE", "XMLPI", "XMLQUERY", "XMLSCHEMA", > +"XMLTEXT", "XMLVALIDATE", "YEAR")))) > > # quoting > quoteIfNeeded <- function(conn, x, warn=T, ...) { > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/checkin-list

2 1

code for primitives and operators
by Chenxi Li 14 Dec '15

14 Dec '15

Hi, Could you tell me which files have the code for primitives and operators? Thanks a lot. Best Regards, Chenxi Li

2 2

About compilation time
by Mustafa Korkmaz 10 Dec '15

10 Dec '15

Hello all, I'm conducting an experiment to show pros/cons of certain DBs and I need to investigate query compilation performance in details. For this, Is there any way to measure the elapsed time in query parsing/compilation time in MonetDB? Also is there any document out there to show the query parsing/compilation details? What I find for timing is only "-i" flag which gives an overall timing stat. I'd be glad for any help. Thank you Mustafa Korkmaz

4 10

DROP SEQUENCE not working
by Anu Raj Srivastava 09 Dec '15

09 Dec '15

Hi, Whenever I try to drop I sequence I get the following error:- DROP SEQUENCE seq_12129; DROP SEQUENCE: unable to drop sequence seq_12129 (there are database objects which depend on it) I have dropped all the tables in the current schema, but I am still getting this error. Is there a way to find out what database object depends on this sequence? Anu

1 0

DBT-3 (TPC-H derivative) test kit
by Mark Wong 07 Dec '15

07 Dec '15

Greetings everyone, I just wanted to share what I've started with a test kit for MonetDB, hoping it will be useful for development efforts: http://sourceforge.net/p/osdldbt/dbt3/ci/master/tree/ The kit also relies on some additional scripts from here: http://sourceforge.net/p/osdldbt/dbttools/ci/master/tree/ Here is an example of a test report that the kit produces: http://mw2q.github.io/dbt3-monetdb-sample/ I'm hoping that the ability to collect low level profiling (on Linux), and collecting system stats will be helpful. For example, using Linux perf to collect data per query in the Power and Throughput Tests. The kit could still use a little help, and I'm not sure if I'm doing things in the best way. If it seems useful, please let me know how the kit can be improved. Thanks! Regards, Mark -- Mark Wong http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services

2 2

Driver JDBC 2.18 rounding decimal value
by Luciano Sasso 02 Dec '15

02 Dec '15

Driver JDBC 2.18, rounding decimal/numeric value, in the insert data on table. Its the same bub, in url https://www.monetdb.org/bugzilla/show_bug.cgi?id=3290 ? Any idea? existis patch ? Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. https://www.avast.com/antivirus

1 0