Bug 6534 - [Mar2018]: mclient -f tab / --format=tab complains about "unsupported formatter"
Summary: [Mar2018]: mclient -f tab / --format=tab complains about "unsupported formatter"
Status: RESOLVED NEXTRELEASE
Alias: None
Product: Client interfaces
Classification: Unclassified
Component: mclient, msqldump (show other bugs)
Version: 11.27.11 (Jul2017-SP3)
Hardware: All All
: Normal blocker
Assignee: clients devs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-02-08 07:16 CET by Stefan Manegold
Modified: 2018-02-08 09:29 CET (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Manegold cwiconfidential 2018-02-08 07:16:36 CET
$ for i in tab sql expanded x csv raw xml trash tab ; do echo -e "\n\t$i\n" ; mclient -d$DB -s'select 1,2;' -f $i ; echo ; done

	tab

unsupported formatter
% .L2,	.L4 # table_name
% L2,	L4 # name
% tinyint,	tinyint # type
% 1,	1 # length
[ 1,	2	]
clk: 0.822 ms


	sql

+------+------+
| L2   | L4   |
+======+======+
|    1 |    2 |
+------+------+
1 tuple
clk: 0.830 ms


	expanded

-[ RECORD 1 ]-
L2 | 1
L4 | 2
clk: 0.811 ms


	x

-[ RECORD 1 ]-
L2 | 1
L4 | 2
clk: 0.796 ms


	csv

1,2
clk: 0.824 ms


	raw

% .L2,	.L4 # table_name
% L2,	L4 # name
% tinyint,	tinyint # type
% 1,	1 # length
[ 1,	2	]
clk: 0.782 ms


	xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE table [
 <!ELEMENT table (row)*>
 <!ELEMENT row (column)+>
 <!ELEMENT column (#PCDATA)>
 <!ATTLIST table name CDATA #IMPLIED>
 <!ATTLIST column name CDATA #IMPLIED
                  isnull (true|false) 'false'>]>
<table name=".L2">
<row><column name="L2">1</column><column name="L4">2</column></row>
</table>
clk: 0.979 ms


	trash

clk: 0.932 ms


	tab

unsupported formatter
% .L2,	.L4 # table_name
% L2,	L4 # name
% tinyint,	tinyint # type
% 1,	1 # length
[ 1,	2	]
clk: 0.836 ms
Comment 1 MonetDB Mercurial Repository cwiconfidential 2018-02-08 09:27:33 CET
Changeset bcc430e78d4c, made by Stefan Manegold <Stefan.Manegold@cwi.nl> in the MonetDB repo, refers to this bug.

For complete details, see https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bcc430e78d4c

Changeset description:

	revert undocumented change of changeset 770e047b548c: "tab" -> "tsv" -> "tab"

	changeset 770e047b548c changed the name of mclient's tabular / tab-separated
	output formatter from "tab" to "tsv" without either documenting this
	change in the checkin message or updating any related documentation
	(--help messages, manpage) accordingly.

	To fix bug 6534, I herewith revert that change, i.e., mclient's
	tabular / tab-seperated output formatter is now again called "tab"
	as it used to be and as all documentation still claims.

	(If you prefer "tsv" over "tab" after all, please feel free to change that
	 correctly and consistently in all code, documentation and test output.)
Comment 2 Stefan Manegold cwiconfidential 2018-02-08 09:29:04 CET
fixed by reverting undocumented (and incomplete) change of changeset 770e047b548c.