linux-traipu team mailing list archive

[Henrik Ingo <henrik.ingo@xxxxxxxxxxxxx>]

So to clarify with some more details:

The segmentation fault happens when there is an uneven amount of
columns, such as:

 curl -X POST -d 'SELECT 'foo';SELECT 'bar', 'baz';'
http://localhost:8086/sql

This only happens when compiled with -O0. If compiled with -O2 things
are inlined and the bug disappears.

I also checked the EXECUTE command in drizzle CLI. It doesn't allow to
combine 2 SQL statements like this, so the issue doesn't arise.

The segmentation fault happens due to the way Execute API works, this is
not a Json Server bug.

** Tags added: execute-api json-server

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/1032888

Title:
  ResultSet contains different amount of coloums

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  New

Bug description:
   curl -X POST -d 'SELECT SLEEP(1000);SELECT _id from test.people;' http://localhost:8086/sql
  For this particular request , response is:
  {
     "query" : "SELECT SLEEP(1000);SELECT _id from test.people;",
     "result_set" : [
        [ "0" ],
        [ "1" ]
     ],
     "sqlstate" : "00000"
  }

  So, if select something that has only 1 column, then it will work.
  but for more than that , segmentation fault.

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/1032888/+subscriptions