Queries on Sql Testing support in AIQ

1.Is the Joins clause Supported in .Sql script?

Yes, it’s supported.

2. Can we write all sorts of SQL commands like DDL, DML, DCL, TCL, and DQL. in .sql script ? What all is possible and what are the limitations?

The scope of usage for SQLClient includes DQL, DML sentences, TCL if it’s included in a stored procedure.

3.If there is more data in the table, for example sql query returns more than 10000 rows of data, will the Appvance sql engine wait for all this huge data to be returned.

This process is synchronic so the execution will wait for this process to be done.

What would be the ideal wait period?

No as it, but it’s possible to establish a rows extraction limit so the execution time can be customized, there are external factors that can affect database communication like latency, missing indexes for the query, insufficient temporal space, etc.

Will the performance of the .sql script execution be affected?

Performance would be the same than when using a database client.

4. Currently in the locker it stores the particular row data that is provided in the .sql script for example storeInLocker=1, it stores the first row of data. Can we store the data of all the rows and pass the row data dynamically in the ds/js scripts?

Beginning AIQ-4.8.3 there’s a new feature that allow us extracting a bunch of rows defined by a new token --limit which determine the max rows returned.

5. Is Nested Sql query supported?

Yes, it is.

6. Is there an option to edit a .sql file in AIQ?

It can be save a .js file to edit it using JS Edit & Play, once it’s uploaded in the repository it can be renamed again using the AIQ file explorer, over the file right click and rename as .sql file.