dolthub / dolthub/dolt

Character set REGEXP syntax (ie. 'N[1,3]') not supported in Dolt

Open
#3,005 2 comments 0 reactions 1 assignee Claimed by @zachmu View on GitHub
bug correctness ORM sql
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 8h
Merged PRs (30d)
120

Description

Consider the following table and data

```
CREATE TABLE IF NOT EXISTS `person` (`id` INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` VARCHAR(255) NOT NULL);
INSERT INTO `person` (`name`) VALUES ('n1');
INSERT INTO `person` (`name`) VALUES ('n2');
INSERT INTO `person` (`name`) VALUES ('n3');
```

Consider the following query

```SQL
SELECT `t1`.`id`, `t1`.`name` FROM `person` AS `t1` WHERE (`t1`.`name` REGEXP 'N[1,3]') ORDER BY `t1`.`name`;
```
MySQL Returns

```
+----+------+
| id | name |
+----+------+
| 1 | n1 |
| 3 | n3 |
+----+------+
```

Dolt returns the empty set

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.