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

TextTable removes the quoted character, when it matches the delimiter

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 14.0, 13.0.3, 13.1.1
    • 13.1
    • Query Engine
    • None
    • DV Sprint 62
    • 0.5
    • 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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            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