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

SQL: Create a view with list of existing COLUMNS

    XMLWordPrintableJSON

Details

    • Task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql
    • Docs Required

    Description

      Need to expose SQL system view with COLUMNS information.

      Need to investigate more deeper which of information should be there.

       

      As start point we can take https://dev.mysql.com/doc/refman/8.0/en/columns-table.html 

      Columns description:

      Name Type Description
      SCHEMA_NAME string Schema name
      TABLE_NAME string Table name
      COLUMN_NAME string Column name
      ORDINAL_POSITION int Column ordinal. Starts with 1
      DEFAULT VALUE string Defaut column's value
      IS_NULLABLE boolean Nullable flag corresponds to QueryEntity#setNotNullFields
      DATA_TYPE string SQL data type
      CHARACTER_LENGTH int Size for char CAHR and VARCHAR types
      NUMERIC_PRECISION int Precision for numeric types
      NUMERIC_SCALE int Scale for numeric types
      IS_AFFINITY_KEY boolean true whan the column is affinity key
      IS_HIDDEN boolean true for hidden _ley nad _val columns. false for all columns available by asterisk mask

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-10745 SQL: jdbc metadata's getColumns returns wrong value for "ORDINAL_POSITION"

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

          Task - A task that needs to be done. IGNITE-11440 H2 SHOW commands support

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. IGNITE-11720 Document new SQL system view "COLUMNS"

          • Major - Major loss of function.
          • Resolved
          is blocked by

          Task - A task that needs to be done. IGNITE-11470 Views don't show in Dbeaver

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

          Web Link GitHub Pull Request #6240

          Web Link Tests results

          Activity

            People

              Unassigned Unassigned
              jooger Iurii Gerzhedovich
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 40m
                  1h 40m