SQL guides

How-to guides / SQL guides

Overview
Getting started
How-to guides
Concepts
CRUD operations
Cluster on Cartridge
Administration
Connectors
Tarantool Enterprise Edition
Reference
Contributing
Releases
- Release calendar
  - Release lifetime table
- Major features
- Tarantool 2.11 (LTS)
- EOL versions
  - Tarantool 2.10.8
    - Overview
    - Compatibility
    - Functionality added or changed
      - Box
      - Test
        
        Fuzz
      - Build
    - Bugs fixed
      - Core
      - Memtx
      - Vinyl
      - Replication
      - LuaJIT
      - Lua
        
        Netbox
      - Box
      - Console
      - Datetime
      - Http
      - Msgpack
  - Tarantool 2.10.7
    - Overview
    - Compatibility
    - Bugs fixed
      - Core
      - Replication
      - LuaJIT
      - SQL
      - Datetime
      - Build
  - Tarantool 2.10.6
    - Overview
    - Compatibility
    - Bugs fixed
      - Core
      - LuaJIT
      - Box
  - Tarantool 2.10.5
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Build
    - Bugs fixed
      - Core
      - Memtx
      - Vinyl
      - Replication
      - Raft
      - LuaJIT
      - Lua
      - SQL
      - Box
      - Datetime
      - Fiber
      - Log
      - Build
  - Tarantool 2.10.4
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - SQL
      - Build
    - Bugs fixed
      - Core
      - Memtx
      - LuaJIT
      - Lua
      - SQL
      - Box
      - Datetime
  - Tarantool 2.10.3
    - Overview
    - Compatibility
    - Functionality added or changed
      - Build
    - Bugs fixed
      - Core
      - Memtx
      - Replication
      - Raft
      - Lua
        
        Merger
        
        Popen
      - Box
      - Synchro
      - Uri
  - Tarantool 2.10.2
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
    - Bugs fixed
      - Core
      - Replication
      - Box
  - Tarantool 2.10.1
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Datetime
      - Decimal
      - Tuple
      - Build
    - Bugs fixed
      - Core
      - Memtx
      - Vinyl
      - Replication
      - LuaJIT
      - Lua
      - SQL
      - Datetime
      - HTTP client
      - Build
  - Tarantool 2.10.0
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Memtx
      - Vinyl
      - Replication
      - Raft
      - LuaJIT
      - Lua
        
        Datetime
        
        Digest
        
        Fiber
        
        Log
        
        Msgpack
        
        Netbox
        
        Schema
      - SQL
      - Box
      - Datetime
      - Fiber
      - Luarocks
      - Xlog
      - Build
    - Bugs fixed
      - Core
      - Memtx
      - Vinyl
      - Replication
      - Raft
      - LuaJIT
      - Lua
        
        Triggers
      - SQL
      - Box
      - Datetime
      - HTTP client
      - Mvcc
      - Net.box
      - Recovery
      - Tarantoolctl
      - Build
  - Tarantool 2.8.4
    - Overview
    - Compatibility
    - Functionality added or changed
      - Build
    - Bugs fixed
      - Core
      - Vinyl
      - Raft
      - LuaJIT
      - Lua
      - Box
      - HTTP client
      - Recovery
  - Tarantool 2.8.3
    - Overview
    - Compatibility
    - Functionality added or changed
      - LuaJIT
      - Build
    - Bugs fixed
      - Core
      - Replication
      - LuaJIT
      - Lua
      - Triggers
      - SQL
      - Build
  - Tarantool 2.8.2
    - Overview
    - Compatibility
    - Functionality added or changed
      - LuaJIT
      - Lua
      - Logging
      - SQL
      - Build
    - Bugs fixed
      - Core
      - Vinyl
      - Replication
      - Raft
      - LuaJIT
      - Lua
        
        Triggers
      - SQL
      - MVCC
  - Tarantool 2.8.1
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Replication
      - LuaJIT
      - Tools
      - Build
      - Testing
    - Bugs fixed
      - Core
      - Replication
      - Swim
      - LuaJIT
      - Lua
      - SQL
      - Build
  - Tarantool 2.7.3
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - LuaJIT
      - Lua
      - SQL
      - Build
    - Bugs fixed
      - Core
      - Vinyl
      - Replication
      - Raft
      - LuaJIT
      - Lua
        
        Triggers
      - SQL
      - MVCC
  - Tarantool 2.7.2
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Replication
      - Build
      - Testing
    - Bugs fixed
      - Core
      - Replication
      - Module swim
      - LuaJIT
      - Lua
      - SQL
      - Build
  - Tarantool 2.7.1
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - LuaJIT
      - Lua
      - SQL
      - Replication
      - Build
      - Miscellaneous
    - Bugs fixed
      - Core
      - Replication
      - SQL
      - LuaJIT
      - Lua
      - Memtx
  - Tarantool 2.6.3
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Replication
      - Build
      - Testing
    - Bugs fixed
      - Core
      - Replication
      - Swim
      - Lua
      - SQL
      - LuaJIT
      - Build
  - Tarantool 2.6.2
    - Overview
    - Compatibility
    - Functionality added or changed
      - Replication
      - Lua
      - Build
    - Bugs fixed
      - Core
      - Replication
      - SQL
      - LuaJIT
      - Lua
      - Memtx
  - Tarantool 2.6.1
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Vinyl
      - LuaJIT
      - SQL
      - Replication
      - Build
      - Misc
      - Module API
    - Bugs fixed
      - Core
      - Replication
      - LuaJIT
      - Lua
      - Memtx
      - Module API
  - Tarantool 2.5.3
    - Overview
    - Compatibility
    - Functionality added or changed
      - Replication
      - Lua
      - Build
    - Bugs fixed
      - Core
      - Replication
      - SQL
      - LuaJIT
      - Lua
      - Memtx
  - Tarantool 2.5.2
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Module API
    - Bugs fixed
      - Core
      - Replication
      - LuaJIT
      - Lua
      - SQL
      - Misc
      - Module API
  - Tarantool 2.5.1
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Vinyl
      - SQL
      - Replication
      - Build
      - Misc
    - Bugs fixed
      - Core
      - Replication
      - Lua
      - SQL
      - Vinyl
      - Memtx
      - Misc
  - Tarantool 2.4.3
    - Overview
    - Compatibility
    - Functionality added or changed
      - Module API
    - Bugs fixed
      - Core
      - Replication
      - LuaJIT
      - Lua
      - SQL
      - Misc
      - Module API
  - Tarantool 2.4.2
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Misc
    - Bugs fixed
      - Core
      - Replication
      - Lua
      - SQL
      - Vinyl
      - Memtx
  - Tarantool 2.4.1
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Lua
      - Misc
    - Bugs fixed
      - Core
      - Replication
      - Lua
      - SQL
      - Types related changes
        
        HTTP client
      - LuaJIT
      - Vinyl
      - Misc
    - Building from sources
  - Tarantool 2.3.3
    - Overview
    - Compatibility
    - Bugs fixed
      - Core
      - Replication
      - Lua
      - SQL
      - Vinyl
      - Memtx
  - Tarantool 2.3.2
    - Overview
    - Compatibility
    - Bugs fixed
      - Core
      - Replication
      - Lua
      - SQL
      - HTTP client
      - LuaJIT
      - Vinyl
      - Misc
        
        Building from sources
  - Tarantool 2.3.1
    - Overview
    - Compatibility
    - Functionality added or changed
      - SQL
      - Core
      - Replication
      - Lua
        
        HTTP client
      - Misc
    - Bugs fixed
      - SQL
      - Core
      - Replication
      - Lua
        
        HTTP client
        
        Console Lua output
      - LuaJIT
      - Misc
        
        Building from sources
  - Tarantool 2.2.3
    - Overview
    - Compatibility
    - Bugs fixed
      - Core
      - Replication
      - Lua
      - SQL
        
        HTTP client
      - LuaJIT
      - Vinyl
      - Misc
        
        Building from sources
  - Tarantool 2.2.2
    - Overview
    - Compatibility
    - Functionality added or changed
      - Core
      - Lua
      - Misc
    - Bugs fixed
      - SQL
      - Core
      - Replication
      - Lua
        
        HTTP client
        
        Console Lua output
      - LuaJIT
      - Misc
        
        Building from sources
  - Tarantool 2.2.1
    - Overview
    - Compatibility
    - Functionality added or changed
  - Tarantool 2.1.2 and earlier
  - Tarantool 1.10.15
    - Overview
    - Compatibility
    - Functionality added or changed
      - Build
    - Bugs fixed
      - Core
      - Vinyl
      - LuaJIT
      - Fiber
      - Log
      - Build
  - Tarantool 1.10.14
    - Overview
    - Compatibility
    - Functionality added or changed
      - Build
    - Bugs fixed
      - Core
      - Vinyl
      - Replication
      - LuaJIT
      - Box
      - Recovery
  - Tarantool 1.10.13
    - Overview
    - Compatibility
    - Functionality added or changed
      - Build
    - Bugs fixed
      - Core
      - Vinyl
      - Replication
      - LuaJIT
      - Box
      - Recovery
  - Tarantool 1.10.12
    - Overview
    - Compatibility
    - Functionality added or changed
      - Build
    - Bugs fixed
      - Core
      - Replication
      - LuaJIT
      - Lua
      - Triggers
      - Build
  - Tarantool 1.10.11
    - Overview
    - Compatibility
    - Functionality added or changed
      - LuaJIT
      - Build
    - Bugs fixed
      - Core
      - Vinyl
      - Replication
      - LuaJIT
      - Lua
        
        Triggers
  - Tarantool 1.10.10
    - Overview
    - Compatibility
    - Functionality added or changed
      - Build
      - Testing
    - Bugs fixed
      - Core
      - Lua
      - Build
  - Tarantool 1.10.9
    - Overview
    - Compatibility
    - Functionality added or changed
      - Build
      - Misc
    - Bugs fixed
      - Core
      - LuaJIT
      - Lua
  - Tarantool 1.10.8
    - Overview
    - Compatibility
    - Functionality added or changed
      - Module API
    - Bugs fixed
      - Core
      - Lua
      - LuaJIT
      - Misc
      - Module API
  - Tarantool 1.10.7
    - Overview
    - Compatibility
    - Bugs fixed
      - Core
      - Lua
      - LuaRocks
      - Vinyl
  - Tarantool 1.10.6
    - Overview
    - Compatibility
    - Bugs fixed
      - Core
      - Replication
      - Lua
        
        HTTP client
      - LuaJIT
      - Vinyl
      - Misc
      - Building from sources
  - Tarantool 1.10.5
    - Overview
    - Compatibility
    - Functionality added or changed
      - Lua
      - Misc
    - Bugs fixed
      - Core
      - Replication
      - Lua
        
        HTTP client
      - LuaJIT
      - Misc
        
        Building from sources
  - Tarantool 1.10.0–1.10.4
  - Tarantool 1.9
  - Tarantool 1.8
  - Tarantool 1.7
  - Tarantool 1.6
- Release policies
  - Tarantool release policy
  - Tarantool legacy release policy
- Compatibility guarantees

How-to guides / SQL guides

Version:

2.11

SQL guides

This section contains hands-on SQL guides. You might also want to read the in-depth SQL reference.

Managing leader elections

SQL beginners’ guide