Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2866

Space in string in Transformation Editor is replaced with <undefined> after Save/Validate SQL

XMLWordPrintable

    • Hide

      1. paste "SELECT 'aaa bbb' AS results" in Transformation editor.
      2. click Save/Validate SQL button
      3. transformation should change to "SELECT 'aaa<undefined>bbb' AS results"

      Show
      1. paste " SELECT 'aaa bbb' AS results " in Transformation editor. 2. click Save/Validate SQL button 3. transformation should change to " SELECT 'aaa<undefined>bbb' AS results "

      Any space in string in Transformation Editor is replaced with <undefined> after Save/Validate SQL action. (see steps to reproduce and attachments)

        1. after.png
          after.png
          5 kB
        2. before.png
          before.png
          7 kB

            [TEIIDDES-2866] Space in string in Transformation Editor is replaced with <undefined> after Save/Validate SQL

            Barry LaFond added a comment -

            10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/c70b59a28fbb7754299b0644de99718e5f75c1e1

            Barry LaFond added a comment - 10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/c70b59a28fbb7754299b0644de99718e5f75c1e1

            Matus Makovy added a comment -

            Video:
            https://dl.dropboxusercontent.com/u/21733588/undefined-bug.mov

            Matus Makovy added a comment - Video: https://dl.dropboxusercontent.com/u/21733588/undefined-bug.mov

            Matus Makovy added a comment -

            blafond I reproduced this today on my MAC.

            I started with clean workspace

            1. Create model project
            2. Create view model with table and one column
            3. Paste transformation SQL "SELECT 'aaa aaa' as c1"
            4. Save model
            5. Define server
            6. Start server
            7. Edit Transformation SQL and save again
            8. <undefined> appears in SQL

            I will add a video.

            TD 10.0.1
            MAC
            JBDS 9.1.0.GA
            Java 1.8.0_71

            Matus Makovy added a comment - blafond I reproduced this today on my MAC. I started with clean workspace Create model project Create view model with table and one column Paste transformation SQL "SELECT 'aaa aaa' as c1" Save model Define server Start server Edit Transformation SQL and save again <undefined> appears in SQL I will add a video. TD 10.0.1 MAC JBDS 9.1.0.GA Java 1.8.0_71

            Stanislav Kaleta (Inactive) added a comment -

            blafond mmakovy@redhat.com It does not happen if I use clean (just installed) designer, but it starts to happen in some point while working with designer. I didn't find out when, yet.

            Stanislav Kaleta (Inactive) added a comment - blafond mmakovy@redhat.com It does not happen if I use clean (just installed) designer, but it starts to happen in some point while working with designer. I didn't find out when, yet.

            Matus Makovy added a comment -

            blafond I've also seen this, there is a certain sequence of steps that you have to do in order to see this. I'll try to investigate this more...

            Matus Makovy added a comment - blafond I've also seen this, there is a certain sequence of steps that you have to do in order to see this. I'll try to investigate this more...

            Barry LaFond added a comment -

            skaleta@redhat.com I can't seem to reproduce this. I tested both a Designer 10.0.Final kit and my local 10.0.1 (Linux).

            Barry LaFond added a comment - skaleta@redhat.com I can't seem to reproduce this. I tested both a Designer 10.0.Final kit and my local 10.0.1 (Linux).

              blafond Barry LaFond
              skaleta@redhat.com Stanislav Kaleta (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: