Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Missing comma before start of a new alter operation. (near COALESCE)" for valid statement #323

Closed
bmcn99 opened this issue Dec 8, 2020 · 0 comments
Assignees
Labels
Milestone

Comments

@bmcn99
Copy link

bmcn99 commented Dec 8, 2020

The following command:

ALTER TABLE orders 
ADD COLUMN `n_deleted_at` timestamp AS (COALESCE(deleted_at, '1980-01-01')) VIRTUAL;

Produces the sql-parser error "Missing comma before start of a new alter operation. (near COALESCE)". The command still goes through just fine though.

This is on version phpmyadmin 4.9.5 and 4.9.5deb2.

@williamdes williamdes added the bug label Dec 8, 2020
@williamdes williamdes added this to the 4.7.2 milestone Dec 8, 2020
@williamdes williamdes modified the milestones: 4.7.2, 4.7.3 Feb 5, 2021
@williamdes williamdes modified the milestones: 4.7.3, 4.7.4 Dec 11, 2021
@williamdes williamdes modified the milestones: 4.7.4, 5.7.0 Nov 21, 2022
@williamdes williamdes modified the milestones: 5.7.0, 5.8.0 Jan 25, 2023
williamdes added a commit that referenced this issue Apr 14, 2023
Pull-request: #439

Signed-off-by: William Desportes <williamdes@wdes.fr>
@williamdes williamdes self-assigned this Apr 14, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants