[PHOENIX-2320] Not able to run upsert query over phoenix query server.

• Type: Wish
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Assignee: Josh Elser
• Reporter: Appasaheb Sawant
• Created: 14/Oct/15 16:52
• Updated: 07/Apr/16 00:30
• Resolved: 25/Jan/16 02:56

Description

Not able to run upsert query over phoenix query server. Select query works but for upsert query records are not inserted into phoenix.

This is CODE

<?php
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,"http://localhost:8765/");
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$headers = array();
// For Select.
//$headers[] = 'request:

{"request":"prepareAndExecute","connectionId":"aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa","sql":"select * from BLOG.POST"}

';

// For Upsert.
$headers[] = 'request:

{"request":"prepareAndExecute","connectionId":"aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa","sql":"UPSERT INTO BLOG.POST (POST_ID,TITLE,CONTENT) values (\'aa11111\',\'Test Title\',\'this is test post content\')"}

';
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
$server_output = curl_exec ($ch);
curl_close ($ch);

OUTPUT
{"response":"Service$ExecuteResponse","results":[

{"response":"resultSet","connectionId":"aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa","statementId":1164383384,"ownStatement":false,"signature":null,"firstFrame":null,"updateCount":1}

]}

But record is not inserted ...