cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create (1,0) index on IX2 (number , string);
select tab_name , tab_index from sys_tables where tab_name = "IX2";
insert into IX2 values (1,"one",null,null,2,"two","aa bb cc dd ee ff 11 22 33 44 55 66 77","29 January 1969",3,"three","aa bb cc dd ee ff 11 22 33 44 55 66 77","29 January 1969",4,"four",null,null);
insert into IX2 values (3,"three",null,null);
create (1,0) index on IX2 (bytes , calendar);
select tab_name , tab_index from sys_tables where tab_name = "IX2";
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * tab_name                          tab_index

IX2                               2 1 '' 1 0 'number'
                                  'string'
* * 
*** Error: duplicate value for attribute '(combination)'
* 
*** Error: cannot index on variable length attribute 'bytes'
* tab_name                          tab_index

IX2                               2 1 '' 1 0 'number'
                                  'string'
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Check index integrity with different data types
- char , bulk , date , integer
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * tab_name                          tab_index

IX2                               2 1 '' 1 0 'number'
                                  'string'
* * 
*** Error: ȥӥ塼 '(combination)' ͤϴ¸ߤޤ
* 
*** Error: Ĺȥӥ塼 'bytes' ˥ǥåϺǤޤ
* tab_name                          tab_index

IX2                               2 1 '' 1 0 'number'
                                  'string'
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
