bendsql icon indicating copy to clipboard operation
bendsql copied to clipboard

unexpected `use db` behavior after `use warehouse`

Open zhang2014 opened this issue 1 year ago • 1 comments

BendSQL 0.4.7-dev

USE warehouse 'test-medium'

deploy@(test-medium)/> use bohu;

USE bohu

0 row in 8.618 sec. Processed 0 rows, 0B (0 rows/s, 0B/s)

deploy@(test-medium)/> show tables;

SHOW TABLES

┌───────────────────────────────────────┐
│           Tables_in_default           │
│                 String                │
├───────────────────────────────────────┤
│ _airbyte_raw_airbyteontimetest        │
│ _airbyte_raw_append_stream            │
│ _airbyte_raw_arrays                   │
│ ·                                     │
│ ·                                     │
│ ·                                     │
│ users__dbt_tmp                        │
│ 185 rows                              │
│ (40 shown)                            │
└───────────────────────────────────────┘
185 rows in 7.976 sec. Processed 185 rows, 185B (23.19 rows/s, 4.87 KiB/s)

deploy@(test-medium)/> use bohu;

USE bohu

0 row in 0.508 sec. Processed 0 rows, 0B (0 rows/s, 0B/s)

deploy@(test-medium)/bohu> show tables;

SHOW TABLES

┌────────────────┐
│ Tables_in_bohu │
│     String     │
├────────────────┤
│ c              │
│ c_random       │
│ employees      │
│ hits           │
│ hits_1         │
│ hits_2         │
│ hits_raw       │
│ random_source  │
│ student        │
│ t1             │
│ t2             │
│ test_order     │
└────────────────┘
12 rows in 0.551 sec. Processed 12 rows, 12B (21.78 rows/s, 4.41 KiB/s)

zhang2014 avatar Aug 22 '23 02:08 zhang2014