| 493 | } |
| 494 | |
| 495 | func TestNowFunctionInDefaultExpression(t *testing.T) { |
| 496 | sql := "CREATE TABLE test (pk timestamp primary key default now())" |
| 497 | |
| 498 | statement, err := ParseDDL(sql, ParserModePostgres) |
| 499 | if err != nil { |
| 500 | t.Fatalf("failed to parse NOW() default expression: %v", err) |
| 501 | } |
| 502 | |
| 503 | got := String(statement) |
| 504 | if got != "create table test (\n\tpk timestamp default(now()) primary key\n)" { |
| 505 | t.Fatalf("unexpected normalized SQL:\n%s", got) |
| 506 | } |
| 507 | } |
| 508 | |
| 509 | // TestTypeKeywordsAsIndexColumns tests that type keywords (uuid, int, bigint, etc.) |
| 510 | // can be used as unquoted column names in index definitions |