📄 bestrowidentifier.out
字号:
ij> -- fewer cols unique con still ignored over primary keycreate table t10 (i int unique not null , j int not null , primary key (i,j));0 rows inserted/updated/deletedij> -- result: columns i,jexecute bestrow using 'values(''APP'',''T10'',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> -- fewer cols unique index still ignored over primary keycreate table t11 (i int not null, j int not null, primary key (i,j));0 rows inserted/updated/deletedij> create unique index t11i_index on t11(i);0 rows inserted/updated/deletedij> -- result: columns i,jexecute bestrow using 'values(''APP'',''T11'',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> -- fewer cols unique index still ignored over unique concreate table t12 (i int not null, j int not null, unique (i,j));0 rows inserted/updated/deletedij> create unique index t12i_index on t12(i);0 rows inserted/updated/deletedij> -- result: columns i,jexecute bestrow using 'values(''APP'',''T12'',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> -- REMIND: we aren't handling nullOk flag correctly-- we just drop nullable cols, we should skip an answer-- that has nullable cols in it instead and look for another one.create table t13 (i int not null, j int not null, k int, unique (i,j));0 rows inserted/updated/deletedij> -- result: columns i, j (WRONG) -- the correct answer is k: the non-null columns of the tableexecute bestrow using 'values(''APP'',''T13'',0,''false'')';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> -- fewest cols unique con is the one picked of severalcreate table t14 (i int not null unique, j int not null, k int, unique (i,j));0 rows inserted/updated/deletedij> -- result: columns iexecute bestrow using 'values(''APP'',''T14'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 ij> -- fewest cols unique index is the one picked of severalcreate table t15 (i int not null, j int not null, k int);0 rows inserted/updated/deletedij> create unique index t15ij on t15(i,j);0 rows inserted/updated/deletedij> create unique index t15i on t15(i);0 rows inserted/updated/deletedij> -- result: columns iexecute bestrow using 'values(''APP'',''T15'',0,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 ij> -- we don't do anything with SCOPE except detect bad valuescreate table t16 (i int not null primary key, j int);0 rows inserted/updated/deletedij> -- result: columns iexecute bestrow using 'values(''APP'',''T16'',1,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 ij> -- result: columns iexecute bestrow using 'values(''APP'',''T16'',2,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------2 |I |4 |INTEGER |4 |NULL |10 |1 ij> -- result: no rowsexecute bestrow using 'values(''APP'',''T16'',-1,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ij> -- result: no rowsexecute bestrow using 'values(''APP'',''T16'',3,''true'')';SCOPE |COLUMN_NAME |DATA_&|TYPE_NAME |COLUMN_SIZE|BUFFER_LEN&|DECIM&|PSEUD&---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ij> rollback work;ij> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -