Sybase ASE 15.5：成功插入无效 [英] Sybase ASE 15.5 : a successful insert which has no effect

问题描述

我正试图在一个很大的表（4亿行）中插入一行。该表具有3列（整数，varchar（128），varchar（255）），主键和聚集索引在第（1,2）列上使用非聚集索引在第（3,3）列上使用非聚集索引。没有外键，没有触发器。

I'm trying to insert a row into a table which is quite big (400 million rows). The table has 3 columns (integer, varchar(128),varchar(255)), primary key and clustered index on columns (1,2) and nonclustered index on columns (2,1) and nonclustered index on column 3. No foreign keys, no triggers.

当我这样做时：

insert into mytable values (0,'test_name','test_val')

执行成功但没有效果，没有插入任何内容，我可以成功执行多次，但它应该显示重复密钥。

It executes successfully but it has no effect, nothing is inserted and I can re-execute it as many times as I want successfully whereas it should say "duplicate key".

可能是什么问题？

注意：noexec已关闭，手动提交不会更改任何内容。

Note : noexec is off and manual commit does not change anything.

推荐答案

您可能拥有 ignore_dup_key 选项。检查 sp_help 过程的结果，以查看用于索引的所有选项。

You probably have the ignore_dup_key option on one of the indexes. Check the results of sp_help procedure to see all the options that you are using for indexes.

这篇关于Sybase ASE 15.5：成功插入无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！