Comments (10)
在定位中。
from matrixone.
confirm,closed
main commit:652cc255d9075ad1cf683f88bcd66d132fe98dcc
mysql> /* cloud_user */explain select * from mo_catalog.mo_user;
+----------------------------------------+
| QUERY PLAN |
+----------------------------------------+
| Project |
| -> Table Scan on mo_catalog.mo_user |
+----------------------------------------+
2 rows in set (0.17 sec)
mysql> /* cloud_nonuser */ select database() as db,last_query_id() as query_id;
+------+--------------------------------------+
| db | query_id |
+------+--------------------------------------+
| db | 018f0580-e585-7323-b2a7-d9d4074a7206 |
+------+--------------------------------------+
1 row in set (0.00 sec)
mysql> select * from result_scan('018f0580-e585-7323-b2a7-d9d4074a7206') as t limit 0,1000;
+----------------------------------------+
| QUERY PLAN |
+----------------------------------------+
| Project |
| -> Table Scan on mo_catalog.mo_user |
+----------------------------------------+
2 rows in set (0.01 sec)
mysql> /* cloud_user */explain select * from insert_ignore_03;
+-----------------------------------------+
| QUERY PLAN |
+-----------------------------------------+
| Project |
| -> Table Scan on db.insert_ignore_03 |
+-----------------------------------------+
2 rows in set (0.10 sec)
mysql> /* cloud_nonuser */ select database() as db,last_query_id() as query_id;
+------+--------------------------------------+
| db | query_id |
+------+--------------------------------------+
| db | 018f0582-45aa-7b10-9909-9358f777f641 |
+------+--------------------------------------+
1 row in set (0.00 sec)
mysql> select * from result_scan('018f0582-45aa-7b10-9909-9358f777f641') as t limit 0,1000;
+-----------------------------------------+
| QUERY PLAN |
+-----------------------------------------+
| Project |
| -> Table Scan on db.insert_ignore_03 |
+-----------------------------------------+
2 rows in set (0.01 sec)
from matrixone.
explain analyze
has the similar issue:
mysql> /* cloud_nonuser */select connection_id();/* cloud_nonuser */ use `mo_sample_data_tpch_sf1`;/* cloud_user */explain analyze select * from mo_catalog.mo_user;/* cloud_nonuser */ select database() as db,last_query_id() as query_id;
+-----------------+
| connection_id() |
+-----------------+
| 18087682 |
+-----------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
+------------------------------------------------------------------------------------------------------------------------------------+
| QUERY PLAN |
+------------------------------------------------------------------------------------------------------------------------------------+
| Project |
| Analyze: timeConsumed=0ms waitTime=0ms inputRows=1 outputRows=1 InputSize=193bytes OutputSize=193bytes MemorySize=193bytes |
| -> Table Scan on mo_catalog.mo_user |
| Analyze: timeConsumed=0ms waitTime=0ms inputRows=1 outputRows=1 InputSize=193bytes OutputSize=193bytes MemorySize=386bytes |
+------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.15 sec)
+-------------------------+--------------------------------------+
| db | query_id |
+-------------------------+--------------------------------------+
| mo_sample_data_tpch_sf1 | 018f28ec-a00d-7002-9c51-9f901f4ec65a |
+-------------------------+--------------------------------------+
1 row in set (0.03 sec)
mysql> select * from result_scan('018f28ec-a00d-7002-9c51-9f901f4ec65a') as t limit 0,1000;
+---------------------+
| connection_id() |
+---------------------+
| 8386658438904696839 |
| 0 |
| 0 |
| 4294967295 |
+---------------------+
4 rows in set (0.30 sec)
mysql>
Display all 768 possibilities? (y or n)
mysql> select statement from system.statement_info where statement_id = '018f28ec-a00d-7002-9c51-9f901f4ec65a' and request_at > '2024-04-28 08:12:00';
+--------------------------------------------------+
| statement |
+--------------------------------------------------+
| explain analyze select * from mo_catalog.mo_user |
+--------------------------------------------------+
1 row in set (0.15 sec)
from matrixone.
未投入
from matrixone.
未投入
from matrixone.
未投入
from matrixone.
未投入
from matrixone.
未投入
from matrixone.
改掉了。
mysql> /* cloud_nonuser */select connection_id();/* cloud_nonuser */ use `mo_sample_data_tpch_sf1`;/* cloud_user */explain analyze select * from mo_catalog.mo_user;/* cloud_nonuser */ select database() as db,last_query_id() as query_id;
+-----------------+
| connection_id() |
+-----------------+
| 10779 |
+-----------------+
1 row in set (0.00 sec)
ERROR 1049 (HY000): invalid database mo_sample_data_tpch_sf1
+------------------------------------------------------------------------------------------------------------------------------------+
| QUERY PLAN |
+------------------------------------------------------------------------------------------------------------------------------------+
| Project |
| Analyze: timeConsumed=0ms waitTime=0ms inputRows=2 outputRows=2 InputSize=386bytes OutputSize=386bytes MemorySize=0bytes |
| -> Table Scan on mo_catalog.mo_user |
| Analyze: timeConsumed=0ms waitTime=0ms inputRows=2 outputRows=2 InputSize=386bytes OutputSize=386bytes MemorySize=386bytes |
+------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.01 sec)
+------+--------------------------------------+
| db | query_id |
+------+--------------------------------------+
| | 018f9609-9215-7712-ac4c-ff391ccce777 |
+------+--------------------------------------+
1 row in set (0.01 sec)
mysql> select * from meta_scan('018f9609-9215-7712-ac4c-ff391ccce777') as t \G
*************************** 1. row ***************************
query_id: 018f9609-9215-7712-ac4c-ff391ccce777
statement: explain analyze select * from mo_catalog.mo_user
account_id: 0
role_id: 0
result_path: SHARED:/query_result/sys_018f9609-9215-7712-ac4c-ff391ccce777_1.blk
create_time: 2024-05-20 20:46:00
result_size: 0.0003681182861328125
tables: mo_user
user_id: 1
expired_time: 2024-05-21 20:46:00
ColumnMap: QUERY PLAN -> QUERY PLAN
1 row in set (0.00 sec)
mysql> select * from result_scan('018f9609-9215-7712-ac4c-ff391ccce777') as t;
+------------------------------------------------------------------------------------------------------------------------------------+
| QUERY PLAN |
+------------------------------------------------------------------------------------------------------------------------------------+
| Project |
| Analyze: timeConsumed=0ms waitTime=0ms inputRows=2 outputRows=2 InputSize=386bytes OutputSize=386bytes MemorySize=0bytes |
| -> Table Scan on mo_catalog.mo_user |
| Analyze: timeConsumed=0ms waitTime=0ms inputRows=2 outputRows=2 InputSize=386bytes OutputSize=386bytes MemorySize=386bytes |
+------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.01 sec)
from matrixone.
testing
from matrixone.
Related Issues (20)
- [Bug]: rolling-update CN behind proxy cause prepared stmt lost HOT 1
- [Bug]: force flush failed. HOT 3
- [Bug]: snapshot bvt may panic HOT 3
- [Bug]: restore account HOT 3
- [Bug]: restore account if exists fk table ref other databasee will report "can not drop database. It has been referenced by foreign keys" HOT 1
- [Tech Request]: rename restrict operator to filter
- [Tech Request]: optmize duplicate check memory usage for sql like insert into t1 selct from t2
- [Bug]: stock_level txn timeout in 60s in tpcc 10-10 longrunning during statbility test on distributed HOT 2
- [Bug]: [tke regression] tpcc 100-1000 test oom. HOT 6
- [Bug]: CI/multi cn e2e run bvt `load data LOCAL infile` got FileNotFoundException HOT 4
- [Bug]: UT TestKill got error `panic BUG: StartStatement called twice`
- [Tech Request]: support read from cache without copy HOT 1
- [Tech Request]: add txn id in log
- [Bug]: restore fk table report can not find table by id in ci HOT 1
- [Bug]: Optimizer doesn't support ProjectList in SEMI Join
- [Bug]: restore single db multi table with fk report 'no such table'. HOT 1
- [Bug]: panic during merge when object is empty
- [Bug]: `context deadline exceeded` error occurs HOT 2
- [Bug]: New account used about 16GB storage HOT 2
- [Bug]: restore reported `w-w conflict` during race-enabled bvt test HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from matrixone.