Re: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

[Scott Robison]

They'll be able to renew the certificate after some payments are made after
the free 6 month trial had lapsed. :)

On Dec 5, 2017 5:15 PM, "Keith Medcalf"  wrote:

>
> Uses an expired SSL certificate ...
>
>
> ---
> The fact that there's a Highway to Hell but only a Stairway to Heaven says
> a lot about anticipated traffic volume.
>
> >-Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of sub sk79
> >Sent: Tuesday, 5 December, 2017 14:48
> >To: SQLite mailing list
> >Subject: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB
> >
> >Hi All:
> >
> >The next version of StepSqlite - enhanced-PL/SQL compiler for SQLite
> >and Oracle-TM
> >BerkeleyDB
> >(https://www.metatranz.com/stepsqlite)
> >is due soon and is packed with Super Powers which will blow your
> >mind!
> >
> >For a start, how about powerful Analytic Window Functions,
> >Collections,
> >Bulk-Ops?
> >Now, if you think that is huge, wait, there is a lot more!!!
> >Look for a detailed announcement in first week of New Year 2018.
> >
> >Currently aiming for a January end beta-release after the ongoing
> >rigorous
> >testing and bug-fix cycle.
> >
> >Meanwhile you can sign-up for beta. Everyone signing up for beta -
> >till Jan
> >31, 2018, gets a professional version free for 6 months (July 31,
> >2018).
> >Those already on the list need not re-register - you are already
> >included! There
> >will always be a free developer version (size-limited ).
> >
> >Be the first to experience the power - get on the waiting list:
> >http://www.metatranz.com/stepsqlite/ShowSignUp?guestlogin=ON
> >
> >Happy New Year!!
> >
> >-SKashikar
> >(Founder)
> >__
> >**StepSqlite** enhanced-PL/SQL on Sqlite
> >and BerkeleyDB: *Be Done at the Speed of Lite!*
> >
> >Twitter: https://twitter.com/metatranz
> >Facebook: https://www.facebook.com/Metatranz/
> >___
> >sqlite-users mailing list
> >sqlite-users@mailinglists.sqlite.org
> >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cross-compiling fails.

[Joe Mistachkin]

Alastair Growcott wrote:
>
> Cross-compiling sqlite3 fails due to the use of binaries in the
> build process that are generated during the build process.
> Specifically:
>

You'll need to use the NMAKE macro XCOMPILE.  Also, depending on
target platform you may need to use the other NMAKE macros like
USE_NATIVE_LIBPATHS, NCRTLIBPATH, and NSDKLIBPATH.

For example, 
 
nmake /f Makefile.msc sqlite3.exe XCOMPILE=1 USE_NATIVE_LIBPATHS=1

Alternatively, you can build the amalgamation source code file
"sqlite3.c" without cross-compiling and then cross-compile it.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cross-compiling fails.

[Richard Hipp]

On 12/4/17, Alastair Growcott  wrote:
> Cross-compiling sqlite3 fails due to the use of binaries in the build
> process that are generated during the build process.

I recommend that you do

./configure; make sqlite3.c

or

nmake /f makefile.msc sqlite3.c

depending on whether your host system is unix or windows.  Then
manually compile the resulting sqlite3.c for your target platform.

What are the host and target systems for the build you are trying to do?

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Cross-compiling fails.

[Alastair Growcott]

Cross-compiling sqlite3 fails due to the use of binaries in the build 
process that are generated during the build process. Specifically:


    mksourceid
    lemon

The configure script explicitly offers the "--host=" option to allow 
cross-compiling. If cross-compiling is not supported then this option 
should be removed, and ideally replace with a short paragraph of text 
explaining this explicitly.


An alternative is to add steps to the build instructions explaining that 
you need to build these binaries natively first and then put them in the 
correct location - however they will probably still get over-written by 
cross-compiled versions when the cross-compile build starts so there may 
need to be additional changes made.


In addition, when cross-compiling for Windows with the MinGW toolchain, 
the code looks for the file "sys/ioctl.h" which doesn't exist for 
Windows/MinGW systems. It looks like SQLITE_OS_UNIX is being incorrectly 
defined. It doesn't look like a difficult problem to solve and if I get 
a reply I will be happy to share any solution I find.



Alastair.

--
Senior Software Engineer
H Scientific Ltd
023 9226 7607
www.h-scientific.co.uk


---
This email has been checked for viruses by AVG.
http://www.avg.com

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Emulate right-join

[Keith Medcalf]

You want a LEFT JOIN not a RIGHT JOIN (these are of course just lazy spellings 
for LEFT OUTER JOIN and RIGHT OUTER JOIN respectively), assuming that you want 
all selected rows from the table of the LEFT and only the matching values (else 
NULL) for the table(s) on the right, which is how you describe what you want to 
achieve.  Simply change the word RIGHT to LEFT.

On the other hand, X RIGHT JOIN Y can be spelled as Y LEFT JOIN X  (which may 
be spelled with the word OUTER preceding the word JOIN) if for some reason you 
really do want a right outer join (which of course means to include all rows 
from the table on the RIGHT and either NULL or the matching values from the 
table(s) on the LEFT.

To simulate a OUTER JOIN (which is an alternate spelling of FULL OUTER JOIN) 
which includes all the rows from both sides with non-matching lookups set to 
null is a wee bit (but not a lot) more complicated when all you can do is a 
LEFT JOIN.

   select EventID,
  ContactInfo,
  TicketID,
  Priority,
  PriorityText,
  CreateDate
 from Events 
left join ColorScheme 
   on ColorScheme.PriorityLevel = Events.EventID 
 order by {SomeSoftwareDefinedOrder}

---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.


>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski
>Sent: Tuesday, 5 December, 2017 14:45
>To: General Discussion of SQLite Database
>Subject: [sqlite] Emulate right-join
>
>I'm working on a pretty simplified event tracking system (So I stay
>out of
>trouble of not updating time spent throughout the day), and each item
>that
>I need to track has an associated priority with it, which ranges for
>any
>positive integer value.  This priority can be user defined as a
>positive
>integer. (FWIW, zero is bottom of the pack, while 1 is top priority -
>- Zero
>priority items are displayed at the bottom of the list, and I
>consider them
>"Undefined")
>
>Priorities 0 to 25 can have a color and title associated with it, and
>this
>information is stored in its own table.  Not all of the 26 priorities
>have
>to be defined.  The PriorityLevel is related to Priority (See below)
>but
>has no direct requirement to exist.
>
>So the question I have is how I can build the query to emulate a
>right-join?
>
>The problem encountered is that if I have an event with a priority
>99, and
>with the priority text not being in the table, my query does not
>return
>items with a priority 99.
>
>The two tables goes something along the lines of:
>
>Events
> - EventID
> - ContactInfo
> - TicketID
> - Resolved
> - Priority (Integer)
> - CreateDate
>
>ColorScheme
> - PriortyLevel (Integer)
> - FGColor
> - BGColor
> - PriorityText
>
>Notes:
>There is no direct PK/FK relation between Priority and PriorityLevel.
>The Priority is defaulted to zero when items are created.  No trigger
>exists to enforce a positive value, but my code protects that data
>info.
>If the the Priority of an Event item is defined with a value that
>does not
>exist in ColorScheme, color wise, it defaults to whatever
>PriorityLevel 0
>is defined as.
>The existing ColorScheme table is loaded into memory to toy with on a
>new
>UI form, then on submit, the real table is dumped and repopulated.
>If the user changes the Priority in the Events table, and there is no
>PriorityLevel in ColorScheme that matches, the color scheme is
>defaulted/assumed to be 0 in the application, only for coloring
>purposes,
>but, retains the priority level.
>On the submission of the color schemes, priority zero is force-
>created,
>meaning that if the user deletes priority 0, the software will add a
>default values to the ColorScheme table.
>
>The query I'm attempting to run is something along the lines of:
>(Untested)
>Select EventID,ContactInfo,TicketID,Priority,CreateDate from Events
>order
>by {SomeSoftwareDefinedOrder}
>
>What I want to do is essentially:
>select EventID,ContactInfo,TicketID,Priority,PriorityText,CreateDate
>from
>Events *RIGHT JOIN* ColorScheme on ColorScheme.PriorityLevel =
>Events.EventID order by {SomeSoftwareDefinedOrder}
>
>What this did in MSSQL2000 days, if I remember correctly, give me all
>results in the Events table even if the relevant info isn't in
>ColorScheme
>table.  The PriorityLevel and PriorityText would be returned as NULL.
>
>Does anyone have any working theories on how I can get ALL results in
>the
>Events table regardless if the Events.Priority isn't in
>ColorScheme.PriorityLevel?
>___
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

[sub sk79]

Thanks for bringing that to my attention. The website is under renovation
as well. Hope to have it fixed soon.

Regards,
SKashikar

On Tue, Dec 5, 2017 at 7:15 PM, Keith Medcalf  wrote:

>
> Uses an expired SSL certificate ...
>
>
> ---
> The fact that there's a Highway to Hell but only a Stairway to Heaven says
> a lot about anticipated traffic volume.
>
> >-Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of sub sk79
> >Sent: Tuesday, 5 December, 2017 14:48
> >To: SQLite mailing list
> >Subject: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB
> >
> >Hi All:
> >
> >The next version of StepSqlite - enhanced-PL/SQL compiler for SQLite
> >and Oracle-TM
> >BerkeleyDB
> >(https://www.metatranz.com/stepsqlite)
> >is due soon and is packed with Super Powers which will blow your
> >mind!
> >
> >For a start, how about powerful Analytic Window Functions,
> >Collections,
> >Bulk-Ops?
> >Now, if you think that is huge, wait, there is a lot more!!!
> >Look for a detailed announcement in first week of New Year 2018.
> >
> >Currently aiming for a January end beta-release after the ongoing
> >rigorous
> >testing and bug-fix cycle.
> >
> >Meanwhile you can sign-up for beta. Everyone signing up for beta -
> >till Jan
> >31, 2018, gets a professional version free for 6 months (July 31,
> >2018).
> >Those already on the list need not re-register - you are already
> >included! There
> >will always be a free developer version (size-limited ).
> >
> >Be the first to experience the power - get on the waiting list:
> >http://www.metatranz.com/stepsqlite/ShowSignUp?guestlogin=ON
> >
> >Happy New Year!!
> >
> >-SKashikar
> >(Founder)
> >__
> >**StepSqlite** enhanced-PL/SQL on Sqlite
> >and BerkeleyDB: *Be Done at the Speed of Lite!*
> >
> >Twitter: https://twitter.com/metatranz
> >Facebook: https://www.facebook.com/Metatranz/
> >___
> >sqlite-users mailing list
> >sqlite-users@mailinglists.sqlite.org
> >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

[Keith Medcalf]

Uses an expired SSL certificate ...


---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.

>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of sub sk79
>Sent: Tuesday, 5 December, 2017 14:48
>To: SQLite mailing list
>Subject: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB
>
>Hi All:
>
>The next version of StepSqlite - enhanced-PL/SQL compiler for SQLite
>and Oracle-TM
>BerkeleyDB
>(https://www.metatranz.com/stepsqlite)
>is due soon and is packed with Super Powers which will blow your
>mind!
>
>For a start, how about powerful Analytic Window Functions,
>Collections,
>Bulk-Ops?
>Now, if you think that is huge, wait, there is a lot more!!!
>Look for a detailed announcement in first week of New Year 2018.
>
>Currently aiming for a January end beta-release after the ongoing
>rigorous
>testing and bug-fix cycle.
>
>Meanwhile you can sign-up for beta. Everyone signing up for beta -
>till Jan
>31, 2018, gets a professional version free for 6 months (July 31,
>2018).
>Those already on the list need not re-register - you are already
>included! There
>will always be a free developer version (size-limited ).
>
>Be the first to experience the power - get on the waiting list:
>http://www.metatranz.com/stepsqlite/ShowSignUp?guestlogin=ON
>
>Happy New Year!!
>
>-SKashikar
>(Founder)
>__
>**StepSqlite** enhanced-PL/SQL on Sqlite
>and BerkeleyDB: *Be Done at the Speed of Lite!*
>
>Twitter: https://twitter.com/metatranz
>Facebook: https://www.facebook.com/Metatranz/
>___
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Emulate right-join

[John McKown]

On Tue, Dec 5, 2017 at 3:44 PM, Stephen Chrzanowski 
wrote:

> I'm working on a pretty simplified event tracking system (So I stay out of
> trouble of not updating time spent throughout the day), and each item that
> I need to track has an associated priority with it, which ranges for any
> positive integer value.  This priority can be user defined as a positive
> integer. (FWIW, zero is bottom of the pack, while 1 is top priority -- Zero
> priority items are displayed at the bottom of the list, and I consider them
> "Undefined")
>
> Priorities 0 to 25 can have a color and title associated with it, and this
> information is stored in its own table.  Not all of the 26 priorities have
> to be defined.  The PriorityLevel is related to Priority (See below) but
> has no direct requirement to exist.
>
> So the question I have is how I can build the query to emulate a
> right-join?
>

​Why not just use a RIGHT JOIN? PostgreSQL supports it. On page
https://www.postgresql.org/docs/current/static/sql-select.html



*join_type*

One of

   -

   [ INNER ] JOIN
   -

   LEFT [ OUTER ] JOIN
   -

   RIGHT [ OUTER ] JOIN
   -

   FULL [ OUTER ] JOIN
   -

   CROSS JOIN

For the INNER and OUTER join types, a join condition must be specified,
namely exactly one of NATURAL, ON *join_condition*, or USING (*join_column* [,
...]). See below for the meaning. For CROSS JOIN, none of these clauses can
appear.

A JOIN clause combines two FROM items, which for convenience we will refer
to as “tables”, though in reality they can be any type of FROM item. Use
parentheses if necessary to determine the order of nesting. In the absence
of parentheses, JOINs nest left-to-right. In any case JOIN binds more
tightly than the commas separating FROM-list items.

CROSS JOIN and INNER JOIN produce a simple Cartesian product, the same
result as you get from listing the two tables at the top level of FROM, but
restricted by the join condition (if any). CROSS JOIN is equivalent to INNER
JOIN ON (TRUE), that is, no rows are removed by qualification. These join
types are just a notational convenience, since they do nothing you couldn't
do with plain FROM and WHERE.

LEFT OUTER JOIN returns all rows in the qualified Cartesian product (i.e.,
all combined rows that pass its join condition), plus one copy of each row
in the left-hand table for which there was no right-hand row that passed
the join condition. This left-hand row is extended to the full width of the
joined table by inserting null values for the right-hand columns. Note that
only the JOIN clause's own condition is considered while deciding which
rows have matches. Outer conditions are applied afterwards.

Conversely, RIGHT OUTER JOIN returns all the joined rows, plus one row for
each unmatched right-hand row (extended with nulls on the left). This is
just a notational convenience, since you could convert it to a LEFT OUTER
JOIN by switching the left and right tables.

FULL OUTER JOIN returns all the joined rows, plus one row for each
unmatched left-hand row (extended with nulls on the right), plus one row
for each unmatched right-hand row (extended with nulls on the left).
ON *join_condition*

​



>
> The problem encountered is that if I have an event with a priority 99, and
> with the priority text not being in the table, my query does not return
> items with a priority 99.
>
> The two tables goes something along the lines of:
>
> Events
>  - EventID
>  - ContactInfo
>  - TicketID
>  - Resolved
>  - Priority (Integer)
>  - CreateDate
>
> ColorScheme
>  - PriortyLevel (Integer)
>  - FGColor
>  - BGColor
>  - PriorityText
>
> Notes:
> There is no direct PK/FK relation between Priority and PriorityLevel.
> The Priority is defaulted to zero when items are created.  No trigger
> exists to enforce a positive value, but my code protects that data info.
> If the the Priority of an Event item is defined with a value that does not
> exist in ColorScheme, color wise, it defaults to whatever PriorityLevel 0
> is defined as.
> The existing ColorScheme table is loaded into memory to toy with on a new
> UI form, then on submit, the real table is dumped and repopulated.
> If the user changes the Priority in the Events table, and there is no
> PriorityLevel in ColorScheme that matches, the color scheme is
> defaulted/assumed to be 0 in the application, only for coloring purposes,
> but, retains the priority level.
> On the submission of the color schemes, priority zero is force-created,
> meaning that if the user deletes priority 0, the software will add a
> default values to the ColorScheme table.
>
> The query I'm attempting to run is something along the lines of: (Untested)
> Select EventID,ContactInfo,TicketID,Priority,CreateDate from Events order
> by {SomeSoftwareDefinedOrder}
>
> What I want to do is essentially:
> select EventID,ContactInfo,TicketID,Priority,PriorityText,CreateDate from
> Events *RIGHT JOIN* ColorScheme on ColorScheme.PriorityLevel =
> Events.EventID 

[sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

[sub sk79]

Hi All:

The next version of StepSqlite - enhanced-PL/SQL compiler for SQLite
and Oracle-TM
BerkeleyDB
(https://www.metatranz.com/stepsqlite)
is due soon and is packed with Super Powers which will blow your mind!

For a start, how about powerful Analytic Window Functions, Collections,
Bulk-Ops?
Now, if you think that is huge, wait, there is a lot more!!!
Look for a detailed announcement in first week of New Year 2018.

Currently aiming for a January end beta-release after the ongoing rigorous
testing and bug-fix cycle.

Meanwhile you can sign-up for beta. Everyone signing up for beta - till Jan
31, 2018, gets a professional version free for 6 months (July 31, 2018).
Those already on the list need not re-register - you are already
included! There
will always be a free developer version (size-limited ).

Be the first to experience the power - get on the waiting list:
http://www.metatranz.com/stepsqlite/ShowSignUp?guestlogin=ON

Happy New Year!!

-SKashikar
(Founder)
__
**StepSqlite** enhanced-PL/SQL on Sqlite
and BerkeleyDB: *Be Done at the Speed of Lite!*

Twitter: https://twitter.com/metatranz
Facebook: https://www.facebook.com/Metatranz/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Emulate right-join

[Stephen Chrzanowski]

I'm working on a pretty simplified event tracking system (So I stay out of
trouble of not updating time spent throughout the day), and each item that
I need to track has an associated priority with it, which ranges for any
positive integer value.  This priority can be user defined as a positive
integer. (FWIW, zero is bottom of the pack, while 1 is top priority -- Zero
priority items are displayed at the bottom of the list, and I consider them
"Undefined")

Priorities 0 to 25 can have a color and title associated with it, and this
information is stored in its own table.  Not all of the 26 priorities have
to be defined.  The PriorityLevel is related to Priority (See below) but
has no direct requirement to exist.

So the question I have is how I can build the query to emulate a right-join?

The problem encountered is that if I have an event with a priority 99, and
with the priority text not being in the table, my query does not return
items with a priority 99.

The two tables goes something along the lines of:

Events
 - EventID
 - ContactInfo
 - TicketID
 - Resolved
 - Priority (Integer)
 - CreateDate

ColorScheme
 - PriortyLevel (Integer)
 - FGColor
 - BGColor
 - PriorityText

Notes:
There is no direct PK/FK relation between Priority and PriorityLevel.
The Priority is defaulted to zero when items are created.  No trigger
exists to enforce a positive value, but my code protects that data info.
If the the Priority of an Event item is defined with a value that does not
exist in ColorScheme, color wise, it defaults to whatever PriorityLevel 0
is defined as.
The existing ColorScheme table is loaded into memory to toy with on a new
UI form, then on submit, the real table is dumped and repopulated.
If the user changes the Priority in the Events table, and there is no
PriorityLevel in ColorScheme that matches, the color scheme is
defaulted/assumed to be 0 in the application, only for coloring purposes,
but, retains the priority level.
On the submission of the color schemes, priority zero is force-created,
meaning that if the user deletes priority 0, the software will add a
default values to the ColorScheme table.

The query I'm attempting to run is something along the lines of: (Untested)
Select EventID,ContactInfo,TicketID,Priority,CreateDate from Events order
by {SomeSoftwareDefinedOrder}

What I want to do is essentially:
select EventID,ContactInfo,TicketID,Priority,PriorityText,CreateDate from
Events *RIGHT JOIN* ColorScheme on ColorScheme.PriorityLevel =
Events.EventID order by {SomeSoftwareDefinedOrder}

What this did in MSSQL2000 days, if I remember correctly, give me all
results in the Events table even if the relevant info isn't in ColorScheme
table.  The PriorityLevel and PriorityText would be returned as NULL.

Does anyone have any working theories on how I can get ALL results in the
Events table regardless if the Events.Priority isn't in
ColorScheme.PriorityLevel?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Re: Possible User Defined Function (UDF) Bug?

[Richard Hipp]

On 12/5/17, no...@null.net  wrote:
> On Tue Nov 28, 2017 at 03:30:54PM +, David Raymond wrote:
>
> SQLite developers, do you recognise this thread as an issue?

Not a serious issue, no.  I might look into it when I have time, but
I'm neck-deep in other issues at the moment.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Re: Possible User Defined Function (UDF) Bug?

[nomad]

On Tue Nov 28, 2017 at 03:30:54PM +, David Raymond wrote:
> With an integer primary key, not just any primary key. Probably
> something to do with the deterministic flag as well. Looks like in
> checking if it's gonna be a good integer for a rowid it calls it
> twice. Below you can see where random() gets called twice, so what
> the before trigger inserts into another table is different than what
> gets put into the original table. If you have a deterministic
> function like abs() it just calls it once, or if you have a
> non-integer-primary-key table it just calls it once.
> 
> 
> sqlite> create table d (id integer primary key);
> 
> sqlite> create table d2 (id int primary key);
> 
> sqlite> create table t (tableName text, id int);
> 
> sqlite> create trigger bi_d before insert on d begin insert into t values 
> ('d', new.id); end;
> 
> sqlite> create trigger bi_d2 before insert on d2 begin insert into t values 
> ('d2', new.id); end;
> 
> sqlite> insert into d values (random());
> 
> sqlite> insert into d2 values (random());
> 
> sqlite> select * from t;
> tableName|id
> d|-5810358455625904630
> d2|-3456845157187719103
> 
> sqlite> select * from d;
> id
> 6606271909038536929
> 
> sqlite> select * from d2;
> id
> -3456845157187719103

That looks like a good test case to me. This is certainly a regression
as earlier versions of SQLite don't show the same behaviour.

SQLite developers, do you recognise this thread as an issue? I've seen
other topics come and go and be fixed in the meantime, but no statement
on this one.

-- 
Mark Lawrence
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compile Error: SQLITE_ENABLE_MULTITHREADED_CHECKS and SQLITE_ENABLE_API_ARMOR defined concurrently

[Dan Kennedy]

On 12/02/2017 11:59 PM, Keith Medcalf wrote:

Both are fine when either is defined independently (or neither is defined) but 
when both are defined concurrently there are compiler errors in function 
checkMutexFree:

sqlite3x.c: In function 'checkMutexFree':
sqlite3x.c:23521:8: error: dereferencing pointer to incomplete type 
'sqlite3_mutex {aka struct sqlite3_mutex}'
if( p->iType<2 ){
 ^~
sqlite3x.c:23529:3: error: expected '}' before 'else'
else{
^~~~

** Note:  The line numbers are not the same as those in the default 
amalgamation due to local changes.  However, the function checkMutexFree is not 
changed from the default.


Thanks for reporting this. Now fixed here:

  http://www.sqlite.org/src/info/0342ce510d2063a6

Dan.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot initialize statically linked extension

[Steve Harrill]

Get me off of this list 

Sent from my iPhone

On Dec 5, 2017, at 04:48, Lifepillar  wrote:

On 05/12/2017 09:24, Guy Harris wrote:
> On Dec 4, 2017, at 3:42 PM, Keith Medcalf  wrote:
>
>> On Monday, 4 December, 2017 15:44, Jens Alfke  wrote:
>>
 If one object is using, for example, the multithreaded runtime and
 the others are using the single threaded runtime (for example), and
 the third perhaps the subsystem runtime
>>
>>>  From the OP’s other thread here it looks like they’re developing
>>>  for iOS or macOS, neither of which have the sorts of multiple
>>>  runtimes you’re talking about (is that a Windows thing?)
>>
>> I had believed it was Windows since "DLL" was mentioned
>
> No, the original message said
>
>> Btw, if I build my extension as a dynamic library and load it
>> in a SQLite shell, all is fine.
>
> which says "dynamic library", rather than "DLL"; the term "dynamic" is
> used with most UN*X implementations of shared libraries (and the file
> suffix used for shared libraries on Darwin-based systems such as macOS
> and iOS is ".dylib").
>
>> and that is a Windows (or OS/2) contraction for dynamic load library.
>> I don't think anything else uses that term in quite the same way.
>
> The initialism "DLL" is a sign that the system being discussed is
> almost certainly Windows.  The word "dynamic", however, isn't - it may
> even be a sign that it's a UN*X, as they probably would have said
> "DLL" were it Windows.

My fault, I should have mentioned my platform's details. As already
pointed out, I'm on macOS, and, specifically, I'm building my project
with Xcode.

On Dec 4, 2017, at 11:59 AM, Keith Medcalf  wrote:
>>
>> You should only be defining SQLITE_CORE if in fact the extension is
>> part of the core -- that is compiled and included (statically linked)
>> to the core sqlite3.c compilation unit.
>
> Which it is, in this case. The OP said that both sqlite and the
> extension are static libraries, so they’re both being linked directly
> into the executable.
>
> I’m not sure what’s going on. Life, can you post a backtrace of the
> crash?

I'll try to make a minimal reproducible example. For now, I have fixed
my issue by linking my extension to the sqlite library rather than to my
executable.

Life.


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot initialize statically linked extension

[Lifepillar]

 > Which it is, in this case. The OP said that both sqlite and th
 > extension are static libraries, so they’re both being linked directly
 > into the executable.
 >
 > I’m not sure what’s going on. Life, can you post a backtrace of the
 > crash?

I'll try to make a minimal reproducible example. For now, I have fixed
my issue by linking my extension to the sqlite library rather than to my
executable.


So, it is most likely a bug in Xcode :/

Probably most of you don't care, but I will describe it just for future
reference.

The issue is related to the fact that I have two targets to build my
extension as a static library and as a dynamic library, respectively.

For some reason that goes beyond my understanding, if the .dylib exists,
my main target picks it up instead of the static library, although I
have explicitly declared only the static library as a dependency, and
even if "Find implicit dependencies" is unchecked. If I remove the
.dylib file, then the main target correctly links to the static library.

Interestingly, I have this issue only with the Debug configuration: if I
build in Release mode, everything builds and runs as expected. Even more
interestingly, if I build in Debug mode, but from the command line,
everything builds and runs as expected (even when the .dylib is there).

What can I say? After the "login as root without password" bug, I should
expect anything... Anyway, your comments helped me narrowing down the
problem.

Sorry for the noise guys!
Life.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot initialize statically linked extension

[Lifepillar]

On 05/12/2017 09:24, Guy Harris wrote:
> On Dec 4, 2017, at 3:42 PM, Keith Medcalf  wrote:
>
>> On Monday, 4 December, 2017 15:44, Jens Alfke  
wrote:

>>
 If one object is using, for example, the multithreaded runtime and
 the others are using the single threaded runtime (for example), and
 the third perhaps the subsystem runtime
>>
>>>  From the OP’s other thread here it looks like they’re developing
>>>  for iOS or macOS, neither of which have the sorts of multiple
>>>  runtimes you’re talking about (is that a Windows thing?)
>>
>> I had believed it was Windows since "DLL" was mentioned
>
> No, the original message said
>
>> Btw, if I build my extension as a dynamic library and load it
>> in a SQLite shell, all is fine.
>
> which says "dynamic library", rather than "DLL"; the term "dynamic" is
> used with most UN*X implementations of shared libraries (and the file
> suffix used for shared libraries on Darwin-based systems such as macOS
> and iOS is ".dylib").
>
>> and that is a Windows (or OS/2) contraction for dynamic load library.
>> I don't think anything else uses that term in quite the same way.
>
> The initialism "DLL" is a sign that the system being discussed is
> almost certainly Windows.  The word "dynamic", however, isn't - it may
> even be a sign that it's a UN*X, as they probably would have said
> "DLL" were it Windows.

My fault, I should have mentioned my platform's details. As already
pointed out, I'm on macOS, and, specifically, I'm building my project
with Xcode.

On Dec 4, 2017, at 11:59 AM, Keith Medcalf  wrote:
>>
>> You should only be defining SQLITE_CORE if in fact the extension is
>> part of the core -- that is compiled and included (statically linked)
>> to the core sqlite3.c compilation unit.
>
> Which it is, in this case. The OP said that both sqlite and the
> extension are static libraries, so they’re both being linked directly
> into the executable.
>
> I’m not sure what’s going on. Life, can you post a backtrace of the
> crash?

I'll try to make a minimal reproducible example. For now, I have fixed
my issue by linking my extension to the sqlite library rather than to my
executable.

Life.


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot initialize statically linked extension

[Guy Harris]

On Dec 4, 2017, at 3:42 PM, Keith Medcalf  wrote:

> On Monday, 4 December, 2017 15:44, Jens Alfke  wrote:
> 
>>> If one object is using, for example, the multithreaded runtime and
>>> the others are using the single threaded runtime (for example), and
>>> the third perhaps the subsystem runtime
> 
>> From the OP’s other thread here it looks like they’re developing for
>> iOS or macOS, neither of which have the sorts of multiple runtimes
>> you’re talking about (is that a Windows thing?)
> 
> I had believed it was Windows since "DLL" was mentioned

No, the original message said

> Btw, if I build my extension as a dynamic library and load it
> in a SQLite shell, all is fine.

which says "dynamic library", rather than "DLL"; the term "dynamic" is used 
with most UN*X implementations of shared libraries (and the file suffix used 
for shared libraries on Darwin-based systems such as macOS and iOS is ".dylib").

> and that is a Windows (or OS/2) contraction for dynamic load library.  I 
> don't think anything else uses that term in quite the same way.

The initialism "DLL" is a sign that the system being discussed is almost 
certainly Windows.  The word "dynamic", however, isn't - it may even be a sign 
that it's a UN*X, as they probably would have said "DLL" were it Windows.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users