Changeset: c7971537462c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c7971537462c Added Files: MacOSX/MonetDB_logo.png clients/R/Tests/dplyr.timeout monetdb5/modules/mal/Tests/orderidx04.stable.err monetdb5/modules/mal/Tests/orderidx04.stable.out sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.err.single sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out.single sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_ALTER_TABLE_crash.Bug-4010.sql sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_ALTER_TABLE_crash.Bug-4010.stable.err sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_ALTER_TABLE_crash.Bug-4010.stable.out sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_UPDATE_crash.Bug-4010.sql sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_UPDATE_crash.Bug-4010.stable.err sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_UPDATE_crash.Bug-4010.stable.out sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.stable.out.32bit sql/test/BugTracker-2016/Tests/storagemodel.sql sql/test/BugTracker-2016/Tests/storagemodel.stable.err sql/test/BugTracker-2016/Tests/storagemodel.stable.out sql/test/BugTracker-2016/Tests/string-length.Bug-3999.sql sql/test/BugTracker-2016/Tests/string-length.Bug-3999.stable.err sql/test/BugTracker-2016/Tests/string-length.Bug-3999.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit Removed Files: MacOSX/MonetDB logo.png sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.sql sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.err sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out Modified Files: MacOSX/MonetDB.pkgproj NT/updatecodes.py clients/R/MonetDB.R/R/dbi.R clients/R/Tests/All clients/R/Tests/dbapply.R clients/R/Tests/dbi.R clients/R/Tests/deps-install.R clients/R/Tests/deps-test.R clients/R/Tests/dplyr-flights.R clients/R/Tests/dplyr-flights.stable.out clients/R/Tests/dplyr.R clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/Tests/exports.stable.out clients/mapiclient/mclient.c gdk/gdk.h gdk/gdk_bbp.c gdk/gdk_join.c gdk/gdk_logger.c gdk/gdk_select.c gdk/gdk_storage.c gdk/gdk_tm.c gdk/gdk_utils.c java/ChangeLog.Jul2015 java/ChangeLog.Jun2016 java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java java/src/main/java/nl/cwi/monetdb/jdbc/MonetResultSet.java java/src/main/java/nl/cwi/monetdb/util/SQLExporter.java monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows.single monetdb5/extras/mal_optimizer_template/opt_sql_append.c monetdb5/extras/rapi/rapi.c monetdb5/mal/mal.c monetdb5/mal/mal.h monetdb5/mal/mal_debugger.c monetdb5/mal/mal_instruction.c monetdb5/mal/mal_instruction.h monetdb5/mal/mal_listing.c monetdb5/mal/mal_namespace.c monetdb5/mal/mal_runtime.c monetdb5/modules/atoms/str.c monetdb5/modules/atoms/str.h monetdb5/modules/atoms/str.mal monetdb5/modules/kernel/batstr.c monetdb5/modules/kernel/batstr.mal monetdb5/modules/kernel/status.c monetdb5/modules/mal/01_batcalc.mal monetdb5/modules/mal/Tests/inspect00.stable.out monetdb5/modules/mal/Tests/inspect05.stable.out monetdb5/modules/mal/bbp.c monetdb5/modules/mal/manifold.c monetdb5/optimizer/Tests/dataflow3.stable.out monetdb5/optimizer/Tests/inline02.stable.out monetdb5/optimizer/Tests/inline03.stable.out monetdb5/optimizer/Tests/inline04.stable.out monetdb5/optimizer/Tests/inline06.stable.out monetdb5/optimizer/Tests/inline07.stable.out monetdb5/optimizer/Tests/inline09.stable.out monetdb5/optimizer/Tests/inline10.stable.out monetdb5/optimizer/Tests/inline12.stable.out monetdb5/optimizer/Tests/inlineCst.stable.out monetdb5/optimizer/Tests/inlineFunction2.stable.out monetdb5/optimizer/Tests/manifold2.stable.out monetdb5/optimizer/Tests/manifold2.stable.out.single monetdb5/optimizer/opt_constants.c monetdb5/optimizer/opt_costModel.c monetdb5/optimizer/opt_support.c monetdb5/optimizer/opt_wrapper.c monetdb5/optimizer/optimizer.c monetdb5/scheduler/run_isolate.c sql/backends/monet5/sql_decimal.mal sql/backends/monet5/sql_decimal.mal.sh sql/backends/monet5/sql_decimal_hge.mal sql/backends/monet5/sql_decimal_hge.mal.sh sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_optimizer.c sql/backends/monet5/sql_upgrades.c sql/benchmarks/ssbm/Tests/01-explain.stable.out sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/02-explain.stable.out sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/03-explain.stable.out sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/04-explain.stable.out sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/05-explain.stable.out sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/06-explain.stable.out sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/07-explain.stable.out sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/08-explain.stable.out sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/09-explain.stable.out sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/10-explain.stable.out sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128 sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 sql/benchmarks/tpch/Tests/02-explain.stable.out sql/benchmarks/tpch/Tests/03-explain.stable.out sql/benchmarks/tpch/Tests/03-explain.stable.out.int128 sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit sql/benchmarks/tpch/Tests/05-explain.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit sql/benchmarks/tpch/Tests/05-explain.stable.out.int128 sql/benchmarks/tpch/Tests/06-explain.stable.out sql/benchmarks/tpch/Tests/06-explain.stable.out.int128 sql/benchmarks/tpch/Tests/08-explain.stable.out sql/benchmarks/tpch/Tests/08-explain.stable.out.int128 sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/09-explain.stable.out.int128 sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out.int128 sql/benchmarks/tpch/Tests/12-explain.stable.out sql/benchmarks/tpch/Tests/12-explain.stable.out.int128 sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit sql/benchmarks/tpch/Tests/14-explain.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out.int128 sql/benchmarks/tpch/Tests/17-explain.stable.out sql/benchmarks/tpch/Tests/17-explain.stable.out.int128 sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit sql/benchmarks/tpch/Tests/21-plan.stable.out sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit sql/common/sql_types.c sql/jdbc/tests/Tests/Test_CisValid.stable.err sql/jdbc/tests/Tests/Test_JdbcClient.stable.out sql/jdbc/tests/Tests/Test_Rmetadata.stable.out sql/scripts/45_uuid.sql sql/server/rel_optimizer.c sql/server/rel_partition.c sql/server/sql_mvc.c sql/server/sql_parser.y sql/server/sql_qc.c sql/storage/store.c sql/test/ADT2006/Tests/bram.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/var_char_cast_truncate.SF-1150907.stable.out sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128 sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128.single sql/test/BugTracker-2013/Tests/binary_copy_into.Bug-3345.SQL.py sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out sql/test/BugTracker-2015/Tests/mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863.stable.out.int128 sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out sql/test/BugTracker-2016/Tests/All sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.32bit sql/test/BugTracker/Tests/authorization.SF-1430616.stable.out sql/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out sql/test/BugTracker/Tests/explain.SF-1739353.stable.out sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Tests/decimal2.stable.out sql/test/Tests/str-pad.stable.out sql/test/Tests/str-trim.stable.out sql/test/Tests/string.stable.out sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 sql/test/Users/Tests/copyinto.SQL.py sql/test/Users/Tests/copyinto.stable.err sql/test/Users/Tests/dropManyUsers.Bug-3764.SQL.py sql/test/Users/Tests/dropManyUsers.Bug-3764.stable.out sql/test/Users/Tests/test_privs2_p1.stable.out sql/test/bugs/Tests/except-union-intersect-bug-sf-1146079.stable.out sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_MapiClient.stable.out sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/check.stable.out sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 sql/test/leaks/Tests/check0.stable.out sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check2.stable.out.int128 sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check3.stable.out.int128 sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check4.stable.out.int128 sql/test/leaks/Tests/check5.stable.out sql/test/leaks/Tests/check5.stable.out.int128 sql/test/leaks/Tests/select1.stable.out sql/test/leaks/Tests/select2.stable.out sql/test/mergetables/Tests/mergequery.stable.out sql/test/orderidx/Tests/simpletable.sql sql/test/orderidx/Tests/simpletable.stable.out sql/test/orderidx/Tests/smalltable.sql sql/test/orderidx/Tests/smalltable.stable.out sql/test/pg_regress/Tests/strings.stable.out sql/test/pg_regress/Tests/without_oid.stable.out.oid32 sql/test/remote/Tests/partition_elim.stable.out sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 testing/Mfilter.py testing/Mtest.py.in tools/mserver/mserver5.c Branch: no-wrd Log Message:
Merge with default branch. diffs (truncated from 32268 to 300 lines): diff --git a/MacOSX/MonetDB.pkgproj b/MacOSX/MonetDB.pkgproj --- a/MacOSX/MonetDB.pkgproj +++ b/MacOSX/MonetDB.pkgproj @@ -544,7 +544,7 @@ <key>BACKGROUND_PATH</key> <dict> <key>PATH</key> - <string>MonetDB logo.png</string> + <string>MonetDB_logo.png</string> <key>PATH_TYPE</key> <integer>1</integer> </dict> diff --git a/MacOSX/MonetDB logo.png b/MacOSX/MonetDB_logo.png rename from MacOSX/MonetDB logo.png rename to MacOSX/MonetDB_logo.png diff --git a/NT/updatecodes.py b/NT/updatecodes.py --- a/NT/updatecodes.py +++ b/NT/updatecodes.py @@ -13,20 +13,22 @@ prcdre = re.compile('"ProductCode" = "8: pacdre = re.compile('"PackageCode" = "8:{(.*)}"') def update(f): - p = subprocess.Popen(['uuidgen'], stdout = subprocess.PIPE) + p = subprocess.Popen(['uuidgen'], stdout = subprocess.PIPE, + universal_newlines = True) u, e = p.communicate() - productcode = u.strip('\r\n').upper() - p = subprocess.Popen(['uuidgen'], stdout = subprocess.PIPE) + productcode = u.strip('\n').upper() + p = subprocess.Popen(['uuidgen'], stdout = subprocess.PIPE, + universal_newlines = True) u, e = p.communicate() - packagecode = u.strip('\r\n').upper() - fp = open(f, 'rb') + packagecode = u.strip('\n').upper() + fp = open(f) data = fp.read() fp.close() repl = '"ProductCode" = "8:{%s}"' % productcode data = prcdre.sub(repl, data) repl = '"PackageCode" = "8:{%s}"' % packagecode data = pacdre.sub(repl, data) - fp = open(f, 'wb') + fp = open(f, 'w') fp.write(data) fp.close() 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 @@ -524,7 +524,7 @@ setMethod("dbWriteTable", signature(conn if (csvdump) { tmp <- tempfile(fileext = ".csv") write.table(value, tmp, sep = ",", quote = TRUE, row.names = FALSE, col.names = FALSE, na="", fileEncoding = "UTF-8") - dbSendQuery(conn, paste0("COPY INTO ", qname, " FROM '", tmp, "' USING DELIMITERS ',','\\n','\"' NULL AS ''")) + dbSendQuery(conn, paste0("COPY INTO ", qname, " FROM '", encodeString(tmp), "' USING DELIMITERS ',','\\n','\"' NULL AS ''")) file.remove(tmp) } else { vins <- paste("(", paste(rep("?", length(value)), collapse=', '), ")", sep='') @@ -924,7 +924,7 @@ monet.read.csv <- monetdb.read.csv <- fu delimspec <- paste0("USING DELIMITERS '", delim, "','", newline, "','", quote, "'") for(i in seq_along(files)) { - thefile <- normalizePath(files[i]) + thefile <- encodeString(normalizePath(files[i])) dbSendUpdate(conn, paste("COPY", if(header) "OFFSET 2", "INTO", tablename, "FROM", paste("'", thefile, "'", sep=""), delimspec, "NULL as", paste("'", na.strings[1], "'", sep=""), if(locked) "LOCKED", if(best.effort) "BEST EFFORT")) diff --git a/clients/R/Tests/All b/clients/R/Tests/All --- a/clients/R/Tests/All +++ b/clients/R/Tests/All @@ -1,6 +1,6 @@ HAVE_LIBR?deps-install +HAVE_LIBR?install HAVE_LIBR?deps-test -HAVE_LIBR?install HAVE_LIBR?dbi HAVE_LIBR?survey HAVE_LIBR?dplyr diff --git a/clients/R/Tests/dbapply.R b/clients/R/Tests/dbapply.R --- a/clients/R/Tests/dbapply.R +++ b/clients/R/Tests/dbapply.R @@ -1,6 +1,5 @@ -ll <- NULL if (Sys.getenv("TSTTRGDIR") != "") { - ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir") + .libPaths(c(.libPaths(), paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir"))) } library(DBI, quietly = T) diff --git a/clients/R/Tests/dbi.R b/clients/R/Tests/dbi.R --- a/clients/R/Tests/dbi.R +++ b/clients/R/Tests/dbi.R @@ -1,6 +1,5 @@ -ll <- NULL if (Sys.getenv("TSTTRGDIR") != "") { - ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir") + .libPaths(c(.libPaths(), paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir"))) } library(DBI) diff --git a/clients/R/Tests/deps-install.R b/clients/R/Tests/deps-install.R --- a/clients/R/Tests/deps-install.R +++ b/clients/R/Tests/deps-install.R @@ -3,6 +3,9 @@ dir.create(unlist(strsplit(Sys.getenv("R # autoinstall DBI and digest, we need those to install MonetDB.R dd <- capture.output(suppressMessages(suppressWarnings({ - install.packages(c("devtools", "digest"), repos="http://cran.rstudio.com/", quiet=T) + repos <- "http://cran.rstudio.com/" + lp <- c("devtools", "digest") + install.packages(lp, repos=repos, quiet=T) + update.packages(repos=repos, ask=F, oldPkgs=lp) devtools::install_github("rstats-db/DBI", quiet=T) }))) diff --git a/clients/R/Tests/deps-test.R b/clients/R/Tests/deps-test.R --- a/clients/R/Tests/deps-test.R +++ b/clients/R/Tests/deps-test.R @@ -5,6 +5,5 @@ dd <- capture.output(suppressMessages(su repos <- c('http://download.r-forge.r-project.org','http://cran.rstudio.com/') if(length(np)) install.packages(np,repos=repos, quiet=T) update.packages(repos=repos, ask=F, oldPkgs=lp, quiet=T) - x <- lapply(lp,function(x){library(x,character.only=TRUE,quietly=T)}) })(c('Rcpp', 'dplyr','survey','sqlsurvey','Lahman','nycflights13')) }))) diff --git a/clients/R/Tests/dplyr-flights.R b/clients/R/Tests/dplyr-flights.R --- a/clients/R/Tests/dplyr-flights.R +++ b/clients/R/Tests/dplyr-flights.R @@ -1,6 +1,5 @@ -ll <- NULL if (Sys.getenv("TSTTRGDIR") != "") { - ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir") + .libPaths(c(.libPaths(), paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir"))) } ff <- textConnection("asdf", open="w") # hide output from connect and attach since it would blow up the test output diff --git a/clients/R/Tests/dplyr-flights.stable.out b/clients/R/Tests/dplyr-flights.stable.out --- a/clients/R/Tests/dplyr-flights.stable.out +++ b/clients/R/Tests/dplyr-flights.stable.out @@ -30,25 +30,25 @@ Ready. # 11:44:05 > [1] TRUE -[1] 336776 16 -[1] 42 16 -[1] 42 16 -[1] 42 16 -[1] 42 16 -[1] 42 16 +[1] 336776 19 +[1] 42 19 +[1] 42 19 +[1] 42 19 +[1] 42 19 +[1] 42 19 [1] 42 3 [1] 42 3 -[1] 42 13 -[1] 42 1 [1] 42 16 [1] 42 1 +[1] 42 19 +[1] 42 1 [1] 42 2 -[1] 42 18 -[1] 42 18 +[1] 42 21 +[1] 42 21 [1] 42 2 [1] 1 1 -[1] 10 16 -[1] 42 16 +[1] 10 19 +[1] 42 19 [1] 42 3 [1] 42 4 [1] 42 4 diff --git a/clients/R/Tests/dplyr.R b/clients/R/Tests/dplyr.R --- a/clients/R/Tests/dplyr.R +++ b/clients/R/Tests/dplyr.R @@ -1,6 +1,5 @@ -ll <- NULL if (Sys.getenv("TSTTRGDIR") != "") { - ll <- paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir") + .libPaths(c(.libPaths(), paste0(Sys.getenv("TSTTRGDIR"),"/rlibdir"))) } ff <- textConnection("asdf", open="w") # hide output from connect and attach since it would blow up the test output diff --git a/clients/R/Tests/dplyr.timeout b/clients/R/Tests/dplyr.timeout new file mode 100644 --- /dev/null +++ b/clients/R/Tests/dplyr.timeout @@ -0,0 +1,1 @@ +2 diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -2290,10 +2290,6 @@ command batstr.startsWith(s:bat[:str],pr address STRbatPrefix; comment Prefix check. -command batstr.stringlength(s:bat[:str]):bat[:int] -address STRbatstringLength; -comment Return the length of a right trimed string. - command batstr.trim(s:bat[:str],s2:bat[:str]):bat[:str] address STRbatStrip2_bat; comment Strip characters in the second strings around the first strings. @@ -32599,10 +32595,6 @@ command str.startsWith(s:str,prefix:str) address STRPrefix; comment Prefix check. -command str.stringlength(s:str):int -address STRSQLLength; -comment Return the length of a right trimed string (SQL semantics). - command str.string(s:str,offset:int,count:int):str address STRSubString; comment Return substring s[offset..offset+count] of a string s[0..n] diff --git a/clients/Tests/MAL-signatures.stable.out.int128 b/clients/Tests/MAL-signatures.stable.out.int128 --- a/clients/Tests/MAL-signatures.stable.out.int128 +++ b/clients/Tests/MAL-signatures.stable.out.int128 @@ -2690,10 +2690,6 @@ command batstr.startsWith(s:bat[:str],pr address STRbatPrefix; comment Prefix check. -command batstr.stringlength(s:bat[:str]):bat[:int] -address STRbatstringLength; -comment Return the length of a right trimed string. - command batstr.trim(s:bat[:str],s2:bat[:str]):bat[:str] address STRbatStrip2_bat; comment Strip characters in the second strings around the first strings. @@ -42028,10 +42024,6 @@ command str.startsWith(s:str,prefix:str) address STRPrefix; comment Prefix check. -command str.stringlength(s:str):int -address STRSQLLength; -comment Return the length of a right trimed string (SQL semantics). - command str.string(s:str,offset:int,count:int):str address STRSubString; comment Return substring s[offset..offset+count] of a string s[0..n] diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -942,7 +942,6 @@ create filter function "ilike"(val strin create function sys.imprintsize(i bigint, nme string) returns bigint begin if nme = 'boolean' or nme = 'tinyint' or nme = 'smallint' or nme = 'int' or nme = 'bigint' or nme = 'hugeint' or nme = 'decimal' or nme = 'date' or nme = 'timestamp' or nme = 'real' or nme = 'double' then return cast(i * 0.12 as bigint); end if ; return 0; end; create function internaltransform(geom geometry, srid_src integer, srid_dest integer, proj4_src string, proj4_dest string) returns geometry external name geom."Transform"; create function isaurl(theurl url) returns bool external name url."isaURL"; -create function sys.isauuid(u uuid) returns boolean begin return true; end; create function sys.isauuid(s string) returns boolean external name uuid."isaUUID"; create function "left_shift"(i1 inet, i2 inet) returns boolean external name inet."<<"; create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; @@ -2033,7 +2032,6 @@ drop function pcre_replace(string, strin [ "sys", "internaltransform", "create function internaltransform(geom geometry, srid_src integer, srid_dest integer, proj4_src string, proj4_dest string) returns geometry external name geom.\"Transform\";", "geom", 1, 1, false, false, false ] [ "sys", "isaurl", "create function isaurl(theurl url) returns bool external name url.\"isaURL\";", "url", 1, 1, false, false, false ] [ "sys", "isauuid", "create function sys.isauuid(s string) returns boolean external name uuid.\"isaUUID\";", "uuid", 1, 1, false, false, false ] -[ "sys", "isauuid", "create function sys.isauuid(u uuid) returns boolean begin return true; end;", "user", 2, 1, false, false, false ] [ "sys", "isnull", "isnil", "calc", 0, 1, false, false, false ] [ "sys", "lcase", "toLower", "str", 0, 1, false, false, false ] [ "sys", "lcase", "toLower", "str", 0, 1, false, false, false ] @@ -2054,9 +2052,9 @@ drop function pcre_replace(string, strin [ "sys", "left_shift", "mbrLeft", "geom", 0, 1, false, false, false ] [ "sys", "left_shift", "mbrLeft", "geom", 0, 1, false, false, false ] [ "sys", "left_shift_assign", "create function \"left_shift_assign\"(i1 inet, i2 inet) returns boolean external name inet.\"<<=\";", "inet", 1, 1, false, false, false ] -[ "sys", "length", "stringlength", "str", 0, 1, false, false, false ] -[ "sys", "length", "stringlength", "str", 0, 1, false, false, false ] -[ "sys", "length", "stringlength", "str", 0, 1, false, false, false ] +[ "sys", "length", "length", "str", 0, 1, false, false, false ] +[ "sys", "length", "length", "str", 0, 1, false, false, false ] +[ "sys", "length", "length", "str", 0, 1, false, false, false ] [ "sys", "levenshtein", "levenshtein", "txtsim", 0, 1, false, false, false ] [ "sys", "levenshtein", "levenshtein", "txtsim", 0, 1, false, false, false ] [ "sys", "levenshtein", "levenshtein", "txtsim", 0, 1, false, false, false ] @@ -3588,7 +3586,6 @@ drop function pcre_replace(string, strin [ "sys", "internaltransform", "geom", "geometry", 0, 0, 1, "srid_src", "int", 32, 0, 1, "srid_dest", "int", 32, 0, 1, "proj4_src", "clob", 0, 0, 1, "proj4_dest", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "isaurl", "theurl", "url", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "isauuid", "s", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys", "isauuid", "u", "uuid", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "isnull", "arg_1", "any", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "lcase", "arg_1", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys", "lcase", "arg_1", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -5156,7 +5153,6 @@ drop function pcre_replace(string, strin [ "inet", "inet", "sys", "host", "TYPE_DEPENDENCY" ] [ "inet", "inet", "sys", "hostmask", "TYPE_DEPENDENCY" ] [ "url", "url", "sys", "isaurl", "TYPE_DEPENDENCY" ] -[ "uuid", "uuid", "sys", "isauuid", "TYPE_DEPENDENCY" ] [ "inet", "inet", "sys", "left_shift", "TYPE_DEPENDENCY" ] [ "inet", "inet", "sys", "left_shift_assign", "TYPE_DEPENDENCY" ] [ "inet", "inet", "sys", "masklen", "TYPE_DEPENDENCY" ] @@ -5596,7 +5592,6 @@ drop function pcre_replace(string, strin [ "isarray" ] [ "isaurl" ] [ "isauuid" ] -[ "isauuid" ] [ "isnull" ] [ "isobject" ] [ "isobject" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list