question: which version to support in SQLancer

[zhenglin-charlie-li]

trafficstars

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:

• Is there a timeline about when will the 8.0 Docker image be released?
• Which version (5.7 or 8.0) would you like us to support?
• There is no 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?

[RingsC]

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.

[zhenglin-charlie-li]

Cool! Thanks for replying.

1. How could we get the Docker image for the 8.0 version?
2. OK, we will discuss with our team which version to support.
3. Oh, I found a typo. /stonedb57/install has a reinstall.sh but /stonedb80/install does not have a reinstall.sh

[davidshiz]

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

[RingsC]

Cool! Thanks for replying.

1. How could we get the Docker image for the 8.0 version?
2. OK, we will discuss with our team which version to support.
3. Oh, I found a typo. /stonedb57/install has a reinstall.sh but /stonedb80/install does not have a reinstall.sh

We will upload the image to docker hub in next week, and we will send you the notification when the imange is ready.

[zhenglin-charlie-li]

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?

[haitaoguan]

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.

[zhenglin-charlie-li]

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.

[davidshiz]

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