Derby
  1. Derby
  2. DERBY-1776

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6, 10.3.1.4
    • Fix Version/s: 10.2.1.6, 10.3.1.4
    • Component/s: SQL
    • Labels:
      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?

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

        Activity

        Gavin made changes -
        Workflow jira [ 12382630 ] Default workflow, editable Closed status [ 12798120 ]
        A B made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Andrew McIntyre made changes -
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Derby Info [Patch Available]
        A B made changes -
        Attachment d1776_reuseInt.patch [ 12341223 ]
        Mike Matrigali made changes -
        Fix Version/s 10.2.1.0 [ 11187 ]
        Fix Version/s 10.3.0.0 [ 12310800 ]
        A B made changes -
        Derby Info [Patch Available]
        Assignee A B [ army ]
        A B made changes -
        Attachment d1776_v1.patch [ 12341091 ]
        Daniel John Debrunner made changes -
        Field Original Value New Value
        Description create table t (i int, x xml);
        select xmlserialize(x) 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 be regular parsing?
        create table t (i int, x xml);
        select xmlserialize(x) 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?
        Daniel John Debrunner created issue -

          People

          • Assignee:
            A B
            Reporter:
            Daniel John Debrunner
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development