#11798: extractFunctions OpenAPI methed against MSSQL is very slow and seems to ignore schema parameted

westers reported 2014-03-01T20:13:52Z · last modified 2014-03-21T18:13:08Z

extractFunctions OpenAPI methed against MSSQL is very slow and seems to ignore schema parameted

Dev	ivangron
QA	tariqrahiman

Priority	Minor
Complexity	Trivial

Component	Open API - General
Version	14.0

I find that the extractFunctions() method is very slow and returns functions from schemas that I do not specify in the schema parameter. I'm accessing a MSSQL 2012 database.

main();

function main() {

var conn = aqua.project.getServerConnection('MY_MSSQL_SERVER');

conn.connect();

conn.changeDatabase("MY_DB");

try {

print("Connected to server \"" + conn.name + "\" database \"" + conn.currentDatabase + "\"");

var meta = conn.getMetadata();

var funcs = meta.extractFunctions(conn.currentDatabase,"SCHEMA_WITH_NO_FUNCS");

funcs.forEach(

function(f) {

print(f.name);

}

);

} catch(e) {

print(e);

} finally {

conn.disconnect();

}

1 attachment

Screen Shot 2014-03-21 at 11.14.18 AM.png

2014-03-21T18:12:56Z

164 KB

All Comments (2) Change History

ivangron 2014-03-10T00:17:40Z

fixed extraction

anilkalshetti 2014-03-18T07:07:57Z

Verified in ADS 14.0.10

Search Tips

Aqua Data Studio / nhilam

extractFunctions OpenAPI methed against MSSQL is very slow and seems to ignore schema parameted

1 attachment

Issue #11798

Completion

Search Tips

Aqua Data Studio / nhilam

Title

extractFunctions OpenAPI methed against MSSQL is very slow and seems to ignore schema parameted

1 attachment

Issue #11798

Completion