Open ZhengLin-Li opened 1 year ago
1: 8.0 docker image will be released in next moth, If you want to get a copy of that, we can build a copy for your team.
2:for 5.7, it's 5.7.36; and for 8.0, it's 8.0.30. Now, we support two major vesions. MySQL 5.7 (5.7.36) and MySQL 8.0 (8.0.30).
3:/stonedb57/install
is where you binary file installed? if yes, reinstall.sh
should be here, otherwise, enn, may some errors existed in your installation. OK, stonedb57
means that it's stoendb for mysql 5.7, not 8.0.
Cool! Thanks for replying.
/stonedb57/install
has a reinstall.sh
but /stonedb80/install
does not have a reinstall.sh
8.0 version is different from the 5.7 build steps, ref to https://stonedb.io/zh/docs/developer-guide/compiling-methods/compile-using-ubuntu2204/compile-using-ubuntu22.04-for-80
If have any other questions feel free to contact, tks so much
Cool! Thanks for replying.
- How could we get the Docker image for the 8.0 version?
- OK, we will discuss with our team which version to support.
- Oh, I found a typo.
/stonedb57/install
has areinstall.sh
but/stonedb80/install
does not have areinstall.sh
We will upload the image to docker hub in next week, and we will send you the notification when the imange is ready.
Hi, @davidshiz @RingsC thanks for replying.
I got another question: How can I config StoneDB if I am using a Docker container v1.0.4 version?
I need to enable the MySQL core::Query Path in config file, but I do not know how can I config?
The error may be cross engine query or SQL syntax not supported. You can check if the engine in the table below are consistent. If it is consistent and an error still reported, your reproduction steps are required.
The error may be cross engine query or SQL syntax not supported. You can check if the engine in the table below are consistent. If it is consistent and an error still reported, your reproduction steps are required.
Hi @haitaoguan , I have checked that the table is consistent.
Reproduction steps:
CREATE TABLE t0(c0 BLOB );
SELECT * FROM t0 WHERE ((t0.c0)XOR(0.3675585217931042)) UNION ALL SELECT * FROM t0 WHERE (NOT ((t0.c0)XOR(0.3675585217931042))) UNION ALL SELECT * FROM t0 WHERE ((((t0.c0)XOR(0.3675585217931042))) IS N
ULL);
-- ERROR 6 (HY000): The query includes syntax that is not supported by the storage engine. Either restructure the query with supported syntax, or enable the MySQL core::Query Path in config file to execute the query with reduced performance.
Configure the parameter tianmu_ini_allowmysqlquerypath
in my.cnf
● Default value: 0
● Value range: 1/0
● Suggested value: If set to 1, SQL parsing, optimization, and execution are all implemented at the Server layer,not use tianmu's optimizer. It is recommended to keep the default value
General Question
Hi, I am an open source contributor in the SQLancer community, and I am creating this issue to ask a few questions.
Our team is working on let SQLancer to support StoneDB and try to find bugs in it. Our team would prefer to support the 8.0 version of StoneDB, but met some problems when installing the 8.0 beta version accroding to the docs.
So, we'd like to ask a few questions:
reinstall.sh
script in the/stonedb57/install
folder, is this a bug? If it's not, how can we install the 8.0 beta version?