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

Valid names can have almost any character, except periods. No periods!

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.1
    • Fix Version/s: 7.4
    • Component/s: Validation
    • Labels:
      None

      Description

      This SQL:
      SELECT t.* FROM
      (EXEC WeatherData.invoke(action = 'GET', endpoint = QUERYSTRING('', '38.99,-77.02 39.70,-104.80 47.6,-122.30' AS listLatLon, 'time-series' AS product, '2004-01-01T00:00:00' AS "begin", '2013-04-20T00:00:00' AS "end", 'maxt' AS maxt, 'mint' AS mint))) AS w, XMLTABLE('/dwml/data/location' PASSING result COLUMNS "location-key" string, lattitude string PATH 'point/@latitude', longitude string PATH 'point/@longitude') AS t

      will fail as location-key contains a hyphen. Actually, the only character which is not valid in a name is the period. Please verify with the Teiid server crew, but we should loosen up the validation criteria as appropriate.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                pnittel Paul Nittel
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: