Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5938

TextTable removes the quoted character, when it matches the delimiter

    Details

    • Sprint:
      DV Sprint 62
    • Story Points:
      0.5
    • Steps to Reproduce:
      Hide

      Run the following query:

      select * from TextTable (
      	'greeting,"hello, world"'
      	Columns 
      		x string
      	Row Delimiter ','
      	Delimiter ';'
      	Quote '"'
      )x ;;
      
      Show
      Run the following query: select * from TextTable ( 'greeting, "hello, world" ' Columns x string Row Delimiter ',' Delimiter ';' Quote '"' )x ;;

      Description

      The TextTable removes characters when they are inside a quoted field, but at the same time match the delimiter. The field is not delimited (and that's great), but the character should not be removed from it either.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                dalex005 Dmitrii Pogorelov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2 hours
                  2h
                  Remaining:
                  Time Spent - 1 hour, 30 minutes Remaining Estimate - 30 minutes
                  30m
                  Logged:
                  Time Spent - 1 hour, 30 minutes Remaining Estimate - 30 minutes
                  1h 30m