Is this a question, feature request, or bug report?

Bug report

QUESTION

Have you checked our documentation at https://cockroachlabs.com/docs/stable/? If you could not find an answer there, please consider asking your question in our community forum at https://forum.cockroachlabs.com/, as it would benefit other members of our community.

yes

Prefer live chat? Message our engineers on our Gitter channel at https://gitter.im/cockroachdb/cockroach.

BUG REPORT

1. Please supply the header (i.e. the first few lines) of your most recent
   log file for each node in your cluster. On most unix-based systems
   running with defaults, this boils down to the output of

   grep -F '[config]' cockroach-data/logs/cockroach.log

   When log files are not available, supply the output of cockroach version
   and all flags/environment variables passed to cockroach start instead.

I170921 14:26:58.485800 1 util/log/clog.go:1013 [config] file created at: 2017/09/21 14:26:58
I170921 14:26:58.485800 1 util/log/clog.go:1013 [config] running on machine: jackburton
I170921 14:26:58.485800 1 util/log/clog.go:1013 [config] binary: CockroachDB CCL v1.0.5 (linux amd64, built 2017/08/24 17:43:46, go1.8.3)
I170921 14:26:58.485800 1 util/log/clog.go:1013 [config] arguments: [cockroach start --insecure --http-port 2800]

2. Please describe the issue you observed:

• What did you do?

Libraries
hibernate 5.2.8
postgresql 9.5.1212

Using Spring Data for JPA via Spring Boot 1.5.6
org.springframework.data.repository.CrudRepository.findOne

fails to find a existing row by serial number..

Hibernate log:

Hibernate: select group0_.id as id1_2_0_, group0_.description as descript2_2_0_, group0_.jhi_key as jhi_key3_2_0_, group0_.name as name4_2_0_ from jhi_group group0_ where group0_.id=?

Confirmed from the CLI that I was able to create the record through Spring Data was also able to do findAll through Spring Data however findOne and delete basically anything that used the ID directly was failing..

From the UI database

CREATE TABLE jhi_group (
id INT NOT NULL DEFAULT unique_rowid(),
jhi_key STRING(50) NOT NULL,
name STRING(50) NULL,
description STRING(255) NULL,
CONSTRAINT "primary" PRIMARY KEY (id ASC),
UNIQUE INDEX jhi_group_jhi_key_key (jhi_key ASC),
FAMILY "primary" (id, jhi_key, name, description)
)

My create table command.

CREATE TABLE IF NOT EXISTS usp.jhi_group (
    id          SERIAL PRIMARY KEY,
    jhi_key     VARCHAR (50) UNIQUE NOT NULL,
    name        VARCHAR(50),
    description VARCHAR(255)
)