--  No issues on Official build (using Linux - Generic (glibc 2.17)
(x86, 64-bit), TAR)


BugNumber=118090
rm -rf $BugNumber/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/$BugNumber --log-error-verbosity=3
bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/$BugNumber --core-file --socket=/tmp/mysql.sock  --port=3306 --log-error=$PWD/$BugNumber/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1  2>&1 &




/export/home/tmp/ushastry/work/binaries/mysql-9.3.0]$ bin/mysql -uroot
-S/tmp/mysql.sock --local-infile
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 9.3.0 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> create database test;
Query OK, 1 row affected (0.005 sec)

mysql> use test
Database changed
mysql> CREATE TABLE t0(c0 INT);
Query OK, 0 rows affected (0.014 sec)

mysql> CREATE TABLE t3(c0 INT);
Query OK, 0 rows affected (0.012 sec)

mysql>
mysql> INSERT INTO t0(c0) VALUES(1);
Query OK, 1 row affected (0.004 sec)

mysql> INSERT INTO t3(c0) VALUES(1);
Query OK, 1 row affected (0.002 sec)

mysql> INSERT INTO t3(c0) VALUES(1);
Query OK, 1 row affected (0.002 sec)

mysql>
mysql> SELECT *
    -> FROM t0 JOIN (SELECT (-(+ (''))) AS col0
    ->                        FROM t3
    ->               LIMIT 2) as subQuery1
    -> ON true;
+------+------+
| c0   | col0 |
+------+------+
|    1 |   -0 |
|    1 |   -0 |
+------+------+
2 rows in set (0.001 sec)

mysql> SELECT *
    -> FROM t0 JOIN (SELECT (-(+ (''))) AS col0
    ->                        FROM t3
    ->               LIMIT 2) as subQuery1
    -> ON true
    -> where (!(subQuery1.col0));
+------+------+
| c0   | col0 |
+------+------+
|    1 |   -0 |
|    1 |   -0 |
+------+------+
2 rows in set, 1 warning (0.001 sec)

## MySQL Server installed using brew

umshastr@umshastr-mac ~ % cls
zsh: command not found: cls
umshastr@umshastr-mac ~ % clear
umshastr@umshastr-mac ~ % brew install mysql
==> Auto-updating Homebrew...
Adjust how often this is run with HOMEBREW_AUTO_UPDATE_SECS or disable with
HOMEBREW_NO_AUTO_UPDATE. Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`).
==> Downloading https://ghcr.io/v2/homebrew/portable-ruby/portable-ruby/blobs/sha256:40e7f5d7514a7e9757facdd39006f7a351d3d7986d3a228be13c8b1c3216727b
##################################################################################################################################################################################################################################### 100.0%
==> Pouring portable-ruby-3.4.3.arm64_big_sur.bottle.tar.gz
==> Auto-updated Homebrew!
==> Updated Homebrew from 4.4.31 (5fb70f5a57) to 4.5.1 (e5308b0245).
Updated 2 taps (homebrew/core and homebrew/cask).
==> New Formulae
add-determinism              ferron                       infat                        multi-gitter                 preevy                       sexpect                      tfmv                         unoserver
bkmr                         girara                       kubernetes-cli@1.32          newsraft                     readerwriterqueue            swiftly                      tfsort                       wrkflw
camlpdf                      hexd                         mender-artifact              opkssh                       rofi                         tdom                         tmex                         yeet
elfio                        iccmax                       miniflux                     policy-engine                sequoia-chameleon-gnupg      terraform-module-versions    undercutf1
==> New Casks
aqua-voice                        elemental@6                       font-bizter                       font-harmonyos-sans-naskh-arabic  font-jetbrains-maple-mono-nf      font-wdxl-lubrifont-tc            sc-menu
cloudpouch                        font-adwaita-mono-nerd-font       font-fzhei-b01                    font-harmonyos-sans-sc            font-noto-serif-dives-akuru       meru                              warp@preview
clover-chord-systems              font-asta-sans                    font-fzxiheii-z08                 font-harmonyos-sans-tc            font-wdxl-lubrifont-jp-n          outerbase-studio                  witsy
elemental                         font-atkynson-mono-nerd-font      font-harmonyos-sans               font-jetbrains-maple-mono         font-wdxl-lubrifont-sc            realvnc-connect

You have 6 outdated formulae installed.


The 4.5.0 release notes are available on the Homebrew Blog:
  https://brew.sh/blog/4.5.0
The 4.5.1 changelog can be found at:
  https://github.com/Homebrew/brew/releases/tag/4.5.1
==> Downloading https://ghcr.io/v2/homebrew/core/mysql/manifests/9.3.0
##################################################################################################################################################################################################################################### 100.0%
==> Fetching dependencies for mysql: protobuf@29 and zlib
==> Downloading https://ghcr.io/v2/homebrew/core/protobuf/29/manifests/29.4
##################################################################################################################################################################################################################################### 100.0%
==> Fetching protobuf@29
==> Downloading https://ghcr.io/v2/homebrew/core/protobuf/29/blobs/sha256:201dfed6c12d9a7eb607c3f42c880633f92ef4c0ac74f09d87c8698104b0d6fe
##################################################################################################################################################################################################################################### 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/zlib/manifests/1.3.1
##################################################################################################################################################################################################################################### 100.0%
==> Fetching zlib
==> Downloading https://ghcr.io/v2/homebrew/core/zlib/blobs/sha256:a801a93f88dba4df7319e46cd9ea5939351e73f7aa62a5153a2f7a0b0d79404d
##################################################################################################################################################################################################################################### 100.0%
==> Fetching mysql
==> Downloading https://ghcr.io/v2/homebrew/core/mysql/blobs/sha256:a1c4bcbfc9cd29ebd827d898ee23fa671d38e53fe38ed941d4de9dc5f2925bab
##################################################################################################################################################################################################################################### 100.0%
==> Installing dependencies for mysql: protobuf@29 and zlib
==> Installing mysql dependency: protobuf@29
==> Downloading https://ghcr.io/v2/homebrew/core/protobuf/29/manifests/29.4
Already downloaded: /Users/umshastr/Library/Caches/Homebrew/downloads/79af11557ac231cc4a15c5e425af5edddfb86d564c59b33b396d54e7168deb4d--protobuf@29-29.4.bottle_manifest.json
==> Pouring protobuf@29--29.4.arm64_sequoia.bottle.tar.gz
🍺  /opt/homebrew/Cellar/protobuf@29/29.4: 445 files, 15.4MB
==> Installing mysql dependency: zlib
==> Downloading https://ghcr.io/v2/homebrew/core/zlib/manifests/1.3.1
Already downloaded: /Users/umshastr/Library/Caches/Homebrew/downloads/f68d0caf232d52f2aa586abefbbfd7e958e384d84f3967008fa83de94b5f10ae--zlib-1.3.1.bottle_manifest.json
==> Pouring zlib--1.3.1.arm64_sequoia.bottle.tar.gz
🍺  /opt/homebrew/Cellar/zlib/1.3.1: 14 files, 403.9KB
==> Installing mysql
==> Pouring mysql--9.3.0.arm64_sequoia.bottle.tar.gz
==> /opt/homebrew/Cellar/mysql/9.3.0/bin/mysqld --initialize-insecure --user=umshastr --basedir=/opt/homebrew/Cellar/mysql/9.3.0 --datadir=/opt/homebrew/var/mysql --tmpdir=/tmp
==> Caveats
Upgrading from MySQL <8.4 to MySQL >9.0 requires running MySQL 8.4 first:
 - brew services stop mysql
 - brew install mysql@8.4
 - brew services start mysql@8.4
 - brew services stop mysql@8.4
 - brew services start mysql

We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -u root

To start mysql now and restart at login:
  brew services start mysql
Or, if you don't want/need a background service you can just run:
  /opt/homebrew/opt/mysql/bin/mysqld_safe --datadir\=/opt/homebrew/var/mysql
==> Summary
🍺  /opt/homebrew/Cellar/mysql/9.3.0: 333 files, 291.9MB
==> Running `brew cleanup mysql`...
Disable this behaviour by setting HOMEBREW_NO_INSTALL_CLEANUP.
Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`).
==> Caveats
==> mysql
Upgrading from MySQL <8.4 to MySQL >9.0 requires running MySQL 8.4 first:
 - brew services stop mysql
 - brew install mysql@8.4
 - brew services start mysql@8.4
 - brew services stop mysql@8.4
 - brew services start mysql

We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -u root

To start mysql now and restart at login:
  brew services start mysql
Or, if you don't want/need a background service you can just run:
  /opt/homebrew/opt/mysql/bin/mysqld_safe --datadir\=/opt/homebrew/var/mysql
umshastr@umshastr-mac ~ %
umshastr@umshastr-mac ~ %
umshastr@umshastr-mac ~ % brew services start mysql
==> Successfully started `mysql` (label: homebrew.mxcl.mysql)
umshastr@umshastr-mac ~ %
umshastr@umshastr-mac ~ % mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 9.3.0 Homebrew

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database test;
Query OK, 1 row affected (0.005 sec)

mysql> use test
Database changed
mysql> CREATE TABLE t0(c0 INT);
Query OK, 0 rows affected (0.011 sec)

mysql> CREATE TABLE t3(c0 INT);
Query OK, 0 rows affected (0.007 sec)

mysql>
mysql> INSERT INTO t0(c0) VALUES(1);
Query OK, 1 row affected (0.006 sec)

mysql> INSERT INTO t3(c0) VALUES(1);
Query OK, 1 row affected (0.001 sec)

mysql> INSERT INTO t3(c0) VALUES(1);
Query OK, 1 row affected (0.002 sec)

mysql> SELECT *
    -> FROM t0 JOIN (SELECT (-(+ (''))) AS col0
    ->                        FROM t3
    ->               LIMIT 2) as subQuery1
    -> ON true;
+------+------+
| c0   | col0 |
+------+------+
|    1 |   -0 |
|    1 |   -0 |
+------+------+
2 rows in set (0.001 sec)

mysql> SELECT *
    -> FROM t0 JOIN (SELECT (-(+ (''))) AS col0
    ->                        FROM t3
    ->               LIMIT 2) as subQuery1
    -> ON true
    -> where (!(subQuery1.col0));
+------+------+
| c0   | col0 |
+------+------+
|    1 |   -0 |
|    1 |   -0 |
+------+------+
2 rows in set, 1 warning (0.001 sec)

mysql>