Thanks!
On Wed, May 14, 2014 at 10:31 AM, Elias Mårtenson <loke...@gmail.com> wrote: > I've fixed the problem. For Postgres, I wasn't checking for the case when > there was 0 rows returned. > > Regards, > Elias > > > On 12 May 2014 05:07, Blake McBride <blake1...@gmail.com> wrote: > >> 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' >> db >> 0 >> 'select * from apl_files;' SQL∆Select[db]'' >> >> $ sqlite3 yyyy.db >> SQLite version 3.7.17 2013-05-20 00:56:22 >> Enter ".help" for instructions >> Enter SQL statements terminated with a ";" >> sqlite> .schema >> CREATE 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 <loke...@gmail.com>wrote: >> >>> Interesting. Does it happen for all empty tables? >>> On 10 May 2014 02:27, "Blake McBride" <blake1...@gmail.com> 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 <loke...@gmail.com>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 <blake1...@gmail.com> 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 >>>>>> >>>>>> >>>>> >>>> >> >
