[Info-Ingres] problem with table names as parameters in Ingres 2006 Release 2

John Dennis denjo02 at hotmail.com
Mon Apr 30 04:39:11 CDT 2007


On Apr 30, 9:57 am, glenn... at gmail.com wrote:
> Hi
>
> I have been testing Ingres 2006 Release 2 for Solaris and have found
> an interesting problem.  We have a large amount of ABF code and there
> seems to be a problem using a parameter for a table name in a insert
> statement, but not for other statements (like updates).  This sort of
> substitution works fine in 2.6.
>
...
> Has anyone else had a similar sort of problem on any other platforms?
>
> Cheers
> Glenn

The problem reproduces with 2006r2 on Windows. But the two cases you
have provided are different. There are no errors with either insert or
update where the table being inserted or updated is a variable, and
both the update or insert will generate errors when the table name is
a variable in a subselect or "from" in the insert.  A bug will be
raised shortly...

John



More information about the Info-Ingres mailing list