[MDEV-24254] CHECK (ISNULL(code)=ISNULL(class)) syntax error Created: 2020-11-20 Updated: 2021-01-22 Resolved: 2020-11-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Create Table |
| Affects Version/s: | 10.3.27 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Brooke Tsui | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Linux 5.4.0-53-generic #59~18.04.1-Ubuntu |
||
| Issue Links: |
|
||||||||||||||||
| Description |
|
It was working before until this version. The clause "CHECK (ISNULL(code)=ISNULL(class))" now causes syntax error mistakenly. Please refer to screen capture for problem explanation and replication. root@fusion:~# uname -a Welcome to the MariaDB monitor. Commands end with ; or \g. Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [fusion]> CREATE TABLE IF NOT EXISTS `test` ( |
| Comments |
| Comment by Alice Sherepa [ 2020-11-20 ] |
|
Thanks! |