Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15085

Invisible Column Non-constant Default value results wrong values

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3(EOL)
    • 10.3.5
    • Server
    • None
    • All

    Description

      MariaDB [d]> create table t2(a int , b int invisible default (a));
      Query OK, 0 rows affected (0.01 sec)
      MariaDB [d]> insert into t2 values(2);                                                                                                                
      Query OK, 1 row affected (0.00 sec)
      MariaDB [d]> select a,b from t2;                                                                                                                      
      +------+------+
      | a    | b    |
      +------+------+
      |    2 | NULL |
      +------+------+
      1 row in set (0.00 sec)
      
      

      Attachments

        Issue Links

          Activity

            This issue if kind of related to how we get data for invisible fields, we kind of think it will be there (which is true in the case of constant default (share->default_values will have it)). but not true is default should be calculated dynamically.

            sachin.setiya.007 Sachin Setiya (Inactive) added a comment - This issue if kind of related to how we get data for invisible fields, we kind of think it will be there (which is true in the case of constant default (share->default_values will have it)). but not true is default should be calculated dynamically.

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              sachin.setiya.007 Sachin Setiya (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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