Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

nodeIndexscan.c

  • Tom Lane's avatar
    1c5b9020
    Fix problem in which sloppily-coded test in ExecInitIndexScan would · 1c5b9020
    Tom Lane authored
    think that both sides of indexqual look like index keys.  An example is
    create table inside (f1 float8 primary key);
    create table outside (g1 float8, g2 float8);
    select * from inside,outside where f1 = atan2(g1+1, g2);
    ERROR:  ExecInitIndexScan: both left and right ops are rel-vars
    (note that failure is potentially platform-dependent).  Solution is a
    cleanup I had had in mind to make anyway: functional index keys should
    be represented as Var nodes in the fixed indexqual, just like regular
    index keys.
    1c5b9020
    History
    Fix problem in which sloppily-coded test in ExecInitIndexScan would
    Tom Lane authored
    think that both sides of indexqual look like index keys.  An example is
    create table inside (f1 float8 primary key);
    create table outside (g1 float8, g2 float8);
    select * from inside,outside where f1 = atan2(g1+1, g2);
    ERROR:  ExecInitIndexScan: both left and right ops are rel-vars
    (note that failure is potentially platform-dependent).  Solution is a
    cleanup I had had in mind to make anyway: functional index keys should
    be represented as Var nodes in the fixed indexqual, just like regular
    index keys.