tesseract
  • 1. Getting Started
    • 1.1. Installation
    • 1.2. Running the Server
  • 2. SQL Reference
    • 2.1. BEGIN
      • 2.1.1. See Also
    • 2.2. COMMIT
      • 2.2.1. Syntax
      • 2.2.2. Overview
      • 2.2.3. Compatibility
      • 2.2.4. See Also
    • 2.3. CREATE INDEX
      • 2.3.1. Syntax
      • 2.3.2. Overview
    • 2.4. CREATE NOTIFICATION
      • 2.4.1. Syntax
      • 2.4.2. Notes
    • 2.5. DELETE
      • 2.5.1. Syntax
    • 2.6. DROP INDEX
      • 2.6.1. Syntax
    • 2.7. DROP NOTIFICATION
      • 2.7.1. Syntax
    • 2.8. DROP TABLE
      • 2.8.1. Syntax
    • 2.9. INSERT
      • 2.9.1. Syntax
      • 2.9.2. Examples
    • 2.10. ROLLBACK
      • 2.10.1. Syntax
      • 2.10.2. Overview
      • 2.10.3. Compatibility
      • 2.10.4. See Also
    • 2.11. SELECT
      • 2.11.1. Syntax
    • 2.12. START TRANSACTION
      • 2.12.1. Syntax
      • 2.12.2. Overview
      • 2.12.3. Compatibility
    • 2.13. UPDATE
      • 2.13.1. Syntax
  • 3. Functions and Operators
    • 3.1. Data Types
    • 3.2. Operators
      • 3.2.1. Arithmetic
      • 3.2.2. Equality
      • 3.2.3. Greater or Less Than
      • 3.2.4. Concatenation
      • 3.2.5. Logical
      • 3.2.6. Regular Expressions
        • 3.2.6.1. Examples
      • 3.2.7. Checking Types
      • 3.2.8. Set Membership
      • 3.2.9. Containment
      • 3.2.10. Operator Precedence
    • 3.3. Aggregate Functions
      • 3.3.1. AVG() – Average
      • 3.3.2. COUNT() – Count records
      • 3.3.3. MAX() – Maximum value
      • 3.3.4. MIN() – Minimum value
      • 3.3.5. SUM() – Total
    • 3.4. Mathematical Functions
      • 3.4.1. ABS() – Absolute value
      • 3.4.2. CEIL() – Round up
      • 3.4.3. COS() – Cosine
      • 3.4.4. FLOOR() – Round down
      • 3.4.5. SIN() – Sine
      • 3.4.6. SQRT() – Square root
      • 3.4.7. TAN() – Tangent
    • 3.5. String Functions
      • 3.5.1. BIT_LENGTH() – Bit Length
      • 3.5.2. CHAR_LENGTH() – Character Length
      • 3.5.3. OCTET_LENGTH() – Octet Length
  • 4. Engine
    • 4.1. Grouping
      • 4.1.1. Extract Expressions
      • 4.1.2. Grouping
      • 4.1.3. Lua Processing
      • 4.1.4. Ensure Single Row
    • 4.2. Indexing
    • 4.3. Tables
    • 4.4. Transactions
      • 4.4.1. Overview
      • 4.4.2. Internals
      • 4.4.3. Collisions
      • 4.4.4. Deadlocks
    • 4.5. Server Protocol
      • 4.5.1. Connect
      • 4.5.2. Request
      • 4.5.3. Response
  • 5. Testing
    • 5.1. Basic Test (sql)
      • 5.1.1. Result (result)
      • 5.1.2. Result in Any Order (result-unordered)
      • 5.1.3. Parser (as)
      • 5.1.4. Ignoring the Parser (parse)
      • 5.1.5. Commenting (comment)
      • 5.1.6. Tags (tags)
      • 5.1.7. Repeating Tests (repeat)
    • 5.2. Failures
      • 5.2.1. Expecting Errors (error)
      • 5.2.2. Expecting Warnings (warning)
    • 5.3. Data Sets (data)
      • 5.3.1. Randomizing Data (data-randomized)
    • 5.4. Verifying Notifications
  • 6. Changelog
    • 6.1. v1.0.0-alpha1 (Aurora)
    • 6.2. v1.0.0-alpha2 (Binary Star)
    • 6.3. v1.0.0-alpha3 (Comet)
    • 6.4. v1.0.0-alpha4 (Dark Matter)
  • 7. FAQ
    • 7.1. Really? Another SQL Database?
    • 7.2. I Thought SQL Was Dead?
    • 7.3. What Are the Goals of Tesseract?
  • 8. Appendix
    • 8.1. Formatting
      • 8.1.1. Basic
      • 8.1.2. SQL Examples
      • 8.1.3. Syntax Descriptions
      • 8.1.4. Notes
      • 8.1.5. Tables
 
tesseract
  • Docs »
  • 4. Engine
  • Edit on GitHub

4. EngineΒΆ

  • 4.1. Grouping
    • 4.1.1. Extract Expressions
    • 4.1.2. Grouping
    • 4.1.3. Lua Processing
    • 4.1.4. Ensure Single Row
  • 4.2. Indexing
  • 4.3. Tables
  • 4.4. Transactions
    • 4.4.1. Overview
    • 4.4.2. Internals
    • 4.4.3. Collisions
    • 4.4.4. Deadlocks
  • 4.5. Server Protocol
    • 4.5.1. Connect
    • 4.5.2. Request
    • 4.5.3. Response
Next Previous

© Copyright 2015, Elliot Chance.

Built with Sphinx using a theme provided by Read the Docs.