Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-24586

SQL functions should return STRING instead of VARCHAR(2000)

    XMLWordPrintableJSON

Details

    • Hide
      Functions that returned VARCHAR(2000) in 1.14, return VARCHAR with maximum length now. In particular this includes:

      JSON_VALUE
      CHR
      REVERSE
      SPLIT_INDEX
      REGEXP_EXTRACT
      PARSE_URL
      FROM_UNIXTIME
      DECODE
      DATE_FORMAT
      CONVERT_TZ
      Show
      Functions that returned VARCHAR(2000) in 1.14, return VARCHAR with maximum length now. In particular this includes: JSON_VALUE CHR REVERSE SPLIT_INDEX REGEXP_EXTRACT PARSE_URL FROM_UNIXTIME DECODE DATE_FORMAT CONVERT_TZ

    Description

      There are some SQL functions which currently return VARCHAR(2000). With more strict CAST behavior from FLINK-24413, this could become an issue.

      The following functions return VARCHAR(2000) and should be changed to return STRING instead:

      • JSON_VALUE
      • JSON_QUERY
      • JSON_OBJECT
      • JSON_ARRAY

      There are also some more functions which should be evaluated:

      • CHR
      • REVERSE
      • SPLIT_INDEX
      • PARSE_URL
      • FROM_UNIXTIME
      • DECODE

      Attachments

        Issue Links

          Activity

            People

              nicholasjiang Nicholas Jiang
              airblader Ingo Bürk
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: