Description Martin Ackermann 2010-11-13 11:08:09 EST

Build Identifier: 20100218-1602

It seems that the constant of type VARCHAR FOR BIT DATA disturbs the parser in the SQL editor when using "Execute All".

Reproducible: Always

Steps to Reproduce:
On "Execute All" the following SQL produces "Syntax error: Encountered ";" at line 1, column 48."
CREATE TABLE app.test (bytearray VARCHAR(255) FOR BIT DATA);
INSERT INTO app.test(bytearray) VALUES(x'0102');
INSERT INTO app.test(bytearray) VALUES(x'0102');

With three times "Execute Current Text", it works fine.

When replacing the the constant by null, the script runs fine with "Execute All":
CREATE TABLE app.test (bytearray VARCHAR(255) FOR BIT DATA);
INSERT INTO app.test(bytearray) VALUES(null);
INSERT INTO app.test(bytearray) VALUES(null);