Update of /cvsroot/monetdb/sql/src/odbc/samples/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv3837/src/odbc/samples/Tests
Modified Files:
All
Added Files:
testgetinfo.SQL testgetinfo.SQL.bat testgetinfo.stable.err
testgetinfo.stable.out
Log Message:
propagated changes of Monday Jul 09 2007 - Tuesday Jul 24 2007
from the SQL_2-18 branch to the development trunk
--- NEW FILE: testgetinfo.SQL ---
#!/bin/sh
PATH="`monetdb-clients-config --pkglibdir`/Tests:$PATH"
export PATH
Mlog -x testgetinfo
--- NEW FILE: testgetinfo.stable.err ---
stderr of test 'testgetinfo` in directory 'src/odbc/samples` itself:
# 11:43:58 >
# 11:43:58 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/Monet-Stable/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/Monet-Stable/lib64/MonetDB4:/ufs/sjoerd/Monet-Stable/lib64/MonetDB4/lib:/ufs/sjoerd/Monet-Stable/lib64/MonetDB4/bin"
--set
"gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/sql_logs"
--set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/xquery_logs"
--set mapi_open=true --set mapi_port=34419 --set xrpc_port=47150 --set
monet_prompt= --trace "--dbname=mTests_src_odbc_samples" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 11:43:58 >
# 11:43:58 >
# 11:43:58 > Mtimeout -timeout 60 ./testgetinfo.SQL testgetinfo
# 11:43:58 >
# 11:43:58 >
# 11:43:58 > testgetinfo
# 11:43:58 >
# 11:43:58 >
# 11:43:58 > Done.
# 11:43:58 >
--- NEW FILE: testgetinfo.stable.out ---
stdout of test 'testgetinfo` in directory 'src/odbc/samples` itself:
# 11:43:58 >
# 11:43:58 > Mtimeout -timeout 180 Mserver
"--config=/ufs/sjoerd/Monet-Stable/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet4/.libs:/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/src/backends/monet4:/ufs/sjoerd/src/MonetDB/stable/sql/src/backends/monet4:/ufs/sjoerd/Monet-Stable/lib64/MonetDB4:/ufs/sjoerd/Monet-Stable/lib64/MonetDB4/lib:/ufs/sjoerd/Monet-Stable/lib64/MonetDB4/bin"
--set
"gdk_dbfarm=/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set
"sql_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/sql_logs"
--set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/stable/sql/x86_64-unknown-linux-gnu/xquery_logs"
--set mapi_open=true --set mapi_port=34419 --set xrpc_port=47150 --set
monet_prompt= --trace "--dbname=mTests_src_odbc_samples" --dbinit="
module(sql_server);" ; echo ; echo Over..
# 11:43:58 >
# Monet Database Server V4.18.1
# Copyright (c) 1993-2007, CWI. All rights reserved.
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
# Visit http://monetdb.cwi.nl/ for further information.
printf("\nReady.\n");
Ready.
quit();
Over..
# 11:43:58 >
# 11:43:58 > Mtimeout -timeout 60 ./testgetinfo.SQL testgetinfo
# 11:43:58 >
# 11:43:58 >
# 11:43:58 > testgetinfo
# 11:43:58 >
SQL_ACCESSIBLE_PROCEDURES: Y
SQL_ACCESSIBLE_TABLES: N
SQL_ACTIVE_ENVIRONMENTS: 0
SQL_AGGREGATE_FUNCTIONS: 127
SQL_ALTER_DOMAIN: 0
SQL_ALTER_TABLE: 55656
SQL_ASYNC_MODE: 0
SQL_BATCH_ROW_COUNT: 2
SQL_BATCH_SUPPORT: 3
SQL_BOOKMARK_PERSISTENCE: 0
SQL_CATALOG_LOCATION: 0
SQL_CATALOG_NAME_SEPARATOR:
SQL_CATALOG_NAME: N
SQL_CATALOG_TERM:
SQL_CATALOG_USAGE: 0
SQL_COLLATION_SEQ: UTF-8
SQL_COLUMN_ALIAS: Y
SQL_CONCAT_NULL_BEHAVIOR: 0
SQL_CONVERT_BIGINT: 2097151
SQL_CONVERT_BINARY: 2097151
SQL_CONVERT_BIT: 2097151
SQL_CONVERT_CHAR: 2097151
SQL_CONVERT_DATE: 2097151
SQL_CONVERT_DECIMAL: 2097151
SQL_CONVERT_DOUBLE: 2097151
SQL_CONVERT_FLOAT: 2097151
SQL_CONVERT_FUNCTIONS: 3
SQL_CONVERT_INTEGER: 2097151
SQL_CONVERT_INTERVAL_DAY_TIME: 2097151
SQL_CONVERT_INTERVAL_YEAR_MONTH: 2097151
SQL_CONVERT_LONGVARBINARY: 2097151
SQL_CONVERT_LONGVARCHAR: 2097151
SQL_CONVERT_NUMERIC: 2097151
SQL_CONVERT_REAL: 2097151
SQL_CONVERT_SMALLINT: 2097151
SQL_CONVERT_TIME: 2097151
SQL_CONVERT_TIMESTAMP: 2097151
SQL_CONVERT_TINYINT: 2097151
SQL_CONVERT_VARBINARY: 2097151
SQL_CONVERT_VARCHAR: 2097151
SQL_CORRELATION_NAME: 2
SQL_CREATE_SCHEMA: 3
SQL_CREATE_TABLE: 13851
SQL_CREATE_TRANSLATION: 0
SQL_CREATE_VIEW: 3
SQL_CURSOR_COMMIT_BEHAVIOR: 0
SQL_CURSOR_ROLLBACK_BEHAVIOR: 0
SQL_CURSOR_SENSITIVITY: 1
SQL_DATABASE_NAME:
SQL_DATA_SOURCE_NAME: MonetDB
SQL_DATA_SOURCE_READ_ONLY: N
SQL_DBMS_NAME: MonetDB ODBC driver
SQL_DBMS_VER: 1.00
SQL_DDL_INDEX: 0
SQL_DEFAULT_TXN_ISOLATION: 2
SQL_DESCRIBE_PARAMETER: N
SQL_DM_VER:
SQL_DRIVER_HDESC: 0
SQL_DRIVER_NAME: MonetDBODBClib
SQL_DRIVER_ODBC_VER: 03.52
SQL_DRIVER_VER: 1.00
SQL_DROP_ASSERTION: 0
SQL_DROP_CHARACTER_SET: 0
SQL_DROP_COLLATION: 0
SQL_DROP_DOMAIN: 0
SQL_DROP_SCHEMA: 0
SQL_DROP_TABLE: 0
SQL_DROP_TRANSLATION: 0
SQL_DROP_VIEW: 0
SQL_DYNAMIC_CURSOR_ATTRIBUTES1: 0
SQL_DYNAMIC_CURSOR_ATTRIBUTES2: 0
SQL_EXPRESSIONS_IN_ORDERBY: Y
SQL_FETCH_DIRECTION: 1
SQL_FILE_USAGE: 0
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1: 0
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2: 0
SQL_GETDATA_EXTENSIONS: 15
SQL_GROUP_BY: 3
SQL_IDENTIFIER_CASE: 2
SQL_IDENTIFIER_QUOTE_CHAR: "
SQL_INFO_SCHEMA_VIEWS: 0
SQL_INSERT_STATEMENT: 0
SQL_INTEGRITY: N
SQL_KEYSET_CURSOR_ATTRIBUTES1: 0
SQL_KEYSET_CURSOR_ATTRIBUTES2: 0
SQL_KEYWORDS: BOOLEAN,COLUMNS,FLOOR,IMPORT,REAL
SQL_LIKE_ESCAPE_CLAUSE: Y
SQL_LOCK_TYPES: 0
SQL_MAX_ASYNC_CONCURRENT_STATEMENTS: 0
SQL_MAX_BINARY_LITERAL_LEN: 0
SQL_MAX_CATALOG_NAME_LEN: 255
SQL_MAX_CHAR_LITERAL_LEN: 1048576
SQL_MAX_COLUMN_NAME_LEN: 255
SQL_MAX_COLUMNS_IN_GROUP_BY: 0
SQL_MAX_COLUMNS_IN_INDEX: 0
SQL_MAX_COLUMNS_IN_ORDER_BY: 0
SQL_MAX_COLUMNS_IN_SELECT: 0
SQL_MAX_COLUMNS_IN_TABLE: 0
SQL_MAX_CONCURRENT_ACTIVITIES: 0
SQL_MAX_CURSOR_NAME_LEN: 0
SQL_MAX_DRIVER_CONNECTIONS: 0
SQL_MAX_IDENTIFIER_LEN: 0
SQL_MAX_INDEX_SIZE: 0
SQL_MAX_PROCEDURE_NAME_LEN: 0
SQL_MAX_ROW_SIZE_INCLUDES_LONG: N
SQL_MAX_ROW_SIZE: 0
SQL_MAX_SCHEMA_NAME_LEN: 255
SQL_MAX_STATEMENT_LEN: 0
SQL_MAX_TABLE_NAME_LEN: 255
SQL_MAX_TABLES_IN_SELECT: 0
SQL_MAX_USER_NAME_LEN: 0
SQL_MULTIPLE_ACTIVE_TXN: Y
SQL_MULT_RESULT_SETS: N
SQL_NEED_LONG_DATA_LEN: Y
SQL_NON_NULLABLE_COLUMNS: 1
SQL_NULL_COLLATION: 1
SQL_NUMERIC_FUNCTIONS: 16777215
SQL_ODBC_API_CONFORMANCE: 1
SQL_ODBC_INTERFACE_CONFORMANCE: 1
SQL_ODBC_SAG_CLI_CONFORMANCE: 1
SQL_ODBC_SQL_CONFORMANCE: 1
SQL_ODBC_VER: 03.52
SQL_OJ_CAPABILITIES: 0
SQL_ORDER_BY_COLUMNS_IN_SELECT: N
SQL_OUTER_JOINS: Y
SQL_PARAM_ARRAY_ROW_COUNTS: 0
SQL_PARAM_ARRAY_SELECTS: 0
SQL_POSITIONED_STATEMENTS: 4
SQL_POS_OPERATIONS: 0
SQL_PROCEDURES: N
SQL_PROCEDURE_TERM: procedure
SQL_QUOTED_IDENTIFIER_CASE: 3
SQL_ROW_UPDATES: N
SQL_SCHEMA_TERM: schema
SQL_SCHEMA_USAGE: 0
SQL_SCROLL_CONCURRENCY: 1
SQL_SCROLL_OPTIONS: 16
SQL_SEARCH_PATTERN_ESCAPE:
SQL_SERVER_NAME: MonetDB
SQL_SPECIAL_CHARACTERS: `!#$;:'<>
SQL_SQL_CONFORMANCE: 8
SQL_STATIC_CURSOR_ATTRIBUTES1: 583
SQL_STATIC_CURSOR_ATTRIBUTES2: 4096
SQL_STRING_FUNCTIONS: 456703
SQL_SUBQUERIES: 23
SQL_SYSTEM_FUNCTIONS: 7
SQL_TABLE_TERM: table
SQL_TIMEDATE_ADD_INTERVALS: 0
SQL_TIMEDATE_DIFF_INTERVALS: 0
SQL_TIMEDATE_FUNCTIONS: 131071
SQL_TXN_CAPABLE: 2
SQL_TXN_ISOLATION_OPTION: 4
SQL_UNION: 1
SQL_USER_NAME: monetdb
SQL_XOPEN_CLI_YEAR:
# 11:43:58 >
# 11:43:58 > Done.
# 11:43:58 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/odbc/samples/Tests/All,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- All 11 Jan 2007 15:12:53 -0000 1.3
+++ All 24 Jul 2007 16:30:56 -0000 1.4
@@ -1 +1,2 @@
odbcsample1
+testgetinfo
--- NEW FILE: testgetinfo.SQL.bat ---
@echo off
set PATH=%CLIENTS_PREFIX%\lib\sql\Tests;%PATH%
call Mlog.bat -x testgetinfo.exe
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
