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 25,698 public repositories matching this topic...

mjonss
mjonss commented Jun 29, 2022

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t (id tinyint unsigned, idpart tinyint, i varchar(255)) partition by range (idpart) (partition p1 values less than (-1));

2. What did you expect to see? (Required)

mysql> creat
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

rohitsud
rohitsud commented May 18, 2020

https://github.com/sequelize/sequelize/blob/8a1429d6044123bba3a3f312b2e0c74b0c829990/lib/model.js#L1271

If I create any model with
charset: 'utf8mb4', collate: 'utf8mb4_general_ci'

sequelize translates it to this for mysql

CREATE TABLE IF NOT EXISTS tablename ... ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8mb4_general_ci;

On stepping through the code, it seems that the issu

type: bug good first issue
cockroach
xiaopingcs
xiaopingcs commented Jun 22, 2022

Bug Description
fix issues found by Coverity Scan in syncMain.c

To Reproduce
N/A

Expected Behavior
fix following issues:
| issue type | category | file path | function | line number |
| -------------------------- | -------------------------- | -------------------------- | -------------------------- |

good first issue improvement
directus
sandrosc
sandrosc commented Jun 30, 2022

Describe the Bug

A repeater with two input fields generates an OpenAPI spec that indicates the return value is a list of strings:

list:
  nullable: true
  type: array
  items:
    type: string

When actually it returns a list of objects:

[
  { title: 'a title', text: 'a text' },
  { title: 'another title', text: 'another text'}
]

The repeater:

API Bug Good First Issue
cube.js
leogodin217
leogodin217 commented Sep 17, 2021

Describe the bug
Using a time dimension on a runningTotal measure on Snowflake mixes quoted and unquoted columns in the query. This fails the query, because Snowflake has specific rules about quoted columns. Specifically:

  • All unquoted column names are treated as upper case
  • Quoted column names are case sensitive.

So "date_from" <> date_from

To Reproduce
Steps to reproduce

bug help wanted good first issue
gmcrocetti
gmcrocetti commented Nov 18, 2021

Hi all. Congrats for the amazing software :)

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

It would be amazing to have the IN operator available in this drop-down list:
Screenshot_20211118_152729


Describe the solution you'd like

Have the IN oper

enhancement good first issue accepted 👍
questdb
amunra
amunra commented Mar 15, 2022

Describe the Bug

The JSON response sent back over HTTP doesn't encode certain characters correctly.

For example, if a value in a string column contains the char \1 the byte value is copied verbatim in the response, breaking the client:

>>> json.loads('"\1"')
...
json.decoder.JSONDecodeError: Invalid control character at: line 1 column 2 (char 1)

Instead, we shou

Bug Good first issue REST API
The-Complete-FAANG-Preparation

This repository contains all the DSA (Data-Structures, Algorithms, 450 DSA by Love Babbar Bhaiya, FAANG Questions), Technical Subjects (OS + DBMS + SQL + CN + OOPs) Theory+Questions, FAANG Interview questions, and Miscellaneous Stuff (Programming MCQs, Puzzles, Aptitude, Reasoning). The Programming languages used for demonstration are C++, Python, and Java.

  • Updated Jun 22, 2022
  • Jupyter Notebook
immudb
zaza81
zaza81 commented Oct 19, 2021
  • Missing information on how to create other databases
  • Missing information on how to switch to other databases
  • When using time travel, we don’t know where to get the transaction number from - we should show this to the user after committing data (this may be a missing capability in immudb / tools).
  • The last long query example in the quick start is incorrect (incorrect
documentation good first issue

Created by Donald D. Chamberlin, Raymond F. Boyce

Released 1986

Wikipedia
Wikipedia

Related Topics

database