Postgres: Error when querying with json operator

[robbestad]

Querying json fields with the ->> operator gives an error using Zend\Db\Sql\Sql

Sample query:

array('d' => 'products_description'), 'p.id = d.id', array('id',"data->>'description'")

error:

"detail": "SQLSTATE[42703]: Undefined column: 7 ERROR:  column d.data\"-\">\">\"'\"description\"' does not exist\nLINE 1: SELECT \"p\".*, \"d\".\"data\"\"-\"\">\"\">\"\"'\"\"description\"\"'\" AS \"dat...\n                      ^"

[mkroeders]

Not tested, but got it for now working

Zend\Db\Adapter\Platform\Postgresql

Replace quoteIdentifierInFragment with the following code

`public function quoteIdentifierInFragment($identifier, array $safeWords = array())
{
$jsonParts = preg_split('#(->{1,2}|#>{1,2})#', $identifier, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
$identifier = array_shift($jsonParts);

    $parts = preg_split('#([\.\s\W])#', $identifier, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
    if ($safeWords) {
        $safeWords = array_flip($safeWords);
        $safeWords = array_change_key_case($safeWords, CASE_LOWER);
    }

    foreach ($parts as $i => $part) {
        if ($safeWords && isset($safeWords[strtolower($part)])) {
            continue;
        }
        switch ($part) {
            case ' ':
            case '.':
            case '*':
            case 'AS':
            case 'As':
            case 'aS':
            case 'as':
                break;
            default:
                $parts[$i] = '"' . str_replace('"', '\\' . '"', $part) . '"';
        }
    }

    if (count($jsonParts) > 1) {
        $last = array_pop($jsonParts);
        $lastParts = preg_split('#([\.\s\W])#', $last, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY);
        array_push($jsonParts, array_shift($lastParts));

        foreach($jsonParts as $part) {
            switch ($part) {
                case '#>' :
                case '#>>' :
                case '->' :
                case '->>' :
                    array_push($parts, $part);
                    continue;

                default :
                    array_push($parts, $this->quoteValue($part));
            }
        }
        array_push($parts, $this->quoteIdentifierInFragment(implode(' ', $lastParts), $safeWords));
    }

    return implode('', $parts);
}`

Again not tested

[GeeH]

This issue has been closed as part of the bug migration program as outlined here - http://framework.zend.com/blog/2016-04-11-issue-closures.html