hoaproject / database Goto Github PK

Is it possible to think about the name enclosing in SQL?
Mysql can use name
Oracle uses "name"
SQL Server handles names like [this]
...

A good topic :
http://stackoverflow.com/questions/10573922/what-does-the-sql-standard-say-about-usage-of-backtick

Please, see K-Phoen/php-sql-parser#1.

Thoughts?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

PDO fails to detect the type of the variable passed to a binded parameter. We need to use bindParam or bindValue to force the good parameter type.

We should handle these two methods in Hoa\Database.

MySql throw a SQL syntax error when using from alias on a Select request

#1064 - You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax 
to use near 'o WHERE o.OBJ_ID = '…' ' at line 1

with request : SELECT OBJ_ID FROM (OBJECTS) AS o WHERE o.OBJ_ID = '…'

Why add parenthesis on line 223 of Hoa\Database\Query\SelectCore ? It work without.

        $this->_from[$alias] = '(' . array_pop($this->_from) . ')';

I doesn't find examples with parenthesis on MySql and MsSql.

This is the syntax from mysql.com.
FROM tbl_name [[AS] alias]

I use MySql 5.5.

PS: there is no comma added between two FORM, this is because Hoa\Database is not finalized?

Hello,

I'm trying to use a Hoa\Database\Query\Select object in an INNER JOIN clause.

My goal is to get the following query:

SELECT *
FROM Foo AS F
INNER JOIN (
  SELECT *
  FROM Bar
) AS B
ON F.Foo_ID = B.Bar_ForeignKey

But I wasn't able to alias correctly my two sources.

• For the Foo table I can make an alias without the keyword AS like from('Foo F').
• The second alias is not well placed due to the ON clause (it's work well without).

There are my test code and the output.

$req = new \Hoa\Database\Query\Select();
$req->from('Foo')
    ->_as('F')
    ->innerJoin(
        (new \Hoa\Database\Query\Select())
            ->from('Bar')
    )
    ->on('F.Foo_ID = B.Bar_ForeignKey')
    ->_as('B');

SELECT *
FROM Foo
INNER JOIN (
  SELECT *
  FROM Bar
)
ON F.Foo_ID = B.Bar_ForeignKey
AS B

PS: Moreover the fact to don't alias an Hoa\Database\Query\Select object in an INNER JOIN clause throw a SQL error : #1248 - Every derived table must have its own alias.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Hello :-),

Since our recent features on having iterators over result set, we force PDO::CURSOR_SCROLL on an ATTR_CURSOR. With SQLite, it failed with a null error. It seems to be an error from PDO but we have to fix it anyway.

Any idea how?