manticoresearch icon indicating copy to clipboard operation
manticoresearch copied to clipboard

Published 20 hours ago • verified publisher icon manticoresoftware

CREATE FUNCTION and CREATE PROCEDURE

Open hiqsociety opened this issue 3 years ago • 3 comments

CREATE FUNCTION and CREATE PROCEDURE feature

since it's more db now. possible to hv these in? thx

hiqsociety avatar Aug 10 '22 21:08 hiqsociety

Well there is CREATE FUNCTION https://manual.manticoresearch.com/Extensions/UDFs_and_Plugins/UDF/Creating_a_function :)

... if you meaning to be able to just run a user defined SQL script, that seems like a big ask, would need to fully implement scripting. Manticore doesn't even have things like BEGIN..END blocks, LOOP, not even proper user-variables.

To see this I think would have to make more case why it would be useful, and what you could do with this, that can't do in any other way.

barryhunter avatar Aug 10 '22 21:08 barryhunter

it could be better to provide example why do you need CREATE statements as I not sure we will be able to implement full capable SQL script and where is no open source SQL script library that could be integrated into Manticore.

tomatolog avatar Aug 11 '22 08:08 tomatolog

coz it makes more sense from a database perspective for

  1. transaction based stuff
  2. a lot of mysql stuff has a lot of written create procedure / create function implementation.

hiqsociety avatar Aug 11 '22 12:08 hiqsociety