MySQL Bugs: #110423: ndb_opt.spj_rqg fails, but only on Mac OS X ARM laptop

Bug #110423	ndb_opt.spj_rqg fails, but only on Mac OS X ARM laptop
Submitted:	18 Mar 2023 20:30	Modified:	23 Mar 2023 7:40
Reporter:	Mikael Ronström	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
It adds one more condition in the push down compared to the expected
test results. So in a sense better if it is correct.

How to repeat:
obvious

Suggested fix:
Don't know

Hello Mikael,

Thank you for the report and feedback.

Sincerely,
Umesh

Posted by developer:
 
No problems could be found with ndb_opt.spj_rqg (see below), closing.

hourglass~/mysql/trunk[mysql-trunk|…7⚑1] % uname -a
Darwin hourglass 22.3.0 Darwin Kernel Version 22.3.0: Mon Jan 30 20:38:37 PST 2023; root:xnu-8792.81.3~2/RELEASE_ARM64_T6000 arm64

hourglass~/mysql/trunk[mysql-trunk|…7⚑1] % mtr --suite=ndb_opt
bld/mysql-test/mysql-test-run.pl --parallel=16 --force --test-progress --shutdown-timeout=0 --suite=ndb_opt
Logging: /Users/mblaudd/mysql/trunk/mysql-test/mysql-test-run.pl  --parallel=16 --force --test-progress --shutdown-timeout=0 --suite=ndb_opt
MySQL Version 8.0.34
Turning off '--mem' option since it is not supported on MacOS.
Checking supported features
 - Binaries are debug compiled
 - MySQL Cluster detected
 - enabling ndbcluster
 - multi threaded ndbd found, will be used "round robin"
Using suite(s): ndb_opt
Collecting tests
Removing old var directory
Creating var directory '/Users/mblaudd/mysql/trunk/bld/mysql-test/var'
Installing system database
Using parallel: 16

==============================================================================
                  TEST NAME                   WORKER RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
[  4%] ndb_opt.index_stat_index_size            w12 [ pass ]   5099
[  9%] ndb_opt.bushy_joins                      w16 [ pass ]  14432
[ 13%] ndb_opt.index_stat_restart               w15 [ pass ]  20569
[ 18%] ndb_opt.index_stat_kernel                w6  [ pass ]  25774
[ 22%] ndb_opt.index_stat_partitions_auto       w2  [ pass ]  31166
[ 27%] ndb_opt.condition_pushdown               w1  [ pass ]  30446
[ 31%] ndb_opt.index_stat_tables                w16 [ pass ]     30
[ 36%] ndb_opt.subquery                         w1  [ pass ]  10574
[ 40%] ndb_opt.index_stat_restart_auto          w10 [ pass ]  56042
[ 45%] ndb_opt.index_stat                       w12 [ pass ]  39078
[ 50%] ndb_opt.statistics0                      w2  [ pass ]  12160
[ 54%] ndb_opt.index_stat_partitions            w12 [ pass ]  10346
[ 59%] ndb_opt.index_stat_auto                  w14 [ pass ]  99324
[ 63%] ndb_opt.spj_rqg                          w1  [ pass ]  56262
[ 68%] ndb_opt.spj_skew                         w14 [ pass ]   2597
[ 72%] ndb_opt.spj_rqg_hypergraph               w10 [ pass ]  47668
[ 77%] ndb_opt.spj_dict                         w6  [ pass ]  84073
[ 81%] ndb_opt.rbwr                             w12 [ pass ]  63613
[ 86%] ndb_opt.statistics1                      w2  [ pass ]  83339
[ 90%] ndb_opt.join_pushdown_default            w15 [ pass ]  140770
[ 95%] ndb_opt.join_pushdown_bka                w16 [ pass ]  147594
[100%] shutdown_report                          w0  [ pass ]       
------------------------------------------------------------------------------
The servers were restarted 8 times
The servers were reinitialized 0 times
Spent 980.956 of 262 seconds executing testcases

Completed: All 22 tests were successful.