[MDEV-9649] Cannot use DEFAULT function in a view Created: 2016-02-28  Updated: 2016-02-28

Status: Confirmed
Project: MariaDB Server
Component/s: Views
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: upstream


 Description    

create table t1 (i int default 0);
 
insert into t1 values (1);
 
select default(i) from t1;
 
create view v1 as select default(i) from t1;


MariaDB [test]> create view v1 as select default(i) from t1;
 
ERROR 1143 (42000): create view command denied to user 'root'@'localhost' for column 'default(i)' in table 'v1'


Generated at Thu Feb 08 07:36:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.