|
From: | Elias Mårtenson |
Subject: | Re: [Bug-apl] SQL on PostgreSQL error |
Date: | Wed, 14 May 2014 23:31:57 +0800 |
It appears to only happen in PostgreSQL. Also, when I tried it with a non-empty file in PostgreSQL, it worked. Thanks.SQL∆LoadLib '/home/blake/Backup/apl-sqlite.git/lib_sql.so'db←'sqlite' SQL∆Connect 'yyyy.db'db0'select * from apl_files;' SQL∆Select[db]''$ sqlite3 yyyy.dbSQLite version 3.7.17 2013-05-20 00:56:22Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite> .schemaCREATE TABLE apl_files (file_name character varying (80) not null unique);sqlite> select * from apl_files;sqlite>On Fri, May 9, 2014 at 8:14 PM, Elias Mårtenson <address@hidden> wrote:
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 postgrespsql (9.1.13)Type "help" for help.apl=# \dtList of relationsSchema | Name | Type | Owner--------+-----------+-------+----------public | apl_files | table | postgres(1 row)apl=# select * from apl_files;file_name-----------(0 rows)apl=#Thanks!BlakeOn 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,EliasOn 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: 0in Function: initin file: Cell.cc:48Call stack:------------------------------------------ Stack trace at Cell.cc:48----------------------------------------0x7f3b16e95de5 __libc_start_main0x4359fd main0x52993d Workspace::immediate_execution(bool)0x46504d Command::process_line()0x463ec3 Command::process_line(UCS_string&)0x46f4e8 Executable::execute_body() const0x4e4040 StateIndicator::run()0x491f9a Prefix::reduce_statements()0x48db6e Prefix::reduce_V_ASS_B_()0x4f4386 Symbol::assign(Value_P, char const*)0x52600b Value::clone(char const*) const0x45b3e1 Cell::init(Cell const&)0x44386f do_Assert(char const*, char const*, char const*, int)========================================SI stack:Depth: 2Exec: 0x2602448Pmode: ∇ SQL∆Select[1]PC: 10 ENDLStat: Z←X SQL[3,db] Yerr_code: 0x0thrown: at StateIndicator.cc:40e_msg_1: 'No Error'e_msg_2: ''e_msg_3: ''Depth: 1Exec: 0x25e6708Pmode: ∇ KF∆Files[1]PC: 6 ←Stat: files←'select file_name from apl_files;' SQL∆Select[db]''err_code: 0x0thrown: at StateIndicator.cc:40e_msg_1: 'No Error'e_msg_2: ''e_msg_3: ''Depth: 0Exec: 0x26011a0Pmode: ◊ db KF∆Files dbPC: 3 ENDLStat: db KF∆Files dberr_code: 0x0thrown: at StateIndicator.cc:40e_msg_1: 'No Error'e_msg_2: ''e_msg_3: ''==================================================================================================================================SEGMENTATION FAULT------------------------------------------ Stack trace at main.cc:122----------------------------------------0x7f3b16e95de5 __libc_start_main0x4359fd main0x52993d Workspace::immediate_execution(bool)0x46504d Command::process_line()0x463ec3 Command::process_line(UCS_string&)0x46f4e8 Executable::execute_body() const0x4e4040 StateIndicator::run()0x491f9a Prefix::reduce_statements()0x48db6e Prefix::reduce_V_ASS_B_()0x4f4386 Symbol::assign(Value_P, char const*)0x52600b Value::clone(char const*) const0x45b3e1 Cell::init(Cell const&)0x443817 do_Assert(char const*, char const*, char const*, int)0x50131c TestFiles::assert_error()0x7f3b186efbb00x47f0aa============================================================================================Process apl segmentation fault
[Prev in Thread] | Current Thread | [Next in Thread] |