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

TextTable removes the quoted character, when it matches the delimiter

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical 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 ;;

      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.

            rhn-engineering-shawkins Steven Hawkins
            dalex005 Dmitrii Pogorelov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                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