Re: open2 or 3 run command using pty

your SQL Statement is

    select * from users
[download]

without a trailing semicolon, which means the SQL engine can't (yet) decide wether the statement is complete, or wether you want to go on with "WHERE whatever IS NULL" or so. Try

my $sql = "select * from users;";
[download]

Update: ... and you didn't close IN; before looping over OUT, so even if your SQL engine recognizes EOF as end of statement, it hasn't received it at that point.

Comment on Re: open2 or 3 run command using pty Select or Download Code

Replies are listed 'Best First'.
Re^2: open2 or 3 run command using pty by klimenkoandrey (Initiate) on Jul 21, 2014 at 11:33 UTC
The NitroDB SQL engine work without trailing semicolon. The first time i try with it. Yes in example i didn't close HANDLERS. Result the same with semicolons or without Close Handlers or not Now i close HANDLERS right after last sent command. Trouble in the "Inserting > sign" I can't even write output from the read to file (Insert >) Now will try to dig perl files from McAfee (maybe have part to communicate with DB)	[reply]

Replies are listed 'Best First'.

Re^2: open2 or 3 run command using pty
by klimenkoandrey (Initiate) on Jul 21, 2014 at 11:33 UTC

The NitroDB SQL engine work without trailing semicolon. The first time i try with it.

Yes in example i didn't close HANDLERS.

Result the same with semicolons or without Close Handlers or not

Now i close HANDLERS right after last sent command. Trouble in the "Inserting > sign" I can't even write output from the read to file (Insert >)

Now will try to dig perl files from McAfee (maybe have part to communicate with DB)

[reply]