[firebird-support] invalid request BLR executing UNION of two views
In a database, I execute the following code:select *from customerunionselect * from customerThe 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
[firebird-support] Invalid request BLR execting UNION of views
In a database, I execute the following code:select *from customerunionselect * from customerThe 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
[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
RE: [firebird-support] Invalid request BLR execting UNION of views
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
[firebird-support] Re: Invalid request BLR execting UNION of views
No, it is executed directly using a SQL command
Re: [firebird-support] Invalid request BLR execting UNION of views
kokok_ko...@yahoo.es [firebird-support] wrote: Hej, In a database, I execute the following code: select * from customer union select * from customer Mind you to tell us something more about the tables and the database? 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? I've tried a simple sample like https://en.wikipedia.org/wiki/Set_operations_%28SQL%29 and it's working like expected, no errors at all. Haven't used anything else than isql, firebird 2.5.2 on windows, freshly created database. Thank you hth, marcus [Non-text portions of this message have been removed]