Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-6055

SQL: Add String length constraint

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.1
    • 2.7
    • sql

    Description

      We should support CHAR(X) and VARCHAR{X syntax. Currently, we ignore it. First, it affects semantics. E.g., one can insert a string with greater length into a cache/table without any problems. Second, it limits efficiency of our default configuration. E.g., index inline cannot be applied to String data type as we cannot guess it's length.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. IGNITE-8385 SQL: Allow variable-length values in index leafs

          • Major - Major loss of function.
          • Open
          depends upon

          Task - A task that needs to be done. IGNITE-8703 JDBC thin: drop support of versions older than 2.5.0

          • Major - Major loss of function.
          • Closed
          duplicates

          Task - A task that needs to be done. IGNITE-5361 SQL: naive handling of fixed length CHAR columns

          • Major - Major loss of function.
          • Closed
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-5809 SQL: Add precision and scale support for table fields.

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-8331 SQL: Add Decimal precision and scale constraint

          • Major - Major loss of function.
          • Resolved
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-7691 Provide info about DECIMAL column scale and precision

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Web Link App to check backward compatibility

          Web Link GitHub Pull Request #3973

          Web Link Run All

          Web Link Upsource

          Activity

            People

              nizhikov Nikolay Izhikov
              vozerov Vladimir Ozerov
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: