Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-12251 Rework the Table API & SQL type system
  3. FLINK-12874

Improve the semantics of zero length character strings

    XMLWordPrintableJSON

    Details

      Description

      Zero-length character strings need special treatment as the SQL standard forbids to declare those type of character strings. For the type inference (e.g. determine the return type of a TRIM('')) it should be possible to return zero-lengths VARCHAR types.

       

      In any case, those type should not have a serializable string representation. Similar behavior is done in the Oracle system: SELECT DUMP(TRIM('')) AS tt FROM dual; returns NULL.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                twalthr Timo Walther
                Reporter:
                twalthr Timo Walther
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

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