MonetDB: protocol - Compilation fixes.
Changeset: a5797937769b for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a5797937769b Modified Files: clients/mapiclient/mclient.c clients/mapilib/mapi.c common/utils/conversion.c monetdb5/modules/atoms/blob.c sql/backends/monet5/sql.c Branch: protocol Log Message: Compilation fixes. diffs (88 lines): diff --git a/clients/mapiclient/mclient.c b/clients/mapiclient/mclient.c --- a/clients/mapiclient/mclient.c +++ b/clients/mapiclient/mclient.c @@ -1048,8 +1048,8 @@ mapi_escape_name(char *name) { char *buffer = startbuffer; if (!startbuffer) return NULL; if (strchr(name, ',') || strchr(name, ' ') || strchr(name, '\t') || strchr(name, '#')) { + char *p; *buffer++ = '"'; - char *p; for (p = name; *p; p++) { if (*p == '"') { *buffer++ = '\\'; diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c --- a/clients/mapilib/mapi.c +++ b/clients/mapilib/mapi.c @@ -6236,10 +6236,6 @@ mapi_set_compute_column_width(Mapi mid, #define NUMERIC_CONVERSION(fromtpe, totpe, fromname, toname, MIN_VALUE, MAX_VALUE) \ case SQL_BINARY_##fromname: { \ - fromtpe val = *((fromtpe*)col->buffer_ptr); \ - if (val < MIN_VALUE || val > MAX_VALUE) { \ - return mapi_setError(hdl->mid, "Overflow when converting value.", "mapi_fetch_field_"#toname, MERROR); \ - } \ *retval = (totpe) *((fromtpe*)col->buffer_ptr); \ return MOK; \ } @@ -6251,11 +6247,15 @@ mapi_set_compute_column_width(Mapi mid, #define HGE_CONVERSION(fromtpe, totpe, fromname, toname, MIN_VALUE, MAX_VALUE) #endif -float STRTOF(const char *restrict str, char **restrict endptr, int base) { +static float +STRTOF(const char *restrict str, char **restrict endptr, int base) { + (void) base; return strtof(str, endptr); } -double STRTOD(const char *restrict str, char **restrict endptr, int base) { +static double +STRTOD(const char *restrict str, char **restrict endptr, int base) { + (void) base; return strtod(str, endptr); } @@ -6289,7 +6289,7 @@ mapi_fetch_field_##typename(MapiHdl hdl, } \ } \ /* string conversion */ \ - mapi_fetch_field(hdl, fnr); \ + val = mapi_fetch_field(hdl, fnr); \ if (hdl->mid->error != MOK) { \ return hdl->mid->error; \ }
MonetDB: protocol - Approve exports.
Changeset: 9d9dd3ff5dab for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9d9dd3ff5dab Modified Files: clients/Tests/exports.stable.out Branch: protocol Log Message: Approve exports. diffs (38 lines): diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out --- a/clients/Tests/exports.stable.out +++ b/clients/Tests/exports.stable.out @@ -518,7 +518,21 @@ MapiMsg mapi_explain_result(MapiHdl hdl, mapi_int64 mapi_fetch_all_rows(MapiHdl hdl); char *mapi_fetch_field(MapiHdl hdl, int fnr); char **mapi_fetch_field_array(MapiHdl hdl); +MapiMsg mapi_fetch_field_bigint(MapiHdl hdl, int fnr, mapi_int64 *result); +MapiMsg mapi_fetch_field_date(MapiHdl hdl, int fnr, short *year, unsigned short *month, unsigned short *day); +MapiMsg mapi_fetch_field_double(MapiHdl hdl, int fnr, double *result); +MapiMsg mapi_fetch_field_hge(MapiHdl hdl, int fnr, hge *result); +MapiMsg mapi_fetch_field_int(MapiHdl hdl, int fnr, signed int *result); size_t mapi_fetch_field_len(MapiHdl hdl, int fnr); +MapiMsg mapi_fetch_field_real(MapiHdl hdl, int fnr, float *result); +MapiMsg mapi_fetch_field_smallint(MapiHdl hdl, int fnr, signed short *result); +MapiMsg mapi_fetch_field_time(MapiHdl hdl, int fnr, unsigned short *hour, unsigned short *min, unsigned short *sec, unsigned int *nanosecond); +MapiMsg mapi_fetch_field_timestamp(MapiHdl hdl, int fnr, short *year, unsigned short *month, unsigned short *day, unsigned short *hour, unsigned short *min, unsigned short *sec, unsigned int *nanosecond); +MapiMsg mapi_fetch_field_tinyint(MapiHdl hdl, int fnr, signed char *result); +MapiMsg mapi_fetch_field_ubigint(MapiHdl hdl, int fnr, mapi_uint64 *result); +MapiMsg mapi_fetch_field_uint(MapiHdl hdl, int fnr, unsigned int *result); +MapiMsg mapi_fetch_field_usmallint(MapiHdl hdl, int fnr, unsigned short *result); +MapiMsg mapi_fetch_field_utinyint(MapiHdl hdl, int fnr, unsigned char *result); char *mapi_fetch_line(MapiHdl hdl); MapiMsg mapi_fetch_reset(MapiHdl hdl); int mapi_fetch_row(MapiHdl hdl); @@ -2534,9 +2548,11 @@ stream *append_wstream(const char *filen stream *block_stream(stream *s); stream *block_stream2(stream *s, size_t bufsiz, compression_method comp, column_compression colcomp); buffer bs2_buffer(stream *s); -void *bs2_getbuf(stream *ss); +column_compression bs2_colcomp(stream *ss); void bs2_resetbuf(stream *ss); +int bs2_resizebuf(stream *ss, size_t bufsiz); void bs2_setpos(stream *ss, size_t pos); +void *bs2_stealbuf(stream *ss); stream *bs_stream(stream *s); bstream *bstream_create(stream *rs, size_t chunk_size); void bstream_destroy(bstream *s); ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Binary transfer of OIDs.
Changeset: 0abd6899dec2 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0abd6899dec2 Modified Files: clients/mapilib/mapi.c sql/backends/monet5/sql_result.c Branch: protocol Log Message: Binary transfer of OIDs. diffs (44 lines): diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c --- a/clients/mapilib/mapi.c +++ b/clients/mapilib/mapi.c @@ -4110,6 +4110,17 @@ mapi_string_conversion_function(int,date mapi_string_conversion_function(hge,hge,hugeint,); #endif +static char* mapi_convert_oid(struct MapiColumn *col) { + int length; + if (*((lng*) col->buffer_ptr) == *((lng*) col->null_value)) return NULL; + length = conversion_lng_to_string(col->write_buf, COLBUFSIZ, (lng*) col->buffer_ptr, *((lng*) col->null_value)); + if (length < 0) return NULL; + col->write_buf[length++] = '@'; + col->write_buf[length++] = '0'; + col->write_buf[length++] = '\0'; + return (char*) col->write_buf; +} + static char* mapi_convert_decimal(struct MapiColumn *col) { if (conversion_decimal_to_string(col->buffer_ptr, col->write_buf, COLBUFSIZ, col->scale, col->typelen, col->null_value) < 0) { return NULL; @@ -4342,6 +4353,9 @@ read_into_cache(MapiHdl hdl, int lookahe } else if (strcasecmp(type_sql_name, "bigint") == 0) { result->fields[i].sql_type = SQL_BINARY_BIGINT; result->fields[i].converter = (mapi_converter) mapi_convert_bigint; + } else if (strcasecmp(type_sql_name, "oid") == 0) { + result->fields[i].sql_type = SQL_BINARY_BIGINT; + result->fields[i].converter = (mapi_converter) mapi_convert_oid; } else if (strcasecmp(type_sql_name, "real") == 0) { result->fields[i].sql_type = SQL_BINARY_REAL; result->fields[i].converter = (mapi_converter) mapi_convert_real; diff --git a/sql/backends/monet5/sql_result.c b/sql/backends/monet5/sql_result.c --- a/sql/backends/monet5/sql_result.c +++ b/sql/backends/monet5/sql_result.c @@ -1826,7 +1826,8 @@ static int write_str_term(stream* s, con static int type_supports_binary_transfer(sql_type *type) { return - type->eclass == EC_BIT || + type->eclass == EC_BIT || + type->eclass == EC_POS || type->eclass == EC_CHAR || type->eclass == EC_STRING || type->eclass == EC_DEC || ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Always print leading zero for timezone display.
Changeset: 4537d302a159 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4537d302a159 Modified Files: clients/mapiclient/mclient.c common/utils/conversion.c common/utils/conversion.h Branch: protocol Log Message: Always print leading zero for timezone display. diffs (56 lines): diff --git a/clients/mapiclient/mclient.c b/clients/mapiclient/mclient.c --- a/clients/mapiclient/mclient.c +++ b/clients/mapiclient/mclient.c @@ -1047,7 +1047,7 @@ mapi_escape_name(char *name) { char *startbuffer = malloc(strlen(name) * 2 + 2); char *buffer = startbuffer; if (!startbuffer) return NULL; - if (strchr(name, ',') || strchr(name, '\t') || strchr(name, '#')) { + if (strchr(name, ',') || strchr(name, ' ') || strchr(name, '\t') || strchr(name, '#')) { *buffer++ = '"'; char *p; for (p = name; *p; p++) { diff --git a/common/utils/conversion.c b/common/utils/conversion.c --- a/common/utils/conversion.c +++ b/common/utils/conversion.c @@ -320,7 +320,7 @@ conversion_time_optional_tz_to_string(ch diff_hour = timezone_diff / 360; timezone_diff -= diff_hour * 360; diff_min = timezone_diff / 6; - if ((res = snprintf(dst + (9 + digits), len - (9 + digits), "%s%02d:%02d", original_diff >= 0 ? "+" : "", diff_hour, diff_min)) < 0) { + if ((res = snprintf(dst + (9 + digits), len - (9 + digits), "%s%02d:%02d", original_diff >= 0 ? "+" : "-", abs(diff_hour), diff_min)) < 0) { return res; } return 15 + digits; @@ -390,7 +390,7 @@ conversion_epoch_optional_tz_to_string(c diff_hour = timezone_diff / 360; timezone_diff -= diff_hour * 360; diff_min = timezone_diff / 6; - if ((res = snprintf(dst + res, len - res, "%s%02d:%02d", original_diff >= 0 ? "+" : "", diff_hour, diff_min)) < 0) { + if ((res = snprintf(dst + res, len - res, "%s%02d:%02d", original_diff >= 0 ? "+" : "-", abs(diff_hour), diff_min)) < 0) { return res; } return res; diff --git a/common/utils/conversion.h b/common/utils/conversion.h --- a/common/utils/conversion.h +++ b/common/utils/conversion.h @@ -66,7 +66,6 @@ void conversion_date_get_data(int date, int conversion_time_to_string(char *dst, int len, const int *src, int null_value, int digits); int conversion_timetz_to_string(char *dst, int len, const int *src, int null_value, int digits, int timezone_diff); - void conversion_time_get_data(int time, int timezone_diff, unsigned short *hour, unsigned short *minute, unsigned short *second, unsigned int *nanosecond); // timestamp conversion, *src is time since epoch in ms @@ -75,11 +74,7 @@ int conversion_epoch_tz_to_string(char * void conversion_timestamp_get_data(lng timestamp, int timezone_diff, short *year, unsigned short *month, unsigned short *day, unsigned short *hour, unsigned short *minute, unsigned short *second, unsigned int *nanosecond); - // blobs are converted to strings in hexadecimal format (i.e. two characters per byte) int conversion_blob_to_string(char *dst, int len, const char *blobdata, size_t nitems); - - - #endif ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Use digits to determine timestamp printing p...
Changeset: 51697805b5d0 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=51697805b5d0 Modified Files: clients/mapilib/mapi.c common/utils/conversion.c common/utils/conversion.h sql/backends/monet5/sql_result.c Branch: protocol Log Message: Use digits to determine timestamp printing precision. diffs (117 lines): diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c --- a/clients/mapilib/mapi.c +++ b/clients/mapilib/mapi.c @@ -4135,7 +4135,7 @@ static char* mapi_convert_timetz(struct static char* mapi_convert_timestamp(struct MapiColumn *col) { if (*((lng*) col->buffer_ptr) == *((lng*)col->null_value)) return NULL; - if (conversion_epoch_to_string(col->write_buf, COLBUFSIZ, (lng*) col->buffer_ptr, *((lng*)col->null_value)) < 0) { + if (conversion_epoch_to_string(col->write_buf, COLBUFSIZ, (lng*) col->buffer_ptr, *((lng*)col->null_value), col->digits) < 0) { return NULL; } return (char*) col->write_buf; @@ -4143,7 +4143,7 @@ static char* mapi_convert_timestamp(stru static char* mapi_convert_timestamptz(struct MapiColumn *col) { if (*((lng*) col->buffer_ptr) == *((lng*)col->null_value)) return NULL; - if (conversion_epoch_tz_to_string(col->write_buf, COLBUFSIZ, (lng*) col->buffer_ptr, *((lng*)col->null_value), col->timezone) < 0) { + if (conversion_epoch_tz_to_string(col->write_buf, COLBUFSIZ, (lng*) col->buffer_ptr, *((lng*)col->null_value), col->digits, col->timezone) < 0) { return NULL; } return (char*) col->write_buf; diff --git a/common/utils/conversion.c b/common/utils/conversion.c --- a/common/utils/conversion.c +++ b/common/utils/conversion.c @@ -323,6 +323,7 @@ conversion_time_optional_tz_to_string(ch if ((res = snprintf(dst + (9 + digits), len - (9 + digits), "%s%02d:%02d", original_diff >= 0 ? "+" : "", diff_hour, diff_min)) < 0) { return res; } + return 15 + digits; } return 9 + digits; } @@ -360,17 +361,28 @@ conversion_timestamp_get_data(lng time, conversion_date_get_data(days, year, month, day); } static int -conversion_epoch_optional_tz_to_string(char *dst, int len, const lng *src, lng null_value, int include_timezone, int timezone_diff) { +conversion_epoch_optional_tz_to_string(char *dst, int len, const lng *src, lng null_value, int digits, int include_timezone, int timezone_diff) { short year; unsigned short month, day, hour, min, sec; unsigned int nanosecond; lng time = *src; + int res = 0; if (*src == null_value) { strcpy(dst, NULL_STRING); return 3; } conversion_timestamp_get_data(*src, timezone_diff, &year, &month, &day, &hour, &min, &sec, &nanosecond); + + if ((res = snprintf(dst, len, "%d-%02d-%02d %02d:%02d:%02d.%06d", year, month, day, hour, min, sec, nanosecond)) < 0) { + return res; + } + digits--; + if (digits == 0) digits = -1; + res += digits - 6; + // adjust displayed precision based on the digits + dst[res] = '\0'; + if (include_timezone) { int diff_hour, diff_min; int original_diff = timezone_diff; @@ -378,19 +390,22 @@ conversion_epoch_optional_tz_to_string(c diff_hour = timezone_diff / 360; timezone_diff -= diff_hour * 360; diff_min = timezone_diff / 6; - return snprintf(dst, len, "%d-%02d-%02d %02d:%02d:%02d.%06d%s%02d:%02d", year, month, day, hour, min, sec, nanosecond, original_diff >= 0 ? "+" : "", diff_hour, diff_min); + if ((res = snprintf(dst + res, len - res, "%s%02d:%02d", original_diff >= 0 ? "+" : "", diff_hour, diff_min)) < 0) { + return res; + } + return res; } - return snprintf(dst, len, "%d-%02d-%02d %02d:%02d:%02d.%06d", year, month, day, hour, min, sec, nanosecond); + return res; } int -conversion_epoch_to_string(char *dst, int len, const lng *src, lng null_value) { - return conversion_epoch_optional_tz_to_string(dst, len, src, null_value, 0, 0); +conversion_epoch_to_string(char *dst, int len, const lng *src, lng null_value, int digits) { + return conversion_epoch_optional_tz_to_string(dst, len, src, null_value, digits, 0, 0); } int -conversion_epoch_tz_to_string(char *dst, int len, const lng *src, lng null_value, int timezone_diff) { - return conversion_epoch_optional_tz_to_string(dst, len, src, null_value, 1, timezone_diff); +conversion_epoch_tz_to_string(char *dst, int len, const lng *src, lng null_value, int digits, int timezone_diff) { + return conversion_epoch_optional_tz_to_string(dst, len, src, null_value, digits, 1, timezone_diff); } static char hexit[] = "0123456789ABCDEF"; diff
MonetDB: protocol - Fix bug with NULL blobs.
Changeset: 300ed9c0c27a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=300ed9c0c27a Modified Files: sql/backends/monet5/sql_result.c Branch: protocol Log Message: Fix bug with NULL blobs. diffs (12 lines): diff --git a/sql/backends/monet5/sql_result.c b/sql/backends/monet5/sql_result.c --- a/sql/backends/monet5/sql_result.c +++ b/sql/backends/monet5/sql_result.c @@ -2059,7 +2059,7 @@ int mvc_export_resultset_prot10(mvc *m, if (convert_to_string || ATOMvarsized(mtype)) { if (c->type.type->eclass == EC_BLOB) { blob *b = (blob*) BUNtail(iterators[i], row); - rowsize += sizeof(lng) + b->nitems == ~(size_t) 0 ? 0 : b->nitems; + rowsize += sizeof(lng) + (b->nitems == ~(size_t) 0) ? 0 : b->nitems; } else { size_t slen = strlen((const char*) BUNtail(iterators[i], row)); rowsize += slen + 1; ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Add support for TIMETZ type.
Changeset: e4ef92ec4acf for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e4ef92ec4acf Modified Files: clients/mapilib/mapi.c common/utils/conversion.c common/utils/conversion.h Branch: protocol Log Message: Add support for TIMETZ type. diffs (98 lines): diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c --- a/clients/mapilib/mapi.c +++ b/clients/mapilib/mapi.c @@ -4119,7 +4119,15 @@ static char* mapi_convert_decimal(struct static char* mapi_convert_time(struct MapiColumn *col) { if (*((int*) col->buffer_ptr) == *((int*)col->null_value)) return NULL; - if (conversion_time_to_string(col->write_buf, COLBUFSIZ, (int*) col->buffer_ptr, *((int*)col->null_value), col->digits, 0) < 0) { + if (conversion_time_to_string(col->write_buf, COLBUFSIZ, (int*) col->buffer_ptr, *((int*)col->null_value), col->digits) < 0) { + return NULL; + } + return (char*) col->write_buf; +} + +static char* mapi_convert_timetz(struct MapiColumn *col) { + if (*((int*) col->buffer_ptr) == *((int*)col->null_value)) return NULL; + if (conversion_timetz_to_string(col->write_buf, COLBUFSIZ, (int*) col->buffer_ptr, *((int*)col->null_value), col->digits, col->timezone) < 0) { return NULL; } return (char*) col->write_buf; @@ -4345,6 +4353,10 @@ read_into_cache(MapiHdl hdl, int lookahe } else if (strcasecmp(type_sql_name, "time") == 0) { result->fields[i].sql_type = SQL_BINARY_TIME; result->fields[i].converter = (mapi_converter) mapi_convert_time; + } else if (strcasecmp(type_sql_name, "timetz") == 0) { + result->fields[i].sql_type = SQL_BINARY_TIMETZ; + result->fields[i].timezone = timezone; + result->fields[i].converter = (mapi_converter) mapi_convert_timetz; } else if (strcasecmp(type_sql_name, "timestamp") == 0) { result->fields[i].sql_type = SQL_BINARY_TIMESTAMP; result->fields[i].converter = (mapi_converter) mapi_convert_timestamp; diff --git a/common/utils/conversion.c b/common/utils/conversion.c --- a/common/utils/conversion.c +++ b/common/utils/conversion.c @@ -292,8 +292,8 @@ conversion_time_get_data(int time, int t } -int -conversion_time_to_string(char *dst, int len, const int *src, int null_value, int digits, int timezone_diff) { +static int +conversion_time_optional_tz_to_string(char *dst, int len, const int *src, int null_value, int digits, int include_timezone, int timezone_diff) { unsigned short hour, min, sec; unsigned int nanosecond; int res = 0; @@ -305,16 +305,36 @@ conversion_time_to_string(char *dst, int conversion_time_get_data(*src, timezone_diff, &hour, &min, &sec, &nanosecond); - if ((res = sprintf(dst, "%02d:%02d:%02d.%06d", hour, min, sec, nanosecond)) < 0) { + if ((res = snprintf(dst, len, "%02d:%02d:%02d.%06d", hour, min, sec, nanosecond)) < 0) { return res; } digits--; if (digits == 0) digits = -1; // adjust displayed precision based on the digits dst[9 + digits] = '\0'; + + if (include_timezone) { + int diff_hour, diff_min; + int original_diff = timezone_diff; + + diff_hour = timezone_diff / 360; + timezone_diff -= diff_hour * 360; + diff_min = timezone_diff / 6; + if ((res = snprintf(dst + (9 + digits), len - (9 + digits), "%s%02d:%02d", original_diff >= 0 ? "+" : "", diff_hour, diff_min)) < 0) { + return res; + } + } return 9 + digits; } +int conversion_time_to_string(char *dst, int len, const int *src, int null_value, int digits) { + return conversion_time_optional_tz_to_string(dst, len, src, null_value, digits, 0, 0); +} + +int conversion_timetz_to_string(char *dst, int len, const int *src, int null_value, int digits, int timezone_diff) { + return conversion_time_optional_tz_to_string(dst, len, src, null_value, digits, 1, timezone_diff); +} + static int days_between_zero_and_epoch = 719528; void diff --git a/common/utils/conversion.h b/common/utils/conversion.h --- a/common/utils/conversion.h +++ b/common/utils/conversion.h @@ -63,7 +63,10 @@ int conversion_date_to_string(char *dst, void conversion_date_get_data(int date, short *year, unsigned short *month, unsigned short *day); // time conversion, *src is ms since 00:00:00 -int conversion_time_to_string(char *dst, int len, const int *src, int null_value, int digits, int timezone_diff); +int conversion_time_to_string(char *dst, int
MonetDB: protocol - Deal with NULL blobs correctly.
Changeset: 209f5381b23e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=209f5381b23e Modified Files: sql/backends/monet5/sql_result.c Branch: protocol Log Message: Deal with NULL blobs correctly. diffs (32 lines): diff --git a/sql/backends/monet5/sql_result.c b/sql/backends/monet5/sql_result.c --- a/sql/backends/monet5/sql_result.c +++ b/sql/backends/monet5/sql_result.c @@ -2059,7 +2059,7 @@ int mvc_export_resultset_prot10(mvc *m, if (convert_to_string || ATOMvarsized(mtype)) { if (c->type.type->eclass == EC_BLOB) { blob *b = (blob*) BUNtail(iterators[i], row); - rowsize += sizeof(lng) + b->nitems; + rowsize += sizeof(lng) + b->nitems == ~(size_t) 0 ? 0 : b->nitems; } else { size_t slen = strlen((const char*) BUNtail(iterators[i], row)); rowsize += slen + 1; @@ -2143,10 +2143,15 @@ int mvc_export_resultset_prot10(mvc *m, buf += sizeof(lng); for (crow = srow; crow < row; crow++) { blob *b = (blob*) BUNtail(iterators[i], crow); - (*(lng*)buf) = b->nitems == ~(size_t) 0 ? -1 : (lng) b->nitems; - buf += sizeof(lng); - memcpy(buf, b->data, b->nitems); - buf += b->nitems; + if (b->nitems == ~(size_t) 0) { + (*(lng*)buf) = -1; + buf += sizeof(lng); + } else { + (*(lng*)buf) = (lng) b->nitems; + buf += sizeof(lng); + memcpy(buf, b->data, b->nitems); + buf += b->nitems; + } } // after the loop we know the size of the column, so write it *((lng*)startbuf) = buf - (startbuf + sizeof(lng)); ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: HTM - remove garbage files and correct stable.{err,out}
Changeset: 4a9fd46f3f01 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4a9fd46f3f01 Removed Files: sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-1.stable.err-- sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-1.stable.out-- sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-2.stable.err-- sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-2.stable.out-- sql/test/2-phase-commit/Tests/InsertWithCommitDeleteWith2PC-1.stable.err-- sql/test/2-phase-commit/Tests/InsertWithCommitDeleteWith2PC-1.stable.out-- sql/test/2-phase-commit/Tests/InsertWithCommitDeleteWith2PC-2.stable.err-- sql/test/2-phase-commit/Tests/InsertWithCommitDeleteWith2PC-2.stable.out-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-1.stable.err-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-1.stable.out-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-2.stable.err-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-2.stable.out-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-cleanup.stable.err-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-cleanup.stable.out-- sql/test/2-phase-commit/Tests/MultipleConnections-cleanup.stable.err-- sql/test/2-phase-commit/Tests/MultipleConnections-cleanup.stable.out-- sql/test/2-phase-commit/Tests/MultipleConnectionsAllWithAutocommit.stable.err-- sql/test/2-phase-commit/Tests/MultipleConnectionsAllWithAutocommit.stable.out-- sql/test/2-phase-commit/Tests/NonUpdatePrecommitReturns0.stable.err-- sql/test/2-phase-commit/Tests/NonUpdatePrecommitReturns0.stable.out-- sql/test/2-phase-commit/Tests/PersistBeforePrecommit-1.stable.err-- sql/test/2-phase-commit/Tests/PersistBeforePrecommit-1.stable.out-- sql/test/2-phase-commit/Tests/PersistBeforePrecommit-2.stable.err-- sql/test/2-phase-commit/Tests/PersistBeforePrecommit-2.stable.out-- sql/test/2-phase-commit/Tests/PersistBeforePrecommitWithRollback-1.stable.err-- sql/test/2-phase-commit/Tests/PersistBeforePrecommitWithRollback-1.stable.out-- sql/test/2-phase-commit/Tests/PersistBeforePrecommitWithRollback-2.stable.err-- sql/test/2-phase-commit/Tests/PersistBeforePrecommitWithRollback-2.stable.out-- sql/test/2-phase-commit/Tests/PrecommitWithoutPersists-1.stable.err-- sql/test/2-phase-commit/Tests/PrecommitWithoutPersists-1.stable.out-- sql/test/2-phase-commit/Tests/PrecommitWithoutPersists-2.stable.err-- sql/test/2-phase-commit/Tests/PrecommitWithoutPersists-2.stable.out-- sql/test/2-phase-commit/Tests/ReadsItsOwnWrites-cleanup.stable.err-- sql/test/2-phase-commit/Tests/ReadsItsOwnWrites-cleanup.stable.out-- sql/test/2-phase-commit/Tests/ReadsItsOwnWrites.stable.err-- sql/test/2-phase-commit/Tests/ReadsItsOwnWrites.stable.out-- sql/test/2-phase-commit/Tests/RollbackAfterPersistcommitHasNoEffect-1.stable.err-- sql/test/2-phase-commit/Tests/RollbackAfterPersistcommitHasNoEffect-1.stable.out-- sql/test/2-phase-commit/Tests/RollbackAfterPersistcommitHasNoEffect-2.stable.err-- sql/test/2-phase-commit/Tests/RollbackAfterPersistcommitHasNoEffect-2.stable.out-- sql/test/2-phase-commit/Tests/RollbackAfterPrecommit-1.stable.err-- sql/test/2-phase-commit/Tests/RollbackAfterPrecommit-1.stable.out-- sql/test/2-phase-commit/Tests/RollbackAfterPrecommit-2.stable.err-- sql/test/2-phase-commit/Tests/RollbackAfterPrecommit-2.stable.out-- sql/test/2-phase-commit/Tests/RollbackBeforePrecommit-1.stable.err-- sql/test/2-phase-commit/Tests/RollbackBeforePrecommit-1.stable.out-- sql/test/2-phase-commit/Tests/RollbackBeforePrecommit-2.stable.err-- sql/test/2-phase-commit/Tests/RollbackBeforePrecommit-2.stable.out-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-1.stable.err-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-1.stable.out-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-2.stable.err-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-2.stable.out-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-3.stable.err-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-3.stable.out-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-4.stable.err-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-4.stable.out-- sql/test/2-phase-commit/Tests/TwoInsetsIn1Transaction.stable.err-- sql/test/2-phase-commit/Tests/TwoInsetsIn1Transaction.stable.out-- sql/test/2-phase-commit/Tests/setup.stable.err-- sql/test/2-phase-commit/Tests/setup.stable.out-- Modified Files: sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-1.stable.err sql/test/2-phase-commit/
MonetDB: 2PC - Remove garbage files
Changeset: ab30dbc72c9c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ab30dbc72c9c Removed Files: sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-1.stable.err-- sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-1.stable.out-- sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-2.stable.err-- sql/test/2-phase-commit/Tests/InsertWith2PCDeleteWithCommit-2.stable.out-- sql/test/2-phase-commit/Tests/InsertWithCommitDeleteWith2PC-1.stable.err-- sql/test/2-phase-commit/Tests/InsertWithCommitDeleteWith2PC-1.stable.out-- sql/test/2-phase-commit/Tests/InsertWithCommitDeleteWith2PC-2.stable.err-- sql/test/2-phase-commit/Tests/InsertWithCommitDeleteWith2PC-2.stable.out-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-1.stable.err-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-1.stable.out-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-2.stable.err-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-2.stable.out-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-cleanup.stable.err-- sql/test/2-phase-commit/Tests/MixTransactionPrecommit-cleanup.stable.out-- sql/test/2-phase-commit/Tests/MultipleConnections-cleanup.stable.err-- sql/test/2-phase-commit/Tests/MultipleConnections-cleanup.stable.out-- sql/test/2-phase-commit/Tests/MultipleConnectionsAllWithAutocommit.stable.err-- sql/test/2-phase-commit/Tests/MultipleConnectionsAllWithAutocommit.stable.out-- sql/test/2-phase-commit/Tests/NonUpdatePrecommitReturns0.stable.err-- sql/test/2-phase-commit/Tests/NonUpdatePrecommitReturns0.stable.out-- sql/test/2-phase-commit/Tests/PersistBeforePrecommit-1.stable.err-- sql/test/2-phase-commit/Tests/PersistBeforePrecommit-1.stable.out-- sql/test/2-phase-commit/Tests/PersistBeforePrecommit-2.stable.err-- sql/test/2-phase-commit/Tests/PersistBeforePrecommit-2.stable.out-- sql/test/2-phase-commit/Tests/PersistBeforePrecommitWithRollback-1.stable.err-- sql/test/2-phase-commit/Tests/PersistBeforePrecommitWithRollback-1.stable.out-- sql/test/2-phase-commit/Tests/PersistBeforePrecommitWithRollback-2.stable.err-- sql/test/2-phase-commit/Tests/PersistBeforePrecommitWithRollback-2.stable.out-- sql/test/2-phase-commit/Tests/PrecommitWithoutPersists-1.stable.err-- sql/test/2-phase-commit/Tests/PrecommitWithoutPersists-1.stable.out-- sql/test/2-phase-commit/Tests/PrecommitWithoutPersists-2.stable.err-- sql/test/2-phase-commit/Tests/PrecommitWithoutPersists-2.stable.out-- sql/test/2-phase-commit/Tests/ReadsItsOwnWrites-cleanup.stable.err-- sql/test/2-phase-commit/Tests/ReadsItsOwnWrites-cleanup.stable.out-- sql/test/2-phase-commit/Tests/ReadsItsOwnWrites.stable.err-- sql/test/2-phase-commit/Tests/ReadsItsOwnWrites.stable.out-- sql/test/2-phase-commit/Tests/RollbackAfterPersistcommitHasNoEffect-1.stable.err-- sql/test/2-phase-commit/Tests/RollbackAfterPersistcommitHasNoEffect-1.stable.out-- sql/test/2-phase-commit/Tests/RollbackAfterPersistcommitHasNoEffect-2.stable.err-- sql/test/2-phase-commit/Tests/RollbackAfterPersistcommitHasNoEffect-2.stable.out-- sql/test/2-phase-commit/Tests/RollbackAfterPrecommit-1.stable.err-- sql/test/2-phase-commit/Tests/RollbackAfterPrecommit-1.stable.out-- sql/test/2-phase-commit/Tests/RollbackAfterPrecommit-2.stable.err-- sql/test/2-phase-commit/Tests/RollbackAfterPrecommit-2.stable.out-- sql/test/2-phase-commit/Tests/RollbackBeforePrecommit-1.stable.err-- sql/test/2-phase-commit/Tests/RollbackBeforePrecommit-1.stable.out-- sql/test/2-phase-commit/Tests/RollbackBeforePrecommit-2.stable.err-- sql/test/2-phase-commit/Tests/RollbackBeforePrecommit-2.stable.out-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-1.stable.err-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-1.stable.out-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-2.stable.err-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-2.stable.out-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-3.stable.err-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-3.stable.out-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-4.stable.err-- sql/test/2-phase-commit/Tests/TestAutocommitUpdates-4.stable.out-- sql/test/2-phase-commit/Tests/TwoInsetsIn1Transaction.stable.err-- sql/test/2-phase-commit/Tests/TwoInsetsIn1Transaction.stable.out-- sql/test/2-phase-commit/Tests/setup.stable.err-- sql/test/2-phase-commit/Tests/setup.stable.out-- Branch: 2PC Log Message: Remove garbage files diffs (truncated from 2985 to 300 lines): diff --git a/sql/test/2-phase-commit
MonetDB: protocol - Don't use -fraw in tests because it makes no...
Changeset: de3ee2290202 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=de3ee2290202 Modified Files: sql/test/mapi/Tests/utf8test.SQL.py sql/test/mapi/Tests/utf8test.stable.out Branch: protocol Log Message: Don't use -fraw in tests because it makes no sense with the new protocol, now use -fcsv. diffs (79 lines): diff --git a/sql/test/mapi/Tests/utf8test.SQL.py b/sql/test/mapi/Tests/utf8test.SQL.py --- a/sql/test/mapi/Tests/utf8test.SQL.py +++ b/sql/test/mapi/Tests/utf8test.SQL.py @@ -23,13 +23,13 @@ sys.stderr.write(err) out, err = client(['-s', "insert into utf8test values ('funny characters: %s')" % funny]) sys.stdout.write(out) sys.stderr.write(err) -out, err = client(['-fraw', '-s', 'select * from utf8test']) +out, err = client(['-fcsv', '-s', 'select * from utf8test']) sys.stdout.write(out) sys.stderr.write(err) out, err = client(['-fsql', '-s', 'select * from utf8test']) sys.stdout.write(out) sys.stderr.write(err) -out, err = client(['-fraw', '-Eiso-8859-1', '-s', 'select * from utf8test'], +out, err = client(['-fcsv', '-Eiso-8859-1', '-s', 'select * from utf8test'], universal_newlines = False) out = out.decode('iso-8859-1') err = err.decode('iso-8859-1') @@ -47,7 +47,7 @@ if sys.version_info[0] == 2: err = err.encode('utf-8') sys.stdout.write(out) sys.stderr.write(err) -out, err = client(['-fraw', '-Eus-ascii', '-s', 'select * from utf8test'], +out, err = client(['-fcsv', '-Eus-ascii', '-s', 'select * from utf8test'], universal_newlines = False) out = out.decode('us-ascii') err = err.decode('us-ascii') diff --git a/sql/test/mapi/Tests/utf8test.stable.out b/sql/test/mapi/Tests/utf8test.stable.out --- a/sql/test/mapi/Tests/utf8test.stable.out +++ b/sql/test/mapi/Tests/utf8test.stable.out @@ -44,17 +44,8 @@ Ready. # 10:26:28 > [ 1] - -# 10:26:28 > -# 10:26:28 > Mtimeout -timeout 60 mclient -lsql -umonetdb -Pmonetdb --host=ottar --port=32641 -fraw -s 'select * from utf8test' -# 10:26:28 > - -% sys.utf8test # table_name -% s # name -% varchar # type -% 32 # length -[ "value without special characters" ] -[ "funny characters: à áâãäå" ] +value without special characters +funny characters: à áâãäå select * from utf8test +--+ | s| @@ -63,12 +54,8 @@ select * from utf8test | funny characters: à áâãäå | +--+ 2 tuples -% sys.utf8test # table_name -% s # name -% varchar # type -% 32 # length -[ "value without special characters" ] -[ "funny characters: à áâãäå" ] +value without special characters +funny characters: à áâãäå select * from utf8test +--+ | s| @@ -77,11 +64,7 @@ select * from utf8test | funny characters: à áâãäå | +--+ 2 tuples -% sys.utf8test # table_name -% s # name -% varchar # type -% 32 # length -[ "value without special characters" ] +value without special characters select * from utf8test +--+ | s| ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Implement mapi_fetch_all_rows.
Changeset: b372bf9457d3 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b372bf9457d3 Modified Files: clients/mapilib/mapi.c Branch: protocol Log Message: Implement mapi_fetch_all_rows. diffs (13 lines): diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c --- a/clients/mapilib/mapi.c +++ b/clients/mapilib/mapi.c @@ -5814,6 +5814,9 @@ mapi_fetch_all_rows(MapiHdl hdl) mnstr_flush(mid->to)) check_stream(mid, mid->to, mnstr_error(mid->to), "mapi_fetch_line", 0); } + if (result->prot10_resultset) { + return result->row_count; + } if (mid->active) read_into_cache(mid->active, 0); else ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Add mapi_fetch_field_[type] family of functi...
Changeset: 8a3d8e27b790 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8a3d8e27b790 Modified Files: clients/mapilib/mapi.c clients/mapilib/mapi.h common/utils/conversion.c common/utils/conversion.h Branch: protocol Log Message: Add mapi_fetch_field_[type] family of functions to avoid unnecessary string conversion function, and implement mapi_store_bind functions. diffs (truncated from 895 to 300 lines): diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c --- a/clients/mapilib/mapi.c +++ b/clients/mapilib/mapi.c @@ -840,6 +840,7 @@ struct MapiColumn { size_t dynamic_write_bufsiz; char write_buf[COLBUFSIZ]; mapi_converter converter; + binary_sql_type sql_type; }; /* information about bound columns */ @@ -4289,12 +4290,15 @@ read_into_cache(MapiHdl hdl, int lookahe result->fields[i].dynamic_write_buf = NULL; result->fields[i].dynamic_write_bufsiz = 0; result->fields[i].converter = NULL; + result->fields[i].sql_type = SQL_BINARY_UNKNOWN; if (strcasecmp(type_sql_name, "blob") == 0) { + result->fields[i].sql_type = SQL_BINARY_BLOB; result->fields[i].converter = (mapi_converter) mapi_convert_blob; } else if (result->fields[i].null_value == NULL) { result->fields[i].converter = (mapi_converter) mapi_convert_null; } else if (strcasecmp(type_sql_name, "varchar") == 0 || strcasecmp(type_sql_name, "char") == 0) { + result->fields[i].sql_type = SQL_BINARY_VARCHAR; if (typelen > 0) { result->fields[i].converter = (mapi_converter) mapi_convert_varchar; result->fields[i].dynamic_write_bufsiz = result->fields[i].typelen * sizeof(char); @@ -4303,38 +4307,53 @@ read_into_cache(MapiHdl hdl, int lookahe result->fields[i].converter = (mapi_converter) mapi_convert_clob; } } else if (strcasecmp(type_sql_name, "clob") == 0) { + result->fields[i].sql_type = SQL_BINARY_CLOB; // var length strings result->fields[i].converter = (mapi_converter) mapi_convert_clob; } else if (strcasecmp(type_sql_name, "int") == 0 || strcasecmp(type_sql_name, "month_interval") == 0) { + result->fields[i].sql_type = SQL_BINARY_INT; result->fields[i].converter = (mapi_converter) mapi_convert_int; } else if (strcasecmp(type_sql_name, "smallint") == 0) { + result->fields[i].sql_type = SQL_BINARY_SMALLINT; result->fields[i].converter = (mapi_converter) mapi_convert_smallint; } else if (strcasecmp(type_sql_name, "tinyint") == 0) { + result->fields[i].sql_type = SQL_BINARY_TINYINT; result->fields[i].converter = (mapi_converter) mapi_convert_tinyint; } else if (strcasecmp(type_sql_name, "boolean") == 0) { + result->fields[i].sql_type = SQL_BINARY_BOOLEAN; result->fields[i].converter = (mapi_converter) mapi_convert_boolean; } else if (strcasecmp(type_sql_name, "decimal") == 0 || strcasecmp(type_sql_name, "sec_interval") == 0) { + result->fields[i].sql_type = SQL_BINARY_DECIMAL; result->fields[i].converter = (mapi_converter) mapi_convert_decimal; } else if (strcasecmp(type_sql_name, "double") == 0) { + result->fields[i].sql_type = SQL_BINARY_DOUBLE; result->fields[i].converter = (mapi_converter) mapi_convert_double; } else if (strcasecmp(type_sql_name, "date") == 0) { + result->fields[i].sql_type = SQL_BINARY_DATE; result->fields[i].converter = (mapi_converter) mapi_convert_date; } else if (strcasecmp(type_sql_name, "bigint") == 0) { + result->fields[i].sql_type =
MonetDB: protocol - Handle TYPE_void.
Changeset: 5525372adcd6 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5525372adcd6 Modified Files: sql/backends/monet5/sql_result.c Branch: protocol Log Message: Handle TYPE_void. diffs (12 lines): diff --git a/sql/backends/monet5/sql_result.c b/sql/backends/monet5/sql_result.c --- a/sql/backends/monet5/sql_result.c +++ b/sql/backends/monet5/sql_result.c @@ -1454,6 +1454,8 @@ get_print_width(int mtype, int eclass, i } else if (mtype == TYPE_hge) { count = bat_max_hgelength(b); #endif + } else if (mtype == TYPE_void) { + count = 4; } else { assert(0); } ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Merge with default.
Changeset: 19f650d7c7d1 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=19f650d7c7d1 Added Files: sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit sql/jdbc/tests/Tests/BugExecuteUpdate_Bug_3350.SQL.bat sql/jdbc/tests/Tests/BugExecuteUpdate_Bug_3350.SQL.sh sql/jdbc/tests/Tests/BugExecuteUpdate_Bug_3350.stable.err sql/jdbc/tests/Tests/BugExecuteUpdate_Bug_3350.stable.out sql/jdbc/tests/Tests/Test_Wrapper.SQL.bat sql/jdbc/tests/Tests/Test_Wrapper.SQL.sh sql/jdbc/tests/Tests/Test_Wrapper.stable.err sql/jdbc/tests/Tests/Test_Wrapper.stable.out sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.sql sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.stable.err sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.stable.out sql/test/BugTracker-2016/Tests/storagemodel.stable.out.int128 sql/test/BugTracker-2016/Tests/union.Bug-6069.sql sql/test/BugTracker-2016/Tests/union.Bug-6069.stable.err sql/test/BugTracker-2016/Tests/union.Bug-6069.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/pg_regress/Tests/oid.stable.out.oid32 sql/test/pg_regress/Tests/without_oid.stable.out.oid32 Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 geom/sql/conformance/Tests/T10.stable.out geom/sql/conformance/Tests/T11.stable.out geom/sql/conformance/Tests/T12.stable.out geom/sql/conformance/Tests/T13.stable.out geom/sql/conformance/Tests/T14.stable.out geom/sql/conformance/Tests/T15.stable.out geom/sql/conformance/Tests/T16.stable.out geom/sql/conformance/Tests/T17.stable.out geom/sql/conformance/Tests/T18.stable.out geom/sql/conformance/Tests/T21.stable.out geom/sql/conformance/Tests/T22.stable.out geom/sql/conformance/Tests/T23.stable.out geom/sql/conformance/Tests/T24.stable.out geom/sql/conformance/Tests/T25.stable.out geom/sql/conformance/Tests/T26.stable.out geom/sql/conformance/Tests/T27.stable.out geom/sql/conformance/Tests/T28.stable.out geom/sql/conformance/Tests/T29.stable.out geom/sql/conformance/Tests/T30.stable.out geom/sql/conformance/Tests/T31.stable.out geom/sql/conformance/Tests/T32.stable.out geom/sql/conformance/Tests/T33.stable.out geom/sql/conformance/Tests/T34.stable.out geom/sql/conformance/Tests/T35.stable.out geom/sql/conformance/Tests/T36.stable.out geom/sql/conformance/Tests/T37.stable.out geom/sql/conformance/Tests/T38.stable.out geom/sql/conformance/Tests/T39.stable.out geom/sql/conformance/Tests/T40.stable.out geom/sql/conformance/Tests/T41.stable.out geom/sql/conformance/Tests/T42.stable.out geom/sql/conformance/Tests/T43.stable.out geom/sql/conformance/Tests/T44.stable.out geom/sql/conformance/Tests/T45.stable.out geom/sql/conformance/Tests/T46.stable.out geom/sql/conformance/Tests/T47.stable.out geom/sql/conformance/Tests/T48.stable.out geom/sql/conformance/Tests/T49.stable.out geom/sql/conformance/Tests/T50.stable.out geom/sql/conformance/Tests/T51.stable.out geom/sql/conformance/Tests/T52.stable.out geom/sql/conformance/Tests/T6.stable.out geom/sql/conformance/Tests/T7.stable.out geom/sql/conformance/Tests/T8.stable.out geom/sql/functions/Tests/ST_AsEWKT.stable.out geom/sql/functions/Tests/ST_AsText.stable.out geom/sql/functions/Tests/ST_Boundary.stable.out geom/sql/functions/Tests/ST_Contains.stable.out geom/sql/functions/Tests/ST_CoordDim.stable.out geom/sql/functions/Tests/ST_Dimension.stable.out geom/sql/functions/Tests/ST_GeomFromText.stable.out geom/sql/functions/Tests/ST_GeometryN.stable.out geom/sql/functions/Tests/ST_GeometryType.stable.out geom/sql/functions/Tests/ST_IsClosed.stable.out geom/sql/functions/Tests/ST_IsEmpty.stable.out geom/sql/functions/Tests/ST_IsRing.stable.out geom/sql/functions/Tests/ST_IsSimple.stable.out geom/sql/functions/Tests/ST_IsValid.stable.out geom/sql/functions/Tests/ST_LineFromText.stable.out geom/sql/functions/Tests/ST_MLineFromText.stable.out geom/sql/functions/Tests/ST_MPointFromText.stable.out geom/sql/functions/Tests/ST_MPolygonFromText.stable.out geom/sql/funct
MonetDB: Dec2016 - Merge with Jun2016 branch.
Changeset: f7301d22c7d9 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f7301d22c7d9 Added Files: sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit sql/test/emptydb-upgrade/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.32bit Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/check.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-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb/Tests/All sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 Branch: Dec2016 Log Message: Merge with Jun2016 branch. diffs (truncated from 14182 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 @@ -39,10 +39,16 @@ Ready. \dSv \dSs \dSf +\dn bam \dn json \dn profiler \dn sys \dn tmp +\dSt bam.export +\dSt bam.files +\dSt bam.pg +\dSt bam.rg +\dSt bam.sq \dSt sys._columns \dSt sys._tables \dSt sys.args @@ -55,6 +61,11 @@ Ready. \dSt sys.idxs \dSt sys.keys \dSt sys.keywords +\dSt sys.netcdf_attrs +\dSt sys.netcdf_dims +\dSt sys.netcdf_files +\dSt sys.netcdf_vardim +\dSt sys.netcdf_vars \dSt sys.objects \dSt sys.privileges \dSt sys.schemas @@ -94,6 +105,7 @@ Ready. \dSf sys."analyze" \dSf sys."bbp" \dSf sys."broadcast" +\dSf sys."chi2prob" \dSf sys."clearrejects" \dSf sys."columnsize" \dSf sys."contains" @@ -125,6 +137,8 @@ Ready. \dSf sys."environment" \dSf sys."epoch" \dSf sys."evalalgebra" +\dSf sys."fitsattach" +\dSf sys."fitsload" \dSf sys."flush_log" \dSf sys."fuse" \dSf sys."generate_series" @@ -157,7 +171,12 @@ Ready. \dSf sys."isauuid" \dSf sys."left_shift" \dSf sys."left_shift_assign" +\dSf sys."lidarattach" +\dSf sys."lidarexport" +\dSf sys."lidarload" \dSf sys."like" +\dSf sys."listdir" +\dSf sys."listdirpat" \dSf sys."malfunctions" \dSf sys."masklen" \dSf sys."mbr" @@ -167,6 +186,8 @@ Ready. \dSf sys."ms_str" \dSf sys."ms_stuff" \dSf sys."ms_trunc" +\dSf sys."netcdf_attach" +\dSf sys."netcdf_importvar" \dSf sys."netmask" \dSf sys."network" \dSf sys."newurl" @@ -194,6 +215,8 @@ Ready. \dSf sys."setmasklen" \dSf sys."setsession" \dSf sys."settimeout" +\dSf sys."shpattach" +\dSf sys."shpload" \dSf sys."shrink" \dSf sys."shutdown" \dSf sys."st_area" @@ -308,6 +331,7 @@ Ready. \dSf sys."var" \dSf sys."var_pop" \dSf sys."var_samp" +SYSTEM SCHEMA bam SYSTEM SCHEMA json SYSTEM SCHEMA profiler SYSTEM SCHEMA sys @@ -324,6 +348,11 @@ SYSTEM TABLE sys.functions SYSTEM TABLE sys.idxs SYSTEM TABLE sys.keys SYSTEM TABLE sys.keywords +SYSTEM TABLE sys.netcdf_attrs +SYSTEM TABLE sys.netcdf_dims +SYSTEM TABLE sys.netcdf_files +SYSTEM TABLE sys.netcdf_vardim +SYSTEM TABLE sys.netcdf_vars SYSTEM TABLE sys.objects SYSTEM TABLE sys.privileges SYSTEM TABLE sys.schemas @@ -380,6 +409,7 @@ SYSTEM FUNCTION sys.ceiling SYSTEM FUNCTION sys.char_length SYSTEM FUNCTION sys.character_length SYSTEM FUNCTION sys.charindex +SYSTEM FUNCTION sys.chi2prob SYSTEM FUNCTION sys.clearrejects SYSTEM FUNCTION sys.code SYSTEM FUNCTION sys.columnsize @@ -435,6 +465,8 @@ SYSTEM FUNCTION sys.epoch SYSTEM FUNCTION sys.evalalgebra SYSTEM FUNCTION sys.exist SYSTEM FUNCTION sys.exp +SYSTEM FUNCTION sys.fitsattach +SYSTEM FUNCTION sys.fitsload SYSTEM FUNCTION sys.floor SYSTEM FUNCTION sys.flush_log SYSTEM FUNCTION sys.fuse @@ -481,7 +513,12 @@ SYSTEM FUNCTION sys.left_shift SYSTEM FUNCTION sys.left_shift_assign SYSTEM FUNCTION sys.length SYSTEM FUNCTION sys.levenshtein +SYSTEM FUNCTION sys.lidarattach +SYSTEM FUNCTION sys.lidarexport +SYSTEM FUNCTION sys.lidarload SYSTEM FUNCTION sys.like +SYSTEM FUNCTION sys.listdir +SYSTEM FUNCTION sys.listdirpat SYSTEM FUNCTION sys.local_timezone SYSTEM FUNCTION sys.localtime SYSTEM FUNCTION sys.localtimestamp @@ -518,6 +555,8 @@ SYSTEM FUNCTION sys.ms_round SYSTEM FUNCTION sys.ms_str SYSTEM FUNCTION sys.ms_stuff SYSTEM FUNCTION sys.ms_trunc +SYSTEM FUNCTION sys.netcdf_attach +SYSTEM FUNCTION sys.netcdf_importvar SYSTEM FUNCTION sys.netmask SYSTEM FUNCTION sys.network SYSTEM FUNCTION sys.newurl @@ -574,6 +613,8 @@ SYSTEM FUNCTION sys.sessions SYSTEM FUNCTION sys.setmasklen SYSTEM FUNCTION sys.setsession SYSTEM FUNCTION sys.settimeout +SYSTEM FUNCTION sys.shpattach +SYSTEM FUNCTION sys.shpload SYSTEM FUNCTION sys.shrink SYSTEM FUNCTION sys.shutdown SYSTEM FUNCTION sys.sign @@ -718,10 +759,16 @@ SYSTEM FUNCTION sys.weekofyear SYSTEM FUNCTION sys.xor S
MonetDB: default - Merge with Dec2016 branch.
Changeset: 25027e4c22ae for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=25027e4c22ae Added Files: sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit sql/test/emptydb-upgrade/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.32bit Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/check.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-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb/Tests/All sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 Branch: default Log Message: Merge with Dec2016 branch. diffs (truncated from 14182 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 @@ -39,10 +39,16 @@ Ready. \dSv \dSs \dSf +\dn bam \dn json \dn profiler \dn sys \dn tmp +\dSt bam.export +\dSt bam.files +\dSt bam.pg +\dSt bam.rg +\dSt bam.sq \dSt sys._columns \dSt sys._tables \dSt sys.args @@ -55,6 +61,11 @@ Ready. \dSt sys.idxs \dSt sys.keys \dSt sys.keywords +\dSt sys.netcdf_attrs +\dSt sys.netcdf_dims +\dSt sys.netcdf_files +\dSt sys.netcdf_vardim +\dSt sys.netcdf_vars \dSt sys.objects \dSt sys.privileges \dSt sys.schemas @@ -94,6 +105,7 @@ Ready. \dSf sys."analyze" \dSf sys."bbp" \dSf sys."broadcast" +\dSf sys."chi2prob" \dSf sys."clearrejects" \dSf sys."columnsize" \dSf sys."contains" @@ -125,6 +137,8 @@ Ready. \dSf sys."environment" \dSf sys."epoch" \dSf sys."evalalgebra" +\dSf sys."fitsattach" +\dSf sys."fitsload" \dSf sys."flush_log" \dSf sys."fuse" \dSf sys."generate_series" @@ -157,7 +171,12 @@ Ready. \dSf sys."isauuid" \dSf sys."left_shift" \dSf sys."left_shift_assign" +\dSf sys."lidarattach" +\dSf sys."lidarexport" +\dSf sys."lidarload" \dSf sys."like" +\dSf sys."listdir" +\dSf sys."listdirpat" \dSf sys."malfunctions" \dSf sys."masklen" \dSf sys."mbr" @@ -167,6 +186,8 @@ Ready. \dSf sys."ms_str" \dSf sys."ms_stuff" \dSf sys."ms_trunc" +\dSf sys."netcdf_attach" +\dSf sys."netcdf_importvar" \dSf sys."netmask" \dSf sys."network" \dSf sys."newurl" @@ -194,6 +215,8 @@ Ready. \dSf sys."setmasklen" \dSf sys."setsession" \dSf sys."settimeout" +\dSf sys."shpattach" +\dSf sys."shpload" \dSf sys."shrink" \dSf sys."shutdown" \dSf sys."st_area" @@ -308,6 +331,7 @@ Ready. \dSf sys."var" \dSf sys."var_pop" \dSf sys."var_samp" +SYSTEM SCHEMA bam SYSTEM SCHEMA json SYSTEM SCHEMA profiler SYSTEM SCHEMA sys @@ -324,6 +348,11 @@ SYSTEM TABLE sys.functions SYSTEM TABLE sys.idxs SYSTEM TABLE sys.keys SYSTEM TABLE sys.keywords +SYSTEM TABLE sys.netcdf_attrs +SYSTEM TABLE sys.netcdf_dims +SYSTEM TABLE sys.netcdf_files +SYSTEM TABLE sys.netcdf_vardim +SYSTEM TABLE sys.netcdf_vars SYSTEM TABLE sys.objects SYSTEM TABLE sys.privileges SYSTEM TABLE sys.schemas @@ -380,6 +409,7 @@ SYSTEM FUNCTION sys.ceiling SYSTEM FUNCTION sys.char_length SYSTEM FUNCTION sys.character_length SYSTEM FUNCTION sys.charindex +SYSTEM FUNCTION sys.chi2prob SYSTEM FUNCTION sys.clearrejects SYSTEM FUNCTION sys.code SYSTEM FUNCTION sys.columnsize @@ -435,6 +465,8 @@ SYSTEM FUNCTION sys.epoch SYSTEM FUNCTION sys.evalalgebra SYSTEM FUNCTION sys.exist SYSTEM FUNCTION sys.exp +SYSTEM FUNCTION sys.fitsattach +SYSTEM FUNCTION sys.fitsload SYSTEM FUNCTION sys.floor SYSTEM FUNCTION sys.flush_log SYSTEM FUNCTION sys.fuse @@ -481,7 +513,12 @@ SYSTEM FUNCTION sys.left_shift SYSTEM FUNCTION sys.left_shift_assign SYSTEM FUNCTION sys.length SYSTEM FUNCTION sys.levenshtein +SYSTEM FUNCTION sys.lidarattach +SYSTEM FUNCTION sys.lidarexport +SYSTEM FUNCTION sys.lidarload SYSTEM FUNCTION sys.like +SYSTEM FUNCTION sys.listdir +SYSTEM FUNCTION sys.listdirpat SYSTEM FUNCTION sys.local_timezone SYSTEM FUNCTION sys.localtime SYSTEM FUNCTION sys.localtimestamp @@ -518,6 +555,8 @@ SYSTEM FUNCTION sys.ms_round SYSTEM FUNCTION sys.ms_str SYSTEM FUNCTION sys.ms_stuff SYSTEM FUNCTION sys.ms_trunc +SYSTEM FUNCTION sys.netcdf_attach +SYSTEM FUNCTION sys.netcdf_importvar SYSTEM FUNCTION sys.netmask SYSTEM FUNCTION sys.network SYSTEM FUNCTION sys.newurl @@ -574,6 +613,8 @@ SYSTEM FUNCTION sys.sessions SYSTEM FUNCTION sys.setmasklen SYSTEM FUNCTION sys.setsession SYSTEM FUNCTION sys.settimeout +SYSTEM FUNCTION sys.shpattach +SYSTEM FUNCTION sys.shpload SYSTEM FUNCTION sys.shrink SYSTEM FUNCTION sys.shutdown SYSTEM FUNCTION sys.sign @@ -718,10 +759,16 @@ SYSTEM FUNCTION sys.weekofyear SYSTEM FUNCTION sys.xor S
MonetDB: Jun2016 - Move stable.out to stable.out.32bit, approve ...
Changeset: 6843f6bd5843 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6843f6bd5843 Added Files: sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit sql/test/emptydb-upgrade/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.32bit Modified Files: sql/test/emptydb-upgrade-chain/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out Branch: Jun2016 Log Message: Move stable.out to stable.out.32bit, approve 64 bit to stable.out. diffs (truncated from 5064 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out @@ -1,33 +1,29 @@ stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain` itself: -# 12:41:42 > -# 12:41:42 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=38686" "--set" "mapi_usock=/var/tmp/mtest-29963/.s.monetdb.38686" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-stable/var/MonetDB/mTests_sql_test_emptydb-upgrade-chain" "--set" "mal_listing=0" "--set" "embedded_r=yes" -# 12:41:42 > +# 15:32:57 > +# 15:32:57 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39456" "--set" "mapi_usock=/var/tmp/mtest-19169/.s.monetdb.39456" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/sjoerd/Monet-stable/var/MonetDB/mTests_sql_test_emptydb-upgrade-chain" "--set" "embedded_r=yes" +# 15:32:57 > -# MonetDB 5 server v11.21.16 (hg id: 3d106269871b+) +# MonetDB 5 server v11.23.14 # This is an unreleased version # Serving database 'mTests_sql_test_emptydb-upgrade-chain', using 8 threads # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked # Found 15.589 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. -# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved +# Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information -# Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:38686/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-29963/.s.monetdb.38686 +# Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:39456/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-19169/.s.monetdb.39456 # MonetDB/GIS module loaded -# Start processing logs sql/sql_logs version 52200 -# Start reading the write-ahead log 'sql_logs/sql/log.4' -# Finished reading the write-ahead log 'sql_logs/sql/log.4' -# Finished processing logs sql/sql_logs # MonetDB/SQL module loaded # MonetDB/R module loaded Ready. -# 12:41:42 > -# 12:41:42 > "/usr/bin/python2" "check.SQL.py" "check" -# 12:41:42 > +# 15:32:58 > +# 15:32:58 > "/usr/bin/python2" "check.SQL.py" "check" +# 15:32:58 > \dn \dt @@ -334,7 +330,7 @@ Ready. \dSf sys."zorder_encode" SYSTEM SCHEMA bam SYSTEM SCHEMA json -SYSTEM SCHEMA profiler +SYSTEM SCHEMA profiler SYSTEM SCHEMA sys SYSTEM SCHEMA tmp SYSTEM TABLE sys._columns @@ -358,7 +354,7 @@ SYSTEM TABLE sys.objects SYSTEM TABLE sys.privileges SYSTEM TABLE sys.schemas SYSTEM TABLE sys.sequences -SYSTEM TABLE sys.spatial_ref_sys +SYSTEM TABLE sys.spatial_ref_sys SYSTEM TABLE sys.statistics SYSTEM TABLE sys.storagemodelinput SYSTEM TABLE sys.systemfunctions @@ -368,7 +364,7 @@ SYSTEM TABLE sys.types SYSTEM TABLE sys.user_role SYSTEM VIEW sys.columns SYSTEM VIEW sys.environment -SYSTEM VIEW sys.geometry_columns +SYSTEM VIEW sys.geometry_columns SYSTEM VIEW sys.optimizers SYSTEM VIEW sys.querylog_calls SYSTEM VIEW sys.querylog_catalog @@ -382,60 +378,60 @@ SYSTEM VIEW sys.tables SYSTEM VIEW sys.tablestoragemodel SYSTEM VIEW sys.tracelog SYSTEM VIEW sys.users -SYSTEM FUNCTION sys.< -SYSTEM FUNCTION sys.<= -SYSTEM FUNCTION sys.<> -SYSTEM FUNCTION sys.= -SYSTEM FUNCTION sys.> -SYSTEM FUNCTION sys.>= +SYSTEM FUNCTION sys.< +SYSTEM FUNCTION sys.<= +SYSTEM FUNCTION sys.<> +SYSTEM FUNCTION sys.= +SYSTEM FUNCTION sys.> +SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev -SYSTEM FUNCTION sys.abs -SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.abs +SYSTEM FUNCTION sys.acos SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze -SYSTEM FUNCTION sys.and -SYSTEM FUNCTION sys.ascii -SYSTEM FUNCTION sys.asin -SYSTEM FUNCTION sys.atan -SYSTEM FUNCTION sys.avg +SYSTEM FUNCTION sys.and +SYSTEM FUNCTION sys.ascii +SYSTEM FUNCTION sys.asin +SYSTEM FUNCTION sys.atan +SYSTEM FUNCTION sys.avg SYSTEM FUNCTION sys.bbp -SYSTEM FUNCTION sys.bit_and -SYSTEM FUNCTION sys.bit_not -SYSTEM FUNCTION sys.bit_or -SYSTEM FUNCTION sys.bit_xor +SYSTEM
MonetDB: Jun2016 - Tests emptydb using a "normally" configured s...
Changeset: e2d8c9244083 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e2d8c9244083 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/check.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-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb/Tests/All sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 Branch: Jun2016 Log Message: Tests emptydb using a "normally" configured server. Note that the saved databases on the test system have been updated as well. diffs (truncated from 8815 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 @@ -39,10 +39,16 @@ Ready. \dSv \dSs \dSf +\dn bam \dn json \dn profiler \dn sys \dn tmp +\dSt bam.export +\dSt bam.files +\dSt bam.pg +\dSt bam.rg +\dSt bam.sq \dSt sys._columns \dSt sys._tables \dSt sys.args @@ -55,6 +61,11 @@ Ready. \dSt sys.idxs \dSt sys.keys \dSt sys.keywords +\dSt sys.netcdf_attrs +\dSt sys.netcdf_dims +\dSt sys.netcdf_files +\dSt sys.netcdf_vardim +\dSt sys.netcdf_vars \dSt sys.objects \dSt sys.privileges \dSt sys.schemas @@ -94,6 +105,7 @@ Ready. \dSf sys."analyze" \dSf sys."bbp" \dSf sys."broadcast" +\dSf sys."chi2prob" \dSf sys."clearrejects" \dSf sys."columnsize" \dSf sys."contains" @@ -123,6 +135,8 @@ Ready. \dSf sys."environment" \dSf sys."epoch" \dSf sys."evalalgebra" +\dSf sys."fitsattach" +\dSf sys."fitsload" \dSf sys."flush_log" \dSf sys."fuse" \dSf sys."generate_series" @@ -155,7 +169,12 @@ Ready. \dSf sys."isauuid" \dSf sys."left_shift" \dSf sys."left_shift_assign" +\dSf sys."lidarattach" +\dSf sys."lidarexport" +\dSf sys."lidarload" \dSf sys."like" +\dSf sys."listdir" +\dSf sys."listdirpat" \dSf sys."malfunctions" \dSf sys."masklen" \dSf sys."mbr" @@ -165,6 +184,8 @@ Ready. \dSf sys."ms_str" \dSf sys."ms_stuff" \dSf sys."ms_trunc" +\dSf sys."netcdf_attach" +\dSf sys."netcdf_importvar" \dSf sys."netmask" \dSf sys."network" \dSf sys."newurl" @@ -192,6 +213,8 @@ Ready. \dSf sys."setmasklen" \dSf sys."setsession" \dSf sys."settimeout" +\dSf sys."shpattach" +\dSf sys."shpload" \dSf sys."shrink" \dSf sys."shutdown" \dSf sys."st_area" @@ -309,6 +332,7 @@ Ready. \dSf sys."zorder_decode_x" \dSf sys."zorder_decode_y" \dSf sys."zorder_encode" +SYSTEM SCHEMA bam SYSTEM SCHEMA json SYSTEM SCHEMA profiler SYSTEM SCHEMA sys @@ -325,6 +349,11 @@ SYSTEM TABLE sys.functions SYSTEM TABLE sys.idxs SYSTEM TABLE sys.keys SYSTEM TABLE sys.keywords +SYSTEM TABLE sys.netcdf_attrs +SYSTEM TABLE sys.netcdf_dims +SYSTEM TABLE sys.netcdf_files +SYSTEM TABLE sys.netcdf_vardim +SYSTEM TABLE sys.netcdf_vars SYSTEM TABLE sys.objects SYSTEM TABLE sys.privileges SYSTEM TABLE sys.schemas @@ -380,6 +409,7 @@ SYSTEM FUNCTION sys.ceiling SYSTEM FUNCTION sys.char_length SYSTEM FUNCTION sys.character_length SYSTEM FUNCTION sys.charindex +SYSTEM FUNCTION sys.chi2prob SYSTEM FUNCTION sys.clearrejects SYSTEM FUNCTION sys.code SYSTEM FUNCTION sys.columnsize @@ -433,6 +463,8 @@ SYSTEM FUNCTION sys.epoch SYSTEM FUNCTION sys.evalalgebra SYSTEM FUNCTION sys.exist SYSTEM FUNCTION sys.exp +SYSTEM FUNCTION sys.fitsattach +SYSTEM FUNCTION sys.fitsload SYSTEM FUNCTION sys.floor SYSTEM FUNCTION sys.flush_log SYSTEM FUNCTION sys.fuse @@ -479,7 +511,12 @@ SYSTEM FUNCTION sys.left_shift SYSTEM FUNCTION sys.left_shift_assign SYSTEM FUNCTION sys.length SYSTEM FUNCTION sys.levenshtein +SYSTEM FUNCTION sys.lidarattach +SYSTEM FUNCTION sys.lidarexport +SYSTEM FUNCTION sys.lidarload SYSTEM FUNCTION sys.like +SYSTEM FUNCTION sys.listdir +SYSTEM FUNCTION sys.listdirpat SYSTEM FUNCTION sys.local_timezone SYSTEM FUNCTION sys.localtime SYSTEM FUNCTION sys.localtimestamp @@ -516,6 +553,8 @@ SYSTEM FUNCTION sys.ms_round SYSTEM FUNCTION sys.ms_str SYSTEM FUNCTION sys.ms_stuff SYSTEM FUNCTION sys.ms_trunc +SYSTEM FUNCTION sys.netcdf_attach +SYSTEM FUNCTION sys.netcdf_importvar SYSTEM FUNCTION sys.netmask SYSTEM FUNCTION sys.network SYSTEM FUNCTION sys.newurl @@ -572,6 +611,8 @@ SYSTEM FUNCTION sys.sessions SYSTEM FUNCTION sys.setmasklen SYSTEM FUNCTION sys.setsession SYSTEM FUNCTION sys.settimeout +SYSTEM FUNCTION sys.shpattach +SYSTEM FUNCTION sys.shpload SYSTEM FUNCTION sys.shrink SYSTEM FUNCTION sys.shutdown SYSTEM FUNCTION sys.sign @@ -719,10 +760,16 @@ SYSTEM FUNCTION sys.zero_or_one SYSTEM FUNCTION sys.zorder_decode_x SYSTEM FUNCTION sys.zorder_decode_y SYSTEM FUNCTION sys.
MonetDB: default - Step two towards a new stable branch "Dec2016".
Changeset: d330627d491a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d330627d491a Added Files: ChangeLog.Dec2016 buildtools/ChangeLog.Dec2016 clients/ChangeLog.Dec2016 clients/mapilib/ChangeLog.Dec2016 common/stream/ChangeLog.Dec2016 gdk/ChangeLog.Dec2016 geom/ChangeLog.Dec2016 monetdb5/ChangeLog.Dec2016 sql/ChangeLog.Dec2016 testing/ChangeLog.Dec2016 tools/merovingian/ChangeLog.Dec2016 Modified Files: ChangeLog MonetDB.spec NT/installer32/MonetDB-ODBC-Installer.vdproj NT/installer32/MonetDB5-Geom-Module.vdproj NT/installer32/MonetDB5-SQL-Installer.vdproj NT/installer64/MonetDB-ODBC-Installer.vdproj NT/installer64/MonetDB5-Geom-Module.vdproj NT/installer64/MonetDB5-SQL-Installer.vdproj NT/monetdb_config.h.in NT/rules.msc buildtools/ChangeLog clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc configure.ag gdk/ChangeLog gdk/libbat.rc monetdb5/ChangeLog monetdb5/tools/libmonetdb5.rc sql/ChangeLog vertoo.data Branch: default Log Message: Step two towards a new stable branch "Dec2016". Increment version numbers. >From now on, *all* bug fixes, and *only* bug fixes, *must* go to the stable branch with the name "Dec2016". diffs (truncated from 468 to 300 lines): diff --git a/ChangeLog b/ChangeLog --- a/ChangeLog +++ b/ChangeLog @@ -1,13 +1,3 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Thu Sep 22 2016 Sjoerd Mullender -- The Perl, PHP, and Python clients, and the JDBC driver each now have - their own repositories and release cycles. The Python client is - maintained by Gijs Molenaar on Github - (https://github.com/gijzelaerr/pymonetdb), the other clients are - maintained by CWI/MonetDB on our own server - (https://dev.monetdb.org/hg/monetdb-java, - https://dev.monetdb.org/hg/monetdb-perl, - https://dev.monetdb.org/hg/monetdb-php). - diff --git a/ChangeLog b/ChangeLog.Dec2016 copy from ChangeLog copy to ChangeLog.Dec2016 diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -1,5 +1,5 @@ %define name MonetDB -%define version 11.24.0 +%define version 11.26.0 %{!?buildno: %global buildno %(date +%Y%m%d)} # groups of related archs diff --git a/NT/installer32/MonetDB-ODBC-Installer.vdproj b/NT/installer32/MonetDB-ODBC-Installer.vdproj --- a/NT/installer32/MonetDB-ODBC-Installer.vdproj +++ b/NT/installer32/MonetDB-ODBC-Installer.vdproj @@ -574,7 +574,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.26.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer32/MonetDB5-Geom-Module.vdproj b/NT/installer32/MonetDB5-Geom-Module.vdproj --- a/NT/installer32/MonetDB5-Geom-Module.vdproj +++ b/NT/installer32/MonetDB5-Geom-Module.vdproj @@ -439,7 +439,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.26.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer32/MonetDB5-SQL-Installer.vdproj b/NT/installer32/MonetDB5-SQL-Installer.vdproj --- a/NT/installer32/MonetDB5-SQL-Installer.vdproj +++ b/NT/installer32/MonetDB5-SQL-Installer.vdproj @@ -4348,7 +4348,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.26.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer64/MonetDB-ODBC-Installer.vdproj b/NT/installer64/MonetDB-ODBC-Installer.vdproj --- a/NT/installer64/MonetDB-ODBC-Installer.vdproj +++ b/NT/installer64/MonetDB-ODBC-Installer.vdproj @@ -574,7 +574,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.26.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer64/MonetDB5-Geom-Module.vdproj b/NT/installer64/MonetDB5-Geom-Module.vdproj --- a/NT/installer64/MonetDB5-Geom-Module.vdproj +++ b/NT/installer64/MonetDB5-Geom-Module.vdproj @@ -439,7 +439,7 @@ "RemovePreviousVersions" = "11:TRUE" "
MonetDB: Dec2016 - Step one towards a new stable branch "Dec2016".
Changeset: 878cf065ea12 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=878cf065ea12 Added Files: ChangeLog.Dec2016 buildtools/ChangeLog.Dec2016 clients/ChangeLog.Dec2016 clients/mapilib/ChangeLog.Dec2016 common/stream/ChangeLog.Dec2016 gdk/ChangeLog.Dec2016 geom/ChangeLog.Dec2016 monetdb5/ChangeLog.Dec2016 sql/ChangeLog.Dec2016 testing/ChangeLog.Dec2016 tools/merovingian/ChangeLog.Dec2016 Removed Files: ChangeLog buildtools/ChangeLog clients/ChangeLog clients/mapilib/ChangeLog common/stream/ChangeLog gdk/ChangeLog geom/ChangeLog monetdb5/ChangeLog sql/ChangeLog testing/ChangeLog tools/merovingian/ChangeLog Modified Files: MonetDB.spec NT/installer32/MonetDB-ODBC-Installer.vdproj NT/installer32/MonetDB5-Geom-Module.vdproj NT/installer32/MonetDB5-SQL-Installer.vdproj NT/installer64/MonetDB-ODBC-Installer.vdproj NT/installer64/MonetDB5-Geom-Module.vdproj NT/installer64/MonetDB5-SQL-Installer.vdproj NT/monetdb_config.h.in NT/rules.msc clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc configure.ag gdk/libbat.rc monetdb5/tools/libmonetdb5.rc vertoo.data Branch: Dec2016 Log Message: Step one towards a new stable branch "Dec2016". Incremented version numbers. Moved ChangeLog file to ChangeLog.Dec2016. The root of the stable branch is "Dec2016_root". diffs (truncated from 323 to 300 lines): diff --git a/ChangeLog b/ChangeLog.Dec2016 rename from ChangeLog rename to ChangeLog.Dec2016 diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -1,5 +1,5 @@ %define name MonetDB -%define version 11.24.0 +%define version 11.25.0 %{!?buildno: %global buildno %(date +%Y%m%d)} # groups of related archs diff --git a/NT/installer32/MonetDB-ODBC-Installer.vdproj b/NT/installer32/MonetDB-ODBC-Installer.vdproj --- a/NT/installer32/MonetDB-ODBC-Installer.vdproj +++ b/NT/installer32/MonetDB-ODBC-Installer.vdproj @@ -574,7 +574,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.25.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer32/MonetDB5-Geom-Module.vdproj b/NT/installer32/MonetDB5-Geom-Module.vdproj --- a/NT/installer32/MonetDB5-Geom-Module.vdproj +++ b/NT/installer32/MonetDB5-Geom-Module.vdproj @@ -439,7 +439,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.25.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer32/MonetDB5-SQL-Installer.vdproj b/NT/installer32/MonetDB5-SQL-Installer.vdproj --- a/NT/installer32/MonetDB5-SQL-Installer.vdproj +++ b/NT/installer32/MonetDB5-SQL-Installer.vdproj @@ -4348,7 +4348,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.25.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer64/MonetDB-ODBC-Installer.vdproj b/NT/installer64/MonetDB-ODBC-Installer.vdproj --- a/NT/installer64/MonetDB-ODBC-Installer.vdproj +++ b/NT/installer64/MonetDB-ODBC-Installer.vdproj @@ -574,7 +574,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.25.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer64/MonetDB5-Geom-Module.vdproj b/NT/installer64/MonetDB5-Geom-Module.vdproj --- a/NT/installer64/MonetDB5-Geom-Module.vdproj +++ b/NT/installer64/MonetDB5-Geom-Module.vdproj @@ -439,7 +439,7 @@ "RemovePreviousVersions" = "11:TRUE" "DetectNewerInstalledVersion" = "11:TRUE" "InstallAllUsers" = "11:TRUE" -"ProductVersion" = "8:11.24.0" +"ProductVersion" = "8:11.25.0" "Manufacturer" = "8:MonetDB" "ARPHELPTELEPHONE" = "8:" "ARPHELPLINK" = "8:http://www.monetdb.org/"; diff --git a/NT/installer64/MonetDB5-SQL-Installer.vdproj b/NT/installer64/MonetDB5-SQL-Installer.vdproj --- a/NT/installer64/MonetDB5-SQL-Installer.vd
MonetDB: default - Added tag Dec2016_root for changeset 0027cb04...
Changeset: f0b8d4b0e589 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f0b8d4b0e589 Modified Files: .hgtags Branch: default Log Message: Added tag Dec2016_root for changeset 0027cb04877b diffs (8 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -640,3 +640,4 @@ f16cdfed96bdc0f3324f8ced85a8b74c67f4dc9b 293b452cd1e5964d820f7d6c538e06507e575d88 Jun2016_13 f16cdfed96bdc0f3324f8ced85a8b74c67f4dc9b Jun2016_SP2_release 293b452cd1e5964d820f7d6c538e06507e575d88 Jun2016_SP2_release +0027cb04877b7687f45277a81a25253a63e9f21f Dec2016_root ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: default - The Python client is no longer part of the repo.
Changeset: 0027cb04877b for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0027cb04877b Modified Files: vertoo.config Branch: default Log Message: The Python client is no longer part of the repo. diffs (16 lines): diff --git a/vertoo.config b/vertoo.config --- a/vertoo.config +++ b/vertoo.config @@ -35,12 +35,6 @@ main.addAnchors("clients/mapilib/mapi.rc 'VALUE "ProductVersion", "%v\\0"', arguments(pattern = 'FILEVERSION %v', format = '@winrc'), arguments(pattern = 'PRODUCTVERSION %v', format = '@winrc')) -main.addAnchors("clients/python2/setup.py", -"version=%q,", -"python2-monetdb-%v.tar") -main.addAnchors("clients/python3/setup.py", -"version=%q,", -"python3-monetdb-%v.tar") main.addAnchors("monetdb5/tools/libmonetdb5.rc", 'VALUE "FileVersion", "%v\\0"', 'VALUE "ProductVersion", "%v\\0"', ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: default - Approvals.
Changeset: db01d8e05444 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=db01d8e05444 Modified Files: sql/benchmarks/ssbm/Tests/01-explain.stable.out sql/benchmarks/ssbm/Tests/02-explain.stable.out sql/benchmarks/ssbm/Tests/03-explain.stable.out 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/07-explain.stable.out sql/benchmarks/ssbm/Tests/08-explain.stable.out sql/benchmarks/ssbm/Tests/09-explain.stable.out sql/benchmarks/ssbm/Tests/10-explain.stable.out sql/benchmarks/ssbm/Tests/11-explain.stable.out sql/benchmarks/ssbm/Tests/12-explain.stable.out sql/benchmarks/ssbm/Tests/13-explain.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/01-plan.stable.out sql/benchmarks/tpch/Tests/03-explain.stable.out sql/benchmarks/tpch/Tests/03-plan.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out sql/benchmarks/tpch/Tests/05-plan.stable.out sql/benchmarks/tpch/Tests/06-explain.stable.out sql/benchmarks/tpch/Tests/06-plan.stable.out sql/benchmarks/tpch/Tests/07-explain.stable.out sql/benchmarks/tpch/Tests/07-plan.stable.out sql/benchmarks/tpch/Tests/08-explain.stable.out sql/benchmarks/tpch/Tests/08-plan.stable.out sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/09-plan.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/10-plan.stable.out sql/benchmarks/tpch/Tests/11-explain.stable.out sql/benchmarks/tpch/Tests/11-plan.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out sql/benchmarks/tpch/Tests/14-plan.stable.out sql/benchmarks/tpch/Tests/17-explain.stable.out sql/benchmarks/tpch/Tests/17-plan.stable.out sql/benchmarks/tpch/Tests/19-explain.stable.out sql/benchmarks/tpch/Tests/19-plan.stable.out sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.stable.out sql/test/BugTracker-2009/Tests/avg-bug.SF-2132666.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.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/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check5.stable.out sql/test/leaks/Tests/drop3.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 Branch: default Log Message: Approvals. diffs (truncated from 41129 to 300 lines): diff --git a/sql/benchmarks/ssbm/Tests/01-explain.stable.out b/sql/benchmarks/ssbm/Tests/01-explain.stable.out --- a/sql/benchmarks/ssbm/Tests/01-explain.stable.out +++ b/sql/benchmarks/ssbm/Tests/01-explain.stable.out @@ -37,48 +37,29 @@ Ready. % mal # name % clob # type % 254 # length -function user.s2_1(A0:int,A1:int,A2:int,A3:int):void; -X_63:void := querylog.define("explain\nselect sum(lo_extendedprice*lo_discount) as revenue\n from lineorder, dwdate\n where lo_orderdate = d_datekey\n and d_year = 1993\n and lo_discount between 1 and 3\n and lo_quantity < 25;","sequential_pipe",43); -X_5 := sql.mvc(); -X_9:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_quantity",0); -X_17:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_discount",0); -C_6:bat[:oid] := sql.tid(X_5,"sys","lineorder"); -C_79 := algebra.subselect(X_17,C_6,A1,A2,true,true,false); -(C_19,r1_22) := sql.bind(X_5,"sys","lineorder","lo_discount",2); -C_80 := algebra.subselect(r1_22,nil:bat[:oid],A1,A2,true,true,f
MonetDB: graph1 - Semantic: support for CHEAPEST SUM(e: expr)
Changeset: e03fa66a96b5 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e03fa66a96b5 Modified Files: sql/server/rel_graph.c sql/server/sql_scan.c Branch: graph1 Log Message: Semantic: support for CHEAPEST SUM(e: expr) Explicitly bind the edge table from the argument of CHEAPEST SUM, identified by the string preceding the colon (:). diffs (192 lines): diff --git a/sql/server/rel_graph.c b/sql/server/rel_graph.c --- a/sql/server/rel_graph.c +++ b/sql/server/rel_graph.c @@ -109,7 +109,6 @@ sql_rel* rel_graph_reaches(mvc *sql, sql static bool error_reported(mvc* sql){ return (sql->session->status < 0); } - static sql_exp* bindg_ret(mvc *sql, sql_exp* bind1, sql_exp* bind2){ if (error_reported(sql)){ // an error already occurred return NULL; @@ -122,60 +121,71 @@ static sql_exp* bindg_ret(mvc *sql, sql_ } } -static sql_exp* bindg_exp(mvc *sql, sql_exp *exp, dlist *parse_tree){ - graph_join *g =NULL; - sql_exp* e =NULL; - exp_kind exp_kind_value = {type_value, card_column, TRUE}; +static sql_exp* bindg_filter_graph(mvc *sql, sql_exp *exp, dlist *parse_tree){ const char* table_ref = NULL; // the table referred (optional) symbol* expr_weight = NULL; // the expression inside CHEAPEST SUM ( ... ); + graph_join* g = NULL; + sql_exp* e = NULL; + exp_kind exp_kind_value = {type_value, card_column, TRUE}; assert(exp && "Expected an expression"); + assert(exp->type == e_cmp && get_cmp(exp) == cmp_filter_graph && "Expected a graph filter exp~"); assert(parse_tree && "The input argument parse_tree is NULL"); assert(parse_tree->cnt == 2 && "Expected two nodes in the root of the parse tree"); - if(exp->type != e_cmp || get_cmp(exp) != cmp_filter_graph){ - // this is not a graph join, move along - return NULL; - } - - (void) sql; - (void) g; - (void) e; - (void) exp_kind_value; - (void) table_ref; - (void) expr_weight; + g = exp->f; table_ref = parse_tree->h->data.sval; expr_weight = parse_tree->h->next->data.sym; + if (table_ref){ // use the table name to refer to the edge table + const char* tname = rel_name(g->edges); - return NULL; + // TODO shall we consider the schema as well? + assert(tname != NULL); + if(strcmp(tname, table_ref) == 0){ + // force the binding against this relation + e = rel_value_exp(sql, &(g->edges), expr_weight, sql_sel, exp_kind_value); + if(!e){ return sql_error(sql, 02, "Cannot bind the cheapest sum expression in the subquery `%s'", tname); } + } + } else { // table name not given + // try to bind the expression a la `best effort' + e = rel_value_exp(sql, &(g->edges), expr_weight, sql_sel, exp_kind_value); + } -// g = exp->f; -// -// // try to bind the expression -// e = rel_value_exp(sql, &(g->edges), sym, sql_sel, exp_kind_value); -// if(!e){ return NULL; } -// -// // an expression has already been bound -// if(g->cost){ -// return sql_error(sql, 02, "TODO: At the moment you cannot bind multiple CHEAPEST SUM expression against the same join"); -// } -// -// // found it! -// g->cost = exp_label(sql->sa, e, ++sql->label); -// return g->cost; + // did we bind our parse tree? + if(e){ + if(g->cost){ // existing limitation, an expression has already been bound + return sql_error(sql, 02, "TODO: At the moment you cannot bind multiple CHEAPEST SUM expression against the same join"); + } + + // found it! + g->cost = exp_label(sql->sa, e, ++sql->label); + return g->cost; + + } else { // no, we didn't bind it + return NULL; + } } +static sql_exp* bindg_exp(mvc *sql, sql_exp *exp, dlist *parse_tree){ + if(exp->type == e_cmp && get_cmp(exp) == cmp_filter_graph){ + // ok this is a graph join + return bindg_filter_graph(sql, exp, parse_tree); + } else { + // this is not a graph join, move along + return NULL; + } +} -static sql_exp* bindg_exps(mvc *sql, list *exps, dlist *sym){ +static sql_exp* bindg_exps(mvc *sql, list *exps, dlist *parse_tree){ sql_exp *result = NULL; // edge case if(!exps || error_reported(sql)) return NULL; for(node* n = exps->h; n; n = n->next){ - sql_exp *bound = bindg_exp(sql, n->data, sym); + sql_exp *bound = bindg_exp(sql, n->data, parse_tree); result = bindg_ret(sql, result, bound); if(error_reported(sql)) return NULL; // ERROR! => stop processing } @@ -183,7
MonetDB: protocol - Compilation fixes.
Changeset: 9290ec648fa5 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9290ec648fa5 Modified Files: clients/mapilib/mapi.c common/utils/conversion.c monetdb5/modules/atoms/blob.c Branch: protocol Log Message: Compilation fixes. diffs (78 lines): diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c --- a/clients/mapilib/mapi.c +++ b/clients/mapilib/mapi.c @@ -4145,7 +4145,7 @@ static char* mapi_convert_blob(struct Ma if (length < 0) { return NULL; } - if (24 + 3 * length > col->dynamic_write_bufsiz) { + if (24 + 3 * length > (lng) col->dynamic_write_bufsiz) { col->dynamic_write_bufsiz = (size_t) 24 + 3 * length; if (col->dynamic_write_buf) free(col->dynamic_write_buf); col->dynamic_write_buf = malloc(col->dynamic_write_bufsiz); @@ -4153,7 +4153,7 @@ static char* mapi_convert_blob(struct Ma return NULL; } } - if (conversion_blob_to_string(col->dynamic_write_buf, col->dynamic_write_bufsiz, col->buffer_ptr + sizeof(lng), length) < 0) { + if (conversion_blob_to_string(col->dynamic_write_buf, (int) col->dynamic_write_bufsiz, col->buffer_ptr + sizeof(lng), length) < 0) { return NULL; } return (char*) col->dynamic_write_buf; @@ -4258,7 +4258,7 @@ read_into_cache(MapiHdl hdl, int lookahe !mnstr_readInt(mid->from, &result->fields[i].scale)) { return mapi_setError(mid, "read error from stream while reading result set", "read_into_cache", MERROR); } - + if (!mnstr_readInt(mid->from, &null_len)) { return mapi_setError(mid, "read error from stream while reading result set", "read_into_cache", MERROR); } diff --git a/common/utils/conversion.c b/common/utils/conversion.c --- a/common/utils/conversion.c +++ b/common/utils/conversion.c @@ -357,7 +357,7 @@ conversion_blob_to_string(char *dst, int { char *s; size_t i; - size_t expectedlen; + int expectedlen; if (nitems == ~(size_t) 0) expectedlen = 4; diff --git a/monetdb5/modules/atoms/blob.c b/monetdb5/modules/atoms/blob.c --- a/monetdb5/modules/atoms/blob.c +++ b/monetdb5/modules/atoms/blob.c @@ -31,6 +31,7 @@ */ #include "monetdb_config.h" #include "blob.h" +#include int TYPE_blob; int TYPE_sqlblob; @@ -228,24 +229,6 @@ sqlblob_tostr(str *tostr, int *l, const } return conversion_blob_to_string(*tostr, expectedlen, p->data, p->nitems); - - // if (p->nitems == ~(size_t) 0) { - // strcpy(*tostr, "nil"); - // return 3; - // } - - // strcpy(*tostr, "\0"); - // s = *tostr; - - // for (i = 0; i < p->nitems; i++) { - // int val = (p->data[i] >> 4) & 15; - - // *s++ = hexit[val]; - // val = p->data[i] & 15; - // *s++ = hexit[val]; - // } - // *s = '\0'; - // return (int) (s - *tostr); /* 64bit: check for overflow */ } static int ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Remove print statements and minor consistenc...
Changeset: ecadceeb8b8f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ecadceeb8b8f Modified Files: clients/mapiclient/mclient.c clients/mapilib/mapi.c sql/backends/monet5/sql_result.c Branch: protocol Log Message: Remove print statements and minor consistency changes. diffs (39 lines): diff --git a/clients/mapiclient/mclient.c b/clients/mapiclient/mclient.c --- a/clients/mapiclient/mclient.c +++ b/clients/mapiclient/mclient.c @@ -1047,7 +1047,7 @@ mapi_escape_name(char *name) { char *startbuffer = malloc(strlen(name) * 2 + 2); char *buffer = startbuffer; if (!startbuffer) return NULL; - if (strchr(name, ',') || strchr(name, ' ') || strchr(name, '\t') || strchr(name, '#')) { + if (strchr(name, ',') || strchr(name, '\t') || strchr(name, '#')) { *buffer++ = '"'; char *p; for (p = name; *p; p++) { diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c --- a/clients/mapilib/mapi.c +++ b/clients/mapilib/mapi.c @@ -4258,11 +4258,7 @@ read_into_cache(MapiHdl hdl, int lookahe !mnstr_readInt(mid->from, &result->fields[i].scale)) { return mapi_setError(mid, "read error from stream while reading result set", "read_into_cache", MERROR); } - - if (strcasecmp(type_sql_name, "sec_interval") == 0) { - result->fields[i].scale = 3; - } - + if (!mnstr_readInt(mid->from, &null_len)) { return mapi_setError(mid, "read error from stream while reading result set", "read_into_cache", MERROR); } diff --git a/sql/backends/monet5/sql_result.c b/sql/backends/monet5/sql_result.c --- a/sql/backends/monet5/sql_result.c +++ b/sql/backends/monet5/sql_result.c @@ -2019,7 +2019,6 @@ int mvc_export_resultset_prot10(mvc *m, } } if (mnstr_flush(s) < 0) { - fprintf(stderr, "Failed to flush.\n"); fres = -1; goto cleanup; } ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: protocol - Escape name in fake mapi headers for consist...
Changeset: a0ce86ce65b1 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a0ce86ce65b1 Modified Files: clients/mapiclient/mclient.c Branch: protocol Log Message: Escape name in fake mapi headers for consistency with old protocol. diffs (44 lines): diff --git a/clients/mapiclient/mclient.c b/clients/mapiclient/mclient.c --- a/clients/mapiclient/mclient.c +++ b/clients/mapiclient/mclient.c @@ -1041,6 +1041,29 @@ classify(const char *s, size_t l) } } + +static char* +mapi_escape_name(char *name) { + char *startbuffer = malloc(strlen(name) * 2 + 2); + char *buffer = startbuffer; + if (!startbuffer) return NULL; + if (strchr(name, ',') || strchr(name, ' ') || strchr(name, '\t') || strchr(name, '#')) { + *buffer++ = '"'; + char *p; + for (p = name; *p; p++) { + if (*p == '"') { + *buffer++ = '\\'; + } + *buffer++ = *p; + } + *buffer++ = '"'; + *buffer = '\0'; + } else { + strcpy(buffer, name); + } + return startbuffer; +} + static void TESTrenderer(MapiHdl hdl) { @@ -1067,7 +1090,9 @@ TESTrenderer(MapiHdl hdl) // column names mnstr_printf(toConsole, "%% "); for(i = 0; i < fields; i++) { - mnstr_printf(toConsole, "%s%s", mapi_get_name(hdl, i), i < fields - 1 ? ",\t" : " "); + char *name = mapi_escape_name(mapi_get_name(hdl, i)); + mnstr_printf(toConsole, "%s%s", name, i < fields - 1 ? ",\t" : " "); + if (name) free(name); } mnstr_printf(toConsole, "# name\n"); // column type names ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list