Bohu

feat: task_advice system table

1

**Summary** Add a system table for advice the background serivice: |catalog_name|database_name| table_name| task_type| need_run| task_sql | reason(variant)| |-----|----------------|------------|----------|-----------|----------|----------- |default|db|xx | COMPACT | 1 |optimize table xx compact limit 3| "{status...

**Summary** ## Setup https://github.com/datafuselabs/wizard/blob/main/checksb/sql/updates/bend/setup.sql ``` DROP TABLE IF EXISTS orders; CREATE TABLE orders ( order_id INT NOT NULL, user_id INT NOT NULL, order_type VARCHAR NOT NULL, asset_type VARCHAR NOT NULL,...

feat: add token table

4

## Summary Schema: ``` CREATE TABLE tokens( address VARCHAR, symbol VARCHAR, decimals BIGINT, total_supply BIGINT, block_number BIGINT ) ```

## Summary Add traces table. Close #issue

##Summay Add `Verified Sources` to new api `v2/query`

Pretty the *.json file

2

https://github.com/datafuselabs/databend-perf/blob/main/collector/ontime/2022-03-28-ontime.json ``` { "metadata":{ "table":"ontime", "tag":"v0.7.0-nightly", "size":"XXXLarge" }, "schema":[ { "name":"Q1", "sql":"SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year \u003e= 2000 AND Year \u003c= 2008 GROUP BY DayOfWeek ORDER...

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/ ## Summary * Increase the maximum size of short_sql from 64 bytes to 10 kb. Some INSERT MERGE...

**Summary** Syntax: ``` CREATE OR REPLACE SEQUENCE seq1; ``` The `SEQUENCE` object and the `nextval` function are used to retrieve and increment a sequence. We can use MetaSrv's built-in sequence...

feat: support recursive CTE

7

**Summary** AWS Athena: ``` create table testing.nk_example_table as SELECT * FROM ( VALUES (1, 'new loan' ,10000, 0.1), (2, 'new loan' ,500 , 0.2), (3, 'add interest' ,0 , 0.15)...