src/test/regress/sql/filesystem.sql

--
-- filesystem
-- 
--
-- *********************************************************************
-- *********************************************************************
-- test filesystem
-- 
-- *********************************************************************
-- *********************************************************************

select * from pg_filesystem;

CREATE FILESYSTEM HDFS2
(
    gpfs_connect = "gpfs_hdfs_connect",
    gpfs_disconnect = "gpfs_hdfs_disconnect",
    gpfs_open = "gpfs_hdfs_openfile",
    gpfs_close = "gpfs_hdfs_closefile",
    gpfs_seek = "gpfs_hdfs_seek",
    gpfs_tell = "gpfs_hdfs_tell",
    gpfs_read = "gpfs_hdfs_read",
    gpfs_write = "gpfs_hdfs_write",
    gpfs_flush = "gpfs_hdfs_sync",
    gpfs_delete = "gpfs_hdfs_delete",
    gpfs_chmod = "gpfs_hdfs_chmod",
    gpfs_mkdir = "gpfs_hdfs_createdirectory",
    gpfs_truncate = "gpfs_hdfs_truncate",
    gpfs_getpathinfo = "gpfs_hdfs_getpathinfo",
    gpfs_freefileinfo = "gpfs_hdfs_freefileinfo",
    gpfs_libfile = "$libdir/gpfshdfs.so"
);

select * from pg_filesystem;

--err: duplicate name
CREATE FILESYSTEM HDFS2
(
    gpfs_connect = "gpfs_hdfs_connect",
    gpfs_disconnect = "gpfs_hdfs_disconnect",
    gpfs_open = "gpfs_hdfs_openfile",
    gpfs_close = "gpfs_hdfs_closefile",
    gpfs_seek = "gpfs_hdfs_seek",
    gpfs_tell = "gpfs_hdfs_tell",
    gpfs_read = "gpfs_hdfs_read",
    gpfs_write = "gpfs_hdfs_write",
    gpfs_flush = "gpfs_hdfs_sync",
    gpfs_delete = "gpfs_hdfs_delete",
    gpfs_chmod = "gpfs_hdfs_chmod",
    gpfs_mkdir = "gpfs_hdfs_createdirectory",
    gpfs_truncate = "gpfs_hdfs_truncate",
    gpfs_getpathinfo = "gpfs_hdfs_getpathinfo",
    gpfs_freefileinfo = "gpfs_hdfs_freefileinfo",
    gpfs_libfile = "$libdir/gpfshdfs.so"
);

-- err: no gpfs_libfile
CREATE FILESYSTEM HDFS3
(
    gpfs_connect = "gpfs_hdfs_connect",
    gpfs_disconnect = "gpfs_hdfs_disconnect",
    gpfs_open = "gpfs_hdfs_openfile",
    gpfs_close = "gpfs_hdfs_closefile",
    gpfs_seek = "gpfs_hdfs_seek",
    gpfs_tell = "gpfs_hdfs_tell",
    gpfs_read = "gpfs_hdfs_read",
    gpfs_write = "gpfs_hdfs_write",
    gpfs_flush = "gpfs_hdfs_sync",
    gpfs_delete = "gpfs_hdfs_delete",
    gpfs_chmod = "gpfs_hdfs_chmod",
    gpfs_mkdir = "gpfs_hdfs_createdirectory",
    gpfs_truncate = "gpfs_hdfs_truncate",
    gpfs_getpathinfo = "gpfs_hdfs_getpathinfo",
    gpfs_freefileinfo = "gpfs_hdfs_freefileinfo"
);

-- err: dumplicate gpfs_libfile
CREATE FILESYSTEM HDFS3
(
    gpfs_libfile = "$libdir/gpfshdfs.so",
    gpfs_libfile = "$libdir/gpfshdfs.so",
    gpfs_connect = "gpfs_hdfs_connect",
    gpfs_disconnect = "gpfs_hdfs_disconnect",
    gpfs_open = "gpfs_hdfs_openfile",
    gpfs_close = "gpfs_hdfs_closefile",
    gpfs_seek = "gpfs_hdfs_seek",
    gpfs_tell = "gpfs_hdfs_tell",
    gpfs_read = "gpfs_hdfs_read",
    gpfs_write = "gpfs_hdfs_write",
    gpfs_flush = "gpfs_hdfs_sync",
    gpfs_delete = "gpfs_hdfs_delete",
    gpfs_chmod = "gpfs_hdfs_chmod",
    gpfs_mkdir = "gpfs_hdfs_createdirectory",
    gpfs_truncate = "gpfs_hdfs_truncate",
    gpfs_getpathinfo = "gpfs_hdfs_getpathinfo",
    gpfs_freefileinfo = "gpfs_hdfs_freefileinfo"
);

-- err: no gpfs_connect
CREATE FILESYSTEM HDFS3
(
    gpfs_libfile = "$libdir/gpfshdfs.so",
    gpfs_disconnect = "gpfs_hdfs_disconnect",
    gpfs_open = "gpfs_hdfs_openfile",
    gpfs_close = "gpfs_hdfs_closefile",
    gpfs_seek = "gpfs_hdfs_seek",
    gpfs_tell = "gpfs_hdfs_tell",
    gpfs_read = "gpfs_hdfs_read",
    gpfs_write = "gpfs_hdfs_write",
    gpfs_flush = "gpfs_hdfs_sync",
    gpfs_delete = "gpfs_hdfs_delete",
    gpfs_chmod = "gpfs_hdfs_chmod",
    gpfs_mkdir = "gpfs_hdfs_createdirectory",
    gpfs_truncate = "gpfs_hdfs_truncate",
    gpfs_getpathinfo = "gpfs_hdfs_getpathinfo",
    gpfs_freefileinfo = "gpfs_hdfs_freefileinfo"
);

-- err: dumplicate gpfs_connect
CREATE FILESYSTEM HDFS3
(
    gpfs_libfile = "$libdir/gpfshdfs.so",
    gpfs_connect = "gpfs_hdfs_connect",
    gpfs_connect = "gpfs_hdfs_connect",
    gpfs_disconnect = "gpfs_hdfs_disconnect",
    gpfs_open = "gpfs_hdfs_openfile",
    gpfs_close = "gpfs_hdfs_closefile",
    gpfs_seek = "gpfs_hdfs_seek",
    gpfs_tell = "gpfs_hdfs_tell",
    gpfs_read = "gpfs_hdfs_read",
    gpfs_write = "gpfs_hdfs_write",
    gpfs_flush = "gpfs_hdfs_sync",
    gpfs_delete = "gpfs_hdfs_delete",
    gpfs_chmod = "gpfs_hdfs_chmod",
    gpfs_mkdir = "gpfs_hdfs_createdirectory",
    gpfs_truncate = "gpfs_hdfs_truncate",
    gpfs_getpathinfo = "gpfs_hdfs_getpathinfo",
    gpfs_freefileinfo = "gpfs_hdfs_freefileinfo"
);

-- err: not exist
DROP FILESYSTEM HDFS3;

-- drop
DROP FILESYSTEM HDFS2;

select * from pg_filesystem;