oracle.user_tables bug

[Michael Cunningham]

This is my first post and if this is the wrong location to list a bug please let me know where I should post it.

The where clause is wrong for this view.

postgres=# \d+ oracle.user_tables

                                        View "oracle.user_tables"

   Column   |               Type                | Collation | Nullable | Default | Storage  | Description

------------+-----------------------------------+-----------+----------+---------+----------+-------------

 table_name | information_schema.sql_identifier |           |          |         | extended |

View definition:

 SELECT tables.table_name

   FROM information_schema.tables

  WHERE tables.table_type::text = 'BASE_TABLE'::text;

The text 'BASE_TABLE' includes an underscore and it should not be there.

The query should be:

 SELECT tables.table_name

   FROM information_schema.tables

  WHERE tables.table_type::text = 'BASE TABLE'::text;

[Pavel Stehule]

Hi

pá 7. 12. 2018 v 19:58 odesílatel Michael Cunningham <napacun...@gmail.com> napsal:

This is my first post and if this is the wrong location to list a bug please let me know where I should post it.

This is correct place

The where clause is wrong for this view.

postgres=# \d+ oracle.user_tables

                                        View "oracle.user_tables"

   Column   |               Type                | Collation | Nullable | Default | Storage  | Description

------------+-----------------------------------+-----------+----------+---------+----------+-------------

 table_name | information_schema.sql_identifier |           |          |         | extended |

View definition:

 SELECT tables.table_name

   FROM information_schema.tables

  WHERE tables.table_type::text = 'BASE_TABLE'::text;

The text 'BASE_TABLE' includes an underscore and it should not be there.

The query should be:

 SELECT tables.table_name

   FROM information_schema.tables

  WHERE tables.table_type::text = 'BASE TABLE'::text;

I fixed it in master, and released 3.7.1 with bugfix.

Thank you for report

Pavel

 

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To post to this group, send email to orafce-...@googlegroups.com.
Visit this group at https://groups.google.com/group/orafce-general.