Source: octave-database
Version: 2.4.4-4
Severity: serious
X-Debbugs-Cc: [email protected]
With octave 6.4.0:
| ans = 0
| pq_connect example 2:
| ## recursive type, array-composite-array
| conn = pq_connect (setdbopts ("dbname", "test"));
| pq_exec_params (conn, "create type complex_bool_array_type as (b bool, ba
bool[]);")
| pq_exec_params (conn, "create table complex_bool_array_array (a
complex_bool_array_type[]);")
| pq_update_types (conn);
| pq_exec_params (conn, "insert into complex_bool_array_array values ($1);",
{struct("ndims", 1, "data", {{{true, struct("ndims", 2, "data", {{true, false;
true, true}})}; {false, struct("ndims", 1, "data", {{false; true}})}}})},
setdbopts ("param_types", {"complex_bool_array_type[]"}))
| data = pq_exec_params (conn, "select * from complex_bool_array_array;").data;
| ## copy in from variable
| pq_exec_params (conn, "copy complex_bool_array_array from stdin with
binary;", setdbopts ("copy_in_data", data, "copy_in_from_variable", true,
"copy_in_types", {"complex_bool_array_type[]"}))
| pq_exec_params (conn, "select * from complex_bool_array_array;")
| ## recursive type, composite-composite-array
| pq_exec_params (conn, "create type complex_complex_bool_array_type as (b
bool, c complex_bool_array_type);")
| pq_exec_params (conn, "create table complex_complex_bool_array (a
complex_complex_bool_array_type);")
| pq_update_types (conn);
| pq_exec_params (conn, "insert into complex_complex_bool_array values ($1);",
{{false, {true, struct("ndims", 2, "data", {{true, false; true, true}})}}},
setdbopts ("param_types", {"complex_complex_bool_array_type"}))
| data = pq_exec_params (conn, "select * from
complex_complex_bool_array").data;
| ## copy in from variable
| pq_exec_params (conn, "copy complex_complex_bool_array from stdin with
binary;", setdbopts ("copy_in_data", data, "copy_in_from_variable", true,
"copy_in_types", {"complex_complex_bool_array_type"}))
| pq_exec_params (conn, "select * from complex_complex_bool_array")
| pq_exec_params (conn, "drop table complex_complex_bool_array;")
| pq_exec_params (conn, "drop table complex_bool_array_array;")
| pq_exec_params (conn, "drop type complex_complex_bool_array_type;")
| pq_exec_params (conn, "drop type complex_bool_array_type;")
| pq_close (conn);
|
| ans = 0
| ans = 0
| ans = 1
| fatal: caught signal Bus error -- stopping myself...
| Bus error
| waiting for server to shut down....2022-01-20 21:34:55.574 UTC [7604] LOG:
received fast shutdown request
| 2022-01-20 21:34:55.575 UTC [7604] LOG: aborting any active transactions
| 2022-01-20 21:34:55.578 UTC [7604] LOG: background worker "logical
replication launcher" (PID 7611) exited with exit code 1
| 2022-01-20 21:34:55.578 UTC [7606] LOG: shutting down
| 2022-01-20 21:34:55.595 UTC [7604] LOG: database system is shut down
See
https://ci.debian.net/data/autopkgtest/testing/armhf/o/octave-database/18529074/log.gz
Cheers
--
Sebastian Ramacher