Hi,

The following query works for the first time:


WITH t AS (
SELECT * FROM tables )
SELECT * FROM t

If I execute the query again, it gives the following error:

Variable 't' allready declared

If I change the alias from "t" to "t2" it works for the first time and then
gives the error on second execution.

Please look into this and correct this bug.

Thanks,

- Venkatesh
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users

Reply via email to