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 <[email protected]> wrote:
> Interesting. Does it happen for all empty tables?
> On 10 May 2014 02:27, "Blake McBride" <[email protected]> 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 <[email protected]>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 <[email protected]> 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
>>>>
>>>>
>>>
>>
