Version:
3.8.7.1 2014-10-29 13:59:56 3b7b72c4685aa5cf5e675c2c47ebec10d9704221

I added a single line to my .sqliterc file to load pcre like so:
.load /usr/lib/sqlite3/pcre.so

Now there's annoying output on ever run:

$ sqlite3 test.db .schema
-- Loading resources from /home/zen/.sqliterc

CREATE TABLE foobar (
...


The 'Loading' part is on stderr which is OK, but still annoying.
However, that extra 2nd line is on stdout which is BAD.

I believe the culprit is `process_sqliterc()` when it calls `process_input()`
will keep a `stdin_is_interactive = 1` setting and `process_input()` thinking
it's reading from the user will emit a newline for some reason or another.

I did something like this to quash these annoying things:

static int process_sqliterc(
...
  int original_stdin_is_interactive = stdin_is_interactive;
...
  if( in ){
/* XXX ugh noisy
    if( stdin_is_interactive ){
      fprintf(stderr,"-- Loading resources from %s\n",sqliterc);
    }
*/
    stdin_is_interactive = 0;
    rc = process_input(p,in);
    stdin_is_interactive = original_stdin_is_interactive;
    fclose(in);
  }
...

I do think the spurious output to stdout is something that shouldn't happen.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to