Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
-
10.2.11, 10.2.12
Description
runnig following test suite with and without --ps-protocol produce different results.
create table DUPPP (code varchar(10) primary key); |
INSERT INTO DUPPP(code) VALUES ('LINE1'), ('LINE2'), ('LINE3'); |
SELECT X.* FROM (SELECT CODE, RN FROM (SELECT A.CODE, @cnt := @cnt + 1 AS RN FROM DUPPP A, (SELECT @cnt := 0) C) T) X; |
drop table DUPP; |
normal execution:
CODE RN
|
LINE1 1
|
LINE2 2
|
LINE3 3
|
with --ps-protocol:
CODE RN
|
LINE3 3
|
LINE3 3
|
LINE3 3
|
Attachments
Issue Links
- relates to
-
CONJ-338 Inconsistent/wrong resultset when using variables and nested selects
- Closed