[MDEV-35552] fieled name 'key' is allowed to be created as Primary Key but selects do not work propperly - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Trivial
Resolution: Not a Bug
Affects Version/s: 10.11.10
Fix Version/s: N/A
Component/s: N/A
Labels:
None
Environment:

Hide
root@puma:~# mysql --version
mysql Ver 15.1 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
root@puma:~# cat /etc/os-release
PRETTY_NAME="Debian GNU/Linux 12 (bookworm)"
NAME="Debian GNU/Linux"
VERSION_ID="12"
VERSION="12 (bookworm)"

Show
root@puma :~# mysql --version mysql Ver 15.1 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper root@puma :~# cat /etc/os-release PRETTY_NAME="Debian GNU/Linux 12 (bookworm)" NAME="Debian GNU/Linux" VERSION_ID="12" VERSION="12 (bookworm)"

Description

It is possible to create Tables with a column named 'key' as a Primary Key with auto increment.
Inserts work Properly but selects not.
When you change the name of the column from 'key' to something else it works.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

example.txt
2 kB
2024-12-02 18:03

Activity

People

Assignee:: Unassigned

Reporter:: Simon Renkert

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2024-12-02 18:04

Updated:: 2024-12-03 09:41

Resolved:: 2024-12-03 09:41

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.