I have a select query that uses a WHERE IN clause in a MemSQL database. The list of values searched in are a result of another select query. Before, I inserted the values for that clause as a string through a web service like so: (1,2,3..). Now I want to move the second query into a stored procedure, and have the values mentioned above be a part of the parameters for that procedure. Say I have a table: create table t (num int); Then when I try to create the sp: DELIMITER // CREATE PROCEDURE test (nums ARRAY(INT)) AS BEGIN ECHO SELECT * FROM t WHERE num IN nums; END // DELIMITER ; I get: ERROR 1064 (42000): Compilation error in function test near line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nums' So apparently it doesn't work that way. Is there way I can get this to recognize the data type I'm inserting? I want to avoid manipulating strings, but if there is no choice, would it require running the query as a string in the stored procedure?

I’m having trouble to execute immediate a SP inside a SP from a table. because i have a lot of SP stored in a table (as a data/string). in oracle we can use “select sp_1(:1,:2) from dual” and running it via execute immediate. how’s singlestore do that? i get error. please help, because we want to migrate from oracle to singlestore. i changed a lot of SP from oracle to singlestore. thanks.

Creating table in MemSQL and creating composite primary key. Lets create simple table with following structure: Table User Data Name userid Primary Key (userid) And assume application support case sensitive userid. So that following user id considered to be different: abc ABC Insert following data: 1) JOHN ABC b) ALEX abc Insert fails in MemSQL as it consider 'ABC' same as 'abc'. Please help me to understand if case sensitive primary key possible in MemSQL table or not.

below is the command that i am using, but when i create the kafka pipeline command i get the below error: ERROR 1933 ER_EXTRACTOR_EXTRACTOR_GET_LATEST_OFFSETS: Cannot get source metadata for pipeline. Failed to create consumer: ssl.ca.location failed: No further error information available Command used: CREATE PIPELINE ticketmaster_pipeline AS LOAD DATA KAFKA ‘b-3.etainmentnonprod.z2xjta.c25.kafka.us-east-1.amazonaws.com:9094,b-1.etainmentnonprod.z2xjta.c25.kafka.us-east-1.amazonaws.com:9094,b-2.etainmentnonprod.z2xjta.c25.kafka.us-east-1.amazonaws.com:9094/ticketmaster’ CONFIG '{“sasl.username”: “AWS_ACCESS_KEY”, "sasl.mechanism": "PLAIN", "security.protocol": "SASL_SSL", "ssl.ca.location": "/etc/pki/ca-trust/extracted/java/cacerts"}' CREDENTIALS ‘{“sasl.password”: “AWS_PSWD/Z”}’ INTO TABLE ticketmaster_kafka FORMAT JSON (event_url ← event_url,event_id ← event_id,timestamp ← timestamp,event_name ← event_name,venue ← venue,event_datetime ← event_datetime,city ← city,state ← state,section ← section,row ← row,qty ← qty,seat_ids ← seat_ids,seat_numbers ← seat_numbers,inventory_type ← inventory_type,price ← price); My kafka setup in on AWS MSK insatnce and i have data in the topic also

I’m having difficulty finding the exception no_data_found in **singlestore**. In **Oracle**, we use no_data_found exception. Is there any alternative solution in **singlestore** for the no_data_found exception?

an aspiring DBA Here. I'm trying to create a stored procedure for a query I'm running. It is a memsql server which is MySQL based. The procedure is as such: delimiter // CREATE PROCEDURE calc_campaign (IN usr VARCHAR(38)) BEGIN Awesome SELECT statement that uses a variable END // The error description is: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN usr VARCHAR(38)) BEGIN my_statement; END' at line 1 The syntax I used seems to correspond with this: https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html And with pretty much every other procedure I saw on Stack forums. What is it I'm missing here? Thanks for any help!