Message-ID: <gh-postgresql-interfaces-psqlodbc-79-c2586966737@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Mon, 13 Jan 2025 12:23:58 +0000
Subject: Re: [postgresql-interfaces/psqlodbc] issue #79: SQLSpecialColumns ODBC API does not return Columns part of UNIQUE INDEX on YugaByteDB
In-Reply-To: <gh-postgresql-interfaces-psqlodbc-79@github.com>
References: <gh-postgresql-interfaces-psqlodbc-79@github.com>
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 2586966737
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 79
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/79#issuecomment-2586966737
Content-Type: text/plain; charset=utf-8

@abhi-555 
In the Pull Request #85 I created a table testtab1 
```
CREATE TABLE test_special( id integer primary key, ival integer);
CREATE UNIQUE index test_special_ui on public.test_special(ival);
```
Then in the test you can see the output as:

```
Result set:
NULL	public	test_special	id	int4	int4	4	4	0	1
NULL	public	test_special	ival	int4	int4	4	4	0	1
```

Are you able to run the test on your end and see the same ?