📄 bestrowidentifier.out
字号:
ij> ---- test java.sql.Connection.DatabaseMetaData.getBestRowIdentifier()---- create a java procedure to do the metadata callcreate procedure getBestRowID(in schema_param Char(10), in tableName_param Char(10), in scope_param int, in nullable_param Char(5)) parameter style java reads sql data dynamic result sets 1 language java external name 'org.apache.derbyTesting.functionTests.util.metadataHelperProcs.getBestRowId';0 rows inserted/updated/deletedij> prepare bestrow as 'call getBestRowID(?,?,?,?)';ij> autocommit off;ij> -- each one of these have only one choicecreate table t1 (i int not null primary key, j int);0 rows inserted/updated/deletedij> create table t2 (i int not null unique, j int);0 rows inserted/updated/deletedij> -- adding not null unique to j - otherwise t2 & t3 would be same.create table t3 (i int not null unique, j int not null unique);0 rows inserted/updated/deletedij> create table t4 (i int, j int);0 rows inserted/updated/deletedij> create unique index t4i on t4(i);0 rows inserted/updated/deletedij> create table t5 (i int, j int);0 rows inserted/updated/deletedij> -- result: column iexecute bestrow using 'values(''APP'',''T1'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 ij> -- result: column iexecute bestrow using 'values(''APP'',''T2'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 ij> -- result: column iexecute bestrow using 'values(''APP'',''T3'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |J |4 |INTEGER |4 |NULL |10 |1 ij> -- result: column iexecute bestrow using 'values(''APP'',''T4'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 ij> -- result: columns i and jexecute bestrow using 'values(''APP'',''T5'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 2 |J |4 |INTEGER |4 |NULL |10 |1 ij> rollback work;ij> -- PK preferred to uniquecreate table t6 (i int not null unique, j int not null primary key);0 rows inserted/updated/deletedij> -- result: column jexecute bestrow using 'values(''APP'',''T6'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |J |4 |INTEGER |4 |NULL |10 |1 ij> -- PK preferred to unique indexcreate table t7 (i int not null, j int not null primary key);0 rows inserted/updated/deletedij> create unique index t7i_index on t7(i);0 rows inserted/updated/deletedij> -- result: column jexecute bestrow using 'values(''APP'',''T7'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |J |4 |INTEGER |4 |NULL |10 |1 ij> -- unique con preferred to unique indexcreate table t8 (i int not null, j int not null unique);0 rows inserted/updated/deletedij> create unique index t8i_index on t8(i);0 rows inserted/updated/deletedij> -- result: column jexecute bestrow using 'values(''APP'',''T8'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |J |4 |INTEGER |4 |NULL |10 |1 ij> -- non-unique index just ignoredcreate table t9 (i int, j int);0 rows inserted/updated/deletedij> create index t9i_index on t9(i);0 rows inserted/updated/deletedij> -- result: columns i,jexecute bestrow using 'values(''APP'',''T9'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 2 |J |4 |INTEGER |4 |NULL |10 |1 ij> rollback work;⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -