search

happyiwin / common-schema

Automatically exported from code.google.com/p/common-schema
0 stars 0 forks source link

json_to_xml returns NULL on correct JSON #51

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
Which version of common_schema are you using? 2.2, mysql 5.6

Which component is failing? json_to_xml function

What is the expected output? What do you see instead?
SELECT common_schema.json_to_xml(jsonValue) FROM Table =>
NULL

Can you provide with sample data?
{
    "strategy": "ALL_TO_ALL",
    "configs": [{
        "licenseUUID": "da5cea41-3223-11e2-bccc-76fcde5e1dd2",
        "hitTypeHashCode": 0,
        "sandboxHitTypeHashCode": 0,
        "channels": []
    },
    {
        "licenseUUID": "81bc094b-bf1d-4d79-93ff-95613c525a55",
        "hitTypeHashCode": 0,
        "sandboxHitTypeHashCode": 0,
        "channels": ["NATIVE"]
    }],
    "type": "MULTIPLE"
}

Please provide any additional information below.
Probably nested arrays are not processed correctly

Original issue reported on code.google.com by khame...@gmail.com on 3 Dec 2013 at 3:04

GoogleCodeExporter commented 8 years ago 
Make sure you have no new line characters

Original comment by jeffrey.carre on 4 Dec 2014 at 7:57