Bug #8671

Postgre:"select * into temp TABLE" is query SQL

Details

Submitted	2006-09-10 17:00 UTC
From	ceaty dot tsai at gmail dot com
Status	Duplicate
Package	DB
PHP Version	4.4.4
OS	FreeBSD 5.5
Roadmaps	(Not assigned)

Comments

[2006-09-10 17:00 UTC] ceaty dot tsai at gmail dot com

Description:
------------
"select * into temp TABLE" is a query sql in Postgre:
But used >= Version 1.7.0RC1, it will be return the 1(DB_OK);
I think maybe be inMainip(DB.php) this function...

Test script:
---------------
select user_id, name into temp foo1 from user where user_id='123';
select user_id,date,start_time,end_time into temp foo2 from work_time;
select * from foo1 AS a join foo2 AS b on a.user_id=b.user_id;
----

Expected result:
----------------
return data;
123, John, 2006-09-07, 09:15:00, 18:10:00
123, John, 2006-09-08, 09:20:00, 19:21:00

Actual result:
--------------
1 (DB_OK)