SQL

Enhancement

[2022-02-14T04:12:14.746Z] ----------------------------------------------------------------------
[2022-02-14T04:12:14.746Z] FAIL: db_test.go:7069: testSerialDBSuite.TestModifyColumnTypeWhenInterception
[2022-02-14T04:12:14.746Z] 
[2022-02-14T04:12:14.746Z] db_test.go:7124:
[2022-02-14T04:12:14.746Z]     c.Assert(checkMiddleWarningCount, Equals, true)
[2022-02-14T04:12:

Working on a project I ran into the documentation for customizing the Foreign Key.
The docs read:

// https://sequelize.org/master/manual/assocs.html
// For example, to use UUID as the foreign key data type instead of the default (INTEGER), you can simply do:

const { DataTypes } = require("Sequelize");

Foo.hasOne(Bar, {
  foreignKey: {
    // name: 'myFooId'
    type: D

Bug Description
taosBenchmark subscribe crash

To Reproduce
Steps to reproduce the behavior:

1. Build taosd, taosBenchmark in latest develop branch
2. go to 'TDengine/src/kit/taos-tools/example'
3. execute taosBenchmark -f insert_csv.json
4. execute taosBenchmark -f subscribe.json

Expected Behavior
taosBenchmark -f subscribe.json should not crash

Screenshots
N/A

Hi community,

This issue is for WeOpen-Star

We need to add more unit test for ExpressionExtractUtil.

• ExpressionExtractUtil#findNotContainsNullLiteralsExpression

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

Issue description

This option will improve performance in many scenarios
https://dev.mysql.com/worklog/task/?id=8134

https://www.facebook.com/weixiang.zhai/posts/678596755543802

Using dolt sql -q "<query>" -r csv > file.csv results in newlines in the output data:

• 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

설명

퀵 정렬 게시글 중 bold 설정이 일부 들어가지 않았습니다.

링크

1. gyoogle - 퀵 정렬 (최악의 경우)
2. gyoogle - 퀵 정렬 (공간복잡도)

스크린샷

1. <img width="600" alt="image" src="https://user-images.githubusercontent.com/57972338/161484958-416f6d20-33df-412a-a5ca-c72f7

Is your feature request related to a problem? Please describe.
Even if I have a folder open, especially in VS Code, and create a new SQL project - I have to reselect that folder as the project location.

![image](https://user-images.githubusercontent.com/12227241/166515237-e7ebaf

Description

Create a cluster with TEST_docdb_log_write_batches=true and observe the following -

./bin/yb-ctl create --rf=1 --data_dir ~/yugabyte-data --tserver_flags 'TEST_docdb_log_write_batches=true'
./bin/ysqlsh
yugabyte=# create table test (k int primary key, v int);
CREATE TABLE
yugabyte=# insert into test values (1, 1);
ERROR:  Network error: recvmsg error: Connection refus