The Wayback Machine - http://web.archive.org/web/20200717232718/https://github.com/topics/sql
Skip to content
#

SQL

sql logo

SQL stands for structured query language. It uses commands such as "select", "insert", "update", "delete". Some common relational database management systems that use SQL are: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, etc.

Here are 12,283 public repositories matching this topic...

wwar
wwar commented Apr 26, 2020

Feature Request

Is your feature request related to a problem? Please describe:

This is a really minor nit, but the EXPLAIN output on binary strings is different from what I expected:

CREATE TABLE t1 (
 id INT NOT NULL PRIMARY KEY auto_increment,
 b varchar(255) not null,
 c varbinary(255) not null,
 index (b),
 index (c)
);


INSERT INTO t1 (b,c) VALUES ('a', 'a'),('b
cockroach
dbeaver
KOLANICH
KOLANICH commented Jan 11, 2019

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

ZQbd
ZQbd commented Sep 10, 2019

sql如下:select * from testreg where text.keyword <> REGEXP("?")
翻译的dsl如下:可以看到翻译的dsl是must,应该是must_not才对
{
"from": 0,
"size": 200,
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"regexp": {
"text.keyword": {
"value": "?",
"flags_value": 65535,
"max_determinized_states": 10000,
"boost":

Created by Donald D. Chamberlin, Raymond F. Boyce

Released 1986

Wikipedia
Wikipedia

Related Topics

database
You can’t perform that action at this time.