runner dumps core

Walter Haslbeck <[email protected]> Thu, 26 Apr 2007 13:11:17 +0200
Newsgroups gmane.comp.lang.4gl.fourjs.user
Organization Hiller GmbH
Message-ID <[email protected]>
Hi,

I want to use the following SQL-statement in 4js:

SELECT MAX(SUBSTRING(mycol FROM '[0-9]*$')::INTEGER) + 1 FROM
myschema.mytable

I tried it in a SQL-Block:
SQL
SELECT ... INTO $myvar ...
END SQL

and via PREPARE/EXECUTE:
LET stmt = "SELECT..."
PREPARE p_x FROM stmt
EXECUTE p_x INTO myvar

Both cases produce an core-dump at runtime.

Any hints / workarounds?



Environment
===========

$ fglrun -V
Four J's Dynamic Virtual Machine Version 3.54.01.19
Built Mar 26 2004 13:59:15
(c) 1989-2004 Four J's Development Tools
Language support library: Standard ASCII (ISO8859-1)
Database front end : POSTGRESQL 7.4.x

$ fglcomp -V
Four J's Universal Compiler Version 3.54.01.19
Built Mar 26 2004 13:59:15
(c) 1989-2004 Four J's Development Tools
Language support library: Standard ASCII (ISO8859-1)

OS: SuSE Linux 9.0

Database:
# select version();
 PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1
(SuSE Linux)


bye,
Walter