aqs.query_hash= $1;

$func$ LANGUAGE SQL;

CREATEFUNCTIONpublic.aqo_enable_query(hashint)

RETURNS VOID

AS $func$

UPDATE aqo_queriesSET

learn_aqo='true',

use_aqo='true'

WHERE query_hash= $1;

$func$ LANGUAGE SQL;

CREATEFUNCTIONpublic.aqo_disable_query(hashint)

RETURNS VOID

AS $func$

UPDATE aqo_queriesSET

learn_aqo='false',

use_aqo='false',

auto_tuning='false'

WHERE query_hash= $1;

$func$ LANGUAGE SQL;

CREATEFUNCTIONpublic.aqo_clear_hist(hashint)

RETURNS VOID

AS $func$

DELETEFROM aqo_dataWHERE fspace_hash=$1;

$func$ LANGUAGE SQL;

CREATEFUNCTIONpublic.aqo_ne_queries()

RETURNS SETOFint

AS $func$

SELECT query_hashFROM aqo_query_stat aqsWHERE-1= ANY (cardinality_error_with_aqo::double precision[]);

$func$ LANGUAGE SQL;

CREATEFUNCTIONpublic.aqo_drop(hashint)

RETURNS VOID

AS $func$

DELETEFROM aqo_queries aqWHERE (aq.query_hash= $1);

DELETEFROM aqo_data adWHERE (ad.fspace_hash= $1);

DELETEFROM aqo_query_stat aqWHERE (aq.query_hash= $1);

DELETEFROM aqo_query_texts aqWHERE (aq.query_hash= $1);

$func$ LANGUAGE SQL;