hi
C:\!dc-db\db-sqlite-corrupt\db-uniq-bug>sqlite3 --version
3.8.5 2014-06-04 14:06:34 b1ed4f2a34ba66c29b130f8d13e9092758019212
C:\!dc-db\db-sqlite-corrupt\db-uniq-bug>sqlite3.exe FlylinkDC.sqlite
0<test-uniq-3.sql
CREATE TABLE fly_hash_block(tth_id integer PRIMARY KEY NOT NULL, tth number
NOT NULL);
INSERT INTO fly_hash_block VALUES(1,1);
INSERT INTO fly_hash_block VALUES(2,2);
INSERT INTO fly_hash_block VALUES(3,2);
*CREATE UNIQUE INDEX iu_fly_hash_block_tth ON fly_hash_block(tth);*
select * from fly_hash_block;
1|1
2|2
3|2
select *distinct* tth from fly_hash_block;
1
*22*
select tth,count(*) from fly_hash_block group by tth;
1|1
2|2
p.s. Oracle - All OK
SQL>
SQL> CREATE TABLE fly_hash_block(tth_id integer PRIMARY KEY NOT NULL, tth
number NOT NULL);
Table created
SQL> INSERT INTO fly_hash_block VALUES(1,1);
1 row inserted
SQL> INSERT INTO fly_hash_block VALUES(2,2);
1 row inserted
SQL> INSERT INTO fly_hash_block VALUES(3,2);
1 row inserted
SQL> CREATE UNIQUE INDEX iu_fly_hash_block_tth ON fly_hash_block(tth);
CREATE UNIQUE INDEX iu_fly_hash_block_tth ON fly_hash_block(tth)
*ORA-01452: CREATE UNIQUE INDEX невозможно; найдены дублирующиеся ключи*
SQL> select * from fly_hash_block;
TTH_ID TTH
--------------------------------------- ----------
1 1
2 2
3 2
SQL> select distinct tth from fly_hash_block;
TTH
----------
1
* 2*
SQL> select tth,count(*) from fly_hash_block group by tth;
TTH COUNT(*)
---------- ----------
1 1
2 2
--
~PPA() {} //
http://flylinkdc.blogspot.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
