Bugzilla – Attachment 59688 Details for
Bug 47520
ODBC with sqliteodbc: primary key field mostly empty, broken scolling
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
sql statements setting up demonstration SQLite3 database
init.sql (text/plain), 809 bytes, created by
Terrence Enger
on 2012-04-09 11:54:08 UTC
(
hide
)
Description:
sql statements setting up demonstration SQLite3 database
Filename:
MIME Type:
Creator:
Terrence Enger
Created:
2012-04-09 11:54:08 UTC
Size:
809 bytes
patch
obsolete
>-- 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 ;
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=59688">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 47520
: 59688 |
59689
|
59690
|
59691
|
59692
|
60314