This repository has been archived on 2025-01-04. You can view files and clone it, but cannot push or open issues or pull requests.
lwb6/legacyworlds-server-data/db-structure/tests/user/040-functions/026-technology-dependencies/050-tgf-techdeps-ai.sql
Emmanuel BENOîT 4f083830f2 Technology dependencies caching and integrity checks
* Added table that will contain the cached technology dependencies.

* Implemented trigger functions that update the cache and make sure
there are no cycles or redundancies in the technology graph.

* The following SQL files need to be (re-)executed:
  -> 030-data/080-techs.sql (for the defs.techdep_cache table)
  -> 040-functions/026-technology-dependencies.sql (new file)
2012-02-16 18:30:58 +01:00

14 lines
No EOL
266 B
PL/PgSQL

/*
* Test privileges on defs.tgf_techdeps_ai( )
*/
BEGIN;
SELECT plan( 1 );
SELECT diag_test_name( 'defs.tgf_techdeps_ai( ) - No EXECUTE privilege' );
SELECT throws_ok( $$
SELECT defs.tgf_techdeps_ai( );
$$ , 42501 );
SELECT * FROM finish( );
ROLLBACK;