Changeset: 170fb495a897 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=170fb495a897 Added Files: sql/test/copy/Tests/format_date.sql sql/test/copy/Tests/format_date.stable.err sql/test/copy/Tests/format_date.stable.out Modified Files: clients/Tests/SQL-dump_all.stable.out clients/Tests/SQL-dump_all.stable.out.int128 clients/Tests/SQL-dump_all.stable.out.oid32 clients/Tests/SQL-dump_all.stable.out.oid32.int128 sql/common/sql_types.c sql/scripts/13_date.sql sql/server/rel_updates.c sql/server/sql_parser.y sql/test/copy/Tests/All sql/test/leaks/Tests/check1_bam.stable.out.int128 sql/test/leaks/Tests/check2_bam.stable.out.int128 sql/test/leaks/Tests/check3_bam.stable.out.int128 sql/test/leaks/Tests/check4_bam.stable.out.int128 sql/test/leaks/Tests/check5_bam.stable.out.int128 Branch: default Log Message:
allow for a format string in the copy into csv files column list. Added an example/test. This is currently only supported for date typed columns as that has the required 'convert'(str,str) -> date function. diffs (truncated from 6137 to 300 lines): diff --git a/clients/Tests/SQL-dump_all.stable.out b/clients/Tests/SQL-dump_all.stable.out --- a/clients/Tests/SQL-dump_all.stable.out +++ b/clients/Tests/SQL-dump_all.stable.out @@ -106,6 +106,7 @@ SYSTEM FUNCTION sys.buffer SYSTEM FUNCTION sys.chi2prob SYSTEM FUNCTION sys.columnsize SYSTEM FUNCTION sys.contains +SYSTEM FUNCTION sys.convert SYSTEM FUNCTION sys.convexhull SYSTEM FUNCTION sys.corr SYSTEM FUNCTION sys.crosses diff --git a/clients/Tests/SQL-dump_all.stable.out.int128 b/clients/Tests/SQL-dump_all.stable.out.int128 --- a/clients/Tests/SQL-dump_all.stable.out.int128 +++ b/clients/Tests/SQL-dump_all.stable.out.int128 @@ -102,6 +102,7 @@ SYSTEM FUNCTION sys.buffer SYSTEM FUNCTION sys.chi2prob SYSTEM FUNCTION sys.columnsize SYSTEM FUNCTION sys.contains +SYSTEM FUNCTION sys.convert SYSTEM FUNCTION sys.convexhull SYSTEM FUNCTION sys.corr SYSTEM FUNCTION sys.crosses @@ -1540,167 +1541,167 @@ 5699 "auth_id" "int" 32 0 5697 NULL true 5700 "privileges" "int" 32 0 5697 NULL true 2 NULL 5701 "grantor" "int" 32 0 5697 NULL true 3 NULL 5702 "grantable" "int" 32 0 5697 NULL true 4 NULL -5891 "id" "oid" 63 0 5899 NULL true 0 NULL -5892 "owner" "clob" 0 0 5899 NULL true 1 NULL -5893 "defined" "timestamp" 7 0 5899 NULL true 2 NULL -5894 "query" "clob" 0 0 5899 NULL true 3 NULL -5895 "pipe" "clob" 0 0 5899 NULL true 4 NULL -5896 "plan" "clob" 0 0 5899 NULL true 5 NULL -5897 "mal" "int" 32 0 5899 NULL true 6 NULL -5898 "optimize" "bigint" 64 0 5899 NULL true 7 NULL -5901 "id" "oid" 63 0 5910 NULL true 0 NULL -5902 "start" "timestamp" 7 0 5910 NULL true 1 NULL -5903 "stop" "timestamp" 7 0 5910 NULL true 2 NULL -5904 "arguments" "clob" 0 0 5910 NULL true 3 NULL -5905 "tuples" "wrd" 64 0 5910 NULL true 4 NULL -5906 "run" "bigint" 64 0 5910 NULL true 5 NULL -5907 "ship" "bigint" 64 0 5910 NULL true 6 NULL -5908 "cpu" "int" 32 0 5910 NULL true 7 NULL -5909 "io" "int" 32 0 5910 NULL true 8 NULL -5912 "id" "oid" 63 0 5928 NULL true 0 NULL -5913 "owner" "clob" 0 0 5928 NULL true 1 NULL -5914 "defined" "timestamp" 7 0 5928 NULL true 2 NULL -5915 "query" "clob" 0 0 5928 NULL true 3 NULL -5916 "pipe" "clob" 0 0 5928 NULL true 4 NULL -5917 "plan" "clob" 0 0 5928 NULL true 5 NULL -5918 "mal" "int" 32 0 5928 NULL true 6 NULL -5919 "optimize" "bigint" 64 0 5928 NULL true 7 NULL -5920 "start" "timestamp" 7 0 5928 NULL true 8 NULL -5921 "stop" "timestamp" 7 0 5928 NULL true 9 NULL -5922 "arguments" "clob" 0 0 5928 NULL true 10 NULL -5923 "tuples" "wrd" 64 0 5928 NULL true 11 NULL -5924 "run" "bigint" 64 0 5928 NULL true 12 NULL -5925 "ship" "bigint" 64 0 5928 NULL true 13 NULL -5926 "cpu" "int" 32 0 5928 NULL true 14 NULL -5927 "io" "int" 32 0 5928 NULL true 15 NULL -5954 "event" "int" 32 0 5967 NULL true 0 NULL -5955 "clk" "varchar" 20 0 5967 NULL true 1 NULL -5956 "pc" "varchar" 50 0 5967 NULL true 2 NULL -5957 "thread" "int" 32 0 5967 NULL true 3 NULL -5958 "ticks" "bigint" 64 0 5967 NULL true 4 NULL -5959 "rrsmb" "bigint" 64 0 5967 NULL true 5 NULL -5960 "vmmb" "bigint" 64 0 5967 NULL true 6 NULL -5961 "reads" "bigint" 64 0 5967 NULL true 7 NULL -5962 "writes" "bigint" 64 0 5967 NULL true 8 NULL -5963 "minflt" "bigint" 64 0 5967 NULL true 9 NULL -5964 "majflt" "bigint" 64 0 5967 NULL true 10 NULL -5965 "nvcsw" "bigint" 64 0 5967 NULL true 11 NULL -5966 "stmt" "clob" 0 0 5967 NULL true 12 NULL -6097 "user" "clob" 0 0 6103 NULL true 0 NULL -6098 "login" "timestamp" 7 0 6103 NULL true 1 NULL -6099 "sessiontimeout" "bigint" 64 0 6103 NULL true 2 NULL -6100 "lastcommand" "timestamp" 7 0 6103 NULL true 3 NULL -6101 "querytimeout" "bigint" 64 0 6103 NULL true 4 NULL -6102 "active" "boolean" 1 0 6103 NULL true 5 NULL -6180 "name" "clob" 0 0 6183 NULL true 0 NULL -6181 "def" "clob" 0 0 6183 NULL true 1 NULL -6182 "status" "clob" 0 0 6183 NULL true 2 NULL -6189 "name" "clob" 0 0 6191 NULL true 0 NULL -6190 "value" "clob" 0 0 6191 NULL true 1 NULL -6221 "qtag" "bigint" 64 0 6229 NULL true 0 NULL -6222 "user" "clob" 0 0 6229 NULL true 1 NULL -6223 "started" "timestamp" 7 0 6229 NULL true 2 NULL -6224 "estimate" "timestamp" 7 0 6229 NULL true 3 NULL -6225 "progress" "int" 32 0 6229 NULL true 4 NULL -6226 "status" "clob" 0 0 6229 NULL true 5 NULL -6227 "tag" "oid" 63 0 6229 NULL true 6 NULL -6228 "query" "clob" 0 0 6229 NULL true 7 NULL -6922 "schema" "clob" 0 0 6935 NULL true 0 NULL -6923 "table" "clob" 0 0 6935 NULL true 1 NULL -6924 "column" "clob" 0 0 6935 NULL true 2 NULL -6925 "type" "clob" 0 0 6935 NULL true 3 NULL -6926 "mode" "clob" 0 0 6935 NULL true 4 NULL -6927 "location" "clob" 0 0 6935 NULL true 5 NULL -6928 "count" "bigint" 64 0 6935 NULL true 6 NULL -6929 "typewidth" "int" 32 0 6935 NULL true 7 NULL -6930 "columnsize" "bigint" 64 0 6935 NULL true 8 NULL -6931 "heapsize" "bigint" 64 0 6935 NULL true 9 NULL -6932 "hashes" "bigint" 64 0 6935 NULL true 10 NULL -6933 "imprints" "bigint" 64 0 6935 NULL true 11 NULL -6934 "sorted" "boolean" 1 0 6935 NULL true 12 NULL -6937 "schema" "clob" 0 0 6947 NULL true 0 NULL -6938 "table" "clob" 0 0 6947 NULL true 1 NULL -6939 "column" "clob" 0 0 6947 NULL true 2 NULL -6940 "type" "clob" 0 0 6947 NULL true 3 NULL -6941 "typewidth" "int" 32 0 6947 NULL true 4 NULL -6942 "count" "bigint" 64 0 6947 NULL true 5 NULL -6943 "distinct" "bigint" 64 0 6947 NULL true 6 NULL -6944 "atomwidth" "int" 32 0 6947 NULL true 7 NULL -6945 "reference" "boolean" 1 0 6947 NULL true 8 NULL -6946 "sorted" "boolean" 1 0 6947 NULL true 9 NULL -6985 "schema" "clob" 0 0 6995 NULL true 0 NULL -6986 "table" "clob" 0 0 6995 NULL true 1 NULL -6987 "column" "clob" 0 0 6995 NULL true 2 NULL -6988 "type" "clob" 0 0 6995 NULL true 3 NULL -6989 "count" "bigint" 64 0 6995 NULL true 4 NULL -6990 "columnsize" "bigint" 64 0 6995 NULL true 5 NULL -6991 "heapsize" "bigint" 64 0 6995 NULL true 6 NULL -6992 "hashes" "bigint" 64 0 6995 NULL true 7 NULL -6993 "imprints" "bigint" 64 0 6995 NULL true 8 NULL -6994 "sorted" "boolean" 1 0 6995 NULL true 9 NULL -6997 "schema" "clob" 0 0 7005 NULL true 0 NULL -6998 "table" "clob" 0 0 7005 NULL true 1 NULL -6999 "count" "bigint" 64 0 7005 NULL true 2 NULL -7000 "columnsize" "hugeint" 64 0 7005 NULL true 3 NULL -7001 "heapsize" "hugeint" 64 0 7005 NULL true 4 NULL -7002 "hashes" "hugeint" 64 0 7005 NULL true 5 NULL -7003 "imprints" "hugeint" 64 0 7005 NULL true 6 NULL -7004 "auxiliary" "hugeint" 128 0 7005 NULL true 7 NULL -7007 "column_id" "int" 32 0 7018 NULL true 0 NULL -7008 "type" "clob" 0 0 7018 NULL true 1 NULL -7009 "width" "int" 32 0 7018 NULL true 2 NULL -7010 "stamp" "timestamp" 7 0 7018 NULL true 3 NULL -7011 "sample" "bigint" 64 0 7018 NULL true 4 NULL -7012 "count" "bigint" 64 0 7018 NULL true 5 NULL -7013 "unique" "bigint" 64 0 7018 NULL true 6 NULL -7014 "nils" "bigint" 64 0 7018 NULL true 7 NULL -7015 "minval" "clob" 0 0 7018 NULL true 8 NULL -7016 "maxval" "clob" 0 0 7018 NULL true 9 NULL -7017 "sorted" "boolean" 1 0 7018 NULL true 10 NULL -7118 "file_id" "bigint" 64 0 7126 NULL false 0 NULL -7119 "file_location" "clob" 0 0 7126 NULL false 1 NULL -7120 "dbschema" "smallint" 16 0 7126 NULL false 2 NULL -7121 "format_version" "varchar" 7 0 7126 NULL true 3 NULL -7122 "sorting_order" "varchar" 10 0 7126 NULL true 4 NULL -7123 "comments" "clob" 0 0 7126 NULL true 5 NULL -7128 "sn" "clob" 0 0 7139 NULL false 0 NULL -7129 "file_id" "bigint" 64 0 7139 NULL false 1 NULL -7130 "ln" "int" 32 0 7139 NULL true 2 NULL -7131 "as" "int" 32 0 7139 NULL true 3 NULL -7132 "m5" "clob" 0 0 7139 NULL true 4 NULL -7133 "sp" "clob" 0 0 7139 NULL true 5 NULL -7134 "ur" "clob" 0 0 7139 NULL true 6 NULL -7141 "id" "clob" 0 0 7158 NULL false 0 NULL -7142 "file_id" "bigint" 64 0 7158 NULL false 1 NULL -7143 "cn" "clob" 0 0 7158 NULL true 2 NULL -7144 "ds" "clob" 0 0 7158 NULL true 3 NULL -7145 "dt" "timestamp" 7 0 7158 NULL true 4 NULL -7146 "fo" "clob" 0 0 7158 NULL true 5 NULL -7147 "ks" "clob" 0 0 7158 NULL true 6 NULL -7148 "lb" "clob" 0 0 7158 NULL true 7 NULL -7149 "pg" "clob" 0 0 7158 NULL true 8 NULL -7150 "pi" "int" 32 0 7158 NULL true 9 NULL -7151 "pl" "clob" 0 0 7158 NULL true 10 NULL -7152 "pu" "clob" 0 0 7158 NULL true 11 NULL -7153 "sm" "clob" 0 0 7158 NULL true 12 NULL -7160 "id" "clob" 0 0 7170 NULL false 0 NULL -7161 "file_id" "bigint" 64 0 7170 NULL false 1 NULL -7162 "pn" "clob" 0 0 7170 NULL true 2 NULL -7163 "cl" "clob" 0 0 7170 NULL true 3 NULL -7164 "pp" "clob" 0 0 7170 NULL true 4 NULL -7165 "vn" "clob" 0 0 7170 NULL true 5 NULL -7172 "qname" "clob" 0 0 7183 NULL false 0 NULL -7173 "flag" "smallint" 16 0 7183 NULL false 1 NULL -7174 "rname" "clob" 0 0 7183 NULL false 2 NULL -7175 "pos" "int" 32 0 7183 NULL false 3 NULL -7176 "mapq" "smallint" 16 0 7183 NULL false 4 NULL -7177 "cigar" "clob" 0 0 7183 NULL false 5 NULL -7178 "rnext" "clob" 0 0 7183 NULL false 6 NULL -7179 "pnext" "int" 32 0 7183 NULL false 7 NULL -7180 "tlen" "int" 32 0 7183 NULL false 8 NULL -7181 "seq" "clob" 0 0 7183 NULL false 9 NULL -7182 "qual" "clob" 0 0 7183 NULL false 10 NULL -7264 "function_id" "int" 32 0 7265 NULL true 0 NULL +5896 "id" "oid" 63 0 5904 NULL true 0 NULL +5897 "owner" "clob" 0 0 5904 NULL true 1 NULL +5898 "defined" "timestamp" 7 0 5904 NULL true 2 NULL +5899 "query" "clob" 0 0 5904 NULL true 3 NULL +5900 "pipe" "clob" 0 0 5904 NULL true 4 NULL +5901 "plan" "clob" 0 0 5904 NULL true 5 NULL +5902 "mal" "int" 32 0 5904 NULL true 6 NULL +5903 "optimize" "bigint" 64 0 5904 NULL true 7 NULL +5906 "id" "oid" 63 0 5915 NULL true 0 NULL +5907 "start" "timestamp" 7 0 5915 NULL true 1 NULL +5908 "stop" "timestamp" 7 0 5915 NULL true 2 NULL +5909 "arguments" "clob" 0 0 5915 NULL true 3 NULL +5910 "tuples" "wrd" 64 0 5915 NULL true 4 NULL +5911 "run" "bigint" 64 0 5915 NULL true 5 NULL +5912 "ship" "bigint" 64 0 5915 NULL true 6 NULL +5913 "cpu" "int" 32 0 5915 NULL true 7 NULL +5914 "io" "int" 32 0 5915 NULL true 8 NULL +5917 "id" "oid" 63 0 5933 NULL true 0 NULL +5918 "owner" "clob" 0 0 5933 NULL true 1 NULL +5919 "defined" "timestamp" 7 0 5933 NULL true 2 NULL +5920 "query" "clob" 0 0 5933 NULL true 3 NULL +5921 "pipe" "clob" 0 0 5933 NULL true 4 NULL +5922 "plan" "clob" 0 0 5933 NULL true 5 NULL +5923 "mal" "int" 32 0 5933 NULL true 6 NULL +5924 "optimize" "bigint" 64 0 5933 NULL true 7 NULL +5925 "start" "timestamp" 7 0 5933 NULL true 8 NULL +5926 "stop" "timestamp" 7 0 5933 NULL true 9 NULL +5927 "arguments" "clob" 0 0 5933 NULL true 10 NULL +5928 "tuples" "wrd" 64 0 5933 NULL true 11 NULL +5929 "run" "bigint" 64 0 5933 NULL true 12 NULL +5930 "ship" "bigint" 64 0 5933 NULL true 13 NULL +5931 "cpu" "int" 32 0 5933 NULL true 14 NULL +5932 "io" "int" 32 0 5933 NULL true 15 NULL +5959 "event" "int" 32 0 5972 NULL true 0 NULL +5960 "clk" "varchar" 20 0 5972 NULL true 1 NULL +5961 "pc" "varchar" 50 0 5972 NULL true 2 NULL +5962 "thread" "int" 32 0 5972 NULL true 3 NULL +5963 "ticks" "bigint" 64 0 5972 NULL true 4 NULL +5964 "rrsmb" "bigint" 64 0 5972 NULL true 5 NULL +5965 "vmmb" "bigint" 64 0 5972 NULL true 6 NULL +5966 "reads" "bigint" 64 0 5972 NULL true 7 NULL +5967 "writes" "bigint" 64 0 5972 NULL true 8 NULL +5968 "minflt" "bigint" 64 0 5972 NULL true 9 NULL +5969 "majflt" "bigint" 64 0 5972 NULL true 10 NULL +5970 "nvcsw" "bigint" 64 0 5972 NULL true 11 NULL +5971 "stmt" "clob" 0 0 5972 NULL true 12 NULL +6102 "user" "clob" 0 0 6108 NULL true 0 NULL +6103 "login" "timestamp" 7 0 6108 NULL true 1 NULL +6104 "sessiontimeout" "bigint" 64 0 6108 NULL true 2 NULL +6105 "lastcommand" "timestamp" 7 0 6108 NULL true 3 NULL +6106 "querytimeout" "bigint" 64 0 6108 NULL true 4 NULL +6107 "active" "boolean" 1 0 6108 NULL true 5 NULL +6185 "name" "clob" 0 0 6188 NULL true 0 NULL +6186 "def" "clob" 0 0 6188 NULL true 1 NULL +6187 "status" "clob" 0 0 6188 NULL true 2 NULL +6194 "name" "clob" 0 0 6196 NULL true 0 NULL +6195 "value" "clob" 0 0 6196 NULL true 1 NULL +6226 "qtag" "bigint" 64 0 6234 NULL true 0 NULL +6227 "user" "clob" 0 0 6234 NULL true 1 NULL +6228 "started" "timestamp" 7 0 6234 NULL true 2 NULL +6229 "estimate" "timestamp" 7 0 6234 NULL true 3 NULL +6230 "progress" "int" 32 0 6234 NULL true 4 NULL +6231 "status" "clob" 0 0 6234 NULL true 5 NULL +6232 "tag" "oid" 63 0 6234 NULL true 6 NULL +6233 "query" "clob" 0 0 6234 NULL true 7 NULL +6927 "schema" "clob" 0 0 6940 NULL true 0 NULL +6928 "table" "clob" 0 0 6940 NULL true 1 NULL +6929 "column" "clob" 0 0 6940 NULL true 2 NULL +6930 "type" "clob" 0 0 6940 NULL true 3 NULL +6931 "mode" "clob" 0 0 6940 NULL true 4 NULL +6932 "location" "clob" 0 0 6940 NULL true 5 NULL +6933 "count" "bigint" 64 0 6940 NULL true 6 NULL +6934 "typewidth" "int" 32 0 6940 NULL true 7 NULL +6935 "columnsize" "bigint" 64 0 6940 NULL true 8 NULL +6936 "heapsize" "bigint" 64 0 6940 NULL true 9 NULL +6937 "hashes" "bigint" 64 0 6940 NULL true 10 NULL +6938 "imprints" "bigint" 64 0 6940 NULL true 11 NULL +6939 "sorted" "boolean" 1 0 6940 NULL true 12 NULL +6942 "schema" "clob" 0 0 6952 NULL true 0 NULL +6943 "table" "clob" 0 0 6952 NULL true 1 NULL +6944 "column" "clob" 0 0 6952 NULL true 2 NULL +6945 "type" "clob" 0 0 6952 NULL true 3 NULL +6946 "typewidth" "int" 32 0 6952 NULL true 4 NULL +6947 "count" "bigint" 64 0 6952 NULL true 5 NULL +6948 "distinct" "bigint" 64 0 6952 NULL true 6 NULL +6949 "atomwidth" "int" 32 0 6952 NULL true 7 NULL +6950 "reference" "boolean" 1 0 6952 NULL true 8 NULL +6951 "sorted" "boolean" 1 0 6952 NULL true 9 NULL +6990 "schema" "clob" 0 0 7000 NULL true 0 NULL +6991 "table" "clob" 0 0 7000 NULL true 1 NULL +6992 "column" "clob" 0 0 7000 NULL true 2 NULL +6993 "type" "clob" 0 0 7000 NULL true 3 NULL +6994 "count" "bigint" 64 0 7000 NULL true 4 NULL +6995 "columnsize" "bigint" 64 0 7000 NULL true 5 NULL +6996 "heapsize" "bigint" 64 0 7000 NULL true 6 NULL +6997 "hashes" "bigint" 64 0 7000 NULL true 7 NULL +6998 "imprints" "bigint" 64 0 7000 NULL true 8 NULL +6999 "sorted" "boolean" 1 0 7000 NULL true 9 NULL +7002 "schema" "clob" 0 0 7010 NULL true 0 NULL +7003 "table" "clob" 0 0 7010 NULL true 1 NULL +7004 "count" "bigint" 64 0 7010 NULL true 2 NULL +7005 "columnsize" "hugeint" 64 0 7010 NULL true 3 NULL +7006 "heapsize" "hugeint" 64 0 7010 NULL true 4 NULL +7007 "hashes" "hugeint" 64 0 7010 NULL true 5 NULL +7008 "imprints" "hugeint" 64 0 7010 NULL true 6 NULL +7009 "auxiliary" "hugeint" 128 0 7010 NULL true 7 NULL +7012 "column_id" "int" 32 0 7023 NULL true 0 NULL +7013 "type" "clob" 0 0 7023 NULL true 1 NULL +7014 "width" "int" 32 0 7023 NULL true 2 NULL +7015 "stamp" "timestamp" 7 0 7023 NULL true 3 NULL +7016 "sample" "bigint" 64 0 7023 NULL true 4 NULL +7017 "count" "bigint" 64 0 7023 NULL true 5 NULL +7018 "unique" "bigint" 64 0 7023 NULL true 6 NULL _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
