From 04d929865346839c0c3a264aeb056cfc46a3972c Mon Sep 17 00:00:00 2001
From: kishoramballi <kishoramballi>
Date: Wed, 21 May 2008 14:08:24 +0000
Subject: [PATCH] for first test case in cache loading.

---
 test/cache/Recovery/csql.conf   | 62 +++++++++++++++++++++++++++++++++++++++++
 test/cache/Recovery/test001.ksh | 14 ++++++++++
 2 files changed, 76 insertions(+)
 create mode 100644 test/cache/Recovery/csql.conf
 create mode 100755 test/cache/Recovery/test001.ksh

diff --git a/test/cache/Recovery/csql.conf b/test/cache/Recovery/csql.conf
new file mode 100644
index 00000000..e8bf6a43
--- /dev/null
+++ b/test/cache/Recovery/csql.conf
@@ -0,0 +1,62 @@
+# CSQL System Configuration File
+
+#####################################Server Section########################
+#Important: For Server section parameters, make sure that the value is same for the 
+#           server process and all the csql client process which connects to it. otherwise, 
+#           behavior is undefined
+
+# Page size. Each database is logically divided into pages and allocation happens 
+# in this unit of pages. Increasing this value will reduce frequent allocation of pages. 
+PAGE_SIZE= 8192
+
+#Total number of client process which can connect and work with the 
+# database concurrently
+MAX_PROCS = 100
+
+# Maximum size of the system database.
+MAX_SYS_DB_SIZE=10485760
+
+#Maximum size of the user database file.
+MAX_DB_SIZE=335544320
+
+#Shared memory key to be used by the system to create and locate system database.
+SYS_DB_KEY=1199
+
+#Shared memory key to be used by the system to create and locate user database.
+USER_DB_KEY=2277
+
+#Give full path for the log file where important system actions are stored.
+LOG_FILE=/tmp/log/csql/log.out
+
+#The virtual memory start address at which the shared memory segment 
+# will be created and attached. 
+MAP_ADDRESS=400000000
+
+#Important: For Server section parameters, make sure that the value is same for the 
+#           server process and all the csql client process which connects to it. otherwise, 
+#           behavior is undefined
+#####################################Client Section########################
+
+#Mutex timeout interval seconds
+MUTEX_TIMEOUT_SECS=0
+MUTEX_TIMEOUT_USECS=5000
+MUTEX_TIMEOUT_RETRIES=10
+
+#Lock timeout interval seconds
+LOCK_TIMEOUT_SECS=0
+LOCK_TIMEOUT_USECS=5000
+LOCK_TIMEOUT_RETRIES=10
+
+#####################################Cache Section########################
+
+#Whether to enable caching of tables from target database
+CACHE_TABLE=true
+
+#DSN Name to connect to the target database.
+#This should be present in ~/odbc.ini file
+DSN=myodbc3
+
+#Give full path for the file where all the cached table information is stored
+TABLE_CONFIG_FILE=/tmp/csql/csqltable.conf
+
+#####################################End Section########################
diff --git a/test/cache/Recovery/test001.ksh b/test/cache/Recovery/test001.ksh
new file mode 100755
index 00000000..74c59796
--- /dev/null
+++ b/test/cache/Recovery/test001.ksh
@@ -0,0 +1,14 @@
+#!/bin/sh
+
+#Run this test only under csql/test or on this directory.
+#Otherwise, it may fail
+
+mv ~/.odbc.ini /tmp
+
+touch ~/.odbc.ini
+
+$CSQL_INSTALL_ROOT/bin/csqlserver -c
+
+mv /tmp/.odbc.ini ~/
+
+exit 0;
-- 
2.11.4.GIT