# Is this a Percona Bug - rejects the fieldname "virtual"

**URL:** <https://forums.percona.com/t/is-this-a-percona-bug-rejects-the-fieldname-virtual/7768>\
**Category:** Percona Server for MySQL 5.7\
**Tags:** mysql, percona\
**Created:** [July 11, 2020, 3:45am UTC](https://forums.percona.com/t/is-this-a-percona-bug-rejects-the-fieldname-virtual/7768 "2020-07-11T03:45:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hder](https://avatars.discourse-cdn.com/v4/letter/h/c37758/32.png) [@hder](https://forums.percona.com/u/hder)\
**Post date:** [July 11, 2020, 3:45am UTC](https://forums.percona.com/t/is-this-a-percona-bug-rejects-the-fieldname-virtual/7768/1 "2020-07-11T03:45:51Z")

</div>

I have a simple query “ **_SELECT virtual FROM groups_** ”. Works in my Windows/Xampp/PHP7/MySQL (5.6) local setup, but in Percona (5.7) on Bluehost, but it rejects the field word “virtual”. I have to use the “ **_SELECT groups.virtual AS virtualx FROM groups_** ” to make it work.&nbsp; This is through PHPMyAdmin interface.&nbsp; The error it provides is - An expression was expected. (near virtual)&nbsp; &nbsp;Unrecognized keyword. (near virtual).&nbsp;&nbsp;Can anyone confirm this is a bug in Percona or provide an explanation?&nbsp; I can’t make sense of it otherwise.

---

<div class="post-metadata">

**Author:** ![daniil.bazhenov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/daniil.bazhenov/32/62_2.png) [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)\
**Post date:** [July 11, 2020, 9:33am UTC](https://forums.percona.com/t/is-this-a-percona-bug-rejects-the-fieldname-virtual/7768/2 "2020-07-11T09:33:57Z")

</div>

Dear @hder   
VIRTUAL was added as reserved keyword in MySQL 5.7  
[https://dev.mysql.com/doc/refman/5.7/en/keywords.html#keywords-5-7-detailed-V](https://dev.mysql.com/doc/refman/5.7/en/keywords.html#keywords-5-7-detailed-V "Link: https://dev.mysql.com/doc/refman/5.7/en/keywords.html#keywords-5-7-detailed-V")  
I would avoid using keywords as column names but if you have you you can refer to them by using backticks

```auto
select&nbsp;`virtual' from&nbsp;groups;&nbsp;should&nbsp;work.

```
