[go: nahoru, domu]

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

Cannot set default value to NOT NULL for a VARCHAR STORED GENERATED column #12874

Closed
bs-thomas opened this issue Jan 7, 2017 · 3 comments
Closed

Comments

@bs-thomas
Copy link
bs-thomas commented Jan 7, 2017

Steps to reproduce

  1. Structure
  2. Pick a generated column, Change
  3. Uncheck "NULL", and default value to none

Expected behaviour

Should change default to "None" instead of NULL

Actual behaviour

Default value stays as NULL

Server configuration

Operating system: Windows 10 Pro

Web server:
Apache 2.4.23

Database:
MySQL 5.7.14

PHP version:
5.6.25

phpMyAdmin version:
4.6.5.2

Client configuration

Browser:
Chrome

Operating system:
Windows

I haven't tried, but I imagine it probably happens in VIRTUAL GENERATE COLUMNS as well.

Here is the SQL query executed though I checked NOT NULL.
ALTER TABLE storage_file CHANGE file_url file_url VARCHAR(510) AS (replace(file_url_template,'{$path}',file_url_path)) STORED;

image

Thanks!

@greggreenhaw
Copy link

virtual columns should be excluded from the insert page because the null is causing an error

@linaspasv
Copy link

Also related to: #13105

@nijel
Copy link
Contributor
nijel commented Mar 21, 2017

Should be fixed as #13105 was fixed.

@nijel nijel closed this as completed Mar 21, 2017
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jun 22, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants