Subject: Re: sqlite_fdw crashes & errors
To: Andrew Gierth <andrew@tao11.riddles.org.uk>,
 Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
References: 
 <CA+t6e1kzja9ats3yLtLYo4jY52h-cNiMxt7zyEgQixHx=vazKQ@mail.gmail.com>
 <534fa6d9-4541-bb7d-a26c-3c021690cc4b@catalyst.net.nz>
 <CA+t6e1njA-BnjqDeAJ9gdzhhfFYhBtKsfnxceFh0BLphM=yonw@mail.gmail.com>
 <3e05aedb-987b-29aa-bb5e-e89bfd372834@catalyst.net.nz>
 <CA+t6e1=h+814eAbv=1Etq_EZ-4PhKF+3cJpi+m3ZUOAU6aGpFw@mail.gmail.com>
 <170c1a6b-651a-4ae8-6ea3-4ce1ab54275f@catalyst.net.nz>
 <CA+t6e1=PHY0S9h6mvPn6A6EFn7trUsq3+uvcx9=JfqzkthesZA@mail.gmail.com>
 <CA+t6e1kAW1wzH_ogge9E3e0yG8feM092Oh5bKjig+u3irp6nkw@mail.gmail.com>
 <CA+t6e1=hiby+-PG1gY3MwEmu9PvTQGztURej-wZuZ=iJ0HhCqg@mail.gmail.com>
 <87sh27hrxj.fsf@news-spur.riddles.org.uk>
 <CA+t6e1kZNsdLw6bRhhzKrjDsr784sES_FErb-5dXhi5EJKoD7Q@mail.gmail.com>
 <87k1njhqxp.fsf@news-spur.riddles.org.uk>
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Openpgp: preference=signencrypt
Autocrypt: addr=mark.kirkwood@catalyst.net.nz; prefer-encrypt=mutual; keydata=
 xsDiBEifoLIRBADnzz1YAQxN+ajn3XhoyTWmp4hHTE05y1Ai0Hf4Et6HYohOw14eFzpzgEpd
 nbtxbs/FDprNC1d2dJ+J67qLzwKW6k95xekMWVtBQJ+tm7W9GPQ/wSSeOiya2tUO7TnjiS4H
 V0U0A2v6iiNDhUBpEiLQ3/09cXdJ3QuDQPP12gRFSwCgj+y/4HHUQeuQI6KYTZ6ynHYQrK8D
 /jYSakbQohDv/z9Z+PC4tgKugbkSumQC3q8G99z4idl1jEIAexJi89lAjrrVq1/WqdUqh0in
 ptsmh5Hk6eM24hqV36dYsvcYoDm3phAPIvEVYXwU9TPeqmxy46obUYpqymWl/EtZN9lIDqwU
 fS1SC9naB7Z1b03aAuvEXJwAdWg6BACp6SIWWvFc6ESdzkQ/5FtvHvq1grDa95y9Dzw9MBj+
 YvWSxBYJo38oqidBGhUsvAAAl5Xw82bbYIQGuw0UgYjg9z8sUapZiNp+Le+gP6DDc7Jyw51b
 eVKTDRjc/GH6hLINlEyWlW3jwUVEKLwZNpOcGTTgfwvPITpM8+1sqQ6egM0tTWFyayBLaXJr
 d29vZCA8bWFyay5raXJrd29vZEBjYXRhbHlzdC5uZXQubno+wmAEExECACAFAkifoLICGwMG
 CwkIBwMCBBUCCAMEFgIDAQIeAQIXgAAKCRCn/vj7UjxSJvn3AKCKsXwnda7/3zTYe01FRRnk
 GltvIQCcD+5qpmZ4AzvfcsFqZ1rw/reu9YXOwU0ESJ+guRAIANEGLgCM28cWn1rg28ZpY4bC
 xUY/DMoQMyG+3oJW5vDYOi9BYdIsH+a3mRk/ElG4r9vlWrSQQwAuDayVH30RuBJU2xHKOx2d
 u22W54SU7Y+fOZS8IUfffgqnKGPkPucM5eLHIiQ33kiNUl7Ho0kDli3rfe5Jyz2tZGP3FB5s
 0u0v23wu7RltzgsFkxhI5kiPBBI0CVdr4w3s1gJM7id7TL8je8IOw/R+VadMn8Us9V9Hr4Yc
 iXhEwtkT3A9RA6ZZee3E3N09ZKjh3dxID2PMRxKPEUAuOELmVzpA77z0Sz6sZXtJgNLLvIjB
 iYvpZscbAGf5fjB8eBn1Kmmzow+tFy8AAwUH/ArPiMQquxtsmFUqMef5k80j66+/mDEbt9xV
 rz1MvXZ5NH4KVMUmgXlRN4yIOVyh/mMjiJ+DEBK/Tp4mcgQqhst2D0p/lvd3/QxtVGWts73y
 IAhRhWvq4jCC6Oy7IDrjRbnO0GEpumiMiT2kko1MCpXwBuJlKUxjlmlwEsKv2fbIsuGlES1u
 /QrLAk1ePfh5VDyKM5z+WT3GMDolrabehI8q5f0ZWPmN63Me6IM6Oqf5kYuRH0gwAauO3/bF
 6NjNsQvM6lm0MbcOzSBNdH/Aru6QPbhscArMUx2opn7gkYg8wCN+Bd1Se1dQTtAcDrEBmR5i
 aoCbEZYkCqVAJF/C5j7CSQQYEQIACQUCSJ+guQIbDAAKCRCn/vj7UjxSJn5/AJ4hzPttJ18v
 gOljiFMBvwIk2HIMTQCfYMk+dS/ixjmPGZ55dk9MNuaLSYQ=
Message-ID: <63820e86-991e-fa2e-4e1c-4596aae14fb7@catalyst.net.nz>
Date: Wed, 19 Sep 2018 11:02:07 +1200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <87k1njhqxp.fsf@news-spur.riddles.org.uk>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Content-Language: en-GB
Precedence: bulk

On 19/09/18 01:33, Andrew Gierth wrote:
>>>>>> "Mariel" == Mariel Cherkassky <mariel.cherkassky@gmail.com> writes:
>  Mariel> So, how exactly it works for other people ? Shouldnt everyone
>  Mariel> who use this extension should have suffered from this bug ? And
>  Mariel> why for selects it works fine ?
>
> The bug is in error reporting, so it kicks in only when an error occurs
> and then only when a null value for the sql text is passed to the
> reporting function.
>
Ah right - I guess I was not tickling the bug correctly:

$ chmod 444 sqlite/test.db
$

$ psql

=#  insert into MARIEL_TEST_foreign values(4,1,1);
ERROR:  failed to execute remote SQL: rc=1 SQL logic error
   sql=INSERT INTO main."MARIEL_TEST"("cola", "colb", "colc") VALUES (?,
?, ?)

regards

Mark