[GitHub] [doris] zddr opened a new issue, #19975: [Bug] row policy use alis error

[via GitHub]

zddr opened a new issue, #19975:
URL: https://github.com/apache/doris/issues/19975

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   master
   
   ### What's Wrong?
   
   ERROR 1054 (42S22): errCode = 2, detailMessage = Unknown column 'id' in 'a'
   
   repro steps：
   
   use idx_db;
   
   CREATE TABLE `userinfo` (
     `id` varchar(200) NULL,
     `username` varchar(500) NULL,
     `userprofession` varchar(500) NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`id`)
   COMMENT 'OLAP'
   DISTRIBUTED BY HASH(`id`) BUCKETS 10
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "in_memory" = "false",
   "storage_format" = "V2",
   "disable_auto_compaction" = "false"
   );
   
   insert into userinfo values ('1','wxx','教师');
   insert into userinfo values ('5','sl','医生');
   insert into userinfo values ('2','wcc','厨师');
   insert into userinfo values ('4','zw','司机');
   insert into userinfo values ('3','ls','程序员');
   
   CREATE USER  'demo1' IDENTIFIED BY '123456';
   
   GRANT SELECT_PRIV,ALTER_PRIV,LOAD_PRIV ON ..* TO 'demo1'@'%';
   
   CREATE ROW POLICY test_userinfo_1 ON idx_db.userinfo
   AS RESTRICTIVE TO demo1 USING (id in ('1','2','3'));
   
   use demo1 login
   
   select * from idx_db.userinfo a;
   select * from idx_db.userinfo;
   
   ### What You Expected?
   
   fix bug
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org