Tarantool 2.1.1 beta released

[Кирилл Юхин]

Date: 2018-11-15

Tag: 2.1.1

Overview

2.1.1 is a beta version of the 2.1 release series. The label 'beta' means we have all planned features implemented and all major bugs fixed.

This release resolves roughly 150 issues since the latest alpha version. There may be bugs in less common areas, please feel free to file an issue at GitHub.

Compatibility

Tarantool 2.1.1 is backward compatible with Tarantool 1.10.x in binary data layout, client-server protocol and replication protocol.

Please upgrade using the box.schema.upgrade() procedure to unlock all the new features of the 2.1 series.

Functionality added or changed

SQL

• Functions in SQL;
  gh-2347
• Introduce Tarantool-specific keyword engine;
  gh-2199
• Work with 'IF NOT EXISTS' in VDBE;
  gh-3435
• Parse and load VIEW into in-memory structs;
  gh-3300
• Use Tarantool's facilities to deal with OS in SQL;
  gh-3284
• Move SQL TRIGGERs into server;
  gh-3273
• Move SQL CHECK into server;
  gh-3272
• Move SQL FOREIGN KEYs into server;
  gh-3271
• Move legacy DD structs to Tarantool;
  gh-2217
• Move all statistics-related data structures out of legacy DD;
  gh-3253
• Store the rest of constraint violation actions inside the backend;
  gh-3178
• Split DDL and DML program logic in SQL;
  gh-3252
• Print active pragmas;
  gh-3054
• Ability to set some sqlite debug vars is necessary;
  gh-2646
• Implement a driver for sysbench benchmark;
  gh-2566
• Ban ON CONFLICT REPLACE for secondary indexes;
  gh-2963
• IS is only applicable when dealing with NULL;
  gh-2136
• Make field type of indexes more specific;
  gh-2494
• Store column type in tuple format;
  gh-3104
• Check column type in SQL parser;
  gh-2645
• Prohibit typeless columns;
  gh-3018
• Prohibit insertions into _trigger during transaction;
  gh-3239
• upper/lower support only default locale;
  gh-3052
• Use struct space * in SQL's structures;
  gh-3561

Server

• Introduce new SQL wire protocol;
  gh-3328
• Is nullable type attribute wanted by API in IPROTO;
  gh-3373
• Add collation field to tuple format;
  gh-2937
• Add string.fromhex() method;
  gh-2562
• Select input language in tarantoolctl;
  gh-2385
• Use Tarantool's structs for metadata during query compilation;
  gh-3369
• Resolve names for VIEW right after its creation;
  gh-3368

Bugs fixed

SQL

• Assertion if update;
  gh-3719
• Sequence recovery problem;
  gh-3712
• Prohibit columns' names in clause;
  gh-3695
• Assertion with undeclared function;
  gh-3671
• Assertion with large number in auto-increment column;
  gh-3670
• Assertion when dropping an index on an altered table;
  gh-3613
• net.box segmentation fault after "create table" with auto-increment;
  gh-3592
• Updates with non-standard clauses cause deletions;
  gh-3566
• Assertion with replace that would violate a unique constraint;
  gh-3565
• Assertion with trigger and two storage engines;
  gh-3551
• Pragma problems;
  gh-3541
• Assertion if guest makes default for-each-row trigger affecting nonexistent table;
  gh-3535
• Assertion for failed drop of a view that has a trigger;
  gh-3529
• Duplicate-key error with a char column containing digits;
  gh-3515
• ABORT and FAIL conflict actions inside transactions are broken;
  gh-3500
• Crash on table creation with PRIMARY INDEX and UNIQUE specifiers;
  gh-3498
• Constraint definition errors create unwanted objects;
  gh-3474
• Primary key can be declared with NULL;
  gh-3473
• SQL Tests failed on concurrent launch;
  gh-3472
• Sophisticated VIEW crashes;
  gh-3440
• RELEASE savepoint doesn't work;
  gh-3379
• Assertion fault on nested SELECT;
  gh-3353
• Segmentation fault;
  gh-3332
• Analyze on VIEW leads to assertion;
  gh-3324
• Ambiguous 'wrong schema version' error;
  gh-3323
• SAVEPOINT statement leads to assertion;
  gh-3313
• INSERT with SELECT is not working in some cases;
  gh-3307
• ON CONFLICT REPLACE is not working;
  gh-3293
• DROP INDEX leads to removal of statistics for all aliases;
  gh-3264
• Region leaks on SELECT;
  gh-3199
• Deferred foreign keys are broken;
  gh-2970
• Assertion fault when vdbe_debug is enabled;
  gh-2957
• Inserting wrong statistics into stat1 leads to incorrect behaviour;
  gh-2859
• Improve sqlite3ColumnOfIndex discrimination;
  gh-2376
• SQL select statement, read privilege;
  gh-2362
• SQL create table statement;
  gh-2350
• INTEGER column allows string values;
  gh-2315
• PRAGMA table_info shows string column as scalar;
  gh-3459
• example.lua does not start in 2.0;
  gh-3348
• IPROTO execute response is written to a wrong obuf;
  gh-3326
• Confusing error message for functional indexes;
  gh-3236
• Use collation struct instead of name;
  gh-3205
• Remove legacy SQL C API;
  gh-3192
• Strange sign of index uniqueness;
  gh-3189
• Use UNIQUE flag from backend's struct Index;
  gh-3181
• Finish cleanup in SQL FE struct Index;
  gh-3179
• Remove collation pointers from SQL FE;
  gh-3123
• Merge BtCursor and ta_cursor structures;
  gh-3120
• Remove COLPRIM flag from struct Column;
  gh-3118
• Parser doesn't handle incorrect collate sequence;
  gh-3010
• Error message with select ... indexed by;
  gh-2996
• Delete op_transaction and related vdbe attributes;
  gh-2992
• Check constraints do not work after autoincrement;
  gh-2981
• Remove unnecessary templates for binding parameters;
  gh-2948
• SQL identifiers and system spaces;
  gh-2927
• Remove sqlite authorization code;
  gh-2868
• Omit creation of index only on primary key;
  gh-2817
• Remove box_interator_key_def();
  gh-2425
• White space in SQL;
  gh-2371
• SQL subquery with =;
  gh-2366
• Remove ZEROBLOB() function;
  gh-2185
• Remove SQLITE_VERSION() etc.;
  gh-2184
• Remove LOAD_EXTENSION();
  gh-2183
• Remove REINDEX statement;
  gh-2174
• Remove CREATE VIRTUAL TABLE;
  gh-2170
• Remove WHERE expr from CREATE INDEX;
  gh-2165
• Remove BEGIN TRANSACTION;
  gh-2164
• Remove ATTACH DATABASE;
  gh-2163
• LIMIT clause doesn't perform type checking;
  gh-2515
• Division by zero should yield error or infinity;
  gh-2135

Server

• index:max() returns irrelevant tuple if there is no match;
  gh-3167
• Produce error if log_nonbclock is used and logging type does not support it;
  gh-3072
• No error if log_format=json and logging to syslog;
  gh-3014
• Lost format while tuple update;
  gh-3051
• box.schema.func.reload only work with a function name;
  gh-2946

Build

• Build fail with a statement that may fall through;
  gh-3658
• Ensure -Werror -Wall set for the whole src/;
  gh-3238
• Remove auto-generated files from source tree;
  gh-3183
• Undefined symbol "iconv_close";
  gh-3046

Other

• Non-informative error messages when configuring logger;
  gh-3556
• Assertion failed while configuring logging to syslogd;
  gh-3502

The full list of issues added or fixed is available at
https://github.com/tarantool/tarantool/issues?utf8=%E2%9C%93&q=is%3Aissue%20milestone%3A2.1.0%20is%3Aclosed