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 (Inactive)
              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