Movatterモバイル変換

Skip to content

postgrespro/vopsPublic

NotificationsYou must be signed in to change notification settings
Fork23
Star163

Commit9ecd5d2

knizhnik

committed

Change flags type in TPCH examples to scalar char

1 parent987071d commit9ecd5d2Copy full SHA for 9ecd5d2

File tree

2 files changed

+6

-6

lines changed

2 files changed

+6

-6

lines changed

`‎tpch.sql`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -9,8 +9,8 @@ create table lineitem(`
`9`	`9`	`l_extendedpricereal,`
`10`	`10`	`l_discountreal,`
`11`	`11`	`l_taxreal,`
`12`		`- l_returnflagchar,`
`13`		`- l_linestatuschar,`
	`12`	`+ l_returnflag"char",`
	`13`	`+ l_linestatus"char",`
`14`	`14`	`l_shipdatedate,`
`15`	`15`	`l_commitdatedate,`
`16`	`16`	`l_receiptdatedate,`

`‎tpch2.sql`

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -9,8 +9,8 @@ create table lineitem(`
`9`	`9`	`l_extendedpricereal,`
`10`	`10`	`l_discountreal,`
`11`	`11`	`l_taxreal,`
`12`		`- l_returnflagchar,`
`13`		`- l_linestatuschar,`
	`12`	`+ l_returnflag"char",`
	`13`	`+ l_linestatus"char",`
`14`	`14`	`l_shipdatedate,`
`15`	`15`	`l_commitdatedate,`
`16`	`16`	`l_receiptdatedate,`
`@@ -22,7 +22,7 @@ create table lineitem(`
`22`	`22`	`createtableorders(`
`23`	`23`	`o_orderkeyinteger,`
`24`	`24`	`o_custkeyinteger,`
`25`		`- o_orderstatuschar,`
	`25`	`+ o_orderstatus"char",`
`26`	`26`	`o_totalpricereal,`
`27`	`27`	`o_orderdatedate,`
`28`	`28`	`o_orderpriorityvarchar,`
`@@ -243,7 +243,7 @@ create table hlineitem(`
`243`	`243`	`createtablehorders(`
`244`	`244`	`o_orderkey int4,`
`245`	`245`	`o_custkey int4,`
`246`		`- o_orderstatuschar,`
	`246`	`+ o_orderstatus"char",`
`247`	`247`	`o_totalprice float4,`
`248`	`248`	`o_orderdatedate,`
`249`	`249`	`o_shippriority int4`

0 commit comments

Comments

(0)

[8]ページ先頭

©2009-2025 Movatter.jp