Sorry, you appear to have found a bug which only gets activated with a WHERE clause used with a CREATE TABLE AS clause. I'll look into it. In the meantime, the workaround is to create and populate the table in separate steps, like this:

$dbh->do("
CREATE TABLE saninfo
  (IP TEXT, Manufacturer TEXT, Model TEXT, OS TEXT,
   OSSP TEXT, RAM TEXT, CPUSpeed INT, CPUCount INT,
   CPUType TEXT, SOFT TEXT)
");
my $select = $dbh->prepare("
    SELECT hostinfo.IP, Manufacturer, Model, OS, OSSP,
           RAM, CPUSpeed, CPUCount, CPUType, SOFT
      FROM hostinfo
      JOIN software ON hostinfo.IP = software.IP
     WHERE SOFT LIKE '%Secure Path%'
");
my $insert = $dbh->prepare("
    INSERT INTO saninfo VALUES(?.?.?.?.?.?.?.?.?.?)
");
$select->execute;
while (my @row = $select->fetchrow_array) {
    $insert->execute(@row);
}
[download]

This will have the same effect as the CREATE TABLE AS SELECT , but does it in separate steps.