wk2418-trace-log.md

Issue-01: Minor issue from file tests/sqllogictests/suites/query/select.test which got fixed.

10: query result mismatch:
[SQL] select catalog,database,name,number_of_blocks,number_of_segments from system.tables where name = 't';
[Diff] (-expected|+actual)
-   default default t 1 1
+   default default t 1 1
+   default map_func_test t 1 1
at tests/sqllogictests/suites/query/select.test:50

11: query failed: Databend sqllogictests error: http query error: code: 1065, Text: error: 
  --> SQL:1:64
  |
1 | select * from t2 where t2.b < ANY(select NULL from t1 where t1.a = t1.a)
  |                                                                ^ column a doesn't exist


[SQL] select * from t2 where t2.b < ANY(select NULL from t1 where t1.a = t1.a)
at tests/sqllogictests/suites/query/subquery.test:662

---

Issue-02: I noticed that several other test suites are failing as well. Could you please take a look and advise on how to proceed?

Running sql with mysql client: [drop table if exists t;] (60.405714ms)
Completed MySQL test for file: tests/sqllogictests/suites/query/subquery.test ✅ (10.170012341s)
Test finished, fail fast enabled, 9 out of 4310 records failed to run
0: query failed: mysql client error: Server error: `ERROR HY000 (1105): UnknownTable. Code: 1025, Text = error: 
  --> SQL:1:31
  |
1 | with t2(tt) as (select a from t1), t3 as (select * from t1), t4 as (select a from t1 where a > 105) select t2.tt, t3.a, t4.a from t2, t3, t4 where t2.tt > 107 order by t2.tt, t3.a, t4.a
  |                               ^^ Unknown table `default`.`t1` in catalog 'default'

.'
[SQL] with t2(tt) as (select a from t1), t3 as (select * from t1), t4 as (select a from t1 where a > 105) select t2.tt, t3.a, t4.a from t2, t3, t4 where t2.tt > 107 order by t2.tt, t3.a, t4.a
at tests/sqllogictests/suites/query/cte/cte.test:24

1: query result mismatch:
[SQL] select * from t2;
[Diff] (-expected|+actual)
-   104 100 102 101 103
+   104 100 102 101 103
+   107 105 106 108 109
+   107 105 106 108 109
+   111 112 113 114 110
+   111 112 113 114 110
+   115 118 119 116 117
+   115 118 119 116 117
at tests/sqllogictests/suites/query/cte/delete_cte.test:36

2: query result mismatch:
[SQL] select * from t2;
[Diff] (-expected|+actual)
    104 100 102 101 103
    107 105 106 108 109
+   107 105 106 108 109
+   111 112 113 114 110
    111 112 113 114 110
+   115 118 119 116 117
    115 118 119 116 117
at tests/sqllogictests/suites/query/cte/insert_cte.test:33

3: statement failed: mysql client error: Server error: `ERROR HY000 (1105): DatabaseAlreadyExists. Code: 2301, Text = Database 'db1' already exists.'
[SQL] CREATE DATABASE db1
at tests/sqllogictests/suites/query/functions/02_0049_function_semi_structureds_check_json.test:59

4: query failed: mysql client error: Server error: `ERROR HY000 (1105): SemanticError. Code: 1065, Text = error: 
  --> SQL:1:34
  |
1 | select id, json_path_query_array(arr, '$[2, 1 to last -1]') from t1
  |                                  ^^^ column arr doesn't exist

.'
[SQL] select id, json_path_query_array(arr, '$[2, 1 to last -1]') from t1
at tests/sqllogictests/suites/query/functions/02_0051_function_semi_structureds_get.test:575

5: query result mismatch:
[SQL] SELECT a, b, a is distinct FROM b FROM t
[Diff] (-expected|+actual)
+   0 NULL 1
+   1 NULL 1
+   NULL 0 1
+   NULL 1 1
+   NULL NULL 0
    0 0 0
    0 1 1
    1 0 1
    1 1 0
at tests/sqllogictests/suites/query/functions/02_0059_function_is_distinct_from.test:135

6: statement failed: mysql client error: Server error: `ERROR HY000 (1105): UnknownTable. Code: 1025, Text = Unknown table 't1'.'
[SQL] INSERT INTO t1 VALUES(55.72076201, 37.59813500, 15)
at tests/sqllogictests/suites/query/functions/02_0060_function_geo.test:16

7: query failed: mysql client error: Server error: `ERROR HY000 (1105): UnknownTable. Code: 1025, Text = error: 
  --> SQL:1:27
  |
1 | select h3_to_geo(h3) from t1
  |                           ^^ Unknown table `default`.`t1` in catalog 'default'

.'
[SQL] select h3_to_geo(h3) from t1
at tests/sqllogictests/suites/query/functions/02_0060_function_geo_h3.test:50

8: query failed: mysql client error: Server error: `ERROR HY000 (1105): UnknownTable. Code: 1025, Text = error: 
  --> SQL:1:15
  |
1 | select * from t1 right join t2 on t1.a > t2.c order by t1.a, t1.b, t2.c, t2.d
  |               ^^ Unknown table `default`.`t1` in catalog 'default'

.'
[SQL] select * from t1 right join t2 on t1.a > t2.c order by t1.a, t1.b, t2.c, t2.d
at tests/sqllogictests/suites/query/join_small_block_size.test:409