Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1776

ERROR 42Z72: XML syntax error; missing keyword(s): 'AS'. - Misleading text

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.2.1.6, 10.3.1.4
    • 10.2.1.6, 10.3.1.4
    • SQL
    • None

    Description

      create table t (i int, x xml);
      select xmlserialize from t;

      ERROR 42Z72: XML syntax error; missing keyword(s): 'AS'.

      This is not an 'XML Syntax error', it's a syntax in the SQL language. No need to have a special error messgae here, wouldn't the error be caught by regular parsing?

      Attachments

        1. d1776_v1.patch
          7 kB
          A B
        2. d1776_reuseInt.patch
          1 kB
          A B

        Activity

          People

            army A B
            djd Daniel John Debrunner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: