Menu

#375 genrate_series and FQS

V1.0 maintenance
open
6
2013-01-22
2013-01-22
No

FQS seems not to handle generate_series() properly both in REL1_0_STABLE and master (as of Jan.22nd, 2013).

Following is the tests and their results:

REL1_0_STABLE ================================================

PGXC$ Psql
psql (PGXC 1.0.1, based on PG 9.1.7)
Type "help" for help.

koichi=# create table t1 (a int);
CREATE TABLE
koichi=# insert into t1 (a) values (generate_series(1,25));
ERROR: set-valued function called in context that cannot accept a set
koichi=# set enable_fast_query_shipping=false;
SET
koichi=# insert into t1 (a) values (generate_series(1,25));
INSERT 0 25
koichi=#

master (as of Jan.22nd, 2013) ====================================

PGXC$ Psql
psql (PGXC 1.1devel, based on PG 9.2beta2)
Type "help" for help.

koichi=# create table t1 ( a integer );
CREATE TABLE
koichi=# insert into t1 (a) values ( generate_series(1,25) );
ERROR: set-valued function called in context that cannot accept a set
koichi=# set enable_fast_query_shipping=false;
SET
koichi=# insert into t1 (a) values ( generate_series(1,25) );
INSERT 0 50
koichi=#

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.