in reply to Re^2: fetchall_arrayref hangs with placeholders query with no results
in thread fetchall_arrayref hangs with placeholders query with no results

I'd be worried if it didn't produce the same result.

I was surprised to read this in DBD::Sybase, might be your client lib:

>DBD::Sybase supports the use of ? placeholders in SQL statements as long as the underlying library and database engine supports it. It does this by using what Sybase calls Dynamic SQL. The ? placeholders allow you to write something like: ...
  • Comment on Re^3: fetchall_arrayref hangs with placeholders query with no results

Replies are listed 'Best First'.
Re^4: fetchall_arrayref hangs with placeholders query with no results
by Anonymous Monk on Apr 15, 2021 at 21:23 UTC
    When you use ? placeholders Sybase goes and creates a temporary stored procedure that corresponds to your SQL statement. You then pass variables to $sth->execute or $dbh->do, which get inserted in the query, and any rows are returned.

    So ... Sybase is obviously very different from the usual SQL standard ...
[reply]

In Section Seekers of Perl Wisdom