| Subject | RE: [firebird-support] Invalid request BLR execting UNION of views |
|---|---|
| Author | Edward Mendez |
| Post date | 2014-08-12T16:42:41Z |
If this is being executed from within a stored procedure, then maybe you are missing the SUSPEND keyword that returns the results;
Regards,
Ed Mendez
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, August 12, 2014 12:27 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Invalid request BLR execting UNION of views
In a database, I execute the following code:
select *
from customer
union
select * from customer
The above does not make sense, it is a reduced query to show the error.
I get "Invalid token. invalid request BLR at offset 4275. BLR syntax error: expected record selection expression clause at offset 4276, encountered 24."
The first thought was a database corruption, but I have restored the database and passed the IBFirstAID application and no errors are detected. I use Firebird 2.5.
What else can I try?
Thank you