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

Improve Enum fields handling in SQL.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7
    • 2.0
    • sql

    Description

      Currently queries like this do not work in Ignite if we use enum field on the left side and enum constant name or ordinal on the right side:

      select * from A where my_enum = 'ENUM_CONST';
      select * from A where my_enum = 3;

      This is a huge usability issue.

      We can try to solve it by contributing `User defined Value types` in H2 and implementing the special value type for Enums to handle comparison with String (convert to enum by name) and with int (convert to enum by ordinal).

      Attachments

        There are no Sub-Tasks for this issue.

        Activity

          People

            Unassigned Unassigned
            sergi Sergei Vladykin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: