dolthub / dolthub/dolthub-issues

Leaving cells with default values "empty" does not work in Spreadsheet editor.

Open
#291 0 comments 0 reactions 1 assignee Claimed by @tbantle22 View on GitHub
bug
Dominant language
No language data
Stars
5
Forks
0
PR merge metrics
No merged PRs in 30d

Description

**Describe the bug and expected behavior**

**To Reproduce (please include link if applicable)**
Steps to reproduce the behavior:
Create following table:

``` sql
CREATE TABLE tbl_test (
guid binary(16) NOT NULL DEFAULT (UUID_TO_BIN(UUID())),
name varchar(50) NOT NULL,
PRIMARY KEY (guid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin
```
Open Spreadsheet editor and leave guid empty. It will throw an error. (Inserting with script works.)

**Screenshots**
![image](https://user-images.githubusercontent.com/8695124/186089744-0dc2b75c-dc25-406d-9c98-b042352dfd13.png)
![image](https://user-images.githubusercontent.com/8695124/186089792-b774f106-c73c-4889-804f-92abd7629cec.png)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.