-- Trying to demonstrate the bug with timestamp as primary key in a
-- connection from LibreOffice via ODBC to a SQLite databse.  (This
-- is the first bug reported in bug 47520.)

drop table byNr ;
drop table byTs ;

-- The bug report says *all* fields defined as NOT NULL PRIMARY KEY,
-- but I have seen the problem otherwise.  For now, trying with a
-- primary key of just one field.


create table byNr (
    nr   integer   not null primary key ,
    ts   timestamp not null ,
    word char (10)
) ;

insert into byNr values( 1 , '2012-04-06 12:34:56.654321', 'Friday'   ) ;
insert into byNr values( 2 , '2012-04-05 13:45:57.123456', 'Thursday' ) ;


create table byTs (
    nr   integer   not null ,
    ts   timestamp not null primary key ,
    word char (10)
) ;

insert into byTs select * from byNr ;