Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

View File Name : explain_for_connection_crash.result

"WL6369 Explain for Connection"
QUERY: SELECT group_concat(c order by (select c from t2 where t2.a=t1.a limit 1)) as grp from t1 
STATUS:NOT_EQUAL
SYNC_POINT:before_reset_query_plan
Diff: EXPLAIN NORMAL vs OTHER
@@ -39,2 +39,3 @@
             "filtered": "25.00",
+            "using_where": true,
             "cost_info": {
@@ -48,4 +49,3 @@
               "c"
-            ],
-            "attached_condition": "(`test`.`t2`.`a` = `test`.`t1`.`a`)"
+            ]
           }
QUERY: SELECT * FROM t1 UNION SELECT * FROM t1 ORDER BY (SELECT a FROM t2 WHERE b = 12) 
STATUS:NOT_EQUAL
SYNC_POINT:before_reset_query_plan
Diff: EXPLAIN NORMAL vs OTHER
@@ -79,2 +79,3 @@
               "filtered": "50.00",
+              "using_where": true,
               "cost_info": {
@@ -87,4 +88,3 @@
                 "b"
-              ],
-              "attached_condition": "(`test`.`t2`.`b` = 12)"
+              ]
             }
QUERY: SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0 
STATUS: EQUAL