[MDEV-19275] Provide SQL service to plugins. - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Fix Version/s: 10.7.1
Component/s: Plugins
Labels:
None

Description

It'd be useful for some plugins to read/store data from/to server tables.
So we can provide the service (as it is defined in the Plugin API) with that functionality.
The functions of that service look exactly as their counterparts from the client library, so users won't be needing extra documentation.
The decided set of functions is:
mysql_init
mysql_real_connect
mysql_options
mysql_close
mysql_real_query
mysql_affected_rows
mysql_errno
mysql_error
mysql_store_result
mysql_free_result
mysql_num_rows
mysql_num_fields
mysql_fetch_row
mysql_fetch_lengths

So that the plugin can do calls like
mysql_real_connect();
mysql_real_query();..
res= mysql_store_result();
...
and it's supposed to work as it does with the client library. The only addition is the
MYSQL_CONNECT_LOCAL option. Connection of that sort attaches to the server itself.

These local queries handled using Server_runnable class model.

Attachments

Issue Links

blocks

MDEV-27595 Backport SQL service, introduced by MDEV-19275

Closed

causes

MDEV-26890 rpl.rpl_shutdown_wait_slaves fails with timeout on sync_with_master

Closed

includes

MDEV-4641 API for running SQL from inside the server

Closed

is blocked by

MDEV-9245 password "reuse prevention" validation plugin

Closed

Activity

Ascending order - Click to sort in descending order

Alexey Botchkov created issue - 2019-04-17 20:20

Alexey Botchkov made changes - 2019-04-22 08:25

Field	Original Value	New Value
Status	Open [ 1 ]	In Progress [ 3 ]

Alexey Botchkov made changes - 2019-04-22 08:25

Assignee	Alexey Botchkov [ holyfoot ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Ralf Gebhardt made changes - 2019-05-07 21:04

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2019-05-10 14:17

Assignee	Sergei Golubchik [ serg ]	Alexey Botchkov [ holyfoot ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Alexey Botchkov made changes - 2019-05-21 10:58

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Alexey Botchkov made changes - 2019-05-21 11:07

Fix Version/s		10.4.5 [ 23311 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Alexey Botchkov made changes - 2019-05-21 13:27

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.4.5 [ 23311 ]

Alexey Botchkov made changes - 2020-09-22 09:10

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Alexey Botchkov made changes - 2020-09-22 09:10

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2020-09-29 13:42

Fix Version/s		10.6 [ 24028 ]
Fix Version/s	N/A [ 14700 ]

Sergei Golubchik made changes - 2021-03-17 15:09

Assignee

Alexey Botchkov [ holyfoot ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2021-03-17 15:09

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Sergei Golubchik made changes - 2021-03-17 15:10

Assignee

Sergei Golubchik [ serg ]

Alexey Botchkov [ holyfoot ]

Sergei Golubchik made changes - 2021-03-17 15:10

Fix Version/s		10.7 [ 24805 ]
Fix Version/s	10.6 [ 24028 ]

Sergei Golubchik made changes - 2021-06-04 13:48

Link

This issue blocks ~~MDEV-9245~~ [ ~~MDEV-9245~~ ]

Alexey Botchkov made changes - 2021-08-03 12:44

Priority

Critical [ 2 ]

Blocker [ 1 ]

Alexey Botchkov made changes - 2021-08-04 09:15

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Ralf Gebhardt made changes - 2021-08-12 08:54

Parent	MDEV-5313 [ 26510 ]
Issue Type	Technical task [ 7 ]	Task [ 3 ]

Sergei Golubchik made changes - 2021-08-25 09:35

Comment

[ A comment with security level 'Developers' was removed. ]

Alexey Botchkov made changes - 2021-09-06 19:42

Assignee	Alexey Botchkov [ holyfoot ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Oleksandr Byelkin made changes - 2021-09-07 06:53

Assignee

Sergei Golubchik [ serg ]

Oleksandr Byelkin [ sanja ]

Oleksandr Byelkin made changes - 2021-09-07 06:53

Assignee	Oleksandr Byelkin [ sanja ]	Alexey Botchkov [ holyfoot ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Alexey Botchkov made changes - 2021-09-07 11:12

Assignee	Alexey Botchkov [ holyfoot ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2021-09-07 14:10

Assignee	Sergei Golubchik [ serg ]	Alexey Botchkov [ holyfoot ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Alexey Botchkov made changes - 2021-09-08 12:01

Assignee

Alexey Botchkov [ holyfoot ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2021-09-09 19:39

Assignee

Sergei Golubchik [ serg ]

Alexey Botchkov [ holyfoot ]

Sergei Golubchik made changes - 2021-09-13 12:24

Assignee

Alexey Botchkov [ holyfoot ]

Elena Stepanova [ elenst ]

Sergei Golubchik made changes - 2021-09-13 12:29

Assignee

Elena Stepanova [ elenst ]

Sergei Golubchik [ serg ]

Oleksandr Byelkin made changes - 2021-09-13 16:21

Link

This issue relates to TODO-3118 [ TODO-3118 ]

Sergei Golubchik made changes - 2021-09-14 06:49

Link

This issue blocks ~~MDEV-9245~~ [ ~~MDEV-9245~~ ]

Sergei Golubchik made changes - 2021-09-14 06:49

Link

This issue is blocked by ~~MDEV-9245~~ [ ~~MDEV-9245~~ ]

Sergei Golubchik made changes - 2021-09-14 06:50

Link

This issue is part of ~~MDEV-9245~~ [ ~~MDEV-9245~~ ]

Sergei Golubchik made changes - 2021-09-14 06:50

Link

This issue is part of ~~MDEV-9245~~ [ ~~MDEV-9245~~ ]

Sergei Golubchik made changes - 2021-10-22 06:15

Fix Version/s		10.7.1 [ 26120 ]
Fix Version/s	10.7 [ 24805 ]
Assignee	Sergei Golubchik [ serg ]	Alexey Botchkov [ holyfoot ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Vladislav Vaintroub made changes - 2021-10-25 10:53

Link

This issue causes ~~MDEV-26890~~ [ ~~MDEV-26890~~ ]

Sergei Golubchik made changes - 2021-12-06 21:24

Workflow

MariaDB v3 [ 95458 ]

MariaDB v4 [ 133931 ]

Ralf Gebhardt made changes - 2022-04-22 08:56

Link

This issue blocks ~~MDEV-27595~~ [ ~~MDEV-27595~~ ]

Ralf Gebhardt made changes - 2022-05-11 16:21

Link

This issue blocks MENT-1348 [ MENT-1348 ]

Ralf Gebhardt made changes - 2022-08-31 16:43

Link

This issue relates to MENT-1619 [ MENT-1619 ]

Sergei Golubchik made changes - 2024-12-16 10:53

Link

This issue includes ~~MDEV-4641~~ [ ~~MDEV-4641~~ ]

People

Assignee:: Alexey Botchkov

Reporter:: Alexey Botchkov

Votes:: 1 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: 2019-04-17 20:20

Updated:: 2025-03-13 11:32

Resolved:: 2021-10-22 06:15

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration