Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11
-
None
-
bb-10.11-midenok
-
Not for Release Notes
Description
Can be reproduced after MDEV-28650 fix (currently in bb-10.11-midenok).
Reproduce
--source include/have_sequence.inc
|
create sequence s; |
create table t1 (a int not null default nextval(s)); |
insert into t1 values(),(); |
flush tables;
|
select default(a) from t1; |
|
|
create algorithm=merge view v1 as select default(a) from t1; |
select * from v1; |
Select * from v1; |
prepare ps from 'SELECT * from v1'; |
execute ps; Execute ps; |
drop prepare ps; |
|
|
create or replace algorithm=temptable view v1 as select default(a) from t1; |
select * from v1; |
Select * from v1; |
prepare ps from 'SELECT * from v1'; |
execute ps; Execute ps; |
drop prepare ps; |
|
|
# cleanup
|
drop view v1; |
drop table t1; |
drop sequence s; |
Result
mtr --ps bug.28650-2
|
...
|
mysqltest: At line 6: The result of the 1st execution does not match with
|
the result of the 2nd execution of ps-protocol:
|
1st:
|
default(a)
|
1001
|
1002
|
|
|
2nd:
|
default(a)
|
1003
|
1004
|
Attachments
Issue Links
- relates to
-
MDEV-38423 MTR --view displays wrong column name
-
- Open
-