developers-list December 2015

developers-list@monetdb.org

10 participants
6 discussions

by martin van dinther

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

6 years, 7 months

code for primitives and operators

by Chenxi Li

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

6 years, 7 months

About compilation time

by Mustafa Korkmaz

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

6 years, 7 months

DROP SEQUENCE not working

by Anu Raj Srivastava

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

6 years, 7 months

DBT-3 (TPC-H derivative) test kit

by Mark Wong

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

6 years, 7 months

Driver JDBC 2.18 rounding decimal value

by Luciano Sasso

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

6 years, 7 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

developers-list December 2015