Re: [Bug-apl] SQL on PostgreSQL error

[Elias Mårtenson]

Interesting. Does it happen for all empty tables?

On 10 May 2014 02:27, "Blake McBride" <address@hidden> wrote:

APL:

      db←'postgresql' SQL∆Connect 'host=localhost user=postgres password=postgres dbname=apl'

      db

      'select * from apl_files;' SQL∆Select[db]''

PostgreSQL:

$ psql apl postgres

psql (9.1.13)

Type "help" for help.

apl=# \dt

           List of relations

 Schema |   Name    | Type  |  Owner   

--------+-----------+-------+----------

 public | apl_files | table | postgres

(1 row)

apl=# select * from apl_files;

 file_name 

-----------

(0 rows)

apl=# 

Thanks!

Blake

On Fri, May 9, 2014 at 9:06 AM, Elias Mårtenson <address@hidden> wrote:

What is the query you ran, and what was the content of the database table?

I won't be able to test this on a real Postgres instance until I get back home (on Monday), but this information may at least give me an idea.

Regards,

Elias

On 9 May 2014 21:58, Blake McBride <address@hidden> wrote:

Greetings,

I've got my keyed file system running on sqlite.  As soon as I started testing it under PostgreSQL I got some errors.  I am thinking that it is possible that you still needed to change the PostgreSQL stuff to match the other changes you had to make for the new API.  This is the error I get:

Thanks!

==============================================================================

Assertion failed: 0

in Function:      init

in file:          Cell.cc:48

Call stack:

----------------------------------------

-- Stack trace at Cell.cc:48

----------------------------------------

0x7f3b16e95de5 __libc_start_main

0x4359fd  main

0x52993d   Workspace::immediate_execution(bool)

0x46504d    Command::process_line()

0x463ec3     Command::process_line(UCS_string&)

0x46f4e8      Executable::execute_body() const

0x4e4040       StateIndicator::run()

0x491f9a        Prefix::reduce_statements()

0x48db6e         Prefix::reduce_V_ASS_B_()

0x4f4386          Symbol::assign(Value_P, char const*)

0x52600b           Value::clone(char const*) const

0x45b3e1            Cell::init(Cell const&)

0x44386f             do_Assert(char const*, char const*, char const*, int)

========================================

SI stack:

Depth:    2

Exec:     0x2602448

Pmode:    ∇ SQL∆Select[1]

PC:       10 ENDL

Stat:     Z←X SQL[3,db] Y

err_code: 0x0

thrown:   at StateIndicator.cc:40

e_msg_1:  'No Error'

e_msg_2:  ''

e_msg_3:  ''

Depth:    1

Exec:     0x25e6708

Pmode:    ∇ KF∆Files[1]

PC:       6 ←

Stat:     files←'select file_name from apl_files;' SQL∆Select[db]''

err_code: 0x0

thrown:   at StateIndicator.cc:40

e_msg_1:  'No Error'

e_msg_2:  ''

e_msg_3:  ''

Depth:    0

Exec:     0x26011a0

Pmode:    ◊  db KF∆Files db

PC:       3 ENDL

Stat:     db KF∆Files db

err_code: 0x0

thrown:   at StateIndicator.cc:40

e_msg_1:  'No Error'

e_msg_2:  ''

e_msg_3:  ''

==============================================================================

====================================================

SEGMENTATION FAULT

----------------------------------------

-- Stack trace at main.cc:122

----------------------------------------

0x7f3b16e95de5 __libc_start_main

0x4359fd  main

0x52993d   Workspace::immediate_execution(bool)

0x46504d    Command::process_line()

0x463ec3     Command::process_line(UCS_string&)

0x46f4e8      Executable::execute_body() const

0x4e4040       StateIndicator::run()

0x491f9a        Prefix::reduce_statements()

0x48db6e         Prefix::reduce_V_ASS_B_()

0x4f4386          Symbol::assign(Value_P, char const*)

0x52600b           Value::clone(char const*) const

0x45b3e1            Cell::init(Cell const&)

0x443817             do_Assert(char const*, char const*, char const*, int)

0x50131c              TestFiles::assert_error()

0x7f3b186efbb0               

0x47f0aa                

========================================

====================================================

Process apl segmentation fault