[MDEV-32773] Syntax error upon Spider initialization under ORACLE mode (a different one) Created: 2023-11-11  Updated: 2023-11-14

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-29870 Backport fixes to spider init bugs to... Closed
is blocked by MDEV-32753 Spider engine does not load in ORACLE... Closed

 Description   

Note: it is not the same as MDEV-32753.

Upon loading Spider under sql_mode=ORACLE, an error is written into the error log:

10.5 ea0b1ccd

 
[ERROR] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'begin  set @col_exists := 0;  select 1 into @col_exists from INFORMATION_SCHE...' at line 1

Spider however still loads.

 Comments   
Comment by Yuchen Pei [ 2023-11-14 ]

This should be fixed by the fix for MDEV-32753, and its counterpart in 10.4-6 after MDEV-29870.

Generated at Thu Feb 08 10:33:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.