test/cache/CacheTable/exp.test043.ksh

   1
   2 (1). cachetable -S
   3
   4 =================================================================================================================
   5 |Mode|  Table Name      |       Primary Key     |       Condition       |       Field List      |       DSN     |
   6 =================================================================================================================
   7 | 1  |              t1  |            NULL       |            NULL       |            NULL       |   myodbc3     |
   8 -----------------------------------------------------------------------------------------------------------------
   9 | 2  |              t2  |            NULL       |         t2f1=11       |            NULL       |   myodbc3     |
  10 -----------------------------------------------------------------------------------------------------------------
  11 | 4  |              t3  |            NULL       |            NULL       |            t3f1       |   myodbc3     |
  12 -----------------------------------------------------------------------------------------------------------------
  13 | 8  |              t4  |            NULL       |            NULL       |            NULL       |   myodbc3     |
  14 -----------------------------------------------------------------------------------------------------------------
  15 |14  |              t5  |            NULL       |         t5f1=11       |            t5f2       |   myodbc3     |
  16 -----------------------------------------------------------------------------------------------------------------
  17
  18 (2). cachetable -t t5 -S
  19
  20 =================================================================================================================
  21 |Mode|  Table Name      |       Primary Key     |       Condition       |       Field List      |       DSN     |
  22 =================================================================================================================
  23 |14  |              t5  |            NULL       |         t5f1=11       |            t5f2       |   myodbc3     |
  24 -----------------------------------------------------------------------------------------------------------------
  25
  26 (3). cachetable -S (Cross Verification)
  27
  28 =================================================================================================================
  29 |Mode|  Table Name      |       Primary Key     |       Condition       |       Field List      |       DSN     |
  30 =================================================================================================================
  31 |                                Cached table does not exist.                                                   |
  32 =================================================================================================================