Overview

Project website www.tarantool.io/en/doc/latest
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository git@github.com:tarantool/doc.git
Repository branch test-weblate
Weblate repository http://weblate.tarantool.io/git/testing_project/documentation-referencereference_sqlsql-features/
File mask locale/*/LC_MESSAGES/reference/reference_sql/sql_plus_lua.po
Translation file Not available
Last change None
Last author None

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 106 4,271 35,926
Translated 100% 106 100% 4,271 100% 35,926
Needs editing 0% 0 0% 0 0% 0
Read-only 100% 106 100% 4,271 100% 35,926
Failing checks 3% 4 5% 236 6% 2,324
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 106 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Quick numbers

4,271
Hosted words
106
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+100%
—
Contributors
—
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

box.schema.func.drop('_TABLE_CONSTRAINTS_OPTS_UNIQUE',{if_exists = true})
function _TABLE_CONSTRAINTS_OPTS_UNIQUE (opts) return require('msgpack').decode(opts).unique end
box.schema.func.create('_TABLE_CONSTRAINTS_OPTS_UNIQUE',
{language = 'LUA',
returns = 'boolean',
body = [[function (opts) return require('msgpack').decode(opts).unique end]],
param_list = {'string'},
exports = {'LUA', 'SQL'},
is_sandboxed = false,
setuid = false,
is_deterministic = false})
box.schema.role.grant('public', 'execute', 'function', '_TABLE_CONSTRAINTS_OPTS_UNIQUE')
pcall(function ()
box.schema.role.revoke('public', 'read', 'space', '_TABLE_CONSTRAINTS', {if_exists = true})
end)
box.execute([[DROP VIEW IF EXISTS _table_constraints;]])
box.execute([[
CREATE VIEW _table_constraints AS SELECT
CAST(NULL AS STRING) AS constraint_catalog,
CAST(NULL AS STRING) AS constraint_schema,
"name" AS constraint_name,
(SELECT "name" FROM "_vspace" x WHERE x."id" = y."id") AS table_name,
CASE WHEN "iid" = 0 THEN 'PRIMARY' ELSE 'UNIQUE' END AS constraint_type,
CAST(NULL AS STRING) AS initially_deferrable,
CAST(NULL AS STRING) AS deferred,
CAST(NULL AS STRING) AS enforced,
"id" AS id,
"iid" AS iid,
"type" AS index_type
FROM "_vindex" y
WHERE _table_constraints_opts_unique("opts") = TRUE;
]])
box.schema.role.grant('public', 'read', 'space', '_TABLE_CONSTRAINTS')
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

tarantool>SELECT constraint_name, constraint_type, table_name, id, iid, index_type
> FROM _table_constraints
> LIMIT 5;
OK 5 rows selected (0.0 seconds)
+-----------------+-----------------+-------------+-----+-----+------------+
| CONSTRAINT_NAME | CONSTRAINT_TYPE | TABLE_NAME | ID | IID | INDEX_TYPE |
+-----------------+-----------------+-------------+-----+-----+------------+
| primary | PRIMARY | _schema | 272 | 0 | tree |
| primary | PRIMARY | _collation | 276 | 0 | tree |
| name | UNIQUE | _collation | 276 | 1 | tree |
| primary | PRIMARY | _vcollation | 277 | 0 | tree |
| name | UNIQUE | _vcollation | 277 | 1 | tree |
+-----------------+-----------------+-------------+-----+-----+------------+
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

This has only the constraints (primary-key and unique-key) that can be found by looking at the :ref:`_index <box_space-index>` space. It is not a list of indexes, that is, it is not equivalent to INFORMATION_SCHEMA.STATISTICS. The columns of the index are not taken because in standard SQL they would be in a different table.
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

_TABLE_CONSTRAINTS view
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

Users who select from this view will need 'read' privilege on the _ck_constraint space.
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

pcall(function ()
box.schema.role.revoke('public', 'read', 'space', '_CHECK_CONSTRAINTS', {if_exists = true})
end)
box.execute([[DROP VIEW IF EXISTS _check_constraints;]])
box.execute([[
CREATE VIEW _check_constraints AS SELECT
CAST(NULL AS STRING) AS constraint_catalog,
CAST(NULL AS STRING) AS constraint_schema,
"name" AS constraint_name,
"code" AS check_clause,
(SELECT "name" FROM "_vspace" x WHERE x."id" = y."space_id") AS space_name,
"language" AS language,
"is_deferred" AS is_deferred,
"space_id" AS space_id
FROM "_ck_constraint" y;
]])
box.schema.role.grant('public', 'read', 'space', '_CHECK_CONSTRAINTS')
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

tarantool>SELECT constraint_name, check_clause, space_name, language
> FROM _check_constraints;
OK 3 rows selected (0.0 seconds)
+------------------------+-------------------------+------------+----------+
| CONSTRAINT_NAME | CHECK_CLAUSE | SPACE_NAME | LANGUAGE |
+------------------------+-------------------------+------------+----------+
| ck_unnamed_Employees_1 | first_name LIKE 'Влад%' | Employees | SQL |
| ck_unnamed_Critics_1 | first_name LIKE 'Vlad%' | Critics | SQL |
| ck_unnamed_ACTORS_1 | salary > 0 | ACTORS | SQL |
+------------------------+-------------------------+------------+----------+
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

_CHECK_CONSTRAINTS view
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

Users who select from this view will need 'read' privilege on the _fk_constraint space.
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_plus_lua — English

In this example child_cols or parent_cols are not taken from the _fk_constraint space because in standard SQL those are in a separate table.
a year ago
Browse all translation changes