Details
-
Bug
-
Resolution: Done
-
Major
-
7.4.1, 7.7
-
None
Description
LIMIT clause is added to Statement being optimized which fails the operation on Oracle
OPTIMIZE:
CREATE VIRTUAL PROCEDURE
BEGIN
DECLARE biginteger VARIABLES.t_pk;
VARIABLES.t_pk = (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen);
SELECT VARIABLES.t_pk AS result;
END
####################################################
PROCEDURE COMMAND: CREATE VIRTUAL PROCEDURE
BEGIN
DECLARE biginteger VARIABLES.t_pk;
VARIABLES.t_pk = (SELECT <table>.seq_gen.cpe_seq FROM <table>.seq_gen LIMIT 2);
SELECT VARIABLES.t_pk AS result;
END