Changeset: 837b043e941a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=837b043e941a Added Files: tools/mserver/mserver5.1.in Removed Files: buildtools/ChangeLog.Jul2012 clients/ChangeLog.Jul2012 gdk/ChangeLog.Jul2012 geom/ChangeLog.Jul2012 java/ChangeLog.Jul2012 monetdb5/ChangeLog.Jul2012 sql/ChangeLog.Jul2012 testing/ChangeLog.Jul2012 tools/merovingian/ChangeLog.Jul2012 tools/mserver/mserver5.1 Modified Files: buildtools/ChangeLog.Jan2014 clients/mapiclient/mclient.1 clients/mapiclient/msqldump.1 configure.ag gdk/gdk_bbp.c gdk/gdk_calc_private.h gdk/gdk_join.c gdk/gdk_private.h gdk/gdk_system.c gdk/gdk_system.h gdk/gdk_utils.c monetdb5/mal/mal_dataflow.c monetdb5/mal/mal_private.h monetdb5/mal/mal_profiler.c monetdb5/mal/mal_recycle.c monetdb5/mal/mal_session.c monetdb5/modules/atoms/Makefile.ag monetdb5/optimizer/opt_pipes.c sql/backends/monet5/rel_bin.c sql/benchmarks/ssbm/Tests/04-explain.stable.out sql/benchmarks/ssbm/Tests/05-explain.stable.out sql/benchmarks/ssbm/Tests/06-explain.stable.out sql/benchmarks/ssbm/Tests/11-explain.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/18-explain.stable.out sql/common/sql_changeset.c sql/common/sql_list.c sql/common/sql_types.c sql/include/sql_list.h sql/server/rel_exp.c sql/server/rel_optimizer.c sql/server/rel_planner.c sql/server/rel_select.c sql/storage/sql_catalog.c sql/storage/store.c sql/test/Tests/setoptimizer.stable.out sql/test/Tests/setoptimizer.stable.out.Windows sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out tools/merovingian/client/monetdb.1 tools/merovingian/daemon/monetdbd.1.in tools/mserver/Makefile.ag Branch: int128 Log Message:
Merge with Jan2014 branch. diffs (truncated from 4942 to 300 lines): diff --git a/buildtools/ChangeLog.Jan2014 b/buildtools/ChangeLog.Jan2014 --- a/buildtools/ChangeLog.Jan2014 +++ b/buildtools/ChangeLog.Jan2014 @@ -1,3 +1,6 @@ # ChangeLog file for buildtools # This file is updated with Maddlog +* Fri Feb 28 2014 Sjoerd Mullender <sjo...@acm.org> +- Configure now enables the SQL front end by default. + diff --git a/buildtools/ChangeLog.Jul2012 b/buildtools/ChangeLog.Jul2012 deleted file mode 100644 --- a/buildtools/ChangeLog.Jul2012 +++ /dev/null @@ -1,3 +0,0 @@ -# ChangeLog file for buildtools -# This file is updated with Maddlog - diff --git a/clients/ChangeLog.Jul2012 b/clients/ChangeLog.Jul2012 deleted file mode 100644 --- a/clients/ChangeLog.Jul2012 +++ /dev/null @@ -1,3 +0,0 @@ -# ChangeLog file for clients -# This file is updated with Maddlog - diff --git a/clients/mapiclient/mclient.1 b/clients/mapiclient/mclient.1 --- a/clients/mapiclient/mclient.1 +++ b/clients/mapiclient/mclient.1 @@ -19,7 +19,7 @@ main-memory perspective with use of a fu automatic index management, extensibility of data types and search accelerators, SQL- and JAQL- frontends. .PP -.I mclient +.I Mclient is the command-line interface to the MonetDB server. .PP If the @@ -58,22 +58,30 @@ Before .I mclient starts parsing command line options, it reads a .I .monetdb -file. If the environment variable +file. +If the environment variable .B DOTMONETDBFILE -is set, it reads the file pointed to by that variable instead. When unset, +is set, it reads the file pointed to by that variable instead. +When unset, .I mclient searches for a .I .monetdb file in the current working directory, and if that doesn't exist, in the -current user's home directory. This file can contain defaults for the -flags -.BR user ", " password ", " language ", " save_history ", " format " and " width . +current user's home directory. +This file can contain defaults for the flags +.BR user , +.BR password , +.BR language , +.BR save_history , +.BR format , +and +.BR width . For example, an entry in a .I .monetdb -file that sets the default language for +file that sets the default language for .I mclient -to mal looks like this: -.IR "language=mal" . +to mal looks like this: +.BR language=mal . To disable reading the .I .monetdb file, set the variable @@ -90,8 +98,8 @@ Print usage information and exit. Print version information and exit. .TP \fB\-\-encoding=\fP\fIencoding\fP (\fB\-E\fP \fIencoding\fP) -Specify the character encoding of the input. The option applies to -both the standard input of +Specify the character encoding of the input. +The option applies to both the standard input of .I mclient and to the argument of the .B \-\-statement @@ -101,11 +109,12 @@ option but not to the contents of files .B \- which refers to standard input) or files specified using the .B \e< -command (those must be encoded using UTF-8). The default encoding is -taken from the locale. +command (those must be encoded using UTF-8). +The default encoding is taken from the locale. .TP \fB\-\-language=\fP\fIlanguage\fP (\fB\-l\fP \fIlanguage\fP) -Specify the query language. The following languages are recognized: +Specify the query language. +The following languages are recognized: .B mal and .BR sql . @@ -117,21 +126,26 @@ option is omitted, the default of is assumed. .TP \fB\-\-database=\fP\fIdatabase\fP (\fB\-d\fP \fIdatabase\fP) -Specify the name or URI of the database to connect to. The \fB-d\fP can be -omitted if an equally named file does not exist in the current -directory. As such, the first non-option argument will be interpreted -as database to connect to if the argument does not exist as file. -Valid URIs are as returned by -.RB "`monetdb discover`, see " monetdb "(1), and look like " "mapi:monetdb://hostname:port/database" . +Specify the name or URI of the database to connect to. +The \fB-d\fP can be omitted if an equally named file does not exist in +the current directory. +As such, the first non-option argument will be interpreted as database +to connect to if the argument does not exist as file. +Valid URIs are as returned by `monetdb discover`, see +.IR monetdb (1), +and look like +\fBmapi:monetdb://\fP\fIhostname\fP\fB:\fP\fIport\fP\fB/\fP\fIdatabase\fP. .TP \fB\-\-host=\fP\fIhostname\fP (\fB\-h\fP \fIhostname\fP) Specify the name of the host on which the server runs (default: -localhost). When the argument starts with a forward slash (/), host is -assumed to be the directory where the UNIX sockets are stored for -platforms where these are supported. +.BR localhost ). +When the argument starts with a forward slash (/), host is assumed to +be the directory where the UNIX sockets are stored for platforms where +these are supported. .TP \fB\-\-port=\fP\fIportnr\fP (\fB\-p\fP \fIportnr\fP) -Specify the portnumber of the server (default: 50000). +Specify the portnumber of the server (default: +.BR 50000 ). .TP \fB\-\-interactive\fP[\fB=\fP\fItimermode\fP] (\fB\-i\fP[\fItimermode\fP]) When reading from standard input, interpret lines starting with @@ -140,21 +154,20 @@ When reading from standard input, interp See the section BACKSLASH COMMANDS below. This is the default if standard input is a terminal. The optional \fItimermode\fP argument controls the -format of the time reported for queries. Note that no space is -allowed between +format of the time reported for queries. +Note that no space is allowed between .B \-i and .IR timermode . The default mode is -\fBhuman\fP which adjusts the time precision to the measured value. The -modes \fBms\fP, \fBs\fP and \fBm\fP force millisecond, second and minute -+ second precision respectively. +\fBhuman\fP which adjusts the time precision to the measured value. +The modes \fBms\fP, \fBs\fP and \fBm\fP force millisecond, second and +minute + second precision respectively. .TP \fB\-\-user\fP\fB=\fP\fIuser\fP (\fB\-u\fP \fIuser\fP) -Specify the user to connect as. If this flag is absent, the client will -ask for a user name, unless a default was found in .monetdb file. Note that -.I user -must follow immediately after the option. +Specify the user to connect as. +If this flag is absent, the client will ask for a user name, unless a +default was found in .monetdb file. .TP \fB\-\-format=\fP\fIformat\fP (\fB\-f\fP \fIformat\fP) Specify the output format. @@ -192,8 +205,9 @@ Load and save the command line history ( Save client/server interaction in the specified file. .TP \fB\-\-statement=\fP\fIstmt\fP (\fB\-s\fP \fIstmt\fP) -Execute the specified query. The query is run before any queries from -files specified on the command line are run. +Execute the specified query. +The query is run before any queries from files specified on the +command line are run. .TP \fB\-\-timezone\fP (\fB\-z\fP) Do not tell the client's timezone to the server. @@ -217,11 +231,12 @@ SQL Options .TP \fB\-\-null=\fP\fInullstr\fP (\fB\-n\fP \fInullstr\fP) Set the string to be used as NULL representation when using the -sql, csv, or tab output formats. If not used, NULL values are -represented by the string "null" in the sql output format, and as the -empty string in the csv and tab output formats. +sql, csv, or tab output formats. +If not used, NULL values are represented by the string \(dqnull\(dq in +the sql output format, and as the empty string in the csv and tab +output formats. Note that an argument is required, so in order to use the empty -string, use \fB\-n ""\fP (with the space) or \fB\-\-null=\fP. +string, use \fB\-n \(dq\(dq\fP (with the space) or \fB\-\-null=\fP. .TP \fB\-\-autocommit\fP (\fB\-a\fP) Switch autocommit mode off. @@ -232,17 +247,18 @@ If specified, query results will be page specified number of lines. .TP \fB\-\-width=\fP\fInr\fP (\fB\-w\fP \fInr\fP) -Specify the width of the screen. The default is the (initial) width -of the terminal. +Specify the width of the screen. +The default is the (initial) width of the terminal. .TP \fB\-\-dump\fP (\fB\-D\fP) Create an SQL dump. .TP \fB\-\-inserts\fP (\fB\-N\fP) Use INSERT INTO statements instead of COPY INTO + CSV values when -dumping the data of a table. This option can be used when trying to -load data from MonetDB into another database, or when e.g. JDBC -applications are used to reload the dump. +dumping the data of a table. +This option can be used when trying to load data from MonetDB into +another database, or when e.g. JDBC applications are used to reload +the dump. .SH BACKSLASH COMMANDS .SS General Commands @@ -345,32 +361,43 @@ Dump the given .IR table . .TP \fB\ed\fP -Alias for \\dvt. +Alias for \edvt. .TP \fB\ed[Stvsfn]+\fP -List database objects of the given type. Multiple type specifiers can -be used at the same time. The specifiers \fIS\fP, \fIt\fP, \fIv\fP, -\fIs\fP, \fIf\fP and \fIn\fP stand for System, table, view, sequence, -function and schema respectively. Note that \fIS\fP simply switches on -viewing system catalog objects, which is orthogonal on the other -specifiers. +List database objects of the given type. +Multiple type specifiers can be used at the same time. +The specifiers \fIS\fP, \fIt\fP, \fIv\fP, \fIs\fP, \fIf\fP and \fIn\fP +stand for System, table, view, sequence, function and schema +respectively. +Note that \fIS\fP simply switches on viewing system catalog objects, +which is orthogonal on the other specifiers. .TP \fB\ed[Stvsfn]+\fP \fIobject\fP Describe the given .I object -in the database using SQL statements that reconstruct the object. The -same specifiers as above can be used, following the same rules. When no -specifiers are given, \fBvt\fP is assumed. +in the database using SQL statements that reconstruct the object. +The same specifiers as above can be used, following the same rules. +When no specifiers are given, +.B vt +is assumed. The object can be given with or without a schema, separated by a dot. -The object name -can contain the wildcard characters \fB*\fP and \fB_\fP that represent -zero or more, and exactly one character respectively. An object -name is converted to lowercase, unless the object name is quoted by -double quotes (\fB"\fP). Examples of this, are e.g. \fI*.mytable\fP, -\fItabletype*\fP or \fI"myschema.FOO"\fP. Note that wildcard characters -do not work in quoted objects. Quoting follows SQL quoting rules. -Arbitrary parts can be quoted, and two quotes following each other in a -quoted string represent the quote itself. +The object name can contain the wildcard characters +.B * +and +.B _ +that represent zero or more, and exactly one character respectively. +An object name is converted to lowercase, unless the object name is +quoted by double quotes +.RB ( \(dq ). +Examples of this, are e.g. +.IR *.mytable , +.IR tabletype* , +or +.IR \(dqmyschema.FOO\(dq . +Note that wildcard characters do not work in quoted objects. +Quoting follows SQL quoting rules. +Arbitrary parts can be quoted, and two quotes following each other in +a quoted string represent the quote itself. .TP \fB\eA\fP Enable auto commit mode. @@ -379,25 +406,38 @@ Enable auto commit mode. Disable auto commit mode. .SH EXAMPLES Efficiently import data from a CSV (comma-separated values) file into -a table. The file must be readable by the server. $file is the -absolute path name of the file, $table is the name of the table, $db +a table. +The file must be readable by the server. +.I $file +is the +absolute path name of the file, +.I $table +is the name of the table, _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
